#musicbrainz

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

7.4 i mean

:-(

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

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

how can i fix that?

edit <pg_data_dir>/pg_hba.conf

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

ive got local musicbrainz_db musicbrainz_user ident mb_map in

cd admin

./psql READWRITE

to test those settings.

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

The indent auth fails with the error above

ident*

I never understand all those shenanigans.

host all all 10.1.1.3/32 trust

where 10.1.1.3 is my local ip.

and everything is nicely tucked behind a firewall.

eew, /me hacks into ruaok's lan

good luck.

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

not really, unfortunately.

why not?

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

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

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

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.

i want replicated moderation :/

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

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

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..

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

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

I hate the evil empire

ha! http://blog.seattlepi.nwsource.com/microsoft/ar...

billg hates windows usablity. in 2003.

I tried using vista a couple of days ago.

woah. amazing.

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

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

I guess.

did you try logging in using psql, jacknetgb ?

using what user?

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

grr. and niklas

:-)

:(

something wrong?

ah

hello

tab complition got nikki not niklas :-)

lol

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.

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

well, at this stage it makes no sense.

one change and the test results are ALL DIFFERENT.

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

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

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?

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

nikki: right.

ruaok which user using psql?

just do ./psql READWRITE

it tests the settings in DBDefs.pm

Still the ident error

did you restart postgres? or HUP it?

i restarted it

then pg_hba is still wrong somehow.

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

I always install from source. that works predictably.

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

can you please consult the postgres docs?

for?

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

ok

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

yes

yawn

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

nothing to worry about

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

but its only took like 2 seconds to complete?

so it hasnt done anything i recon

what was your initdb command?

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

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

'night

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

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

warp: ok :) would be great

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.

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.

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

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

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

LotR: niklas' summer of code project!

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

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

bbiab

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

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

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).

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

aha

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

true

I'll keep it for now

Im gonna go buy groceries

omg nerdvana

hi guys

hellomo

byeniklas

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

its the next logical step after this scandinvasion

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

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.

I always think that in second hand CD shops anyway

yeah :)

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

or *record* store

@_@

speaking of scandinvasions

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

(

Yes! There is hope!

ladedida obama ladedida

\o/

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

\o/^2

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

haha

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

By all means.

I might even answer.

8)

it specifically mentions that "ripping" is illegal :p

Luckily it's not illegal here.