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
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
