Allen, Thanks, I did think as much, but wanted to double check before hassling my hosting company further. I also found this explanation on MySql in case anyone else experiences this: http://dev.mysql.com/doc/refman/5.1/en/blocked-host.html
Cheers email : [EMAIL PROTECTED] homepage : http://www.limlom.com/ Allen Gilliland wrote: > That message doesn't suggest anything to do with Roller itself, it > sounds like mysql has simply banned your host from connections for > some reason. You are probably better off check out this problem on > the mysql forums. > > -- Allen > > > Finbar Dineen wrote: >> After working fine for months I've got a problem of three different >> installations of Roller (all on the same host). I'm using Tomcat 5.5.7 >> and MySql 4.1 >> I'm getting the following error message showing in my log files: >> >> INFO 2006-09-01 00:00:00,012 TurnoverReferersTask:run - task started >> INFO 2006-09-01 00:00:02,905 TurnoverReferersTask:run - task completed >> INFO 2006-09-01 00:00:41,752 >> HibernatePlanetManagerImpl:getAggregation - Generated aggregation in >> 6.18 seconds >> ERROR 2006-09-01 00:50:02,633 JDBCExceptionReporter:logExceptions - >> Server connection failure during transaction. Due to underlying >> exception: 'java.sql.SQLException: null, message from server: "Host >> 'www.myhost.com' is blocked because of many connection errors; >> unblock with 'mysqladmin flush-hosts'"'. >> >> ** BEGIN NESTED EXCEPTION ** >> java.sql.SQLException >> MESSAGE: null, message from server: "Host 'www8.kc.aoindustries.com' >> is blocked because of many connection errors; unblock with >> 'mysqladmin flush-hosts'" >> >> STACKTRACE: >> >> java.sql.SQLException: null, message from server: "Host >> 'www8.kc.aoindustries.com' is blocked because of many connection >> errors; unblock with 'mysqladmin flush-hosts'" >> at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:991) >> at com.mysql.jdbc.Connection.createNewIO(Connection.java:2669) >> at com.mysql.jdbc.Connection.<init>(Connection.java:1474) >> at >> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) >> >> at >> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) >> >> at >> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) >> >> at >> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) >> >> at >> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:74) >> >> at >> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) >> >> at >> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) >> >> at >> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59) >> >> at >> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298) >> >> at >> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110) >> >> at >> org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88) >> >> at >> org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162) >> at org.hibernate.loader.Loader.doQuery(Loader.java:390) >> at >> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218) >> >> at org.hibernate.loader.Loader.doList(Loader.java:1593) >> at org.hibernate.loader.Loader.list(Loader.java:1577) >> at >> org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111) >> >> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322) >> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300) >> at >> org.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperty(HibernatePropertiesManagerImpl.java:52) >> >> at >> org.roller.config.RollerRuntimeConfig.getProperty(RollerRuntimeConfig.java:51) >> >> at >> org.roller.config.RollerRuntimeConfig.getBooleanProperty(RollerRuntimeConfig.java:68) >> >> at >> org.roller.config.PingConfig.getSuspendPingProcessing(PingConfig.java:150) >> >> at >> org.roller.presentation.pings.PingQueueProcessor.processQueue(PingQueueProcessor.java:73) >> >> at >> org.roller.presentation.pings.PingQueueTask.run(PingQueueTask.java:65) >> at java.util.TimerThread.mainLoop(Timer.java:512) >> at java.util.TimerThread.run(Timer.java:462) >> >> ================================================ >> >> The only help I can find on this is from: >> http://lists.mysql.com/win32/16598 >> >> But I'm still having problems transalting this into a solution for my >> blog. >> What exactly has happened and how do I go about solving this? >> >>
