#metabrainz

/

      • bitmap
        zas: do you think we'll have >1 read-only postgres slave to start with?

        • 2016-08-25 23828, 2016

      • bitmap
        I'm running into some issues with docker + pgbouncer + haproxy

        • 2016-08-25 23815, 2016

      • zas
        1 ro slave is enough for now

        • 2016-08-25 23831, 2016

      • zas
        which kind of issue ?

        • 2016-08-25 23832, 2016

      • bitmap
        okay

        • 2016-08-25 23805, 2016

      • bitmap
        well, not an expert on this, but from what I can tell haproxy->pgbouncer is better than pgbouncer->haproxy

        • 2016-08-25 23817, 2016

      • bitmap
        that's what https://wiki.postgresql.org/images/1/1e/QuanHa_PG… does

        • 2016-08-25 23813, 2016

      • bitmap
        this has a comment saying the same... http://dba.stackexchange.com/questions/56559/post…

        • 2016-08-25 23827, 2016

      • bitmap
        so each pgbouncer container has to be paired with a specific postgres-slave container

        • 2016-08-25 23857, 2016

      • bitmap
        I'm not sure how to pull that off without keeping them in the same container

        • 2016-08-25 23818, 2016

      • bitmap
        I guess it's possible to create different service names for each slave...so hardcoding them in the compose file

        • 2016-08-25 23814, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23843, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23828, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23829, 2016

      • Mineo has quit

        • 2016-08-25 23827, 2016

      • pingupingu joined the channel

        • 2016-08-25 23832, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23834, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23800, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23816, 2016

      • bitmap
        ok, I'm pretty sure the right solution is to just run pgbouncer and postgres in the same container

        • 2016-08-25 23847, 2016

      • bitmap
        since I can't find any way to scale pairs of containers that have a 1:1 relationship

        • 2016-08-25 23840, 2016

      • bitmap
        I thought it might be smart enough to do that with links, but no http://stackoverflow.com/questions/29725955/how-d…

        • 2016-08-25 23835, 2016

      • uZer42 joined the channel

        • 2016-08-25 23806, 2016

      • Gore|home has quit

        • 2016-08-25 23818, 2016

      • Gore|home joined the channel

        • 2016-08-25 23831, 2016

      • JesseW joined the channel

        • 2016-08-25 23831, 2016

      • Gentlecat
        bitmap: where do we store private keys for configuration?

        • 2016-08-25 23817, 2016

      • bitmap
        I made a docker-server-configs repo but it's empty atm

        • 2016-08-25 23829, 2016

      • Gentlecat
        setting them as env variables in compose file is probably not very smart

        • 2016-08-25 23842, 2016

      • bitmap
        not 100% sure how it's going to work yet either

        • 2016-08-25 23850, 2016

      • Gentlecat
        right

        • 2016-08-25 23858, 2016

      • bitmap
        probably json files that get posted into consul

        • 2016-08-25 23812, 2016

      • Gentlecat
        does it do that?

        • 2016-08-25 23815, 2016

      • bitmap
        https://www.consul.io/docs/agent/http/kv.html

        • 2016-08-25 23829, 2016

      • Gentlecat
        aha

        • 2016-08-25 23851, 2016

      • bitmap
        they have this 'Vault' thing you're supposed to store private stuff in, but

        • 2016-08-25 23810, 2016

      • bitmap
        that has some delay weirdness if you're rendering templates with secrets in them, I guess

        • 2016-08-25 23845, 2016

      • bitmap
        part where it says "Please note that Vault does not support blocking queries" https://github.com/hashicorp/consul-template

        • 2016-08-25 23858, 2016

      • yeeeargh joined the channel

        • 2016-08-25 23849, 2016

      • porl2 joined the channel

        • 2016-08-25 23850, 2016

      • porl has quit

        • 2016-08-25 23821, 2016

      • yeeeargh has quit

        • 2016-08-25 23838, 2016

      • JonnyJD joined the channel

        • 2016-08-25 23858, 2016

      • mrc0mmand has quit

        • 2016-08-25 23815, 2016

      • mrc0mmand joined the channel

        • 2016-08-25 23846, 2016

      • diana_olhovyk_ joined the channel

        • 2016-08-25 23807, 2016

      • Mineo joined the channel

        • 2016-08-25 23812, 2016

      • JesseW has quit

        • 2016-08-25 23820, 2016

      • Nyanko-sensei joined the channel

        • 2016-08-25 23826, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23801, 2016

      • Nyanko-sensei has quit

        • 2016-08-25 23828, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23801, 2016

      • fractalizator joined the channel

        • 2016-08-25 23807, 2016

      • Mineo has quit

        • 2016-08-25 23814, 2016

      • Rotab has quit

        • 2016-08-25 23809, 2016

      • Rotab joined the channel

        • 2016-08-25 23848, 2016

      • Rotab has quit

        • 2016-08-25 23804, 2016

      • Rotab joined the channel

        • 2016-08-25 23810, 2016

      • LordSputnik
        Leftmost: sent you the GSoC eval in case you didn't see

        • 2016-08-25 23844, 2016

      • LordSputnik
        I'd like to submit it tonight

        • 2016-08-25 23811, 2016

      • LordSputnik
        Leftmost: also, another reminder about http://doodle.com/poll/tsq8dye437qctkp9

        • 2016-08-25 23806, 2016

      • porl2 has quit

        • 2016-08-25 23828, 2016

      • porl joined the channel

        • 2016-08-25 23859, 2016

      • CatQuest
        Learn You A Haskell for Great Good!

        • 2016-08-25 23847, 2016

      • mihaitish joined the channel

        • 2016-08-25 23803, 2016

      • porl has quit

        • 2016-08-25 23845, 2016

      • kartikgupta0909 joined the channel

        • 2016-08-25 23808, 2016

      • kartikgupta0909
        alastairp: ping!

        • 2016-08-25 23821, 2016

      • Leo_Verto
        LordSputnik, looks like most of us have time on Saturday at 18:00 UTC! :P

        • 2016-08-25 23829, 2016

      • Nyanko-sensei joined the channel

        • 2016-08-25 23833, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23831, 2016

      • Nyanko-sensei has quit

        • 2016-08-25 23859, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23817, 2016

      • creature has quit

        • 2016-08-25 23801, 2016

      • pprkut has quit

        • 2016-08-25 23802, 2016

      • creature joined the channel

        • 2016-08-25 23802, 2016

      • creature has quit

        • 2016-08-25 23802, 2016

      • creature joined the channel

        • 2016-08-25 23830, 2016

      • pprkut joined the channel

        • 2016-08-25 23837, 2016

      • Gentlecat has quit

        • 2016-08-25 23822, 2016

      • Gentlecat joined the channel

        • 2016-08-25 23804, 2016

      • kartikgupta0909 has quit

        • 2016-08-25 23801, 2016

      • arcctgx joined the channel

        • 2016-08-25 23805, 2016

      • arcctgx
        hi, I have a question regarding musicbrainz

        • 2016-08-25 23834, 2016

      • arcctgx
        is there a way to assign existing cover art to a different release?

        • 2016-08-25 23851, 2016

      • arcctgx
        other than removing it from one release, and adding it to another one?

        • 2016-08-25 23828, 2016

      • arcctgx
        example: https://musicbrainz.org/release/f7e745c5-69b6-37b… this is the UK release of this single, and it has the artwork of both the UK and German release. I'd like to assign the last two images to the German release, which currently doesn't have any artwork.

        • 2016-08-25 23830, 2016

      • LordSputnik
        Leo_Verto: yeah, I still don't really want to do it at the weekend though

        • 2016-08-25 23838, 2016

      • kepstin
        arcctgx: there's currently no way other than downloading the original images and re-uploading them on the other release

        • 2016-08-25 23849, 2016

      • arcctgx
        kepstin: all right, so I'm going to do it like that

        • 2016-08-25 23844, 2016

      • arcctgx
        thanks :)

        • 2016-08-25 23835, 2016

      • kartikgupta0909 joined the channel

        • 2016-08-25 23842, 2016

      • lazka joined the channel

        • 2016-08-25 23826, 2016

      • Lotheric has quit

        • 2016-08-25 23814, 2016

      • Lotheric joined the channel

        • 2016-08-25 23849, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23816, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23856, 2016

      • D4RK-PH0ENiX has quit

        • 2016-08-25 23850, 2016

      • D4RK-PH0ENiX joined the channel

        • 2016-08-25 23832, 2016

      • zas
        bitmap: ping

        • 2016-08-25 23847, 2016

      • anthony25 has quit

        • 2016-08-25 23854, 2016

      • pingupingu has quit

        • 2016-08-25 23801, 2016

      • anthony25 joined the channel

        • 2016-08-25 23845, 2016

      • diana_olhovyk_ has quit

        • 2016-08-25 23850, 2016

      • zas
        Freso: i'm preparing the migration of Discourse from DWNI to GCloud, i just did a test of restoration, it seems ok, i need to fix few things though, mostly email related

        • 2016-08-25 23840, 2016

      • zas
        the process will be: set current Discourse RO, make a full backup, upload it to S3, download the backup on the VM, restore it, switch DNS, the whole process should be under 30 minutes (mostly because restoration is slow, almost 700Mb of data), dns ttl was already reduced to few mins

        • 2016-08-25 23806, 2016

      • zas
        the new installation is using dockerized nginx reverse proxy with letsencrypt companion, and official discourse docker image, using multi containers setup

        • 2016-08-25 23810, 2016

      • JesseW joined the channel

        • 2016-08-25 23859, 2016

      • CallerNo6
        Okay, so let's say that working on my "to do" list is actual work, and not work-avoidance-behavior.

        • 2016-08-25 23818, 2016

      • CallerNo6
        One of the things I really want to put together is a strong "how to get started" for prospective contributors. But even better than having an MeB-specific doc would be linkng to a good general-purpose one. Anybody have a favorite "how to get started in open source" link (off the top of your head)?

        • 2016-08-25 23819, 2016

      • CallerNo6 looks at https://guides.github.com/activities/contributing-to-open-source/ which is a little more high-altitude than I had in mind.

        • 2016-08-25 23840, 2016

      • JesseW has quit

        • 2016-08-25 23856, 2016

      • Mineo joined the channel

        • 2016-08-25 23846, 2016

      • diana_olhovyk_ joined the channel

        • 2016-08-25 23846, 2016

      • bitmap
        zas: pong

        • 2016-08-25 23838, 2016

      • yeeeargh joined the channel

        • 2016-08-25 23802, 2016

      • samdave joined the channel

        • 2016-08-25 23809, 2016

      • samdave
        Hi, I'm trying to get the database mounted into postgresql. Or into any indexable DB app! Anyone able to assist?

        • 2016-08-25 23845, 2016

      • bitmap
        CallerNo6: I don't know of any good links, but I'd be interested in reading it

        • 2016-08-25 23801, 2016

      • bitmap has no idea what he's doing

        • 2016-08-25 23854, 2016

      • CallerNo6
        Then it's a good thing bitmap works for an agent of chaos :-)

        • 2016-08-25 23859, 2016

      • bitmap
        samdave: I can try to assist. what is your current progress?

        • 2016-08-25 23847, 2016

      • samdave
        I've tried a few things, but ultimatly, I have the download and the software installed. very advanced, I know.

        • 2016-08-25 23826, 2016

      • samdave
        I'm happy with writing queries, but the tar file just won't 'restore'.

        • 2016-08-25 23849, 2016

      • samdave
        for me to work with the data.

        • 2016-08-25 23855, 2016

      • Mineo
        did you follow https://github.com/metabrainz/musicbrainz-server/… or some other guide?

        • 2016-08-25 23817, 2016

      • samdave
        I have the VM running.

        • 2016-08-25 23830, 2016

      • samdave
        nothing in the command line seems to work.

        • 2016-08-25 23853, 2016

      • samdave
        ssh doesn't work either.

        • 2016-08-25 23828, 2016

      • bitmap
        oh, VM, I'm not really experienced with that

        • 2016-08-25 23831, 2016

      • samdave
        Can I clarify, that I should be able to query the VM box via the PG software?

        • 2016-08-25 23836, 2016

      • bitmap
        are you using the one from http://wiki.musicbrainz.org/MusicBrainz_Server/Se…

        • 2016-08-25 23839, 2016

      • dehy has quit

        • 2016-08-25 23847, 2016

      • samdave
        yes

        • 2016-08-25 23812, 2016

      • samdave
        Or is it possible to get the DB onto the PG server software?

        • 2016-08-25 23815, 2016

      • bitmap
        and not the new one from https://github.com/metabrainz/musicbrainz-vm

        • 2016-08-25 23842, 2016

      • bitmap
        the VM should already have a database imported, though it might be outdated

        • 2016-08-25 23842, 2016

      • samdave
        yes, I'm sure the VM does. But I can't get to it!

        • 2016-08-25 23800, 2016

      • bitmap
        how are you trying to ssh into the machine?

        • 2016-08-25 23812, 2016

      • samdave
        so, if the VM has a DB on it, how do I connect to it? I need to be able to query the DB, so the web portal is out. SSH isn't working.

        • 2016-08-25 23834, 2016

      • bitmap
        you have to be able to ssh into it

        • 2016-08-25 23842, 2016

      • samdave
        or, I restore the DB, which is downloadable, to a local install of postgresql

        • 2016-08-25 23814, 2016

      • samdave
        is it enabled out the box?

        • 2016-08-25 23829, 2016

      • samdave
        I imagine so, as the guide doesn't tell you it needs doing!

        • 2016-08-25 23839, 2016

      • bitmap
        yes, there are instructions at http://wiki.musicbrainz.org/MusicBrainz_Server/Se…

        • 2016-08-25 23842, 2016

      • bitmap
        "Using the VM"

        • 2016-08-25 23811, 2016

      • bitmap
        you can also try using the new one at https://github.com/metabrainz/musicbrainz-vm

        • 2016-08-25 23826, 2016

      • samdave
        I get the "using the VM" bit, but it doesnt work.

        • 2016-08-25 23830, 2016

      • samdave
        I am downloading the beta.

        • 2016-08-25 23833, 2016

      • samdave
        to try as well.