#musicbrainz

there are more than 30000 artists that only have one track

wow. Good stat.

custom query?

yes, wait a minute ...

the numbers are old, but still apply to some extent.

I see. Artists with no albums, group by track count.

yup. I already identified about 5000 of them that are duplicates

the follow the pattern '{artist we have} + some other string'

good idea.

and then there are wendell's reports, so we should get rid of many of them

as of a week ago:

FROM artist, track

WHERE NOT EXISTS (

SELECT * FROM album WHERE artist.id = album.artist

) AND artist.id = track.artist

GROUP BY artist.id

ORDER BY COUNT(track.id)

)

AS tracks_by_artist

GROUP BY numtracks

ORDER BY COUNT(artistid) DESC;

doh

try again

numtracks | count

-----------+-------

1 | 29235

2 | 6071

3 | 2108

4 | 1134

(damn X clipboards. grrrr.)

it gets worse

the whole VA submission process is BAD. really BAD.

I've seen submissions from good moderators that had mistakes in the artist fields

I think I can write a function that checks a proposed artist's name and makes suggestions to improve it

many people submit stuff like 'artist feat. artist' or 'x + y', 'x and y' etc.

that sounds good...

ok, I'll add it to my TODO for the next release

heh. my university was rated as "germany's best in computer science" :-)

according to cdrecord, my burner "Does return CD ISRC information"

interesting...

damn. ioctl_list(4) is outdated.

ok, I can read the "Universal Product Code" from a CD-Audio using a ioctl()

brb..

tried two discs. one had the UPC, the other didn't. and apparently, not all drives support to read the UPC :-(

the ISRC can be written using a CD burner but there's no way to read it

cool.

maybe now I can start to catch up on mb-users. 55 unread. eek!

nothing relevant, IMHO. just chat

ok, should be quick then.

oh, I got another X for you. maybe you can help.

s/X/Q/ (question). duh.

what am I like?

anyway, the question is this:

how can I use the X server when I'm su'd to another user?

e.g. login in as me; start X; su - anotheruser ; gvim

you mean, you can't start the program because you don't have the permissions?

which used to work on Red Hat, but now says "can't open display".

I can't remember if on RH I had to customise anything to make that work, or if it was like that by default.

I have this problem, too. it has something to do with authentication. xhost comes to mind.

wait a few minutes, I'll have a look at it

xauth is relevant, too

djce: ok, I think I know how it works

cool. beats the hell out of me.

in the account that started the X server: xauth extract - $DISPLAY > /tmp/cookie

in the other account you su-ed to: xauth merge /tmp/cookie

and also set DISPLAY identically on both accounts

yay!

You da man!

I don't know if the cookie expires after the server is restarted. you have to try that

but I don't think so

ok, we'll see.. Thanks.

np

orogor_ is now known as orogor

djce: 'xhost +localhost'

djce: that should fix your X problem

well, that's the easy way, anyway

:)

melange: but allows anyone on localhost to access the X server

how worried about that are you?

my box is used by several people

ok, well you need to be more restrictive then

if you're the only one on the box, or if you trust the others who access it, then xhost +localhost is fine

yup. and set $DISPLAY

that probably depends on if you "su -" or not

I tend to drop the "-" most of the time

I use it. my personal user has a strict umask

melange: thanks for the tip, btw

np

Hey, not bad. I allocated myself 30 minutes for that work. That was pretty close!

:-)

no no no, you're supposed to over-allocate, that way you can get it in and say "it's a miracle!"

(ref:

(ref: Scotty from Star Trek)

lol

well I did think I might round up a bit... say, in 30-minute chunks? Do you think rounding from 30:11 to 60:00 is too much? ;-)

It's a miracle!

;)

it means you've got 29:49 to surf the web until your next task

:)

it starts to waffle on a bit, but I think there's some general agreement now

I reduced the artist count instead

yalaforge: ?

yes?

"I reduced the artist count instead" - I don't understand

we have tons of duplicated artists

I submit merges or 'change artist' mods

ca. 25000-30000 of our artists are dupes, I guess

ok .. I'm still trying to work out how this relates to the MB thread

:)

it's a more useful way of spending 30 minutes :-)

I see :-)

aaaaaaaaahhhhh

*ding*

well, I think it was just the timing

I made my comment about waffling and agreements, and you said you just reduced the artist count (as if, reducing the artist count was a better way to deal with classical and mix naming)

oh :-)

which, of course, didn't make a lot of sense :)

aaaaaaanyway

yup. time to do some voting

yeah .. I've fallen off the top five. I've been slack the last week, only a few votes each day.

same here. but some on the top voters list seem to like the 'abstain' button

abstain's don't count on the top five though, right?

don't know

melange: I think you're right.

do artists with no albums get removed automatically?