Paul J Stevens wrote:
Alex,
would you mind putting svn-trunk to the test. I think I've nailed this
sucker. Internal_date values are now initialized by scanning the From_
line. This should make imports from mbox style mailboxes behave as expected.
Used svn revision 2059.
SM version 1.5.1 still produced wrong dates - the time of insertion,
like "8.15 pm".
What I did:
make uninstall previous version, pretty sure the old binaries were gone.
svn checkout https://svn.ic-s.nl/svn/dbmail/trunk/dbmail
############## Checked out revision 2059. #############
autoreconf -i -f
./configure --with-mysql
make
make install
mysql -u dbmail dbmail -p ->
drop database dbmail;
create database dbmail;
mysql -u dbmail dbmail -p < sql/mysql/create_tables.mysql
added users (no forwarding)
/usr/local/sbin/mailbox2dbmail -u a_user -t mbox -m
/root/somepath/a_user -p /usr/local/sbin/dbmail-smtp
dbmail-imapd
Logged in with SM and saw the same dates as with 2.0.9.
Checked in the database, the values in dbmail_datefield look OK. But SM
is using the values from internal_date in dbmail_physmessage and they
are showing the time I inserted the mails via dbmail-smtp! You tried
changing that, didn't you?
I'll debug some errors from the migration now.
... You replied meanwhile: ...
> Did you do the add_*.sql thing? You /need/ the additional tables
> required for 2.1.+
Sorry, but there are none in the sql/mysql directory (they are there for
postgreSQL tho), I think they are already included in the create script:
mysql> show tables;
+---------------------------+
| Tables_in_dbmail |
+---------------------------+
| dbmail_acl |
| dbmail_aliases |
| dbmail_auto_notifications |
| dbmail_auto_replies |
| dbmail_ccfield |
| dbmail_datefield |
| dbmail_fromfield |
| dbmail_headername |
| dbmail_headervalue |
| dbmail_mailboxes |
| dbmail_messageblks |
| dbmail_messages |
| dbmail_pbsp |
| dbmail_physmessage |
| dbmail_referencesfield |
| dbmail_replycache |
| dbmail_replytofield |
| dbmail_sievescripts |
| dbmail_subjectfield |
| dbmail_subscription |
| dbmail_tofield |
| dbmail_usermap |
| dbmail_users |
+---------------------------+
Alex
