- Server operating system version
- Ubuntu 22.04.2 LTS
- Plesk version and microupdate number
- Plesk 18.0.50
Did an upgrade of our server from Ubuntu 20.x to 22.x
Afterwards, all site work fine when connecting to the mariadb database except one.
In fact two seperate sites use the same database. One can connects to the the database using the same credentials and works as it did before. However the other site gives
Warning: mysqli_connect(): (HY000/2002): Connection refused in /path/to/my/connection_script.php
I've double checked that the user/pass are still being correctly loaded in the problem site but no joy.
Is there some possible 'jail' that has been activated that is cause MariaDB to reject that mysqli_connect() from one domain but not from another domain?? (Both domains are on the same server.) Prior to upgrade we did extensive testing of the migration from Ubuntu 20 to Ubuntu 22 on our DEV server which duplicates the Plesk setup of our live server and everything worked fine there. (and has for the many weeks since we moved DEV to 22)
We have several sites that use the same connection_script.php like:
Where 'site1' happily connects to the database as before, but 'site2' throws the error. the 'connection_script.php' code and credentials are identical on each site
On the problem site I can also shell into that particular domain and connect successfully to the database in question using the same credentials.
All I can think is that somebody hit our PROD server scripts during the transition and possibly triped some 'failed login bans' but I don't see anything in IP Address Banning for the fail2ban jails (we had previously white listed all of our IP addresses associated with the server, so it shouldn't be catching them anyways??)
The sites in question are on PHP 7.4. We were in the process of upgrading toe PHP 8.2 so I tried an emergency move to PHP 8.2, but got the same connection error on the site in question.
Any help would be greatly appreciated.
Afterwards, all site work fine when connecting to the mariadb database except one.
In fact two seperate sites use the same database. One can connects to the the database using the same credentials and works as it did before. However the other site gives
Warning: mysqli_connect(): (HY000/2002): Connection refused in /path/to/my/connection_script.php
I've double checked that the user/pass are still being correctly loaded in the problem site but no joy.
Is there some possible 'jail' that has been activated that is cause MariaDB to reject that mysqli_connect() from one domain but not from another domain?? (Both domains are on the same server.) Prior to upgrade we did extensive testing of the migration from Ubuntu 20 to Ubuntu 22 on our DEV server which duplicates the Plesk setup of our live server and everything worked fine there. (and has for the many weeks since we moved DEV to 22)
We have several sites that use the same connection_script.php like:
/mnt/vhosts1/path/to/connection_script.php
/mnt/vhosts2/path/to/connection_script.php
Where 'site1' happily connects to the database as before, but 'site2' throws the error. the 'connection_script.php' code and credentials are identical on each site
On the problem site I can also shell into that particular domain and connect successfully to the database in question using the same credentials.
All I can think is that somebody hit our PROD server scripts during the transition and possibly triped some 'failed login bans' but I don't see anything in IP Address Banning for the fail2ban jails (we had previously white listed all of our IP addresses associated with the server, so it shouldn't be catching them anyways??)
The sites in question are on PHP 7.4. We were in the process of upgrading toe PHP 8.2 so I tried an emergency move to PHP 8.2, but got the same connection error on the site in question.
Any help would be greatly appreciated.