sqlalchemy could not parse sql_connection urls containning ipv6 address

[Wang Bo]

Version of Nova: Grizzly.

I tried to configure openstack in pure IPv6 enviroment.

 Edit nova.conf file in controller node.
 Set the sql_connection = msyql://nova:nova@[2001:db8::22]/nova?charset=utf8 ( [2001:db8::22] is ipv6 address of controller node)

When started the service nova-conductor (or any other project connected to database), It reported ERROR.
In File: /usr/lib64/python2.6/site-packages/sqlalchemy/engine/url.py
  Function : def _parse_rfc1738_args(name):
                           pattern = re.compile(r'''
                              (?P<name>[\w\+]+)://
                              (?:
                              (?P<username>[^:/]*)
                              (?::(?P<password>[^/]*))?
                              @)?
                              (?:
                              (?P<host>[^/:]*)
                              (?::(?P<port>[^/]*))?
                              )?
                              (?:/(?P<database>.*))?
                              '''
                              , re.X)

                          m = pattern.match(name)
                               if m is not None:
                                    components = m.groupdict()

Add breakpoint in above code and debug to get the components. Result of components is following:
{ 'username': 'nova', 'name': 'mysql', 'database':'nova?charset=utf8', 'host': '[2001', 'password':'nova', 'port' : 'db8::22]' }

Obviously, the current code could not parse sql_connection urls that contain ipv6 address correctly.

[Matt Riedemann (mriedem)]

Which version of sqlalchemy do you have installed?

This might be unrelated, but I see you're running on python 2.6 and wanted to point out that the built in url parsing support for IPv6 didn't show up until python 2.7:

http://docs.python.org/2.7/library/urlparse.html

[Wang Bo (chestack)]

Reply to #1, Thanks for your comments.

Version of installed sqlalchemy : 0.7.9.

I know that urlparse.py added ipv6 url parsing capabilities in python 2.7. But this bug is about sqlalchemy. OpenStack use url.py (sqlalchemy/engine/url.py) but not urlparse.py to connect DB. The following is home page of sqlalchemy: http://www.sqlalchemy.org/

The lastest version is 0.8 which still do not support ipv6.

[David Ripton (dripton)]

This is a real bug, but unfortunately it's in SQLAlchemy, so OpenStack can't fix it directly without dumping SQLAlchemy, which would be a drastic change. Please report the bug to SQLAlchemy, though, so they are aware that there are people who'd like them to support IPv6 addresses in their connection URLs.

As a workaround, you can give the box 2001:db8::22 a DNS entry or hosts file entry and refer to it by hostname rather than IPv6 address.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/53218

[Wei Hu (huwei-xtu)]

Sqlalchemy has fixed the bug. And I have tried it, it does work.
http://www.sqlalchemy.org/trac/ticket/2851#comment:4

[Davanum Srinivas (DIMS) (dims-v)]

Fixed upstream