-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Paul J Stevens schrieb: > I haven't touched the sieve layer at all. Just return values from sql > calls setting the is_active field. > > Uwe Kiewel wrote: >> Paul J Stevens wrote: >>> fixed now. >>> >> Sure. Your fixed the command line utility. But maybe you broke the sieve >> functionality? > > No warranties, remember? > But: git-log -p is your friend. > > >> This script won't work: > > Plz include some logs. >
lmtp is selecting the sieve script, but thats it about sieve. Loglevel was 511. Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_stmt_prepare(+391): [0x19600b0] [SELECT name FROM dbmail_sievescripts WHERE owner_idnr = ? AND active = 1] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_stmt_set_u64(+407): [0x19a2790] 1:[5] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Info:[message] sort_deliver_to_mailbox(+2004): useridnr [5] mailbox [INBOX] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Debug:[db] db_findmailbox(+2033): looking for mailbox with FQN [INBOX]. Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Debug:[misc] mailbox_remove_namespace(+193): [INBOX] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_stmt_prepare(+391): [0x19600b0] [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE owner_idnr= ? AND name LIKE ? ] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_stmt_set_u64(+407): [0x19c8b00] 1:[5] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_stmt_set_str(+397): [0x19c8b00] 2:[INBOX] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Debug:[db] db_find_create_mailbox(+2623): mailbox [INBOX] found Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Debug:[message] sort_deliver_to_mailbox(+2019): Checking if we have the right to post incoming messages Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_query(+340): [0x19600b0] [SELECT name,seq FROM dbmail_mailboxes WHERE mailbox_idnr=2] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] log_query_time(+290): last query took [0.001] seconds Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Debug:[MailboxState] db_getmailbox_seq(+455): id: [2] name: [INBOX] seq [1102] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_query(+340): [0x19600b0] [SELECT permission FROM dbmail_mailboxes WHERE mailbox_idnr = 2] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] log_query_time(+290): last query took [0.001] seconds Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_query(+340): [0x19600b0] [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=2 AND (status < 2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=2 AND (status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=2 AND (status < 2) AND recent_flag=1] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] log_query_time(+290): last query took [0.002] seconds Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_clear(+282): [0x19600b0] connection cleared Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Debug:[MailboxState] db_getmailbox_count(+370): exists [23] unseen [23] recent [1] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_query(+340): [0x19600b0] [SELECT MAX(message_idnr)+1 FROM dbmail_messages WHERE mailbox_idnr=2] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] log_query_time(+290): last query took [0.001] seconds Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_query(+340): [0x19600b0] [SELECT DISTINCT(keyword) FROM dbmail_keywords k JOIN dbmail_messages m ON k.message_idnr=m.message_idnr JOIN dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr WHERE b.mailbox_idnr=2] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] log_query_time(+290): last query took [0.003] seconds Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_close(+275): [0x19600b0] connection to pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_get(+257): [0x19600b0] connection from pool Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_query(+340): [0x19600b0] [SELECT owner_idnr, name, no_select, no_inferiors FROM dbmail_mailboxes WHERE mailbox_idnr = 2] Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] log_query_time(+290): last query took [0.001] seconds Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_con_clear(+282): [0x19600b0] connection cleared Dec 15 22:12:28 server dbmail-lmtpd[6267]: [0x1949910] Database:[db] db_stmt_prepare(+391): [0x19600b0] [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes WHERE owner_idnr = ? AND name LIKE ? ] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIVAwUBSUbJ4kJXG7BUuynnAQIHeQ/+ME6jejb173Q20HFSBaBWouh78CJVe22A BHCL+9rAALFTsMJh85tSefECWbRzHo18WlA2rBZUxTCdZovvU7GMYYMV59d8iF+H xYziAwF/fog82qQ120mmwIF5/QfRpKddKNIlSDVSrgPz/UZuwGkN1ginagGAIxMK Y/N7MXrZecrbzOzHNFp9bOIMqI8lp8T3tN0yhzBALs3kffDkYBiV0d9Z1S6Schlb LCmfHO5qJQoE3vqvpR17cb8VMj7v5edyiWw32onsj1Kg9iz0uURhM6u6rO6PXQbG Xc+bRAG76gvFDY2myPOVEwEthi2qOru787OKC1LeW6T2yl4NHDG/rBMKUfSHzHV0 +zqRHpYQkipZl4X2ItHNh4x8Qm8F/QA3Iw/nU+/7izy6phHhOU0v720x0tu1emdB P4kRaHmYmZ3XqvpHdIqI9T5DFyAwC2yxI3iczns54O/BE8aJTFarCuDmJOyJMsOT QZPG18ztq5HxvRe5u4smMRWzPCzvgQsf3UifsrZBHKQO3FODZEPHdMbHTaipPsRn Fc8iS/JrajP6LeTVfUhrJj40mGb6ErWTXsPqdBs3StdfkrhiE5cq7wwq+T7s1BQU D4lVGOKUlniAEC7Uw3pr6dcPmNHSnf3XC+xDU8/ZVYT/bk5rD8JayR/gw9xisDqi AIc9t+nHBgU= =9BLR -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
