For some reason i got "mysqli_real_connect(): (HY000/2002): No such file or directory" when trying to login in phpmyadmin. Also I got error "Error Establishing a Database Connection" in my wordpress. This is my first time using aaPanel. I am migrating website from other panel that use nginx, and in this panel i am using aaPanel with openLiteSpeed. This is what i do to fix it = fixing phpmyadmin config.inc.php in phpmyadmin folder, changing $cfg['Servers'][$i]['host'] = 'localhost'; to $cfg['Servers'][$i]['host'] = '127.0.0.1'; fixing wordpress wp-config.php in wordpress folder, changing define( 'DB_HOST', 'localhost' ); to define( 'DB_HOST', '127.0.0.1' ); what i install in my aaPanel = openLiteSpeed 1.6.15 php 7.4 with opcache and redis extension mariadb 10.4.12 dns manager 3.3 fail2ban 1.7 pure-ftpd 1.0.49 phpmyadmin 5.0 redis 6.0.8 What i want to ask, is this normal for "localhost" to not be recognized? And is it mandatory to change "localhost" to "127.0.0.1" ? Is what i doing here just some workaround, or there are permanent fix somewhere?

lacroix Please check if the two parameter values of your PHP are /tmp/mysql.sock

aaPanel_Jose I forgot to write, another thing I edit in php7.4 is the session configuration. I change it from the default "files" to "redis". I don't know if that has any relationship with this problem though. I am just trying to recall whatever i change manually. And now replying yo your confirmation, And what i found is that 2 parameter is empty... after filling the parameter with /tmp/mysql.sock as the same with your image, the "localhost" parameter is now working in phpmyadmin and wordpress. I don't know why that 2 parameter is empty in that vps. When I install another aaPanel just few hours ago in different vps, the "localhost" in phpmyadmin is working. The only difference is I install nginx in there, not openlitespeed. Everything else (installation and configuration) is the same. Thank you for the help.

aaPanel_Jose Today after i restart my php7.4, that 2 parameter is now empty again. Is it bug? Or is there another fix so that parameter will not reset again to empty after php restart?

lacroix could you tell me what operating system are you using? Let me check

aaPanel_Jose i am using centos 8 from vultr

lacroix Thanks for your information, we will check as soon as possible

This error exists in any OS in combination with OpenLiteSpeed. Whenever you change any values in the PHP configuration tab the PHP config looses the path to mysql.sock in the following lines: pdo_mysql.default_socket = /tmp/mysql.sock mysqli.default_socket = /tmp/mysql.sock This config error causes a lot of trouble. @aaPanel_Jose can you please fix this?

neotheghost This problem has been fixed. I installed a few servers and it did not appear. Do you still encounter it?

Yes. Newly installed Server based on Ubuntu 20.04 and newly Installed Server based on CentOS 8.2.2004 On both systems the php config file is missing the path to mysql.sock. as soon as you change any value in the settings.

neotheghost Thank you for your feedback, we will check it Also, what is the version of php you installed

Need to change localhost to 127.0.0.1

aaP_khosrojerdi_hadi

for me changing /tmp/mysql.sock for pdo_mysql.default_socket and mysqli.default_socket worked. please make sure you change mysql.sock not mysqld.sock and then restart mysql, php, openlitespeed.

pdo_mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

« Previous Page