-----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 > > > -- > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.4.7 (MingW32) > > > > iD8DBQFG5ZiKcGGHuFdGSWARAgAGAKCKKE03bcTFqF9xPp/niZjaW7LHMACfYW3d > > tHWbldIoIpJef+ZIqTMVjjs= > > =lcPe > > -----END PGP SIGNATURE----- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) iD8DBQFG5uOdcGGHuFdGSWARAilBAJ0Xv1TYU8K9PaNTGmZfr6sR14nTtwCffwx7 /sgIPWaH5WlCGsZOO+HOVCQ= =lgdv -----END PGP SIGNATURE-----