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
