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" " <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 ? 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
