Welcome Guest. Please Login or Register  


You are here: Index > Softaculous Auto Installer > General Support > Topic : Error establishing a database connection using Php fpm chroot in ISPConfig via Softaculous



Normal Mode | Print  

 Error establishing a database connection using Php fpm chroot in ISPConfig via Softaculous (6 Replies, Read 4453 times)
EuroDomenii
Group: Member
Post Group: Newbie
Posts: 15
Status:
Softaculous generates wp-config.php with localhost:3306, which causes PHP to attempt a connection to a unix socket rather than over TCP/IP. The unix socket file does not exist in the chroot, so the database connection fails.

A similar issue is in “APS installer in chrooted PHP-FPM: database connection problems” https://git.ispconfig.org/ispconfig/ispconfig3/issues/5235, fixed with  https://git.ispconfig.org/ispconfig/ispconfig3/-/merge_requests/879/diffs . Since Softaculous php files are encrypted, I can’t hack in.

Trying to change $conf['db_host'] = '127.0.0.1'; in /usr/local/ispconfig/server/lib/config.inc.php
And /usr/local/ispconfig/interface/lib/config.inc.php doesn’t help either.

BTW, when creating the website, where does softaculous gets his information about the database? From mysql_clientdb_plugin.inc.php? Maybe we could also hack some ispconfig plugins.

A related issue is https://www.softaculous.com/board/index.php?tid=16135&title=ispconfig “Yes you can use an external MySQL server. You need to set that server as default MySQL server and then Softaculous will create databases on the remote server.”  The difference is that I have to trigger 127.0.0.1, instead of localhost, for default local server.

Using [client] protocol=tcp in my.cnf won’t help ( via https://serverfault.com/questions/337818/how-to-force-mysql-to-connect-by-tcp-instead-of-a-unix-socket)

Thanks!
IP: --   


Threads
 EuroDomenii   Error establishing a database connection using Php fpm chroot in ISPConfig via Softaculous (6 Replies, Read 4453 times)
    |--  Brijesh   Hi, You can...   on April 24, 2020, 7:37 am
    |--  EuroDomenii   Hi, You can...   on April 24, 2020, 8:29 am
    |--  Brijesh   Hi, We have...   on April 27, 2020, 1:01 pm
    |--  bhavana   Hi, We have...   on May 22, 2020, 5:52 am
    |--  EuroDomenii   Thanks for including...   on May 22, 2020, 12:45 pm
    |--  Brijesh   Hi, Glad to...   on May 25, 2020, 6:49 am

« Previous    Next »

Normal Mode | Print  



Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 27, 2024, 9:08 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.187