Mailing-List: contact dev-help@openmeetings.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openmeetings.apache.org
Subject: Re: OM3.1.2 Restore Error:  Seeking Help
References: <000001d20278$f2d74150$d885c3f0$@Coscend.com>
From: seba.wagner@gmail.com
Content-Type: text/plain;
	charset=us-ascii
In-Reply-To: <000001d20278$f2d74150$d885c3f0$@Coscend.com>
Message-Id: <BB37C17D-E2C2-4772-B8B5-7EA2EE508273@gmail.com>
Date: Tue, 30 Aug 2016 17:18:13 +1200
To: dev@openmeetings.apache.org
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (1.0)
archived-at: Tue, 30 Aug 2016 05:18:27 -0000

Those are all db connectivity errors.

So you user/pass/host/Db-name invalid or permission issues.

Thanks
Sebastian=20

Sent from my iPhone

> On 30/08/2016, at 4:42 PM, Coscend@OM <OM.Insights@Coscend.com> wrote:
>=20
> Dear OpenMeetings Developers,
>=20
>=20
>=20
> 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 connectio=
n
> refused error.  We would appreciate any vectors to resolve the issue.  Bel=
ow
> are the use case, the commands we are using, resulting errors and error lo=
g.
>=20
>=20
>=20
>=20
> ---------
>=20
> USE CASE
>=20
> ---------
>=20
> 1. Compiled, installed and configured OM 3.1.2.  Environment: CentOS 7.3,
> MariaDB 10.x, JDK 1.8_u102
>=20
> 2. Declared environmental variables: =20
>=20
> $RED5_HOME=3D[path_to_dist/red5]
>=20
> $OM_CONTEXT=3D[installation_name_in_webapps]
>=20
> 3. For backing up: ./admin.sh -v -b -file test.data.backup.zip
>=20
> 4. Compiled and installed another instance of OM 3.1.2.
>=20
> 5. For restoring:  ./admin.sh -v -i -file test.data.backup.zip --db-type
> mysql --drop --db-name test_db_312
>=20
>=20
>=20
> ----------
>=20
> Result:  3 ERRORS
>=20
> ----------
>=20
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed
>=20
> 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?
>=20
> .
>=20
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Coul=
d
> not create connection to database server. Attempted reconnect 3 times.
> Giving up.
>=20
> .
>=20
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Acce=
ss
> denied for user ''@'localhost' to database 'test_db_312'
>=20
>=20
>=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> ERROR LOG
>=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed
>=20
> 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=3Dtrue&useUnicode=3D=
true&
> createDatabaseIfNotExist=3Dtrue&characterEncoding=3Dutf-8&connectionCollat=
ion=3Dut
> f8_general_ci&cachePrepStmts=3Dtrue&cacheCallableStatements=3Dtrue&cacheSe=
rverCo
> nfiguration=3Dtrue&useLocalSessionState=3Dtrue&elideSetAutoCommits=3Dtrue&=
alwaysSe
> ndSetIsolation=3Dfalse&enableQueryTimeouts=3Dfalse&prepStmtCacheSize=3D300=
0&prepSt
> mtCacheSqlLimit=3D1000".  You may have specified an invalid URL.
>=20
>       at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataS=
ou
> rceFactory.java:272)
>=20
>       at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataS=
ou
> rceFactory.java:258)
>=20
>       at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getConnectionFactory(JD=
BC
> ConfigurationImpl.java:733)
>=20
>       at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource(JDBCConfi=
gu
> rationImpl.java:878)
>=20
>       at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDataSource2(JDBCConf=
ig
> urationImpl.java:920)
>=20
>       at
> org.apache.openjpa.jdbc.schema.SchemaTool.<init>(SchemaTool.java:132)
>=20
>       at org.apache.openmeetings.cli.Admin.runSchemaTool(Admin.java:475)
>=20
>       at org.apache.openmeetings.cli.Admin.immediateDropDB(Admin.java:500)=

>=20
>       at org.apache.openmeetings.cli.Admin.dropDB(Admin.java:466)
>=20
>       at org.apache.openmeetings.cli.Admin.process(Admin.java:268)
>=20
>       at org.apache.openmeetings.cli.Admin.main(Admin.java:528)
>=20
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Coul=
d
> not create connection to database server. Attempted reconnect 3 times.
> Giving up.
>=20
>       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>=20
>       at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcc=
es
> sorImpl.java:62)
>=20
>       at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr=
uc
> torAccessorImpl.java:45)
>=20
>       at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>=20
>       at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
>=20
>       at com.mysql.jdbc.Util.getInstance(Util.java:387)
>=20
>       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917)
>=20
>       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
>=20
>       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
>=20
>       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
>=20
>       at
> com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2163)=

>=20
>       at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2088)
>=20
>       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
>=20
>       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
>=20
>       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>=20
>       at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcc=
es
> sorImpl.java:62)
>=20
>       at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr=
uc
> torAccessorImpl.java:45)
>=20
>       at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>=20
>       at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
>=20
>       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410=
)
>=20
>       at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)=

>=20
>       at
> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getSimpleConnection(=
Si
> mpleDriverDataSource.java:91)
>=20
>       at
> org.apache.openjpa.jdbc.schema.AutoDriverDataSource.getConnection(AutoDriv=
er
> DataSource.java:39)
>=20
>       at
> org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(Simple=
Dr
> iverDataSource.java:60)
>=20
>       at
> org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingD=
at
> aSource.java:116)
>=20
>       at
> org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingD=
at
> aSource.java:92)
>=20
>       at
> org.apache.openjpa.jdbc.schema.DataSourceFactory.installDBDictionary(DataS=
ou
> rceFactory.java:250)
>=20
>       ... 9 common frames omitted
>=20
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Acce=
ss
> denied for user ''@'localhost' to database 'test_db_312'
>=20
>       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>=20
>       at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcc=
es
> sorImpl.java:62)
>=20
>       at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr=
uc
> torAccessorImpl.java:45)
>=20
>       at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
>=20
>       at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
>=20
>       at com.mysql.jdbc.Util.getInstance(Util.java:387)
>=20
>       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
>=20
>       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
>=20
>       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
>=20
>       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
>=20
>       at com.mysql.jdbc.MysqlIO.changeDatabaseTo(MysqlIO.java:1958)
>=20
>       at
> com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO=
.j
> ava:1890)
>=20
>       at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228)
>=20
>       at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
>=20
>       at
> com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)=

>=20
>       ... 25 common frames omitted
>=20
>=20
>=20
> Thank you.
>=20
>=20
>=20
> Sincerely,
>=20
>=20
>=20
> Hemant K. Sabat
>=20
>=20
>=20
> Coscend Communications Solutions
>=20
> Web site:  <http://www.coscend.com/> www.Coscend.com=20
>=20
> ------------------------------------------------------------------
>=20
> 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=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20