[mythtv-users] .29 won't connect to backend
Jack McGee
jack at greendesk.net
Tue Oct 16 16:57:05 UTC 2018
On 10/16/2018 07:32 AM, Stephen Worthington wrote:
> On Tue, 16 Oct 2018 06:32:33 -0500, you wrote:
>
>> On 10/15/2018 09:25 PM, Stephen Worthington wrote:
>>> On Mon, 15 Oct 2018 20:01:15 -0500, you wrote:
>>>
>>>> On 10/15/2018 07:10 PM, Mark Perkins wrote:
>>>>>
>>>>>
>>>>> On 16 October 2018 10:33:46 am Jack McGee <jack at greendesk.net> wrote:
>>>>>
>>>>>> On 10/15/2018 02:04 PM, Jack McGee wrote:
>>>>>>> I upgraded a 16.04 frontend and 16.04 backend from .28 to .29.
>>
>>>
>>> It is not connecting to the database. Are you running MariaDB or
>>> MySQL? Is mysqld running? What do these commands show:
>>>
>>> sudo netstat -alnp | grep 3306
>>> sudo ps -ef | grep mysql
>>> sudo systemctl status mysql
>>
>> mythuser at amethi:/var/log/mythtv$ sudo netstat -alnp | grep 3306
>> [sudo] password for mythuser:
>> tcp 0 0 192.168.1.105:3306 0.0.0.0:*
>> LISTEN 1189/mysqld
>
> This looks like it may be the problem. MySQL is only listening on one
> IP address, 192.168.1.105, which I presume is the IP address of the
> Ethernet card. So trying to connect on localhost is not going to
> work. You either need to change the "localhost" in all your
> config.xml files to "192.168.1.105", or you need to change the
> "bind-address=" settings in your MySQL config. The latter is the
> better option, unless this PC has multiple Ethernet cards. So go to
> /etc/mysql and do this command:
>
The machine has multiple ethernet ports.
Only one is connected.
mythuser at amethi:/var/log/mythtv$ lspci | grep -i eth
00:19.0 Ethernet controller: Intel Corporation Ethernet Connection
I217-V (rev 05)
So I changed config.xml on the backend:
> mythuser at amethi:/home/mythtv/.mythtv$ cat config.xml
> <Configuration>
> <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
> <Database>
> <PingHost>1</PingHost>
> <Host>192.168.1.105</Host>
> <UserName>mythtv</UserName>
> <Password>mythtv</Password>
> <DatabaseName>mythconverg</DatabaseName>
> <Port>3306</Port>
> </Database>
> <WakeOnLAN>
> <Enabled>0</Enabled>
> <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
> <SQLConnectRetry>5</SQLConnectRetry>
> <Command>echo 'WOLsqlServerCommand not set'</Command>
> </WakeOnLAN>
> </Configuration>
restarted backend:
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: N thread_unknown mythdirs.cpp:195 (InitializeMythDirs) Using runtime prefix = /usr
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: N thread_unknown mythdirs.cpp:197 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext mythcorecontext.cpp:271 (Init) Assumed character encoding: en_US.UTF-8
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: N CoreContext mythcontext.cpp:599 (LoadDatabaseSettings) Empty LocalHostName.
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext mythcontext.cpp:607 (LoadDatabaseSettings) Using localhost value of amethi
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB 192.168.1.105, BE , attempt 0, status dbAwake
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I LogForward loggingserver.cpp:302 (SyslogLogger) Added syslogging
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: N CoreContext mythcorecontext.cpp:1768 (InitLocale) Setting QT default locale to EN_US
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext mythcorecontext.cpp:1801 (SaveLocaleDefaults) Current locale EN_US
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: N CoreContext mythlocale.cpp:123 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext mythtranslation.cpp:73 (load) Loading en_us translation for module mythfrontend
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext schemawizard.cpp:120 (Compare) Current MythTV Schema Version (DBSchemaVer): 1348
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: I CoreContext mythtranslation.cpp:73 (load) Loading en_us translation for module mythfrontend
> Oct 16 11:21:09 amethi mythbackend: mythbackend[1599]: N CoreContext main_helpers.cpp:597 (run_backend) MythBackend: Starting up as the master server.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext programinfo.cpp:2382 (CheckProgramIDAuthorities) Found 1 distinct programid authorities
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'LogClean'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'DBCleanup'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'ThemeUpdateNotifications'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'RecordedArtworkUpdate'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I Scheduler mythdbcon.cpp:462 (getStaticCon) New static DB connectionSchedCon
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'MythFillDB'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'UpdateRadioStreams'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'JobQueueRecover'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:633 (RegisterTask) Registering HouseKeeperTask 'HardwareProfiler'.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext housekeeper.cpp:706 (Start) Starting HouseKeeper.
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext serverpool.cpp:422 (listen) Listening on TCP 0.0.0.0:6544
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext serverpool.cpp:422 (listen) Listening on TCP [::]:6544
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext serverpool.cpp:422 (listen) Listening on TCP 0.0.0.0:6554
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext serverpool.cpp:422 (listen) Listening on TCP [::]:6554
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext serverpool.cpp:422 (listen) Listening on TCP 0.0.0.0:6549
> Oct 16 11:21:10 amethi mythbackend: mythbackend[1599]: I CoreContext serverpool.cpp:422 (listen) Listening on TCP [::]:6549
> Oct 16 11:21:13 amethi mythbackend: mythbackend[1599]: I Scheduler scheduler.cpp:2356 (HandleReschedule) Reschedule requested for MATCH 0 0 0 - SchedulerInit
> Oct 16 11:21:13 amethi mythbackend: mythbackend[1599]: E Scheduler scheduler.cpp:3824 (BuildNewRecordsQueries) Invalid search key in recordid 309
> Oct 16 11:21:13 amethi mythbackend: mythbackend[1599]: E Scheduler scheduler.cpp:3824 (BuildNewRecordsQueries) Invalid search key in recordid 486
> Oct 16 11:21:13 amethi mythbackend: mythbackend[1599]: E Scheduler scheduler.cpp:3824 (BuildNewRecordsQueries) Invalid search key in recordid 488
> Oct 16 11:21:13 amethi mythbackend: mythbackend[1599]: I Scheduler scheduler.cpp:2469 (HandleReschedule) Scheduled 413 items in 0.5 = 0.09 match + 0.12 check + 0.33 place
> Oct 16 11:21:13 amethi mythbackend: mythbackend[1599]: I Scheduler scheduler.cpp:2538 (HandleRunSchedulerStartup) Scheduler: Seem to be woken up by USER
> Oct 16 11:21:14 amethi mythbackend: mythbackend[1599]: I CoreContext main_helpers.cpp:687 (run_backend) Main::Registering HttpStatus Extension
> Oct 16 11:21:14 amethi mythbackend: mythbackend[1599]: E CoreContext serverpool.cpp:435 (listen) Failed listening on TCP 0.0.0.0:3306 - Error 8: The bound address is already in use
> Oct 16 11:21:14 amethi mythbackend: mythbackend[1599]: C CoreContext main_helpers.cpp:700 (run_backend) Backend exiting, MainServer initialization error.
> Oct 16 11:21:14 amethi mythbackend: mythbackend[1599]: I CoreContext bonjourregister.cpp:28 (~BonjourRegister) Bonjour: De-registering service '' on ''
and the command again:
mythuser at amethi:/home/mythtv/.mythtv$ sudo netstat -alnp | grep 3306
>> [sudo] password for mythuser:
>> tcp 0 0 192.168.1.105:3306 0.0.0.0:* LISTEN 1180/mysqld
>> tcp 0 0 192.168.1.105:56296 192.168.1.105:3306 ESTABLISHED 8025/mythfrontend.r
>> tcp 0 0 192.168.1.105:3306 192.168.1.105:56212 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:3306 192.168.1.105:56210 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:56354 192.168.1.105:3306 ESTABLISHED 8025/mythfrontend.r
>> tcp 0 0 192.168.1.105:3306 192.168.1.95:55132 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:3306 192.168.1.105:56354 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:3306 192.168.1.95:55176 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:3306 192.168.1.105:56296 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:56286 192.168.1.105:3306 ESTABLISHED 8025/mythfrontend.r
>> tcp 0 0 192.168.1.105:3306 192.168.1.95:55186 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:3306 192.168.1.105:56286 ESTABLISHED 1180/mysqld
>> tcp 0 0 192.168.1.105:56212 192.168.1.105:3306 ESTABLISHED 8025/mythfrontend.r
>> tcp 0 0 192.168.1.105:56210 192.168.1.105:3306 ESTABLISHED 8025/mythfrontend.r
>> tcp 0 0 192.168.1.105:3306 192.168.1.95:55252 ESTABLISHED 1180/mysqld
>> unix 3 [ ] STREAM CONNECTED 23306 1659/dbus-daemon @/tmp/dbus-gnCTESRztz
192.168.1.95 is the frontend only machine.
It connects to backend, but can't see music library, can't see
recordings, but knows there are a bunch in the group. Can't set to record.
Frontend running on backend complains it can't connect to backend
server. With either localhost or 192.168.1.105 set as the backend host.
More information about the mythtv-users
mailing list