#musicbrainz

/

      • phidauex
        looks like its all working, ruaok :)

        • 2003-04-01 09125, 2003

      • phidauex
        one small problem.. with the 'tagger' test application, it will find matching tracks and list them 1. 2. 3. etc, but if you type '1' to choose, it just says "Query failed: No items matched"

        • 2003-04-01 09152, 2003

      • phidauex
        but thats probably just a boo boo in the test application, i can sucessfully get trms, get tracks, find albums, lookup cds, et

        • 2003-04-01 09125, 2003

      • phidauex
        good stuff, you rock the block party till my hair turns grey.

        • 2003-04-01 09111, 2003

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

        • 2003-04-01 09159, 2003

      • djce has quit

        • 2003-04-01 09141, 2003

      • jsimmons
        jsimmons is now known as jsimmons|april1

        • 2003-04-01 09136, 2003

      • djce
        djce (~davide@mkbackup.power.net.uk) has joined #musicbrainz

        • 2003-04-01 09155, 2003

      • ruaok
        hey

        • 2003-04-01 09112, 2003

      • ruaok
        I created a new account (on test) for user mb

        • 2003-04-01 09119, 2003

      • djce
        Hi

        • 2003-04-01 09131, 2003

      • ruaok
        I figured we'd use that account to run the staging server from.

        • 2003-04-01 09141, 2003

      • djce
        OK. Cool. How's the tagger?

        • 2003-04-01 09145, 2003

      • ruaok
        what is the best way to give that new user privs to access the database?

        • 2003-04-01 09152, 2003

      • ruaok
        I've never had to deal with PG perms before.

        • 2003-04-01 09103, 2003

      • ruaok
        tagger is lagging. :-)

        • 2003-04-01 09110, 2003

      • ruaok
        The macheads got to me first....

        • 2003-04-01 09117, 2003

      • djce
        If you use the new InitDB.pl, then it should create a new Pg user

        • 2003-04-01 09125, 2003

      • djce
        that user will own the database,

        • 2003-04-01 09125, 2003

      • ruaok
        DUH!

        • 2003-04-01 09126, 2003

      • ruaok
        Right.

        • 2003-04-01 09131, 2003

      • djce
        thus have all the perms required.

        • 2003-04-01 09141, 2003

      • ruaok
        Forgot about thet nicetly.

        • 2003-04-01 09150, 2003

      • ruaok
        Lemme blow the current db away.

        • 2003-04-01 09149, 2003

      • ruaok
        Grr. perms are still off.

        • 2003-04-01 09101, 2003

      • ruaok
        Does InitDb.pl need to run as root to get that right?

        • 2003-04-01 09110, 2003

      • djce
        On the DB? Lemme check...

        • 2003-04-01 09119, 2003

      • djce
        No, it just needs the "postgres" user to exist.

        • 2003-04-01 09125, 2003

      • djce
        Which of course it always will.

        • 2003-04-01 09126, 2003

      • ruaok
        crap.

        • 2003-04-01 09137, 2003

      • ruaok
        User mb still has no right to access the tables.

        • 2003-04-01 09103, 2003

      • ruaok
        I did a dropdb, InitDb.pl --createdb and then InitDb.pl --clean

        • 2003-04-01 09136, 2003

      • djce
        You're talking about the "musicbrainz" db on cranky?

        • 2003-04-01 09145, 2003

      • djce
        owned by postgres?

        • 2003-04-01 09155, 2003

      • ruaok
        yes

        • 2003-04-01 09116, 2003

      • djce
        So do you want to use the DB user "mb", or "postgres"?

        • 2003-04-01 09117, 2003

      • ruaok
        I dropped it, and then used InitDb.pl as user mb

        • 2003-04-01 09123, 2003

      • ruaok
        mb

        • 2003-04-01 09130, 2003

      • djce
        ok, wait a mo...

        • 2003-04-01 09129, 2003

      • djce
        Ah! Either you need to drop the db, edit DBDefs.pm (set DB_USER and edit DSN),

        • 2003-04-01 09136, 2003

      • ruaok
        oh and go read /root/mbpasswd for

        • 2003-04-01 09145, 2003

      • ruaok
        and nuke it when you got it.

        • 2003-04-01 09149, 2003

      • djce
        I don't know if that's supported though.

        • 2003-04-01 09123, 2003

      • djce
        That's the PW for the "mb" OS user?

        • 2003-04-01 09134, 2003

      • djce
        I was just su-ing to it :-)

        • 2003-04-01 09120, 2003

      • ruaok
        ya

        • 2003-04-01 09135, 2003

      • djce
        sorry, missed this line: /or/ try to change to ownership of the db.

        • 2003-04-01 09140, 2003

      • djce
        I don't know if that's supported though.

        • 2003-04-01 09115, 2003

      • ruaok
        what user do I create the db as in order to use it with mb?

        • 2003-04-01 09129, 2003

      • djce
        Whatever you like. Just remember to edit DBDefs.pm

        • 2003-04-01 09136, 2003

      • djce
        (before you run InitDB)

        • 2003-04-01 09142, 2003

      • ruaok
        that not working. :-(

        • 2003-04-01 09129, 2003

      • djce
        I don't see what the problem is; it's perfectly well set up for using "postgres" as the DB user right now, that works.

        • 2003-04-01 09148, 2003

      • djce
        If you want to change it, just edit DBDefs.pm (DSN and DB_USER), drop the DB, and re-run InitDB.

        • 2003-04-01 09112, 2003

      • ruaok is feeling dense.

        • 2003-04-01 09121, 2003

      • ruaok
        I guess I didn't want to use user postgres.

        • 2003-04-01 09130, 2003

      • ruaok
        for whatever whack-ass reason that was.

        • 2003-04-01 09142, 2003

      • djce
        Not using postgres is preferable, but not essential.

        • 2003-04-01 09152, 2003

      • ruaok
        the sessions and lock are not working yet...

        • 2003-04-01 09110, 2003

      • djce
        OK. That always seems to take a few attempts to get right.

        • 2003-04-01 09121, 2003

      • ruaok
        yep

        • 2003-04-01 09126, 2003

      • djce
        The config is too scattered to make that bit easy :-(

        • 2003-04-01 09152, 2003

      • djce
        (Oh yeah looks like I lied about changing 'DSN' - no need to change that)

        • 2003-04-01 09153, 2003

      • ruaok
        at least I can load a fresh dataset in a minute :-)

        • 2003-04-01 09128, 2003

      • djce
        A, err, rather small dataset? :-)

        • 2003-04-01 09101, 2003

      • djce
        Wow. Tim just told me that yesterday he caught up with all 3000+ pending moderations! Abstained from loads, but still.... :-)

        • 2003-04-01 09125, 2003

      • ruaok
        damn. tell him thanks!

        • 2003-04-01 09134, 2003

      • djce
        Will do!

        • 2003-04-01 09159, 2003

      • ruaok
        we need to create the subscribe to artist feature so that when mods for an artist come in it sends mail to the user.

        • 2003-04-01 09145, 2003

      • djce
        OK, so before which we need to clean up the "email" column on the mod table. It's totally unvalidated so far.

        • 2003-04-01 09104, 2003

      • djce
        There's some "foo at bar dot com" -type entries in there.

        • 2003-04-01 09106, 2003

      • ruaok
        Yes.

        • 2003-04-01 09127, 2003

      • ruaok
        But, I think that should be done when the user subscribes.

        • 2003-04-01 09145, 2003

      • ruaok
        Is THIS -> foo bar @ fus dot com <- your right addy?

        • 2003-04-01 09112, 2003

      • ruaok
        I'll go tinker more.

        • 2003-04-01 09116, 2003

      • ruaok
        Have a good day at work.

        • 2003-04-01 09116, 2003

      • djce
        Well, we can do some proper validation stuff when the time comes. You know, e-mail a link, etc.

        • 2003-04-01 09125, 2003

      • ruaok
        ya

        • 2003-04-01 09130, 2003

      • djce
        OK. Sleep well!

        • 2003-04-01 09138, 2003

      • djce
        night!

        • 2003-04-01 09147, 2003

      • djce has quit

        • 2003-04-01 09141, 2003

      • phidauex
        ruaok: still around?

        • 2003-04-01 09149, 2003

      • ruaok
        barely.

        • 2003-04-01 09135, 2003

      • phidauex
        kk

        • 2003-04-01 09137, 2003

      • phidauex
        k

        • 2003-04-01 09146, 2003

      • phidauex
        just wanted to let you know that mb_client compiled happily

        • 2003-04-01 09153, 2003

      • phidauex
        and works like a charm

        • 2003-04-01 09133, 2003

      • ruaok
        sweet.

        • 2003-04-01 09138, 2003

      • ruaok
        glad to hear it.

        • 2003-04-01 09149, 2003

      • ruaok
        More Mac shit coming soon -- I promise.

        • 2003-04-01 09153, 2003

      • ruaok
        but bedtime for me.

        • 2003-04-01 09155, 2003

      • ruaok
        later!

        • 2003-04-01 09157, 2003

      • phidauex
        thanks

        • 2003-04-01 09100, 2003

      • ruaok
        ruaok is now known as ruaok|zzz

        • 2003-04-01 09100, 2003

      • phidauex
        night, ruaok

        • 2003-04-01 09109, 2003

      • phidauex
        us mac folks are taking over MB

        • 2003-04-01 09115, 2003

      • phidauex
        muahaha

        • 2003-04-01 09157, 2003

      • alus_
        alus_ (alus@cs242710-9.austin.rr.com) has joined #musicbrainz

        • 2003-04-01 09157, 2003

      • alus has quit

        • 2003-04-01 09115, 2003

      • alus_
        alus_ is now known as alus

        • 2003-04-01 09122, 2003

      • phidauex__
        phidauex__ (~phidauex@dsl093-192-027.stl1.dsl.speakeasy.net) has joined #musicbrainz

        • 2003-04-01 09123, 2003

      • phidauex has quit

        • 2003-04-01 09108, 2003

      • kyleboon|sleep
        kyleboon|sleep is now known as kyleboon|work

        • 2003-04-01 09104, 2003

      • icepick
        icepick is now known as icepick-away

        • 2003-04-01 09133, 2003

      • Rotty
        Rotty (someone@dsl-152-218.utaonline.at) has joined #musicbrainz

        • 2003-04-01 09118, 2003

      • icepick-away
        icepick-away is now known as icepick

        • 2003-04-01 09132, 2003

      • eikeon has left the channel

        • 2003-04-01 09126, 2003

      • eikeon
        eikeon (~eikeon@jungle.ne.client2.attbi.com) has joined #musicbrainz

        • 2003-04-01 09134, 2003

      • Rotty_
        Rotty_ (someone@dsl-243-233.utaonline.at) has joined #musicbrainz

        • 2003-04-01 09158, 2003

      • Rotty__
        Rotty__ (someone@dsl-242-235.utaonline.at) has joined #musicbrainz

        • 2003-04-01 09123, 2003

      • Rotty has quit

        • 2003-04-01 09103, 2003

      • alus has quit

        • 2003-04-01 09103, 2003

      • alus_
        alus_ (~alus@cs242710-9.austin.rr.com) has joined #musicbrainz

        • 2003-04-01 09121, 2003

      • alus_
        alus_ is now known as alus

        • 2003-04-01 09155, 2003

      • ruaok|zzz has quit

        • 2003-04-01 09132, 2003

      • Rotty_ has quit

        • 2003-04-01 09112, 2003

      • Rotty_
        Rotty_ (someone@dsl-239-124.utaonline.at) has joined #musicbrainz

        • 2003-04-01 09142, 2003

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

        • 2003-04-01 09143, 2003

      • phidauex__ has quit

        • 2003-04-01 09113, 2003

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

        • 2003-04-01 09126, 2003

      • ruaok
        djce: evening!

        • 2003-04-01 09111, 2003

      • ruaok
        did you look at the errors in /etc/build_words.out ?

        • 2003-04-01 09139, 2003

      • djce
        hi

        • 2003-04-01 09140, 2003

      • phidauex
        phidauex (~phidauex@dsl093-192-027.stl1.dsl.speakeasy.net) has joined #musicbrainz

        • 2003-04-01 09151, 2003

      • djce
        not yet... just looking at the error on "newsearch.html"

        • 2003-04-01 09159, 2003

      • djce
        (you're talking about the test server, right?)

        • 2003-04-01 09110, 2003

      • ruaok
        fidodough: how are things?

        • 2003-04-01 09113, 2003

      • ruaok
        dah.

        • 2003-04-01 09116, 2003

      • phidauex
        doing well

        • 2003-04-01 09130, 2003

      • ruaok
        I walked into my office and heard the hard drive rumbling. Sounded like you. :-)

        • 2003-04-01 09134, 2003

      • phidauex
        haven't had much chance to play with mb_client, but everything cept the tagger example seem to be working fine

        • 2003-04-01 09137, 2003

      • phidauex
        hehe

        • 2003-04-01 09159, 2003

      • ruaok
        good.

        • 2003-04-01 09102, 2003

      • djce
        ruaok: where's build_words.out ?

        • 2003-04-01 09113, 2003

      • ruaok
        I have one build issue under linux to address and then I will release 2.0.2

        • 2003-04-01 09118, 2003

      • phidauex
        i wish i could communicate by sending tiny programs that control disk access to make the drive's speak

        • 2003-04-01 09118, 2003

      • ruaok
        djce: /tmp

        • 2003-04-01 09122, 2003

      • djce
        ok

        • 2003-04-01 09126, 2003

      • phidauex
        or just beep you in morse code

        • 2003-04-01 09106, 2003

      • djce
        errr, but there's no errors there are there? Looks like a good clean run to me.

        • 2003-04-01 09134, 2003

      • ruaok
        errr

        • 2003-04-01 09100, 2003

      • ruaok
        Yes there were errors, but I guess they ended up on my console. :-(

        • 2003-04-01 09109, 2003

      • ruaok
        Wich is on the other end of town.

        • 2003-04-01 09110, 2003

      • djce
        OK, shall I re-run it?

        • 2003-04-01 09119, 2003

      • ruaok
        Perhaps check out if all is in order.

        • 2003-04-01 09127, 2003

      • djce
        ok

        • 2003-04-01 09129, 2003

      • ruaok
        Maybe something didn't get build.

        • 2003-04-01 09154, 2003

      • ruaok
        if it needs to get rebuilt, I can try again when I'm done hacking on the tagger.

        • 2003-04-01 09121, 2003

      • djce
        one duplicate index: "drop index wordlist_wordindex;"

        • 2003-04-01 09124, 2003

      • djce
        (done)