On Wed, Sep 12, 2007 at 02:30:07PM +0530, Sandeep Agarwal wrote: > Date: Wed, 12 Sep 2007 14:30:07 +0530 > From: Sandeep Agarwal <[EMAIL PROTECTED]> > Subject: Re: [vchkpw] vpopmail and postgresql > To: vchkpw@inter7.com > > On 9/12/07, Charles Boening <[EMAIL PROTECTED]> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > I'm not sure about the newer versions of vpopmail (still running > > 5.4.10), but you may need to edit the vpgsql.h file. > > > > After you changed the postgresql configs, did you restart the postgresql > > service or HUP the postmaster? > > > > lsof -i | grep postgres > > > > ps ax | grep postmaster > > > > > > Charlie > > > > > > > > > -----Original Message----- > > > From: Marco Spiga [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, September 11, 2007 9:41 AM > > > To: vchkpw@inter7.com > > > Subject: Re: [vchkpw] vpopmail and postgresql > > > > > > On Mon, Sep 10, 2007 at 12:18:34PM -0700, Charles Boening wrote: > > > > Date: Mon, 10 Sep 2007 12:18:34 -0700 > > > > From: Charles Boening <[EMAIL PROTECTED]> > > > > Subject: RE: [vchkpw] vpopmail and postgresql > > > > To: vchkpw@inter7.com > > > > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > > Hash: SHA1 > > > > > > > > > > > > In your pg_hba.conf > > > > > > > > host vpopmail vpopuser 127.0.0.1/32 trust > > > > > > > > > > > > Also, in your postgresql.conf, make sure you enable TCP connections. > > > > listen_addresses = '*' # set appropriately > > > > port = 5432 > > > > > > > Hi Charles! > > > > > > My netstat output is: > > > Active Internet connections (servers and established) > > > Proto Recv-Q Send-Q Local Address Foreign Address > > > State PID/Program name > > > tcp 0 0 127.0.0.1:5432 0.0.0.0:* > > > LISTEN 3508/postmaster > > > udp 0 0 127.0.0.1:32768 127.0.0.1:32768 > > > ESTABLISHED 3508/postmaster > > > > > > If I try to run 'tcpdump -i lo 5432' and I give the command > > vadddomain, > > > I don't see any traffic on loopback interface. > > > > > > Where I can setup vpopmail parameters to work with remote address > > > of postgresql (for example 127.0.0.1 or 172.16.89.4) and one private > > > password of vpopmail database? > > > > > > I tried to create /var/vpopmail/etc/vpopmail.pgsql with this line: > > > localhost|0|vpopuser|password|vpopmail > > > but the status don't change (I think this file is useless). > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Marco Spiga [mailto:[EMAIL PROTECTED] > > > > > Sent: Monday, September 10, 2007 11:28 AM > > > > > To: vchkpw@inter7.com > > > > > Subject: [vchkpw] vpopmail and postgresql > > > > > > > > > > Hello > > > > > > > > > > Please help me!!! > > > > > > > > > > How can I do to work vpopmail with postgresql over socket tcp and > > > > > password authentications? > > > > > > > > > > If I try the command: > > > > > > > > > > /var/vpopmail/bin/vadddomain mydomain.com domainpassword > > > > > > > > > > I have this output message: > > > > > > > > > > > > ------------------------------------------------------------------- > > > > > vauth_open: can't connect: FATAL: Ident authentication failed for > > > > user > > > > > "vpopuser" > > > > > > > > > > Error - Success. Initial open. > > > > > > > ------------------------------------------------------------------- > > > > > > > > > > It work only if I insert in pg_hba.conf this line: > > > > > > > > > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > > > > > > > > > # "local" is for Unix domain socket connections only > > > > > > > > > > local all postgres ident > > sameuser > > > > > local vpopmail vpopuser trust > > > > > > > > > > I have inserted in /var/vpopmail/etc/vpopmail.pgsql this line: > > > > > > > > > > localhost|0|vpopuser|mypassword|vpopmail > > > > > > > > > > I am Sorry for my bad English. > > > > > Please help me!!! > > > > > > > > > > Marco > > i am also using a old version of vpopmail 5.4.13, to connect to > postgres on a remote machine i made the following changes in vpgsql.h > file, the changes are > > /* Edit to match your set up */ > #define DB "vpopmail" > #define DBHOST "hostname" > #define DBUSER "username" > #define DBPASSWD "password" > #define PG_CONNECT "host=" DBHOST " user=" DBUSER " password=" > DBPASSWD " dbname=" DB
Thanks Charles, Thanks Sandeep. With your AID, I have resolved problem!! Marco