MySql credentials in persistence.xml are not set
On Fri, Mar 1, 2013 at 12:37 AM, George Kirkham <[email protected]>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:[email protected]] > *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
