Team Chat Logs

April 15, 2010

2010 3
Mo Tu We Th Fr Sa Su
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30    
<< <   > >>

[00:59:15.554022]<_dave_h_d>in trac reports/sqlite can one do double group by
[01:21:47.915738]<Le_Vert_>hi
[01:21:49.955609]<bionoid>_dave_h_d: GROUP BY a, b, c, .. ?
[01:22:48.215225]<bionoid>hasienda: Cool I just read the wiki, keep up the good work man! This might motivate me to actually install .12 ;-)
[01:23:16.456713]<Le_Vert_>hi mates
[01:23:29.396019]<Le_Vert_>is there anyone who can help me with trac' performance
[01:23:40.051035]<Le_Vert_>I don't know what more to
[01:23:45.060336]<Le_Vert_>and figuring out leaving trac
[01:23:53.489866]<bionoid>hello Le_Vert_ :-) What server tech are you using, ,and what operations are slow?
[01:23:58.290242]<Le_Vert_>wikistart takes about 2 or 3 minutes to load...
[01:24:10.383105]<Le_Vert_>once the homepage is loaded, browsing inside trac works as excpect
[01:24:34.078315]<Le_Vert_>debian test + trac 0.11 + mod_wsgi (was running on mod_python a few hours ago, same performance)
[01:25:03.855782]<Le_Vert_>ie: time LANG=C wget http://www.museek-plus.org
[01:26:07.218902]<bionoid>Yeah that's not very speedy
[01:26:21.379959]<Le_Vert_>and the server is not loaded at all
[01:26:29.105368]<Le_Vert_>I can't see any apache thread working
[01:26:45.954183]<Le_Vert_>www.graphikzoo.com (php based is hosted on the same server)
[01:26:52.150554]<bionoid>Try to start up the env with tracd instead of apache.
[01:26:53.585789]<Le_Vert_>just to see the performance differences....
[01:28:38.227136]<hasienda>bionoid: Hey, thanks. I will try hard, need it myself badly.
[01:29:03.607171]<Le_Vert_>http://88.191.100.241:8080/trac
[01:29:34.052193]<Le_Vert_>seems to works fine bionoid
[01:29:38.478357]<Le_Vert_>what does it means ??
[01:30:28.504475]<bionoid>Le_Vert_ probably means your apache config is borked :P
[01:30:49.268619]<hasienda>bionoid: you should definitely try 0.12, side-by-side editor mode and i18n (being a German) is a killer.
[01:32:00.031297]<bionoid>hasienda hehe yeah, and lots of other do too, but they all moved to other tools years ago hehe. Would be _great_ to have it in core.
[01:32:47.227451]<Le_Vert_>bionoid: http://dedibox.le-vert.net/divers/vhost-wsgi.conf
[01:32:48.857014]<bionoid>hasienda well yeah, trouble is I have a lot of (really ugly) hacks on my production systems, so migrating to .12 is not gonna happen anytime soon.. ;-)
[01:32:53.119186]<Le_Vert_>do you see something wrong here ?
[01:33:26.526383]<kirean>anyone knows of a ticketquerymacro with the possibility of summarizing time/hours
[01:34:36.043132]<bionoid>Le_Vert_ not at first glance, no, maybe enable debug logs in apache and see if it gives a hint?
[01:35:10.772601]<Le_Vert_>maybe I could just disable all vhosts
[01:35:11.364822]<bionoid>kirean It will be core when hasienda's finished :D (right? right??)
[01:35:21.199960]<Le_Vert_>and start with the minimal working configuration
[01:35:26.815633]<Le_Vert_>but I doubt it will change anything
[01:36:17.051589]<hasienda>bionoid: bad news is good news: yesterday I did another jump forward in understanding, how Trac is working with respect to pulling/pushing ticked data from/to db. So I hope to iron out many of my former design flaws in custom ticket implementation that I did while initially just stumbling through the code not even knowing any Python lang.
[01:37:19.350447]<hasienda>bionoid: yes, I'm aiming at core, and rblank is already informed, involved as soon as I get the patches to trunk out here.
[01:37:51.575121]<kirean>oh, so that's what you're working on?
[01:38:03.522480]<hasienda>bionoid: even basing on rblank's Merurial repo for good measure ...
[01:38:09.123742]<_dave_h_d>bionoid: what i meant to ask is if you can have double __group__
[01:38:25.007475]<hasienda>bionoid: *Mercurial
[01:38:43.543366]<_dave_h_d>bionid: so lets say by milestone, and then within that user
[01:38:51.723686]<Le_Vert_>bionoid: I'm going to init a new empty environment
[01:39:02.601130]<Le_Vert_>en create an apache vhost with minimal configuration
[01:39:07.003460]<Le_Vert_>let's see how it works
[01:41:37.617303]<bionoid>hasienda: I struggled with the database stuff too, magic dicts and all.. but I somehow made it work ;-)
[01:42:23.921284]<bionoid>hasienda: I've now allocated a day near end of month for .12 install/test, looking forward to your patches :D
[01:42:31.529163]<bionoid>_dave_h_d sorry no idea probably not
[01:47:29.620660]<hasienda>kirean: Certainly you do know http://trac-hacks.org/wiki/TimingAndEstimationPlugin - that looks at least like a starting point, and other related plugins a mentioned there too.
[01:48:17.090208]<hasienda>bionoid: will try hard, to give you something to test then ;-)
[01:49:33.407719]<hasienda>*** diving into deeps of trac trunk sourcecode to push ideas into code right away
[01:50:07.417045]<Le_Vert_>bionoid: http://hwraid.le-vert.net/
[01:50:10.359680]<Le_Vert_>not quite fast
[01:50:22.315615]<Le_Vert_>empty trac environment
[01:50:28.963127]<Le_Vert_>minimal mod_python apache conf
[01:57:24.836728]<kirean>hasienda: yes, I do know about TimingAndEstimationPlugin
[01:57:25.038458]<kirean>I just want something that adds an additional row to ticketquery which gives me a sum of all entries in a specified column
[02:00:36.911976]<kirean>like: [[TicketQueryWithSum(milestone=xxx,col=id|summary|milestone|status|owner|time_est_dev,summarize=time_est_dev,table)]]
[02:01:07.489203]<Le_Vert_>bionoid:
[02:01:09.495705]<Le_Vert_>got it
[02:01:11.791201]<Le_Vert_>I think :)
[02:01:32.646489]<Le_Vert_>trac-spamfilter plugin.....
[02:03:16.513062]<hasienda>kirean: I know of a 'hitcount' feature. What you're asking is certainly possible but I know of now existing implementation. And I know the call for 'numeric' custom fields in Trac may be (related to) what you want. I suggest adding to the relevant Trac ticket, to show demand and help pushing this at least.
[02:14:45.502740]<bootlaces>Hiya Everyone :) A quickie question. I've put the TestingWorkflow I found on TracHacks on our installation of 0.11. It works wonderfully. We are very pleased with it. It mentions to put a style into our site CSS, where do I find the site CSS?
[02:14:53.936027]<bootlaces>(is it local to the project directory?)
[02:15:02.273468]<bootlaces>http://trac-hacks.org/wiki/TestingWorkflow
[02:22:38.721262]<Sacho>in htdocs/css
[02:24:15.981171]<bootlaces>thank you :)
[02:24:52.700921]<bootlaces>would the css be a file or folder (and would it be local to the project, in the $ENV/htdocs directory?)
[02:25:55.847276]<Le_Vert_>hehehehe :)
[02:25:57.400431]<Le_Vert_>great
[02:26:11.107724]<Le_Vert_>is there anyone who has write access to trac's wiki ?
[02:26:19.115464]<Le_Vert_>on the tracperformance page
[02:26:28.975933]<Le_Vert_>it could be great to add a note about trac-spamfilter plugin
[02:26:44.283627]<Le_Vert_>it was responsible of the damn poor performance of my tracs
[02:26:55.652500]<Le_Vert_>then I moved from mod_python to mod_wsgi on daemon mode
[02:27:07.641620]<Le_Vert_>and I had never seen such fast trac before :p
[02:33:29.676256]<Sacho>bootlaces: normally it's somewhere in your trac install directory
[02:33:37.258332]<Sacho>you can add your own to htdocs/css
[02:33:45.506084]<Sacho>in the project directory
[02:34:00.180675]<bootlaces>thank you Sacho :)
[02:38:32.308403]<kirean>in a trac custom query (0.11), can I show a column with the value of one column-another column?
[02:41:26.609801]<bootlaces>I tried creating a css folder under the project/htdocs folder (there was none), then I put in a site.css with the change in it and trac didn't pick it up
[02:41:56.704437]<bootlaces>if I put the css into the roadmap.css in the installed trac it works
[02:42:20.833942]<bootlaces>I tried renaming the site.css in my project/htdocs to roadmap.css and it didn't work either.
[02:49:55.115137]<Sacho>permissions?
[02:58:52.903025]<hasienda>bionoid: just added a clearer description on my upcoming proposal for implementation to http://trac.edgewall.org/wiki/TracTicketsCustomTimeFields
[02:59:50.792078]<hasienda>bionoid: still appreciate feedback on my decisions as well on documentation to make it a good start for code review.
[03:15:58.885359]<kirean>osimons: around? maybe you know?
[03:18:35.990543]<bionoid>hasienda: Will give feedback when I get around to testing it for sure! But until then, keep it up.. ;-)
[03:18:42.113324]<bionoid>bootlaces: iirc you have to include the .css from templates/site.html manually
[03:22:31.484691]<bootlaces>bionoid: I have $ENV/templates/site.html. I should put the css in there?
[03:22:36.462579]<bootlaces>ahhh or
[03:22:44.182591]<bootlaces>I see, add a link ref to the css in teh site.html
[03:26:04.979295]<scfe>hasienda: regarding your custom time fields
[03:26:26.225158]<scfe>I think babel has some i18n-enabled date parsing
[03:26:52.596047]<scfe>also I'm a bit surprised that you want to use an external library for that
[03:27:04.071428]<scfe>actually trac can parse dates already - why not use that?
[03:27:29.016275]<scfe>my comments were in regard to your point: "parse user input and consolidate different flavors of time stamps, initially done with help of mxDateTime.Parser "
[03:27:57.901821]<scfe>I think we should not add the possibility to use different time formats - just rely on trac's mechanism
[03:28:39.950130]<scfe>you have to add code for the ticket notifications until announcer is merged into trunk
[03:30:06.399170]<osimons>kirean: nope, need to use sql math for that (report, not query)
[03:30:16.241808]<bionoid>bootlaces: Exactly
[03:30:26.203664]<bionoid>@wiki 0.11/TracInterfaceCustomization
[03:30:26.213445]<evil_twin>http://trac.edgewall.org/wiki/0.11/TracInterfaceCustomization
[03:30:43.568090]<bionoid>see section "Site Appearance"
[03:39:57.379445]<_dave_h_d>can i add extra column to version?
[03:40:05.022853]<_dave_h_d>or is it just ticket?
[03:40:11.183479]<Sacho>what do you mean?
[03:40:29.572523]<_dave_h_d>Sacho: well to ticket i can add extra columns in the config
[03:40:41.391884]<bionoid>_dave_h_d: No, other resources do not have custom fields, unfortunally.
[03:41:19.754165]<_dave_h_d>bionoid: cheers
[03:41:31.877920]<bionoid>_dave_h_d: That's my #1 major pain with Trac, and hasienda's currently working on #2 date/time support ;-)
[03:42:00.485014]<bionoid>hasienda: so just allocate your time for #1 right away, I'm sure you're gonna need it soon ;-)
[03:53:46.154731]<_dave_h_d>hey guys when i do strftime('%m', v.time, 'unixepoch')
[03:53:55.841206]<_dave_h_d>is it at all possible to get it to do Jan Feb
[03:54:00.439429]<_dave_h_d>Mar Apr etc
[03:54:21.902097]<_dave_h_d>sqlite trac report
[03:57:27.669125]<hasienda>*** just reviewing last minutes of discussion
[03:57:32.606461]<hasienda>scfe: did't came across Babel with regard to date/time parsing, will look at this, thanks.
[03:58:13.382549]<scfe>hasienda: Babel could be interesting because it is an optional dependency for 0.12 anyway.
[03:58:32.685211]<scfe>also my advice is to focus on a minimal implementation first
[03:58:50.628102]<scfe>so use parse_date from trac as a first shot and get it into trac
[03:58:59.562019]<scfe>afterwards improve your implementation
[03:59:05.406633]<hasienda>scfe: mx.DateTime.Parser had excellent references and was available even on Debain GNU/Linux, what made it a premium choice for me as a bloody python beginner.
[04:00:24.370645]<scfe>what's wrong about: from trac.util.datefmt import parse_date; when = parse_date(input_string);`?
[04:00:36.692712]<scfe>can't much easier using my.DateTime...
[04:01:39.667417]<hasienda>scfe: I choose to add all thinkable possibility to INPUT different time formats - and convert/store it away in native format, but maybe I'll find out that I was wrong at put down with it. cboos responded in the wiki page too, but didn't trash mx totally, at least not for the start.
[04:02:56.678180]<scfe>hasienda: I don't want to criticize your decisions :-) - but when you start something new (e.g. Python), try to do the minimal thing first
[04:03:17.260290]<scfe>after all there's value also for using trac's infrastructure
[04:03:57.102372]<scfe>because there are other date fields as well (e.g. milestone due) which work then differently than the custom datetime fields
[04:03:58.502727]<hasienda>scfe: code for the ticket notifications may be more a matter of time then anything else, since I already need announcer for my intended use case and just want to make it happen in the first place.
[04:04:57.861203]<scfe>nothing wrong with that - however I guess your feature won't be merged until you support trac out of the box
[04:05:36.493666]<scfe>it's just extremely important in software development to break up features in very small, incremental steps to get towards a solution
[04:06:07.704042]<hasienda>bionoid: redarding your #1, how do you translate 'thank your for the flowers' to native English speach? :-)
[04:06:08.018279]<scfe>this will improve your chances to get into trunk
[04:07:42.311823]<hasienda>scfe: 'minimal implementation first' - 100 % with you, but couldn't figure out how to work with parse_date - with mx I could.
[04:08:04.019150]<kirean>osimons: thanks!
[04:08:07.170483]<scfe>hasienda: No problem - just push a patch queue to bitbucket, we'll work out the details
[04:10:34.759096]<hasienda>scfe: as you mention this, happen that I'm a beginner with Mercurial an bitbucket too. Any hint on pushing (my current) patch queue there? Couldn't work this out before as well.
[04:10:58.841096]<scfe>http://ches.nausicaamedia.com/articles/technogeekery/using-mercurial-queues-and-bitbucket-org
[04:11:10.256073]<hasienda>scfe: thanks. :-)
[04:11:20.694719]<scfe>basically you have two repos: One with the main trac code (pristine) and one for your patches
[04:11:56.393912]<scfe>for an example how this looks with bitbucket, check http://bitbucket.org/felixschwarz/cherrypy2/
[04:12:52.681797]<hasienda>scfe: will have a look and hopefully be able to do it than.
[04:12:56.120375]<hasienda>*** going back to real life for some time now (my little baby daughter is calling)
[04:28:37.708067]<bionoid>hasienda: Don't know, but I sure will get you some nice ones if you fix it ;-)
[04:29:32.977047]<bionoid>_dave_h_d: Create a lookup table in your DB and fetch names from it
[04:29:48.193590]<bionoid>_dave_h_d: (or use a very long CASE statement)
[04:34:03.820116]<hasienda>bionoid: 'Danke für die Blumen!' [iron.] -> 'Thanks for nothing!' [iron.] or 'Thank you very much, I'm sure!' [iron.] (http://www.dict.cc/deutsch-englisch/Danke.html), but irony was not intended. Have to rethink this. ;-)
[04:43:42.879646]<bootlaces>got my style to work :)
[04:44:20.952358]<bootlaces> <link rel="stylesheet" href="/trac/fubar/chrome/site/css/testing.css"/>
[04:44:41.989953]<bootlaces>with css/testing.css living under site in the project directory
[04:50:23.971589]<bootlaces>Is it just the owner of a ticket and the ticket admin that can close a ticket, or can I assign that right to another group/person?
[04:58:31.832360]<osimons>@wiki TracWorkflow
[04:58:31.837366]<evil_twin>http://trac.edgewall.org/wiki/TracWorkflow
[04:58:37.841393]<osimons>bootlaces: ^^ you decide
[05:01:05.284787]<bootlaces>thank you osimons :)
[05:12:50.412504]<bootlaces>In the TracWorkflow, for close.permission (for example), can you have more than one value?
[05:12:53.417529]<bootlaces>i.e.,
[05:13:09.643773]<bootlaces>close.permissions = TICKET_ADMIN, TICKET_CREATE
[05:13:10.336355]<bootlaces>?
[05:18:24.545541]<bootlaces>actually, TICKET_MODIFY will do nicely :)
[05:34:03.825793]<cheche>Is it possible to disable the version control component for anonymous users?
[05:34:53.532837]<cheche>Hi good morning by the way
[06:08:33.988067]<osimons>cheche: sure, just don't allow them BROWSER_VIEW permission
[06:09:02.998252]<osimons>http://trac.edgewall.org/wiki/TracPermissions#RepositoryBrowser
[06:11:00.259120]<_dave_h_d>i am grouping by version, can i group so i have version and items and for the non versioned items to have non version
[06:26:01.211758]<retracile>bootlaces: multiple are allowed
[06:26:05.761013]*retracile -> work
[06:26:33.082865]<_dave_h_d>actually, here is the query, i want the stuff which is not in aversion to show too : http://pastebin.com/jepKxWzc
[06:26:37.382835]<_dave_h_d>is this possible?
[06:32:14.422410]<_dave_h_d>come on guys this is a good challenge
[06:32:21.686510]<_dave_h_d>:-)
[06:43:58.528821]<phrearch>hi
[06:44:24.762022]<cheche>osimons: thanks!
[06:44:47.095113]<phrearch>i just installed trac on ubuntu with this guide http://trac.edgewall.org/wiki/0.11/TracOnUbuntu
[06:45:07.745510]<phrearch>how can i get the site with apache on myhost.org, instead of myhost.org/projects/myproject ?
[06:50:33.242727]<scfe>phrearch: you need to configure Apache accordingly. do you have some knowlegde about apache configs?
[06:50:53.390211]<phrearch>scfe: yea, im trying to setup a proper virtualhost
[06:51:28.201714]<phrearch>i need the most simple config to point my trac project to mysite.org
[06:51:36.431781]<phrearch>instead o mysite.org/projects/myproject
[06:51:54.511240]<scfe>phrearch: multiple projects or just one?
[06:52:09.482862]<scfe>phrearch: mod_python, mod_wsgi?
[06:52:16.345018]<phrearch>scfe: just one with mod_python i think
[06:52:26.250225]<phrearch>yes, modpython
[06:52:45.210576]<scfe>So you use <Location /> instead of /projects
[06:52:56.942530]<scfe>and replace 'TracEnvParentDir'
[06:54:07.891303]<scfe>instead use "PythonOption TracEnv /var/trac/myproject"
[06:54:21.949648]<scfe>also the uriroot might need to be adapted
[06:56:06.809118]<phrearch>ah thanks
[06:56:10.480136]<phrearch>i think i got it
[06:56:11.521143]<phrearch>http://paste.pocoo.org/show/202171/
[10:57:07.401346]<DaMato>re
[10:57:45.873719]<DaMato>does anybody know why TracSpamFilter is throwing messages recently like: "ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings..."
[10:57:48.715576]<DaMato>?
[11:17:39.065076]<osimons>DaMato: spam filter at your site?
[11:18:05.744463]<osimons>(and not a t.e.o)?
[11:20:13.675468]<osimons>i have a feeling your problem is related to a quite recent python, like perhaps 2.7, that intends to be a transition between old-style strings and new unicode and byte types. what python version?
[11:24:38.527224]<DaMato>osimons: yes, at my own site.
[11:25:37.813777]<DaMato>osimons: that's "Python 2.6.5 (r265:79063, Mar 26 2010, 13:16:17)" on a Gentoo/Linux system.
[11:26:52.281250]<osimons>i'd do some searching for that combination, likely some careless string handling in spamfilter that now causes error with certain strings of unknown encoding
[11:27:44.525043]<osimons>if you find anything (or don't but see error persist), then please file a ticket at t.e.o against the spamfilter plugin
[11:28:06.948675]<DaMato>I'll do.. the full error message is: "ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings."
[11:28:26.174003]<DaMato>and the stack trace is that:
[11:28:28.140997]<DaMato>File "/usr/lib64/python2.6/site-packages/trac/web/main.py", line 450, in _dispatch_request
[11:28:28.343871]<DaMato> dispatcher.dispatch(req)
[11:28:28.357222]<DaMato>File "/usr/lib64/python2.6/site-packages/trac/web/main.py", line 206, in dispatch
[11:28:28.370166]<DaMato> resp = chosen_handler.process_request(req)
[11:28:28.554838]<DaMato>File "/usr/lib64/python2.6/site-packages/trac/admin/web_ui.py", line 114, in process_request
[11:28:29.527801]<DaMato> path_info)
[11:28:31.585561]<DaMato>File "build/bdist.linux-x86_64/egg/tracspamfilter/admin.py", line 74, in render_admin_panelFile "build/bdist.linux-x86_64/egg/tracspamfilter/admin.py", line 221, in _process_monitoring_panelFile "build/bdist.linux-x86_64/egg/tracspamfilter/api.py", line 176, in trainFile "build/bdist.linux-x86_64/egg/tracspamfilter/filters/bayes.py", line 78, in trainFile "/usr/lib64/python2.6/site-packages/spambayes/hammie.py", line 164, in train
[11:28:36.554381]<DaMato> self.bayes.learn(tokenize(msg), is_spam)
[11:28:38.557734]<DaMato>File "/usr/lib64/python2.6/site-packages/spambayes/classifier.py", line 252, in learn
[11:28:40.573419]<DaMato> self._add_msg(wordstream, is_spam)
[11:28:42.603733]<DaMato>File "/usr/lib64/python2.6/site-packages/spambayes/classifier.py", line 354, in _add_msg
[11:28:44.542882]<DaMato> record = self._wordinfoget(word)
[11:28:46.609133]<DaMato>File "build/bdist.linux-x86_64/egg/tracspamfilter/filters/bayes.py", line 149, in _wordinfogetFile "build/bdist.linux-x86_64/egg/tracspamfilter/filters/bayes.py", line 114, in _get_rowFile "/usr/lib64/python2.6/site-packages/trac/db/util.py", line 64, in execute
[11:28:50.529130]<DaMato> return self.cursor.execute(sql_escape_percent(sql), args)
[11:28:52.604713]<DaMato>File "/usr/lib64/python2.6/site-packages/trac/db/sqlite_backend.py", line 80, in execute
[11:28:54.224393]<DaMato> result = PyFormatCursor.execute(self, *args)
[11:28:58.567321]<DaMato>File "/usr/lib64/python2.6/site-packages/trac/db/sqlite_backend.py", line 59, in execute
[11:29:00.553742]<DaMato> args or [])
[11:29:02.548262]<DaMato>File "/usr/lib64/python2.6/site-packages/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
[11:29:04.532911]<DaMato> return function(self, *args, **kwargs)
[11:30:08.695037]<osimons>gah. paste please - don't do that!
[11:30:11.358819]<osimons>@paste
[11:30:11.395127]<evil_twin>paste is http://paste.lisp.org/new/trac
[11:30:56.705070]<osimons>i don't use the plugin, and don't have time atm to help, so better do some googling yourself and save the trace for the new ticket at t.e.o site