Page 1 of 1

phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 15:11
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

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 15:18
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.

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 15:42
by Nikitaidis
Thank you for your answer... still show error.
Screenshot 2021-12-14 at 15.37.49.png

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 16:14
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'

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 16:31
by Nikitaidis
I add 'host' => '127.0.0.1', but still show same error.

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 18:01
by Florian
Hallo,

check /var/log/syslog why MariaDB is not starting. Also check that your HDD is not completely occupied.

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 18:26
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)

Re: phpMyAdmin - Error

Posted: Tue 14. Dec 2021, 19:19
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

Re: phpMyAdmin - Error  [SOLVED]

Posted: Tue 14. Dec 2021, 19:39
by Nikitaidis
Ok thank you