Thomas, Paul, Found it, strace was useful, I could see that by default without specifying -f /etc/dbmail.conf it's reading the defaults in /usr/local/etc/dbmail.conf. In previous dbmail-util in ~2.3.6 it was reading by default /etc/dbmail.conf.
Paul, Don't know how you want the behavior, so here's the info for you to consider. For me, I'm going to specify -f to solve it for me. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Jorge Bastos > Sent: quinta-feira, 6 de Novembro de 2014 09:42 > To: 'DBMail mailinglist' > Subject: Re: [Dbmail] dbmail-util 3.1.17 not cleaning deleted emails > > Hi Thomas, > > > you can use strace to see what SQL statements are issued: > > > > strace -s 100 -a 160 -e trace=sendto dbmail-util -v -y -dp > > > > will give you something like this: > > > > .... > > Deleting messages with DELETE status... > > sendto(3, "Q\0\0\0%SET statement_timeout TO 300000;\0", 38, > > MSG_NOSIGNAL, NULL, 0) > > = 38 > > sendto(3, "Q\0\0\0\27BEGIN TRANSACTION;\0", 24, MSG_NOSIGNAL, NULL, > 0) > > > > = 24 > > sendto(3, "Q\0\0\0/DELETE FROM dbmail_messages WHERE status=3\0", 48, > > MSG_NOSIGNAL, NULL, 0) > > = 48 > > sendto(3, "Q\0\0\0\30COMMIT TRANSACTION;\0", 25, MSG_NOSIGNAL, NULL, > > 0) > > > > = 25 > > sendto(3, "Q\0\0\0#SET statement_timeout TO 3000;\0", 36, > > MSG_NOSIGNAL, NULL, 0) > > = 36 > > Ok. Messages deleted. > > > > Setting DELETE status for deleted messages... > > sendto(3, "Q\0\0\0%SET statement_timeout TO 300000;\0", 38, > > MSG_NOSIGNAL, NULL, 0) > > = 38 > > sendto(3, "Q\0\0\0\27BEGIN TRANSACTION;\0", 24, MSG_NOSIGNAL, NULL, > 0) > > > > = 24 > > sendto(3, "Q\0\0\0;UPDATE dbmail_messages SET status = 3 WHERE status > > = 2\0", 60, MSG_NOSIGNAL, NULL, 0) > > = 60 > > sendto(3, "Q\0\0\0\30COMMIT TRANSACTION;\0", 25, MSG_NOSIGNAL, NULL, > > 0) > > > > = 25 > > sendto(3, "Q\0\0\0#SET statement_timeout TO 3000;\0", 36, > > MSG_NOSIGNAL, NULL, 0) > > = 36 > > Ok. Messages set for deletion. > > Re-calculating used quota for all users... > > sendto(3, "Q\0\0\0%SET statement_timeout TO 300000;\0", 38, > > MSG_NOSIGNAL, NULL, 0) > > = 38 > > sendto(3, "Q\0\0\1\316SELECT usr.user_idnr, SUM(pm.messagesize), > > usr.curmail_size FROM dbmail_users usr LEFT JOIN dbm"..., 463, > > MSG_NOSIGNAL, NULL, 0) = 463 > > sendto(3, "Q\0\0\0#SET statement_timeout TO 3000;\0", 36, > > MSG_NOSIGNAL, NULL, 0) > > = 36 > > Ok. Used quota updated for all users. > > .... > > > > so what i did was check the status field in dbmail_messages before > > deleting, > > -) after deleting (in thunderbird) => status 2 > > -) then after running dbmail-util to mark the deleted messages => > > status 2->3 > > -) after dbmail-util pruning => messages are gone > > > > so it seems to work here. > > > > anyway with that strace command you can debug the SQL commands easier > > than setting some logging in the DB (which of course would be for > more > > than one executable then). > > In fact I was thinking in a way to the SQL executed by -util but the > only way I figured out yet was the sql logs but during work hours it's > almost impossible to retrieve them, and the only change is to get them > at very late hours. > > Haven't thinked in strace yet, but thanks for the tip :) Will do and > post. > > Thanks, > > > _______________________________________________ > 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
