View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Projeqtor v 11.0.2 installation failing to connect to database - ProjeQtOr
 

[SOLVED] Projeqtor v 11.0.2 installation failing to connect to database

More
28 Nov 2023 05:29 #1 by Dave42
Installation failing on Debian 12.2 apache2 php8.2 
The error code is SQLSTATE[HY000] [2002] Connection timed out
The CLI allows me to connect using  mysql -hx.x.x.x -uxxxx -pxxxx database_name from host server
The webhost does not have mysql or mariadb server installed locally an other database server is being used on same subnet the webhost does have a mysql client installed as well as php82-mysql
verified that webhost is able to query database from cli but from install php script unable to connect

please advise how to correct

addition info if helpfull the install system check list is as follows
PHP version is 8.2.7 : OK
Module PDO is available : OK
Module PDO for 'MYSQL' is available : OK
Module MBSTRING is available : OK
Class ZipArchive is available : OK
Module DOMDocument is available : OK
GD Library is available and correctly installed : OK
Module IMAP is available : OK
Module OPENSSL is available : OK
Module XML is available : OK
max_input_vars=4000 : OK
max_execution_time=30 : OK
memory_limit=1000G : OK
file_uploads=1 : OK
session.auto_start is disabled : OK
register_globals is disabled : OK
SQLSTATE[HY000] [2002] Connection timed out

Please Log in or Create an account to join the conversation.

More
28 Nov 2023 14:08 #2 by babynus
Surely your mysql server does not allow remote connections.
Check mysql log files for more info.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
28 Nov 2023 15:06 #3 by Dave42
verified that webhost is able to query database from cli but from install php script unable to connect

As I stated connectivity was verified that connection was allowed from the webserver CLI I will be investigating further today in theory it may be an issue within the PDO or mysql db connect of projeqtor or a path issue for the mysql client that is some how different than mysql server path on localhost. I noticed that several other project from other development teams are having similar issues related to having no mysql server installed on webhost.
Our servers are specifically designed for task rather than general use they exist as clusters the DB cluster uses more than 48 E5-2697 xeon cores while the webhost cluster has 40of same processors and 16 10G over copper network ports DB cluster is a HPC while WEBhost cluster is Hi availability.
These are not LAMP installs

Please Log in or Create an account to join the conversation.

More
28 Nov 2023 17:57 #4 by babynus
I am still sure it is a specific configuration of your MySql server that blocks the connection.
Please check mysql log files for more info.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
29 Nov 2023 03:46 #5 by Dave42
Actually it is an issue with PHP unable to execute system commands will solve myself and post actual solution. Multiple machines on network are using database server concurrently with credentials used during install only this particular server cluster is having difficulty with any system calls from php.

Please Log in or Create an account to join the conversation.

More
02 Dec 2023 23:47 - 02 Dec 2023 23:51 #6 by Dave42
Completely off base and wrong direction NO THERE WAS NO PERMISSIONS ERRORS INVOLVED

THE ACTUAL ISSUE WAS A DEFAULT SETTING IN THE APACHE2 CONFIGURATION FILE FOR PHP-FPM8.2
found on debian at /etc/php/8.2/apache2/php.ini line number 883
default install reads default_socket_timeout = 0
should read default _socket_timeout = 60
once corrected all functions work as intended .

Again as I stated multiple instances of other servers in cluster were having no issues connecting meaning there was NO permissions issue.
Often the short cut or most common answer leads folks in wrong direction completely 
Last edit: 02 Dec 2023 23:51 by Dave42. Reason: misspelling

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.051 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.