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?

Need to change localhost to 127.0.0.1

lacroix

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?

aaPanel_Jose

lacroix

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

lacroix

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.

lacroix

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?

aaPanel_Jose

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

lacroix

aaPanel_Jose

i am using centos 8 from vultr

aaPanel_Jose

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

neotheghost

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?

aaPanel_Jose

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

neotheghost

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.

aaPanel_Jose

neotheghost
Thank you for your feedback, we will check it

Also, what is the version of php you installed

neotheghost

aaPanel_Jose PHP 7.4.12. But when i tried switching to 7.3 to avoid this problem, i noticed it existed also in 7.3.

neotheghost

Problem still exists with PHP 7.4.13 & OpenLiteSpeed 1.6.18 on CentOS 8.2.2004.

DimmmCom

I confirm. This issue is present on Ubuntu 20.04, Openlitespeed. Tested on PHP 8.0, 7.4, 7.3.
And 100% appears when changing parameters through this setting.

aaPanel_Jose

This problem will be fixed after click the Fix button

tores54

aaPanel_Jose The problem still exists, the fixit button does not help.
Only reinstalling php helps. But as soon as I change the config everything breaks again

deewinc

tores54 The problem still exists, the fixit button does not help.
Only reinstalling php helps. But as soon as I change the config everything breaks again

Did you find a fix for this problem?

deewinc

@aaPanel_Jose ~ can you investigate this issue please? I'm getting the error on a clean installation.

https://www.aapanel.com/forum/d/5570-wordpress-fails-to-complete-installation-database-error

urusweb

I just installed OpenLiteSpeed + Mysql + PHP7.4
Then I added the website and downloaded the backup file from the old server via wget.

But when downloading, why is the IP localhost (127.0.0.1)? So I can't download the file.

Connecting to urldomain.com (urldomain.com)|127.0.1.1|:443... failed: Connection refused.

Please help
Note: I have not directed the IP to this new server.

aaPanel_Kern

urusweb
Hello, please check the A record resolution of your domain name, and also check whether the relevant records are specified in the /etc/hosts file.