openmeetings-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maxim Solodovnik <solomax...@gmail.com>
Subject Re: OM3.1.2 Restore Error: Seeking Help
Date Tue, 30 Aug 2016 06:44:49 GMT
please use link from here http://openmeetings.apache.org/mail-lists.html to
unsubscribe

On Tue, Aug 30, 2016 at 1:41 PM, Craig McFadden <office@cmfwebsolutions.com>
wrote:

> unsubscribe
> > On 30 Aug 2016, at 06:42, Coscend@OM <OM.Insights@Coscend.com> wrote:
> >
> > 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.proceedHandshakeWithPluggableA
> uthentication(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
> >
> >
> >
> >
> >
> >
> >
>
>


-- 
WBR
Maxim aka solomax

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