phpMyAdmin - Error  [SOLVED]

Locked
Nikitaidis
Posts: 44
Joined: Sun 28. Apr 2019, 13:59

phpMyAdmin - Error

Post by Nikitaidis »

How can fix MySQL error :

Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.
session_start(): open(SESSION_FILE, O_RDWR) failed: No such file or directory (2)
session_start(): Failed to read session data: files (path: /tmp/keyhelp/)

MySQL - Connection Error: 2002 (No such file or directory).

Thank you
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: phpMyAdmin - Error

Post by Alexander »

Hello,

shortly after reboot, this is normal behaviour, as /tmp/keyhelp/ directory does not exist yet. 1 Minute after reboot, the directory will be created by the KeyHelp master-cronjob.
Feel free to create this directory on your own, if you do not want to wait: /tmp/keyhelp/ with 0777 permissions.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Nikitaidis
Posts: 44
Joined: Sun 28. Apr 2019, 13:59

Re: phpMyAdmin - Error

Post by Nikitaidis »

Thank you for your answer... still show error.
Screenshot 2021-12-14 at 15.37.49.png
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: phpMyAdmin - Error

Post by Alexander »

What have you done before? What changes have you performed on your server?

You may want to check /home/keyhelp/www/phpmyadmin/config.inc.php
and try changing the 'host' value to '127.0.0.1'
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Nikitaidis
Posts: 44
Joined: Sun 28. Apr 2019, 13:59

Re: phpMyAdmin - Error

Post by Nikitaidis »

I add 'host' => '127.0.0.1', but still show same error.
Last edited by Nikitaidis on Tue 14. Dec 2021, 19:40, edited 2 times in total.
User avatar
Florian
Keyweb AG
Posts: 1243
Joined: Wed 20. Jan 2016, 02:28

Re: phpMyAdmin - Error

Post by Florian »

Hallo,

check /var/log/syslog why MariaDB is not starting. Also check that your HDD is not completely occupied.
Mit freundlichen Grüßen / Best regards
Florian Cheno

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Nikitaidis
Posts: 44
Joined: Sun 28. Apr 2019, 13:59

Re: phpMyAdmin - Error

Post by Nikitaidis »

query (cache) './A/IN' denied
Dec 14 06:26:15 host postfix/smtpd[345522]: connect from lax01.xitoring.com[107.167.244.30]
Dec 14 06:26:16 host postfix/smtpd[345522]: disconnect from lax01.xitoring.com[107.167.244.30] ehlo=1 quit=1 commands=2
Dec 14 06:26:54 host named[401]: client @0x7f24e0037e40 198.203.28.254#52131 (.): query (cache) './A/IN' denied
Dec 14 06:27:00 host postfix/smtpd[345522]: connect from jax01.xitoring.com[198.203.28.254]
Dec 14 06:27:01 host postfix/smtpd[345522]: disconnect from jax01.xitoring.com[198.203.28.254] ehlo=1 quit=1 commands=2
Dec 14 06:27:01 host CRON[348142]: (root) CMD (nice -n 5 php /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php)
Last edited by Nikitaidis on Tue 14. Dec 2021, 19:40, edited 1 time in total.
User avatar
Florian
Keyweb AG
Posts: 1243
Joined: Wed 20. Jan 2016, 02:28

Re: phpMyAdmin - Error

Post by Florian »

Hallo,

these are only entries from other services.

Try to restart the database server and then immediately check the log.

Also check if something is logged into /var/log/mysql/error.log
Mit freundlichen Grüßen / Best regards
Florian Cheno

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Nikitaidis
Posts: 44
Joined: Sun 28. Apr 2019, 13:59

Re: phpMyAdmin - Error  [SOLVED]

Post by Nikitaidis »

Ok thank you
Locked