8 messages in net.sourceforge.lists.courier-maildropRe: [maildropl] Maildrop and postgres
FromSent OnAttachments
Jonathan ChocronMar 15, 2006 10:19 am 
Ian MacDonaldMar 15, 2006 11:17 am 
Devin RubiaMar 15, 2006 11:22 am 
Devin RubiaMar 15, 2006 11:27 am 
Jonathan ChocronMar 16, 2006 4:58 am 
Devin RubiaMar 16, 2006 6:55 am 
Isaac ZinnerMar 21, 2006 9:04 am 
moussMar 21, 2006 2:16 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [maildropl] Maildrop and postgresActions...
From:Ian MacDonald (ia@ianbmacdonald.com)
Date:Mar 15, 2006 11:17:41 am
List:net.sourceforge.lists.courier-maildrop

Well,

I wish to use maildrop with postgresql. I found two howtos that dealt with mysql and none with postgres.

Looking at the source grep "mysql" * -R | wc -l = 185 grep "postgres" * -R | wc -l = 0

At least with 1.5.3 (Debian Sarge) this is not supported with a simple rebuild.

Mysql howtos state that the config file is /etc/maildrop/maildropmysql.cf, however I could not find any trace of that in the documentation.

Yeah, if you find docs on this, I am trying to configure MailDrop with MySQL and have not found any docs on the maildropmysql.config file, and how it affects the build/run of MailDrop. I'm hoping I can build a maildrop with specific fields (uid/gid/maildir_base) hardcoded, and pull out just the variable data.

Taking this for true, I suppose that the config file for postgres should be : "maildroppgsql.cf".

But is that correct ?

Second question : how can I check whether maildrop is indeed using the DB to authenticate ?

I just uncomment the "log" line in MySQL and watches the queries. Offhand I forget the equivalent for PostGres, but that is probably the easiest way to see the DB connection information.

maildrop -V 9 -d us@domain.com or similar can be used to see the commandline output

iMac