On 6/2/11 5:05 PM, "Paul J Stevens" <[email protected]> wrote:
>On 02-06-11 16:29, Martin Senebald wrote: >> Counting messages with DELETE status... >> Jun 02 14:13:23 atomsk.daquan.eu dbmail-util[24018]: [0x208b9b0] >> Database:[db] db_con_get(+256): [0x2091870] connection from pool >> Jun 02 14:13:23 atomsk.daquan.eu dbmail-util[24018]: [0x208b9b0] >> Database:[db] db_query(+344): [0x2091870] [SELECT COUNT(*) FROM >> dbmail_messages WHERE status=3] > >try to run this by hand. Just to make sure. Works. mysql> SELECT COUNT(*) FROM dbmail_messages WHERE status=3; +----------+ | COUNT(*) | +----------+ | 1 | +----------+ 1 rows in set (0.23 sec) with status 2 i have about 3000 msgs mysql> SELECT COUNT(*) FROM dbmail_messages WHERE status=2; +----------+ | COUNT(*) | +----------+ | 3068 | +----------+ 1 rows in set (0.22 sec) > >> Jun 02 14:13:23 atomsk.daquan.eu dbmail-util[24018]: [0x208b9b0] >> Database:[db] log_query_time(+290): last query took [0.000] seconds >> Jun 02 14:13:23 atomsk.daquan.eu dbmail-util[24018]: [0x208b9b0] >> Database:[db] db_con_close(+274): [0x2091870] connection to pool >> Failed. An error occured. Please check log. >> >> another thing i realized, my /var/log/dbmail.log is empty while i have >> >> file_logging_levels = 511 >> # >> syslog_logging_levels = 15 >> in my dbmail.conf >> >> Does someone has an idea why dbmail-util p is not working? >> Or maybe a hint how to enable the log to /var/log/dbmail.log ? > >That file is most likely not writable. I checked that already. I changed now the location and after dbmail restart it looks like ls -l /var/log/dbmail total 28 -rw------- 1 root root 0 Jun 2 15:21 dbmail.log -rw------- 1 root root 28015 Jun 2 15:24 error.log dbmails runs as root atm. i get the debug msg from my accessing mailclient in the error.log but nothing in dbmail.log so it seems to work kind of. > > >Fix the permissions on that file or set another location: > >sudo mkdir /var/log/dbmail >sudo chown nobody:nogroup /var/log/dbmail >sudo vi /etc/dbmail.conf > >update the logfile and errorlog entries: > >logfile = /var/log/dbmail/dbmail.log >errorlog = /var/log/dbmail/error.log > > > >> >> Thanks in advance >> Martin >> >> >> >> _______________________________________________ >> DBmail mailing list >> [email protected] >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > >-- >________________________________________________________________ >Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin > > * Premium Hosting Services and Web Application Consultancy * > > www.nfg.nl/[email protected]/+31.85.877.99.97 >________________________________________________________________ >_______________________________________________ >DBmail mailing list >[email protected] >http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
