| *** ctracey has quit IRC | 00:00 | |
| *** tmatsu has joined #openstack-trove | 00:01 | |
| *** amit213 has quit IRC | 00:01 | |
| *** zacksh has quit IRC | 00:02 | |
| *** ctracey has joined #openstack-trove | 00:05 | |
| *** amit213 has joined #openstack-trove | 00:06 | |
| *** zacksh has joined #openstack-trove | 00:09 | |
| *** tnowak has quit IRC | 00:12 | |
| *** rajinir_ has quit IRC | 00:21 | |
| *** zhugaoxiao has quit IRC | 01:06 | |
| *** Administrator_ has quit IRC | 01:06 | |
| *** tmatsu_ has joined #openstack-trove | 01:16 | |
| *** tmatsu_ has quit IRC | 01:16 | |
| *** tmatsu_ has joined #openstack-trove | 01:17 | |
| *** tmatsu has quit IRC | 01:19 | |
| *** gcb has joined #openstack-trove | 02:06 | |
| *** tqtran has quit IRC | 03:19 | |
| *** gouthamr has quit IRC | 03:54 | |
| *** Jack_Iv has joined #openstack-trove | 03:59 | |
| *** Jack_Iv has quit IRC | 04:04 | |
| *** gcb has quit IRC | 04:22 | |
| *** gcb has joined #openstack-trove | 04:34 | |
| *** chhavi has joined #openstack-trove | 05:18 | |
| *** Jack_Iv has joined #openstack-trove | 05:58 | |
| *** chhavi has quit IRC | 06:27 | |
| *** chhavi has joined #openstack-trove | 06:29 | |
| *** tqtran has joined #openstack-trove | 07:03 | |
| *** tqtran has quit IRC | 07:07 | |
| *** rcernin has joined #openstack-trove | 07:11 | |
| *** Kevin_Zheng_ has joined #openstack-trove | 07:14 | |
| *** Kevin_Zheng_ is now known as Kevin_Zheng | 07:17 | |
| *** dalees has quit IRC | 07:32 | |
| *** tesseract has joined #openstack-trove | 07:34 | |
| *** ctracey has quit IRC | 07:35 | |
| *** gmann has quit IRC | 07:35 | |
| *** ctracey has joined #openstack-trove | 07:36 | |
| *** gmann has joined #openstack-trove | 07:37 | |
| *** dalees has joined #openstack-trove | 07:43 | |
| *** Jack_Iv has quit IRC | 08:05 | |
| *** pcaruana has joined #openstack-trove | 08:17 | |
| rpittau | fishbone: trove supports mysql 5.6; how did you create the ubuntu image ? | 08:18 |
|---|---|---|
| *** Jack_Iv has joined #openstack-trove | 08:18 | |
| Jack_Iv | Folka, how can I add my ssh key while creating an database instance? | 08:31 |
| *** tosky has joined #openstack-trove | 08:53 | |
| *** tnowak has joined #openstack-trove | 08:56 | |
| *** chhavi has quit IRC | 09:19 | |
| *** Jack_Iv has quit IRC | 09:37 | |
| *** Jack_Iv has joined #openstack-trove | 09:38 | |
| Jack_Iv | Hey | 09:38 |
| Jack_Iv | Where can I find the list of supported systems? | 09:38 |
| Jack_Iv | Can I deploy mysql on a trove-guesagent ubuntu 16.04 ? | 09:39 |
| *** Jack_Iv has quit IRC | 09:51 | |
| *** Jack_Iv has joined #openstack-trove | 09:52 | |
| *** gcb has quit IRC | 10:00 | |
| tnowak | Jack_Iv: to add ssh keys you can probably use cloudconfig file on the controller in /etc/trove/cloudinit/mysql.cloudinit | 10:00 |
| Jack_Iv | it's a hell | 10:01 |
| Jack_Iv | why trove can not do it via nova ? | 10:01 |
| Jack_Iv | I found trove SO unusable and undocumented | 10:01 |
| tnowak | yep | 10:02 |
| openstackgerrit | Tomasz Nowak proposed openstack/trove master: Use CNF_INCLUDE_DIR to create mysql-flavor directory https://review.openstack.org/437369 | 10:05 |
| *** tosky has quit IRC | 10:21 | |
| *** tosky has joined #openstack-trove | 10:22 | |
| *** Jack_Iv has quit IRC | 10:23 | |
| *** Jack_Iv has joined #openstack-trove | 10:23 | |
| *** Jack_Iv has quit IRC | 10:26 | |
| *** Jack_Iv has joined #openstack-trove | 10:26 | |
| *** Jack_Iv has quit IRC | 10:47 | |
| *** Jack_Iv has joined #openstack-trove | 10:48 | |
| *** Jack_Iv has quit IRC | 10:52 | |
| *** chhavi has joined #openstack-trove | 11:03 | |
| *** chhavi has quit IRC | 11:10 | |
| *** chhavi has joined #openstack-trove | 11:10 | |
| azlev | tnowak: Hi. Is it necessary to know the mysql config structure before we bootstrap? Trove can just override all files and doesnt bother how it was before | 11:16 |
| azlev | I mean, the only really important file is the first one, that include other files | 11:17 |
| tnowak | azlev: I think you are right that the first file is the critical one. and there are commands that try to purge the default configuration. what about selinux policies? the paths would need to be listed for hardening. | 11:27 |
| azlev | good point | 11:37 |
| azlev | tnowak: another qestion, isnt red hat using mariadb? Should this code be in some mariadb specifics place? (honest question) | 11:43 |
| *** tmatsu_ has quit IRC | 11:43 | |
| azlev | After deploy a trove at work in next month, I want to contribute with code, so I need to understand it | 11:44 |
| tnowak | azlev: that's right. I just managed to run instances with mariadb 10.1 on RHEL 7.2 (without guest images, just with cloud_config), but I changed all paths with sed. | 11:50 |
| tnowak | mariadb code goes to trove/guestagent/datastore/experimental/mariadb | 11:52 |
| *** chhavi has quit IRC | 11:53 | |
| *** chhavi has joined #openstack-trove | 11:54 | |
| *** tosky_ has joined #openstack-trove | 11:57 | |
| *** tosky has quit IRC | 11:59 | |
| *** ildikov has quit IRC | 12:01 | |
| *** ildikov has joined #openstack-trove | 12:03 | |
| *** tosky_ is now known as tosky | 12:06 | |
| *** chhavi has quit IRC | 12:07 | |
| *** chhavi has joined #openstack-trove | 12:07 | |
| chhavi | hello, I built the trove image for the mariadb, the trove-guestagent service is running, but the trove deploy is failing with the "GuestError: An error occurred communicating with the guest: Service is not discovered." | 13:02 |
| chhavi | from the guestagent logs it shows the guestagent module drivers are not initialized. | 13:03 |
| chhavi | do we need any additional configs to load the same | 13:03 |
| amrith | not that I know of chhavi | 13:03 |
| amrith | but I don't know how the "trove-guestagent service" could be running if the guestagent logs show that the "guestagent module drivers are not initialized" | 13:04 |
| chhavi | ok, | 13:04 |
| amrith | what that likely means is that your datastore specification in the config file isn't making its way across. | 13:04 |
| amrith | or there's a datastore configuration file but it isn't able to resolve that to the drivers for that datastore. | 13:05 |
| chhavi | What it looks that by default there is ping driver which should be loaded when we first start the guestagent | 13:05 |
| amrith | A large amount of the code in the guestagent is datastore agnostic and it looks to load a guestagent model | 13:05 |
| amrith | s/model$/module/ | 13:05 |
| chhavi | but in my case Initializing module driver manager. | 13:06 |
| chhavi | 2017-02-28 09:08:08.566 2036 INFO trove.guestagent.module.driver_manager [-] No module drivers loaded | 13:06 |
| chhavi | 2" | 13:06 |
| chhavi | so the service is running but its of no use | 13:06 |
| amrith | yup | 13:06 |
| chhavi | guest_info config file has the proper datastore_manager initialization | 13:07 |
| chhavi | i am trying for mariadb | 13:07 |
| amrith | the driver_manager is pretty straightforward; it looks to resolve that datatore and load a module | 13:07 |
| amrith | something is messed up; maybe in the way python is looking for the modules, or where your guestagent code is ending up | 13:08 |
| amrith | did you figure out where to put the guestagent code (i.e. not use the rsync/scp) | 13:08 |
| -openstackstatus- NOTICE: restarting gerrit to address performance problems | 13:09 | |
| *** ChanServ changes topic to "restarting gerrit to address performance problems" | 13:09 | |
| amrith | in any event, you have a guest instance coming up; if you configured it for ssh (you must have; you appear to have shell access) just ssh into it and try and start the trove-guest service manually | 13:09 |
| amrith | and you'll be able to debug it live | 13:09 |
| amrith | once you figure out what's wrong, you can rebuild your guest image. | 13:09 |
| amrith | and I suspect that given where you are getting a failure, the prepare message is still in the queue so when you get to load the right module, your instance may even just go ACTIVE | 13:09 |
| chhavi | yes i fixed those issues for not using the rsync, and cloning the code for the correct branch | 13:09 |
| amrith | anyway, I have to run now to a 9am meeting. I'll be back online later | 13:10 |
| chhavi | sure, | 13:10 |
| chhavi | i am able to login and trying to debug the instance | 13:10 |
| *** kylek3h has joined #openstack-trove | 13:12 | |
| -openstackstatus- NOTICE: ok gerrit is back to normal | 13:38 | |
| *** ChanServ changes topic to "ok gerrit is back to normal" | 13:38 | |
| *** spilla has joined #openstack-trove | 13:42 | |
| *** ChanServ changes topic to "Trove Openstack Database as a Service | Docs https://github.com/openstack/trove | Channel Logs http://eavesdrop.openstack.org/irclogs/ | IRC must read http://sackheads.org/~bnaylor/spew/away_msgs.html" | 13:44 | |
| -openstackstatus- NOTICE: gerrit is back to normal and I don't know how to use the openstackstaus bot | 13:44 | |
| *** gouthamr has joined #openstack-trove | 13:50 | |
| *** openstackgerrit has quit IRC | 14:03 | |
| *** openstackgerrit has joined #openstack-trove | 14:14 | |
| openstackgerrit | Merged openstack/trove stable/newton: Prepare for using standard python tests https://review.openstack.org/427897 | 14:14 |
| *** Jack_Iv has joined #openstack-trove | 14:17 | |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger in common/strategies/ https://review.openstack.org/433782 | 14:26 |
| *** chlong has joined #openstack-trove | 14:30 | |
| tnowak | chhavi: I had it today i mitaka, fixed with https://review.openstack.org/#/c/437341/ | 14:38 |
| tnowak | but who knows, it may be something different | 14:39 |
| *** tmatsu has joined #openstack-trove | 14:44 | |
| *** tmatsu has quit IRC | 14:48 | |
| fishbone | rpittau: I built the image inside openstack actually; are you saying trove does not support mysql-5.6? | 14:58 |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger in common/ https://review.openstack.org/433819 | 15:00 |
| fishbone | rpittau: my mistake, I meant to write mysql-5.7 | 15:00 |
| *** Jack_Iv has quit IRC | 15:01 | |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger in common/ https://review.openstack.org/433819 | 15:01 |
| *** Jack_Iv has joined #openstack-trove | 15:01 | |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger part 5 https://review.openstack.org/433833 | 15:08 |
| *** chlong has quit IRC | 15:11 | |
| *** johnma has quit IRC | 15:12 | |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger part 6 https://review.openstack.org/433846 | 15:13 |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger part 7 https://review.openstack.org/433858 | 15:21 |
| rpittau | fishbone: trove supports all features only on mysql 5.6; on mysql 5.7 is limited (e.g. no replication) | 15:22 |
| fishbone | rpittau: I see, I will try with mysql-5.6 | 15:23 |
| rpittau | fishbone: you should look at the integration part in the trove github repo if you want to build images | 15:24 |
| fishbone | rpittau: do you have a link for that? I have installed directly from the cloud repositories I have not been using the git repositories. | 15:25 |
| fishbone | rpittau: this references issues such as the /var/lib/mysql/data folder creation right? | 15:26 |
| rpittau | fishbone: https://github.com/openstack/trove | 15:26 |
| rpittau | fishbone: by default the expected base dir for mysql is /var/lib/mysql, that means that the data dir should be /var/lib/mysql/data; you can modify that behavior in different ways, but for my experience, a default installation is better | 15:32 |
| fishbone | rpittau: I was running into issues when starting the mysql service in the trove image as it said the system database was not installed, I noticed that the mysql database folder on instantiation was moved from /var/lib/mysql to /var/lib/mysql/data, is this normal behavior or do I have to change a setting in mysql to recognize the new location? | 15:35 |
| fishbone | rpittau: perhaps it was also due to the mysql version I was using? | 15:35 |
| *** chlong has joined #openstack-trove | 15:43 | |
| tnowak | trove moves stuff to .../data, because /var/lib/mysql is mounted from an external volume, and "lost+found" directory blocks mariadb from creating its files (complains about some files there) | 15:53 |
| tnowak | I just run "sed -i 's:datadir=/var/lib/mysql$:#datadir=/var/lib/mysql:' /etc/my.cnf /etc/my.cnf.d/*" | 15:55 |
| tnowak | BTW, (in mitaka at least) it leaves incorrect SELinux context on the remounted /var/lib/mysql, so mariadb can't start ("Bind on unix socket: Permission denied") | 15:56 |
| *** rajinir_ has joined #openstack-trove | 15:56 | |
| openstackgerrit | Gábor Antal proposed openstack/trove master: Handle log message interpolation by the logger part 8 https://review.openstack.org/434195 | 16:00 |
| *** rcernin has quit IRC | 16:08 | |
| fishbone | tnowak: at what point do you run the sed command? | 16:08 |
| *** mugsie__ is now known as mugsie | 16:09 | |
| tnowak | fishbone: before starting the guestagent, to comment out the default datadir | 16:09 |
| fishbone | tnowak: ah, so as user data? | 16:10 |
| tnowak | yes, cloud_config file... | 16:11 |
| fishbone | tnowak: Just so I understand, the purpose here is to comment out the default data directory of mysql as it will be recreated on instantiation? | 16:12 |
| openstackgerrit | Peter Stachowski proposed openstack/trove master: Stabilize gate: Fix CONTROLLER_IP is .1 issue https://review.openstack.org/439038 | 16:12 |
| tnowak | fishbone: yes, with new datadir set in files in e.g. /etc/mysql.conf.d/* from guestagent templates | 16:15 |
| fishbone | tnowak: thanks, I will experiment with this | 16:17 |
| tnowak | good luck | 16:17 |
| *** Jack_Iv has quit IRC | 16:20 | |
| *** Jack_Iv has joined #openstack-trove | 16:20 | |
| *** pcaruana has quit IRC | 16:34 | |
| *** Jack_Iv_ has joined #openstack-trove | 16:44 | |
| *** Jack_Iv has quit IRC | 16:48 | |
| *** tqtran has joined #openstack-trove | 16:59 | |
| *** tqtran has quit IRC | 16:59 | |
| fishbone | tnowak: now I am getting a mysqld sock error | 17:00 |
| fishbone | the mysql service runs fine on the image prior to instantiation | 17:00 |
| fishbone | tnowak: based on logs it seems like mysql starts up fine, until the trove guestagent stops it, then it cannot be start again | 17:01 |
| tnowak | fishbone: yeah, guestagent does a lot of file manipulation. did you enable debugging? | 17:05 |
| tnowak | fishbone: I use sed -i 's/# debug = True/debug = True/' /etc/trove/trove-guestagent.conf | 17:06 |
| *** gcb has joined #openstack-trove | 17:06 | |
| tnowak | fishbone: you will every "sudo mv/cp ..." g.a. runs | 17:07 |
| *** tesseract has quit IRC | 17:09 | |
| fishbone | tnowak: yes debug mode is on, I see that it copies over the my.cnf and does a find for all cnf files in conf.d | 17:12 |
| tnowak | anything in /var/log/mariadb/? | 17:13 |
| fishbone | tnowak: then it proceeds to start mysql and updaterc, then it stops it but cant start it back up | 17:13 |
| fishbone | tnowak: I am actually using mysql as opposed to mariadb, but no there are no logs in /var/log/mysql | 17:14 |
| tnowak | try trunning mysqld_safe manually | 17:16 |
| *** gcb has quit IRC | 17:30 | |
| azlev | fishbone: check wich user is running the backup. I coudn't backup in my tests because backup runs with root, but only user trove has the .my.cnf | 17:30 |
| *** tosky has quit IRC | 17:31 | |
| *** chhavi has quit IRC | 17:44 | |
| *** chlong has quit IRC | 18:06 | |
| *** AJaeger has left #openstack-trove | 18:28 | |
| fishbone | tnowak: All is well now, thank you very much for your help. It turns out all I needed to do was add a header to the main my.cnf file | 18:37 |
| tnowak | fishbone: header? | 18:38 |
| fishbone | tnowak: yes the original my.cnf file only has the uncommented line to include the other folders but it does not have the leading [mysql] directive, when I added that it seems to work | 18:40 |
| tnowak | interesting, thanks for that | 18:41 |
| openstackgerrit | Tomasz Nowak proposed openstack/trove master: Use existing CNF_INCLUDE_DIR to create mysql-flavor directory https://review.openstack.org/437369 | 18:42 |
| *** chlong has joined #openstack-trove | 19:25 | |
| *** johnma has joined #openstack-trove | 19:34 | |
| *** Jack_Iv_ has quit IRC | 19:47 | |
| *** Jack_Iv has joined #openstack-trove | 19:48 | |
| *** Jack_Iv has quit IRC | 19:52 | |
| *** Jack_Iv has joined #openstack-trove | 20:05 | |
| *** harlowja has quit IRC | 20:15 | |
| *** harlowja has joined #openstack-trove | 20:16 | |
| openstackgerrit | Merged openstack/trove master: Install Redis 3.2.6 by compilation https://review.openstack.org/416361 | 20:36 |
| openstackgerrit | amrith proposed openstack/trove master: DNM: testing gate https://review.openstack.org/438664 | 20:37 |
| openstackgerrit | amrith proposed openstack/trove master: handle impending oslo.messaging deprecation https://review.openstack.org/407626 | 20:42 |
| openstackgerrit | amrith proposed openstack/trove master: Remove Trove's support for Heat https://review.openstack.org/385513 | 20:43 |
| *** mpotdar_ has joined #openstack-trove | 20:54 | |
| *** mpotdar_ has quit IRC | 20:55 | |
| *** johnma has quit IRC | 21:09 | |
| *** chlong has quit IRC | 21:27 | |
| *** mpotdar has joined #openstack-trove | 21:38 | |
| *** chlong has joined #openstack-trove | 21:39 | |
| *** gouthamr has quit IRC | 21:44 | |
| *** mpotdar has quit IRC | 21:47 | |
| *** mpotdar has joined #openstack-trove | 21:48 | |
| *** mpotdar has quit IRC | 21:53 | |
| *** Jack_Iv has quit IRC | 21:56 | |
| *** Jack_Iv has joined #openstack-trove | 21:56 | |
| *** chlong has quit IRC | 21:58 | |
| *** Jack_Iv has quit IRC | 22:01 | |
| *** spilla has quit IRC | 22:07 | |
| openstackgerrit | Merged openstack/trove master: Fix module-instances command https://review.openstack.org/403287 | 22:28 |
| *** gouthamr has joined #openstack-trove | 22:28 | |
| trevormc | glad to see things merging :) | 22:33 |
| *** fishbone has quit IRC | 23:18 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!