Обсуждение: connection between the aol server and postgresql database

Поиск
Список
Период
Сортировка

connection between the aol server and postgresql database

От
"Li Chi"
Дата:
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