odd install problem with DBD::Pg

odd install problem with DBD::Pg

am 15.09.2007 02:13:25 von danielmcbrearty

hi

just done a new install of DBD::Pg, on a fresh machine. Have been
through the usual steps ... :

- get it to compile
- set up a test db
- check that I can connect from the command line
- set DBI env variables
- make test

The problem I have is that there is a "no such file" error when
tryingto connect in t/01connect.t

The error says that it is looking for /var/run/.s.blahblah.3222 as a
socket name, and indeed this does not exist. What exists is the
similarly named /var/run/.s.blahblah.3223 and an associated lock file.

I've tried make clean, make ... also restarting postgres.

Everything is upto date modules from the last few days - this server
is only a few weeks old.

What can cause this, and what is the fix?

thanks

Daniel

Re: odd install problem with DBD::Pg

am 17.09.2007 00:57:18 von Greg

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> The error says that it is looking for /var/run/.s.blahblah.3222 as a
> socket name, and indeed this does not exist. What exists is the
> similarly named /var/run/.s.blahblah.3223 and an associated lock file.

Those numbers are usually indicative of the port being used. Make sure
you have the port set to 3223 and not 3222. Usual places to set it are
in the dsn string passed to DBI->connect or the PGPORT environment
variable.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200709161856
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B90 6714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFG7bSkvJuQZxSWSsgRAyFmAJ9IR9bpeMrokNTSOz9yP1UhGfeqjACg gdyD
E8bWVfd8BOTWW/u4ejCaBZ0=
=aHvI
-----END PGP SIGNATURE-----