/srv/irclogs.ubuntu.com/2018/05/12/#juju.txt

bobeo_kwmonroe: honestly, im not sure. I went through a rebuild thanks to some help with bdx, so im hoping its resolved. Ill update very shortly, im checking out the new build now12:26
bobeo_kwmonroe: ok so the update is Ive got rsyslog forwarding from....annnnd im an idiot12:48
bobeo_ok, so just to clarify, I send the logs to graylog, not to elasticsearch correct?13:01
bobeo_graylog is the logging server portion of graylog right? im not losing my mind here?13:01
bdxany sad souls hanging around on a weekend want haproxy charm options parsing fixed see here https://code.launchpad.net/~jamesbeedy/charm-haproxy/options_newline/+merge/34546316:24
TheAbsentOnedo you ever stop working bdx? x)16:55
bdxTheAbsentOne: ahah, I have to catch up on bugs I hit during the week and didn't have time to tend to16:57
bdxeither filing them or fixing or both16:57
TheAbsentOnebdx much respect sir!16:57
TheAbsentOnebdx: since you are here I can ask it, do you have experience with the pgbouncer charm?17:01
bdxahh .. I haven't used it for a few years, but yeah kindof17:02
bdxlooks like its actively maintained17:03
bdxand has docs and stuff17:03
TheAbsentOneI heard the pgbouncer charm would allow me to set multiple authentication hosts in the charm itself, but I don't really see how17:04
TheAbsentOnegonna have a look at the code17:04
TheAbsentOnebdx: correct me if I'm wrong but shouldn't an interface allow this instead of a charm?17:05
bdxinterfaces are really just for helping communicate information from one application to another ....17:06
bdxtake it as you will17:06
bdxthats how I understand it17:06
TheAbsentOneyeah exactly bdx17:07
TheAbsentOneI fail to see how the bouncher charm would help me in adding an extre entry to the host auth file on the pgsql server17:09
bdxahh17:13
bdxTheAbsentOne: Possibly because pgbouncer would be the one communicating with postgresql17:13
bdxso you just communicate with pgbouncer at that point17:13
bdxthen postgresql only need a single entry in the pg_hba.conf for pgbouncer17:14
bdxI could be entirely wrong, but I seem to remember something to that degree17:14
bdxTheAbsentOne: https://gpdb.docs.pivotal.io/43180/admin_guide/access_db/topics/pgbouncer.html#pgb_config17:15
bdx^ something similar to that may be going on under the covers, I'm really not familiar enough to say17:16
TheAbsentOnebut can I request that in my charm using pgbouncer bdx?17:17
bdxTheAbsentOne: I'm unsure what you are trying to do17:18
TheAbsentOneyeah my bad I'll try to illustrate it: Assume I have a model with the postgresql charm and the pgbouncer charm deployed. Now assume that I have charm A that is a website that will access a postgres database and charm A is connect to charm B. The one connecting to (either postgresql or pgbouncer) is charm B however. This means that charm B is automatically configured in the host auth files but charm A's host is not allowed to conn17:21
TheAbsentOneI want in charm B to write code that set's, "host A should be allowed to connect to the db as well"17:21
TheAbsentOnedoes that makes sense bdx?17:21
bdxyeah17:27
bdxTheAbsentOne: what you are trying to do essentially is bypass part of the postgresql auth system17:30
bdxdo you understand that?17:30
TheAbsentOnewell not really I want to pass a config string that the postgresql charm needs to handle; as a matter of fact there is an option for that in the postgresql but this means manual interaction which I want to evade17:31
bdxgot it17:32
bdxyeah, thats how I've always gotten around it17:32
TheAbsentOnethe postgresql charm does "something" (<-- add an entry in the host auth file) for the requesting charm. I want the postgresql charm to do the same thing but for a host that I pass instead17:32
bdxsetting extra_pg_auth17:32
bdxtotally17:32
TheAbsentOneyep that works ok I guess17:32
TheAbsentOnebut it would be awesome if there was a function that would allow it in the pgsql interface, or an optional parameter in the set_database method that requests a db and makes everything happen17:33
bdx"I want the postgresql charm to do the same thing but for a host that I pass instead" - got it, so just a custom entry to the pg_hba.conf17:33
bdxtotally17:33
bdxI would make a feature request against the pgsql interface for that17:33
TheAbsentOneI hope I can convince stub for something like that x) I can see it being usefull for others too17:33
bdxyeah, if you make a feature request/bug for it post it here and I'l give it some heat for you17:34
bdxI can see that being super handy17:34
TheAbsentOneI talked about it though with stub it was he who said take a look at pgbouncer17:34
TheAbsentOneThe only problem is that I don't have a launchpad account and the pgsql interface is not hosted on github x)17:35
bdxTheAbsentOne: sounds like you know what you need to do then :)17:35
TheAbsentOneor is there another way to request it formally? bdx as I haven't used launchpad before17:35
bdxyea, thats totally annoying, but people have the right to use what version control they please17:36
TheAbsentOnetotally bdx I'm creating an ubuntu one account as we speak17:37
bdxTheAbsentOne: that will be useful for many things, charmstore, JAAS, etc etc etc17:38
bdxbut will also allow you to interact with the greater community too17:38
TheAbsentOneYeah thought so too but I hadn't the need for it so far. Could you point me where I can ask/feature request/issue on launchpad, it seems I'm blind17:40
TheAbsentOneahn wow was only look at the git....17:41
bdxthere should be a link on the charm webpage17:42
bdxto "submit a bug"17:42
bdxfollow that and submit your feature request there17:42
TheAbsentOneyeah found it, Ill just submit a bug idd, thanks for the help bdx17:42
bdxnp17:43
TheAbsentOneIt is done, back to writing x)17:58
bdxTheAbsentOne: post it here18:18
TheAbsentOnebdx: https://bugs.launchpad.net/interface-pgsql/+bug/177088518:24
mupBug #1770885: add support for multiple host auth when requesting db <pgsql Interface for charms.reactive:New> <https://launchpad.net/bugs/1770885>18:24
bdxTheAbsentOne: nice work18:26
TheAbsentOnehaha thanks, we'll see what happens and I hope it might help others too18:28
bdxkwmonroe: https://github.com/jamesbeedy/charm-graylog/blob/endpoints/reactive/graylog.py#L479,L522 - getting close18:44
bdxwe will make this thing scale out and drop the apache2 bs here soon18:45
TheAbsentOnenice code bdx I wish I had my eyes on things like that weeks ago!18:58
TheAbsentOneI feel like I'm only startint to understand it right now and I feel stupid for it xD18:59
bdxTheAbsentOne: its cool man, everyone has their own learning curve18:59
bdxTheAbsentOne: fyi, I've been eyeing these changes for months19:05
bdxstill don't have it perfect, but I'm real close19:05
bdxwhy I need a fe hours on the weekends to hack these types of things out19:06
TheAbsentOneyeah it's very time consuming for some reason while it seems so little/easy at first19:07
bdx^ programming19:08
TheAbsentOnebasicly xD but still, I underestimated reactive programming very hard19:10
bdxTheAbsentOne: its all relative :)19:12
bdxlast bug19:20
bdxhttps://bugs.launchpad.net/charm-haproxy/+bug/177089019:20
mupBug #1770890: haproxy should wait to write out a front end and backend until they are configured by relating service <charm-haproxy:New> <https://launchpad.net/bugs/1770890>19:20
bdxim off to get some sunshine now19:21
bdxlates19:21
TheAbsentOnebdx enjoy!19:23

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!