Thursday, 2020-07-30

ladruaAnyone? I’m getting error when using cli to try to list flavors02:21
ladruatrove.common.wsgi [-] 67881848-3ad4-4d68-9ff3-c2f24b39b6bd: Invalid input for field identity/password/user: id or name must be present.02:21
ladruatrove datastore-list and trove datastore-version-list works02:22
lxkongladrua: first, please use openstack CLI instead of trove.02:30
lxkongSecond, Trove doesn't support Flavor API any more02:30
lxkongyou should talk to Nova for flavor information02:30
ladruaOk, thanks. I initially tried to follow lates docs: https://docs.openstack.org/trove/latest/admin/building_guest_images.html then tried picking up some pieces here and there.02:31
ladruaBut should I not create a flavour with trove-manage command?02:32
ladruatrove-manage datastore_version_flavor_add mysql 5.7.29 402:32
ladruaIs what I’ve tried02:33
lxkong`datastore_version_flavor_add ` is not creating flavors02:33
ladruaso when you say dont use trove cli, do you also mean I shouldnt use trove-manage ?02:33
lxkongjust defines which flavors a datastore version supports02:33
ladruaNo, but I thought I had to link a existing nova flavor to a datastore version02:34
lxkong`trove-manage` is is CLI for trove datastore management, not identical to `trove` CLI02:34
lxkong`datastore_version_flavor_add ` is not necessary02:35
lxkongladrua: which doc are you following?02:35
lxkonghttps://docs.openstack.org/trove/latest/admin/building_guest_images.html doesn't mention flavor02:35
ladruaI guess I found some older docs02:36
ladruahttps://docs.openstack.org/mitaka/cli-reference/trove-manage.html02:36
lxkongyes, you did02:37
lxkongTrove has been changed a lot since the last two dev cycles02:37
ladruaStill root cause for searching for more docs was same error as mentioned above, when entering Horizon. Horizon UI says “Unable to retrive database instances”02:38
ladruaand log file says trove.common.wsgi [-] 67881848-3ad4-4d68-9ff3-c2f24b39b6bd: Invalid input for field identity/password/user: id or name must be present.02:39
lxkongwhich Trove version have you deployed?02:39
ladruaI deployed it with Kolla with openstack Ussuri02:41
lxkongTrove Horizin plugin is broken I guess, it's not actively maintained.02:41
lxkonglack of contributor, you know02:42
ladruaok..02:42
ladruaI see02:42
lxkongThe server side should be OK02:42
lxkongand python-troveclient is up to date02:42
ladruaI will then try a bit more with the cli and see if I get up and running02:42
ladruaThanks a log for the info02:43
ladrua*lot02:43
ladrua:)02:43
lxkongnp, please let me know if you have other questions02:43
ladruaMuch appreciated02:43
ladruaI get same error when using openstack cli03:00
ladruaopenstack database instance create mysql_instance_1 3     --size 10     --nic net-id=d403cf4a-e9a9-4511-ac76-2fac98d97ca9    --databases test --users user:password     --datastore mysql --datastore_version 5.7.29     --is-public03:04
ladruatrove.common.wsgi [-] d1239986-c766-4866-bd77-225e99ec57c5: Invalid input for field identity/password/user: id or name must be present03:05
ladruaOne thing I notce is that in my creation of datastore, I did not include the “--config-file=/etc/trove/trove.conf” parameter03:08
ladruaas described here: https://docs.openstack.org/trove/latest/admin/datastore.html03:08
ladruaThat might be important … :D03:09
ladruaNah, did not help. Same error…03:27
ladrualxkong: any other pointers?03:42
*** tosky has joined #openstack-trove06:32
*** congnt96 has joined #openstack-trove07:06
*** rcernin has quit IRC07:32
*** congnt96 has quit IRC08:14
*** rcernin has joined #openstack-trove08:29
*** rcernin has quit IRC08:34
lxkong`Invalid input for field identity/password/user: id or name must be present` the error log is weird, I've never seen such msg. Did you try using --debug to see more information?08:51
*** spatel has joined #openstack-trove08:58
*** spatel has quit IRC09:04
ladrualxkong: I did https://gist.github.com/ladrua/78ba48d02d73448ac3c97426a2cfcdef09:09
*** congnt96 has joined #openstack-trove09:26
lxkongladrua: your python-troveclient version?09:39
ladruaI am now using openstack client .. “openstack 5.2.0” it says09:46
ladruatrove --version 3.3.- But I am not using trove command09:48
ladrua*3.3.109:49
ladruaOk, I realized they are old. Upgraded to openstack 5.3.1 and trove 5.0.010:08
ladrua—debug error: https://gist.github.com/ladrua/3e679c6c4a06b1b38abcafad53ff7a6510:10
*** rcernin has joined #openstack-trove10:37
*** rcernin has quit IRC10:54
*** congnt96 has quit IRC11:19
*** spatel has joined #openstack-trove11:52
*** spatel has quit IRC11:56
*** __ministry1 has joined #openstack-trove14:31
*** congnt96 has joined #openstack-trove15:33
*** __ministry1 has quit IRC17:46
*** Reepicheep has quit IRC18:41
*** Reepicheep has joined #openstack-trove22:22
*** SauloASilva has joined #openstack-trove22:25
SauloASilvaHi. I am building my own image with ubuntu 18.04 , rocky and mariadb 10.4. I am facing the follow error : An err22:28
SauloASilvaor occurred preparing datastore: (pymysql.err.InternalError) (1698, u"Access den22:28
SauloASilvaied for user 'root'@'localhost'") (Background on this error at: http://sqlalche.22:28
SauloASilvame/e/2j85): InternalError: (pymysql.err.InternalError) (1698, u"Access denied fo22:28
SauloASilvar user 'root'@'localhost'") . But I can go to console and run mysql -uroot -hlocalhost and connnect to mysql database .22:28
SauloASilvadid anyone already face same problem .22:28
SauloASilvaall other functions are working fine .22:35
*** rcernin has joined #openstack-trove23:13
*** rcernin has quit IRC23:14
*** rcernin has joined #openstack-trove23:14
*** tosky has quit IRC23:14

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