something is eating the brackets before it gets to SQLAlchemy:
>>> from sqlalchemy.engine import url
# with brackets, happy
>>> url.make_url("mysql+pymysql://nova_api:LP1VoffTn36gPLU8tz67YYEV8@[fd12:3456:789a:1::3]/nova_api?read_default_group=tripleo&read_default_file=/etc/my.cnf.d/tripleo.cnf")
mysql+pymysql://nova_api:***@[fd12:3456:789a:1::3]/nova_api?read_default_file=/etc/my.cnf.d/tripleo.cnf&read_default_group=tripleo
# take the two brackets out, identical error
>>> url.make_url("mysql+pymysql://nova_api:LP1VoffTn36gPLU8tz67YYEV8@fd12:3456:789a:1::3/nova_api?read_default_group=tripleo&read_default_file=/etc/my.cnf.d/tripleo.cnf")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/url.py", line 229, in make_url
return _parse_rfc1738_args(name_or_url)
File "/home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/url.py", line 288, in _parse_rfc1738_args
return URL(name, **components)
File "/home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/url.py", line 71, in __init__
self.port = int(port)
ValueError: invalid literal for int() with base 10: '3456:789a:1::3'
something is eating the brackets before it gets to SQLAlchemy:
>>> from sqlalchemy.engine import url
# with brackets, happy url("mysql+ pymysql: //nova_ api:LP1VoffTn36 gPLU8tz67YYEV8@ [fd12:3456: 789a:1: :3]/nova_ api?read_ default_ group=tripleo& read_default_ file=/etc/ my.cnf. d/tripleo. cnf") //nova_ api:*** @[fd12: 3456:789a: 1::3]/nova_ api?read_ default_ file=/etc/ my.cnf. d/tripleo. cnf&read_ default_ group=tripleo
>>> url.make_
mysql+pymysql:
# take the two brackets out, identical error
>>> url.make_ url("mysql+ pymysql: //nova_ api:LP1VoffTn36 gPLU8tz67YYEV8@ fd12:3456: 789a:1: :3/nova_ api?read_ default_ group=tripleo& read_default_ file=/etc/ my.cnf. d/tripleo. cnf") classic/ dev/sqlalchemy/ lib/sqlalchemy/ engine/ url.py" , line 229, in make_url rfc1738_ args(name_ or_url) classic/ dev/sqlalchemy/ lib/sqlalchemy/ engine/ url.py" , line 288, in _parse_rfc1738_args classic/ dev/sqlalchemy/ lib/sqlalchemy/ engine/ url.py" , line 71, in __init__
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/home/
return _parse_
File "/home/
return URL(name, **components)
File "/home/
self.port = int(port)
ValueError: invalid literal for int() with base 10: '3456:789a:1::3'