The file is used multiple times:
- By the backend to find the MySQL database - otherweise a built-in default is used: [778249a]
- By the frontend to find its backend; otherwise the frontend tries to find a backend using UPnP.
- By other mythProgramsNames to locate the backend e.g. mythshutdown.
Depending on the distribution and or local choices, the file may be found in: /etc/mythtv/config.xml, ~/.mythtv/config.xml or ~mythtv/.mythtv/config.xml etc.
The proper way to get the actual location is to look under $HOME/.mythtv of the user running a MythTV program. Typically, the user that runs the backend is mythtv. Frontends may be run as the login user name. Note that if MYTHCONFDIR is set, it overrides the setting of HOME.
To find which environmental variable is used, and therefore the actual location, users should look at the values of HOME and possibly MYTHCONFDIR of the program being run. This includes any scripts/systemd .system files/Upstart .conf files. If a program is being run from the command line, simply type: echo "HOME=$HOME, MYTHCONFDIR=$MYTHCONFDIR" to see what's set.
Before 0.26, mysql.txt was used. It is no longer required by MythTV. It is possible that some non-compliant 3rd party programs still reference it. MythTV 0.26.
The following template can be found in mythtv/contrib/config_files/config.xml
<Configuration> <UPnP> <UDN> <MediaRenderer>xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx</MediaRenderer> </UDN> </UPnP> <LocalHostName>my-unique-identifier-goes-here</LocalHostName> <Database> <PingHost>1</PingHost> <Host>127.0.0.1</Host> <UserName>mythtv</UserName> <Password>mythtv</Password> <DatabaseName>mythconverg</DatabaseName> <Port>3306</Port> </Database> <WakeOnLAN> <Enabled>0</Enabled> <SQLReconnectWaitTime>0</SQLReconnectWaitTime> <SQLConnectRetry>5</SQLConnectRetry> <Command>echo 'WOLsqlServerCommand not set'</Command> </WakeOnLAN> </Configuration>
- The unique name used to look-up host-specific settings. By default the hostname is used and this shouldn't be changed, but it can be useful to overwrite this when the hostname is changed or multiple frontends with different configurations should run on the same host.
- The UUID used for the MythTV frontend, when used as a UPnP media renderer.
- These settings are deprecated by the settings below mythtv/libs/libmyth/mythcontext.cpp.
All configuration data is stored in a central MySQL database, which must be reachable for all MythTV components.
- 1=MythTV should try to test-ping the host running the database using ICMP echo-request before actually connecting the database process; usually 1.
- The hostname, IPv4 or IPv6 address of the host, where the database is running.
- The name of the account used to authenticate against the database; usually mythtv.
- The password used to authenticate.
- The name of the schema of the database; usually mythconverg.
- The TCP port number, where the database is running on; usually 3306.
If the database is unreachable, MythTV can try to wake up the host using for example Wake-on-LAN.
- 1=MythTV should try to wake up the host. PingHost=1 must be set as well!
- Seconds to wait between reconnection attempts.
- Number of times to retry; usually 5.
- Command to use to wake server; for example sudo etherwake xx:xx:xx:xx:xx:xx.