Dear OpenMeetings Developers,
We are backing up and restoring database content of OM 3.1.2 from one
instance to another. While restoring, we are getting a database connection
refused error. We would appreciate any vectors to resolve the issue. Below
are the use case, the commands we are using, resulting errors and error log.
---------
USE CASE
---------
1. Compiled, installed and configured OM 3.1.2. Environment: CentOS 7.3,
MariaDB 10.x, JDK 1.8_u102
2. Declared environmental variables:
$RED5_HOME=[path_to_dist/red5]
$OM_CONTEXT=[installation_name_in_webapps]
3. For backing up: ./admin.sh -v -b -file test.data.backup.zip
4. Compiled and installed another instance of OM 3.1.2.
5. For restoring: ./admin.sh -v -i -file test.data.backup.zip --db-type
mysql --drop --db-name test_db_312
----------
Result: 3 ERRORS
----------
[ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed
org.apache.openjpa.util.UserException: A connection could not be obtained
for driver class "com.mysql.jdbc.Driver" and URL
"jdbc:mysql://localhost:3306/test_db_312?
.
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could
not create connection to database server. Attempted reconnect 3 times.
Giving up.
.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access
denied for user ''@'localhost' to database 'test_db_312'
==========
ERROR LOG
=========
[ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed
org.apache.openjpa.util.UserException: A connection could not be obtained
for driver class "com.mysql.jdbc.Driver" and URL
"jdbc:mysql://localhost:3306/test_db_312?autoReconnect=true&useUnicode=true&
createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=ut
f8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerCo
nfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSe
ndSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepSt
mtCacheSqlLimit=1000". You may have specified an invalid URL.
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSou
rceFactory.java:272)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSou
rceFactory.java:258)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JDBC
ConfigurationImpl.java:733)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource(JDBCConfigu
rationImpl.java:878)
at
org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource2(JDBCConfig
urationImpl.java:920)
at
org.apache.openjpa.jdbc.schema.SchemaTool.<init>(SchemaTool.java:132)
at org.apache.openmeetings.cli.Admin.runSchemaTool(Admin.java:475)
at org.apache.openmeetings.cli.Admin.immediateDropDB(Admin.java:500)
at org.apache.openmeetings.cli.Admin.dropDB(Admin.java:466)
at org.apache.openmeetings.cli.Admin.process(Admin.java:268)
at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could
not create connection to database server. Attempted reconnect 3 times.
Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
at
com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2163)
at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2088)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at
org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getSimpleConnection(Si
mpleDriverDataSource.java:91)
at
org.apache.openjpa.jdbc.schema.AutoDriverDataSource.getConnection(AutoDriver
DataSource.java:39)
at
org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(SimpleDr
iverDataSource.java:60)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDat
aSource.java:116)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDat
aSource.java:92)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataSou
rceFactory.java:250)
... 9 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access
denied for user ''@'localhost' to database 'test_db_312'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
at com.mysql.jdbc.MysqlIO.changeDatabaseTo(MysqlIO.java:1958)
at
com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.j
ava:1890)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228)
at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at
com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
... 25 common frames omitted
Thank you.
Sincerely,
Hemant K. Sabat
Coscend Communications Solutions
Web site: <http://www.coscend.com/> www.Coscend.com
------------------------------------------------------------------
CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail
Messages from Coscend Communications Solutions' posted at:
<http://www.coscend.com/Terms_and_Conditions.html>
http://www.Coscend.com/Terms_and_Conditions.html
