Cannot get into setup of Mythfrontend [SOLVED]

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

jcfaber1
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Cannot get into setup of Mythfrontend [SOLVED]

Post by jcfaber1 » Mon Jan 02, 2017 10:44 pm

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
Senior
Posts: 169
Joined: Tue Feb 23, 2016 7:33 am
United States of America

Re: Cannot get into setup of Mythfrontend

Post by daraden » Tue Jan 03, 2017 12:07 am

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

jcfaber1
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Tue Jan 03, 2017 1:06 am

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
Senior
Posts: 169
Joined: Tue Feb 23, 2016 7:33 am
United States of America

Re: Cannot get into setup of Mythfrontend

Post by daraden » Tue Jan 03, 2017 1:40 am

try logging in to mysql with

Code: Select all

mysql -u mythtv mythconverg -p

User avatar
bill6502
Developer
Posts: 1369
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by bill6502 » Tue Jan 03, 2017 3:21 am

Hi,

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

jcfaber1
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Wed Jan 04, 2017 1:39 am

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
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Wed Jan 04, 2017 1:46 am

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
Senior
Posts: 169
Joined: Tue Feb 23, 2016 7:33 am
United States of America

Re: Cannot get into setup of Mythfrontend

Post by daraden » Thu Jan 05, 2017 7:57 pm

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
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Fri Jan 06, 2017 1:43 am

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

User avatar
bill6502
Developer
Posts: 1369
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by bill6502 » Fri Jan 06, 2017 2:41 am

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
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Fri Jan 06, 2017 3:14 am

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

User avatar
bill6502
Developer
Posts: 1369
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by bill6502 » Fri Jan 06, 2017 3:34 am

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
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Fri Jan 06, 2017 1:35 pm

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

User avatar
bill6502
Developer
Posts: 1369
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by bill6502 » Fri Jan 06, 2017 4:48 pm

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
Junior
Posts: 27
Joined: Mon Jan 02, 2017 8:23 pm
United States of America

Re: Cannot get into setup of Mythfrontend

Post by jcfaber1 » Fri Jan 06, 2017 6:14 pm

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.

Post Reply