#musicbrainz

/

      • ojnkpjg
        that'll do you a lot of good
      • inhouseuk
        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
      • luks
      • hm, right, you don't have any email set there
      • ojnkpjg
        i think i've reinstalled windows at least 6 times for my mother
      • yalaforge installed windows xp two years ago for his parents
      • yalaforge
        the box is used a lot for word processing and internet, but they don't have the admin password
      • ojnkpjg
        i took admin away until they started calling me up and bothering me to install things
      • yalaforge
        no problems so far, no re-installs, no viruses etc :-)
      • ojnkpjg
        i guess i can't have it both ways
      • wolfsong_
        thanks
      • luks: so why should 1029 be a style issue?
      • luks
        read the lengthy discussion in mb-style
      • "Release Country ReQUEST"
      • wolfsong_
        but my request really isn't tied to that
      • it's more about capturing the year not which country
      • yalaforge wonders why he didn't get email when the ticket was changed
      • luks
        it was something wrong with the mail server i guess
      • yalaforge
        ah, ok
      • luks
        because i didn't get eny email either
      • and i usually get email on *all* trac changes :)
      • wolfsong_
        that thread seems to be about to EU or not to EU
      • yalaforge
        but now it works again?
      • luks
        yes
      • yalaforge
        k
      • luks
        oh, wolfsong, please use #XXXX for linking to other tickets
      • Shepard` joined the channel
      • Shepard has quit
      • wolfsong_
        ok
      • Shepard`
        Shepard` is now known as Shepard
      • russ_ has quit
      • wolfsong_
        FF is hateful
      • Shepard
        agreed
      • Jetpack
        do you mean firefox?
      • luks
        okay, there is really somthing wrong. i've changed http://test.musicbrainz.org/trac/ticket/1029 and still no email
      • ojnkpjg
        it crashes on my desktop box every time i try to save anything
      • works fine on windows
      • i think debian broke it
      • yalaforge
        luks: try logging into test, maybe the mails are in the mail queue
      • luks
        yep
      • zout
        luks: it takes quite some time for trac mail to arrive
      • luks
        actually no, IME, they arrive very quickly
      • inhouseuk
        yes, the ones I received last week arrived almost immediately
      • luks
        ususally i click 'Submit' and after few seconds i have a new email
      • SenRepus
      • luks
        it seems to be the trac issue :/
      • luks sighs
      • yalaforge
        so the mail server isn't sitting on a pile of mails?
      • luks
        nope, they are not in queue
      • yalaforge
        :-(
      • luks
        not even in logs
      • it seems to be specific for that one ticket
      • yalaforge
        oh? for others mail is sent?
      • luks
        yes
      • yalaforge
        did you try to reset the cc line? maybe there's something in there the parser doesn't like
      • luks
        but it should at least send a mail to wolfsong anyway
      • yalaforge
        hmm, yes
      • luks
        bleh
      • dju` joined the channel
      • time to enable trac's debug log
      • nice "07:01:43 Trac[web_ui] ERROR: Failure sending notification on change to ticket #1029: ..."
      • :/
      • rowaasr13
        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
      • in tp
      • er, for tp
      • but i haven't looked closely at any of it
      • or even briefly, i just sort of skimmed
      • yalaforge
        there are in fact a few strcpy()s in mb_client
      • "\"openURL(file://%s,new-window)\"");
      • stuff like this is no problem