Team Chat Logs

March 13, 2010

2010 2
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 31        

[01:12:09.221644]<lelit>hi all. I've mostly completed the italian translation, and uploaded the new catalog on #5489. Hopefully I can now move on to complete trac-darcs 0.8 too :-)
[01:35:33.330491]<sobersabre>hi.
[01:35:43.005090]<sobersabre>I was asking about my trac setup yesterday.
[01:35:50.327583]<sobersabre>is there a channel log somewhere ?
[01:37:22.457654]<lelit>look at the topic
[01:37:28.704668]<sobersabre>ok, here is the paste: http://pastebin.ca/1835580
[01:37:38.398762]<sobersabre>this is the apache configuration.
[01:37:58.558146]<sobersabre>I have currently this location as src for the special imagery:
[01:38:22.562849]<sobersabre>src="/project/chrome/common/image.png"
[01:38:24.989407]<sobersabre>in trac.ini
[01:38:31.558825]<sobersabre>I still cannot see the image.
[01:38:39.520912]<sobersabre>what shall I use in src="" ?
[01:39:13.542467]<sobersabre>where am I supposed to put the custom logo and how shall I refer to it in trac.ini ?!
[01:39:45.918080]<sobersabre>please note that I have: Alias /project "/usr/share/trac"
[01:39:56.778374]<sobersabre>and I also have a <Location "/project">
[01:40:15.522098]<sobersabre>maybe I should have setup it otherwise ?
[01:40:41.112769]<osimons>sobersabre: if inside the project htdocs, that is known as 'site' prefix - like src = site/mylogo.jpg
[01:40:56.869726]<nielx>sobersabre: I think /chrome/site/ maps to ENV/htdocs
[01:41:39.023464]<osimons>@wiki TracInterfaceCustomization
[01:41:39.028543]<evil_twin>http://trac.edgewall.org/wiki/TracInterfaceCustomization
[01:41:40.087063]<gozerbot>no result found
[01:41:53.333253]<osimons>sobersabre: http://trac.edgewall.org/wiki/TracInterfaceCustomization#ProjectLogoandIcon
[01:43:14.897377]<sobersabre>osimons: I'
[01:43:22.538059]<sobersabre>ll try thanks. rtfm'ing :)
[01:47:07.806475]<sobersabre>osimons: testing... shall I *reload* or *restart* the server ?
[01:47:41.736279]<sobersabre>(in debian there's reload for -HUP or restart for ... -TERM and spawn again)
[01:52:00.917482]<sobersabre>osimons: I did what the page says, and I now can see the image has the right size, but I don't see the image itself.
[01:52:05.713467]<sobersabre>I'm on google chrome...
[01:52:11.200940]<sobersabre>maybe it's got something cached...
[01:53:32.554423]<sobersabre>I'm now on firefox.
[01:54:03.014035]<sobersabre>when I'm looking at page info, "Media" section, I see the image is NOT correctly understood.
[01:54:12.023040]<sobersabre>Location is ok.
[01:54:18.913670]<sobersabre>Type is "text/html"
[01:54:47.511314]<sobersabre>the Size is unknown, Dimensions are 0px x 0px (scaled to 65px x 17 px)
[01:54:50.982030]<sobersabre>which is WRONG.
[01:55:02.658469]<sobersabre>my files owndership is www-data and the same group.
[01:55:15.233873]<sobersabre>I have envrironment in /home/trac/project
[01:55:26.991079]<sobersabre>I created a folder htdocs, and added all the images there.
[01:55:35.335613]<sobersabre>I even chmodded the icon to be executabl.
[01:55:40.752671]<sobersabre>something is WRONG.
[01:55:46.590932]<sobersabre>can somebody give an idea ?
[01:56:06.906898]<nielx>nope
[01:57:34.138231]<sobersabre>ARGH!
[01:58:44.949557]<sobersabre>the webserver returns 404 on the GET request of these images.
[01:58:54.613055]<sobersabre>It simply doesn't look in the right place.
[01:59:13.660964]<sobersabre>it tries to look in /project/chrome/common/
[01:59:36.944829]<sobersabre>if I write /project/file.png
[01:59:52.260542]<sobersabre>but /project is in apache terms.
[01:59:59.333172]<sobersabre>argh!
[02:00:05.911174]<sobersabre>I'll try apache forum.
[02:37:25.406212]<osimons>sobersabre: did you not read what i wrote? you want to drop it into $project htdocs, and use "src = site/file.png" as setting
[02:38:32.222452]<osimons>the reference in the url should then be "/project/chrome/site/file.png" which trac will convert to local project htdocs reference
[02:39:05.588986]<osimons>anything 'common' is for the Trac .egg - ie. images, js and css shipped with Trac, and that you should not change or need to refer to
[02:50:37.969305]<osimons>"site/file.png", not "/project/file.png" or any other variation you seem to be using. there is a pre-created folder that should then be /home/trac/project/htdocs (guessing from your paths) where the project-chrome files should be dropped. this project-relative htdocs folder is referred to as 'site' in trac.ini regardless of what your project is called or where project resides on disk.
[02:51:27.621478]<osimons>- this is all trac, and nothing apache. i do hope they don't confuse your setup further in that channel...
[02:52:03.432118]*osimons heads out. later.
[03:19:33.213720]<gozerbot>trac: SeaChange/WhatUsersWant edited - <http://trac.edgewall.org/wiki/SeaChange/WhatUsersWant?version=115>
[03:55:21.855964]<j-b>Hello.
[03:55:40.482183]<j-b>Is it possible to configure trac so that people go directly to the timeline and not the wiki ?
[04:03:58.521855]<sobersabre>hi, is there a way to have SQL shell into trac environment ?
[04:04:14.257378]<sobersabre>I want to see a name of a field in the DB to create a report.
[04:56:41.649514]<doki_pen>talley: that nice to hear!
[07:49:35.748285]<gozerbot>trac: Ticket #9137 (Improper display of negative time difference) created - <http://trac.edgewall.org/ticket/9137>
[08:33:20.750618]<TiN>Hi, there is a variable for use in a template that has url_root eg http://mytracs/myproject, i need http://mytracs?
[08:33:42.722077]<TiN>How can I list the available variables in the templates eg abs_href?
[09:47:08.043805]<sobersabre>hi all
[09:50:20.166748]<sobersabre>osimons: thank you I simply didn't get initially the meaning of "site" keyword.
[09:50:29.788370]<sobersabre>Thanks for the explanation - it works.
[09:50:34.683314]<sobersabre>:)
[10:32:51.550559]<dfas>I'm trying the "easy_install http://svn.edgewall.org/repos/trac/trunk/" but I'm getting an error.
[10:33:05.709387]<dfas>it says: "zipimport.ZipImportError: bad local file header in /usr/lib/python2.4/site-packages/Trac-0.12dev_r9348-py2.4.egg"
[10:35:46.118870]<osimons>dfas: check your setuptools version - may be old? python -c "import setuptools; print setuptools.__version__"
[10:35:54.533631]<osimons>mine is 0.6c11
[10:38:02.887475]<dfas>0.6c11
[11:49:36.682689]<gozerbot>trac: SeaChange/WhatDevelopersWant edited - <http://trac.edgewall.org/wiki/SeaChange/WhatDevelopersWant?version=4>
[11:52:46.705915]<TiN>Sorry, I ask again just in case
[11:52:48.241199]<TiN>How can I list the available variables in the templates eg abs_href?
[11:56:57.603854]<osimons>TiN: developer plugin at trac-hacks.org, or you can use my debugging site.html code that i have pasted here: http://trac.edgewall.org/wiki/TracDev/PortingFromClearSilverToGenshi#Debugging
[11:57:14.299109]<osimons>- basically print and test what you need in a simple way
[11:57:25.005703]*osimons returns to tv
[11:58:37.889215]<TiN>osimons: thanks :-)
[12:11:07.965749]<unregistered>is it possible to configure what ticket changes trigger a cc?
[12:11:39.572418]<unregistered>we only really want notifications when there are comments or maybe if the description changes
[12:57:54.629891]<gozerbot>trac: TracMercurial edited - <http://trac.edgewall.org/wiki/TracMercurial?version=70>
[13:00:35.464825]<hasienda>unregistered: You may want to test AnnouncerPlugin. It aims to be more than a replacement for TracNotification. Option "ignore_cc_changes" allows for notification suppression, if only cc has changed. Think this could be easily extended, if you need more. You may want to have a look at /announcer/producers/ticket.py line 88, where you'll find function "ticket_changed".
[13:18:53.649775]<sobersabre>is there a way to access tickets database via sql interface ?
[13:19:15.337673]<sobersabre>I want to see what's a name of a field I see in the ticket.
[13:19:32.329877]<sobersabre>and to create a query related to it (report)
[13:19:43.177825]<sobersabre>it's a custom field.
[13:20:19.199545]<unregistered>hasienda: thank you. i think this might work for me
[13:20:50.015464]<Mulleteer>sobersabre, do you mean custom ticket field defined in trac.ini ?
[13:20:56.760527]<sobersabre>yes.
[13:21:04.734263]<sobersabre>I think so.
[13:21:13.176641]<sobersabre>I mean YES SIR.
[13:21:16.150829]<Mulleteer>those are stored in ticket_custom table
[13:21:31.064730]<sobersabre>ok...
[13:21:53.073911]<Mulleteer>do you want example of report that uses custom fields?
[13:21:55.778590]<sobersabre>so I will have to query from 2 tables....
[13:21:59.211915]<sobersabre>yes.
[13:22:05.905213]<Mulleteer>wait a sec
[13:22:12.152748]<sobersabre>I prefer to not do typos :)
[13:23:40.837095]<Mulleteer>http://dpaste.com/171654/
[13:24:04.730410]<Mulleteer>that report uses two custom fields, 'customer' and 'cdstatus'
[13:24:10.921098]<Mulleteer>those have been defined in trac.ini
[13:27:55.979813]<sobersabre>Mulleteer: http://dpaste.com/171655/
[13:28:14.996228]<sobersabre>this is the ttype in [ticket-custom] section
[13:28:27.728156]<sobersabre>how do I refer to the field ? ttype ?
[13:29:04.003397]<Mulleteer>yes
[13:29:09.833887]<sobersabre>ok.
[13:29:26.786420]<dfas>I'm on RedHat, how do I install the python bindings for SVN?
[13:30:05.814821]<sobersabre>I have the section ticket-custom, not ticket_custom, is it still OK ?
[13:31:06.048601]<Mulleteer>if you can see custom fields in trac it should not matter
[13:32:19.533218]<sobersabre>I'm trying to do this: http://dpaste.com/171661/
[13:32:22.749528]<sobersabre>it's not accepted.
[13:32:24.347400]<sobersabre>why ?
[13:33:31.461974]<Mulleteer>change c.ttype to c.value
[13:33:32.268105]<sobersabre>it claims no such column c.ttype
[13:34:19.333714]<Mulleteer>and add c.name = 'ttype' in the where clause
[13:34:32.083420]<sobersabre>yep... I got a cartesian product of something :)
[13:36:15.473395]<sobersabre>oh, this is not what I intended to have.
[13:36:24.689695]<sobersabre>the c.value brings SEVERAL values.
[13:36:27.927926]<sobersabre>very weird.
[13:36:49.310378]<Mulleteer>did you add c.name = 'ttype' in where clause?
[13:37:08.581538]<sobersabre>no
[13:37:21.572235]<sobersabre>I added t.id=c.ticket
[13:37:23.918521]<sobersabre>AND
[13:37:35.177832]<sobersabre>I mean
[13:37:49.992469]<sobersabre>I want to only have the field of that particular ticket.
[13:38:05.611126]<sobersabre>is there SQL interface, to see what other field I have there ?
[13:38:15.350957]<sobersabre>some shell ?
[13:38:27.202517]<Mulleteer>as far as I know no, I've used sqlclient to access the database
[13:38:40.731547]<sobersabre>sqlclient ?
[13:38:50.219083]<Mulleteer>sqlite3
[13:38:50.640905]<sobersabre>what is this ?
[13:38:53.899409]<sobersabre>ok!
[13:38:57.772667]<sobersabre>that's enough!
[13:39:31.470509]<sobersabre>I'm opening db/trac.db ?
[13:39:34.480555]<sobersabre>?
[13:39:43.520292]<Mulleteer>yes, sqlite3 db/trac.db is the command line
[13:40:24.694090]<hasienda>sobersabre: I use sqlitebrowser for that, nice GUI, no SQL knowledge needed for queries.
[13:41:15.184059]<Mulleteer>btw, I think your where clause should be 'WHERE ... AND t.id=c.ticket AND c.name = 'ttype'
[13:43:52.930566]<sobersabre>Mulleteer: true, I didn't understand the structure of the table before selecting it all :)
[13:43:58.274094]<sobersabre>it works now, thanks.
[13:44:02.719541]<Mulleteer>np
[13:45:33.618428]<sobersabre>I
[13:46:11.481209]<sobersabre>finally fixed some of my long ignored little uglies in my trac... it means one of the projects is coming to an end :)
[13:46:19.680357]<sobersabre>some free time :p
[14:35:30.798803]<unregistered>how is that green window on the right of trac-hacks.org done?
[14:35:43.161545]<unregistered>on the main wiki page
[14:37:09.674089]<coderanger_>newsflash macro
[14:37:19.792847]<coderanger_>(effectively)
[14:37:33.678034]<unregistered>thanks
[14:41:01.248926]<unregistered>oh, heh. and thanks for the plugin itself :)
[15:16:52.297680]<dfas>Is someone willing to setup subversion 1.6.9 and trac 0.11.7 with apache on my new RH/CentOS machine? paying $40 for the job
[16:27:56.811702]<gozerbot>trac: Changeset [9349]: creates announcer branch ... - <http://trac.edgewall.org/changeset/9349>
[16:38:45.738402]<achaemenes>could someone please help me with this problem I have on ALL my trac sites, and have had it from months and months...
[16:38:49.120693]<achaemenes>user logs in
[16:38:57.066463]<achaemenes>clicks on some link
[16:39:06.046502]<achaemenes>and they've been logged out in the process
[16:52:47.594157]<retracile>achaemenes: one specific user, or all users? Are you using http auth or account manager's form-based login?
[16:53:35.087570]<achaemenes>retracile: I'm using account manager's form-based login, and it happens for my user - I don't know if it happens for everyone - i just assumed it would be :P
[16:54:20.782554]<achaemenes>I have a main trac conf file that all the trac instances inherit from
[16:54:27.070236]<achaemenes>the problem is with all the sites
[16:54:48.642088]<achaemenes>so its probably in the main config file - but not necessarily
[16:54:54.637010]<achaemenes>and as you said - maybe its just me?
[16:55:14.481317]<achaemenes>here's the site: http://ai.autonomy.net.au/
[16:55:57.024839]<achaemenes>and the main trac.ini file: http://paste.pocoo.org/show/189356/
[16:56:42.722181]<achaemenes>and the trac.ini for the AI site: http://paste.pocoo.org/show/189357/
[16:57:31.682622]<achaemenes>Trac 0.11.5
[17:22:12.418545]<retracile>achaemenes: I don't remember hearing other reports of such behavior. The first thing that jumps out at me though is the sheer number of plugins you're using. You might try disabling some of them temporarily to see if one of them is the culprit.
[17:22:32.787268]<retracile>achaemenes: I don't have time to dig into it with you tonight though; sorry.
[17:22:51.295237]<achaemenes>retracile: thanks for looking at this - i appreciate it - I'll start with the plugins
[17:28:31.739482]<achaemenes>i disabled all the modules except acctmgr
[17:31:51.289731]<dfas>now I'm getting this: [error] [client 192.168.1.90] PythonHandler trac.web.modpython_frontend: ImportError: cannot import name compat
[17:31:53.296705]<dfas>any clues?
[22:57:59.124924]<gozerbot>trac: Ticket #9138 (mysql database upgrade problem) created - <http://trac.edgewall.org/ticket/9138>