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: [email protected] > > -----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: [email protected] > > 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-----
