You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Aysha Saddiqa <ay...@yahoo.com> on 2013/02/28 08:24:48 UTC
Could not create connection to database server
Hi,
I can access the Openmeetings database manually via the command line using something like;
C:\Users\Administrator>mysql -u openmeetings -ppassword openmeetings
But the OpenMeetings red5 script is returning errors “Could not create connection to database server” in the openmeetings_log file;
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) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2367) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.23-bin.jar:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) ~[mysql-connector-java-5.1.23-bin.jar:na]
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-jar-1.4.jar:1.4]
... 51 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:673) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1084) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2306) ~[mysql-connector-java-5.1.23-bin.jar:na]
... 65 common frames omitted
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3052) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:597) ~[mysql-connector-java-5.1.23-bin.jar:na]
... 68 common frames omitted
Thanks,
Aysha
Re: Could not create connection to database server
Posted by Kamran Asif <ka...@gmail.com>.
aoa
aysha restart mysql service.....
On Thu, Feb 28, 2013 at 12:24 PM, Aysha Saddiqa <ay...@yahoo.com>wrote:
> Hi,
>
> I can access the Openmeetings database manually via the command line using
> something like;
> C:\Users\Administrator>mysql -u openmeetings -ppassword openmeetings
>
> But the OpenMeetings red5 script is returning errors “Could not create
> connection to database server” in the openmeetings_log file;
>
> 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)
> ~[na:1.7.0_11]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]
> at java.lang.reflect.Constructor.newInstance(Unknown
> Source) ~[na:1.7.0_11]
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2367)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_11]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]
> at java.lang.reflect.Constructor.newInstance(Unknown
> Source) ~[na:1.7.0_11]
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> ~[commons-dbcp-jar-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
> ~[commons-dbcp-jar-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
> ~[commons-dbcp-jar-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
> ~[commons-dbcp-jar-1.4.jar:1.4]
> ... 51 common frames omitted
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
>
> The last packet sent successfully to the server was 0 milliseconds ago.
> The driver has not received any packets from the server.
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_11]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]
> at java.lang.reflect.Constructor.newInstance(Unknown
> Source) ~[na:1.7.0_11]
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:673)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1084)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at
> com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2306)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> ... 65 common frames omitted
> Caused by: java.io.EOFException: Can not read response from server.
> Expected to read 4 bytes, read 0 bytes before connection was unexpectedly
> lost.
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3052)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:597)
> ~[mysql-connector-java-5.1.23-bin.jar:na]
> ... 68 common frames omitted
>
> Thanks,
>
> Aysha
>
RE: Could not create connection to database server
Posted by George Kirkham <gk...@co2crc.com.au>.
Aysha,
I believe you have already checked this, but can you please check again that you persistence.xml file is configured correctly as per the Username and Password of “C:\Users\Administrator>mysql -u openmeetings -ppassword openmeetings”
Can you please check your
C:\red5\webapps\openmeetings\WEB-INF\classes\META-INF\ persistence.xml
And see if the file contains something like the below details, but uses your OpenMeetings Username and Password.
<property name="openjpa.ConnectionProperties"
value="DriverClassName=com.mysql.jdbc.Driver
, Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000
, MaxActive=100
, MaxWait=10000
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=openmeetings
, Password=password" />
<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema" />
See the below instructions in the Windows installation instructions
https://cwiki.apache.org/confluence/download/attachments/27838216/Installing+OM2.x+On+Windows-XP-7-2003.pdf?version=1&modificationDate=1360929123000
Step 19: Edit Config Files for mysql usage
Locate the following folder:
C:\red5\webapps\openmeetings\WEB-INF\classes\META-INF
Rename persistence.xml to persistence.xml.old
Copy mysql_persistence.xml and rename as persistence.xml
Open persistence.xml in wordpad and change the Username and Password like the following:
, Username=openmeetings
, Password=password"/>
Save the file and we are now ready to start the service.
Thanks,
George Kirkham
From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Friday, 1 March 2013 4:40 AM
To: Openmeetings user-list
Cc: Aysha Saddiqa
Subject: Re: Could not create connection to database server
MySql credentials in persistence.xml are not set
On Fri, Mar 1, 2013 at 12:37 AM, George Kirkham <gk...@co2crc.com.au> wrote:
Hi,
Can anyone assist Aysha with his Windows 7 install ?
What can cause the error;
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
He states that he can access the OpenMeetings database from the command line, so I cannot think what might be causing this.
Is it normal for a Windows install to be connecting through “mysql-connector-java-5.1.23-bin.jar:na”, this is not in my logs for Debian installation, naturally.
Thanks,
George Kirkham
From: Aysha Saddiqa [mailto:ayshasaddiqa@yahoo.com]
Sent: Thursday, 28 February 2013 6:25 PM
To: User Open Meeting
Subject: Could not create connection to database server
Hi,
I can access the Openmeetings database manually via the command line using something like;
C:\Users\Administrator>mysql -u openmeetings -ppassword openmeetings
But the OpenMeetings red5 script is returning errors “Could not create connection to database server” in the openmeetings_log file;
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) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2367) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.23-bin.jar:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) ~[mysql-connector-java-5.1.23-bin.jar:na]
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-jar-1.4.jar:1.4]
... 51 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:673) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1084) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2306) ~[mysql-connector-java-5.1.23-bin.jar:na]
... 65 common frames omitted
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3052) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:597) ~[mysql-connector-java-5.1.23-bin.jar:na]
... 68 common frames omitted
Thanks,
Aysha
--
WBR
Maxim aka solomax
Re: Could not create connection to database server
Posted by Maxim Solodovnik <so...@gmail.com>.
MySql credentials in persistence.xml are not set
On Fri, Mar 1, 2013 at 12:37 AM, George Kirkham <gk...@co2crc.com.au>wrote:
> Hi,****
>
> ** **
>
> Can anyone assist Aysha with his Windows 7 install ?****
>
> ** **
>
> What can cause the error;****
>
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could
> not create connection to database server. Attempted reconnect 3 times.
> Giving up.****
>
> ** **
>
> He states that he can access the OpenMeetings database from the command
> line, so I cannot think what might be causing this. ****
>
> ** **
>
> Is it normal for a Windows install to be connecting through “
> mysql-connector-java-5.1.23-bin.jar:na”, this is not in my logs for
> Debian installation, naturally. ****
>
> ** **
>
> Thanks,****
>
> ** **
>
> George Kirkham****
>
> ** **
>
> ** **
>
> ** **
>
> *From:* Aysha Saddiqa [mailto:ayshasaddiqa@yahoo.com]
> *Sent:* Thursday, 28 February 2013 6:25 PM
> *To:* User Open Meeting
> *Subject:* Could not create connection to database server****
>
> ** **
>
> Hi,****
>
> ** **
>
> I can access the Openmeetings database manually via the command line using
> something like;****
>
> C:\Users\Administrator>mysql -u openmeetings -ppassword openmeetings****
>
> ****
>
> But the OpenMeetings red5 script is returning errors “Could not create
> connection to database server” in the openmeetings_log file;****
>
> ****
>
> 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)
> ~[na:1.7.0_11]****
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]****
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]****
>
> at java.lang.reflect.Constructor.newInstance(Unknown
> Source) ~[na:1.7.0_11]****
>
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2367)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_11]****
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]****
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]****
>
> at java.lang.reflect.Constructor.newInstance(Unknown
> Source) ~[na:1.7.0_11]****
>
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
> ~[commons-dbcp-jar-1.4.jar:1.4]****
>
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
> ~[commons-dbcp-jar-1.4.jar:1.4]****
>
> at
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
> ~[commons-dbcp-jar-1.4.jar:1.4]****
>
> at
> org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
> ~[commons-dbcp-jar-1.4.jar:1.4]****
>
> ... 51 common frames omitted****
>
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure****
>
> ****
>
> The last packet sent successfully to the server was 0 milliseconds ago.
> The driver has not received any packets from the server.****
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_11]****
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]****
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> ~[na:1.7.0_11]****
>
> at java.lang.reflect.Constructor.newInstance(Unknown
> Source) ~[na:1.7.0_11]****
>
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:673)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1084)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at
> com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2306)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> ... 65 common frames omitted****
>
> Caused by: java.io.EOFException: Can not read response from server.
> Expected to read 4 bytes, read 0 bytes before connection was unexpectedly
> lost.****
>
> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3052)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:597)
> ~[mysql-connector-java-5.1.23-bin.jar:na]****
>
> ... 68 common frames omitted****
>
> ** **
>
> Thanks,****
>
> ** **
>
> Aysha****
>
--
WBR
Maxim aka solomax
RE: Could not create connection to database server
Posted by George Kirkham <gk...@co2crc.com.au>.
Hi,
Can anyone assist Aysha with his Windows 7 install ?
What can cause the error;
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
He states that he can access the OpenMeetings database from the command line, so I cannot think what might be causing this.
Is it normal for a Windows install to be connecting through “mysql-connector-java-5.1.23-bin.jar:na”, this is not in my logs for Debian installation, naturally.
Thanks,
George Kirkham
From: Aysha Saddiqa [mailto:ayshasaddiqa@yahoo.com]
Sent: Thursday, 28 February 2013 6:25 PM
To: User Open Meeting
Subject: Could not create connection to database server
Hi,
I can access the Openmeetings database manually via the command line using something like;
C:\Users\Administrator>mysql -u openmeetings -ppassword openmeetings
But the OpenMeetings red5 script is returning errors “Could not create connection to database server” in the openmeetings_log file;
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) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2367) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2288) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.23-bin.jar:na]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) ~[mysql-connector-java-5.1.23-bin.jar:na]
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) ~[commons-dbcp-jar-1.4.jar:1.4]
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ~[commons-dbcp-jar-1.4.jar:1.4]
... 51 common frames omitted
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_11]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_11]
at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_11]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:673) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1084) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2306) ~[mysql-connector-java-5.1.23-bin.jar:na]
... 65 common frames omitted
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3052) ~[mysql-connector-java-5.1.23-bin.jar:na]
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:597) ~[mysql-connector-java-5.1.23-bin.jar:na]
... 68 common frames omitted
Thanks,
Aysha