Thursday, 2021-03-11

*** jamesmcarthur has quit IRC00:17
*** tosky has quit IRC00:26
*** jamesmcarthur has joined #openstack-trove01:19
*** rcernin has quit IRC02:01
*** rcernin has joined #openstack-trove02:05
*** jamesmcarthur has quit IRC02:32
*** jamesmcarthur has joined #openstack-trove02:39
*** rcernin has quit IRC02:39
*** rcernin has joined #openstack-trove02:42
*** rcernin has quit IRC02:51
*** rcernin has joined #openstack-trove03:05
*** rcernin has quit IRC03:12
*** jamesmcarthur has quit IRC03:19
*** jamesmcarthur has joined #openstack-trove03:21
*** rcernin has joined #openstack-trove03:23
*** jamesmcarthur has quit IRC03:23
*** jamesmcarthur has joined #openstack-trove03:23
*** rcernin has quit IRC03:24
*** rcernin has joined #openstack-trove03:24
*** e0ne has joined #openstack-trove04:12
*** e0ne has quit IRC04:12
lxkongyasemind: 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 messages04:36
lxkongor please send emails to openstack-discuss mailing list.04:36
lxkongotherwise, it's impossible for us to communicate04:37
*** jamesmcarthur has quit IRC05:47
*** yasemind has joined #openstack-trove06:02
*** e0ne has joined #openstack-trove06:24
*** e0ne has quit IRC06:24
*** rcernin has quit IRC07:40
*** rcernin has joined #openstack-trove07:47
*** jamesmcarthur has joined #openstack-trove07:47
*** jamesmcarthur has quit IRC07:52
*** rcernin has quit IRC08:06
*** rcernin has joined #openstack-trove08:17
*** tosky has joined #openstack-trove08:33
*** tosky_ has joined #openstack-trove08:52
*** tosky is now known as Guest8681408:53
*** tosky_ is now known as tosky08:53
*** Guest86814 has quit IRC08:55
*** rcernin has quit IRC09:01
*** rcernin has joined #openstack-trove09:28
lxkongyasemind: 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.html09:32
lxkongThose are also documented in API doc https://docs.openstack.org/api-ref/database/#databases09:32
*** rcernin has quit IRC09:47
*** rcernin has joined #openstack-trove10:04
*** rcernin has quit IRC10:20
lxkongyasemind: after enable root, you can manage user and db using root.10:22
lxkongyasemind: after you have set up your users, you can then disable root10:22
yasemindlxkong i cant connect psql with root user, how can i set up database and user ?10:24
lxkonghow did you create the psql instance? Your command?10:25
yasemindi create database instance at horizon. should i create command line ?10:29
*** e0ne has joined #openstack-trove10:30
lxkongyasemind: can you provide more detailed info?10:31
lxkongwhat parameters have you specified in the dashboard?10:31
lxkongHave you ever tried CLI?10:31
lxkongyasemind: 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
yasemindi 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 password10:34
yasemindtrove-guestagent.log ->  http://paste.openstack.org/show/803460/10:35
*** ahsen has joined #openstack-trove10:42
*** ahsen has quit IRC10:52
*** e0ne has quit IRC11:03
*** rcernin has joined #openstack-trove11:07
*** sapd1 has joined #openstack-trove11:41
*** rcernin has quit IRC11:58
*** rcernin has joined #openstack-trove12:23
*** rcernin has quit IRC12:29
*** rcernin has joined #openstack-trove12:41
*** rcernin has quit IRC12:46
*** rcernin has joined #openstack-trove12:52
*** rcernin has quit IRC12:57
*** rcernin has joined #openstack-trove12:58
*** openstack has joined #openstack-trove13:16
*** ChanServ sets mode: +o openstack13:16
*** __ministry1 has joined #openstack-trove13:41
*** sapd1 has joined #openstack-trove14:00
*** rcernin has joined #openstack-trove14:59
*** rcernin has quit IRC15:04
*** spotz has joined #openstack-trove15:10
*** jmlowe has quit IRC15:30
*** jmlowe has joined #openstack-trove15:33
*** jamesmcarthur has joined #openstack-trove15:46
*** __ministry1 has quit IRC15:58
*** jamesmcarthur has quit IRC16:28
*** jamesmcarthur has joined #openstack-trove16:30
*** rcernin has joined #openstack-trove17:00
*** rcernin has quit IRC17:16
yasemindlxkong 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 IRC18:16
*** yasemind has joined #openstack-trove18:21
*** sapd1 has quit IRC18:43
lxkong>  i can connect psql with root user and postgres database18:50
lxkongHow did you fix that?18:50
lxkongyasemind: now you can connect with psql, then what's the current problem?18:51
*** jamesmcarthur has quit IRC18:52
yasemind@lx18:52
yasemindlxkong trove cant create database and user18:53
lxkongDid you see my message sent yesterday?18:53
lxkonghttps://www.irccloud.com/pastebin/gIAZhqsn/18:53
yasemindyes i see these18:54
yasemind i try to add new rule https://github.com/openstack/trove/blob/bd2b256a377a5648586ec4a5d51edd58dd88a620/trove/guestagent/da..., but it didnt work.18:54
lxkongyou can create users/db using root credential18:55
*** jamesmcarthur has joined #openstack-trove18:55
yasemindi dont want to manually created database and user, can i fix it ?18:56
yasemindwhy i added new rule for pg_hba.conf file ? i didnt understand18:59
lxkongno, 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
lxkonge.g. if in the future, we introduced another database, we still need to add another group of APIs for users/db management19:01
lxkongit's not as simple as adding new rule in pg_hba.conf19:01
lxkongyasemind: may I know which cloud are you working for?19:02
yasemindwe use openstack19:03
yasemindwe think to add other database system for future19:04
lxkongyasemind: I know, I mean, are you working for some public cloud or private cloud?19:04
yasemindprivate cloud19:04
lxkongok, thanks19:07
yasemindlxkong i work for safir cloud https://www.b3lab.org/en/sayfalar/safir_cloud-13/19:09
lxkongyasemind: 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
yasemindlxkong root user enabled, create database and user after disabled root user in the trove code ?19:15
lxkonguse root credential to connect with database to do some initial set up (creating roles, databases, granting rols to dbs).19:18
yasemindlxkong user is root ? https://github.com/openstack/trove/blob/master/trove/guestagent/datastore/postgres/service.py#L73619:27
lxkongyasemind: 1. Get root credential19:36
lxkonghttps://www.irccloud.com/pastebin/jaHMVFCZ/19:36
lxkong2. Login to the database using root user.19:36
lxkonghttps://www.irccloud.com/pastebin/mpdB9gfw/19:36
lxkongThen you add users and dbs in postgres directly.19:38
lxkongyasemind: Do I make myself understood?19:38
lxkongI created the instance by simply using the command:19:39
lxkonghttps://www.irccloud.com/pastebin/mTDF7RtK/19:39
*** e0ne has joined #openstack-trove19:45
yasemindlxkong: i understand what do you mean, i want to contribute to trove code,  i think postgresql should work automatically like mysql19:45
*** jamesmcarthur has quit IRC19:47
*** jamesmcarthur has joined #openstack-trove19:48
*** jamesmcarthur has quit IRC19:53
*** rcernin has joined #openstack-trove20:00
*** yasemind has quit IRC20:10
*** e0ne has quit IRC20:36
lxkongyasemind, 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
lxkongwe could definitely provide another group of api dedicated for postgresql20:37
*** rcernin has quit IRC21:04
*** e0ne has joined #openstack-trove21:06
*** rcernin has joined #openstack-trove21:35
*** rcernin has quit IRC21:51
*** rcernin has joined #openstack-trove21:54
*** rcernin has quit IRC22:00
*** rcernin has joined #openstack-trove22:00
*** jamesmcarthur has joined #openstack-trove23:16
*** e0ne has quit IRC23:16
*** jamesmcarthur has quit IRC23:41
*** jamesmcarthur has joined #openstack-trove23:52
*** jamesmcarthur has quit IRC23:57

Generated by irclog2html.py 2.17.2 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!