Paul J Stevens <[EMAIL PROTECTED]> wrote: Colin Manning wrote: > O.K. > > I have been over this many many times. The data looks good in the database. > If I telnet to the server and > a login name pass > a select inbox > a fetch 1
That doesn't make any sense at all! a fetch 1 should return: a BAD missing argument(s) to FETCH It does. However A typo on your part? a fetch 1 rfc822 > I get the message - body and all. > However, If I do this from a mail client (evolution, thunderbird, > outlook) I get nothing. > > Sigh. > > If I create another database and start using it (SVN) can I import my > existing database into it? > > Is there a script that will allow me to convert from my current dbmail > (2.0.6) database to some flat file style database retaining all the > folders that I can import to my new database? Not for 2.0.x, but 2.1 contains dbmail-export that will allow you to do just that. > Any help / advice appreciated. Let's assume the upgrade was botched somehow. Cool. Stop your mta, and dbmail daemons. Backup your database. Check, check. Done that - All stopped. Now have at least two verified backups. Fix the dbmail_messageblks table: pgsql dbmail < sql/postgresql/migrate_2.0_to_2.1.pgsql What !?! Where is this file ??? I'm sure I have not seen it. from the directory containing all my dbmail 2.0 and 2.1 src: find . -name migrate* -print ./dbmail/sql/mysql/.svn/text-base/migrate_from_2.0_to_2.1.mysql.svn-base ./dbmail/sql/mysql/.svn/wcprops/migrate_from_2.0_to_2.1.mysql.svn-work ./dbmail/sql/mysql/.svn/prop-base/migrate_from_2.0_to_2.1.mysql.svn-base ./dbmail/sql/mysql/.svn/props/migrate_from_2.0_to_2.1.mysql.svn-work ./dbmail/sql/mysql/migrate_from_2.0_to_2.1.mysql Mmmm. found in SVN. Done. This will make your data unusable from 2.0! Next downgrade your database by dropping and re-creating all the new tables. pgsql dbmail < sql/postgresql/add_*.p[g]sql Done. Populate the new tables: dbmail-util -by O.K. start the daemons, verify using your favorite mail client. try inserting a test message manually: No worries. Logs look good. cat testmsg.eml | dbmail-smtp -u youruser Done. Only now restart your mta... Now send e-mail from yahoo account - Success. now etrn ...... - Success. Now running SVN and sieve better be worth it. And all the while: make sure you deinstall old binaries and libraries before running code from SVN! Good luck. Thank you Paul for all your time and knowledge. Was it the fact that I did not run the 2.0 to 2.1 migration script the first time? -- ________________________________________________________________ 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 Send instant messages to your online friends http://au.messenger.yahoo.com
