Cannot get into setup of Mythfrontend [SOLVED]

[jcfaber1]

When I try to get into setup upon launching the front end it asks for a password. The wiki shows mythtv to be the password but it does not work. Any suggestions?
Thanks
John

[daraden]

check the password in /etc/mythtv/config.xml on the backend

[jcfaber1]

Thanks. so I went there and:
john@john-Precision-WorkStation-T7400:~$ cat /etc/mythtv/config.xml
<Configuration>
<Database>
<PingHost>1</PingHost>
<Host>localhost</Host>
<UserName>mythtv</UserName>
<Password>te7p5YJc</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>

I went into the front end and entered the above password and I still did not get in. Any other ideas?
Thanks
John

[daraden]

try logging in to mysql with

Code: Select all

mysql -u mythtv mythconverg -p

[bill6502]

Hi,

Also, see: https://www.mythtv.org/wiki/Config.xml#Troubleshooting . Especially
the "A note for newcomers" section and info about broken links.

[jcfaber1]

Thank you both for your suggestions. For the first suggestion:
john@john-Precision-WorkStation-T7400:~$ mysql -u mythtv mythconverg -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
john@john-Precision-WorkStation-T7400:~$ mysql -u mythtv mythconverg -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
john@john-Precision-WorkStation-T7400:~$ mysql -u mythtv mythconverg -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)

I entered mythtv,root,YES and Sundowner2 passwords. Sundowner2 is the pwd for user John. None of these work.

In the second part, I ran the following:
john@john-Precision-WorkStation-T7400:~$ diff ~mythtv/.mythtv/config.xml ~/.mythtv/config.xml
1a2
> <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
5,6c6,7
< <UserName>mythtv</UserName>
< <Password>te7p5YJc</Password>
---
> <UserName>root</UserName>
> <Password>root</Password>
11c12
< <Enabled>0</Enabled>
---
> <Enabled>1</Enabled>
15a17,21
> <UPnP>
> <UDN>
> <MediaRenderer>6c77f1c5-3008-493f-ae99-8cebd54ba867</MediaRenderer>
> </UDN>
> </UPnP>
17d22
I went too MySql Workbench and entered the "te7p5YJc" and got in! Now I am not sure how I am to change this and where else to look. I think the root/root is in the backend setup screen as I could never move beyond with mythtv/mythtv. I do not understand what the rest of the output means.

Thanks!

John

[jcfaber1]

To add to my comment above, when I am in MySQL Workbench >Management> Users and Privileges on the right it says that I do not have sufficient privlidges. Perhaps this needs to be a command line change?

Thanks
John

[daraden]

I've never used MySQL workbench, so the only help i can offer with that is the password "te7p5YJc" should be for the mythtv user which shouldn't have admin privileges. During MySQL setup it should have asked you to set a root password. this should be the password you need.
as per your other post you likely need -p so you can enter the password

Code: Select all

mysql root mysql -p

the ~mythtv/.mythtv/config.xml shhould refer to /home/mythtv/.mythtv/config.xml. which is used by the mythtv user

the ~/.mythtv/config.xml should refer to /home/john/.mythtv/config.xml. which is used by john. this is the one you are using when you try to run the frontend.
try editing john's to match the mythtv users config

[jcfaber1]

Hi, daraden, thanks for your response. I went to: /home/mysql and there are no files or directory when executing ls -l from that directory. The same is true for /home/john/ there is no mythtv directory. I wend through all /home/john/ directories and did not find a config file. I am not sure what challenges this presents.

In addition, I was able to change the mythtv user password for mysql to mythtv. When I ran the install for mythtv-backend-master I did give mysql root user 'root' pwd. When I ran the backend setup, I had to use root/root in order to move forward in the install process - most likely because of the te7p5YJc mythtv user password. Now I do not know how to go back in to change it to mythtv/mythtv as it goes past that part.

Thanks for your cooperation. BTW I have been using NextPVR for a couple years, while it works well I am wanting to get away from Windows 10 update misery.

John

[bill6502]

Just a few comments...

You probably meant to type /home/mythtv/.mythtv, rather than /home/mysql
the latter doesn't normally exist (or need to.)

To see hidden directories (and files), use ls -la, ls -l won't list them.

The cat of /etc/mythtv/config.xml looks normal (<UserName>mythtv</UserName>
<Password>te7p5YJc</Password>.)

Based on the Password, you're running Mythbuntu or Ubuntu.

The *buntu's usually link the mythtv and you own user's .mythtv/config.xml
to the one you found in /etc/mythtv. As the Wiki I posted earlier mentions, those
links (like Windows shortcuts) can get broken. The diff you did earlier
confirms that because if the links were both pointing to the /etc/mythtv
file, there would be no differences.

If the backend is running, then just copy the mythtv version to your own users,
like this:

Code: Select all

cp ~mythtv/.mythtv/config.xml ~/.mythtv

Or you can read up on using the link command (ln -s) to restore the 'normal'
*buntu configuration. Personally, I have to copies of the config.xml. Either way
is OK.

The backend is normally (almost always) started as user mythtv and therefore
user config.xml from ~mythtv/.mythtv. Using user/password root/root is for
administrative use.

[jcfaber1]

Ok , thanks on the ls -la. I would go crazy. I copied the file /home/mythtv/.mythtv/.config.xml to /home/john/mythtv/.mythtv.config.xml and they are now the same. When I go into the front end and click on setup it prompts me for a password. mythtv password does not work, I can never get into setup.

I understand that the root user should have been for admin. I am not sure how to change it in the backend setup as it goes past that part.

I am using Xubuntu as a new install. All new to me. I had a little experience with AIX decades ago.
In some ways it seems like a new install would (short of OS) be a good idea ?

Thanks.
John

[bill6502]

It could be that I'm not understanding the problem correctly
(and I don't use Mythbuntu, so can't duplicate the "click on
setup" you mention.) I was assuming the answer to the password
prompt would have been: te7p5YJc

Let's see if you've got a setup pin in place, please do this:

Code: Select all

wget -O- yourBackendHostnameOrIpAddress:6544/Myth/GetSetting?Key=SetupPinCode

I'm looking for a line similar to this:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?><String>1234</String>

If the string has a value, like 1234 above, then that's the setup password.

Just to be clear, ~ is the same as /home/yourUserName and
~anyUserName is shorthand for /home/anyUserName. Just
saves you from typing a few keystrokes.

[jcfaber1]

Sorry for the delay as I signed out for the night. From the command line, I entered mythtv-setup which brought me into the GUI back end setup. I was not able to see where I can grab the logs to attach. I went to item 8 system events but did not see any log files. I am sorry to seem so dense but this is all new.

BTW I my plan is to use Kodi as the front end on different machines with the Mythtv plugin. I was wanting to setup the front end to edit the channels and the guide as the guide is pulling every possible Comcast channel even though I have very few available to me.

In the meantime I will read up on how to attach logs.

Thanks.

John

[bill6502]

I updated my previous answer because it was off base, but it does tell
me that the backend is running OK. Try the above wget command.

[jcfaber1]

Hi, bill
I hope this is what you were requesting:

ohn@john-Precision-WorkStation-T7400:~$ wget -O- 192.168.1.99:6544/Myth/GetSetting?Key=SetupPinCode1
--2017-01-06 12:13:38-- http://192.168.1.99:6544/Myth/GetSettin ... upPinCode1
Connecting to 192.168.1.99:6544... failed: Connection refused.