connection between the aol server and postgresql database

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

Browse pgsql-admin by date

  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