alias_dsn password suffix with # will panic

[ajaxmao]

Traceback (most recent call last):
File "/usr/bin/mycli", line 11, in
sys.exit(cli())
File "/usr/lib/python2.7/site-packages/click/core.py", line 716, in call
return self.main(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/click/core.py", line 696, in main
rv = self.invoke(ctx)
File "/usr/lib/python2.7/site-packages/click/core.py", line 889, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/lib/python2.7/site-packages/click/core.py", line 534, in invoke
return callback(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/mycli/main.py", line 1027, in cli
mycli.connect_uri(database, local_infile, ssl)
File "/usr/lib/python2.7/site-packages/mycli/main.py", line 285, in connect_uri
uri.port, local_infile=local_infile, ssl=ssl)
File "/usr/lib64/python2.7/urlparse.py", line 112, in port
port = int(port, 10)
ValueError: invalid literal for int() with base 10:

[meeuw]

This is certainly a bug but could you try to surround the dsn with quotes? Like:

[alias_dsn]
test = "mysql://user:pa##@host"

?

[ajaxmao]

I try to surround the dsn with quotes, but it's helpless.

I think the '# ‘’ is used for fragments，and the default value of allow_fragments is True.

<scheme>://<netloc>/<path>;<params>?<query>#<fragment>

I try to change function _splitnetloc in urlparse, it's helpful

//urlparse lib

def _splitnetloc(url, start=0):
    delim = len(url)   # position of end of domain part of url, default is end
    location_at = url.find('@')
    for c in '/?#':    # look for delimiters; the order is NOT important
        wdelim = url.find(c, start)        # find first of this delim      
        if wdelim >= 0 and wdelim > location_at:                    # if found
            delim = min(delim, wdelim)     # use earliest delim position   
    return url[start:delim], url[delim:]   # return (domain, rest)

[meeuw]

Hmm I don't think patching system libraries is a good idea... Have you tried replacing '#' with %23 in your password?

Like this:

[alias_dsn]
test = "mysql://user:pa%23%23@host"

[ajaxmao]

Thanks，it‘s a good idea ’to use 23% and Unquote . But may cause another issue to happen if '%23' is just a part of my password. 囧...

[meeuw]

% can be escaped by using %25, so if your password contains %23 that would become %2523.