LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CentOS
User Name
Password
CentOS This forum is for the discussion of CentOS Linux. Note: This forum does not have any official participation.

Notices


Reply
  Search this Thread
Old 09-14-2022, 03:07 PM   #1
Patriboom
LQ Newbie
 
Registered: Feb 2019
Posts: 7

Rep: Reputation: Disabled
Wink 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/
 
Old 09-14-2022, 04:07 PM   #2
boughtonp
Senior Member
 
Registered: Feb 2007
Location: UK
Distribution: Debian
Posts: 3,616

Rep: Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554
Quote:
Originally Posted by Patriboom View Post
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?

 
1 members found this post helpful.
Old 09-14-2022, 04:54 PM   #3
michaelk
Moderator
 
Registered: Aug 2002
Posts: 25,740

Rep: Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923
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/
 
Old 10-05-2022, 12:58 PM   #4
Patriboom
LQ Newbie
 
Registered: Feb 2019
Posts: 7

Original Poster
Rep: Reputation: Disabled
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.
 
Old 10-05-2022, 01:25 PM   #5
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,666

Rep: Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970
Quote:
Originally Posted by Patriboom View Post
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.
 
Old 10-05-2022, 01:51 PM   #6
Patriboom
LQ Newbie
 
Registered: Feb 2019
Posts: 7

Original Poster
Rep: Reputation: Disabled
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.
 
Old 10-05-2022, 02:04 PM   #7
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,666

Rep: Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970
Quote:
Originally Posted by Patriboom View Post
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:
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.
 
Old 10-05-2022, 02:46 PM   #8
Patriboom
LQ Newbie
 
Registered: Feb 2019
Posts: 7

Original Poster
Rep: Reputation: Disabled
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.
 
Old 10-05-2022, 03:22 PM   #9
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,666

Rep: Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970Reputation: 7970
Quote:
Originally Posted by Patriboom View Post
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:
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??
 
Old 10-05-2022, 04:59 PM   #10
Patriboom
LQ Newbie
 
Registered: Feb 2019
Posts: 7

Original Poster
Rep: Reputation: Disabled
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.
 
Old 10-05-2022, 05:24 PM   #11
michaelk
Moderator
 
Registered: Aug 2002
Posts: 25,740

Rep: Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923Reputation: 5923
You can post PHP code just not the actual PHP tags.
 
Old 10-05-2022, 07:38 PM   #12
Patriboom
LQ Newbie
 
Registered: Feb 2019
Posts: 7

Original Poster
Rep: Reputation: Disabled
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
 
Old 10-06-2022, 08:42 AM   #13
boughtonp
Senior Member
 
Registered: Feb 2007
Location: UK
Distribution: Debian
Posts: 3,616

Rep: Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554Reputation: 2554
Quote:
Originally Posted by Patriboom View Post
Ok, I'll try again the code, but - again - this code works perfectly under wichever other server than CentOs
Quote:
Originally Posted by Patriboom View Post
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 View Post
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.


 
  


Reply

Tags
bugs, centos, php-7, testing



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Adobe AIR on Linux: Pre-Beta Testers Needed LXer Syndicated Linux News 0 02-21-2008 12:30 AM
Software Wattmeter: Testers needed! nosrednaekim Linux - Laptop and Netbook 2 12-13-2006 03:18 PM
Beta Testers Needed msound General 18 07-28-2006 10:22 AM
Synaptic Testers Needed chris319 Debian 0 08-13-2003 11:04 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > CentOS

All times are GMT -5. The time now is 01:46 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration