[mythtvnz] Broken communication from front end

[Worik Stanton]

Still a problem.

I issued the following SQL commands...

use mysql;
DELETE FROM  db WHERE Host LIKE "192.168.1.%" AND DB = "mythconverg" AND
User = "mythtv";
DELETE FROM user WHERE Host LIKE "192.168.1.%" AND User = "mythtv" ;

Still no joy.

Feeling desperate I tried...

sudo dpkg-reconfigure mythtv-database
sudo dpkg-reconfigure mythtv-common

Still no joy.

I missed a question from Tony:

> Would I be right to think that your existing installation is a
> combined BE/FE or do you currently have 1 or more remote FEs running
> successfully. 
I have a back end and a frontend on separate machines



My database seems OK

mysql>     select Host, User from user; 
+-----------+------------------+
| Host      | User             |
+-----------+------------------+
| %         | mythtv           |
| 127.0.0.1 | root             |
| cardamom  | root             |
| localhost | debian-sys-maint |
| localhost | mythtv           |
| localhost | root             |
+-----------+------------------+
6 rows in set (0.00 sec)

mysql> select host, db, user from db;
+-----------+-------------+--------+
| host      | db          | user   |
+-----------+-------------+--------+
| %         | mythconverg | mythtv |
| localhost | mythconverg | mythtv |
+-----------+-------------+--------+
2 rows in set (0.00 sec)

The IP number, the port and the password on the front end are the same
as on the back end.

One thing I should be able to see is the front end attempting to
connect  in the back end.  But I can find nothing in any logs.

cheers
Worik




On 20/09/12 21:47, Tony Sauri wrote:
> On 20/09/12 21:08, Worik Stanton wrote:
>> On 20/09/12 20:59, Tony Sauri wrote:
>>>      select Host, DB, User from db where Db = "mythconverg";
>> mysql> select Host, DB, User from db where Db = "mythconverg";
>> +-------------+-------------+--------+
>> | Host        | DB          | User   |
>> +-------------+-------------+--------+
>> | %           | mythconverg | mythtv |
>> | 192.168.1.% | mythconverg | mythtv |
>> | localhost   | mythconverg | mythtv |
>> +-------------+-------------+--------+
>> 3 rows in set (0.00 sec)
>>
>>
>>
>
>
>
> Ok
>
> If you issue the following SQL statemnts (logged in as root you will
> undo the  effects of your "Grant" statement
>
> use mysql;
>
> DELETE FROM  db WHERE Host LIKE "192.168.1.%" AND DB = "mythconverg"
> AND User = "mythtv";
>
> DELETE FROM user WHERE Host LIKE "192.168.1.%" AND User = "mythtv" ;
>
> Regards
>
>
> TOny Sauri
>
>
>
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>


-- 
it does not matter                      I think that I shall never see
how much I dig and dig                    A billboard lovely as a tree
this hole just                      Indeed, unless the billboards fall
keeps getting deeper                      I'll never see a tree at all