[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-10-27 Thread Mark Vanderwiel
** Changed in: openstack-chef
   Status: Triaged = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-10-27 Thread Mark Vanderwiel
** Changed in: openstack-chef
   Status: Triaged = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-08-14 Thread JJ Asghar
Here is the openstack + chef bug report: https://bugs.launchpad.net
/openstack-chef/+bug/1356887

** Also affects: openstack-chef
   Importance: Undecided
   Status: New

** Changed in: openstack-chef
   Importance: Undecided = High

** Changed in: openstack-chef
   Status: New = Triaged

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-08-14 Thread JJ Asghar
Here is the openstack + chef bug report: https://bugs.launchpad.net
/openstack-chef/+bug/1356887

** Also affects: openstack-chef
   Importance: Undecided
   Status: New

** Changed in: openstack-chef
   Importance: Undecided = High

** Changed in: openstack-chef
   Status: New = Triaged

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-08-14 Thread JJ Asghar
https://bugs.launchpad.net/openstack-chef/+bug/1356887

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-08-06 Thread JJ Asghar
Heres' a fix, it's gross but works.

# mysql -u root -pilikerandompasswords glance
mysql alter table migrate_version convert to character set utf8 collate 
utf8_unicode_ci;
mysql flush privileges;
mysql quit

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-06-30 Thread Jon Proulx
HI All,

I Just hit this bug during a test Upuntu 12.04 test upgrade , I see fix
released for 14.04 should I have this fix in 12.04?

root@test-controller:~# dpkg -l glance
||/ Name   Version
+++-==
ii  glance 1:2014.1-0ubuntu1~cloud0 

root@test-controller:~# glance-manage db sync
2014-06-30 16:59:24.744 9119 CRITICAL glance [-] ValueError: Tables 
image_locations,image_members,image_properties,image_tags,images,migrate_version
 have non utf8 collation, please make sure all tables are CHARSET=utf8

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-29 Thread Corey Bryant
** Changed in: glance (Ubuntu)
   Status: Triaged = Fix Released

** Changed in: glance (Ubuntu Trusty)
   Status: Triaged = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-29 Thread Corey Bryant
** Changed in: glance (Ubuntu)
   Status: Triaged = Fix Released

** Changed in: glance (Ubuntu Trusty)
   Status: Triaged = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


Re: [Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-29 Thread mtibaa wael
Thanks a lot


2014-04-29 18:27 GMT+02:00 Corey Bryant corey.bry...@canonical.com:

 ** Changed in: glance (Ubuntu)
Status: Triaged = Fix Released

 ** Changed in: glance (Ubuntu Trusty)
Status: Triaged = Fix Released

 --
 You received this bug notification because you are subscribed to the bug
 report.
 https://bugs.launchpad.net/bugs/1279000

 Title:
   db migrate script to set charset=utf8 for all tables

 Status in OpenStack Image Registry and Delivery Service (Glance):
   Fix Released
 Status in Oslo - a Library of Common OpenStack Code:
   Fix Released
 Status in “glance” package in Ubuntu:
   Fix Released
 Status in “glance” source package in Trusty:
   Fix Released

 Bug description:
   2014-02-11 17:42:15.495 26564 CRITICAL glance [-] ValueError: Tables
 image_locations,image_members,image_properties,image_tags,images,migrate_version,task_info,tasks
 have non utf8 collation, please make sure all tables are CHARSET=utf8
   2014-02-11 17:42:15.495 26564 TRACE glance Traceback (most recent call
 last):
   2014-02-11 17:42:15.495 26564 TRACE glance   File
 /usr/local/csi/share/csi-glance.venv//bin/glance-manage, line 13, in
 module
   2014-02-11 17:42:15.495 26564 TRACE glance sys.exit(main())
   2014-02-11 17:42:15.495 26564 TRACE glance   File
 /usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/cmd/manage.py,
 line 220, in main
   2014-02-11 17:42:15.495 26564 TRACE glance return
 CONF.command.action_fn()
   2014-02-11 17:42:15.495 26564 TRACE glance   File
 /usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/cmd/manage.py,
 line 121, in sync
   2014-02-11 17:42:15.495 26564 TRACE glance
 CONF.command.current_version)
   2014-02-11 17:42:15.495 26564 TRACE glance   File
 /usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/cmd/manage.py,
 line 98, in sync
   2014-02-11 17:42:15.495 26564 TRACE glance
 migration.db_sync(db_migration.MIGRATE_REPO_PATH, version)
   2014-02-11 17:42:15.495 26564 TRACE glance   File
 /usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/openstack/common/db/sqlalchemy/migration.py,
 line 195, in db_sync
   2014-02-11 17:42:15.495 26564 TRACE glance _db_schema_sanity_check()
   2014-02-11 17:42:15.495 26564 TRACE glance   File
 /usr/local/csi/share/csi-glance.venv/lib/python2.6/site-packages/glance/openstack/common/db/sqlalchemy/migration.py,
 line 216, in _db_schema_sanity_check
   2014-02-11 17:42:15.495 26564 TRACE glance ) % ','.join(table_names))
   2014-02-11 17:42:15.495 26564 TRACE glance ValueError: Tables
 image_locations,image_members,image_properties,image_tags,images,migrate_version,task_info,tasks
 have non utf8 collation, please make sure all tables are CHARSET=utf8
   2014-02-11 17:42:15.495 26564 TRACE glance

   glance-manage fail to come up with above error. It's like due to
 following commit in oslo wherein we enforce charset=utf8 for all tables.
   7aa94df Add a db check for CHARSET=utf8

   I think we should have a migration script to change the charset for
   all tables.

 To manage notifications about this bug go to:
 https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions



--

*Élève ingénieur de l'E*cole* N*ationale des *S*ciences* d*e l'*I*
nformatique*  (ENSI)*
Stagiaire au *CEA *(*Commissariat à l'énergie atomique et aux énergies
alternatives*).
Membre de L'Institute of Electrical and Electronics Engineers (IEEE)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-17 Thread Thierry Carrez
** Changed in: oslo
Milestone: icehouse-rc1 = 2014.1

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-17 Thread Thierry Carrez
** Changed in: glance
Milestone: icehouse-rc1 = 2014.1

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-04 Thread Thierry Carrez
** Changed in: oslo
   Status: Fix Committed = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-04 Thread Thierry Carrez
** Changed in: oslo
   Status: Fix Committed = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Dolph Mathews
** Also affects: keystone
   Importance: Undecided
   Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Thierry Carrez
** Changed in: glance
   Status: In Progress = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Thierry Carrez
See bug 1301036 for the keystone issue

** No longer affects: keystone

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Dolph Mathews
** Also affects: keystone
   Importance: Undecided
   Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Dolph Mathews
Thiago, that exception looks to be caused by this patch to oslo.db:

  https://github.com/openstack/oslo-incubator/commit/7aa94df

Should there be an exception for migrate_version there? (why do we care
about the charset of that table?) Alternatively, Nova appears to have a
workaround:

if migrate_engine.name == mysql:
# In Folsom we explicitly converted migrate_version to UTF8.
sql = ALTER TABLE migrate_version CONVERT TO CHARACTER SET utf8;
# Set default DB charset to UTF8.
sql += ALTER DATABASE %s DEFAULT CHARACTER SET utf8; % \
migrate_engine.url.database
migrate_engine.execute(sql)

** Changed in: keystone
   Status: New = Incomplete

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Thierry Carrez
** Tags added: icehouse-rc-potential

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Ben Nemec
If the charset of migrate_version doesn't matter (I don't know if that's
true though), then we might just want to exclude it from the check in
the oslo function since we would know that it never matters.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Lars Kellogg-Stedman
Even with https://review.openstack.org/#/c/75356/ merged into glance,
glance master will still fail with the original error if it encounters a
non-utf8 database, because it calls db_sync with without modifying the
default sanity_check=True.  So we either need an option to set
sanity_check=False when upgrading the database, or really the migration
mechanism should take care of converting database tables to utf-8.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Ben Nemec
Lars, see https://review.openstack.org/#/c/75865/  That should allow
migrations to continue for Icehouse without forcing utf8.

Unfortunately there's a lot of potential complexity around converting
tables to utf8 so the Glance team doesn't want to add that this late in
the cycle.  This is a temporary workaround and hopefully we can come up
with a permanent solution in Juno.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Lars Kellogg-Stedman
Ben: Ah, thanks, I missed that.  Is there a similar fix for keystone?
Keystone has the same utf8 check, but does not yet appear to have merged
(or have pending) the changes to make it optional and to expose that to
the -manage command.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Thierry Carrez
** Changed in: glance
   Status: In Progress = Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Ben Nemec
I'm not sure what the status is in Keystone.  I seem to recall that they
had already done a utf8 migration script, but to be safe you should
probably check with them directly.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-04-01 Thread Thierry Carrez
See bug 1301036 for the keystone issue

** No longer affects: keystone

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-29 Thread Thiago Martins
Hello guys,

Just for the record, brand new installation, Ubuntu 14.04, today's
upgrade, keystone version 1:2014.1~rc1-0ubuntu1 and, first time
running keystone-manage db_sync command on an empty keystone
database, it returns:

2014-03-29 03:09:43.521 18564 CRITICAL keystone [-] ValueError: Tables
migrate_version have non utf8 collation, please make sure all tables
are CHARSET=utf8

...maybe it is related to this BUG, I'm not sure... Only one table got
created on keystone db, which is migrate_version, db_sync aborted.

My keystone/mysql server is a KVM Virtual Machine, IPv6-Only setup, name
resolution okay. MySQL bind-listen on ::.

After following post #2 and restarting it from scratch, db_sync worked!

Best!
Thiago

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-25 Thread OpenStack Infra
Reviewed:  https://review.openstack.org/75356
Committed: 
https://git.openstack.org/cgit/openstack/oslo-incubator/commit/?id=f7705f3a7d6acd8319318afc0fd9d1b534285f7d
Submitter: Jenkins
Branch:master

commit f7705f3a7d6acd8319318afc0fd9d1b534285f7d
Author: Zhi Yan Liu zhiy...@cn.ibm.com
Date:   Sat Feb 1 06:24:16 2014 +0800

Make table utf-8 charset checking be optional for DB migration

Add an option to the migration db_sync call to allow a project to
disable the check for utf8 encoding on all tables.  This allows the
project to fix problems automatically via a migration, which
otherwise would not be possible because the utf8 check would stop
them from running migrations.

Change-Id: I7f271d846141ac72dde3fb0d12159b125018eb2c
Closes-bug: #1279000
Signed-off-by: Zhi Yan Liu zhiy...@cn.ibm.com


** Changed in: oslo
   Status: In Progress = Fix Committed

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-21 Thread Ben Nemec
** Changed in: oslo
   Importance: Undecided = High

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-19 Thread OpenStack Infra
** Changed in: oslo
 Assignee: Zhi Yan Liu (lzy-dev) = Ben Nemec (bnemec)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-19 Thread Ben Nemec
** Changed in: oslo
Milestone: None = icehouse-rc1

** Changed in: oslo
 Assignee: Ben Nemec (bnemec) = Zhi Yan Liu (lzy-dev)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-17 Thread James Page
** Also affects: glance (Ubuntu)
   Importance: Undecided
   Status: New

** Also affects: glance (Ubuntu Trusty)
   Importance: Undecided
   Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to glance in Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-17 Thread James Page
** Also affects: glance (Ubuntu)
   Importance: Undecided
   Status: New

** Also affects: glance (Ubuntu Trusty)
   Importance: Undecided
   Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-17 Thread James Page
** Changed in: glance (Ubuntu Trusty)
   Status: New = Triaged

** Changed in: glance (Ubuntu Trusty)
   Importance: Undecided = High

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs


[Bug 1279000] Re: db migrate script to set charset=utf8 for all tables

2014-03-17 Thread James Page
** Changed in: glance (Ubuntu Trusty)
   Importance: High = Medium

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1279000

Title:
  db migrate script to set charset=utf8 for all tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1279000/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs