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