-----Original Message-----
From: Vincent Torri <vto...@univ-evry.fr> Subj: Re: [E-devel] about trac problems Date: Thu Apr 9, 2009 10:30 Size: 5K To: Nick Hughart <mek...@mekhome.dyndns.org> cc: enlightenment-devel@lists.sourceforge.net On Thu, 9 Apr 2009, Nick Hughart wrote: >> as a lot of us know, we have some problems with trac (password when >> using tickets, lots of cpu consumption, need of removing cookies when >> trying to login, globally very slow, etc...). >> >> I have asked in #trac to have some kind of answers and i put the >> quotes in that mail for posterity. >> >> 1) about cpu consumption, the answer is: do not use CGI, use anything >> else. The advices were: "FastCGI, mod_python, tracd, or mod_wsgi" > > Tried mod_python once and trac went so out of control that the whole > server locked up and we had to have OSUOSL restart it. The only > solution I think will fit us is fastcgi. I know I researched this > before and all the other solutions had lists of problems associated > with them. I know cgi is slow, but time is money as they say and I > have little of both right now :) according to the comment below, mod_python can have issues, and tracd could be a good alternative: http://trac.edgewall.org/wiki/TracStandalone I seem to recall not liking the tracd solution before. Fastcgi should be a huge improvement. Vincent >> " >> <coderanger> to answer the question more fully >> <coderanger> CGI works by re-executing the script every time a URL is >> requested <coderanger> this means Trac has to load itself up for each >> request <coderanger> (loading and activating Trac's in-memory data >> structures is relatively slow compared to simple request handling) >> <coderanger> All the other systems keep the same in-memory data >> around so you only have to do the loading on the first hit >> <coderanger> mod_py is generally the easiest to setup, but has more >> potential issues >> <coderanger> mod_py == mod_python == modpython.org >> <evil_twin> tracdoc is >> https://coderanger.net/~coderanger/tracdoc/install/index.html >> <coderanger> that guide has detailed instructions >> " >> >> maybe not using cgi will also speed up the whole thing. >> >> 2) about problem when login, i (i'm not the only one) have that error: >> >> Traceback (most recent call last): >> File "/usr/lib/python2.4/site-packages/trac/web/api.py", line 339, >> in send_error >> 'text/html') >> File "/usr/lib/python2.4/site-packages/trac/web/chrome.py", line >> 702, in render_template >> if not req.session or not int(req.session.get('accesskeys', 0)): >> File "/usr/lib/python2.4/site-packages/trac/web/api.py", line 169, >> in __getattr__ >> value = self.callbacks[name](self) >> File "/usr/lib/python2.4/site-packages/trac/web/main.py", line >> 257, in _get_session >> return Session(self.env, req) >> File "/usr/lib/python2.4/site-packages/trac/web/session.py", line >> 149, in __init__ >> self.promote_session(sid) >> File "/usr/lib/python2.4/site-packages/trac/web/session.py", line >> 232, in promote_session >> (self.req.authname, int(time.time()))) >> File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, >> in execute return self.cursor.execute(sql_escape_percent(sql), args) >> File "/var/lib/python-support/python2.4/MySQLdb/cursors.py", line >> 166, in execute >> self.errorhandler(self, exc, value) >> File "/var/lib/python-support/python2.4/MySQLdb/connections.py", >> line 35, in defaulterrorhandler >> raise errorclass, errorvalue >> IntegrityError: (1062, "Duplicate entry 'vtorri-0' for key 1") >> >> >> answer: >> >> " >> <coderanger> vtorri: You are using a case-sensitive collation and >> have more than one username (a variant of "vtorri") that differ only >> by case <coderanger> or the inverse >> <coderanger> check what values exist in the table >> " >> >> It seems that it's because we are using SQL. >> >> I don't know what it means (i don't know python or sql or trac), but >> it seems that there is a solution. >> >> Can some admin look at that ? > > I will look at the collation that MySQL is using, but not sure I can > make it case-insensitive. This must be something they depend on from > sqlite. I'll look into this and see if I can't figure it out. > > Thanks for looking into it with the devs. Hopefully their suggestions > are useful. > >> >> thank you >> >> Vincent >> >> ------------------------------------------------------------------------------ >> This SF.net email is sponsored by: >> High Quality Requirements in a Collaborative Environment. >> Download a free trial of Rational Requirements Composer Now! >> http://p.sf.net/sfu/www-ibm-com >> _______________________________________________ >> enlightenment-devel mailing list >> enlightenment-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/enlightenment-devel > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > High Quality Requirements in a Collaborative Environment. > Download a free trial of Rational Requirements Composer Now! > http://p.sf.net/sfu/www-ibm-com > _______________________________________________ > enlightenment-devel mailing list > enlightenment-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/enlightenment-devel > > -- > Ce message a été vérifié par MailScanner > pour des virus ou des polluriels et rien de > suspect n'a été trouvé. > Message délivré par le serveur de messagerie de l'Université d'Evry. > > ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ enlightenment-devel mailing list enlightenment-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/enlightenment-devel
