Hi All,
I have been running dbmail for some time now, and waiting for seive - thanks
to everyone involved in getting it going.
So I thought that today would be a good day to install 2.1.5 - after finally
getting it to compile.
So, understanding that it is unstable, a backup of the database and the
ability to re-install to existing executables is all I need to recover if
anything goes sour.
Fine so far - so I thought (pg_dump file failed - operator error, to much
rush, so not checked properly :-)
make
make install
add_header_tables
add_sieve_tables
add_auto_replies_fields
add_replycache
add_usermap
dbmail-util -byv
The makes went fine, dbmail-util failed with some messages in cache, reported
that errors were fixed and to check that all is ok run it again. So I did.
Similar result.
Errors similar to the following were produced:
Opening connection to database...
Opening connection to authentication...
Ok. Connected.
Repairing DBMAIL for incorrect is_header flags...
Ok. Found [0] incorrect is_header flags.
--- checking is_header flags took 30 seconds
Repairing DBMAIL for rfcsize field...
Ok. Found [0] missing rfcsize values.
--- checking rfcsize field took 1 seconds
Repairing DBMAIL for cached header values...
Ok. Found [14] un-cached physmessages.
dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_referencesfield
(physmessage_id, referencesfield) VALUES (12444,'[EMAIL PROTECTED]')] : [ERROR:
duplicate key violates unique constraint "dbmail_referencesfield_1"
]
dbmail-message.c,insert_field_cache: insert referencesfield failed [INSERT
INTO dbmail_referencesfield (physmessage_id, referencesfield) VALUES
(12444,'[EMAIL PROTECTED]')]
dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_referencesfield
(physmessage_id, referencesfield) VALUES (12444,'[EMAIL PROTECTED]')] : [ERROR:
current transaction is aborted, commands ignored until end of transaction block
]
dbmail-message.c,insert_field_cache: insert referencesfield failed [INSERT
INTO dbmail_referencesfield (physmessage_id, referencesfield) VALUES
(12444,'[EMAIL PROTECTED]')]
dbpgsql.c, db_query: Error executing query [INSERT INTO dbmail_referencesfield
(physmessage_id, referencesfield) VALUES (12444,'[EMAIL PROTECTED]')] : [ERROR:
current transaction is aborted, commands ignored until end of transaction block
]
.......
dbmail-message.c,insert_field_cache: insert referencesfield failed [INSERT
INTO dbmail_referencesfield (physmessage_id, referencesfield) VALUES
(27501,'[EMAIL PROTECTED]')]
.--- checking cached headervalues took 37 seconds
Maintenance done. Errors were found and fixed.
Try running dbmail-util again to confirm that the errors were repaired.
O Well, I bring up postfix and send an e-mail anyway.
Get dbmail-smtp signal 11 error that leads me to install the latest SVN.
Try again - autoconf, make, install, send e-mail.
dbmail-smtp -V
*** DBMAIL: dbmail-smtp version $Revision: 2058 $ (c) 1999-2004 IC&S,
2004-2006 NFG, The Netherlands
No errors in maillog (That I can detect).
The header is visible in my mail clients ( I'v tried evoulution, thunderbird
and M$ Outlook 2003 all using imap), but the body is nowhere to be seen. I can
see it in the database (dbmail_messageblks), but can't get it to my mail client.
So methinks I'll restore my original database and executables. WRONG. Backup
failed.
Is there any way back? Or anyway forward?
I would prefer to go forward.
here is an extract from my maillog:
Apr 4 14:55:46 mail postfix/postfix-script: starting the Postfix mail system
Apr 4 14:55:46 mail postfix/master[18516]: daemon started -- version 2.2.2,
configuration /etc/postfix
Apr 4 14:56:42 mail postfix/smtpd[18530]: connect from
web38009.mail.mud.yahoo.com[209.191.124.120]
Apr 4 14:56:42 mail postfix/trivial-rewrite[18533]: warning: database
/etc/postfix/transport.db is older than source file /etc/postfix/transport
Apr 4 14:56:43 mail postfix/smtpd[18530]: 28AE22AF24:
client=web38009.mail.mud.yahoo.com[209.191.124.120]
Apr 4 14:56:44 mail postfix/cleanup[18534]: 28AE22AF24: message-id=<[EMAIL
PROTECTED]>
Apr 4 14:56:44 mail postfix/qmgr[18519]: 28AE22AF24: from=<[EMAIL
PROTECTED]>, size=1907, nrcpt=1 (queue active)
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [host]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail last message repeated 3 times
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): found value
[127.0.0.1]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [db]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): found value
[dbmail]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [user]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): found value
[dbmail]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [pass]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail last message repeated 3 times
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): item not found
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [sqlport]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail last message repeated 3 times
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): item not found
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [sqlsocket]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): NULL item value
in item-list
Apr 4 14:56:44 mail last message repeated 3 times
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): item not found
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [trace_level]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): found value [5]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 4 14:56:44 mail dbmail/smtp[18536]: header.c,consume_header_line: end of
header found
Apr 4 14:56:44 mail dbmail/smtp[18536]: header.c,get_rfc_size: remaining_len
= 771
Apr 4 14:56:44 mail dbmail/smtp[18536]: mime_readheader(): entering mime loop
Apr 4 14:56:44 mail dbmail/smtp[18536]: mime_readheader(): found double
newline; header size: 18 lines
Apr 4 14:56:44 mail dbmail/smtp[18536]: authsql.c,auth_check_user_ext:
checking user [EMAIL PROTECTED] in alias table
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('[EMAIL
PROTECTED]') AND lower(alias) <> lower(deliver_to)]
Apr 4 14:56:44 mail dbmail/smtp[18536]: authsql.c,auth_check_user_ext: into
checking loop
Apr 4 14:56:44 mail dbmail/smtp[18536]: authsql.c,auth_check_user_ext:
checking user [EMAIL PROTECTED] to 2
Apr 4 14:56:44 mail dbmail/smtp[18536]: authsql.c,auth_check_user_ext:
checking user [2] in alias table
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('2') AND
lower(alias) <> lower(deliver_to)]
Apr 4 14:56:44 mail dbmail/smtp[18536]: authsql.c,auth_check_user_ext:
adding [2] to deliver_to address
Apr 4 14:56:44 mail dbmail/smtp[18536]: dsn.c, dsnuser_resolve: user [EMAIL
PROTECTED] found total of [1] aliases
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[BEGIN]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 4 14:56:44 mail dbmail/smtp[18536]: misc.c,create_unique_id: created:
9f172373d8d4949cd9f3e46ebab37416
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='8']
Apr 4 14:56:44 mail dbmail/smtp[18536]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[INSERT INTO dbmail_physmessage (messagesize, internal_date) VALUES ('0',
CURRENT_TIMESTAMP)]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT currval('dbmail_physmessage_id_seq')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[INSERT INTO dbmail_messages(mailbox_idnr, physmessage_id,
unique_id,recent_flag, status) VALUES ('142', '29083',
'9f172373d8d4949cd9f3e46ebab37416', '1', '5')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT currval('dbmail_message_idnr_seq')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('1','Received: from web38009.mail.mud.yahoo.com
(web38009.mail.mud.yahoo.com [209.191.124.120]) by mail.itnavigate.com.au
(Postfix) with SMTP id 28AE22AF24 for <[EMAIL PROTECTED]>; Tue, 4 Apr
2006 14:56:42 +0800 (WST) Received: (qmail 53533 invoked by uid 60001); 4 Apr
2006 06:56:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024;
d=yahoo.com.au;
h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
b=HmhQ1ITIIVDXl3/C8cysl7yQ3cd9+pJSMm4NEtB4yM1LKnjXY48v/sqbbLk3mjngq2J9oZvIeurtA/ZUDxeIeh3GOq7l06BmqPYjLqypweCeEbVD4kgtT11lWFLsEo7w+V1o0S1OIzEvYOAFYWBvs05EllaeSZb0fSqx4KHblhM=
; Message-ID: <[EMAIL PROTECTED]> Received: from [58.6.56.84] by
web38009.mail.mud.yahoo.com via HTTP; Tue, 04 Apr 2006
16:56:35 EST Date: Tue, 4 Apr 2006 16:56:35 +10
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT currval('dbmail_messageblk_idnr_seq')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: store_message_temp(): allocating
[524288] bytes of memory for readblock
Apr 4 14:56:44 mail dbmail/smtp[18536]: pipe.c,store_message_in_blocks:
inserting message: --0-1754653729-1144133795=:52863 Content-Type: text/plain;
charset=iso-8859-1 Content-Transfer-Encoding: 8bit Testing DBMail-lmtp
bTesting DBMail-lmtp bTesting DBMail-lmtp bTesting DBMail-lmtp bTesting
DBMail-lmtp b --------------------------------- On Yahoo!7
Messenger: Make free PC-to-PC calls to your friends overseas.
--0-1754653729-1144133795=:52863 Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit Testing DBMail-lmtp bTesting DBMail-lmtp
bTesting DBMail-lmtp bTesting DBMail-lmtp bTesting DBMail-lmtp b<br><p>
<hr size=1>On Yahoo!7<br> <a
href="http://au.rd.yahoo.com/mail/tag/**http%3A%2F%2Fau.messenger.yahoo.com%2F";
> Messenger: Make free PC-to-PC calls to your friends overseas.</a>
--0-1754653729-1144133795=:52863--
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[INSERT INTO dbmail_messageblks (is_header, messageblk, blocksize,
physmessage_id) VALUES ('0','--0-1754653729-1144133795=:52863 Content-Type:
text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Testing
DBMail-lmtp bTesting DBMail-lmtp bTesting DBMail-lmtp bTesting DBMail-lmtp
bTesting DBMail-lmtp b --------------------------------- On
Yahoo!7 Messenger: Make free PC-to-PC calls to your friends overseas.
--0-1754653729-1144133795=:52863 Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit Testing DBMail-lmtp bTesting DBMail-lmtp
bTesting DBMail-lmtp bTesting DBMail-lmtp bTesting DBMail-lmtp b<br><p>
<hr size=1>On Yahoo!7<br> <a
href="http://au.rd.yahoo.com/mail/tag/**http%3A%2F%2Fau.messenger.yahoo.com%2F";
> Messenger: Make free PC-to-PC calls to your friends overseas.</a>
--0-1754653729-1144133795=:52863-- ', '771',
'29083')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT currval('dbmail_messageblk_idnr_seq')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[UPDATE dbmail_messages SET unique_id = '9f172373d8d4949cd9f3e46ebab37416',
status = '0' WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[UPDATE dbmail_physmessage SET messagesize = '1868', rfcsize = '1906' WHERE id
= '29083']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT dbmail_mailboxes.owner_idnr FROM dbmail_mailboxes, dbmail_messages
WHERE dbmail_mailboxes.mailbox_idnr = dbmail_messages.mailbox_idnr AND
dbmail_messages.message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: db.c,db_add_quotum_used: adding 1868
to mailsize
Apr 4 14:56:44 mail dbmail/smtp[18536]: db.c.user_idnr_is_delivery_user_idnr:
looking up user_idnr for [EMAIL PROTECTED]@__
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT user_idnr FROM dbmail_users WHERE userid='[EMAIL PROTECTED]@__']
Apr 4 14:56:44 mail dbmail/smtp[18536]: pipe.c, insert_messages: temporary
msgidnr is [42196]
Apr 4 14:56:44 mail dbmail/smtp[18536]: pipe.c, insert_messages: calling
sort_and_deliver for useridnr [2]
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='2']
Apr 4 14:56:44 mail dbmail/smtp[18536]: db.c, db_find_create_mailbox:
mailbox [INBOX] found
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT pm.messagesize FROM dbmail_physmessage pm, dbmail_messages msg WHERE
pm.id = msg.physmessage_id AND message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT 1 FROM dbmail_users WHERE user_idnr = '2' AND (maxmail_size > 0) AND
(curmail_size + '1868' > maxmail_size)]
Apr 4 14:56:44 mail dbmail/smtp[18536]: misc.c,create_unique_id: created:
80f793ac50d6b85252f987d8e2b06832
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.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 '2', physmessage_id, seen_flag, answered_flag, deleted_flag,
flagged_flag, recent_flag, draft_flag, '80f793ac50d6b85252f987d8e2b06832',
status FROM dbmail_messages WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT currval('dbmail_message_idnr_seq')]
Apr 4 14:56:44 mail dbmail/smtp[18536]: db.c,db_add_quotum_used: adding 1868
to mailsize
Apr 4 14:56:44 mail dbmail/smtp[18536]: db.c.user_idnr_is_delivery_user_idnr:
no need to look up user_idnr for [EMAIL PROTECTED]@__
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[UPDATE dbmail_users SET curmail_size = curmail_size + '1868' WHERE user_idnr =
'2']
Apr 4 14:56:44 mail dbmail/smtp[18536]: sort.c, sort_and_deliver: message
id=42197, size=1868 is inserted
Apr 4 14:56:44 mail dbmail/smtp[18536]: pipe.c, insert_messages: successful
sort_and_deliver for useridnr [2]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [AUTO_NOTIFY]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): found value [no]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): searching value
for config item [AUTO_REPLY]
Apr 4 14:56:44 mail dbmail/smtp[18536]: GetConfigValue(): found value [no]
Apr 4 14:56:44 mail dbmail/smtp[18536]: insert_messages(): we need to
deliver [0] messages to external addresses
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[DELETE FROM dbmail_messages WHERE message_idnr = '42196']
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = '29083']
Apr 4 14:56:44 mail dbmail/smtp[18536]: insert_messages(): temporary message
deleted from database
Apr 4 14:56:44 mail dbmail/smtp[18536]: insert_messages(): End of function
Apr 4 14:56:44 mail dbmail/smtp[18536]: dbpgsql.c,db_query: executing query
[COMMIT]
Apr 4 14:56:44 mail dbmail/smtp[18536]: main(): freeing dsnuser list
Apr 4 14:56:44 mail dbmail/smtp[18536]: dsn.c, dsnuser_free: dsnuser freed
Apr 4 14:56:44 mail dbmail/smtp[18536]: main(): freeing all other lists
Apr 4 14:56:44 mail dbmail/smtp[18536]: main(): freeing memory blocks
Apr 4 14:56:44 mail dbmail/smtp[18536]: main(): they're all free. we're
done.
Apr 4 14:56:44 mail dbmail/smtp[18536]: main(): exit code is [0].
Apr 4 14:56:44 mail postfix/pipe[18535]: 28AE22AF24: to=<[EMAIL PROTECTED]>,
relay=dbmail-smtp, delay=2, status=sent (itnavigate.com.au)
Apr 4 14:56:44 mail postfix/qmgr[18519]: 28AE22AF24: removed
Apr 4 14:56:44 mail postfix/smtpd[18530]: disconnect from
web38009.mail.mud.yahoo.com[209.191.124.120]
Apr 4 14:57:12 mail dbmail/imap4d[18553]: pool.c,child_register:
initializing child_state [18553] using slot [4]
Apr 4 15:00:04 mail postfix/anvil[18532]: statistics: max connection rate
1/60s for (smtp:209.191.124.120) at Apr 4 14:56:42
Apr 4 15:00:05 mail postfix/anvil[18532]: statistics: max connection count 1
for (smtp:209.191.124.120) at Apr 4 14:56:42
Apr 4 15:00:07 mail postfix/anvil[18532]: statistics: max cache size 1 at
Apr 4 14:56:42
---------------------------------
On Yahoo!7
Messenger: Make free PC-to-PC calls to your friends overseas.
