Thanks. I've temporarily removed the connection limit to mysql. I'll monitor for a while and try and come up with a new limit.
On 9/28/2011 9:36 PM, Jeremy McSpadden wrote: > Edit your my.cnf and bump up the max connections then restart mysql. > > > -- > Jeremy McSpadden > > On Sep 28, 2011, at 8:23 PM, "Paul Houlbrooke"<[email protected]> > wrote: > >> >> I'm having trouble importing my Penalty Box files in MySQL. I keep >> getting errors about there being to many connections. Everything else is >> working fine with MySQL, just the pb is having trouble. >> >> Sep-28-11 21:01:12 [init] Starting SMTP-worker-threads with >> ThreadCycleTime set to 3000 microseconds >> Sep-28-11 21:01:12 [init] Starting communication worker threads [1 to 5] >> Sep-28-11 21:01:21 [Worker_1] Worker_1 started >> Sep-28-11 21:01:21 [Worker_2] Ldaplist database error: TIEHASH: Can't >> open dbi:mysql:database=assp;host=localhost, Too many connections at >> c:\assp\assp.pl line 8122 thread 4 >> Sep-28-11 21:01:21 [Worker_2] Worker_2 started >> Sep-28-11 21:01:21 [Worker_3] Worker_3 started >> Sep-28-11 21:01:21 [Worker_5] Worker_5 started >> Sep-28-11 21:01:21 [Worker_4] Worker_4 started >> Sep-28-11 21:01:21 [init] All Threads are started >> Sep-28-11 21:01:21 [init] Info: CPU priority changed for Worker_10000 >> from 0 to 2 >> Sep-28-11 21:01:21 [init] Info: CPU priority changed for Worker_10001 >> from 0 to 2 >> Sep-28-11 21:01:21 [init] Try using mysql database<assp> for selected >> tables >> Sep-28-11 21:01:21 [init] Using table<whitelist> in mysql >> Database<assp> instead of file c:/assp/whitelist >> Sep-28-11 21:01:21 [init] Using table<redlist> in mysql >> Database<assp> instead of file c:/assp/redlist >> Sep-28-11 21:01:21 [init] Using table<delaydb> in mysql >> Database<assp> instead of file c:/assp/delaydb >> Sep-28-11 21:01:21 [init] Using table<delaywhitedb> in mysql >> Database<assp> instead of file c:/assp/delaydb.white >> Sep-28-11 21:01:21 [init] Using table<PBWhite> in mysql >> Database<assp> instead of file c:/assp/pb/pbdb.white.db >> Sep-28-11 21:01:22 [init] Using table<PBBlack> in mysql >> Database<assp> instead of file c:/assp/pb/pbdb.black.db >> Sep-28-11 21:01:22 [init] Error: Too many connections >> Sep-28-11 21:01:22 [init] MySQL check for table RBLCache canceled! >> Sep-28-11 21:01:22 [init] Using table<RBLCache> in mysql >> Database<assp> instead of file c:/assp/pb/pbdb.rbl.db >> Sep-28-11 21:01:22 [init] Pbdb.uribl.db database error: TIEHASH: Can't >> open dbi:mysql:database=assp;host=localhost, Too many connections at >> c:\assp\assp.pl line 8122 >> Sep-28-11 21:01:22 [init] Warning: can not use defined database - >> switching over to use files instead of database assp! >> Sep-28-11 21:01:22 [init] Error : DB-failover loading hashes from files >> Sep-28-11 21:01:22 [init] Warning : setting configvalue for adminusersdb >> to adminusers >> Sep-28-11 21:01:22 [init] Warning : setting configvalue for adminusersdb >> to adminusers >> Sep-28-11 21:01:22 [init] Info: adminusersdb (c:/assp/) - loaded >> Sep-28-11 21:01:22 [init] Info: adminusersdb (c:/assp/.right) - loaded >> Sep-28-11 21:01:22 [init] Warning: whitelist has only 0 records: (ignore >> if this is a new install) >> >> >> ------------------------------------------------------------------------------ >> All the data continuously generated in your IT infrastructure contains a >> definitive record of customers, application performance, security >> threats, fraudulent activity and more. Splunk takes this data and makes >> sense of it. Business sense. IT sense. Common sense. >> http://p.sf.net/sfu/splunk-d2dcopy1 >> _______________________________________________ >> Assp-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/assp-user >> > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2dcopy1 > _______________________________________________ > Assp-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/assp-user ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Assp-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-user
