So I upgrade to the latest 3.0.14 (com.mysql.jdbc.Driver) and I start getting connection errors. Fortunately, I can change my privileges in mysql to account for the host that it does not want to allow to connect. Here's the odd thing. It's seeing the host name as something other than what our host name is set for.
Does anyone know if this setting for the host is controlled by mysql or where is servoy getting this host name from? I'm suspect that it's the Tomcat server that Servoy runs that is passing the odd host name to the db server. Here is some of the output from the Servoy server.
- Code: Select all
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
Our server host name is not isoproductionsinc. but rather another name. (See error above or at end below)
- Code: Select all
[root@server servoy]# sh ./servoy_server.sh
Looking for servoy.properties on /root/servoy.properties
Loading servoy.properties from /home/servoy/servoy.properties
Loading - Done
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
at com.servoy.j2db.persistence.datasource.l.createConnection(Unknown Source)
at com.servoy.j2db.persistence.datasource.p.makeObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.h.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.b3(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.l.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getSolution(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.persistence.Repository.loadAllSolutionsCompletlyInMem(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.main(Unknown Source)
Caused by: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:645)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1771)
at com.mysql.jdbc.Connection.<init>(Connection.java:440)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
... 17 more
( the above errors repeated many times...)
Using RMI registry on port 1099
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Starting service Tomcat-Apache
Apache Tomcat/4.0.1
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
DBCP borrowObject failed: java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'isoproductionsinc.' is not allowed to connect to this MySQL server"
Final get connection failure for server isonuke in 6 times