Host xxx.xxx.xxx.xxx is not allowed to connect to this MariaDB server

Hi, this morning we have got a power trip and we on the mail server (Done from The Perfect Server - Debian 8 Jessie (Apache2, BIND, Dovecot, ISPConfig 3) Now I couldn't send and receive any emails from outside.

I have got the following errors:

dovecot: auth-worker(1204): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) - waiting for 1 seconds before retry

Host is not allowed to connect to this MariaDB server

 

Hi Till,
I can login to mysql as root user. Please see the following.
root@hwamail:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 22
Server version: 10.0.22-MariaDB-0+deb8u1 (Debian)

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use dbispconfig
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [dbispconfig]>

 

root@hwamail:~# /etc/init.d/mysql restart
[ ok ] Restarting mysql (via systemctl): mysql.service.

 

Please help me to resolve the problem. Today from this morning no emails for our teachers and staff. The email is very important. Tonight I need to solve the problem.

Thank you.

 

The output is:
mysql.gtid_slave_pos
note : Table does not support optimize, doing recreate + analyze instead
mysql.innodb_index_stats
note : Table does not support optimize, doing recreate + analyze instead
mysql.innodb_table_stats
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__bookmark
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__column_info
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__designer_coords
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__favorite
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__history
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__navigationhiding
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__pdf_pages
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__recent
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__relation
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__savedsearches
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__table_coords
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__table_info
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__table_uiprefs
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__tracking
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__userconfig
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__usergroups
note : Table does not support optimize, doing recreate + analyze instead
phpmyadmin.pma__users
note : Table does not support optimize, doing recreate + analyze instead

 

I think MariaDB repair should be okay.

 

I tried the following:
root@hwamail:~# mysqlcheck -uroot -p --repair --all-databases
Enter password:
dbispconfig.aps_instances OK
dbispconfig.aps_instances_settings OK
dbispconfig.aps_packages OK
dbispconfig.aps_settings OK
dbispconfig.attempts_login OK
dbispconfig.client OK
dbispconfig.client_circle OK
dbispconfig.client_message_template OK
dbispconfig.client_template OK
dbispconfig.client_template_assigned OK
dbispconfig.country OK
dbispconfig.cron OK
dbispconfig.directive_snippets OK
dbispconfig.dns_rr OK
dbispconfig.dns_slave OK
dbispconfig.dns_soa OK
dbispconfig.dns_template OK
dbispconfig.domain OK
dbispconfig.firewall OK
dbispconfig.ftp_user OK
dbispconfig.help_faq OK
dbispconfig.help_faq_sections OK
dbispconfig.iptables OK
dbispconfig.mail_access OK
dbispconfig.mail_backup OK
dbispconfig.mail_content_filter OK
dbispconfig.mail_domain OK
dbispconfig.mail_forwarding OK
dbispconfig.mail_get OK
dbispconfig.mail_mailinglist OK
dbispconfig.mail_relay_recipient OK
dbispconfig.mail_traffic OK
dbispconfig.mail_transport OK
dbispconfig.mail_user OK
dbispconfig.mail_user_filter OK
dbispconfig.monitor_data OK
dbispconfig.openvz_ip OK
dbispconfig.openvz_ostemplate OK
dbispconfig.openvz_template OK
dbispconfig.openvz_traffic OK
dbispconfig.openvz_vm OK
dbispconfig.remote_session OK
dbispconfig.remote_user OK
dbispconfig.server OK
dbispconfig.server_ip OK
dbispconfig.server_php OK
dbispconfig.shell_user OK
dbispconfig.software_package OK
dbispconfig.software_repo OK
dbispconfig.software_update OK
dbispconfig.software_update_inst OK
dbispconfig.spamfilter_policy OK
dbispconfig.spamfilter_users OK
dbispconfig.spamfilter_wblist OK
dbispconfig.support_message OK
dbispconfig.sys_config OK
dbispconfig.sys_cron OK
dbispconfig.sys_datalog OK
dbispconfig.sys_dbsync OK
dbispconfig.sys_filesync OK
dbispconfig.sys_group OK
dbispconfig.sys_ini OK
dbispconfig.sys_log OK
dbispconfig.sys_remoteaction OK
dbispconfig.sys_session OK
dbispconfig.sys_theme OK
dbispconfig.sys_user OK
dbispconfig.web_backup OK
dbispconfig.web_database OK
dbispconfig.web_database_user OK
dbispconfig.web_domain OK
dbispconfig.web_folder OK
dbispconfig.web_folder_user OK
dbispconfig.web_traffic OK
dbispconfig.webdav_user OK
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos
note : The storage engine for the table doesn't support repair
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats
note : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note : The storage engine for the table doesn't support repair
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
phpmyadmin.pma__bookmark
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__column_info
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__designer_coords
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__favorite
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__history
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__navigationhiding
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__pdf_pages
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__recent
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__relation
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__savedsearches
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__table_coords
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__table_info
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__table_uiprefs
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__tracking
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__userconfig
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__usergroups
note : The storage engine for the table doesn't support repair
phpmyadmin.pma__users
note : The storage engine for the table doesn't support repair

 

For your Info, I can connect to dbispconfig via phpmyadmin.

 

Okay, I try now.

 

Still the same.

 

Yes, I can login to ISPConfig.

 

I can login to SquirrelMail by using my email and password but can not send and receive emails from and to outside.
I can send and receive internally within the same domain.

 

okay, I try now.

 

before restart postfix and amavis, the /var/log/mail.log is: (where xxx.xxx.xxx.xxx is mail server's public IP)
Oct 10 23:33:07 hwamail postfix/submission/smtpd[23009]: connect from unknown[xxx.xxx.xxx.xxx]
Oct 10 23:33:07 hwamail postfix/cleanup[23020]: warning: regexp map /etc/postfix/body_checks, line 1: ignoring unrecognized request
Oct 10 23:33:07 hwamail postfix/submission/smtpd[23009]: 8AA1840E300E: client=unknown[xxx.xxx.xxx.xxx], sasl_method=PLAIN, [email protected]
Oct 10 23:33:07 hwamail postfix/cleanup[23020]: 8AA1840E300E: message-id=<[email protected]>
Oct 10 23:33:07 hwamail postfix/qmgr[1457]: 8AA1840E300E: from=<[email protected]>, size=27099, nrcpt=1 (queue active)
Oct 10 23:33:08 hwamail postfix/smtpd[23024]: connect from localhost[127.0.0.1]
Oct 10 23:33:08 hwamail postfix/smtpd[23024]: 2E3A540E3012: client=localhost[127.0.0.1]
Oct 10 23:33:08 hwamail postfix/cleanup[23020]: 2E3A540E3012: message-id=<[email protected]>
Oct 10 23:33:08 hwamail postfix/smtpd[23024]: disconnect from localhost[127.0.0.1]
Oct 10 23:33:08 hwamail postfix/qmgr[1457]: 2E3A540E3012: from=<[email protected]>, size=27547, nrcpt=1 (queue active)
Oct 10 23:33:08 hwamail amavis[1464]: (01464-02) Passed CLEAN {RelayedOpenRelay}, [xxx.xxx.xxx.xxx]:63063 [xxx.xxx.xxx.xxx] <[email protected]> -> <[email protected]>, Queue-ID: 8AA1840E30$
Oct 10 23:33:08 hwamail postfix/smtp[23021]: 8AA1840E300E: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.76, delays=0.12/0/0/0.63, dsn=2.0.0, status=sent (250 2.0.0 f$
Oct 10 23:33:08 hwamail postfix/qmgr[1457]: 8AA1840E300E: removed
Oct 10 23:33:10 hwamail postfix/smtp[23025]: 2E3A540E3012: to=<[email protected]>, relay=gmail-smtp-in.l.google.com[172.217.194.27]:25, delay=1.9, delays=0.13/0/0.93/0.82, dsn=5.7.1, sta$
Oct 10 23:33:10 hwamail postfix/cleanup[23020]: 269BC40E3015: message-id=<[email protected]>
Oct 10 23:33:10 hwamail postfix/bounce[23026]: 2E3A540E3012: sender non-delivery notification: 269BC40E3015
Oct 10 23:33:10 hwamail postfix/qmgr[1457]: 269BC40E3015: from=<>, size=30156, nrcpt=1 (queue active)
Oct 10 23:33:10 hwamail postfix/qmgr[1457]: 2E3A540E3012: removed
Oct 10 23:33:10 hwamail dovecot: lda([email protected]): sieve: msgid=<[email protected]>: stored mail into mailbox 'INBOX'
Oct 10 23:33:10 hwamail postfix/pipe[23027]: 269BC40E3015: to=<[email protected]>, relay=dovecot, delay=0.33, delays=0.09/0/0/0.23, dsn=2.0.0, status=sent (delivered via dovecot service)
Oct 10 23:33:10 hwamail postfix/qmgr[1457]: 269BC40E3015: removed
Oct 10 23:33:23 hwamail dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=::1, lip=::1, mpid=23030, secured, session=<ysskk+F3HQAAAAAAAAAAAAAAAAAAAAAB>
Oct 10 23:33:23 hwamail dovecot: imap([email protected]): Disconnected: Logged out in=79 out=776
Oct 10 23:33:29 hwamail dovecot: imap-login: Login: user=<[email protected]>, method=PLAIN, rip=xxx.xxx.xxx.xxx, lip=192.168.100.2, mpid=23033, TLS, session=<Jf16k+F3PwA6uagq>
Oct 10 23:33:29 hwamail dovecot: imap([email protected]): Disconnected: Logged out in=32 out=444
Oct 10 23:34:07 hwamail postfix/submission/smtpd[23009]: disconnect from unknown[xxx.xxx.xxx.xxx]