Postfix(chroot) and Postgresql

2007-11-30 Thread Bengt Frost
Hi, I am trying to use PostgreSQL as a backend for my Postfix virtual mail system and dovecot(psql) for smtp-auth. 'Postfix' is chrooted - most of it - and with MySQL socket there is no problem to auth users and use Postfix transport_maps and virtual_*_maps. I have problem with postgresql sock

Re: Postfix(chroot) and Postgresql

2007-11-30 Thread Bengt Frost
Thanks, Not sure if this mail is showing in correct thread - lost your mail att google server. On Fri, Nov 30, 2007 at 10:15:29PM +, Craig Skinner wrote: > On Fri, Nov 30, 2007 at 10:33:04PM +0100, Bengt Frost wrote: > > > > Someone out there have any suggestions how use Postfix (and Dovec

Re: Postfix(chroot) and Postgresql

2007-11-30 Thread Bengt Frost
Ok, Efficiency can sometimes be important. Had no idea about this solution - have to figure out how to do it. Thanks! Is OpenLDAP something to consider. --bfrost Genadijus Paleckis wrote: Instead of that I would recommend you to use DB files generated at regular intervals instead of 'online

Re: Postfix(chroot) and Postgresql

2007-11-30 Thread Craig Skinner
On Fri, Nov 30, 2007 at 10:33:04PM +0100, Bengt Frost wrote: > > Someone out there have any suggestions how use Postfix (and Dovecot) > with PostgreSQL? Pull the user data from PostgreSQL and generate the files: /etc/sasldb2.db (copy to /var/spool/postfix/etc && postfix reload) /etc/cram-md5.pwd

Re: Postfix(chroot) and Postgresql

2007-11-30 Thread Bengt Frost
*Addition* to above: In pg_hba.conf (PosgreSQL): vmail(user) access to datab with md5 password local(and host) --bfrost Bengt Frost wrote: Hi, I am trying to use PostgreSQL as a backend for my Postfix virtual mail system and dovecot(psql) for smtp-auth. 'Postfix' is chrooted - most of it - a

Re: Postfix(chroot) and Postgresql

2007-11-30 Thread Genadijus Paleckis
Instead of that I would recommend you to use DB files generated at regular intervals instead of 'online' access to postgresql. It is less CPU expensive and much faster. But if you wish to use SQL maps I guess you may want to use 127.0.0.1 instead of local socket and of course you need to configu

Re: Postfix(chroot) and Postgresql

2007-12-01 Thread Craig Skinner
On Sat, Dec 01, 2007 at 12:07:54AM +0100, Bengt Frost wrote: > > > > > > Someone out there have any suggestions how use Postfix (and Dovecot) > > > with PostgreSQL? > > > > Pull the user data from PostgreSQL and generate the files: > > /etc/sasldb2.db (copy to /var/spool/postfix/etc && postfix relo

Re: Postfix(chroot) and Postgresql

2007-12-01 Thread Bengt Frost
Thanks! I have underestimate the use of flat files and you have give me useful tips. I have to refresh my perl programming - lately most C and Python (and sh of course ...) --bfrost (fvp.se, fvp.eu, fvpideas.com) P.S I am not sure if this gets through to misc mailinglist - sending from my mailse

Re: Postfix(chroot) and Postgresql

2007-12-25 Thread badeguruji
openbsd.org Sent: Saturday, December 1, 2007 7:12:54 AM Subject: Re: Postfix(chroot) and Postgresql On Sat, Dec 01, 2007 at 12:07:54AM +0100, Bengt Frost wrote: > > > > > > Someone out there have any suggestions how use Postfix (and Dovecot) > > > with PostgreSQL? > &

Re: Postfix(chroot) and Postgresql

2007-12-25 Thread johan beisser
On Dec 25, 2007, at 12:57 PM, badeguruji wrote: I want to setup postfix and dovecot. i want to authenticate my users thru ldap. for that i have installed openldap server package. Is there a place where i can find some 'ponited' help on how to build such an 'email users' database? i do not wa

Re: Postfix(chroot) and Postgresql

2007-12-26 Thread Stuart Henderson
aig Skinner <[EMAIL PROTECTED]> > Sent: Saturday, December 1, 2007 7:12:54 AM > Subject: Re: Postfix(chroot) and Postgresql > > > How about - using OpenLDAP? > > Same thing. Flat files are fast and reliable [...] To add to Craig's comment from the mail you quoted, they're also a lot simpler.

Re: Postfix(chroot) and Postgresql

2007-12-26 Thread Marc Balmer
badeguruji wrote: [...] i am searching on google and have not found anything yet. i am therefore looking into generic ldap manuals. (i do not want to be a ldap guru) I maintaining some larger email installations that use LDAP. If you are not willing/don't want to dig deep into the matter, th