[mythtv-users] troubles after upgrading mariadb [solved]

Klaus Becker colonius47 at gmail.com
Wed Nov 24 20:01:42 UTC 2021



Am 24/11/2021 um 20:32 schrieb Paul Harrison:
> On 24/11/2021 19:23, Klaus Becker wrote:
> 
>>> I think you are confusing the default port MariaDB/MySQL listens on 
>>> 3306 and the default port the backend listens on 6544?
>>>
>>> There are two different servers involved the DB server and the 
>>> mythbackend server both on different ports both have to configure 
>>> properly for a frontend to connect.
>>>
>>>
>>> Paul H.
>>
>>
>> I tried several times with 6544 for frontend without success.
>>
>> I used 3306 for several years successfully, and even now frontend 
>> tells me that the default port is 3306.
>>
>> I really don't understand. Here my two config-files (I only change the 
>> pwd, but it is the same in both files):
>>
>>
>>
>> $ cat .mythtv/config.xml
>> <Configuration>
>> <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
>>   <Database>
>>     <PingHost>1</PingHost>
>>     <Host>localhost</Host>
>>     <UserName>mythtv</UserName>
>>     <Password>mythtv</Password>
>>     <DatabaseName>mythconverg</DatabaseName>
>>     <Port>6544</Port>
>>   </Database>
>>   <WakeOnLAN>
>>     <Enabled>0</Enabled>
>>     <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>>     <SQLConnectRetry>5</SQLConnectRetry>
>>     <Command>echo 'WOLsqlServerCommand not set'</Command>
>>   </WakeOnLAN>
>>   <UPnP>
>>     <UDN>
>> <MediaRenderer>c310791c-1dfd-4510-9c3e-b007e3093191</MediaRenderer>
>>     </UDN>
>>   </UPnP>
>> </Configuration>
>>
>>
>>
>> # cat /etc/mythtv/config.xml
>> <Configuration>
>>   <Database>
>>     <PingHost>1</PingHost>
>>     <Host>localhost</Host>
>>     <UserName>mythtv</UserName>
>>     <Password>mythtv</Password>
>>     <DatabaseName>mythconverg</DatabaseName>
>>     <Port>6544</Port>
>>   </Database>
>>   <WakeOnLAN>
>>     <Enabled>0</Enabled>
>>     <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>>     <SQLConnectRetry>5</SQLConnectRetry>
>>     <Command>echo 'WOLsqlServerCommand not set'</Command>
>>   </WakeOnLAN>
>> </Configuration>
>>
>> Klaus
>>
> 
> The port in the config.xml is the one the database server is using and 
> will nearly always be 3306. So change that back to 3306. Stop the 
> backend for now and retry what Bill told you to do.


That's what I did and... it works ! Great, thanks a lot.

> 
> I also think you also have an error in your backend configuration where 
> it is also set to listen for connection from frontends on 3306 but that 
> should be 6544.

> 
> 
> Paul H.

I have 3306 in both config.xml-files and in mythtv-setup, but 6544 in 
frontend.

Not easy to understand but it works and I shall remember. I did not find 
that on the wiki.

cheers

Klaus





More information about the mythtv-users mailing list