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
Surely your mysql server does not allow remote connections.
Check mysql log files for more info.
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
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.
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.
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