openmeetings-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Coscend@OM" <OM.Insig...@Coscend.com>
Subject OM3.1.2 Restore Error: Seeking Help
Date Tue, 30 Aug 2016 04:42:43 GMT
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 

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message