| Author |
Message |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 20 Oct 2006 19:21:14
|
Anonymous
|
Hi,
I did try installing postgresql8.1.5 source and pgpool-II on my virtual machine FC5. This time I did not have any problem.
My question is now do I need to do anything with edb's libpq.so.4 or libpq/s. Once I installed postges8.1.5 from source do they link static or dynamic to edb libpqs.
It installed pgpool ok, but now I am having problem to connect through pgpool with web application. I do not get any error but keep trying to login no end, then I stop it.
Just wanted to know what happens to libpq/s?
thanks
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 20 Oct 2006 20:15:33
|
shoaib1
Senior member
![[Avatar]](/images/avatar/9bf31c7ff062936a96d3c8bd1f8f2ff3.png)
Joined: 8 Aug 2007 05:04:08
Messages: 350
Location: Islamabad, Pakistan
Offline
|
Just replace the libpq.so file found in <EnterpriseDB-Install-Dir>/dbserver/lib with the already existing libpq.so.4 and make sure you rename libpq.so with libpq.so.4
Thanks,
|
-- Shoaib Mir Project Analyst EnterpriseDB (www.enterprisedb.com) |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 23 Oct 2006 14:04:15
|
Anonymous
|
Hi,
Here is what I did,
I copied libpq.so.4 to <EnterpriseDB-Install-Dir>/dbserver/lib and rename it to libpq.so.
This did not do any changes, I am still having problem to login through pgpool.But once I stopped Tomcat, it gives this error below from catalina.out.
------------------------------
INFO: ContextListener: contextDestroyed()
Oct 22, 2006 5:53:12 AM org.apache.catalina.realm.JDBCRealm getPassword
SEVERE: Exception performing authentication
com.edb.util.PSQLException: An I/O error occured while sending to the backend.
at com.edb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:426)
at com.edb.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:422)
at com.edb.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:355)
at com.edb.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:270)
at org.apache.catalina.realm.JDBCRealm.getPassword(JDBCRealm.java:546)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:399)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:347)
at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:257)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.cluster.tcp.ReplicationValve.invoke(ReplicationValve.java:346)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.net.SocketException: Socket closed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:21
at java.io.BufferedInputStream.read(BufferedInputStream.java:235)
at com.edb.core.PGStream.ReceiveChar(PGStream.java:241)
at com.edb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1472)
at com.edb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:400)
... 20 more
Oct 22, 2006 5:53:12 AM org.apache.catalina.cluster.deploy.FarmWarDeployer stop
INFO: Cluster FarmWarDeployer stopped.
------------------------------
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 25 Oct 2006 10:21:41
|
shoaib1
Senior member
![[Avatar]](/images/avatar/9bf31c7ff062936a96d3c8bd1f8f2ff3.png)
Joined: 8 Aug 2007 05:04:08
Messages: 350
Location: Islamabad, Pakistan
Offline
|
>>An I/O error occured while sending
This means while the Java client was connected to the database, the database server crashed or got restarted.
Please check the database server logs at this specific time when the I/O error comes.
Thank you,
|
-- Shoaib Mir Project Analyst EnterpriseDB (www.enterprisedb.com) |
|
|
 |
|
|