| *** rcernin_ has joined #openstack-sahara | 01:23 | |
| *** rcernin has quit IRC | 01:25 | |
| openstackgerrit | Andriy Shevchenko proposed openstack/openstack-ansible-os_sahara master: import zuul job settings from project-config https://review.openstack.org/594690 | 01:55 |
|---|---|---|
| openstackgerrit | Andriy Shevchenko proposed openstack/openstack-ansible-os_sahara master: switch documentation job to new PTI https://review.openstack.org/594691 | 01:55 |
| *** rcernin has joined #openstack-sahara | 02:00 | |
| openstackgerrit | Andriy Shevchenko proposed openstack/openstack-ansible-os_sahara stable/ocata: import zuul job settings from project-config https://review.openstack.org/594759 | 02:01 |
| *** rcernin_ has quit IRC | 02:03 | |
| *** Bhujay has joined #openstack-sahara | 04:16 | |
| *** cmart has quit IRC | 04:31 | |
| *** galaxyblr has joined #openstack-sahara | 04:32 | |
| *** galaxyblr has quit IRC | 04:38 | |
| *** galaxyblr has joined #openstack-sahara | 04:39 | |
| Bhujay | ranger installation error http://paste.openstack.org/show/728566/ | 04:56 |
| Bhujay | mariadb was installed in the image, the VM shows it - http://paste.openstack.org/show/728567/ | 05:07 |
| *** pcaruana has joined #openstack-sahara | 06:41 | |
| *** ivoline has joined #openstack-sahara | 06:42 | |
| *** ivoline has quit IRC | 06:48 | |
| *** rcernin has quit IRC | 07:07 | |
| *** tosky has joined #openstack-sahara | 07:13 | |
| Bhujay | tosky , the error i hv pasted looks like missing mysql.service alias in mariadb.service | 07:19 |
| Bhujay | so i have disabled the mysql install and changed mysql start to maridb start here https://github.com/openstack/sahara/blob/f8566f6daf18b29be8bc44ec1ce5e9dd16c87ef3/sahara/plugins/ambari/deploy.py#L200b start here .. | 07:22 |
| tosky | no, no, that should not be needed | 07:22 |
| tosky | I deployed ambari on CentOS and RHEL which use mariadb | 07:22 |
| Bhujay | on the vm i wanted to start with mysqld and didnt find the service but mariadb started | 07:24 |
| tosky | the code should be changed to use systemctl start mysqld | 07:24 |
| Bhujay | ok let me check on the vm if systemctl recognize that service | 07:24 |
| Bhujay | no , it doesn't | 07:27 |
| Bhujay | https://bugzilla.redhat.com/show_bug.cgi?id=1520577 | 07:27 |
| openstack | bugzilla.redhat.com bug 1520577 in mariadb "systemd unit file for mariadb server should include alias for mysqld.service" [Unspecified,Closed: cantfix] - Assigned to mschorm | 07:27 |
| tosky | ok, ok, change it to mariadb | 07:28 |
| tosky | but still systemctl | 07:28 |
| Bhujay | ok , so this error stage was gone . prepare ranger was ok but it failed when ambari tried to install ranger . | 07:30 |
| tosky | also the line before should bechanged probably to use the r.install_package method | 07:30 |
| tosky | and specify mariadb-server also there | 07:30 |
| tosky | so that it could work also with ubuntu | 07:30 |
| Bhujay | sure , noted that | 07:31 |
| Bhujay | now we need to debug why ambari fails with DatabaseException:no database selected | 07:33 |
| Bhujay | http://paste.openstack.org/show/728571/ - please see the bottom part which is log from ambari | 07:33 |
| Bhujay | you would notice that the db connection check is passed , but the select query actually don't mention any db name | 07:34 |
| *** tosky has quit IRC | 07:43 | |
| *** tosky has joined #openstack-sahara | 07:43 | |
| tosky | I never used directly the mysql connector for java, so maybe something else is missing | 07:46 |
| tosky | maybe it just tries to use the default db | 07:48 |
| tosky | is it possible to print the content of /tmp/init.sql before it's removed? | 07:48 |
| Bhujay | sure , I will do | 07:48 |
| tosky | also, more important question: are there updated instruction for installing ranger inside ambari? | 07:49 |
| tosky | I have the feeling that the code there was written some time ago | 07:49 |
| Bhujay | from the init_db_template we see init.sql is nothing but the root user nae and passwrd ? are you looking for the db pwd ? | 07:50 |
| tosky | I was looking for the creation of a database | 07:50 |
| tosky | as described here: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.2/bk_security/content/configuring_mysql_for_ranger.html | 07:51 |
| Bhujay | will init.sql have it ? is it not just for user and pwd creation https://github.com/openstack/sahara/blob/f8566f6daf18b29be8bc44ec1ce5e9dd16c87ef3/sahara/plugins/ambari/deploy.py#L188 | 07:52 |
| Bhujay | i can still get the output if you want , let me know | 07:52 |
| openstackgerrit | OpenStack Proposal Bot proposed openstack/sahara-dashboard stable/rocky: Imported Translations from Zanata https://review.openstack.org/594053 | 07:53 |
| tosky | I don't know if init.sql would have it :) | 07:54 |
| tosky | so I wonder what happened back then when the code was added | 07:54 |
| Bhujay | shd i insert the code in init.sql as per hortonworks doc link u shared ? | 07:56 |
| tosky | well, the question is: does ambari assume to find a user with that username and password, and a database with that name as written in that page? | 07:58 |
| tosky | or are those parameters? | 07:58 |
| * tosky bbl | 07:59 | |
| Bhujay | thinking | 08:00 |
| Bhujay | from the ambari log we can see db connection with user name and pwd is ok. so the question can be narrowed down to if the db exists or not | 08:01 |
| Bhujay | and when the db is created , is it during ambari server set up or during ranger installation | 08:01 |
| Bhujay | if during ambari server set up , do we need to change the default ambari db from the ambari setting , iirc i saw somewhere a ambari default db realated setting in the ui , is it creating problem ? | 08:02 |
| *** pcaruana has quit IRC | 08:28 | |
| *** pcaruana has joined #openstack-sahara | 08:30 | |
| *** tosky has quit IRC | 08:59 | |
| *** tosky has joined #openstack-sahara | 09:00 | |
| tosky | is this ambari default db the default db used by ambari on the ambari node, or is it an additional db installed on another node so that it can be used by services? | 09:36 |
| Bhujay | tosky , ambari default db is postgres . I am trying on a single node . Ranger is using mysql on the same node . I logged into the db with root ( pwd retrived from openstack db ) and found during ranger installation randeradmin user and db schema git cerated ok | 09:41 |
| Bhujay | got* | 09:41 |
| tosky | Bhujay: I found https://issues.apache.org/jira/browse/RANGER-651 with a quick search | 09:49 |
| tosky | maybe related? | 09:49 |
| Bhujay | let bme see | 09:49 |
| tosky | uh uh | 09:50 |
| tosky | this is an old bug | 09:50 |
| tosky | https://storyboard.openstack.org/#!/story/1496527 | 09:50 |
| Bhujay | ok , i chekced that xml file , the connection string to db looks ok | 09:51 |
| tosky | which version of HDP are you trying to deploy? | 09:51 |
| Bhujay | 2.4 | 09:51 |
| tosky | with ambari 2.4? | 09:51 |
| Bhujay | yes | 09:51 |
| tosky | does the error match the one in the story? | 09:51 |
| Bhujay | checking | 09:51 |
| Bhujay | yes the error is the same for dbexception but there is also a permission error http://paste.openstack.org/show/728580/ . Also what is the change to be made in ranger-admin-site.xml? | 10:09 |
| tosky | all I know is in that page :) | 10:24 |
| Bhujay | thanks tosky , i will gothrough this in more details to see if something can be done | 10:45 |
| tosky | thanks | 10:46 |
| Bhujay | i got into ranger due to phoenix installation issue which is reqd by my organization. if you can hint something | 10:46 |
| *** dave-mccowan has joined #openstack-sahara | 10:47 | |
| Bhujay | the error is http://paste.openstack.org/show/728584/ | 10:48 |
| Bhujay | tosky. do u think that was something to do with ranger ? | 10:49 |
| tosky | I really don't know | 10:50 |
| tosky | I never tried to deploy it | 10:50 |
| Bhujay | tosky , all the effort i have given so far is based on Ambari 2.4 and HDP 2.4. How about ambari 2.5 image , is it ok to invest effort on ? | 10:53 |
| tosky | HDP or ambari 2.5? | 10:55 |
| Bhujay | Ambari 2.4 | 10:55 |
| Bhujay | sorry | 10:55 |
| Bhujay | Ambari 2.5 | 10:55 |
| tosky | I think we jumped from Ambari 2.4 to Ambari 2.6 | 10:55 |
| tosky | the summary is: | 10:55 |
| tosky | - with sahara-image-pack on queens you can generate an Ambari 2.4 image that can spawn HDP 2.5, 2.4, 2.3 | 10:56 |
| tosky | - with sahara-image-pack on rocky you can generate an Ambari 2.6 image that can spawn HDP 2.6, 2.5 and 2.4, or an Ambari 2.4 image for HDP 2.3 | 10:56 |
| Bhujay | what is the dependency on rocky , can i try the sahara/rock/stable on queen ? | 10:57 |
| Bhujay | i mean sahara latest stable tag on openstack queen ? | 10:58 |
| tosky | that would have Ambari 2.6 | 11:00 |
| tosky | which may require some changes in queens | 11:00 |
| Bhujay | humm | 11:02 |
| Bhujay | but ambari 2.4 with hdp2.5 image tested ok ? | 11:02 |
| tosky | I did test it at least once :) | 11:03 |
| Bhujay | that sounds good | 11:04 |
| openstackgerrit | Merged openstack/sahara-dashboard stable/rocky: Imported Translations from Zanata https://review.openstack.org/594053 | 11:33 |
| tellesnobrega | Bhujay, I'm a little late to the party, but looks like you got some help already, let me know if I can be of any assistance | 11:42 |
| openstackgerrit | Merged openstack/puppet-sahara stable/rocky: Update UPPER_CONSTRAINTS_FILE for stable/rocky https://review.openstack.org/593836 | 12:52 |
| *** Bhujay has quit IRC | 13:21 | |
| *** galaxyblr has quit IRC | 13:28 | |
| openstackgerrit | Merged openstack/puppet-sahara stable/rocky: Update .gitreview for stable/rocky https://review.openstack.org/593835 | 13:43 |
| *** cmart has joined #openstack-sahara | 13:51 | |
| openstackgerrit | Andriy Shevchenko proposed openstack/openstack-ansible-os_sahara stable/pike: import zuul job settings from project-config https://review.openstack.org/595066 | 14:47 |
| openstackgerrit | Andriy Shevchenko proposed openstack/openstack-ansible-os_sahara stable/queens: import zuul job settings from project-config https://review.openstack.org/595119 | 14:54 |
| *** cmart has quit IRC | 14:56 | |
| openstackgerrit | Andriy Shevchenko proposed openstack/openstack-ansible-os_sahara stable/rocky: import zuul job settings from project-config https://review.openstack.org/595181 | 15:02 |
| *** cmart has joined #openstack-sahara | 15:08 | |
| *** pcaruana has quit IRC | 15:10 | |
| *** openstackgerrit has quit IRC | 15:31 | |
| *** pcaruana has joined #openstack-sahara | 15:49 | |
| *** cmart has quit IRC | 16:39 | |
| *** cmart has joined #openstack-sahara | 17:04 | |
| *** afazekas_ has quit IRC | 17:25 | |
| *** rodrigods has joined #openstack-sahara | 17:44 | |
| *** cmart has quit IRC | 18:08 | |
| *** tosky has quit IRC | 18:47 | |
| *** pcaruana has quit IRC | 19:47 | |
| *** cmart has joined #openstack-sahara | 20:48 | |
| *** cmart has quit IRC | 22:18 | |
| *** rcernin has joined #openstack-sahara | 22:34 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!