| *** jamesmcarthur has quit IRC | 00:17 | |
| *** tosky has quit IRC | 00:26 | |
| *** jamesmcarthur has joined #openstack-trove | 01:19 | |
| *** rcernin has quit IRC | 02:01 | |
| *** rcernin has joined #openstack-trove | 02:05 | |
| *** jamesmcarthur has quit IRC | 02:32 | |
| *** jamesmcarthur has joined #openstack-trove | 02:39 | |
| *** rcernin has quit IRC | 02:39 | |
| *** rcernin has joined #openstack-trove | 02:42 | |
| *** rcernin has quit IRC | 02:51 | |
| *** rcernin has joined #openstack-trove | 03:05 | |
| *** rcernin has quit IRC | 03:12 | |
| *** jamesmcarthur has quit IRC | 03:19 | |
| *** jamesmcarthur has joined #openstack-trove | 03:21 | |
| *** rcernin has joined #openstack-trove | 03:23 | |
| *** jamesmcarthur has quit IRC | 03:23 | |
| *** jamesmcarthur has joined #openstack-trove | 03:23 | |
| *** rcernin has quit IRC | 03:24 | |
| *** rcernin has joined #openstack-trove | 03:24 | |
| *** e0ne has joined #openstack-trove | 04:12 | |
| *** e0ne has quit IRC | 04:12 | |
| lxkong | yasemind: I know you are offline now, in case you can check the channel log, I leave msg here anyway. Please use irc bouncer to hold the session so that you don't miss messages | 04:36 |
|---|---|---|
| lxkong | or please send emails to openstack-discuss mailing list. | 04:36 |
| lxkong | otherwise, it's impossible for us to communicate | 04:37 |
| *** jamesmcarthur has quit IRC | 05:47 | |
| *** yasemind has joined #openstack-trove | 06:02 | |
| *** e0ne has joined #openstack-trove | 06:24 | |
| *** e0ne has quit IRC | 06:24 | |
| *** rcernin has quit IRC | 07:40 | |
| *** rcernin has joined #openstack-trove | 07:47 | |
| *** jamesmcarthur has joined #openstack-trove | 07:47 | |
| *** jamesmcarthur has quit IRC | 07:52 | |
| *** rcernin has quit IRC | 08:06 | |
| *** rcernin has joined #openstack-trove | 08:17 | |
| *** tosky has joined #openstack-trove | 08:33 | |
| *** tosky_ has joined #openstack-trove | 08:52 | |
| *** tosky is now known as Guest86814 | 08:53 | |
| *** tosky_ is now known as tosky | 08:53 | |
| *** Guest86814 has quit IRC | 08:55 | |
| *** rcernin has quit IRC | 09:01 | |
| *** rcernin has joined #openstack-trove | 09:28 | |
| lxkong | yasemind: Hi, the user and database model for PostgreSQL is different with MySQL, so the functions are not supported. Please see https://docs.openstack.org/trove/latest/user/manage-db-and-users.html | 09:32 |
| lxkong | Those are also documented in API doc https://docs.openstack.org/api-ref/database/#databases | 09:32 |
| *** rcernin has quit IRC | 09:47 | |
| *** rcernin has joined #openstack-trove | 10:04 | |
| *** rcernin has quit IRC | 10:20 | |
| lxkong | yasemind: after enable root, you can manage user and db using root. | 10:22 |
| lxkong | yasemind: after you have set up your users, you can then disable root | 10:22 |
| yasemind | lxkong i cant connect psql with root user, how can i set up database and user ? | 10:24 |
| lxkong | how did you create the psql instance? Your command? | 10:25 |
| yasemind | i create database instance at horizon. should i create command line ? | 10:29 |
| *** e0ne has joined #openstack-trove | 10:30 | |
| lxkong | yasemind: can you provide more detailed info? | 10:31 |
| lxkong | what parameters have you specified in the dashboard? | 10:31 |
| lxkong | Have you ever tried CLI? | 10:31 |
| lxkong | yasemind: i have to go sleep, very late here. Please feel free to leave message in this channel (or email, up to you), again, please provide sufficient info for debugging. | 10:34 |
| yasemind | i didn't try to CLI, i select to volume size (1GB), volume type (lvm), datastore (postgresql-12.4), flavor (m1.medium), networking (provider), initialize databases, initial admin user and password | 10:34 |
| yasemind | trove-guestagent.log -> http://paste.openstack.org/show/803460/ | 10:35 |
| *** ahsen has joined #openstack-trove | 10:42 | |
| *** ahsen has quit IRC | 10:52 | |
| *** e0ne has quit IRC | 11:03 | |
| *** rcernin has joined #openstack-trove | 11:07 | |
| *** sapd1 has joined #openstack-trove | 11:41 | |
| *** rcernin has quit IRC | 11:58 | |
| *** rcernin has joined #openstack-trove | 12:23 | |
| *** rcernin has quit IRC | 12:29 | |
| *** rcernin has joined #openstack-trove | 12:41 | |
| *** rcernin has quit IRC | 12:46 | |
| *** rcernin has joined #openstack-trove | 12:52 | |
| *** rcernin has quit IRC | 12:57 | |
| *** rcernin has joined #openstack-trove | 12:58 | |
| *** openstack has joined #openstack-trove | 13:16 | |
| *** ChanServ sets mode: +o openstack | 13:16 | |
| *** __ministry1 has joined #openstack-trove | 13:41 | |
| *** sapd1 has joined #openstack-trove | 14:00 | |
| *** rcernin has joined #openstack-trove | 14:59 | |
| *** rcernin has quit IRC | 15:04 | |
| *** spotz has joined #openstack-trove | 15:10 | |
| *** jmlowe has quit IRC | 15:30 | |
| *** jmlowe has joined #openstack-trove | 15:33 | |
| *** jamesmcarthur has joined #openstack-trove | 15:46 | |
| *** __ministry1 has quit IRC | 15:58 | |
| *** jamesmcarthur has quit IRC | 16:28 | |
| *** jamesmcarthur has joined #openstack-trove | 16:30 | |
| *** rcernin has joined #openstack-trove | 17:00 | |
| *** rcernin has quit IRC | 17:16 | |
| yasemind | lxkong i try to add new rule https://github.com/openstack/trove/blob/bd2b256a377a5648586ec4a5d51edd58dd88a620/trove/guestagent/datastore/postgres/service.py#L127, but it didnt work. | 18:04 |
| *** yasemind has quit IRC | 18:16 | |
| *** yasemind has joined #openstack-trove | 18:21 | |
| *** sapd1 has quit IRC | 18:43 | |
| lxkong | > i can connect psql with root user and postgres database | 18:50 |
| lxkong | How did you fix that? | 18:50 |
| lxkong | yasemind: now you can connect with psql, then what's the current problem? | 18:51 |
| *** jamesmcarthur has quit IRC | 18:52 | |
| yasemind | @lx | 18:52 |
| yasemind | lxkong trove cant create database and user | 18:53 |
| lxkong | Did you see my message sent yesterday? | 18:53 |
| lxkong | https://www.irccloud.com/pastebin/gIAZhqsn/ | 18:53 |
| yasemind | yes i see these | 18:54 |
| yasemind | i try to add new rule https://github.com/openstack/trove/blob/bd2b256a377a5648586ec4a5d51edd58dd88a620/trove/guestagent/da..., but it didnt work. | 18:54 |
| lxkong | you can create users/db using root credential | 18:55 |
| *** jamesmcarthur has joined #openstack-trove | 18:55 | |
| yasemind | i dont want to manually created database and user, can i fix it ? | 18:56 |
| yasemind | why i added new rule for pg_hba.conf file ? i didnt understand | 18:59 |
| lxkong | no, the user/db API was designed only for mysql, only contains very basic operations. If you want to support postgres, you need to wrap everything related in postgres (https://www.postgresql.org/docs/12/user-manag.html) in Trove, which doesn't bring any values and is actually recreating the wheels. | 19:00 |
| lxkong | e.g. if in the future, we introduced another database, we still need to add another group of APIs for users/db management | 19:01 |
| lxkong | it's not as simple as adding new rule in pg_hba.conf | 19:01 |
| lxkong | yasemind: may I know which cloud are you working for? | 19:02 |
| yasemind | we use openstack | 19:03 |
| yasemind | we think to add other database system for future | 19:04 |
| lxkong | yasemind: I know, I mean, are you working for some public cloud or private cloud? | 19:04 |
| yasemind | private cloud | 19:04 |
| lxkong | ok, thanks | 19:07 |
| yasemind | lxkong i work for safir cloud https://www.b3lab.org/en/sayfalar/safir_cloud-13/ | 19:09 |
| lxkong | yasemind: for user and db management for psql, the user (the database owner) has to use root credential to do some initial set up. | 19:09 |
| yasemind | lxkong root user enabled, create database and user after disabled root user in the trove code ? | 19:15 |
| lxkong | use root credential to connect with database to do some initial set up (creating roles, databases, granting rols to dbs). | 19:18 |
| yasemind | lxkong user is root ? https://github.com/openstack/trove/blob/master/trove/guestagent/datastore/postgres/service.py#L736 | 19:27 |
| lxkong | yasemind: 1. Get root credential | 19:36 |
| lxkong | https://www.irccloud.com/pastebin/jaHMVFCZ/ | 19:36 |
| lxkong | 2. Login to the database using root user. | 19:36 |
| lxkong | https://www.irccloud.com/pastebin/mpdB9gfw/ | 19:36 |
| lxkong | Then you add users and dbs in postgres directly. | 19:38 |
| lxkong | yasemind: Do I make myself understood? | 19:38 |
| lxkong | I created the instance by simply using the command: | 19:39 |
| lxkong | https://www.irccloud.com/pastebin/mTDF7RtK/ | 19:39 |
| *** e0ne has joined #openstack-trove | 19:45 | |
| yasemind | lxkong: i understand what do you mean, i want to contribute to trove code, i think postgresql should work automatically like mysql | 19:45 |
| *** jamesmcarthur has quit IRC | 19:47 | |
| *** jamesmcarthur has joined #openstack-trove | 19:48 | |
| *** jamesmcarthur has quit IRC | 19:53 | |
| *** rcernin has joined #openstack-trove | 20:00 | |
| *** yasemind has quit IRC | 20:10 | |
| *** e0ne has quit IRC | 20:36 | |
| lxkong | yasemind, thanks for offering the help, but first I would suggest you take a look at the difference between mysql and postgresql for users management. | 20:37 |
| lxkong | we could definitely provide another group of api dedicated for postgresql | 20:37 |
| *** rcernin has quit IRC | 21:04 | |
| *** e0ne has joined #openstack-trove | 21:06 | |
| *** rcernin has joined #openstack-trove | 21:35 | |
| *** rcernin has quit IRC | 21:51 | |
| *** rcernin has joined #openstack-trove | 21:54 | |
| *** rcernin has quit IRC | 22:00 | |
| *** rcernin has joined #openstack-trove | 22:00 | |
| *** jamesmcarthur has joined #openstack-trove | 23:16 | |
| *** e0ne has quit IRC | 23:16 | |
| *** jamesmcarthur has quit IRC | 23:41 | |
| *** jamesmcarthur has joined #openstack-trove | 23:52 | |
| *** jamesmcarthur has quit IRC | 23:57 | |
Generated by irclog2html.py 2.17.2 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!