Am 10.02.2012 16:10, schrieb Paul J Stevens: > On 02/10/2012 03:55 PM, Reindl Harald wrote: >> problem exists also with >> dbmail-3.0.0-6.fc15.20120210.rh.b745a81d39b75d9f335779cc8af3a906b4eb01e1.x86_64 >> >> another debug-log attached, here the debug-output of the reply-query, rest as >> attachment (lines 665-669 are interesting) >> >> BTW - why is the host-name messed up in the log? > > Good question. What locale are you on? > >> >> Feb 10 15:42:47 testserver.rhsof½Ï dbmail-lmtpd[20530]: [0xbc2280] >> Database:[db] db_stmt_prepare(+400): [0xbed4b0] >> [SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = ? AND ? >> BETWEEN start_date AND stop_date] >> Feb 10 15:42:47 testserver.rhsof½Ï dbmail-lmtpd[20530]: [0xbc2280] >> Database:[db] db_stmt_set_u64(+420): [0xcf8a00] >> 1:[15] >> Feb 10 15:42:47 testserver.rhsof½Ï dbmail-lmtpd[20530]: [0xbc2280] >> Database:[db] db_stmt_set_str(+408): [0xcf8a00] >> 2:[NOW()] >> Feb 10 15:42:47 testserver.rhsof½Ï dbmail-lmtpd[20530]: [0xbc2280] >> Database:[db] db_con_close(+274): [0xbed4b0] >> connection to pool >> Feb 10 15:42:47 testserver.rhsof½Ï dbmail-lmtpd[20530]: [0xbc2280] >> Error:[message] execute_auto_ran(+2385): error >> fetching reply body > > This just doesn't tell us anything. Please try the mysql logs
i fear they also do not show any interesting
but try the query manually is interesting
how do i get these idiotic warnings mysql speaks about?
why do i get "could not fetch reply_body" for every single lmtp-delivery
independent if the user has a reply defined?
mysql> SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 15;
+---------------------------------------+
| reply_body |
+---------------------------------------+
| Autoreply-Test
mysql> SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 15 AND
'NOW()' BETWEEN start_date AND stop_date;
Empty set, 2 warnings (0.00 sec)
mysql> SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 15 AND
'NOW()' BETWEEN date(start_date) AND
date(stop_date);
Empty set, 2 warnings (0.00 sec)
_______________________
13 Query INSERT INTO dbmail_keywords (message_idnr,
keyword) SELECT 70916,keyword from dbmail_keywords WHERE
message_idnr=70915
13 Query COMMIT
13 Query START TRANSACTION
13 Query UPDATE dbmail_users SET curmail_size =
curmail_size + 809 WHERE user_idnr = 15
13 Query COMMIT
13 Prepare SELECT reply_body FROM dbmail_auto_replies
WHERE user_idnr = ? AND ? BETWEEN start_date AND stop_date
13 Execute SELECT reply_body FROM dbmail_auto_replies
WHERE user_idnr = 15 AND 'NOW()' BETWEEN start_date AND
stop_date
13 Close stmt
13 Query START TRANSACTION
13 Query DELETE FROM dbmail_messages WHERE message_idnr
= 70915
13 Query COMMIT
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
