ofbiz installation on AIX 6.1

Posted by khindri on
URL: http://ofbiz.116.s1.nabble.com/ofbiz-installation-on-AIX-6-1-tp3912876.html

While running the default ofbiz installation on AIX 6.1 and postgres 9.0 i am getting the following error



org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:276)
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:95)
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
org.postgresql.Driver.makeConnection(Driver.java:386)
org.postgresql.Driver.connect(Driver.java:260)
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
org.apache.commons.dbcp.managed.LocalXAConnectionFactory.createConnection(LocalXAConnectionFactory.java:62)
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:117)
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1270)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1250)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:736)



Its the default setup on AIX only thing is i have changed entityengine.xml to use localpostnew datasource and changed the jdbc connection url and related parameters.

Also changed the algorithm SunX509 to IbmX509 .