[mythtv-users] Connect to MySQL failed

[Mike Carron]

On 4/2/2014 5:56 AM, C.I. wrote:
> On 14-04-01 10:43 PM, Mike Carron wrote:
>>
>> On 4/1/2014 8:48 PM, C.I. wrote:
>>> On 14-04-01 06:54 PM, Mike Carron wrote:
>>>>
>>>> On 4/1/2014 6:09 PM, C.I. wrote:
>>>>> On 14-03-31 10:55 PM, Mike Carron wrote:
>>>>>>
>>>>>> On 3/31/2014 8:43 PM, C.I. wrote:
>>>>>>> Hello everybody,
>>>>>>>
>>>>>>> I'm using OpenElec 3.2.4 on a Zotac ID83 and so far it's working 
>>>>>>> great. I'm so happy with it.
>>>>>>>
>>>>>>> Lately, I've connected a Hauppauge WinTV-HVR-950Q USB Tuner to 
>>>>>>> try to watch some over-the-air channels, channels that I can 
>>>>>>> receive with my TV. I've tried so many settings for MythTV and 
>>>>>>> MythTV cmyth PVR Client but for some reason I'm getting the same 
>>>>>>> message all the time: "Connect to MySQL failed: 2003: Can't 
>>>>>>> connect to MySQL server". I'm out of ideas, I tried to find some 
>>>>>>> solutions on Google but... no success. That's why I'm asking 
>>>>>>> this community to help me.
>>>>>>>
>>>>>>> I'm using Ubuntu on my laptop so I'm kind of familiar with 
>>>>>>> terminal and I can connect to my OpenElec box (Zotac) using SSH. 
>>>>>>> I just don't know what to check or how to troubleshoot.
>>>>>>>
>>>>>>> Would you, guys, help me? PLEASE...!
>>>>>>>
>>>>>>> Thank you in advance.
>>>>>>>
>>>>>>> icntf
>>>>>>>
>>>>>> ***
>>>>>> First go to Setup on your Mythbackend and confirm your database 
>>>>>> IP address and password (1st page). The IP address should be the 
>>>>>> same as the physical IP address of your backend on your network. 
>>>>>> If it is something else, change it. Then make sure that your 
>>>>>> OpenELEC is using those IP and password values to connect. Once 
>>>>>> you are sure your Open ELEC is looking in the right place you 
>>>>>> should be ok.
>>>>>>
>>>>>> Incidentally, it wouldn't hurt to assign a static IP address to 
>>>>>> your MythTV backend
>>>>>>
>>>>>> mike
>>>>>> _______________________________________________
>>>>>
>>>>> Hello again,
>>>>>
>>>>> I tried what you told me many times, even before your email, but 
>>>>> it doesn't work. I'm getting the same message. Do you have any 
>>>>> other suggestions?
>>>>>
>>>>> Thank you.
>>>>>
>>>>> P.S. Would you tell me please where, in OpenElec, I can find the 
>>>>> MythTV folder?
>>>>>
>>>>> Thanks again.
>>>>> _______________________________________________
>>>> ***
>>>> I'm not sure what you mean by MythTV folder in OpenELEC.
>>>>
>>>> mike
>>>> ______________________________________________
>>> When I'm connecting through SSH, where are the MythTV files located?
>>>
>>> Thanks.
>>> _______________________________________________
>> ***
>> As best as I understand, OpenELEC does nothing with MythTV files. It 
>> communicates with the Mythbackend, which actually deals with the 
>> database and the various recording files. Where those various files 
>> might be is established by your decisions when you establish your 
>> storage groups in the Mythbackend Setup.
>>
>> If you mean different files you will need to be more precise in 
>> describing exactly what files you are interested in.
>>
>> mike
>> _______________________________________________
>
> I'm trying to understand what is going on with MythTV and how to get 
> rid of that message. I can't make it work even if the settings are OK. 
> I'm stuck with that message and I don't want to give up yet.
>
> :(
> _______________________________________________
>
***
Having read one of your replies to Phil I'm guessing that we have a 
major disconnect in this dialog.

If you are using the Cmyth add-on in OpenELEC then you must also have a 
MythTV backend installed and running on a different machine from the one 
OpenELEC is on. If you have a MythTV backend running on a different 
machine then the Config page of your Cmyth add-on needs to have the 
correct details for that backend machine. Two of the entries on that 
page are unique, the IP address of the machine running the MythTV 
backend and the password for the database on that machine.

mike