[mythtvnz] New Backend / Existing Frontends

[Stephen Worthington]

On Thu, 11 Feb 2010 12:36:02 +1300, you wrote:

>Replying to all posters, (thank you)
>
>I replaced the FE/BE box HDD with a new 1.5TB, so only thing new is the HDD and software.  Rest is known working hardware.
>
>Running MCC from a FE shows the mySQL connection is failing to connect.
>
>Running
>sudo dpkg-reconfigure mythtv-database
>sudo dpkg-reconfigure mythtv-common   (Replaced localhost with FE/BE IP)did not help.I'd earlier overwritten localhost in the 
>General setup and that IP remained correct.running this gives:~$ sudo iptables -L[sudo] password for user:Chain INPUT (policy 
>ACCEPT)target     prot opt source               destinationChain FORWARD (policy ACCEPT)target     prot opt source 
>destinationChain OUTPUT (policy ACCEPT)target     prot opt source               destinationI presume this means its running in a 
>default config, I've never changed the mythbuntu settings for this and there is remote access to the machine, e.g. mythweb ssh and 
>VNC.
>
>I've decided to just run the install up again as I think what I might have done worng was not check the allow other users to connect 
>box when it asked me during the faulty install and it seems hard to fix that now.  I think the fix might lie in the MySQL however 
>that's not a good place for me to muck around.

The correct MySQL password should be in /etc/mythtv/mysql.txt.

I use this very useful little script to login to MySQL to do manual
queries:

#!/bin/bash

# Run MySQL to access the mythconfig database.

source /etc/mythtv/mysql.txt
mysql -u $DBUserName -p$DBPassword -h $DBHostName $DBName

If that works, then the mysql.txt file has the correct password and
you should try entering that into the frontend setup.

>I do find the users a little confusing, as it seems, by default, there are two users, "mythtv" and your nominated logon say 
>"mylogon".   Remote FE seem to want to connect as mythtv however it seems one run the FE/BE as "mylogon"  It seems using 
>tv_grab_nz-py that one needs to configure both /home/mythtv/.mythtv and also /home/mylogon/.mythtv to get universal access.   Can 
>anyone clarify this further?  Would using "mythtv" as the logon be better?  Perhaps there are good reasons not to do this?

I linked /home/mythtv/.mythtv to /home/mylogon/.mythtv to solve those
sorts of problems.  I think I had to move/edit a couple of things from
/home/mythtv/.mythtv across into the files in /home/mylogon/.mythtv.
But it is working well now, and I can run mythfilldatabase manually
and it works.  I tried setting up things to use the mythtv login, but
could not figure out how to do it.  The mythtv login is only partially
configured.  It does not appear in the GUI to be selected, and I could
not figure out how to make it appear.