The $ character must be URL encoded if used as a database password

[Ryan J Ollos]

TracEnvironment#DatabaseConnectionStrings lists 3 characters that must be URL encoded when used as a database password. I've found that $ must also be URL encoded (Trac 1.0.10).

I found this by trial and error. It's not clear to me why $ needs to be encoded.

>>> from trac.db.api import _parse_db_str
>>> p = _parse_db_str('mysql://tracuser:the$_$password@localhost:3306/trac')
>>> print(p[1]['password'])
the$_$password

[Jun Omae]

Works for me….

$ ~/venv/trac/1.0.10/bin/trac-admin /dev/shm/trac initenv Project 'mysql://tractestuser:the$_$password@127.0.0.1/tractest'
Creating and Initializing Project
 Installing default wiki pages
  TracNavigation imported from /home/jun66j5/venv/trac/1.0.10/lib/python2.5/site-packages/trac/wiki/default-pages/TracNavigation
...
Congratulations!

$ grep database /dev/shm/trac/conf/trac.ini
database = mysql://tractestuser:the$_$password@127.0.0.1/tractest
$ ~/venv/trac/1.0.10/bin/trac-admin /dev/shm/trac                                                              Welcome to trac-admin 1.0.10
Interactive Trac administration console.
Copyright (C) 2003-2013 Edgewall Software

Type:  '?' or 'help' for help on commands.

Trac [/dev/shm/trac]> ticket_type list

Possible Values
---------------
defect
enhancement
task

Trac [/dev/shm/trac]>

[Ryan J Ollos]

Yeah, it's very strange behavior to see on this server. The server on which I did the SQLite to MySQL migration currently has an encoded value for $ in the database connection string password: %24. It's the only way I could get Trac to connect to the database. When connecting with the MySQL client I use $ in the password.

I will try to reproduce locally.

This is CentOS 6:

$ mysql --version
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

[Ryan J Ollos]

Here is some more information about this server, in case this comes up again:

• MySQL: server: "5.1.73-log", client: "5.1.73", thread-safe: 1
• MySQLdb: 1.2.3c1
• Python: 2.6.6