#musicbrainz

/

      • jacknetgb
        hey ruaok it failed again, but the problem was the old 7.1 process was still running

        • 2008-06-25 17744, 2008

      • jacknetgb
        7.4 i mean

        • 2008-06-25 17748, 2008

      • ruaok
        :-(

        • 2008-06-25 17755, 2008

      • Knio has quit

        • 2008-06-25 17705, 2008

      • Knio joined the channel

        • 2008-06-25 17705, 2008

      • ruaok
        at least that is easy to fix. just takes time.

        • 2008-06-25 17714, 2008

      • jacknetgb
        psql: FATAL: Ident authentication failed for user "musicbrainz_user"

        • 2008-06-25 17718, 2008

      • jacknetgb
        how can i fix that?

        • 2008-06-25 17751, 2008

      • ruaok
        edit <pg_data_dir>/pg_hba.conf

        • 2008-06-25 17704, 2008

      • ruaok
        and add permissions for your user/ip combo to access the server

        • 2008-06-25 17721, 2008

      • jacknetgb
        ive got local musicbrainz_db musicbrainz_user ident mb_map in

        • 2008-06-25 17743, 2008

      • ruaok
        cd admin

        • 2008-06-25 17748, 2008

      • ruaok
        ./psql READWRITE

        • 2008-06-25 17751, 2008

      • ruaok
        to test those settings.

        • 2008-06-25 17704, 2008

      • ruaok
        if you get the DB prompt, you're all good.

        • 2008-06-25 17711, 2008

      • ruaok
        or a no db exists error

        • 2008-06-25 17704, 2008

      • jacknetgb
        The indent auth fails with the error above

        • 2008-06-25 17708, 2008

      • jacknetgb
        ident*

        • 2008-06-25 17751, 2008

      • ruaok
        I never understand all those shenanigans.

        • 2008-06-25 17756, 2008

      • ruaok
        host all all 10.1.1.3/32 trust

        • 2008-06-25 17702, 2008

      • ruaok
        where 10.1.1.3 is my local ip.

        • 2008-06-25 17713, 2008

      • ruaok
        and everything is nicely tucked behind a firewall.

        • 2008-06-25 17729, 2008

      • xlotlu
        eew, /me hacks into ruaok's lan

        • 2008-06-25 17738, 2008

      • ruaok
        good luck.

        • 2008-06-25 17747, 2008

      • nikki uses trust too

        • 2008-06-25 17714, 2008

      • LotR
        ruaok: would something like this be helpful? http://nopaste.snit.ch/13398

        • 2008-06-25 17736, 2008

      • ruaok
        not really, unfortunately.

        • 2008-06-25 17741, 2008

      • LotR
        why not?

        • 2008-06-25 17757, 2008

      • ruaok
        because you'd need a known DB that doesn't change to sit under the hood.

        • 2008-06-25 17723, 2008

      • ruaok
        because automated tests will fail randomly on a constantly changing database. :-(

        • 2008-06-25 17741, 2008

      • ruaok
        so you've solved the easy part. now the hard work needs to be done. :-(

        • 2008-06-25 17741, 2008

      • LotR
        ruaok: you can write the tests so they are more resilient to changes. I'd say the tests I wrote really shouldn't fail even if the database changes.

        • 2008-06-25 17704, 2008

      • xlotlu
        i want replicated moderation :/

        • 2008-06-25 17711, 2008

      • LotR
        ruaok: but I understand that more interesting tests would be harder to write

        • 2008-06-25 17756, 2008

      • ruaok
        and the things I am testing hard for are ordering of search results.

        • 2008-06-25 17705, 2008

      • LotR
        ruaok: if you give me an example of a real check you want to make, I can see if I can come up with the corresponding test..

        • 2008-06-25 17705, 2008

      • ruaok
        and that assumes that you have thousands of records for it to work right.

        • 2008-06-25 17739, 2008

      • ruaok
        a search for "faye wong" should have her appear in the top 3 hits.

        • 2008-06-25 17745, 2008

      • MBChatLogger
        I hate the evil empire

        • 2008-06-25 17745, 2008

      • ruaok
        ha! http://blog.seattlepi.nwsource.com/microsoft/arch…

        • 2008-06-25 17759, 2008

      • ruaok
        billg hates windows usablity. in 2003.

        • 2008-06-25 17707, 2008

      • ruaok
        I tried using vista a couple of days ago.

        • 2008-06-25 17714, 2008

      • ruaok
        woah. amazing.

        • 2008-06-25 17707, 2008

      • adamgolding has quit

        • 2008-06-25 17711, 2008

      • adamgolding joined the channel

        • 2008-06-25 17745, 2008

      • jacknetgb
        i still get that error with the line added that you said above (modified for my network of course)

        • 2008-06-25 17701, 2008

      • LotR
        ruaok: http://nopaste.snit.ch/13399 <-- better?

        • 2008-06-25 17718, 2008

      • ruaok
        I guess.

        • 2008-06-25 17735, 2008

      • ruaok
        did you try logging in using psql, jacknetgb ?

        • 2008-06-25 17756, 2008

      • jacknetgb
        using what user?

        • 2008-06-25 17758, 2008

      • niklas joined the channel

        • 2008-06-25 17708, 2008

      • ruaok
        LotR: I just can't conceive of writing test cases that are not going to be brittle

        • 2008-06-25 17719, 2008

      • ruaok waves at nikki

        • 2008-06-25 17723, 2008

      • ruaok
        grr. and niklas

        • 2008-06-25 17727, 2008

      • ruaok
        :-)

        • 2008-06-25 17730, 2008

      • niklas
        :(

        • 2008-06-25 17735, 2008

      • niklas
        something wrong?

        • 2008-06-25 17701, 2008

      • niklas
        ah

        • 2008-06-25 17702, 2008

      • niklas
        hello

        • 2008-06-25 17714, 2008

      • ruaok
        tab complition got nikki not niklas :-)

        • 2008-06-25 17735, 2008

      • nikki waves back at ruaok anyway

        • 2008-06-25 17756, 2008

      • ruaok
        lol

        • 2008-06-25 17754, 2008

      • LotR
        ruaok: I thought it'd be useful to not have to do all the testing by hand. even if it might be a bit brittle, it still seems less work to me to figure out if a test is genuinely failing or if it's just because the test isn't good enough.

        • 2008-06-25 17706, 2008

      • LotR
        ruaok: I can stop if you're not interested though :)

        • 2008-06-25 17711, 2008

      • ruaok
        well, at this stage it makes no sense.

        • 2008-06-25 17722, 2008

      • ruaok
        one change and the test results are ALL DIFFERENT.

        • 2008-06-25 17738, 2008

      • ruaok
        It's too early for what you're suggesting.

        • 2008-06-25 17701, 2008

      • ruaok
        once I figure out what I'm doing, I'll come back to this...

        • 2008-06-25 17730, 2008

      • nikki
        I'm only half paying attention, but isn't the idea that you can put a list of searches and a list of results there and see whether they're found properly or not without doing the same searches over and over?

        • 2008-06-25 17742, 2008

      • LotR
        ruaok: you can also write TODO tests. so you write them how you'd *like* the results to be, and then if you run the test it will fail, but it won't really count

        • 2008-06-25 17757, 2008

      • LotR
        nikki: right.

        • 2008-06-25 17750, 2008

      • jacknetgb
        ruaok which user using psql?

        • 2008-06-25 17704, 2008

      • ruaok
        just do ./psql READWRITE

        • 2008-06-25 17712, 2008

      • ruaok
        it tests the settings in DBDefs.pm

        • 2008-06-25 17737, 2008

      • jacknetgb
        Still the ident error

        • 2008-06-25 17703, 2008

      • ruaok
        did you restart postgres? or HUP it?

        • 2008-06-25 17709, 2008

      • jacknetgb
        i restarted it

        • 2008-06-25 17732, 2008

      • ruaok
        then pg_hba is still wrong somehow.

        • 2008-06-25 17748, 2008

      • ruaok
        I have yet to get the pg from pre-built packages to work.

        • 2008-06-25 17756, 2008

      • ruaok
        I always install from source. that works predictably.

        • 2008-06-25 17701, 2008

      • jacknetgb
        Heres my pg_hba.conf http://jacknet.co.uk/pg_hba.txt

        • 2008-06-25 17726, 2008

      • ruaok
        can you please consult the postgres docs?

        • 2008-06-25 17701, 2008

      • jacknetgb
        for?

        • 2008-06-25 17717, 2008

      • ruaok
        further help on this? I'm working on other stuff atm

        • 2008-06-25 17704, 2008

      • jacknetgb
        ok

        • 2008-06-25 17735, 2008

      • jacknetgb
        Is it fine if i just get the database does not exist error?

        • 2008-06-25 17744, 2008

      • ruaok
        yes

        • 2008-06-25 17748, 2008

      • xlotlu
        yawn

        • 2008-06-25 17735, 2008

      • jacknetgb
        WARNING: skipping "pg_shdepend" --- only table or database owner can vacuum it , any ideas?

        • 2008-06-25 17711, 2008

      • xlotlu
        nothing to worry about

        • 2008-06-25 17720, 2008

      • jacknetgb
        Wed Jun 25 21:25:14 2008 : InitDb.pl succeeded

        • 2008-06-25 17725, 2008

      • jacknetgb
        but its only took like 2 seconds to complete?

        • 2008-06-25 17730, 2008

      • jacknetgb
        so it hasnt done anything i recon

        • 2008-06-25 17748, 2008

      • ruaok
        what was your initdb command?

        • 2008-06-25 17718, 2008

      • jacknetgb
        ./admin/InitDb.pl --createdb --import mbdump*.tar.bz2

        • 2008-06-25 17716, 2008

      • ruaok
        I doubt that this would change it, but try cd'ing into admin and rerun with the path for import fixed up

        • 2008-06-25 17744, 2008

      • xlotlu
        'night

        • 2008-06-25 17752, 2008

      • xlotlu has quit

        • 2008-06-25 17704, 2008

      • niklas
        warp: are you going to make the tool keep track of which releases have been submitted?

        • 2008-06-25 17740, 2008

      • warp
        niklas: i can do that, if you don't expect anything fancy :)

        • 2008-06-25 17758, 2008

      • niklas
        warp: ok :) would be great

        • 2008-06-25 17743, 2008

      • warp
        it's a commandline tool, i'm assuming people will run it in their ~/music directory or something. an easy way to do it is to assume each release lives in its own subdirectory, and just write a small file there which says the release has already been submitted.

        • 2008-06-25 17741, 2008

      • warp
        the other option would be to keep a central database of submitted MBIDs, also shouldn't be much work with python, but i'm not that familiar with such databases.

        • 2008-06-25 17746, 2008

      • LotR
        warp: you could just read the files for MB tags, no? no need for extra files

        • 2008-06-25 17728, 2008

      • warp
        LotR: i can't _see_ with just an mbid if that release has already been submitted to niklas' collection db.

        • 2008-06-25 17734, 2008

      • LotR
        I guess I don't know what 'collection db' is

        • 2008-06-25 17744, 2008

      • warp
        LotR: niklas' summer of code project!

        • 2008-06-25 17746, 2008

      • niklas
        warp: would it help you when developing if you can see "duplicates"? mbid's that have been submitted but already are in the database

        • 2008-06-25 17758, 2008

      • niklas
        LotR: http://niklasbe.wordpress.com :)

        • 2008-06-25 17705, 2008

      • ruaok heads to lunch

        • 2008-06-25 17707, 2008

      • ruaok
        bbiab

        • 2008-06-25 17756, 2008

      • warp
        niklas: not really, i think it would be better to just silently ignore them. I don't think there is any harm.

        • 2008-06-25 17725, 2008

      • niklas
        no but I was thinking just while youre developing, to make sure theyre saved correctly

        • 2008-06-25 17710, 2008

      • warp
        niklas: I think I actually have one duplicate in my /mnt/music directory. (flac and mp3 versions of the same release which _I_ consider seperate releases, they have different catalog #s, but for MB they are just one release).

        • 2008-06-25 17723, 2008

      • niklas
        because I did that. keep a list of duplicates. doesnt require any extra querys. but I'll just remove it if it is unnecessary

        • 2008-06-25 17731, 2008

      • niklas
        aha

        • 2008-06-25 17744, 2008

      • warp
        niklas: maybe other users would eventually like to see that reported, so don't ask _just_ me :).

        • 2008-06-25 17728, 2008

      • niklas
        true

        • 2008-06-25 17731, 2008

      • niklas
        I'll keep it for now

        • 2008-06-25 17740, 2008

      • niklas
        Im gonna go buy groceries

        • 2008-06-25 17751, 2008

      • CatCat
        omg nerdvana

        • 2008-06-25 17754, 2008

      • CatCat
        hi guys

        • 2008-06-25 17707, 2008

      • warp
        hellomo

        • 2008-06-25 17712, 2008

      • warp
        byeniklas

        • 2008-06-25 17717, 2008

      • CatCat
        I sure do hope that MGdesigner guy shows up again- cool people from asia in #musicbrainz

        • 2008-06-25 17712, 2008

      • CatCat
        its the next logical step after this scandinvasion

        • 2008-06-25 17728, 2008

      • Kerensky97
        It'd be nice just so we get people adding Asian albums en mass.

        • 2008-06-25 17703, 2008

      • Kerensky97
        When I was in Japan going through used CD stores I was thinking how cool it would be just to get paid to go though all the CDs there and enter them into MB.

        • 2008-06-25 17744, 2008

      • nikki
        I always think that in second hand CD shops anyway

        • 2008-06-25 17721, 2008

      • Kerensky97
        yeah :)

        • 2008-06-25 17711, 2008

      • LotR
        so get a job at a 2nd hand cd store? :)

        • 2008-06-25 17756, 2008

      • CatCat
        or *record* store

        • 2008-06-25 17758, 2008

      • CatCat
        @_@

        • 2008-06-25 17726, 2008

      • Tykling joined the channel

        • 2008-06-25 17749, 2008

      • CatCat
        speaking of scandinvasions

        • 2008-06-25 17743, 2008

      • CatCat
        hmm canidae har ikke vært her inne på en stund :

        • 2008-06-25 17745, 2008

      • CatCat
        (

        • 2008-06-25 17724, 2008

      • MBChatLogger
        Yes! There is hope!

        • 2008-06-25 17724, 2008

      • CatCat
        ladedida obama ladedida

        • 2008-06-25 17728, 2008

      • CatCat
        \o/

        • 2008-06-25 17700, 2008

      • srotta
        I've been thinking about going to local library with a laptop and just going through all the releases.

        • 2008-06-25 17709, 2008

      • CatCat
        \o/^2

        • 2008-06-25 17718, 2008

      • srotta
        They removed locked cases from cds so I could actually do that some day.

        • 2008-06-25 17705, 2008

      • warp
        haha

        • 2008-06-25 17734, 2008

      • Wizzcat
        at the library here they have signs saying they can and will ask you what you're doing if you use a computer to listen to music in the library

        • 2008-06-25 17709, 2008

      • srotta
        By all means.

        • 2008-06-25 17718, 2008

      • srotta
        I might even answer.

        • 2008-06-25 17719, 2008

      • srotta
        8)

        • 2008-06-25 17729, 2008

      • Wizzcat
        it specifically mentions that "ripping" is illegal :p

        • 2008-06-25 17742, 2008

      • srotta
        Luckily it's not illegal here.