Monday, 2018-06-11

*** paulfantom has quit IRC00:38
openstackgerritTristan Cacqueray proposed openstack/ara master: faq: update supported ansible version numbers  https://review.openstack.org/57412703:47
*** gvincent has joined #ara07:05
*** gvincent has joined #ara07:05
*** rvgate has joined #ara08:08
*** gnupyx has joined #ara09:03
gnupyxHi, if I use ara with PostgreSQL, if my postgresql is not reachable, what will happen?09:03
*** rvgate has quit IRC11:37
*** rvgate has joined #ara11:37
dmsimardgnupyx: the data won't be recorded and it's likely you'll get timeouts during your playbook execution (it'll hang up)11:54
*** gnupyx has quit IRC12:03
*** dougbtv has quit IRC12:18
*** dougbtv has joined #ara12:18
*** odyssey4me has quit IRC12:39
*** odyssey4me has joined #ara12:39
*** tbielawa has joined #ara12:47
*** Bakey has joined #ara12:50
*** myoung|off is now known as myoung13:19
*** tbielawa is now known as tbielawa|brb13:38
*** tbielawa|brb has quit IRC13:40
*** tbielawa has joined #ara13:40
*** pmdharris has joined #ara13:49
*** resmo_ has joined #ara14:24
pmdharrisdmsimard: Sorry I disappeared on Friday, I was fighting two VPNs and a recalcitrant VM - I've continued debugging and it looks like using different versions of PyMySQL results in different errors, so I suspect version mismatches of some form or another may be at least one cause of my problems getting ARA to work with MySQL14:36
*** themurph has joined #ara14:38
pmdharrisdmsimard: Ok, interesting stuff - I've been getting errors like 'ResourceClosedError: This result object does not return rows. It has been closed automatically.' and 'Packet sequence number wrong - got 51 expected 1'14:57
pmdharrisdmsimard: They go away when I use ara 0.14.6 (but everything else is unchanged - python-pymysql, mariadb, etc.); I think there might be problems with 0.15.014:58
pmdharrisdmsimard: I'll continue with 0.14.6 for my work (I don't think we're picky), but if you want me to help with 0.15.0 I've got logging and whatnot set up and good to go14:59
*** tbielawa is now known as tbielawa|mtg14:59
dmsimardpmdharris: are those errors from the callback (i.e, when running ansible) or when browsing the UI ?14:59
dmsimardalso, what OS and version of python is that ?15:00
pmdharrisdmsimard: Just browsing the UI - no problems with the callback as near as I can tell (except some 'invalid UTF-8 string' warnings in some configurations)15:00
dmsimardpmdharris: how is the web interface started ? with runserver or mod_wsgi ? something else ?15:01
pmdharrisCurrently with 'ara-manage runserver'15:04
pmdharrisdmsimard: Debian/stable, Python 2.7 for 'ara-manage runserver', Mac OS X, Python 2 and 3 for the callback plugin15:05
dmsimardpmdharris: ok, I'm currently working on a "framework" to improve the integration tests with different topologies/deployment configurations15:05
*** bcoca has joined #ara15:05
*** bcoca has joined #ara15:05
dmsimardfor example, the intent is to test with runserver, mod_wsgi, nginx, mysql, postegresql, sqlite, etc.. on different distros and versions of python15:06
dmsimardso I hope we'd be able to reproduce that in the tests15:06
dmsimardpmdharris: just to make sure, when you say mysql is it really mysql or is it mariadb ?15:06
pmdharrisdmsimard: MariaDB15:07
dmsimard10 or 5?15:07
pmdharrisdmsimard: Though I was able to reproduce the problems against an AWS-hosted MySQL instance15:07
pmdharrisdmsimard: MariaDB 10.1, the AWS MySQL instance would have been 5.515:07
dmsimardok, I'll have a look at it when I have a chance -- there's a wsgi regression that slipped in 0.15.0 and I'm hoping to be able to cut a release to address it sometime soon, hopefully I can look at your issue so that it's also fixed in the next release15:08
pmdharrisdmsimard: ok, fair enough - we're happy using 0.14.6 probably indefinitely; if there's anything you want me to do to help let me know15:09
pmdharrisdmsimard: (especially in the next couple of days, this is the only thing I'm supposed to be working on at this point)15:09
*** Naphta has joined #ara15:11
NaphtaHey, is there any way I can check which version was compatible with an older version of ansible? Or are the newer ones "working" but untested?15:11
dmsimardNaphta: the latest release/master is always tested against the latest supported dot releases, i.e https://docs.ansible.com/ansible/latest/reference_appendices/release_and_maintenance.html15:13
NaphtaAdditionally, I've got it setup and working but having trouble pointing it at a database server using credentials. I'm using something like `export ARA_DATABASE="mysql+pymysql://ara:<pass>@<ip>/ara"; ara-manage runserver`15:13
dmsimardNaphta: otherwise it's more of a floor than a ceiling (in regards to supported versions)15:13
NaphtaOr rather, I had it working with sqlite.15:13
dmsimardNaphta: you can look at the different dot releases here: https://github.com/openstack/ara/releases and browse to the requirements.txt file to see what was the minimum supported version15:14
dmsimardNaphta: that should work but pmdharris was actually just saying that he was having issues with the latest 0.15.0 release, you can try 0.14.6 while I try to iron that out15:16
NaphtaAh cool, cheers.15:17
NaphtaI hope to get upgraded to Ansible 2.5 soon but for now I'm back in the dark ages of 2.2 :/15:17
openstackgerritMerged openstack/ara master: faq: update supported ansible version numbers  https://review.openstack.org/57412715:18
dmsimardpmdharris: btw, your use case (i.e, everyone running ansible from their laptops) is a story I'd like to improve in the upcoming 1.0 because connecting directly to databases is meh. There'll be an API in 1.0.15:19
dmsimardNaphta: definitely want to try to at least stay on a supported release, even if just for security fixes. I know it's not easy :)15:19
NaphtaOur issue is generally that Ansible has a bad habit of breaking changes between releases15:20
dmsimardbcoca: did you ever get around to trying out a poc to send arbitrary data to callbacks without being in the playbook execution context ?15:20
dmsimardNaphta: I hear you15:20
bcocadmsimard: in my head, yes, need to write the code, probably something i'll put in hacking/ for 'testing callbacks' but should be easy enough for 'replay'15:21
dmsimardbcoca: cool, let me know when you have something, happy to try it out15:21
*** rvgate has quit IRC15:42
pmdharrisdmsimard: Yeah the thought of making it work over HTTP(S) crossed my mind but it's more work than I'm willing to take on :)15:54
*** tbielawa|mtg is now known as tbielawa15:55
NaphtaWhen clicking the files to view their data; does that just run locally on the ara server or is that data stored and sent over into the database?15:56
Naphtatask details etc too.15:57
pmdharrisdmsimard: So with 0.14.6, I created the MySQL DB with charset latin1/collate latin1_swedish_ci - otherwise the ara schema can't be created because there's apparently an arbitrary byte-limit to the length of some index15:57
pmdharrisdmsimard: Now I'm getting seemingly harmless warnings to the effect of: /usr/local/lib/python2.7/site-packages/pymysql/cursors.py:170: Warning: (1300, u"Invalid utf8 character string: '9C7590'")15:58
pmdharrisdmsimard: Any thoughts off the top of your head?15:58
*** tbielawa is now known as tbielawa|brb16:29
*** resmo_ has quit IRC17:15
*** tbielawa|brb is now known as tbielawa17:19
*** tbielawa is now known as tbielawa|lunch17:27
*** spiette has quit IRC17:44
*** spiette has joined #ara17:46
*** tbielawa|lunch is now known as tbielawa18:27
*** myoung is now known as myoung|lunch18:52
*** tbielawa has quit IRC19:10
*** tbielawa has joined #ara19:10
-openstackstatus- NOTICE: Zuul was restarted for a software upgrade; changes uploaded or approved between 19:30 and 19:50 will need to be rechecked19:55
*** myoung|lunch is now known as myoung19:59
*** pmdharris has quit IRC20:30
*** tbielawa has quit IRC20:44
*** themurph has quit IRC21:30
*** paulfantom has joined #ara21:45
*** myoung is now known as myoung|off21:50
*** Bakey has quit IRC23:49

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