connection between the aol server and postgresql database
От | Li Chi |
---|---|
Тема | connection between the aol server and postgresql database |
Дата | |
Msg-id | 20000114093855.97505.qmail@hotmail.com обсуждение исходный текст |
Список | 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
В списке pgsql-admin по дате отправления: