Thanks yes I set the max_connections to 500, works no problem. I was just surprised to see > 150 connections used by 7 threads, why would 1 thread need more then 1 connection ?
David A. Lee [email protected] http://www.xmlsh.org On 9/28/2010 5:11 AM, Matti Haack wrote: > 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 > > ------------------------------------------------------------------------------ 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
