#metabrainz

/

      • samphippen
        I did not pay for *one thing* while I was there
      • 2015-09-28 27109, 2015

      • samphippen
        (they even covered my flights :O)
      • 2015-09-28 27116, 2015

      • alastairp
        instead you payed for 10000 things!
      • 2015-09-28 27124, 2015

      • ruaok
        good deal. that was my arrangement too when I went there.
      • 2015-09-28 27125, 2015

      • samphippen
        :D
      • 2015-09-28 27136, 2015

      • ruaok
        but to get a souvenir for my mom was... ugh.
      • 2015-09-28 27138, 2015

      • samphippen
        now I'm geocoding ~600,000 addresses for a client
      • 2015-09-28 27122, 2015

      • samphippen has quit
      • 2015-09-28 27131, 2015

      • samphipp_ joined the channel
      • 2015-09-28 27102, 2015

      • Mogmi_ is now known as Momgi
      • 2015-09-28 27108, 2015

      • Momgi is now known as Mogmi
      • 2015-09-28 27148, 2015

      • ruaok
        zas: hypnocat is making me ill. :(
      • 2015-09-28 27112, 2015

      • alastairp
        samphipp_: got 5 minutes to pair on a flask question?
      • 2015-09-28 27119, 2015

      • samphipp_
        sure
      • 2015-09-28 27121, 2015

      • samphipp_ is now known as samphippen
      • 2015-09-28 27138, 2015

      • alastairp
      • 2015-09-28 27155, 2015

      • alastairp
        it seems that one recommendation is to put your current session's connection in flask.g
      • 2015-09-28 27123, 2015

      • alastairp
        but that doesn't help if 1) you also want to use stuff from a command line program, 2) you want to isolate your db models/functions to not rely on flask
      • 2015-09-28 27100, 2015

      • zas
        ruaok: this cat is overpowered imho
      • 2015-09-28 27107, 2015

      • alastairp
        I'm trying to work out a compromise that lets me use my same database access package from cli or flask
      • 2015-09-28 27116, 2015

      • ruaok nods
      • 2015-09-28 27143, 2015

      • alastairp
      • 2015-09-28 27144, 2015

      • alastairp
        we used to have something like https://github.com/metabrainz/acousticbrainz-serv…, but we're moving away from psycopg2 to sqlalchemy.
      • 2015-09-28 27112, 2015

      • alastairp
        I don't want to create a new connection every time I go into a function. ideally it'd happen once at the beginning of a flask request, or script startup
      • 2015-09-28 27141, 2015

      • alastairp
        I guess I could just have a method in db/__init__ to create a connection and save it to db.connection. then I can call that in @before_request, or at the top of the script
      • 2015-09-28 27121, 2015

      • alastairp
        that is - almost exactly like what's there already, except I do it per-request instead of per-server isntance
      • 2015-09-28 27122, 2015

      • alastairp
        instance
      • 2015-09-28 27127, 2015

      • alastairp
        thanks
      • 2015-09-28 27124, 2015

      • alastairp
        ruaok: 🍍 it?
      • 2015-09-28 27140, 2015

      • ruaok
        I'm finding that emoji are a great way of being non-sequitoristic.
      • 2015-09-28 27150, 2015

      • ruaok
        If that is even a word. ;)
      • 2015-09-28 27133, 2015

      • ruaok
        zas: you around?
      • 2015-09-28 27149, 2015

      • zas
        ruaok: yes
      • 2015-09-28 27133, 2015

      • ruaok
        ok, running the localhost-setup script on all of our servers now.
      • 2015-09-28 27146, 2015

      • ruaok
        I can run you through our servers as I do that.
      • 2015-09-28 27152, 2015

      • ruaok
        you can follow along, take notes and see that you can log in.
      • 2015-09-28 27154, 2015

      • ruaok
        first one
      • 2015-09-28 27158, 2015

      • ruaok
      • 2015-09-28 27136, 2015

      • ruaok
        for each server, make sure you have sudo
      • 2015-09-28 27148, 2015

      • ruaok
        nagios is hosted at the OSLOSU and is intentionally not hosted at DWNI.
      • 2015-09-28 27156, 2015

      • ruaok
        so that it can monitor DWNI.
      • 2015-09-28 27125, 2015

      • zas
        no ssh to nagios.mb.org
      • 2015-09-28 27148, 2015

      • ruaok
        and you're expanding that to nagios.musicbrainz.org right?
      • 2015-09-28 27118, 2015

      • zas
        yup, ok now, it timed out on first attempt
      • 2015-09-28 27140, 2015

      • zas
        sudo ok
      • 2015-09-28 27117, 2015

      • ruaok
        next
      • 2015-09-28 27120, 2015

      • ruaok
      • 2015-09-28 27135, 2015

      • ruaok
        that is our freedb gateway that chirlu` has recently adopted to look after
      • 2015-09-28 27141, 2015

      • ruaok hopes it is housebroken
      • 2015-09-28 27113, 2015

      • zas
        ok ssh + sudo
      • 2015-09-28 27119, 2015

      • ruaok
      • 2015-09-28 27124, 2015

      • ruaok
        our currently active gateway.
      • 2015-09-28 27129, 2015

      • ruaok
        pair to bert.
      • 2015-09-28 27137, 2015

      • ruaok
        failover isn't fully setup yet.
      • 2015-09-28 27146, 2015

      • ruaok
        I want to finish that myself before I hand it over to you.
      • 2015-09-28 27116, 2015

      • zas
        ok
      • 2015-09-28 27101, 2015

      • ruaok
        ok, now moving into our hosting setup.
      • 2015-09-28 27117, 2015

      • ruaok
        have a quick look at syswiki/NetworkTopology.md
      • 2015-09-28 27156, 2015

      • reosarevok joined the channel
      • 2015-09-28 27156, 2015

      • reosarevok has quit
      • 2015-09-28 27156, 2015

      • reosarevok joined the channel
      • 2015-09-28 27131, 2015

      • samphipp_ joined the channel
      • 2015-09-28 27108, 2015

      • samphippen has quit
      • 2015-09-28 27140, 2015

      • ruaok
        lb1 and zaphod are aliases for machines.
      • 2015-09-28 27153, 2015

      • ruaok
        zaphod is the currently active gateway machine.
      • 2015-09-28 27124, 2015

      • zas
        ok noted
      • 2015-09-28 27107, 2015

      • ruaok
        internally we have our own DNS server.
      • 2015-09-28 27116, 2015

      • ruaok
        with its own TLD: .mb
      • 2015-09-28 27119, 2015

      • ruaok
        ssh scooby.mb
      • 2015-09-28 27123, 2015

      • ruaok
        works from ernie/bert
      • 2015-09-28 27104, 2015

      • zas
        scooby asks a password atm
      • 2015-09-28 27132, 2015

      • ruaok
        yeah, I'm still working on scooby, sorry.
      • 2015-09-28 27137, 2015

      • ruaok
        scooby is special.
      • 2015-09-28 27139, 2015

      • zas
        np ;)
      • 2015-09-28 27141, 2015

      • samphipp_ has quit
      • 2015-09-28 27138, 2015

      • ruaok
        scooby has been in service continuously since 2006.
      • 2015-09-28 27150, 2015

      • ruaok
        wrap your head around that.
      • 2015-09-28 27159, 2015

      • ruaok
        it needs to head to retirement soon.
      • 2015-09-28 27106, 2015

      • ruaok
        but it sill has stats and FTP on it.
      • 2015-09-28 27155, 2015

      • reosarevok
        ruaok: did you put up the stuff from this book again?
      • 2015-09-28 27103, 2015

      • ruaok
        reosarevok: yes
      • 2015-09-28 27106, 2015

      • reosarevok
        Ok :)
      • 2015-09-28 27118, 2015

      • ruaok
        zas: scooby is so old it won't even run this script.
      • 2015-09-28 27129, 2015

      • reosarevok
        I guess I'll write to Peter and see what they're thinking of
      • 2015-09-28 27150, 2015

      • ruaok
        reosarevok: please do.
      • 2015-09-28 27156, 2015

      • samphippen joined the channel
      • 2015-09-28 27158, 2015

      • ruaok
        zas: we'll come back to scooby
      • 2015-09-28 27100, 2015

      • ruaok
        next: cartman.mb
      • 2015-09-28 27110, 2015

      • ruaok
        cartman is our index generator for the search indexes.
      • 2015-09-28 27126, 2015

      • ruaok
        in an endless loop of making indexes and pushing them to our search servers
      • 2015-09-28 27131, 2015

      • zas
        cartman asks pw too
      • 2015-09-28 27150, 2015

      • ruaok
        try again
      • 2015-09-28 27153, 2015

      • ruaok
        the script just finished
      • 2015-09-28 27113, 2015

      • samphippen has quit
      • 2015-09-28 27151, 2015

      • zas
        does the script supposed to add ssh keys on ernie/bert zas/.ssh ? there is none atm
      • 2015-09-28 27128, 2015

      • juhae has quit
      • 2015-09-28 27111, 2015

      • samphippen joined the channel
      • 2015-09-28 27127, 2015

      • ruaok
        no, only your public key to authorized_keys
      • 2015-09-28 27134, 2015

      • ruaok
        we dont have access to your private key.
      • 2015-09-28 27102, 2015

      • ruaok
        how about cartman now?
      • 2015-09-28 27158, 2015

      • zas
        still ask pw
      • 2015-09-28 27108, 2015

      • ruaok
        wiley?
      • 2015-09-28 27127, 2015

      • zas
        same
      • 2015-09-28 27137, 2015

      • ruaok
        grrr.
      • 2015-09-28 27145, 2015

      • ruaok
        zas: on cartman your passwd is "foo"
      • 2015-09-28 27149, 2015

      • ruaok
        log in and change it.
      • 2015-09-28 27157, 2015

      • ruaok
        then figure out why your SSH isn't working. :p
      • 2015-09-28 27159, 2015

      • ruaok
        same thing on wiley.
      • 2015-09-28 27154, 2015

      • ruaok waits for zas
      • 2015-09-28 27110, 2015

      • regagain joined the channel
      • 2015-09-28 27130, 2015

      • zas
        i changed passwords, but i didnt figure yet about ssh keys, let's move on, i'll look into that later
      • 2015-09-28 27145, 2015

      • ruaok
        ok
      • 2015-09-28 27146, 2015

      • ruaok
        you
      • 2015-09-28 27155, 2015

      • ruaok
        re in both on wiley and cartman?
      • 2015-09-28 27111, 2015

      • zas
        i need pass to sudo on cartman
      • 2015-09-28 27151, 2015

      • zas
        same for wiley
      • 2015-09-28 27126, 2015

      • ruaok
        try again cartman
      • 2015-09-28 27121, 2015

      • zas
        ok
      • 2015-09-28 27133, 2015

      • ruaok
        working?
      • 2015-09-28 27103, 2015

      • zas
        yes
      • 2015-09-28 27106, 2015

      • zas
        on cartman
      • 2015-09-28 27115, 2015

      • ruaok
        ok, try asterix
      • 2015-09-28 27143, 2015

      • zas
        but wiley still asks a pw to sudo
      • 2015-09-28 27149, 2015

      • ruaok
        working on that now that cartman is confirmed
      • 2015-09-28 27155, 2015

      • zas
        asterix asks pw for ssh (same as others).
      • 2015-09-28 27116, 2015

      • zas
        what are the main roles of wiley and asterix ?
      • 2015-09-28 27139, 2015

      • ruaok
        try wiley
      • 2015-09-28 27109, 2015

      • ruaok
        wiley was intended to be a replacement for scooby, but now is as decript as scooby.
      • 2015-09-28 27115, 2015

      • ruaok
        it runs mail and jira.
      • 2015-09-28 27124, 2015

      • ruaok
        and git related things that may not be in use anymore
      • 2015-09-28 27134, 2015

      • zas
        wiley asks pw for sudo
      • 2015-09-28 27105, 2015

      • ruaok
        thats fine. does it succeed?
      • 2015-09-28 27102, 2015

      • zas
        yes
      • 2015-09-28 27111, 2015

      • ruaok
        ok, done then. :)
      • 2015-09-28 27123, 2015

      • ruaok
        asterix is one of three application servers for mb.
      • 2015-09-28 27133, 2015

      • ruaok
        four now.
      • 2015-09-28 27141, 2015

      • ruaok
        lolo, astro and lobe are the others.
      • 2015-09-28 27102, 2015

      • ruaok
        why in the hell does asterix ask for a passwd?
      • 2015-09-28 27104, 2015

      • zas
        i figured out about ssh keys, i need to enable ForwardAgent
      • 2015-09-28 27115, 2015

      • ruaok
        ah
      • 2015-09-28 27120, 2015

      • zas
        lolo.mb asks for ssh pw, (but not wiley anymore),
      • 2015-09-28 27136, 2015

      • ruaok
        now you're getting ahead of me.
      • 2015-09-28 27137, 2015

      • ruaok
        :)
      • 2015-09-28 27145, 2015

      • zas
        :)
      • 2015-09-28 27146, 2015

      • ruaok
        asterix sudo ok?
      • 2015-09-28 27105, 2015

      • zas
        yes
      • 2015-09-28 27126, 2015

      • ruaok will proceed down the list
      • 2015-09-28 27129, 2015

      • ruaok
        hobbes
      • 2015-09-28 27152, 2015

      • ruaok
        used for jenkins and not much else. it used to be test.mb.org and we needed a separate machine for it
      • 2015-09-28 27106, 2015

      • ruaok
        but I didn't want to dedicate a whole server for it, so that is a mac mini.