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 A typo on your part? > 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. Stop your mta, and dbmail daemons. Backup your database. Check, check. Fix the dbmail_messageblks table: pgsql dbmail < sql/postgresql/migrate_2.0_to_2.1.pgsql 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 Populate the new tables: dbmail-util -by start the daemons, verify using your favorite mail client. try inserting a test message manually: cat testmsg.eml | dbmail-smtp -u youruser Only now restart your mta... And all the while: make sure you deinstall old binaries and libraries before running code from SVN! Good luck. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
