MailWatch stopped updating

[stefan968]

MailWatch worked fine but stopped updating several days ago. I checked everything i could think of. The database appears to be fine I did a repair but no problems. Logging stopped 23-5 12:11. You can see this clearly in the maillog:

May 23 12:11:01 smtp3 MailScanner[20777]: 6EAC51201A7.A414C: Logged to MailWatch SQL
May 23 12:11:07 smtp3 MailScanner[20777]: 7515B120331.A23EE: Logged to MailWatch SQL
May 23 12:11:11 smtp3 MailScanner[20777]: 8C5DA1201A7.AE992: Logged to MailWatch SQL
May 24 03:46:01 smtp3 MailScanner[20774]: Config: calling custom end function MailWatchLogging
May 24 03:46:01 smtp3 MailScanner[20539]: Config: calling custom end function MailWatchLogging
May 24 03:46:07 smtp3 MailScanner[25509]: Config: calling custom init function MailWatchLogging

I updated the system to the latest version but that didn't help.

Appreciate some help.

Regards,

Stefan

[stefan968]

Here is the debug from the mailwatch.pm:

DBI 1.609-ithread default trace level set to 0x0/2 (pid 3579) at MailWatch.pm line 31 via Config.pm
line 760
-> DBI->connect(DBI:mysql:database=mailscanner;host=localhost, mailwatch, ****, HASH(0x7f2d136c9a10)
)
-> DBI->install_driver(mysql) for linux perl=5.010001 pid=3579 ruid=0 euid=0
install_driver: DBD::mysql version 4.013 loaded from /usr/lib64/perl5/DBD/mysql.pm
<- install_driver= DBI::dr=HASH(0x7f2d136d03b8)
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::mysql::dr (DBI::dr=HASH(0x7f2d136d03b8)~0x7f2d136d02e0 'database=mailscanner;hos
t=localhost' 'mailwatch' **** HASH(0x2015e10)) thr#1bec010
imp_dbh->connect: dsn = database=mailscanner;host=localhost, uid = mailwatch, pwd = FbviQ1p88ozVDITSG1Yz
ipAmHSsHSt
imp_dbh->my_login : dbname = mailscanner, uid = mailwatch, pwd = FbviQ1p88ozVDITSG1YzipAmHSsHSt,host = l
ocalhost, port = NULL
imp_dbh->mysql_dr_connect: host = |localhost|, port = 0, uid = mailwatch, pwd = FbviQ1p88ozVDITSG1YzipAm
HSsHSt
imp_dbh->use_server_side_prepare: 0
imp_dbh->mysql_dr_connect: client_flags = 2
imp_dbh->mysql_dr_connect: <- <- connect= DBI::db=HASH(0x7f2d136cfad0) at DBI.pm line 653
-> STORE for DBD::mysql::db (DBI::db=HASH(0x7f2d136cfc50)~INNER 'PrintError' 0) thr#1bec010
<- STORE= 1 at DBI.pm line 705
-> STORE for DBD::mysql::db (DBI::db=HASH(0x7f2d136cfc50)~INNER 'AutoCommit' 1) thr#1bec010
<- STORE= 1 at DBI.pm line 705
-> STORE for DBD::mysql::db (DBI::db=HASH(0x7f2d136cfc50)~INNER 'Username' 'mailwatch') thr#1bec010
<- STORE= 1 at DBI.pm line 708
<> FETCH= 'mailwatch' ('Username' from cache) at DBI.pm line 708
-> connected in DBD::_::db for DBD::mysql::db (DBI::db=HASH(0x7f2d136cfad0)~0x7f2d136cfc50 'DBI:mysq
l:database=mailscanner;host=localhost' 'mailwatch' 'FbviQ1p88ozVDITSG1YzipAmHSsHSt' HASH(0x7f2d136c9a10)
) thr#1bec010
<- connected= undef at DBI.pm line 714
<- connect= DBI::db=HASH(0x7f2d136cfad0)
-> STORE for DBD::mysql::db (DBI::db=HASH(0x7f2d136cfc50)~INNER 'dbi_connect_closure' CODE(0x3bdd500
)) thr#1bec010
<- STORE= 1 at DBI.pm line 723
-> prepare for DBD::mysql::db (DBI::db=HASH(0x7f2d136cfad0)~0x7f2d136cfc50 'SELECT to_address, from_
address FROM blacklist') thr#1bec010
[root@smtp3 ~]# tail /root/dbitrace.log -f
! <- DESTROY= undef during global destruction
! -> DESTROY in DBD::_::common for DBD::SQLite::dr (DBI::dr=HASH(0x3447fc0)~INNER) thr#d5e010
! <- DESTROY= undef during global destruction
! -> DESTROY for DBD::SQLite::db (DBI::db=HASH(0x35afd18)~INNER) thr#d5e010
DESTROY DBI::db=HASH(0x35afd18) skipped due to InactiveDestroy
! <- DESTROY= undef during global destruction
! -> DESTROY for DBD::SQLite::st (DBI::st=HASH(0x358e8b0)~INNER) thr#d5e010
! <- DESTROY= undef during global destruction
! -> DESTROY for DBD::SQLite::st (DBI::st=HASH(0x35a0920)~INNER) thr#d5e010
! <- DESTROY= undef during global destruction

[stefan968]

Does anyone have a clue how to fix this?

I tried everything checked the database and all the permissions. Everything seems fine but its still not logging. I need to fix this asap.

Appreciate any help.

Stefan

[stefan968]

I fixed it by restoring the server from a previous backup. I then updated to version 3.0.1.1 and copied over the latest config and mailscanner database from the broken server. In theory this server is identical to the old one but this one works and the old one doesn't.

[shawniverson]

Glad you have it resolved

Backups are a lifesaver. Wish more people would use that practice. EFA is an appliance. If it is broken, well, try to fix it. If you can't, then restore. No backup, well, sorry about your luck....spin up a new one.