But wait - there's more!
When I revert back to 2.0.6 executables th mail gets delivered correctly!! - I
just can't accesses from my client untill I revert to the SVN executables.
Paul J Stevens <[EMAIL PROTECTED]> wrote: Colin Manning wrote:
> 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,
None of those look fatal.
>
> 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.
Running 2.0.9 or 2.0.10 would be fine, without restoring the data.
>
> Is there any way back? Or anyway forward?
>
> I would prefer to go forward.
great.
>
> here is an extract from my maillog:
I only see logs from dbmail-smtp. Show me some imap logs.
Errr... that would be because I cut the log to short - sorry. Here is an
attempt to get a message yust now.
Apr 5 06:10:39 mail dbmail/imap4d[26201]: COMMAND: [14 UID fetch 42207 (UID
RFC822.SIZE BODY[])]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[0]: 'fetch'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[1]: '42207'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[2]: '('
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[3]: 'UID'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[4]: 'RFC822.SIZE'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[5]: 'BODY'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[6]: '['
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[7]: ']'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: arg[8]: ')'
Apr 5 06:10:39 mail dbmail/imap4d[26201]: imap4.c,IMAPClientHandler:
Executing command uid...
Apr 5 06:10:39 mail dbmail/imap4d[26201]: db.c,db_acl_has_right: checking ACL
[read_flag] for user [2] on mailbox [2]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: db.c, db_acl_has_right: mailbox [2]
is owned by user [2], is that also [2]?
Apr 5 06:10:39 mail dbmail/imap4d[26201]: db.c, db_acl_has_right: mailbox [2]
is owned by user [2], giving all rights
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[2] = [UID]
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 2] = UID
(returning 3)
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[3] =
[RFC822.SIZE]
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: args[idx = 3] =
RFC822.SIZE (returning 4)
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[4] =
[BODY]
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,_imap_session_fetch_parse_octet_range: parse token [)]
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,dbmail_imap_session_fetch_parse_args: parse args[7] = [)]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: imapcommands.c,_ic_fetch:
fetch_start [42207] fetch_end [42207]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: dbpgsql.c,db_query: executing query
[SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag,
recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize,
message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id =
msg.physmessage_id AND message_idnr BETWEEN '42207' AND '42207' AND
mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [* 1199 FETCH (]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [RFC822.SIZE 1826]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [ ]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [UID 42207]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [ ]
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,_imap_cache_update: cache message [42207] filter [1]
Apr 5 06:10:39 mail dbmail/imap4d[26201]: dbpgsql.c,db_query: executing query
[SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = '42207']
Apr 5 06:10:39 mail dbmail/imap4d[26201]: dbpgsql.c,db_query: executing query
[SELECT messageblk FROM dbmail_messageblks WHERE physmessage_id = '29087' ORDER
BY messageblk_idnr]
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-message.c,_set_content_from_stream: parse message
Apr 5 06:10:39 mail dbmail/imap4d[26201]:
dbmail-imapsession.c,_imap_cache_update: cache size [1914]
]r 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [BODY[] {1914}
Apr 5 06:10:39 mail dbmail/imap4d[26201]: dbpgsql.c,db_query: executing query
[SELECT seen_flag FROM dbmail_messages WHERE message_idnr = '42207' AND status
< '2' AND mailbox_idnr = '2']
]r 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [)
]r 5 06:10:39 mail dbmail/imap4d[26201]: RESPONSE: [14 OK UID FETCH completed
Apr 5 06:10:39 mail dbmail/imap4d[26201]: imap4.c,IMAPClientHandler: Finished
command uid [0]
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
---------------------------------
On Yahoo!7
Messenger: Make free PC-to-PC calls to your friends overseas.