Thread: postgre socket - connection error

postgre socket - connection error

From
"Saurabh Shah"
Date:
Hello,

Problem statement: I m getting following error while connecting to
postgresql7.2.1 through DBD:Pg :


[Thu Jun 20 13:15:50 2002] [error] [client 127.0.0.1]
DBI->connect(dbname=template1) failed: connectDBStart() -- socket()
failed: errno=2

[Thu Jun 20 13:15:50 2002] [error] [client 127.0.0.1] No such file or
directory

[Thu Jun 20 13:15:50 2002] [error] [client 127.0.0.1] Error:
<br>connectDBStart() -- socket() failed: errno=2<br>No such file or
directory<br>

[Thu Jun 20 13:15:50 2002] [error] [client 127.0.0.1] Compilation failed
in require at c:\EZPUBL~1\apache\htdocs\SQL-LE~1\admin.pl line 93.


Installed:

I have Windows 2000 os. And have postgresql7.2.1 installed on cygwin on
drive i:. Also I have active perl and apache installed on drive c:.


Details:

Now I think we have to check the problem step by step.

+--------+   +--------+       +------------+    +-----------+
| Script +-->+ DBI    +---+-->+ DBD Postgre+--->+ Postgre DB|
+--------+   +--------+       +------------+    +-----------+
A         B    C      D        E       F        G


(A) Script is perfectly allright. -- no problem (if you have got any
other sample script to test connection of DBD:pg and postgresql then pls
send to me)

(B) I uninstalled DBI -- its giving me proper error that "DBI not
installed". And after I again install the error does not come. So -- no
problem

(C) dbi is installed and same as B -- no problem

(D) when I uninsalled DBD-pg it gave be these errors:

[Thu Jun 20 12:54:45 2002] [error] [client 127.0.0.1] malformed header
from script. Bad header=bin/mozilla:
c:/apache/htdocs/sql-ledger/admin.pl

[Thu Jun 20 12:54:45 2002] [error] [client 127.0.0.1] Unknown error

[Thu Jun 20 12:54:45 2002] [error] [client 127.0.0.1] Compilation failed
in require at c:\apache\htdocs\SQL-LE~1\admin.pl line 93.

In the first error again there seems to be some path problem -- u all
must be knowing better.
Again if I install dbd-pg these errors go away and the prime error (in
the very top of email) comes.
But lets keep this -- A SUSPECT


(E)DBD-Pg . Is there some setting to be done to let DBD-Pg about where
the postgre sql is (eg. Port of postgresql or the pid or the socket
'/tmp/.s.PGSQL.5432')?
Lets also keep this -- A SUSPECT

(F)Same as E -- A SUSPECT

(G)Postgresql7.2.1 has been installed. I can access template1 and can
create table through psql. --- no problem


That leaves us with three suspects:
(D) Connection from DBI to DBD-Pg
(E) DBD-Pg settings etc.
(F) Connection from DBD-Pg to postgre

Any ideas?

Thanks and regards,
saurabh



-----Original Message-----
From: sql-ledger-users-admin@sql-ledger.org
[mailto:sql-ledger-users-admin@sql-ledger.org] On Behalf Of Dieter
Simader
Sent: 19 June 2002 08:15
To: sql-ledger-users@sql-ledger.org
Subject: RE: [SL] for power users a minor problem, errors while
executingadmin.pl

You don't have a template1 database. Try template0 or create a database.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========