Monday, 2019-01-07

ara-slackzach.swanson: this just popped up on reddit https://longboat.io/01:03
ara-slackzach.swanson: Discussion on reddit @ https://www.reddit.com/r/ansible/comments/ad9jiw/logging_all_your_ansible_playbook_runs/01:32
ara-slackdmsimard: @zach.swanson interesting, thanks for sharing :)04:32
ara-slackdmsimard: I replied to the comment about ara.04:32
tristanCdmsimard: ((Ara Record Ansible) Report Ansible) :)04:48
ara-slackjeansebastien.guyot: @jeansebastien.guyot has joined the channel08:25
ara-slackjeansebastien.guyot: Hi !08:34
ara-slackI have a problem when i upgrade ARA from 0.14.6 to 0.15.0 or upper.08:34
ara-slackI have some SQL error : "Could not locate column in row 'stats.id' or 'plays.id' or 'tasks.id', etc.08:34
ara-slackI am on Postgres 9.2.21, and i not run SQL migration before upgrade ARA.08:34
ara-slackjeansebastien.guyot: Can you help me to understand what is the problem please ?08:34
ara-slackjeansebastien.guyot: I don't want erase database because i take a statustic with this databse ...08:37
*** gvincent has joined #ara08:41
*** ssbarnea|bkp2 has joined #ara09:38
*** ssbarnea has quit IRC09:39
*** herald85 has joined #ara10:05
*** sshnaidm|off is now known as sshnaidm10:30
*** jungleslow has joined #ara10:41
ara-slacksorin.sbarnea: @sorin.sbarnea has joined the channel12:04
ara-slackpaulieboo: @paulieboo has joined the channel13:55
ara-slackpaulieboo: (I'm using ara 0.16.1 and ansible 2.7.5.)14:10
*** irclogbot_0 has quit IRC14:14
ara-slackdmsimard: @paulieboo do you have the ability to specify the location of those files at runtime ?14:23
ara-slackdmsimard: @paulieboo for example, instead of attempting to hard code the location in the ansible.cfg file, have something like: export ARA_DIR="$(pwd)/.ara"14:24
ara-slackpaulieboo: Sure, I can do that.14:25
ara-slackdmsimard: I don't think I've seen users putting the database in version control before14:26
ara-slackpaulieboo: It's an odd one I'll admit, but my employer is being audited for ISO27001 compliance shortly and the remit is "log all the things"...!14:29
ara-slackdmsimard: @paulieboo how does that work in practice, though ? If I clone the repo, run ara, commit it and push it back but someone else also ran ara in the meantime -- the database is going to conflict ? And there's no fixing that merge conflict without losing one of the two runs I think14:37
*** irclogbot_0 has joined #ara14:38
ara-slackpaulieboo: @dmsimard That's a good point, but at the moment I'm the only dev ops guy and the only one running the playbooks, so for the time being, it won't matter.14:39
ara-slackpaulieboo: You're right though, this would be a horrible situation with more than one person running ara. But for now (and for our impending ISO audit) it ticks all the boxes.14:40
ara-slackdmsimard: Does that sort of audit expect connections to be controlled from a central location (like a bastion host?)14:41
openstackgerritMerged openstack/ara-clients master: Readded support for keep-alive (better performance).  https://review.openstack.org/61711214:45
ara-slackpaulieboo: @dmsimard No, I don't think so. It's not been mentioned anyway.14:50
dmsimardOkay -- I ask because what some users do is set up ARA on their bastion host where Ansible runs from14:51
dmsimardGood luck and let us know if you have questions :)14:51
ara-slackpaulieboo: @dmsimard Thanks for your help :+1:14:58
ara-slackdmsimard: @jeansebastien.guyot Not going to lie, the easiest thing would be to start on a new database for sure. Is your database backed up ? If so, what happens if you run "ara-manage db show" ?14:58
dmsimardapollo13: fyi I'm going to try and clean up the backlog and roadmap as well as put up a general status update once that's done15:02
apollo13sounds good15:02
*** irclogbot_0 has quit IRC15:06
*** irclogbot_0 has joined #ara15:13
*** openstackgerrit has quit IRC15:22
dmsimardara 0.16.2 has been tagged, it's a small bugfix release -- notes here: https://github.com/openstack/ara/releases/tag/0.16.215:25
dmsimardssbarnea|bkp2: ^15:25
dmsimardit will eventually make it's way to pypi15:25
ssbarnea|bkp2dmsimard: thanks! I am wrong to assume that those using ansible in offline mode (sqlite + generate html) should not be affected by 1.0 breaking changes?15:43
dmsimardssbarnea|bkp2: what's 100% not supported is sql migrations from 0.x to 1.x15:44
dmsimardssbarnea|bkp2: it's an entirely new database schema in an entirely new backend (from flask to django)15:45
ssbarnea|bkp2this does not worry me.15:45
dmsimardssbarnea|bkp2: html generation is still a question mark -- mostly because of the swift use case (instead of the current log server approach with the middleware)15:46
dmsimardThe question mark is that the backend needs access to the database -- there's no way to use a sqlite database over http.15:47
dmsimardThe current middleware approach relies on the URL matching a filesystem location on disk and so the middleware is able to load "arbitrary" databases15:48
dmsimardSince the URL and the filesystem location must match, it's not too awful from a security standpoint -- there's also some basic checks in place15:48
dmsimardIf the database is remote, however, we need to start thinking outside the box a bit.15:49
*** herald85 has quit IRC16:34
ara-slackdmsimard: @paulieboo thanks for the nice words :smile: where did you hear about ara btw ?17:25
ara-slackdmsimard: --check and --diff indeed require special treatment17:26
ara-slackpaulieboo: To my shame, on that Reddis thread someone posted, above, about Longboat!17:26
ara-slackpaulieboo: To my shame, on that ~Reddis~ Reddit thread someone posted, above, about Longboat! (Sorry, just been hacking keys out of redis)17:27
ara-slackdmsimard: We have a bug for adding in proper support for --check, I'm not sure if we'll be able to land it in time for ara 1.0 but it's something we want to do for sure17:28
ara-slackdmsimard: https://storyboard.openstack.org/#!/story/200092917:28
ara-slackdmsimard: --diff is a little bit trickier, but we want to support it too17:28
ara-slackpaulieboo: That's great to hear. So happy to have stumbled upon a great tool with approachable developers! :slightly_smiling_face:17:31
*** openstackgerrit has joined #ara17:45
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: Fix TypeError: API changed playbook.file to playbook.path  https://review.openstack.org/62902017:45
dmsimardgvincent: ^ an easy one17:45
dmsimardI updated https://api.demo.recordsansible.org/api/v1/ to HEAD and noticed the issue17:46
dmsimardAlso I'm not sure why Zuul isn't picking up the new job I'm setting up in https://review.openstack.org/#/c/625666/ anymore... will need to investigate17:46
dmsimardIt was working in patchset 7 but then stopped working17:46
dmsimardapollo13: woo https://api.demo.recordsansible.org/api/v1/info17:47
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP: Run a CI job that builds and publishes the web dashboard  https://review.openstack.org/62566618:18
*** mgariepy has quit IRC18:35
*** mgariepy has joined #ara18:53
openstackgerritMerged openstack/ara-web master: Fix TypeError: API changed playbook.file to playbook.path  https://review.openstack.org/62902019:16
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP: Run a CI job that builds and publishes the web dashboard  https://review.openstack.org/62566619:17
dmsimardI found why the ara-web integration job wasn't working \o/19:20
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP: Run a CI job that builds and publishes the web dashboard  https://review.openstack.org/62566619:28
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP Move playbook details page in a dedicated page  https://review.openstack.org/62845119:34
dmsimardgvincent: ^ rebased your change to contain the playbook.path fix19:34
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP: Run a CI job that builds and publishes the web dashboard  https://review.openstack.org/62566619:35
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP: Run a CI job that builds and publishes the web dashboard  https://review.openstack.org/62566619:49
apollo13dmsimard: is that all auto deployed? :)20:28
dmsimardapollo13: the demos ? not yet20:33
dmsimardI want them to be, though20:33
apollo13ok, we should also deploy the web interface there I guess?20:33
apollo13oh https://web.demo.recordsansible.org/playbooks ?20:33
dmsimardapollo13: yeah20:34
dmsimardI fixed that20:34
apollo13ok, will retry later :) wanna see the webiface20:34
dmsimardthere's not much to see yet20:35
dmsimardbut it's coming together20:35
dmsimardapollo13: pulled the fix, https://web.demo.recordsansible.org works now20:36
dmsimardThe plan is to first retrieve the data and then to have something that looks similar to the current 0.x UI as a first release20:37
apollo13indeed it does20:37
dmsimardOnce 1.0 releases, we'll be able to iterate on making the UI prettier and adding cool features like searching etc :p20:38
openstackgerritDavid Moreau Simard proposed openstack/ara-web master: WIP: Run a CI job that builds and publishes the web dashboard  https://review.openstack.org/62566623:46
-openstackstatus- NOTICE: The Etherpad service at https://etherpad.openstack.org/ has been offline since 23:22 UTC due to a hypervisor issue in our service provider, but should hopefully return to service shortly.23:47

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