[mythtv-users] MySql permissions required for Frontend accessing Backend?

[Kevin Kuphal]

alunt2003 at googlemail.com wrote:
> On Thu, Jul 06, 2006 at 03:55:38PM -0500, Kevin Kuphal wrote:
>   
>> alunt2003 at googlemail.com wrote:
>>     
>>> Kevin Kuphal, who happens to be a Linux guru, thinks:
>>>   
>>>       
>>>> alunt2003 at googlemail.com wrote:
>>>>     
>>>>         
>>>>> Hi Guys/Gals.
>>>>>
>>>>> I've had MythTV working for months on a combined Frontend/Backend.
>>>>> I now want another Frontend (on the same lan 192.168.0.x) to connect to the backend.
>>>>> I have entered the following in mysql:
>>>>>
>>>>>  grant all on mythconverg.* to mythtv@"192.168.0.%" identified by "mythtv";
>>>>>  flush privileges;
>>>>>
>>>>> The new Frontend kinda connects,but not fully.
>>>>> I can see in the job queue that i have two programmes waiting,yet i dont
>>>>> get to see any of my recordings.
>>>>>
>>>>> As i go throught the menus it gives me the "Could not connect to the
>>>>> master server--is it running blah..." error, yet i have the same user
>>>>> name and password as the frontend on the backend box.
>>>>>
>>>>> This is what i see in an xterm:
>>>>>
>>>>> 2006-07-06 19:54:36.848 Connecting to backend server:mythbackend.podzone.org:6543 (try 1 of 5)
>>>>> 2006-07-06 19:54:36.848 Connection timed out.You probably should modify the Master Server 
>>>>> settings in the setup program and set the proper IP address.
>>>>>
>>>>> Any Ideas?
>>>>>   
>>>>>       
>>>>>           
>>>> Do you have DNS or your hosts file set properly to find that servers IP 
>>>> from name (mythbackend.podzone.org)? 
>>>>
>>>> Kevin
>>>>     
>>>>         
>>> Yes,I have my hosts setup fine.   192.168.0.7     mythbackend.podzone.org mythbackend
>>>
>>> However i have the ip address in the frontend and not the backends hostname.
>>>   
>>>       
>> Just as an FYI, you don't have a permission problem at this point.  You 
>> have a communications problem between the frontend and backend of some 
>> kind.  I would suggest trying to set everything the same (IP on all 
>> boxes or hostname on all boxes) as I think it is quite sensitive to 
>> this.  Check also any firewalls that might get in the way, etc.
>>
>> Kevin
>>     
>
> I thought it was impossible to assign the sam IP address to all boxes on
> the same lan.
> I don't have firewalls on my boxes,my computers are behind an adsl
> router/modem/firewall.
>   
No, I meant, use either IP addresses everywhere in the config, or always 
use hostnames.  Don't mix setting your backend up identifying itself 
using hostname and then the frontend connecting using IP address.

Kevin