[mythtv-users] troubles after upgrading mariadb
Klaus Becker
colonius47 at gmail.com
Tue Nov 23 17:36:43 UTC 2021
Am 19/11/2021 um 02:40 schrieb stinga:
> On 19/11/2021 04:48, Klaus Becker wrote:
>> Am 18/11/2021 um 21:26 schrieb Klaus Becker:
>>> Hi,
>>>
>>> I use Debian unstable, frontend worked fine for a long time. I only
>>> watch german tv.
>>>
>>> But recently mariadb changed from 10.5 to 10.6 and I lost my database
>>> "mythconverg". I got a message that told me that the db cannot be
>>> upgraded automatically and that I have to restore it manually. Un
>>> fortunately I did not pay attention.
>>>
>>> Finally I deleted the new db created by mariadb and created an empty
>>> db with the same name "mythconverg".
>>>
>>> I backuped my db in september, but since this time, I did not use
>>> MythTV very often and the db probably did not change very much since
>>> that time. I watched and then deleted some recordings, but I have no
>>> new recordings since a long time.
>>>
>>> So I restored my db with
>>> # qmysql -u mythtv -p mythconverg < /home/klaus/mythconverg.sql.
>>>
>>
>> Finally I did a channel scan successfully, but it did not change
>> anything.
>
Hi again,
I struggled a lot to resolve the problem.
I have a backup of Debian unstable from september. I installed it again
on another partition (sda7), and there frontend works. So the DB is ok.
I imported the DB as described in the wiki to my actual system (sda1),
and there I have the above problems. I verified the DB with mysqlcheck,
it is ok.
Then I returned to sda7, I put MythTV and MariaDB on hold and then I
performed "apt -dist-upgrade" successfully. I observed that Mysql was
not upgraded. Afterwards I had again the above problems!
So my problems seem not to come from MythTV or DB, but from Debian unstable.
I might be a port-problem, I explain:
https://www.mythtv.org/wiki/Setup_General says that for v29, the
serverport is 6543. I spent some time to make it work on sda, without
success, no connection to the server which is running, I verified with
systemctl.
"Nmap localhost" says "3306/tcp open mysql". So the right port should
be 3306. I used this port since I use MythTV (several years) and it
still works on sda1, but still with the above problems. Mythtv-setup
also says that 3306 is the default port.
While launching frontend by commandline, I see among others:
2021-11-23 17:43:31.293788 I Listening on TCP 0.0.0.0:6547
2021-11-23 17:43:31.294481 I Listening on TCP [::]:6547
2021-11-23 17:43:35.734683 I Service registration complete: name
'Mythfrontend on 1stein' type '_mythfrontend._tcp.' domain: 'local.'
2021-11-23 17:43:53.271600 I De-registering service
'_mythfrontend._tcp.' on 'Mythfrontend on 1stein'
2021-11-23 17:43:34.551430 I MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:3306 (try 1 of 1)
2021-11-23 17:43:34.594742 I MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:3306 (try 1 of 1)
2021-11-23 17:43:34.598809 I MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:3306 (try 1 of 1)
and so on, very often
Isn't there confusion between port 3306 and 6547 ?
sincerely
Klaus
More information about the mythtv-users
mailing list