Using ~/.my.cnf instead of Database connection string

[arcadius <arcadius@…>]

On FreeBSD, I try to backup enviroment:

# trac-admin path/to/enviroment hotcopy path/to/backup
Hotcopying path/to/enviroment to path/to/backup ...
Backing up database ...
TracError: mysqldump failed: mysqldump: Got error: 1045: Access denied for user 'trac'@'localhost' (using password: YES) when trying to connect

When I remove (rename) ~/.my.cnf which describes some other MySQL user, not 'trac'@'localhost' (who is the only one having access to Trac's database), hotcopying succeeds.

trac-admin should prefer data in Database connection string, not in ~/.my.cnf.

[Jun Omae]

No. Trac Environment, tracd, trac-admin, … shouldn't depend on $HOME/.my.cnf file (Whose home directory? root? apache? someone?). Use read_default_file parameter if you want to use .my.cnf. See DatabaseBackend#MySQL.

However, mysqldump via hotcopy have to work even if ~/.my.cnf is existent or not.

[anonymous]

There's no read_default_file in my project's trac.ini and parameters in [inherit] section are empty.

trac-admin ends with error when:

1. FreeBSD user, who has run it, has .my.cnf in his home directory, and
2. MySQL credential specified there has no access to Trac's database.

[Jun Omae]

read_default_file is in database connection string.