I am running MythTV on Centos 7.4.1708, a fresh installation. I installed MythTV using the @nux-destop.
I'm able to connect to the MythTV database via the command line. I have one config.xml which is linked to /etc/mythtv/config.xml. I've googled, searched and I find multiple instances of this error, but none of the solutions work. In the past, I've been able to get this to work by beating solution into the keyboard, until it works. I would prefer to come up with a concrete solution. A solution that puts this error to rest, once and for all.
I have done multiple installations of MythTV and I always run into this error. Be it FreeBSD, Slackware, ubuntu, Debian, Fedora and now CentOS.
All I get from the logs is:
Code: Select all
2018-01-15 02:02:55.803185 E [2842/2842] CoreContext mythdbcon.cpp:242 (OpenDatabase) - [DBManager0] Unable to connect to database!
2018-01-15 02:02:55.803251 E [2842/2842] CoreContext mythdbcon.cpp:243 (OpenDatabase) - Driver error was [1/1045]:
QMYSQL: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)
Code: Select all
[jjthomas@anthem ~]$ cat /etc/mythtv/config.xml
<Configuration>
<LocalHostName>my-unique-identifier-goes-here</LocalHostName>
<Database>
<PingHost>1</PingHost>
<Host>anthem.027esc.net</Host>
<UserName>mythtv</UserName>
<Password>AWvsUQbN7a85SjK2</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>
Code: Select all
[root@anthem ~]# find / -name 'config.xml'
/etc/mythtv/config.xml
/home/jjthomas/.mythtv/config.xml
[root@anthem ~]# ls -l /etc/mythtv/config.xml
lrwxrwxrwx. 1 root root 33 Jan 15 01:31 /etc/mythtv/config.xml -> /home/jjthomas/.mythtv/config.xml
Code: Select all
[root@anthem ~]# mysql -u mythtv -pAWvsUQbN7a85SjK2
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.56-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> exit
Bye
Help?
TIA
-JJ