Nová verze WinStrom 10.7 (diskuse)

[filbar]

Tak jsem si nainstaloval novou verzi Winstromu, a hlásí mi:

/etc/init.d/winstrom restart
Restarting services for WinStrom 10 Server winstromjava.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database!
Can't run WinStrom

A v logu mám:

java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
        at cz.winstrom.net.server.tcp.ServerUtils.getJDBCConnection(ServerUtils.java:116)
        at cz.winstrom.net.server.rmi.WinStromConnectorImpl.createAndUpdateCentralDatabase(WinStromConnectorImpl.java:1337)
        at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:193)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:271)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:148)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
        ... 6 more
16:56:13,027 ERROR ServerUtils:121 - Error connecting to the main database
java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
        at cz.winstrom.net.server.tcp.ServerUtils.getJDBCConnection(ServerUtils.java:116)
        at cz.winstrom.net.server.rmi.WinStromConnectorImpl.createAndUpdateCentralDatabase(WinStromConnectorImpl.java:1337)
        at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:193)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:271)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:148)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
        ... 6 more
16:56:13,111 ERROR ServerUtils:219 - Error creating SSL server socket factory
java.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database!
        at cz.winstrom.net.server.tcp.ServerUtils.getJDBCConnection(ServerUtils.java:122)
        at cz.winstrom.net.server.rmi.WinStromConnectorImpl.createAndUpdateCentralDatabase(WinStromConnectorImpl.java:1337)
        at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:193)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:271)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:148)
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
        at cz.winstrom.net.server.tcp.ServerUtils.getJDBCConnection(ServerUtils.java:116)
        ... 4 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
        ... 6 more
16:56:13,120 ERROR WinStromServer:471 - Error starting WinStrom server
java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database!
        at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:220)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:271)
        at cz.winstrom.net.server.WinStromServer.main(WinStromServer.java:148)
Caused by: java.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database!
        at cz.winstrom.net.server.tcp.ServerUtils.getJDBCConnection(ServerUtils.java:122)
        at cz.winstrom.net.server.rmi.WinStromConnectorImpl.createAndUpdateCentralDatabase(WinStromConnectorImpl.java:1337)
        at cz.winstrom.net.server.tcp.ServerUtils.initSSL(ServerUtils.java:193)
        ... 2 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
        at cz.winstrom.net.server.tcp.ServerUtils.getJDBCConnection(ServerUtils.java:116)
        ... 4 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
        ... 6 more

Přitom s předchozí verzi mi to běželo v pohodě.

[Ferš]

Dobrý den,

problém je, že není správně nastavena databáze. Potřebovali bychom vědět více informací:

• jakou distribuci používáte
• jedná se o novou instalaci nebo aktualizaci?
• pokud máte Ubuntu/Debian, co vrací příkaz: pg_lsclusters
• jaký je obsah souboru /etc/winstrom/winstrom-server.xml?

Předem děkuji.

S pozdravem Petr Ferschmann

[filbar]

Používám CentOS 5.4 a jedná se o aktualizaci. Obsah souboru je:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
    <comment>WinStrom server configuration</comment>
    <entry key="host">localhost</entry>
    <entry key="port">5432</entry>
    <entry key="user">dba</entry>
    <entry key="password">7971</entry>
</properties>lt;?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
    <comment>WinStrom server configuration</comment>
    <entry key="host">localhost</entry>
    <entry key="port">5432</entry>
    <entry key="user">dba</entry>
    <entry key="password">7971</entry>
</properties>

V souboru s přístupen do PGSQL mám:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
hostssl    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5

hostssl         all     all             10.0.0.101/24           md5
host    all     all             10.0.0.101/24           md5

[filbar]

Moc se omlouvám za svojí neznalost NATu. Ve stejné době jsem si totiž do stroje, na kterém mi běží Winstrom(a provozuji na něm i NAT) přidal i nové síťové rozhraní a PostgreSQL začala naslouchat na tomto novém rozhraní.