| openstackgerrit | David Moreau Simard proposed openstack/ara master: Move the tooltip for the playbook status so it's centered properly https://review.openstack.org/461932 | 00:02 |
|---|---|---|
| *** harlowja has quit IRC | 00:04 | |
| *** iceyao has joined #ara | 00:11 | |
| openstackgerrit | Merged openstack/ara master: Add playbook parameters and metadata, handle task tags https://review.openstack.org/461907 | 00:14 |
| *** iceyao has quit IRC | 00:16 | |
| openstackgerrit | Merged openstack/ara master: Move the tooltip for the playbook status so it's centered properly https://review.openstack.org/461932 | 00:30 |
| *** iceyao has joined #ara | 00:39 | |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Only import ARA models in the SQL migrations https://review.openstack.org/461941 | 00:44 |
| *** cuongnv has joined #ara | 00:51 | |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Don't try to uncompress if there's nothing to uncompress https://review.openstack.org/461943 | 00:56 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Fix bad column type for ara_record's value https://review.openstack.org/461944 | 00:56 |
| *** iceyao_ has joined #ara | 00:58 | |
| *** iceyao has quit IRC | 00:58 | |
| openstackgerrit | Merged openstack/ara master: Only import ARA models in the SQL migrations https://review.openstack.org/461941 | 01:15 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Narrow a little bit the main container https://review.openstack.org/461947 | 01:21 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Don't try to uncompress if there's nothing to uncompress https://review.openstack.org/461943 | 01:22 |
| openstackgerrit | Merged openstack/ara master: Don't try to uncompress if there's nothing to uncompress https://review.openstack.org/461943 | 02:23 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Fold tips into tooltips and resize panels accordingly https://review.openstack.org/461958 | 02:31 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Use drawCallback hook instead of fnInitComplete for datatables https://review.openstack.org/461960 | 02:33 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Fix bad column type for ara_record's value https://review.openstack.org/461944 | 02:34 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Narrow a little bit the main container https://review.openstack.org/461947 | 02:34 |
| *** iceyao_ has quit IRC | 02:37 | |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Re-introduce the playbook path on mouse over playbook file https://review.openstack.org/461964 | 02:40 |
| *** iceyao has joined #ara | 02:41 | |
| openstackgerrit | Merged openstack/ara master: Fold tips into tooltips and resize panels accordingly https://review.openstack.org/461958 | 03:05 |
| openstackgerrit | Merged openstack/ara master: Use drawCallback hook instead of fnInitComplete for datatables https://review.openstack.org/461960 | 03:05 |
| openstackgerrit | Merged openstack/ara master: Re-introduce the playbook path on mouse over playbook file https://review.openstack.org/461964 | 03:09 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Use get_name() methods for retrieving host and task names https://review.openstack.org/461974 | 03:10 |
| *** iceyao has quit IRC | 03:48 | |
| *** iceyao has joined #ara | 04:10 | |
| *** iceyao has quit IRC | 04:15 | |
| *** iceyao has joined #ara | 04:29 | |
| *** iceyao has quit IRC | 04:33 | |
| *** iceyao has joined #ara | 04:35 | |
| *** iceyao has quit IRC | 05:23 | |
| *** cuongnv has quit IRC | 05:30 | |
| *** iceyao has joined #ara | 05:38 | |
| *** cuongnv has joined #ara | 05:38 | |
| *** iceyao has quit IRC | 05:42 | |
| *** iceyao has joined #ara | 07:42 | |
| *** iceyao has quit IRC | 07:46 | |
| *** iceyao has joined #ara | 08:26 | |
| *** iceyao has quit IRC | 08:30 | |
| *** iceyao has joined #ara | 08:48 | |
| *** iceyao has quit IRC | 08:53 | |
| *** iceyao_ has joined #ara | 09:13 | |
| *** iceyao_ has quit IRC | 09:18 | |
| *** cuongnv_ has joined #ara | 09:23 | |
| *** cuongnv has quit IRC | 09:24 | |
| *** cuongnv_ is now known as cuongnv | 09:34 | |
| *** iceyao has joined #ara | 09:58 | |
| *** iceyao has quit IRC | 10:03 | |
| *** cuongnv has quit IRC | 10:23 | |
| *** iceyao has joined #ara | 10:40 | |
| *** iceyao has quit IRC | 10:45 | |
| *** iceyao has joined #ara | 11:04 | |
| *** iceyao has quit IRC | 11:14 | |
| *** iceyao has joined #ara | 11:42 | |
| *** iceyao has quit IRC | 11:47 | |
| *** iceyao has joined #ara | 12:00 | |
| *** iceyao has quit IRC | 12:05 | |
| *** iceyao has joined #ara | 12:22 | |
| *** iceyao has quit IRC | 12:26 | |
| *** iceyao has joined #ara | 12:29 | |
| *** iceyao has quit IRC | 12:36 | |
| *** iceyao has joined #ara | 12:41 | |
| openstackgerrit | Merged openstack/ara master: Fix bad column type for ara_record's value https://review.openstack.org/461944 | 12:57 |
| openstackgerrit | Merged openstack/ara master: Narrow a little bit the main container https://review.openstack.org/461947 | 12:59 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Use get_name() methods for retrieving host and task names https://review.openstack.org/461974 | 13:11 |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Use get_name() methods for retrieving host and task names https://review.openstack.org/461974 | 13:11 |
| *** tready has joined #ara | 13:14 | |
| tready | any ideas on why my remote client isn't able to send its ansible data to my ara server? postgres logs say, "could not receive data from client: Connection reset by peer" | 13:16 |
| tready | client is able to connect to server using psql | 13:16 |
| dmsimard | tready: not sure, I haven't personally used postgre before. You followed the instructions from the docs ? They were written by a postgre ara user. | 13:17 |
| tready | yes, I did. let me read over them again, I guess | 13:18 |
| dmsimard | tready: _dev ^ maybe you know ? | 13:18 |
| _dev | What does your $ARA_DATABASE environment variable read? | 13:20 |
| _dev | I just woke up and am getting ready to head into my office, so I may be a little slow to reply | 13:20 |
| tready | no worries | 13:20 |
| tready | I'm using the ansible.cfg method | 13:21 |
| tready | the only line in the [ara] section is: | 13:21 |
| _dev | It sounds like that the connection string is borked | 13:21 |
| tready | database = postgresql+psycopg2://user:pass@server:5432/ara | 13:22 |
| _dev | Hm. That's looks right. | 13:22 |
| _dev | Can you see the client attempting to connect server side? | 13:22 |
| _dev | Check in the Postgres server logs, and if that fails, use tcpdump to just make sure | 13:23 |
| tready | postgres logs say, "could not receive data from client: Connection reset by peer" | 13:23 |
| tready | but it's that connection attempting, yes | 13:23 |
| tready | the local ara on the postgres server uses postgres w/o issue | 13:24 |
| _dev | Hm. I wonder if it's trying to use SSL by default? | 13:25 |
| _dev | Is your Postgres server configured with ssl and do you have it set for that user in pg_hba.conf? | 13:25 |
| tready | oooooohhhhh.... yes, psql does look like it connects w/ssl | 13:25 |
| tready | (from the remote client) | 13:26 |
| _dev | Smells like psycopg2 is either trying to connect with ssl and the server isnt set up, or that psycopg2 is trying non-ssl and the server is expecting ssl | 13:27 |
| _dev | Try changing your connection string to try an ssl connection? | 13:27 |
| tready | have you got a link for documentation on that? | 13:27 |
| tready | psql login output: | 13:28 |
| tready | psql (9.5.6, server 9.6.2) | 13:28 |
| tready | WARNING: psql major version 9.5, server major version 9.6. | 13:28 |
| tready | Some psql features might not work. | 13:28 |
| tready | SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) | 13:28 |
| tready | Type "help" for help. | 13:28 |
| tready | I assume I'll find what I'm looking for in the psycopg2 docs | 13:29 |
| dmsimard | tready: let me know if there's something we can improve in the docs if you figure it out | 13:38 |
| tready | I'd think the docs would need to mention something like, "be sure to check to see if your server's expecting an SSL connection, otherwise you may see "connection reset by peer" in your postgres logs" | 13:39 |
| tready | but yeah, I'll confirm that I've got it working once I get the SSL sorted out. but it does seem the likely culprit | 13:39 |
| dmsimard | tready: so we have this documentation that does not exist (yet) around "known issues" https://storyboard.openstack.org/#!/story/2000984 | 13:41 |
| *** karimb has joined #ara | 13:48 | |
| _dev | I didn't even think about the ssl thing since postgres only listens on a unix socket on our box | 13:49 |
| _dev | Duh. My bad. | 13:49 |
| *** infinitejest has joined #ara | 13:49 | |
| openstackgerrit | Merged openstack/ara master: Use get_name() methods for retrieving host and task names https://review.openstack.org/461974 | 14:09 |
| *** openstackgerrit has quit IRC | 14:18 | |
| *** iceyao has quit IRC | 14:35 | |
| *** iceyao has joined #ara | 14:47 | |
| *** tready1 has joined #ara | 15:17 | |
| *** tready has quit IRC | 15:18 | |
| tready1 | _dev: I'm reading that I need to pass the sslmode param to the connection string, but am unsure of the formatting for ara? | 15:36 |
| tready1 | although, documentation says that even w/SSL enabled, server should still negotiate normal connections | 15:43 |
| dmsimard | tready1: it's really not specific to ara, try to check with sqlalchemy documentation | 15:49 |
| dmsimard | it's really a sqlalchemy connection string | 15:49 |
| tready1 | ok, I'll look at that | 15:49 |
| tready1 | well... that may not be it | 15:51 |
| tready1 | I was just able to connect from the machine w/the sslmode=disable flag | 15:51 |
| tready1 | (via psql) | 15:51 |
| tready1 | psql -h server -p 5432 -U user -W -d "dbname=ara sslmode=disable" | 15:52 |
| *** dougbtv has quit IRC | 15:54 | |
| -dmsimard- ARA 0.13.0rc1 is tagged, release notes: https://github.com/openstack/ara/releases/tag/0.13.0rc1 ## To test: pip install git+https://git.openstack.org/openstack/ara@0.13.0rc1 | 15:55 | |
| _dev | you could try | 16:09 |
| _dev | postgres+psycopg2://user:pass@host:5432/ara?sslmode=enforce | 16:09 |
| _dev | er, s/enforce$/require/ | 16:09 |
| *** karimb has quit IRC | 16:30 | |
| *** tready1 has quit IRC | 16:34 | |
| *** infinitejest has quit IRC | 16:36 | |
| *** tready1 has joined #ara | 16:40 | |
| tready1 | same deal w/that string. I'm wondering if it's the auth method? do you know if psql MD5's its pwds by default? b/c I've only got MD5 enabled for host in pg_hba.conf | 16:47 |
| *** harlowja has joined #ara | 16:48 | |
| *** openstackgerrit has joined #ara | 17:04 | |
| openstackgerrit | Jesse Pretorius (odyssey4me) proposed openstack/ara master: [TEST] This is a test - do not merge https://review.openstack.org/462225 | 17:04 |
| *** iceyao has quit IRC | 17:33 | |
| tready1 | whelp, that wasn't it, either. I just passed it an md5 hash as a password, & didn't even get past authentication ("FATAL: password authentication failed for user "blah") | 17:56 |
| tready1 | so I guess that means that the connection is authenticating correctly w/o the hash - just getting reset | 17:57 |
| dmsimard | tready1: that's weird :( | 17:57 |
| tready1 | which again could point back to SSL | 17:57 |
| tready1 | gonna revisit that database string | 17:58 |
| tready1 | though I can definitely use psql to connect from remote using either SSL or no SSL | 18:09 |
| dmsimard | tready1: what version of sqlalchemy is installed ? | 18:12 |
| tready1 | looks like 1.0.12 | 18:14 |
| dmsimard | tready1: I'm picking up sqlalchemy 1.1.9 from pypi, where are you picking it up from ? | 18:15 |
| dmsimard | 1.0.12 is a bit more than a year old, perhaps there's been fixes since then | 18:18 |
| tready1 | I'll update | 18:24 |
| tready1 | it's pypi, iirc | 18:24 |
| tready1 | 1.1.9 after upgrade. same output | 18:27 |
| dmsimard | same output no matter the different variations of the connection string ? | 18:27 |
| tready1 | I can try disabling SSL again, if that's what you mean, but psql can connect from that host regardless of SSL on the connection | 18:28 |
| dmsimard | tready1: I get that, just trying to find what could be the problem with my abysmal knowledge of postgre | 18:31 |
| tready1 | yep, no worries. ok, same output with ?sslmode=require on the end | 18:33 |
| *** tready1 has quit IRC | 18:39 | |
| *** tready1 has joined #ara | 18:40 | |
| tready1 | & again same output with ?sslmode=disable on the end | 18:46 |
| -openstackstatus- NOTICE: Gerrit on review.openstack.org is being restarted to accomodate a memory leak in Gerrit. Service should return shortly. | 18:51 | |
| *** tready1 has quit IRC | 19:12 | |
| *** iceyao has joined #ara | 19:40 | |
| *** iceyao has quit IRC | 19:44 | |
| *** iceyao has joined #ara | 20:08 | |
| *** iceyao has quit IRC | 20:12 | |
| openstackgerrit | David Moreau Simard proposed openstack/ara master: Do not insert an include task for Ansible >=2.2.0 https://review.openstack.org/462290 | 21:02 |
| openstackgerrit | Merged openstack/ara master: Do not insert an include task for Ansible >=2.2.0 https://review.openstack.org/462290 | 21:46 |
| *** harlowja has quit IRC | 22:28 | |
| *** harlowja has joined #ara | 23:31 | |
| *** iceyao has joined #ara | 23:58 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!