LinuxQuestions.org - Testers needed

- CentOS (https://www.linuxquestions.org/questions/centos-111/)

- - Testers needed (https://www.linuxquestions.org/questions/centos-111/testers-needed-4175716749/)

Patriboom

09-14-2022 03:07 PM

Testers needed

Hello all,

I'm the main developper for a Ticket system called « BUGS »
I did sumbit to SoftCoolous and it is available there since years, but the new version seems to have a bug with Centos.

I've tested BUGS under Debian and Windows ( XAMPP ) with apache2 and PHP 7.4 / PHP 8.1 everything is good. So what the problem with Centos ???? I'm unable to find out.

So please, help me. You may have to pass through the only install process, you may have to go further, you may decide to adopt the BUGS system for yourself ... You'll see.

Already thanks for your support and help.

BUGS is available for free from
https://github.com/pixeline/bugs/

boughtonp

09-14-2022 04:07 PM

Quote:

Originally Posted by Patriboom (Post 6380178)

the new version seems to have a bug with Centos.

...

So what the problem with Centos ???? I'm unable to find out.

Which specific version of CentOS? How do you know there's a bug?

Your readme claims "PHP 7.3 and lower are no longer supported" which essentially means you're not supporting CentOS.

What's stopping you from running a VM to test it yourself?

michaelk

09-14-2022 04:54 PM

The initial version installed in CentOS 7 is 5.4 but can be upgraded via the epel repository to 8.2.
My first guess would be a selinux problem if you specifically have not configured it for your application or maybe disabled it.

https://www.linode.com/docs/guides/a...x-on-centos-7/

Patriboom

10-05-2022 12:58 PM

So ... is there anyone who accepts to test my system ?
I could do it myself, as said up here but I'll probably do the same as usually and not find the bug. I need someone totally new front of this install process.

Thanks.

TB0ne

10-05-2022 01:25 PM

Quote:

Originally Posted by Patriboom (Post 6380178)

Hello all,
I'm the main developper for a Ticket system called «BUGS» I did sumbit to SoftCoolous and it is available there since years, but the new version seems to have a bug with Centos.

I've tested BUGS under Debian and Windows ( XAMPP ) with apache2 and PHP 7.4 / PHP 8.1 everything is good. So what the problem with Centos ???? I'm unable to find out. So please, help me. You may have to pass through the only install process, you may have to go further, you may decide to adopt the BUGS system for yourself ... You'll see.

Sounds very odd to me. You say you're the main developer, and that there is a 'bug with Centos'...but you don't actually TELL US what the bug is, or what's been reported???

Since you claim there's a problem, document what has been reported here, so others can see if it can be duplicated. Otherwise, this just sounds like you want to 'advertise' your software.

Patriboom

10-05-2022 01:51 PM

I did not expect such reaction. I don't want to advertise my BUGS system.
I'm in touch with Softacolous who follows the progress of the system for themselves and their clients.
Softacolous guy came back saying that the bug he encounter is the following:
- install process block with « No such table created in database ».
I've tested under Windows, under Linux with differents versions of PHP: still unable to reproduce the reported bug.
That why I'm asking someone else to test. I guess that I'm not doing like a new user and I'm passing around the problem even when I don't try to so.
Developping BUGS stated only for myself, from an existing canevas. Some users did like it ... good but nothing more. I really don't care to advertising or not the system it is there on github. Take it if you want, don't take .. it's free. I don't even have any idea of how many users are using it. I don't care. So I've been surprised by you point of view (advertising). My only concern is: it must work for everyone as it is for me. Softacolous guy said me that he tested and had problem with it under CentOs that why I post here. It is that simple. Under github, it's not even my name, my account that shows but pixeline/bugs

Thanks.

TB0ne

10-05-2022 02:04 PM

Quote:

Originally Posted by Patriboom (Post 6384518)

Code:

- install process block with « No such table created in database ».

I've tested under Windows, under Linux with differents versions of PHP: still unable to reproduce the reported bug. That why I'm asking someone else to test. I guess that I'm not doing like a new user and I'm passing around the problem even when I don't try to so. Developping BUGS stated only for myself, from an existing canevas. Some users did like it ... good but nothing more. I really don't care to advertising or not the system it is there on github. Take it if you want, don't take .. it's free. I don't even have any idea of how many users are using it. I don't care. So I've been surprised by you point of view (advertising). My only concern is: it must work for everyone as it is for me. Softacolous guy said me that he tested and had problem with it under CentOs that why I post here. It is that simple. Under github, it's not even my name, my account that shows but pixeline/bugs

Well, when you post about a problem (and don't say what it actually is), then say things like we may decide to 'adopt it' ourselves, certainly reads like it might be. We only know what you tell us.

And is that the EXACT error? Because I don't find that syntax anywhere in any of the files I downloaded. If I had to debug this app, I'd search the source code for that error message, and look at what can trigger it.

Patriboom

10-05-2022 02:46 PM

You're right, this message doesn't show in any file. That's why I have so hard time to debug it. The message is from the MyAdmin or from MySQL engine. The only user who had such problem is a CentOs user. As said up, I've thoroughly tested under Debian and PHP 7.4, 8.0,8.1 MySQL with PHPmyAdmin or with Adminer; also under Windows.

Here is the quote that user sent me:

Quote:

We were in the process of manual installation of Bugs 1.9_1d on Centos7 with Apache 2.2, PHP 7.4, MYSQL 5.5.

However we face the following issue :

On entering the db details and clicking 'Install' we get the following warning :

Warning: Invalid argument supplied for foreach() in /{{PATH}}/{{TO}}/{{BUGS}}/install/config-setup.php on line 105

Also After entering admin details we are not redirected to admin login page , we are redirected to the install URL i.e :

http://{{URL}}/{{TO}}/{{BUGS}}/install/index.php?Lng=en

And following is the screenshot of the same :

Also when i visit the login page manually via URL i.e

http://{{URL}}/{{TO}}/{{BUGS}}/login the login page is loaded fine, and however after entering the login details the following error is thrown i.e :

Unhandled Exception
Message:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bugs191d.users' doesn't exist

SQL: SELECT * FROM `users` WHERE (`email` = ?) LIMIT 1

Bindings: array (
* 0 => '{{ADMIN_EMAIL}}',
)

Location:

/{{PATH}}/{{TO}}/{{BUGS}}/laravel/database/connection.php on line 238

All this can be explained by failure on data tables creation.
That why I need tester on CentOs: any other OS seams to not encounter such problems.

TB0ne

10-05-2022 03:22 PM

Quote:

Originally Posted by Patriboom (Post 6384530)

Code:

We were in the process of manual installation of Bugs 1.9_1d on Centos7 with Apache 2.2, PHP 7.4, MYSQL 5.5. However we face the following issue :



On entering the db details and clicking 'Install' we get the following warning :

Warning: Invalid argument supplied for foreach() in /{{PATH}}/{{TO}}/{{BUGS}}/install/config-setup.php on line 105



Also After entering admin details we are not redirected to admin login page , we are redirected to the install URL i.e :

http://{{URL}}/{{TO}}/{{BUGS}}/install/index.php?Lng=en



And following is the screenshot of the same :

Also when i visit the login page manually via URL i.e

http://{{URL}}/{{TO}}/{{BUGS}}/login the login page is loaded fine, and however after entering the login details the following error is thrown i.e :



Unhandled Exception Message:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bugs191d.users' doesn't exist



SQL: SELECT * FROM `users` WHERE (`email` = ?) LIMIT 1

Bindings: array (

* 0 => '{{ADMIN_EMAIL}}',

)

Location:

/{{PATH}}/{{TO}}/{{BUGS}}/laravel/database/connection.php on line 238

All this can be explained by failure on data tables creation. That why I need tester on CentOs: any other OS seams to not encounter such problems.

Bolded two lines above; have you looked at the line referenced there? It's telling you line 105, and seems to center around the lack of the users table. Have you looked at what/how the users table gets created?

Also, this doesn't sound like a 'bug' at all...the user in question says they're doing a manual installation, rather than going through things? Are you *SURE* they're following the instructions??

Patriboom

10-05-2022 04:59 PM

Thanks for that.
The system is supposed to installs itself.

The part the user did manually could not work because the previous step was the one which installs the database and its tables.
So the problem encountered by the user is all about the database deployment (its table). Which I never encountered under Debian nor windows. I asked him if the commands « scandir et get_contents » are available on his PHP and he said they are. Such is his answer:

Quote:

scandir() and file_get_contents() , those functions work fine on my server without any issues.

So, facing that, the install code goes like that:
It seams that I'm not allowed to post PHP code here. So please refer to ./install/config-setup.php file from the github deposite.

Again, the only user with such problem, is a CentOs user.

Thanks for your help.

michaelk

10-05-2022 05:24 PM

You can post PHP code just not the actual PHP tags.

Patriboom

10-05-2022 07:38 PM

Ok, I'll try again the code, but - again - this code works perfectly under wichever other server than CentOs

PHP code could not pass through - twice

The returned message is:

Quote:

Sorry, you have been blocked
You are unable to access linuxquestions.org

boughtonp

10-06-2022 08:42 AM

Quote:

Originally Posted by Patriboom (Post 6384585)

Ok, I'll try again the code, but - again - this code works perfectly under wichever other server than CentOs

Quote:

Originally Posted by Patriboom (Post 6384530)

As said up, I've thoroughly tested under Debian and PHP 7.4, 8.0,8.1 MySQL with PHPmyAdmin or with Adminer

Thoroughly?

So you've got comprehensive automated tests that you've ran against all THIRTY TWO releases of PHP 7.4?

Your issue is not CentOS.

It may be security software like SELinux/similar, but it's probably either a bug in your code and/or in the specific combination of versions of software being used.

Quote:

PHP code could not pass through - twice

The returned message is:

Quote:

Sorry, you have been blocked
You are unable to access linuxquestions.org

This is because LQ uses CloudFlare filters, which blocks arbitrary snippets of code, for no good reason.

It's similar to checking for the presence of a "<" or the word "script" and blindly unsetting variables, instead of doing proper validation/handling of user input.

The options are to figure out what the filter is and bypass it (a trivial though tedious process), or supply the code as an .txt attachment, or (given a repository already exists) supply a direct link to the correct version.

Quote:

Originally Posted by Patriboom (Post 6384518)

My only concern is: it must work for everyone as it is for me.

If that is your concern, ask your Softaculous contact for the exact versions of all software involved, and install them in a local VM so you can debug the issue directly.

All times are GMT -5. The time now is 11:58 AM.