Hi everybody!
I need to run postgres db on different host than sipxpbx run.
I've looked over all sturtup scripts and configs and change data or add code
for different postgres hostname, including
/etc/sipxpbx/database/database.xml and sipxconfig.properties.in.
sipxconfig.log:
"2008-12-24 14:01:06,897": INFO:DynamicSessionFactoryBean:743:Building new
Hibernate SessionFactory
"2008-12-24 14:01:36,089":
WARN:BasicResourcePool:1841:com.mchange.v2.resourcepool.basicresourcepool$acquiret...@199f443--
Acquisition Attempt Failed!!! Cle
aring pending acquires. While trying to acquire a needed new resource, we
failed to succeed more than the maximum number of allowed acquisition
attempts (30)
. Last acquisition attempt exception:
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at
org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.<init>(Socket.java:366)
at java.net.Socket.<init>(Socket.java:180)
at org.postgresql.core.PGStream.<init>(PGStream.java:59)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
... 14 more
sipxconfig.properties.in:
[crop]
# ======= BEGIN NEW INSTALLATION SETTINGS =================
#added by petol
sipxconfig.db.host=postgres.local
sipxconfig.db.user=sipxdbuser
sipxconfig.db.url=jdbc:postgresql://postgres.local:5432/SIPXCONFIG
database.xml:
[crop]
<property name="sipxconfig.db.name" value="SIPXCONFIG" />
<property name="sipxconfig.db.host" value="postgres.local" />
<property name="sipxconfig.db.user" value="sipxdbuser" />
<property name="sipxconfig.db.password" value="sipxdbpass" />
<property name="sql.dir" location="${basedir}" />
<property name="sipxpbx.conf.dir" location="${basedir}/.." />
<property name="sipxconfig.db.url"
value="jdbc:postgresql://${sipxconfig.db.host}/${sipxconfig.db.name}" />
<property name="dblink.sql" location="/usr/share/pgsql/contrib/dblink.sql"
/>
[crop]
Note that postgres.local not equal to localhost.
Grateful for any help.
--
/petol
http://kab.tv/rus
_______________________________________________
sipx-users mailing list
[email protected]
List Archive: http://list.sipfoundry.org/archive/sipx-users
Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-users
