this hadn't given any warning. It was a secondary drive in one of my spare boxes and I thought - ah, I'll make it primary, reinstall and let my nephew have the machine
ojnkpjg
that's no fun
wolfsong_
luks: when you add your login to the CC in Trac does it send you an email on changes?
ojnkpjg
sounds like there probably wasn't anything very important on it, though right?
reinstalling stuff is a pain in the ass, though
luks
wolfsong_: yes, it sends you emails if you are in CC, or you are reporter or owner of the ticket
rowaasr13
Ok, seems like unsubscribing old address and moving new subscription to it did work. I thought mailman could complain on move, because that old address already registered for other lists.
wolfsong_
i've never gotten one
where can i check the email? My Account just lets me change my pwd
inhouseuk
ojnkpjg: fortunately nothing important on the drive. It's just inconvenient and means I'll need another drive before I can let him have the machine
Those japanese guys kill me with name changes. Say, what do you people think, what's best way to deal with case when signer changes her name by just one kanji, leaving same reading. Two entries for both names? Link them with some AR or what?
yalaforge
luks: so, does anyone have a blank email address set?
it's not me :-)
luks
yes, probably
yalaforge
"Opened 9 months ago". yay
luks goes to fix it and send them patch
rowaasr13
It'd be good to have separate entries for all those linked with some kind of "changed name to" AR that would link them in single discography. And ability to see entire such discography on MB's site, of course.
Would help a lot in cases of slight name changes, but remaining same "persona".
zout has to go
zout
bye!
zout has quit
luks
awww, this code is so broken :/
yalaforge had a look at their sql code. they are completely clueless
Shepard
someone did not read the 'fragile' note on the box
yalaforge
'select whatever from wherever where str = %s' % (value)
ojnkpjg
is that actually in there?
yalaforge
yes
they're filtering the strings manually though
but of course, they forgot one, so they had an sql injection leak
ojnkpjg
probably more than one
yalaforge
almost 200 vulnerable trac installs are still out there
yup
ojnkpjg
just one found so far :/
luks
hmm, i think they only use 'select whatever from wherever where str = %s', (value)
which escapes the strings
yalaforge
in this case, the db driver would do the filtering, but IIRC that's not how they do it
oh, it's mixed. sometimes they do, sometimes not :-)
luks
:)
yalaforge
% (by, by))
luks
haha
yalaforge
"WHERE milestone=%s ORDER BY value", (field, milestone))
inhouseuk
they sound like a bunch of muppets
yalaforge
seems there was someone with a clue
inhouseuk
one clue maybe
yalaforge
their design looks nice, but apparently they have some weak programmers
luks
yep
flamingcow
this is trac code?
yalaforge
yup
better keep it on a DB on its own :-)
Muti joined the channel
dju` has quit
inhouseuk
and on a machine that does nothing else
luks
i can't believe this is really in their code:
cursor.execute("SELECT DISTINCT author,ticket FROM ticket_change "
"WHERE ticket=%s", (tktid,))
for author,ticket in cursor:
recipients.append(row[0])
notice the 'row' variable
yalaforge
hmmm.
inhouseuk
is there any validation on that?
luks
it's from previous block of code
validation on what?
yalaforge
the cursor.execute() is safe
inhouseuk
the variables
yalaforge
the DB driver is used to expand the %s, not the python string interpolation (this time)
inhouseuk
ah
yalaforge suddenly wonders where the row variable comes from :-)
ojnkpjg
form input
luks
"from previous block of code"
HairMetalAddict
Okay, there's the usual "submitting an album that's already listed"-types... and now I got one that *knew* the album existed because they submitted an edit for it, then submitted an Add Album for said album only a few minutes after editing the current listing..
ojnkpjg
hehe
yalaforge is a bit slow today :-)
HairMetalAddict slaps his head in Doh! fashion...
there's a lot of sprintf and str{cpy,cat} in the musicbrainz libs, to be fair, though :P
not sure it's all safe
yalaforge
yup
fortunately, the MB server doesn't attack clients
ojnkpjg
YET.
yalaforge
unlike evil people on the internet, having access to trac
:-))
ojnkpjg
i'm more worried about possible malicious metadata in files