On Thu, 9 Apr 2009 07:49:27 +0200 (CEST) Vincent Torri <vto...@univ-evry.fr> wrote:
> > Hey, > > 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 :) > > " > <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
