Hello David, you have to set max_connections=500 in your my.cnf
Every thread opens it's own SQL connection (this is by design) so with every ASSP thread, you need a bunch new connections. With 7 Threads I actually have around 200 SQL connections (including some for Mailserver and Web apps) Reduce ASSP threads or allow more SQL connection on your SQL-Server. Matti > OK GOt *most* things working, but now I had to bump my mysql > connections to 500. > ASSP is eating 167 connections. Is that normal ? I cant find a setting > for the mysql connection pool limit. > Is there one ? > Thanks for any suggestions. > David A. Lee > [email protected] > http://www.xmlsh.org > On 9/27/2010 6:47 PM, Steve Moffat wrote: >> root/youroldpassword >> >> Sent from my iPad >> >> On Sep 27, 2010, at 6:39 PM, "David"<[email protected]> wrote: >> >>> Thanks for the suggestion. >>> Unfortunately root/nospam4me is not letting me in. >>> Any suggestions on where to look for the default username or how to >>> change it ? >>> >>> David A. Lee >>> [email protected] >>> http://www.xmlsh.org >>> >>> >>> On 9/27/2010 4:46 PM, Scott MacLean wrote: >>>> V2 has been stable and working well for me for years now. I had the >>>> same problem - was using V1 for years, but it simply couldn't handle >>>> the load of spam I was getting. There were growing pains with V2, but >>>> the current version (even the current development version) are stable >>>> and very capable. >>>> >>>> If I remember correctly, the default login id is "root" and the >>>> password is "nospam4me" for a new installation. I suspect it is >>>> considering your installation to be a new one, as I think V2 stores >>>> login information differently than V1. >>>> >>>> At 04:35 PM 9/27/2010, David wrote: >>>> >>>> >>>>> I've been running ASSP 1.x for years. >>>>> This week it started haning on me about once an hour and I have to kill >>>>> -9 it. My systsem has a moderate volume of spam and I noticed assp V2 >>>>> is multi-threaded and is now released. >>>>> I would like to try out ASSP V2 . >>>>> >>>>> I tried installing ASSPV2 from scratch then copied over my assp.cfg file >>>>> from my V1 directory. It started fine and seemed to be workign, but I >>>>> cannot login to the web panel, it has removed my admin ID and seems to >>>>> have put it into a DB somewhere. >>>>> >>>>> How do I set the admin user/password ? >>>>> Is ASSPV2 ready to use ? or am I being too ambitious. >>>>> >>>>> Thank you >>>>> >>>>> -- >>>>> David A. Lee >>>>> [email protected] >>>>> http://www.xmlsh.org >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Start uncovering the many advantages of virtual appliances >>>>> and start using them to simplify application deployment and >>>>> accelerate your shift to cloud computing. >>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>> _______________________________________________ >>>>> Assp-test mailing list >>>>> [email protected] >>>>> https://lists.sourceforge.net/lists/listinfo/assp-test >>>> >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> _______________________________________________ >>>> Assp-test mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/assp-test >>>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Assp-test mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/assp-test >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Assp-test mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/assp-test >> > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Assp-test mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/assp-test -- Matti Haack - Hit Haack IT Service Gmbh Poltlbauer Weg 4, D-94036 Passau Geschäftsführer: Henry Haack HRB Passau Nr. 5678 +49 851 50477-22 Fax: +49 851 50477-29 http://www.haack-it.de ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
