New installation problems on Ubuntu

[benpearson]

Hi,
I am trying to install myth TV for the 1st time and am really struggling, hoping someone can help I should point out at this stage that I am in no way an ubuntu expert! I am running ubuntu 16.04 LTS and have Plex and sonarr installed on the same system.

I have installed using the instructions on the wiki, when I start the backend configuration GUI I select the region and country and then receive a message which says myth cannot connect to the database. It doesn't matter what settings I try in there I cannot get it to connect, I have tried both the randomly generated password in the configuration XML file and I have also changed the password to one of my choice and tried that.

Any help really would be gratefully received as I'm not sure what to try.


**This e-mail has been composed using Dragon Dictate. Apologies for any typos / grammatical errors which have been missed.**

[bill6502]

Hi,

Need to see if mysql is even running and if it is if the credentials are correct.

There's a simple test you can run. Try: mysql -u mythtv -p mythconverg

That gets MythTV out of the picture. The password is the one in config.xml.
Which config.xml file is in use? This should help: https://www.mythtv.org/wiki/Config.xml#Troubleshooting

[benpearson]

hi Bill,

When I run the sql command, this is the output

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 90
Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

is that correct?
when I run diff ~mythtv/.mythtv/config.xml ~/.mythtv/config.xml the output is
1a2
> <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
5c6
< <UserName>mythtv</UserName>
---
> <UserName>myth</UserName>
17d17
<
what should i do?

[bill6502]

Good job. You've proven that mysql is running and login works.

I'd change the UserName in ~/.mythtv/config.xml to mythtv.

Ignore the LocalHostName difference.