[mythtv-users] Mythfrontend will not start

[Ozzy Lash]

On Wed, Aug 31, 2016 at 9:00 PM, Jack McGee <jack at greendesk.net> wrote:

> On 08/31/2016 08:35 PM, Joseph Fry wrote:
>
> You have no password set for the MythTV MySQL acct.  You need to update
> your config.xml accordingly.
>
> On Wed, Aug 31, 2016, 8:43 PM Jack McGee <jack at greendesk.net> wrote:
>
>>
>> I do not see that.  I see:
>>
>>
>> mysql> SHOW GRANTS FOR mythtv;
>> +---------------------------------------------------------+
>> | Grants for mythtv@%                                     |
>> +---------------------------------------------------------+
>> | GRANT USAGE ON *.* TO 'mythtv'@'%'                      |
>> | GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
>> +---------------------------------------------------------+
>> 2 rows in set (0.00 sec)
>>
>> _______________________________________________
>
>
>
> Here is revised config.xml
>
> mythuser at mythuser-ZBOX-ID84:~/.mythtv$ cat config.xml
> <Configuration>
>   <Database>
>     <PingHost>1</PingHost>
>     <Host>192.168.0.105</Host>
>     <UserName>mythtv</UserName>
>     <Password></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>
>
> mythfrontend log after that change:
>
>
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt
> handler
> (snip)
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> N thread_unknown mythdirs.cpp:194 (InitializeMythDirs) Using configuration
> directory = /home/mythuser/.mythtv
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I Logger logging.cpp:313 (run) Added logging to the console
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I CoreContext mythcorecontext.cpp:266 (Init) Assumed character encoding:
> en_US.UTF-8
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E CoreContext mythdbparams.cpp:49 (IsValid) DBPassword is not set in
> config.xml
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E CoreContext mythdbparams.cpp:39 (IsValid) DBHostName is not set in
> config.xml
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> N CoreContext mythcontext.cpp:505 (LoadDatabaseSettings) Empty
> LocalHostName.
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I CoreContext mythcontext.cpp:513 (LoadDatabaseSettings) Using localhost
> value of mythuser-ZBOX-ID84
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable to
> connect to database!
> Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was
> [1/2002]:#012QMYSQL: Unable to connect#012Database error was:#012Can't
> connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
> (2)
> (snip)
> Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I SendMessage mythcorecontext.cpp:436 (ConnectCommandSocket)
> MythCoreContext::ConnectCommandSocket(): Connecting to backend server:
> localhost:6543 (try 1 of 1)
> Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E SendMessage mythcorecontext.cpp:979 (GetBackendServerIP) MythCoreContext::GetBackendServerIP():
> No address defined for host: localhost
> Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E MythSocketThread(-1) mythsocket.cpp:729 (ConnectToHostReal)
> MythSocket(7f2ea4004a60:-1): Failed to connect to (127.0.0.1:6543)
> Connection refused
> Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E SendMessage mythcorecontext.cpp:506 (ConnectCommandSocket) Connection to
> master server timed out.#012#011#011#011Either the server is down or the
> master server settings#012#011#011#011in mythtv-settings does not contain
> the proper IP address
> (snip)
> Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I CoreContext mythtranslation.cpp:73 (load) Loading en_us translation for
> module mythfrontend
> Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> I SendMessage mythcorecontext.cpp:436 (ConnectCommandSocket)
> MythCoreContext::ConnectCommandSocket(): Connecting to backend server:
> localhost:6543 (try 1 of 1)
> Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E SendMessage mythcorecontext.cpp:979 (GetBackendServerIP) MythCoreContext::GetBackendServerIP():
> No address defined for host: localhost
> Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E MythSocketThread(-1) mythsocket.cpp:729 (ConnectToHostReal)
> MythSocket(7f2e3000aad0:-1): Failed to connect to (127.0.0.1:6543)
> Connection refused
> Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]:
> E SendMessage mythcorecontext.cpp:506 (ConnectCommandSocket) Connection to
> master server timed out.#012#011#011#011Either the server is down or the
> master server settings#012#011#011#011in mythtv-settings does not contain
> the proper IP address
>
>
>
>
You may want to take a step back and look at your mysql configuration on
the backend.  From your netstat output, it doesn't look to me like it is
listening for connections from remote hosts, only from the local host.

One way to test this out is to go to the frontend and do a

mysql -h 192.168.0.105 -u mythtv mythconverg

(since you have no password set on the db, if you did have a password you
would need to use the -p option)

If you can't connect from the frontend then that is (at least one)
problem.  For mysql, the way to get it to listen for connections from
remote hosts was  to set in either my.conf in the /etc/mysql directory, or
in a file in the /etc/mysql/conf.d directory:

[mysqld]
bind-address    = 192.168.0.105

If you are using mariadb, then I don't know how you set it. Once you set it
you will need to restart mysqld.

Hopefully that is the issue.

Bill
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160831/33a6e36b/attachment.html>