[mythtvnz] Broken communication from front end

[Tony Sauri]

On 20/09/12 19:12, Worik Stanton wrote:
> My frontend is no longer talking to my back end.  It starts up in setup
> mode asking for country and language
>
> The only change I made was I issued the SQL ommand 'grant all on
> mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";'  as user
> root on the backend.
>
> The front end can ping the back end so it is not a broken network.
>
> How do I recover?
>
> Exploring the set up on the back end I see that I have automatic backups
> for SQL database configured. Will that be useful?

Are those backups of the mythconverg tables only?  If so will be 
unlikely to be of much use as your command impacts various tables of the 
mysql database.

>
> I was trying to get my Raspberry PI XBMC front end going.  I was going
> to make the subject line "I am an idiot" but I thought that would be too
> obscure.  Accurate though!
>
> cheers
> Worik
>


Need a bit more info.

a) You stated your authentication password was "mythtv".
	Is this a sanitized value?
	Is the actual passwod you used the same as the
	password in   	/home/mythtv/.mythtv/mysql.txt  ?

b) What is the IP of your backend?

c)  Login to MYSQL on Backend as root

	Then issue these SQL commands

	use mysql;

	select Host, User from user;

Then post results here.


Tony