when i click onto greylist i get the following error.
Code: Select all
Error in the query:
Code: Select all
MailWatch Version: 1.2.15
Operating System Version: CentOS Linux 7 (Core)
Postfix Version: 3.4.8
MailScanner Version: 5.3.4
ClamAV Version: 0.103.0
SpamAssassin Version: 3.4.4
PHP Version: 7.2.34
MySQL Version: 10.1.41-MariaDB
GeoIP Database Version: GeoLite2 Country database 2020-12-29 15:51:41
Code: Select all
[root@efa4 ~]# systemctl status -l sqlgrey
● sqlgrey.service - SQLgrey Postfix Grey-listing Policy service
Loaded: loaded (/usr/lib/systemd/system/sqlgrey.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/sqlgrey.service.d
└─override.conf
Active: active (running) since Tue 2021-01-05 16:06:09 CET; 15min ago
Main PID: 13180 (sqlgrey)
CGroup: /system.slice/sqlgrey.service
└─13180 /usr/bin/perl -w /usr/sbin/sqlgrey -d
Jan 05 16:06:09 efa4.xx.de systemd[1]: Starting SQLgrey Postfix Grey-listing Policy service...
Jan 05 16:06:09 efa4.xx.de sqlgrey[13180]: Process Backgrounded
Jan 05 16:06:09 efa4.xx.de sqlgrey[13180]: 2021/01/05-16:06:09 sqlgrey (type Net::Server::Multiplex) starting! pid(13180)
Jan 05 16:06:09 efa4.xx.de systemd[1]: Started SQLgrey Postfix Grey-listing Policy service.
Jan 05 16:06:09 efa4.xx.de sqlgrey[13180]: Binding to TCP port 2501 on host 127.0.0.1 with IPv4
Jan 05 16:06:09 efa4.xx.de sqlgrey[13180]: Setting gid to "988 988"
Jan 05 16:06:09 efa4.xx.de sqlgrey[13180]: Setting uid to "991"
I also already tried a "update_sqlgrey_config". and a service restart.
And /etc/sqlgrey/sqlgrey.conf also doesnt look strange.
Also mysql doesnt report an error:
Code: Select all
mysqlcheck -c -A -uroot -p`grep ROOT /etc/eFa/MySQL-Config | awk -F: '{print $2}'
mailscanner.audit_log OK
mailscanner.autorelease OK
mailscanner.blacklist OK
mailscanner.inq OK
mailscanner.maillog OK
mailscanner.mcp_rules OK
mailscanner.mtalog OK
mailscanner.mtalog_ids OK
mailscanner.outq OK
mailscanner.sa_rules OK
mailscanner.saved_filters OK
mailscanner.user_filters OK
mailscanner.users OK
mailscanner.whitelist OK
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos OK
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 OK
mysql.innodb_table_stats OK
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
opendmarc.domains OK
opendmarc.ipaddr OK
opendmarc.messages OK
opendmarc.reporters OK
opendmarc.requests OK
opendmarc.signatures OK
sa_bayes.bayes_expire OK
sa_bayes.bayes_global_vars OK
sa_bayes.bayes_seen OK
sa_bayes.bayes_token OK
sa_bayes.bayes_vars OK
sa_bayes.txrep OK
sqlgrey.config OK
sqlgrey.connect OK
sqlgrey.domain_awl OK
sqlgrey.from_awl OK
sqlgrey.optin_domain OK
sqlgrey.optin_email OK
sqlgrey.optout_domain OK
sqlgrey.optout_email OK
And which sql select on which table would i need to check if there is anything happening ?
I can connect to the mysql DB as user sqlgrey with the password mentioned in /etc/sqlgrey/sqlgrey.conf.
Thx