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 now | 12:26 |
---|---|---|
bobeo_ | kwmonroe: ok so the update is Ive got rsyslog forwarding from....annnnd im an idiot | 12: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 |
bdx | any 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/345463 | 16:24 |
TheAbsentOne | do you ever stop working bdx? x) | 16:55 |
bdx | TheAbsentOne: ahah, I have to catch up on bugs I hit during the week and didn't have time to tend to | 16:57 |
bdx | either filing them or fixing or both | 16:57 |
TheAbsentOne | bdx much respect sir! | 16:57 |
TheAbsentOne | bdx: since you are here I can ask it, do you have experience with the pgbouncer charm? | 17:01 |
bdx | ahh .. I haven't used it for a few years, but yeah kindof | 17:02 |
bdx | looks like its actively maintained | 17:03 |
bdx | and has docs and stuff | 17:03 |
TheAbsentOne | I heard the pgbouncer charm would allow me to set multiple authentication hosts in the charm itself, but I don't really see how | 17:04 |
TheAbsentOne | gonna have a look at the code | 17:04 |
TheAbsentOne | bdx: correct me if I'm wrong but shouldn't an interface allow this instead of a charm? | 17:05 |
bdx | interfaces are really just for helping communicate information from one application to another .... | 17:06 |
bdx | take it as you will | 17:06 |
bdx | thats how I understand it | 17:06 |
TheAbsentOne | yeah exactly bdx | 17:07 |
TheAbsentOne | I fail to see how the bouncher charm would help me in adding an extre entry to the host auth file on the pgsql server | 17:09 |
bdx | ahh | 17:13 |
bdx | TheAbsentOne: Possibly because pgbouncer would be the one communicating with postgresql | 17:13 |
bdx | so you just communicate with pgbouncer at that point | 17:13 |
bdx | then postgresql only need a single entry in the pg_hba.conf for pgbouncer | 17:14 |
bdx | I could be entirely wrong, but I seem to remember something to that degree | 17:14 |
bdx | TheAbsentOne: https://gpdb.docs.pivotal.io/43180/admin_guide/access_db/topics/pgbouncer.html#pgb_config | 17:15 |
bdx | ^ something similar to that may be going on under the covers, I'm really not familiar enough to say | 17:16 |
TheAbsentOne | but can I request that in my charm using pgbouncer bdx? | 17:17 |
bdx | TheAbsentOne: I'm unsure what you are trying to do | 17:18 |
TheAbsentOne | yeah 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 conn | 17:21 |
TheAbsentOne | I want in charm B to write code that set's, "host A should be allowed to connect to the db as well" | 17:21 |
TheAbsentOne | does that makes sense bdx? | 17:21 |
bdx | yeah | 17:27 |
bdx | TheAbsentOne: what you are trying to do essentially is bypass part of the postgresql auth system | 17:30 |
bdx | do you understand that? | 17:30 |
TheAbsentOne | well 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 evade | 17:31 |
bdx | got it | 17:32 |
bdx | yeah, thats how I've always gotten around it | 17:32 |
TheAbsentOne | the 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 instead | 17:32 |
bdx | setting extra_pg_auth | 17:32 |
bdx | totally | 17:32 |
TheAbsentOne | yep that works ok I guess | 17:32 |
TheAbsentOne | but 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 happen | 17: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.conf | 17:33 |
bdx | totally | 17:33 |
bdx | I would make a feature request against the pgsql interface for that | 17:33 |
TheAbsentOne | I hope I can convince stub for something like that x) I can see it being usefull for others too | 17:33 |
bdx | yeah, if you make a feature request/bug for it post it here and I'l give it some heat for you | 17:34 |
bdx | I can see that being super handy | 17:34 |
TheAbsentOne | I talked about it though with stub it was he who said take a look at pgbouncer | 17:34 |
TheAbsentOne | The only problem is that I don't have a launchpad account and the pgsql interface is not hosted on github x) | 17:35 |
bdx | TheAbsentOne: sounds like you know what you need to do then :) | 17:35 |
TheAbsentOne | or is there another way to request it formally? bdx as I haven't used launchpad before | 17:35 |
bdx | yea, thats totally annoying, but people have the right to use what version control they please | 17:36 |
TheAbsentOne | totally bdx I'm creating an ubuntu one account as we speak | 17:37 |
bdx | TheAbsentOne: that will be useful for many things, charmstore, JAAS, etc etc etc | 17:38 |
bdx | but will also allow you to interact with the greater community too | 17:38 |
TheAbsentOne | Yeah 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 blind | 17:40 |
TheAbsentOne | ahn wow was only look at the git.... | 17:41 |
bdx | there should be a link on the charm webpage | 17:42 |
bdx | to "submit a bug" | 17:42 |
bdx | follow that and submit your feature request there | 17:42 |
TheAbsentOne | yeah found it, Ill just submit a bug idd, thanks for the help bdx | 17:42 |
bdx | np | 17:43 |
TheAbsentOne | It is done, back to writing x) | 17:58 |
bdx | TheAbsentOne: post it here | 18:18 |
TheAbsentOne | bdx: https://bugs.launchpad.net/interface-pgsql/+bug/1770885 | 18:24 |
mup | Bug #1770885: add support for multiple host auth when requesting db <pgsql Interface for charms.reactive:New> <https://launchpad.net/bugs/1770885> | 18:24 |
bdx | TheAbsentOne: nice work | 18:26 |
TheAbsentOne | haha thanks, we'll see what happens and I hope it might help others too | 18:28 |
bdx | kwmonroe: https://github.com/jamesbeedy/charm-graylog/blob/endpoints/reactive/graylog.py#L479,L522 - getting close | 18:44 |
bdx | we will make this thing scale out and drop the apache2 bs here soon | 18:45 |
TheAbsentOne | nice code bdx I wish I had my eyes on things like that weeks ago! | 18:58 |
TheAbsentOne | I feel like I'm only startint to understand it right now and I feel stupid for it xD | 18:59 |
bdx | TheAbsentOne: its cool man, everyone has their own learning curve | 18:59 |
bdx | TheAbsentOne: fyi, I've been eyeing these changes for months | 19:05 |
bdx | still don't have it perfect, but I'm real close | 19:05 |
bdx | why I need a fe hours on the weekends to hack these types of things out | 19:06 |
TheAbsentOne | yeah it's very time consuming for some reason while it seems so little/easy at first | 19:07 |
bdx | ^ programming | 19:08 |
TheAbsentOne | basicly xD but still, I underestimated reactive programming very hard | 19:10 |
bdx | TheAbsentOne: its all relative :) | 19:12 |
bdx | last bug | 19:20 |
bdx | https://bugs.launchpad.net/charm-haproxy/+bug/1770890 | 19:20 |
mup | Bug #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 |
bdx | im off to get some sunshine now | 19:21 |
bdx | lates | 19:21 |
TheAbsentOne | bdx enjoy! | 19:23 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!