From: | "Li Chi" <li__chi(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | connection between the aol server and postgresql database |
Date: | 2000-01-14 01:38:55 |
Message-ID: | 20000114093855.97505.qmail@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi, all,
I installed aol server 2.3.3 and postgresql 6.5.3 on my sparc machine with
solaris 2.7. Since I had no cc compiler installed and no root privilege, I
had to copy tclConfig.sh and change TCL_CC='gcc' and
TCL_SHLIB_CFLAGS='-fPIC'. I can compile and install postgresql. there were
no problem when I nohup postmaster -i &, createdb, psql in my sparc machine.
I also modified the pg_hba.conf to allow all to access my database. The
version of tcl is 8.2. I used the database driver AOLserver/bin/postgres.so
to connect to the postgrsql
However, when I accessed the database throught aolserver web base
administration page. It failed and the aol server died. the terminal running
posgres has following message:
pq_recvbuf: unexpected EOF on client connection
the log of aol server is as following:
[14/Jan/2000:16:53:19 +0800][19910.11][server1] Notice:
Ns_DbOpenDb(postgres): Opening datasource: 137.189.xx.xx:5432:foo
[14/Jan/2000:16:53:19 +0800][19910.11][server1] Notice: Opening foo on
137.189.xx.xx, port 5432
[14/Jan/2000:16:53:20 +0800][19910.11][server1] Notice:
Ns_PgOpenDb(postgres): Openned connection to 137.189.xx.xx:5432:foo.
[14/Jan/2000:16:53:20 +0800][19910.11][server1] Notice: Querying 'set
datestyle to 'ISO';'
[14/Jan/2000:16:53:20 +0800][19910.11][server1] Notice: Querying 'SELECT
relname FROM pg_class WHERE relkind = 'r' and relname !~ '^Inv' ORDER BY
relname;'
Which part do you think have problem, AOL server, the driver or the
postgresql parts? what is the problem? Any solution?
Thanks for your help.
Li Chi
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
From | Date | Subject | |
---|---|---|---|
Next Message | Strand Johan F. | 2000-01-14 12:08:49 | Password |
Previous Message | Li Chi | 2000-01-13 06:20:41 | Can not connect to postgresql database |