Thanks Sumbry and Aaron: I have the full 30 July CVS working with MySQL although there are some bugs. I have yet to build it for PgSQL although I have created a database. I can't figure out the problem with Auto-Reply which no longer is functional. I also note that Mozilla Thunderbird's message block fetch is still broken despite some notes in the CVS. I think its a Mozilla quirk.
I have released DbMail Administrator (DBMA) for DbMail CVS/RCnext/2.x It can be obtained from http://library.mobrien.com/dbmailadministrator/ I don't know if you have tried this, [EMAIL PROTECTED] You might find it handy. I have included in the V2.0 tarball package a create tables script for MySQL InnoDB and "NEW-V2-alter_tables.PgSQL" thanks to [Dbmail-dev]:[EMAIL PROTECTED] Have many happy days... best... Mike ----- Original Message ----- From: "Sumbry][" <[EMAIL PROTECTED]> To: "DBMAIL Developers Mailinglist" <[email protected]> Sent: Friday, July 30, 2004 9:13 AM Subject: RE: [Dbmail-dev] Re: Arranging the 2.0rc8 source package > There are still a few problems with the function of the current CVS. > > 1) Has anyone got the latest full CVS actually working correctly using the > new table names? > 2) The current CVS might be a little premature for a candidate release. > > best... Mike I did - only after manually changing all the table names under postgres to dbmail_whatever. AFAIK the latest CVS will not work unless you do this, however there is nothing in the sql-changelog that says this needs to be done. Here's the changes for Postgres: BEGIN TRANSACTION; ALTER TABLE acl RENAME TO dbmail_acl; ALTER TABLE aliases RENAME TO dbmail_aliases; ALTER TABLE auto_notifications RENAME TO dbmail_auto_notifications; ALTER TABLE auto_replies RENAME TO dbmail_auto_replies; ALTER TABLE dups RENAME TO dbmail_dups; ALTER TABLE mailboxes RENAME TO dbmail_mailboxes; ALTER TABLE messageblks RENAME TO dbmail_messageblks; ALTER TABLE messages RENAME TO dbmail_messages; ALTER TABLE pbsp RENAME TO dbmail_pbsp; ALTER TABLE physmessage RENAME TO dbmail_physmessage; ALTER TABLE subscription RENAME TO dbmail_subscription; ALTER TABLE users RENAME TO dbmail_users; END TRANSACTION; Something else I'd like to see before a 2.0 release, is that dbmail has support for Postgres transactions built in, but it's not actually using them anywhere. I see the function calls in db.c, but they're not being used. Actually using transactions would be an enormous performance benefit to dbmail Postgres users. ----- "Any sufficiently advanced bug is indistinguishable from a feature." -- Rich Kulawiec [EMAIL PROTECTED] > > 1) Has anyone got the latest full CVS actually working correctly using the > > new table names? I've been working on the database scripts this week, they're not done. In fact, I just filed a bug because the auto_replies and auto_notifications tables are not correctly upgraded -- they just get zapped and recreated! > Something else I'd like to see before a 2.0 release, is that dbmail has > support for Postgres transactions built in, but it's not actually using > them anywhere. I see the function calls in db.c, but they're not being > used. I don't know why we didn't add these calls into the code yet, but I think it's something that we can do during a point release because it's won't affect any user-visible interfaces. Aaron _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
