[mythtv-users] Mythfrontend will not start
Jack McGee
jack at greendesk.net
Thu Sep 1 12:04:10 UTC 2016
> On 08/31/2016 09:53 PM, Ozzy Lash wrote:
>>
>>
>>
>> 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)
>
>
> mythuser at mythuser-ZBOX-ID84:/var/log/mythtv$ mysql -h 192.168.0.105 -u
> mythtv mythconverg
> ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.0.163'
> (using password: NO)
>
>>
>> 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
>>
It did not have that line, so I added it:
> mythuser at amethi:/etc/mysql$ cat my.cnf
> #
> # The MySQL database server configuration file.
> #
> # You can copy this to one of:
> # - "/etc/mysql/my.cnf" to set global options,
> # - "~/.my.cnf" to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run program with --help to get a list of available options and with
> # --print-defaults to see which it would actually understand and use.
> #
> # For explanations see
> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>
> #
> # * IMPORTANT: Additional settings that can override those from this file!
> # The files must end with '.cnf', otherwise they'll be ignored.
> #
>
> !includedir /etc/mysql/conf.d/
> !includedir /etc/mysql/mysql.conf.d/
>
> [mysqld]
> bind-address = 192.168.0.105
> mythuser at amethi:/etc/mysql$ sudo service mysql restart
>
>
complete frontend log:
https://app.box.com/s/kk7y2k39arkcirn86efrl03y8k30kb22
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N thread_unknown mythdirs.cpp:192
(InitializeMythDirs) Using runtime prefix = /usr
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N thread_unknown mythdirs.cpp:194
(InitializeMythDirs) Using configuration directory = /home/mythuser/.mythtv
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I Logger logging.cpp:313 (run) Added logging to the
console
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I CoreContext mythcorecontext.cpp:266 (Init) Assumed
character encoding: en_US.UTF-8
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbparams.cpp:49 (IsValid)
DBPassword is not set in config.xml
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbparams.cpp:39 (IsValid)
DBHostName is not set in config.xml
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N CoreContext mythcontext.cpp:505
(LoadDatabaseSettings) Empty LocalHostName.
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I CoreContext mythcontext.cpp:513
(LoadDatabaseSettings) Using localhost value of mythuser-ZBOX-ID84
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbcon.cpp:229 (OpenDatabase)
[DBManager0] Unable to connect to database!
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: 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
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:979
(GetBackendServerIP) MythCoreContext::GetBackendServerIP(): No address
defined for host: localhost
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N CoreContext mythcorecontext.cpp:1670 (InitLocale)
Setting QT default locale to en_US
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7fe154004a80:-1): Failed to connect to
(127.0.0.1:6543) Connection refused
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: 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
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:979
(GetBackendServerIP) MythCoreContext::GetBackendServerIP(): No address
defined for host: localhost
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7fe154004810:-1): Failed to connect to
(127.0.0.1:6543) Connection refused
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: 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
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)
repeats many times.
SNIP
Sep 1 05:51:47 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7fe144002b80:-1): Failed to connect to
(127.0.0.1:6543) Connection refused
Sep 1 05:51:47 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160901/4eae7c30/attachment.html>
More information about the mythtv-users
mailing list