This morning When we run mailscanner web. https://efa.domain.com we recieve an error:
Error: Database connection failed
It is possible that the database is overloaded or otherwise not running properly
Contact the system administrator if the problem persists
My version is 3.0.2.3
and when i try to restart mailscanner , i have this :
Code: Select all
Restarting MailScanner ...
Could not use Custom Function code MailScanner::CustomConfig::InitSQLBlacklist, it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/share/MailScanner/perl/custom/SQLBlackWhiteList.pm line 164.
) at /usr/share/MailScanner/perl/MailScanner/Config.pm line 1053
Could not use Custom Function code MailScanner::CustomConfig::InitSQLWhitelist, it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBI connect('database=mailscanner;host=localhost','mailwatch',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at /usr/share/MailScanner/perl/custom/SQLSpamSettings.pm line 69
) at /usr/share/MailScanner/perl/MailScanner/Config.pm line 1053
and when i try to restart mysql :
Code: Select all
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
. SUCCESS!
Code: Select all
[Wed Nov 22 11:05:52 2017] [error] [client ] PHP Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'Unknown column 'released' in 'field list'' in /var/www/html/mailscanner/functions.php:975\nStack trace:\n#0 /var/www/html/mailscanner/functions.php(975): mysqli->query('?SELECT? id AS ...')\n#1 /var/www/html/mailscanner/functions.php(1998): dbquery('?SELECT? id AS ...')\n#2 /var/www/html/mailscanner/status.php(81): db_colorised_table('?SELECT? id AS ...', 'last 50 mes...')\n#3 {main}\n thrown in /var/www/html/mailscanner/functions.php on line 975, referer: http://ip_address/mailscanner/quarantine.php
Any help would be more then appreticiated.
With best regards