Paul J Stevens wrote:
Tom Allison wrote:
I may have buggered my configuration file but I am trying to switch an
installation from postgresql to sqlite.
But the configuration file is written in terms of the hostname and port,
not the sqlite file location.
Also, and probably minor, the debian package for 2.2 sets the dbmail
user $HOME=/dev/null, which makes it a little harder to use dbmail with
sqlite. I can get around this one well enough.
Why? The homedir for the dbmail user is not relevant. File access is.
But what syntax do I use in the configuration file, dbmail.conf?
I use:
install -d -o dbmail -g dbmail -m 2700 /var/lib/dbmail
ignore the host/user/port settings in dbmail.conf and just define db:
db=/var/lib/dbmail/dbmail.sqlite
sqlite3 /var/lib/dbmail/dbmail.sqlite <
/usr/share/doc/dbmail-sqlite/examples/create_tables.sqlite
chown dbmail:dbmail /var/lib/dbmail/dbmail.sqlite
start y'r daemons.
And yes: it would be nice if the installer took care of all this.
Consider it a todo on the list.
Thanks. Even this on the website would be helpful. If you check the howto for
postgres and mysql they have this level of information available. sqlite just
says it's supported... :)
