You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openmeetings.apache.org by "Coscend@OM" <OM...@Coscend.com> on 2016/08/30 04:42:43 UTC
OM3.1.2 Restore Error: Seeking Help
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
RE: Re: OM3.1.2 Restore Error: Seeking Help
Posted by om...@coscend.com.
Dear Maxim and Sebastian,
Thank you for the guidance.
Sincerely,
Hemant K. Sabat
www.Coscend.com
--------- Original Message --------- Subject: Re: OM3.1.2 Restore Error: Seeking Help
From: "Maxim Solodovnik" <so...@gmail.com>
Date: 8/29/16 11:03 pm
To: "dev" <de...@openmeetings.apache.org>, "OM.Insights@Coscend.com" <OM...@coscend.com>
>>>> Could we import a OM 3.0.7 database content into OM 3.1.2
installation? Do the tables, rows and columns accurately mapped across
3.0.x to 3.1.x? Is there a specific option that needs to be given in
./admin.sh command? Thank you.
yes, import should work as expected
On Tue, Aug 30, 2016 at 12:57 PM, Coscend@OM <OM...@coscend.com>
wrote:
> Dear Maxim,
>
> Thank you for your prompt response. It worked perfectly. For the benefit
> of OM community, below is the summary of issue and resolution [USE CASE].
>
> Could we import a OM 3.0.7 database content into OM 3.1.2 installation?
> Do the tables, rows and columns accurately mapped across 3.0.x to 3.1.x?
> Is there a specific option that needs to be given in ./admin.sh command?
> Thank you.
>
> ===========================================================
> USE CASE: ACCESS DENIED WHILE IMPORTING DATABASE CONTENT
> ===================================
> 1. Compile, install and configure OM 3.1.2. Environment: CentOS 7.3,
> MariaDB 10.x, JDK 1.8_u102
> 2. Declare 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. Compile and install 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 --db-user [username_of_user_in_db]
> --db-pass [password_of_user_in_db]
>
> ----------
> 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'
>
> Sincerely,
>
> Hemant K. Sabat
>
> Coscend Communications Solutions
> Web site: www.Coscend.com <http://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
>
>
>
>
> -----Original Message-----
> From: Maxim Solodovnik [mailto:solomax666@gmail.com]
> Sent: Tuesday, August 30, 2016 12:13 AM
> To: dev <de...@openmeetings.apache.org>; OM.Insights@Coscend.com
> Subject: Re: OM3.1.2 Restore Error: Seeking Help
>
> You need to specify "db-user"/"db-pass" command-line options
>
> On Tue, Aug 30, 2016 at 11:42 AM, Coscend@OM <OM.Insights@coscend.com
> <ma...@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:2
> > 163)
> >
> > 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:2
> > 104)
> >
> > ... 25 common frames omitted
> >
> >
> >
> > Thank you.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Hemant K. Sabat
> >
> >
> >
> > Coscend Communications Solutions
> >
> > Web site: <http://www.coscend.com/> www.Coscend.com <
> http://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
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2016.0.7752 / Virus Database: 4649/12907 - Release Date: 08/29/16
>
--
WBR
Maxim aka solomax
Re: OM3.1.2 Restore Error: Seeking Help
Posted by Maxim Solodovnik <so...@gmail.com>.
>>>> Could we import a OM 3.0.7 database content into OM 3.1.2
installation? Do the tables, rows and columns accurately mapped across
3.0.x to 3.1.x? Is there a specific option that needs to be given in
./admin.sh command? Thank you.
yes, import should work as expected
On Tue, Aug 30, 2016 at 12:57 PM, Coscend@OM <OM...@coscend.com>
wrote:
> Dear Maxim,
>
> Thank you for your prompt response. It worked perfectly. For the benefit
> of OM community, below is the summary of issue and resolution [USE CASE].
>
> Could we import a OM 3.0.7 database content into OM 3.1.2 installation?
> Do the tables, rows and columns accurately mapped across 3.0.x to 3.1.x?
> Is there a specific option that needs to be given in ./admin.sh command?
> Thank you.
>
> ===========================================================
> USE CASE: ACCESS DENIED WHILE IMPORTING DATABASE CONTENT
> ===================================
> 1. Compile, install and configure OM 3.1.2. Environment: CentOS 7.3,
> MariaDB 10.x, JDK 1.8_u102
> 2. Declare 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. Compile and install 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 --db-user [username_of_user_in_db]
> --db-pass [password_of_user_in_db]
>
> ----------
> 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'
>
> Sincerely,
>
> Hemant K. Sabat
>
> Coscend Communications Solutions
> Web site: www.Coscend.com <http://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
>
>
>
>
> -----Original Message-----
> From: Maxim Solodovnik [mailto:solomax666@gmail.com]
> Sent: Tuesday, August 30, 2016 12:13 AM
> To: dev <de...@openmeetings.apache.org>; OM.Insights@Coscend.com
> Subject: Re: OM3.1.2 Restore Error: Seeking Help
>
> You need to specify "db-user"/"db-pass" command-line options
>
> On Tue, Aug 30, 2016 at 11:42 AM, Coscend@OM <OM.Insights@coscend.com
> <ma...@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:2
> > 163)
> >
> > 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:2
> > 104)
> >
> > ... 25 common frames omitted
> >
> >
> >
> > Thank you.
> >
> >
> >
> > Sincerely,
> >
> >
> >
> > Hemant K. Sabat
> >
> >
> >
> > Coscend Communications Solutions
> >
> > Web site: <http://www.coscend.com/> www.Coscend.com <
> http://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
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2016.0.7752 / Virus Database: 4649/12907 - Release Date: 08/29/16
>
--
WBR
Maxim aka solomax
RE: OM3.1.2 Restore Error: Seeking Help
Posted by "Coscend@OM" <OM...@Coscend.com>.
Dear Maxim,
Thank you for your prompt response. It worked perfectly. For the benefit of OM community, below is the summary of issue and resolution [USE CASE].
Could we import a OM 3.0.7 database content into OM 3.1.2 installation? Do the tables, rows and columns accurately mapped across 3.0.x to 3.1.x? Is there a specific option that needs to be given in ./admin.sh command? Thank you.
===========================================================
USE CASE: ACCESS DENIED WHILE IMPORTING DATABASE CONTENT
===================================
1. Compile, install and configure OM 3.1.2. Environment: CentOS 7.3, MariaDB 10.x, JDK 1.8_u102
2. Declare 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. Compile and install 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 --db-user [username_of_user_in_db] --db-pass [password_of_user_in_db]
----------
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'
Sincerely,
Hemant K. Sabat
Coscend Communications Solutions
Web site: www.Coscend.com <http://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
-----Original Message-----
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Tuesday, August 30, 2016 12:13 AM
To: dev <de...@openmeetings.apache.org>; OM.Insights@Coscend.com
Subject: Re: OM3.1.2 Restore Error: Seeking Help
You need to specify "db-user"/"db-pass" command-line options
On Tue, Aug 30, 2016 at 11:42 AM, Coscend@OM <OM.Insights@coscend.com <ma...@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:2
> 163)
>
> 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:2
> 104)
>
> ... 25 common frames omitted
>
>
>
> Thank you.
>
>
>
> Sincerely,
>
>
>
> Hemant K. Sabat
>
>
>
> Coscend Communications Solutions
>
> Web site: <http://www.coscend.com/> www.Coscend.com <http://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
-----
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2016.0.7752 / Virus Database: 4649/12907 - Release Date: 08/29/16
Re: OM3.1.2 Restore Error: Seeking Help
Posted by Maxim Solodovnik <so...@gmail.com>.
You need to specify "db-user"/"db-pass" command-line options
On Tue, Aug 30, 2016 at 11:42 AM, Coscend@OM <OM...@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
Re: OM3.1.2 Restore Error: Seeking Help
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <of...@cmfwebsolutions.com>
wrote:
> unsubscribe
> > On 30 Aug 2016, at 06:42, Coscend@OM <OM...@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
Re: OM3.1.2 Restore Error: Seeking Help
Posted by Craig McFadden <of...@cmfwebsolutions.com>.
unsubscribe
> On 30 Aug 2016, at 06:42, Coscend@OM <OM...@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.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
>
>
>
>
>
>
>
Re: OM3.1.2 Restore Error: Seeking Help
Posted by se...@gmail.com.
Those are all db connectivity errors.
So you user/pass/host/Db-name invalid or permission issues.
Thanks
Sebastian
Sent from my iPhone
> On 30/08/2016, at 4:42 PM, Coscend@OM <OM...@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.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
>
>
>
>
>
>
>