[mythtv-users] How to control database settings from config.xml

[Per Hatlevik]

> ================ mythfrontend output without mysql.txt ================
> 2011-12-22 21:28:45.101 mythfrontend version:  [0.24.1-5.fc16 (e89d6a9f7e)] www.mythtv.org
> 2011-12-22 21:28:45.101 Using runtime prefix = /usr
> 2011-12-22 21:28:45.102 Using configuration directory = /home/göran/.mythtv
> 2011-12-22 21:28:45.103 ThreadPool:HTTP: Initial 1, Max 25, Timeout 60000
> 2011-12-22 21:28:48.360 Unable to read configuration file mysql.txt
> 2011-12-22 21:28:48.360 Empty LocalHostName.
> 2011-12-22 21:28:48.361 Using localhost value of mimmi
> 2011-12-22 21:28:48.390 New DB connection, total: 1
> 2011-12-22 21:28:48.739 Unable to connect to database!
> 2011-12-22 21:28:48.739 Driver error was [1/1045]:
> QMYSQL: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'localhost' (using password: NO)

this seems like a problem to me. shouldn't the mythtv user be using a
password in mysql (default to mythtv)?

also, on some systems mysql may not be setup to listen for external
network connections by default. i think on debian it defaults to
listening on the loop back. check my.cnf (on my system this is
/etc/mysql/my.cnf but your location could be different). you want to
be sure that the bind-address parameter is set to a real ip address.
by default on debian this looks like:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

which would work for a combined BE/FE but would not let remote systems
connect to mysql.

you can always use the mysql client to test database connectivity
outside of myth, get that working and then tackle the myth specific
configuration.

hope that helps.

per hatlevik