Hello Martin, Dieter >DON'T do this, leave the script alone... > >set >tcpip_socket=true >in file postgresql.conf, usually located in /var/lib/pgsql/data/
I have not made any changes to postgresql.conf
I checked its still like this:
#
# Connection Parameters
#
#tcpip_socket = false
#ssl = false
Also I can connect to template1 through psql command.
Also I can create tables on it through psql command.
Now I think we have to check step by step that problem is in which
layer.
+--------+ +--------+ +------------+ +-----------+
| Script +-->+ DBI +---+-->+ DBD Postgre+--->+ Postgre DB|
+--------+ +--------+ +------------+ +-----------+
As you have told me I checked connection through a simple perl script.
(which I have attached with this email).
But its giving the same errors plus one more starting error. (may give
some hints)
[Wed Jun 19 22:21:39 2002] [error] [client 127.0.0.1] malformed header
from script. Bad header=No such file or directory:
c:/apache/htdocs/sql-ledger/connectwin.pl
[Wed Jun 19 22:21:39 2002] [error] [client 127.0.0.1]
DBI->connect(dbname=YourDBName) failed: connectDBStart() -- socket()
failed: errno=2
[Wed Jun 19 22:21:39 2002] [error] [client 127.0.0.1] No such file or
directory
It seems first error has got some path problem.
What do ya say?
Do you have any other simple script through which I can test.
Thanks. And very grateful for your co-operation.
This is the best opensource support I have ever found. :)
Regards,
saurabh
----- Original Message -----
From: "Martin Lillepuu" <[EMAIL PROTECTED]>
> �hel kenal p�eval (teisip�ev, 18. juuni 2002 10:32) kirjutas Saurabh
Shah:
> > Thanks Dieter,
> > It worked well. :)
> >
> > But now when I try to created pg dataset through admin.pl I get
> > following error:
> >
> > connectDBStart() -- socket() failed: errno=2
> > No such file or directory
>
> have you set postgres to listen tcp connections (add -i option in
startup
> script)?
DON'T do this, leave the script alone...
set
tcpip_socket=true
in file postgresql.conf, usually located in /var/lib/pgsql/data/
/sergio
------------------------------------------------------------------------
----
Bringing you mounds of caffeinated joy
>>> http://thinkgeek.com/sf <<<
_______________________________________________
sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive
http://www.mail-archive.com/[email protected]/
connectwin.pl
Description: Binary data
