Try setting the debug level for imap to 5 in dbmail.conf, and send us some more logs. Possibly mail was inserted only partially after you upgraded, so there may be incomplete messages in your database. If that is the case, and your database conversion was successful, old messages should be retrievable through imap without problems. If old messages are also a problem, your conversion was incomplete.

Who am I 2 be wrote:
Hi again,

I did as you suggested, but this still haven't helped on the error messages I get :(
Still getting theese messages:
Sep 26 20:54:58 moonserv dbmail/imap4d[31083]: db_get_main_header(): error, no header for this message? Sep 26 20:55:00 moonserv dbmail/imap4d[7480]: db_get_main_header(): error, no header for this message? Sep 26 20:55:02 moonserv dbmail/imap4d[7420]: db_get_main_header(): error, no header for this message? Sep 26 20:55:05 moonserv dbmail/imap4d[15234]: db_get_main_header(): error, no header for this message? Sep 26 20:55:09 moonserv dbmail/imap4d[31002]: db_get_main_header(): error, no header for this message? Sep 26 20:55:12 moonserv dbmail/imap4d[24120]: db_get_main_header(): error, no header for this message? Sep 26 20:55:14 moonserv dbmail/imap4d[31083]: db_get_main_header(): error, no header for this message? Sep 26 20:55:18 moonserv dbmail/imap4d[7420]: db_get_main_header(): error, no header for this message? Sep 26 20:55:20 moonserv dbmail/imap4d[15234]: db_get_main_header(): error, no header for this message? Sep 26 20:55:21 moonserv dbmail/imap4d[31002]: db_get_main_header(): error, no header for this message? Sep 26 20:55:24 moonserv dbmail/imap4d[24120]: db_get_main_header(): error, no header for this message?

Other suggestions?  Is there any other changes I need to do to my db?

Thanks in advance.

O yes. The tables for pre-1.0 and 1.2 are incompatible. I posted an upgrade script about a year ago or so on this list. It's mainly a matter of:

#> mysqladmin create dbmailnew
#> tail +7 sql/mysql/create_tables.mysql | mysql dbmailnew
#> mysqldump -d dbmailnew > dbmailnew.sql

#> mysqladmin create dbmailold
#> mysqldump -d dbmail |mysql dbmailold

#> mysqldump -d dbmailold > dbmailold.sql
#> diff dbmailold.sql dbmailnew.sql

Now start tweaking dbmailold with alter statements and repeat the last two commands until the differences are non-critical (only differences in the indexes are allowed).

If your satisfied with dbmailold use your .mysql_history file to obtain all the alter statements you used. This will be your conversion script. Test it on a fresh database loaded with your pre-1.0 schema, and if your happy with the results (diff is your friend), run it against your active database.


Who am I 2 be wrote:

Hi all,

I'm running dbmail 1.2.10, Mysql 4.0.18 and using sendmail for smtp on a OpenBSD 3.5 box. Things seem to work fine, except I get some strange errors in the maillog. I've upgraded from pre 1.0 dbmail (can't remember what version it was), is there anything I need to do to my database?

Any ideas?

From maillog:


Sep 20 20:06:47 moonserv dbmail/imap4d[4889]: db_get_main_header(): error, no header for this message? Sep 20 20:06:50 moonserv dbmail/imap4d[28750]: db_get_main_header(): error, no header for this message? Sep 20 20:11:34 moonserv dbmail/imap4d[10751]: db_get_main_header(): error, no header for this message? Sep 20 20:11:38 moonserv dbmail/imap4d[27349]: db_get_main_header(): error, no header for this message? Sep 20 20:52:06 moonserv dbmail/imap4d[26192]: db_fetch_headers(): could not init msgfetch Sep 20 20:52:28 moonserv dbmail/imap4d[18453]: db_fetch_headers(): could not init msgfetch Sep 20 20:53:38 moonserv dbmail/imap4d[28750]: db_get_main_header(): error, no header for this message? Sep 20 20:53:41 moonserv dbmail/imap4d[19012]: db_get_main_header(): error, no header for this message? Sep 20 20:56:58 moonserv dbmail/imap4d[1892]: db_fetch_headers(): could not init msgfetch Sep 20 20:58:38 moonserv dbmail/imap4d[27349]: db_get_main_header(): error, no header for this message?

_________________________________________________________________
MSN Messenger http://www.msn.no/computing/messenger Den raskeste veien mellom deg og dine venner

_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


--
  ________________________________________________________________
  Paul Stevens                                         [EMAIL PROTECTED]
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands_______________________________________www.nfg.nl
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


_________________________________________________________________
MSN Hotmail http://www.hotmail.com Med markedets beste SPAM-filter. Gratis!

_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


--
  ________________________________________________________________
  Paul Stevens                                         [EMAIL PROTECTED]
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands_______________________________________www.nfg.nl

Reply via email to