<div dir="ltr"><div><div><div><div></div><br></div>hi all,<br>i successfully upgraded our system (linux centos 5+mysql 5+apache-tomcat-5.5.25+java 1.6+opencms multisite environment)<br>from opencms 7.5.3 to opencms 8.5.1, no installation errors, nor problems;<br>
<br>all seems to work, except the external mysql database pool configured in file "opencms.properties" :((<br><br>when i start opencms in the "opencms.log" file i can see the related following lines:<br>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 1, wait 5,000 ms.<br>
INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 2, wait 5,000 ms.<br>INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 3, wait 5,000 ms.<br>
INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 4, wait 5,000 ms.<br>INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 5, wait 5,000 ms.<br>
INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 6, wait 5,000 ms.<br>INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 7, wait 5,000 ms.<br>
INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 8, wait 5,000 ms.<br>INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 9, wait 5,000 ms.<br>
INFO [ org.opencms.db.CmsDbPool: 345] . Wait for DB : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>), attempt 10, wait 5,000 ms.<br>INFO [ org.opencms.db.CmsDbPool: 358] . Init. JDBC pool : opencms:test_db_name (jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a>)<br>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br><br></div><div>then opencms log goes ahead without successfully initialize "test_db_name";</div>
<div><br>i do confirm that all external db worked properly&perfectly in previous opencms version 7.5.3 !<br></div><div><br></div>here it is configured lines inside "opencms.properties" related to "test_db_name", actually<br>
</div>configured in mysql server(obviously not the same machine where opencms is installed) with ip address: 192.168.1.20 <br><div><br># Configuration of the driver manager<br>#################################################################################<br>
driver.vfs=db<br>driver.project=db<br>driver.user=db<br>driver.history=db<br>#<br># Declaration of database pools<br>#################################################################################<br>db.pools=\<br> default,\<br>
test_db_name<br><br># Configuration of the database driver manager<br>#################################################################################<br><a href="http://db.name">db.name</a>=mysql_41<br><br>db.vfs.driver=org.opencms.db.mysql.CmsVfsDriver<br>
db.vfs.pool=opencms:default<br>db.vfs.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br><br>db.project.driver=org.opencms.db.mysql.CmsProjectDriver<br>db.project.pool=opencms:default<br>db.project.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br>
<br>db.user.driver=org.opencms.db.mysql.CmsUserDriver<br>db.user.pool=opencms:default<br>db.user.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br><br>db.history.driver=org.opencms.db.mysql.CmsHistoryDriver<br>db.history.pool=opencms:default<br>
db.history.sqlmanager=org.opencms.db.mysql.CmsSqlManager<br><br>db.cos.pool=opencms:default<br><br># Configuration of the test_db_name database pool<br>#################################################################################<br>
# name of the JDBC driver<br>db.pool.test_db_name.jdbcDriver=org.gjt.mm.mysql.Driver<br><br># URL of the JDBC driver<br>db.pool.test_db_name.jdbcUrl=jdbc:mysql://<a href="http://192.168.1.20:3306/test_db_name">192.168.1.20:3306/test_db_name</a><br>
<br># optional parameters for the URL of the JDBC driver<br>#db.pool.test_db_name.jdbcUrl.params=?characterEncoding\=UTF-8<br><br># user name to connect to the database<br>db.pool.test_db_name.user=db_user<br><br># password to connect to the database<br>
db.pool.test_db_name.password=db_password<br><br># the URL to make the JDBC DriverManager return connections from the DBCP pool<br>db.pool.test_db_name.poolUrl=opencms:test_db_name<br><br># the maximum number of objects that can be borrowed from the pool<br>
db.pool.test_db_name.maxActive=25<br><br># the maximum amount of time before throwing an exception when the pool is exhausted<br>db.pool.test_db_name.maxWait=2000<br><br># the minimum number of objects that will kept connected<br>
db.pool.test_db_name.minIdle=3<br><br># the maximum number of objects that can sit idled in the pool<br>db.pool.test_db_name.maxIdle=10<br><br># action to take when the pool is exhausted {grow|block|fail}<br>db.pool.test_db_name.whenExhaustedAction=grow<br>
<br># connections will be validated before they are borrowed from the pool<br>db.pool.test_db_name.testOnBorrow=false<br><br># connections will be validated by evictor thread<br>db.pool.test_db_name.testWhileIdle=true<br>
<br># number of milliseconds to sleep between runs of the evictor thread<br># -1 means no idle connection evictor thread will be run<br>db.pool.test_db_name.timeBetweenEvictionRuns=3600000<br><br># number of connections tested in a run of the evictor thread<br>
db.pool.test_db_name.numTestsPerEvictionRun=3<br><br># minimum amount of time in milliseconds a connection may be idle in the pool before it is eligable for eviction<br>db.pool.test_db_name.minEvictableIdleTime=1800000<br>
<br># the query to validate connections<br>#db.pool.test_db_name.testQuery=SELECT STRUCTURE_ID FROM CMS_OFFLINE_STRUCTURE WHERE RESOURCE_PATH = '/'<br>db.pool.test_db_name.testQuery=<br><br>#<br><div><br>so i am wondering, is opencms 8.5.1 still compatible with external mysql db pool ?<br>
if yes, can anyone help me in order to solve the problem above ?<br>
<br>thanks in advance,<br>bye.</div></div></div>