EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

libpq is not installed or libpq is old  XML

Forum Index » Advanced Server
Author Message
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
shoaib1

Senior member
[Avatar]

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)
[WWW] [MSN]
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.
------------------------------
shoaib1

Senior member
[Avatar]

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)
[WWW] [MSN]
 
Forum Index » Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team