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 <[email protected]> wrote: > unsubscribe > > On 30 Aug 2016, at 06:42, Coscend@OM <[email protected]> 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
