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-----

Reply via email to