This doesn't look right.
Candice Quates wrote:
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: pipe.c, insert_messages: temporary
msgidnr is [7]
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: pipe.c, insert_messages: calling
sort_and_deliver for useridnr [2]
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: GetConfigValue(): searching value
for config item [SQLREGEX]
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: GetConfigValue(): item not found
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: GetConfigValue(): searching value
for config item [LIBSIEVE]
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: GetConfigValue(): item not found
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: dbmysql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='2']
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: dbmysql.c,db_query: executing query
[SELECT pm.messagesize FROM dbmail_physmessage pm, dbmail_messages msg WHERE
pm.id = msg.physmessage_id AND message_idnr = '7']
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: dbmysql.c,db_query: executing query
[SELECT 1 FROM dbmail_users WHERE user_idnr = '2' AND (maxmail_size > 0) AND
(curmail_size + '669' > maxmail_size)]
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: misc.c,create_unique_id: created:
31c4736a7014ef3bfb6462157efd504f
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: dbmysql.c,db_query: executing query
[INSERT INTO dbmail_messages (mailbox_idnr,physmessage_id, seen_flag,
answered_flag, deleted_flag, flagged_flag, recent_flag, draft_flag, unique_id,
status) SELECT '1', physmessage_id, seen_flag, answered_flag, deleted_flag,
flagged_flag, recent_flag, draft_flag, '31c4736a7014ef3bfb6462157efd504f',
status FROM dbmail_messages WHERE message_idnr = '7']
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: db.c,db_add_quotum_used: adding 669
to mailsize
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]:
db.c.user_idnr_is_delivery_user_idnr: no need to look up user_idnr for [EMAIL
PROTECTED]@__
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: dbmysql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size + '669' WHERE user_idnr =
'2']
Sep 6 16:55:01 mail1 dbmail/lmtpd[96635]: sort.c, sort_and_deliver: message
id=0, size=669 is inserted
Given that the temporary msgidnr is 7, the message_idnr should *not* by 0.
Show us the schema for your dbmail_messages table. This sounds like
auto_increment is not set for dbmail_messages.message_idnr
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
