#musicbrainz

orogor: I don't have enough mp3s to bother.

hold on

have a try , should work

just brows , avoid download , or u ll kil my bandwith in a second

orogor: nice, are you sure you want to provide that to the world?

orogor: you just posted that in a chatroom...

why ?

haa , i ll shut down the server just after

that's all your music?

yes

there s 2 album of keith jarret missing

but i have to re-encode em

they are in ogg , i need em in MP3 , so they are in a temp dir

think i should generate a php page for viewing covers ?

just realised that

that s loooonnngg

260 unidentified , 508 identified , 2800 pending

dude, take that server off the net. It would be so easy for a script-kiddie to crack you.

why ?

do u know what this rpm script does ?

what does it do?

just says from where i ve downloaded all the rpm installed on my computers

based on 2 text files

i m on windows , i can t even read the linux filesysteme myself

orogor: uh huh

orogor: nt?

xp

or nt5 it s same

haa , just been attacked

wanna see the logs ?

orogor: that was probably just me randomly clicking buttons on your site

nah it was a real attack

orogor: really? how do you know?

[Sat Sep 27 19:53:40 2003] [error] [client 81.51.62.100] File does not exist: c:/program files/easyphp/www/scripts/..��/winnt/system32/cmd.exe

just gived u the way to hack my server throught

I think that was me

u tried to run cmd.exe ?

orogor: not on purpose, but I tried to run phpmyadmin and some other stuff

nahh

somone has tried to run cmd.exe from various ip

and tried a lot f other things too

orogor: scary

thats the way it it

that's why I reformat and reinstall every week

haa , jus realised it wasn t today

the attack was the 27 september

orogor (~orogor@AMarseille-206-1-5-101.w80-15.abo.wanad...) has joined #musicbrainz

oppps

i ve should have done this in pv

orogor (~orogor@AMarseille-206-1-5-101.w80-15.abo.wanad...) has joined #musicbrainz

orogor (~orogor@AMarseille-206-1-5-101.w80-15.abo.wanad...) has joined #musicbrainz

sward_3 (~sward@pcp715355pcs.alxndr01.va.comcast.net) has joined #musicbrainz

ruaok (~robert@adsl-63-194-101-14.dsl.snlo01.pacbell.net) has joined #musicbrainz

sward_2 (~sward@pool-138-88-153-210.esr.east.verizon.net) has joined #musicbrainz

djce (~davide@195.60.9.122) has joined #musicbrainz

ruaok (~robert@adsl-63-201-0-114.dsl.snlo01.pacbell.net) has joined #musicbrainz

djce: I'm not sure how that guy ended up using the staging server...

No? Was it not meant to be up?

I'm just /assuming/ it was the staging server.

It would certainly explain it.

Unless it was his own dev server.

I don't think he has a dev server.

well, I sent him mail asking him...

Oh and entering edit_track moderations barfs on the staging server with a 'cannot determine primark key error'.

Any ideas?

I can't see any mention of MIME::Lite in cranky's error log

huh?

Is it in the error log somewhere?

try to do a track name edit moderation on test.mb.org

MIME::Lite is now installed

errr, are there any tracks to edit?

maybe i can just add one...

artist portishead :-)

Ah! I forgot that browseartists won't let you browse ALL of them.

I saw the empty page and assumed it meant 0 artists.

Anyway, it worked for me.

See mod #6

Or is it only when appying the mod?

Ah. so it is. :-(

How about restarting Apache? It might have an out of date statement handle.

I forget where httpd is on that box...

one sec.

restarted

ok

nope.

still happens.

Is there anything special about the way that table was created?

I just used the normal InitDb.pl script

ah! I bet it's the replication triggers, isn't it?

Does the replication stuff require that each table has a single column PK?

'cos that table doesn't.

Ohhh, that could be it.

right.

I'm innocent -- I'm just hacking on other people code. :-)

Hmmm ;-)

Are you going to drop the rep. triggers on that DB?

Sure, let me do that.

ok

would be neat if you coudl theme your musicbrainz

That's certainly an idea I haven't heard suggested before!

Do you mean the web site, the Tagger, or both?

site

Maybe when the move to all CSS (i.e. all using .css files, not direct formatting) is done, this would be possible.

As long as someone could contribute the necessary style sheets and images, etc.

neat

then there's no reason this couldn't be done.

djce: that was it.

good

i was saying like some sites have it, changing colors

Of course I have no clue how to fix that...

ruaok: Reading the dbmirror README it says:

NOTE: DBMirror requires that every table being mirrored have a primary key

defined.

Whooops. :-(

but says nothing about requiring a one-column PK.

Ah, no, I see.

So we define a primary key and get on with life?

trackwords has a unique index on (wordid, trackid), and they're both NOT NULL.

which is the same as being a PK.

But it's not actually a PK.

So we'd just need to turn that unique index into a PK, and that should do it.

plus any other tables like it.

I think those are the only ones.

OK, I'll play with it later today.

ok. Anyway, food's ready ... catch you later I expect.

yalaforge (~matthias@krl9-d9bb4014.pool.mediaWays.net) has joined #musicbrainz

Na!

hi :-)

Mein Freund has das Geld von Dir erhalten und mir ruebergeschickt!

Vielen dank!

np

I'm glad to be back

How were the tests??