Same problem for me. Haven't looked into it myself yet, but my Inbox is
getting full of mailling list items.
-Jon
Uwe Kiewel wrote:
-----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
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
