[opencms-dev] post upgrade to OpenCms 8.5.1 - external mysql database pool do not work anymore - (configuration/log inside) pls help

[always.work.in.progress always.work.in.progress]

hi all,
i successfully upgraded our system (linux centos 5+mysql
5+apache-tomcat-5.5.25+java 1.6+opencms multisite environment)
from opencms 7.5.3 to opencms 8.5.1, no installation errors, nor problems;

all seems to work, except the external mysql database pool configured in
file "opencms.properties" :((

when i start opencms in the "opencms.log" file i can see the related
following lines:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
1, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
2, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
3, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
4, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
5, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
6, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
7, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
8, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
9, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 345] . Wait for DB          :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name), attempt
10, wait 5,000 ms.
INFO [      org.opencms.db.CmsDbPool: 358] . Init. JDBC pool     :
opencms:test_db_name (jdbc:mysql://192.168.1.20:3306/test_db_name)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

then opencms log goes ahead without successfully initialize "test_db_name";

i do confirm that all external db worked properly&perfectly in previous
opencms version 7.5.3 !

here it is configured lines inside "opencms.properties" related to
"test_db_name", actually
configured in mysql server(obviously not the same machine where opencms is
installed) with ip address: 192.168.1.20

# Configuration of the driver manager
#################################################################################
driver.vfs=db
driver.project=db
driver.user=db
driver.history=db
#
# Declaration of database pools
#################################################################################
db.pools=\
    default,\
    test_db_name

# Configuration of the database driver manager
#################################################################################
db.name=mysql_41

db.vfs.driver=org.opencms.db.mysql.CmsVfsDriver
db.vfs.pool=opencms:default
db.vfs.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.project.driver=org.opencms.db.mysql.CmsProjectDriver
db.project.pool=opencms:default
db.project.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.user.driver=org.opencms.db.mysql.CmsUserDriver
db.user.pool=opencms:default
db.user.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.history.driver=org.opencms.db.mysql.CmsHistoryDriver
db.history.pool=opencms:default
db.history.sqlmanager=org.opencms.db.mysql.CmsSqlManager

db.cos.pool=opencms:default

# Configuration of the test_db_name database pool
#################################################################################
# name of the JDBC driver
db.pool.test_db_name.jdbcDriver=org.gjt.mm.mysql.Driver

# URL of the JDBC driver
db.pool.test_db_name.jdbcUrl=jdbc:mysql://192.168.1.20:3306/test_db_name

# optional parameters for the URL of the JDBC driver
#db.pool.test_db_name.jdbcUrl.params=?characterEncoding\=UTF-8

# user name to connect to the database
db.pool.test_db_name.user=db_user

# password to connect to the database
db.pool.test_db_name.password=db_password

# the URL to make the JDBC DriverManager return connections from the DBCP
pool
db.pool.test_db_name.poolUrl=opencms:test_db_name

# the maximum number of objects that can be borrowed from the pool
db.pool.test_db_name.maxActive=25

# the maximum amount of time before throwing an exception when the pool is
exhausted
db.pool.test_db_name.maxWait=2000

# the minimum number of objects that will kept connected
db.pool.test_db_name.minIdle=3

# the maximum number of objects that can sit idled in the pool
db.pool.test_db_name.maxIdle=10

# action to take when the pool is exhausted {grow|block|fail}
db.pool.test_db_name.whenExhaustedAction=grow

# connections will be validated before they are borrowed from the pool
db.pool.test_db_name.testOnBorrow=false

# connections will be validated by evictor thread
db.pool.test_db_name.testWhileIdle=true

# number of milliseconds to sleep between runs of the evictor thread
# -1 means no idle connection evictor thread will be run
db.pool.test_db_name.timeBetweenEvictionRuns=3600000

# number of connections tested in a run of the evictor thread
db.pool.test_db_name.numTestsPerEvictionRun=3

# minimum amount of time in milliseconds a connection may be idle in the
pool before it is eligable for eviction
db.pool.test_db_name.minEvictableIdleTime=1800000

# the query to validate connections
#db.pool.test_db_name.testQuery=SELECT STRUCTURE_ID FROM
CMS_OFFLINE_STRUCTURE WHERE RESOURCE_PATH = '/'
db.pool.test_db_name.testQuery=

#

so i am wondering, is opencms 8.5.1 still compatible with external mysql db
pool ?
if yes, can anyone help me in order to solve the problem above ?

thanks in advance,
bye.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20130418/3addb494/attachment.htm>