Hi, Anatoly,
I am not sure if you solved this problem already, but I suffered the
similar problem as yours when I upgraded openstack from havana to
icehouse today.
There were two problems I suffered, and both related to msyql table
character set.
Simply check, if you run: keystone-manage db_version, and the version
stays at 37, you probably failed at db_sync as I did.
In my case, while I did keystone-manage db_sync, there was an error in
/var/log/keystone/keystone.log:
2014-06-09 21:23:12.732 53481 CRITICAL keystone [-] ValueError: Tables
"region" have non utf8 collation, please make sure all tables are
CHARSET=utf8
So, the workaround was to go to mysql and change the CHARSET to utf8 for
table: "region", for example, run following sql command in mysql:
use keystone ;
alter table region CHARACTER SET utf8 COLLATE utf8_general_ci;
And, the second problem was actually a bug of db_migration script which
was already reported and fixed, but, unfortunately, it is not yet
available in rdo release, so, you will have to apply patch by hand,
please see detail:
https://git.openstack.org/cgit/openstack/keystone/commit/?id=4408625031bc9804fa4bd4a72988bf31375b7787
I hope this can be helpful, if you have not yet solved this problem.
Best regards,
Felix Lee ~
On 2014年05月29日 13:44, Anatoly Oreshkin wrote:
Hello,
I've upgraded Havana to IceHouse on Scientific Linux 6.5 following these
steps:
yum install http://rdo.fedorapeople.org/openstack-havana/rdo-release-havana.rpm
yum -y update
nova-manage db sync
cinder-manage db sync
glance-manage db_sync
keystone-manage db_sync
When I run command keystone tenenat-list
I get
uthorization Failed: An unexpected error prevented the server from fulfilling
your
request. (HTTP 500)
/var/log/keystone shows
2014-05-29 15:42:58.782 10638 TRACE keystone.common.wsgi ProgrammingError:
(ProgrammingError) (1146, "Table 'keystone.assignment' doesn't exist") 'SELECT
assignment.type AS assignment_type, assignment.actor_id AS assignment_actor_id,
assignment.target_id AS assignment_target_id, assignment.role_id AS
assignment_role_id, assignment.inherited AS assignment_inherited \nFROM
assignment
\nWHERE assignment.actor_id = %s AND assignment.target_id = %s'
('9436d6868f314fae81166cedf1769bed', '71d30105c083454398c9617cd15a9e4d')
2014-05-29 15:42:58.782 10638 TRACE keystone.common.wsgi
Can anybody help me ?
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
--
Felix H.T Lee Academia Sinica Grid & Cloud.
Tel: +886-2-27898308
Office: Room P111, Institute of Physics, 128 Academia Road, Section 2,
Nankang, Taipei 115, Taiwan
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
