#musicbrainz

/

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

        • 2003-10-10 28336, 2003

      • orogor
        hold on

        • 2003-10-10 28349, 2003

      • orogor
        http://80.15.38.101/music/

        • 2003-10-10 28356, 2003

      • orogor
        have a try , should work

        • 2003-10-10 28340, 2003

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

        • 2003-10-10 28353, 2003

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

        • 2003-10-10 28310, 2003

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

        • 2003-10-10 28313, 2003

      • orogor
        why ?

        • 2003-10-10 28332, 2003

      • orogor
        haa , i ll shut down the server just after

        • 2003-10-10 28345, 2003

      • taybin
        that's all your music?

        • 2003-10-10 28349, 2003

      • orogor
        yes

        • 2003-10-10 28310, 2003

      • orogor
        there s 2 album of keith jarret missing

        • 2003-10-10 28318, 2003

      • orogor
        but i have to re-encode em

        • 2003-10-10 28335, 2003

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

        • 2003-10-10 28351, 2003

      • orogor
        think i should generate a php page for viewing covers ?

        • 2003-10-10 28310, 2003

      • orogor
        just realised that

        • 2003-10-10 28357, 2003

      • orogor
        that s loooonnngg

        • 2003-10-10 28322, 2003

      • orogor
        260 unidentified , 508 identified , 2800 pending

        • 2003-10-10 28307, 2003

      • taybin
        http://80.15.38.101/rpm/

        • 2003-10-10 28323, 2003

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

        • 2003-10-10 28345, 2003

      • orogor
        why ?

        • 2003-10-10 28359, 2003

      • orogor
        do u know what this rpm script does ?

        • 2003-10-10 28307, 2003

      • taybin
        what does it do?

        • 2003-10-10 28330, 2003

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

        • 2003-10-10 28338, 2003

      • orogor
        based on 2 text files

        • 2003-10-10 28306, 2003

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

        • 2003-10-10 28317, 2003

      • taybin
        orogor: uh huh

        • 2003-10-10 28325, 2003

      • taybin
        orogor: nt?

        • 2003-10-10 28329, 2003

      • orogor
        xp

        • 2003-10-10 28339, 2003

      • orogor
        or nt5 it s same

        • 2003-10-10 28335, 2003

      • orogor
        haa , just been attacked

        • 2003-10-10 28345, 2003

      • orogor
        wanna see the logs ?

        • 2003-10-10 28339, 2003

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

        • 2003-10-10 28353, 2003

      • orogor
        nah it was a real attack

        • 2003-10-10 28304, 2003

      • taybin
        orogor: really? how do you know?

        • 2003-10-10 28308, 2003

      • orogor
        [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

        • 2003-10-10 28327, 2003

      • orogor
        just gived u the way to hack my server throught

        • 2003-10-10 28343, 2003

      • taybin
        I think that was me

        • 2003-10-10 28300, 2003

      • orogor
        u tried to run cmd.exe ?

        • 2003-10-10 28319, 2003

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

        • 2003-10-10 28327, 2003

      • orogor
        nahh

        • 2003-10-10 28344, 2003

      • orogor
        somone has tried to run cmd.exe from various ip

        • 2003-10-10 28356, 2003

      • orogor
        and tried a lot f other things too

        • 2003-10-10 28359, 2003

      • taybin
        orogor: scary

        • 2003-10-10 28311, 2003

      • orogor
        thats the way it it

        • 2003-10-10 28327, 2003

      • taybin
        that's why I reformat and reinstall every week

        • 2003-10-10 28344, 2003

      • orogor
        haa , jus realised it wasn t today

        • 2003-10-10 28320, 2003

      • orogor
        the attack was the 27 september

        • 2003-10-10 28311, 2003

      • orogor has quit

        • 2003-10-10 28359, 2003

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

        • 2003-10-10 28307, 2003

      • orogor
        oppps

        • 2003-10-10 28330, 2003

      • orogor
        i ve should have done this in pv

        • 2003-10-10 28353, 2003

      • orogor has quit

        • 2003-10-10 28337, 2003

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

        • 2003-10-10 28339, 2003

      • orogor has left the channel

        • 2003-10-10 28350, 2003

      • taybin has left the channel

        • 2003-10-10 28359, 2003

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

        • 2003-10-10 28343, 2003

      • orogor has left the channel

        • 2003-10-10 28314, 2003

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

        • 2003-10-10 28322, 2003

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

        • 2003-10-10 28354, 2003

      • sbw has quit

        • 2003-10-10 28303, 2003

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

        • 2003-10-10 28301, 2003

      • sward_3 has quit

        • 2003-10-10 28354, 2003

      • ruaok has quit

        • 2003-10-10 28301, 2003

      • djce
        djce (~davide@195.60.9.122) has joined #musicbrainz

        • 2003-10-10 28350, 2003

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

        • 2003-10-10 28310, 2003

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

        • 2003-10-10 28317, 2003

      • djce
        No? Was it not meant to be up?

        • 2003-10-10 28325, 2003

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

        • 2003-10-10 28332, 2003

      • djce
        It would certainly explain it.

        • 2003-10-10 28339, 2003

      • djce
        Unless it was his own dev server.

        • 2003-10-10 28315, 2003

      • ruaok
        I don't think he has a dev server.

        • 2003-10-10 28338, 2003

      • ruaok
        well, I sent him mail asking him...

        • 2003-10-10 28314, 2003

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

        • 2003-10-10 28315, 2003

      • ruaok
        Any ideas?

        • 2003-10-10 28320, 2003

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

        • 2003-10-10 28328, 2003

      • djce
        huh?

        • 2003-10-10 28336, 2003

      • djce
        Is it in the error log somewhere?

        • 2003-10-10 28343, 2003

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

        • 2003-10-10 28319, 2003

      • djce does so...

        • 2003-10-10 28346, 2003

      • ruaok
        MIME::Lite is now installed

        • 2003-10-10 28348, 2003

      • djce
        errr, are there any tracks to edit?

        • 2003-10-10 28311, 2003

      • djce
        maybe i can just add one...

        • 2003-10-10 28322, 2003

      • ruaok
        artist portishead :-)

        • 2003-10-10 28325, 2003

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

        • 2003-10-10 28336, 2003

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

        • 2003-10-10 28342, 2003

      • djce
        Anyway, it worked for me.

        • 2003-10-10 28358, 2003

      • djce
        See mod #6

        • 2003-10-10 28311, 2003

      • djce
        Or is it only when appying the mod?

        • 2003-10-10 28331, 2003

      • djce
        Ah. so it is. :-(

        • 2003-10-10 28302, 2003

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

        • 2003-10-10 28310, 2003

      • djce
        I forget where httpd is on that box...

        • 2003-10-10 28318, 2003

      • ruaok
        one sec.

        • 2003-10-10 28335, 2003

      • ruaok
        restarted

        • 2003-10-10 28337, 2003

      • djce
        ok

        • 2003-10-10 28347, 2003

      • ruaok
        nope.

        • 2003-10-10 28351, 2003

      • ruaok
        still happens.

        • 2003-10-10 28339, 2003

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

        • 2003-10-10 28350, 2003

      • ruaok
        which table??

        • 2003-10-10 28302, 2003

      • ruaok
        I just used the normal InitDb.pl script

        • 2003-10-10 28311, 2003

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

        • 2003-10-10 28320, 2003

      • ruaok ducks

        • 2003-10-10 28323, 2003

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

        • 2003-10-10 28331, 2003

      • djce
        'cos that table doesn't.

        • 2003-10-10 28337, 2003

      • ruaok
        Ohhh, that could be it.

        • 2003-10-10 28341, 2003

      • ruaok
        right.

        • 2003-10-10 28354, 2003

      • djce wags a finger at ruaok

        • 2003-10-10 28323, 2003

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

        • 2003-10-10 28329, 2003

      • djce
        Hmmm ;-)

        • 2003-10-10 28346, 2003

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

        • 2003-10-10 28356, 2003

      • ruaok
        Sure, let me do that.

        • 2003-10-10 28300, 2003

      • djce
        ok

        • 2003-10-10 28325, 2003

      • verus
        would be neat if you coudl theme your musicbrainz

        • 2003-10-10 28303, 2003

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

        • 2003-10-10 28300, 2003

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

        • 2003-10-10 28306, 2003

      • verus
        site

        • 2003-10-10 28313, 2003

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

        • 2003-10-10 28329, 2003

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

        • 2003-10-10 28336, 2003

      • RJ has quit

        • 2003-10-10 28339, 2003

      • verus
        neat

        • 2003-10-10 28341, 2003

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

        • 2003-10-10 28358, 2003

      • ruaok
        djce: that was it.

        • 2003-10-10 28301, 2003

      • djce
        good

        • 2003-10-10 28303, 2003

      • verus
        i was saying like some sites have it, changing colors

        • 2003-10-10 28312, 2003

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

        • 2003-10-10 28324, 2003

      • djce
        ruaok: Reading the dbmirror README it says:

        • 2003-10-10 28327, 2003

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

        • 2003-10-10 28328, 2003

      • djce
        defined.

        • 2003-10-10 28335, 2003

      • ruaok
        Whooops. :-(

        • 2003-10-10 28341, 2003

      • djce
        but says nothing about requiring a one-column PK.

        • 2003-10-10 28357, 2003

      • djce
        Ah, no, I see.

        • 2003-10-10 28302, 2003

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

        • 2003-10-10 28315, 2003

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

        • 2003-10-10 28322, 2003

      • djce
        which is the same as being a PK.

        • 2003-10-10 28327, 2003

      • djce
        But it's not actually a PK.

        • 2003-10-10 28340, 2003

      • ruaok grumbles

        • 2003-10-10 28342, 2003

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

        • 2003-10-10 28350, 2003

      • djce
        plus any other tables like it.

        • 2003-10-10 28300, 2003

      • ruaok
        I think those are the only ones.

        • 2003-10-10 28305, 2003

      • ruaok
        OK, I'll play with it later today.

        • 2003-10-10 28323, 2003

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

        • 2003-10-10 28333, 2003

      • djce is away: eating

        • 2003-10-10 28357, 2003

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

        • 2003-10-10 28331, 2003

      • ruaok
        Na!

        • 2003-10-10 28348, 2003

      • yalaforge
        hi :-)

        • 2003-10-10 28355, 2003

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

        • 2003-10-10 28357, 2003

      • ruaok
        Vielen dank!

        • 2003-10-10 28303, 2003

      • yalaforge
        np

        • 2003-10-10 28308, 2003

      • yalaforge
        I'm glad to be back

        • 2003-10-10 28319, 2003

      • ruaok
        How were the tests??