[Sqlalchemy-tickets] [sqlalchemy] #2851: Sqlalchemy does not work in ipv6 environment

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

#2851: Sqlalchemy does not work in ipv6 environment
------------------------+-------------------------------------------
 Reporter:  huwei       |           Owner:
     Type:  defect      |          Status:  new
 Priority:  high        |       Milestone:  0.7.xx
Component:  mysql       |        Severity:  refactor - over two days
 Keywords:  ipv6 mysql  |  Progress State:  awaiting triage
------------------------+-------------------------------------------
 Environment:
   python 2.6
   sqlalchemy 0.7.9
   redhat 6.4
   mysql 5.5.34

 In openstack grizzly version, I configured the mysql connection url from
 ipv4 to ipv6
 address(connection=mysql://keystone:keystone@[2001:da8:2004:1000:202:116:160:90]/keystone?charset=utf).
 And restart openstack service, but when I use keystone cli to list users.
 I got an error message "Authorization Failed: KS-117430E An unexpected
 error prevented the server from fulfilling your request. invalid literal
 for int() with base 10: 'da8:2004:1000:202:116:160:90]' (HTTP 500)".
 And the following is the error log information.

 2013-10-21 08:14:57.429 25606 ERROR keystone.common.wsgi [-] invalid
 literal for int() with base 10: 'da8:2004:1000:202:116:160:90]'
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi Traceback (most
 recent call last):
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/common/wsgi.py", line 238, in
 __call__
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     result =
 method(context, **params)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/token/controllers.py", line 94,
 in authenticate
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     context,
 auth)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/token/controllers.py", line
 257, in _authenticate_local
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     username,
 DEFAULT_DOMAIN_ID)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/identity/core.py", line 177, in
 wrapper
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 f(self, *args, **kwargs)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/identity/core.py", line 337, in
 get_user_by_name
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     driver =
 self._select_identity_driver(domain_id)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/identity/core.py", line 280, in
 _select_identity_driver
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi
 self.get_domain(domain_id)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/identity/core.py", line 538, in
 get_domain
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 self.assignment_api.get_domain(domain_id)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/cache/region.py", line 936, in
 decorate
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi
 should_cache_fn)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/cache/region.py", line 588, in
 get_or_create
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi
 async_creator) as value:
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/core/dogpile.py", line 158, in
 __enter__
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 self._enter()
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/core/dogpile.py", line 98, in
 _enter
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     generated =
 self._enter_create(createdtime)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/core/dogpile.py", line 149, in
 _enter_create
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     created =
 self.creator()
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/cache/region.py", line 565, in
 gen_value
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     created_value
 = creator()
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/dogpile/cache/region.py", line 932, in
 creator
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 fn(*arg, **kw)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/assignment/core.py", line 262,
 in get_domain
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 self.driver.get_domain(domain_id)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/assignment/backends/sql.py",
 line 525, in get_domain
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     session =
 self.get_session()
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/common/sql/core.py", line 236,
 in get_session
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     self._engine
 = self.get_engine()
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/common/sql/core.py", line 278,
 in get_engine
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     engine =
 new_engine()
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib/python2.6/site-packages/keystone/common/sql/core.py", line 251,
 in new_engine
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi
 connection_dict = sql.engine.url.make_url(CONF.sql.connection)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/url.py", line 178,
 in make_url
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 _parse_rfc1738_args(name_or_url)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/url.py", line 216,
 in _parse_rfc1738_args
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     return
 URL(name, **components)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi   File
 "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/url.py", line 56, in
 __init__
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi     self.port =
 int(port)
 2013-10-21 08:14:57.429 25606 TRACE keystone.common.wsgi ValueError:
 invalid literal for int() with base 10: 'da8:2004:1000:202:116:160:90]'

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2851>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python