Keystone endpoint update

I'm afraid with the V2 API there isn't an update - only a delete and create. To update the endpoint, you'd need to update it and recreate it, or manually tweak the values in the database by hand.

I updated by hand sql in the database (no problems by now), but dubts if any additional configuraion is setup using API create command that we can see.

Hi Daniel,

For updating the URLs in the endpoint you must login to the mysql by following the commands..

$ mysql -u<rootname> -p<password>

mysql> connect keystone;

mysql>select * from endpoint;

It'll list the end points, copy the id of the endpoint which u want to update.

use the following command

mysql> update endpoint set <theUrlValueWithColumnName> where id='<IdoftheEndpoint>';

Now its updated,.. u can check it by again using the "select * from endpoint" command in mysql..

let me knnow its working or not..

Regards,
Rajesh kannan

I did following to update keystone endpoint, this is not good way to do it but it worked for me.

1. Take dump of keystone database using mysqldump command into a sql file
2. Open that sql file in your favourite editor, replace all occurrences of endpoint IP with your desired IP. for example., I replaced 100.69.10.1 with 127.0.0.1 and save changes while taking backup of original sql file.
3. Drop Keystone database
4. Create Keystone database and import that edited sql file using mysql command
5. You can use backup to revert to backup sql file if you want.

mysql>show databases;
mysql>use keystone;
mysql> use keystone;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> update endpoint set url='http://network-public.local.ubuntu.com:9696' where url='http://network-internal-
public.local.ubuntu.com:9696';

Use the above to update mysql command to do multiple endpoints update.

Once made the changes update endpoints in configuration files in controller nodes.

mysql>show databases;
mysql>use keystone;
mysql> use keystone;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> update endpoint set url='http://network-public.local.ubuntu.com:9696' where url='http://network-internal .public.local.ubuntu.com:9696';

Use the above to update mysql command to do multiple endpoints update.

Once made the changes update endpoints in configuration files in controller nodes.