[mythtv-users] mythtv-backend service stops

[Thomas Mashos]

On Sat, Nov 15, 2014 at 10:08 PM, Roger Searle <roger.searle at gmail.com> wrote:
> On 17/11/2014 12:18 a.m., Paul Harrison wrote:
>>
>> On 16/11/14 10:56, Jan Ceuleers wrote:
>>>
>>> On 11/15/2014 09:14 PM, Roger Searle wrote:
>>>>
>>>> Why does the backend service stop almost immediately?
>>>
>>> In order to answer this particular question (which may help you to
>>> diagnose the other issues you are facing), try running the backend
>>> manually from the cli instead of by starting it as a service.
>>>
>>> In order to make this test as relevant as possible, first find out how
>>> (i.e. with which command-line options) the backend is being started by
>>> looking at the relevant init script.
>>>
>>>     LANG=$LANG exec /usr/bin/mythbackend --syslog local7 --user mythtv
>>> --daemon
>
> Yes this is all I had in my mythtv-backend.conf
>>>
>>>
>>> So then, still as root, start the backend as above (except for the
>>> --daemon bit) and watch its output:
>>>
>>> root at be:~# /usr/bin/mythbackend --syslog local7 --user mythtv
>>>
>>> The backend's output will tell you for sure, but I'll bet it'll start
>>> working if you remove options such as --nologserver and --enable-dblog
>>> if they are present.
>
> Unfortunately this wasn't my issue...
>>>
>>>
>>> HTH, Jan
>>>
>>
>>
>> We now check that --syslog, --logpath and --enable-dblog are not used
>> if --nologserver is used.
>>
>> Paul H.
>>
> Thanks - progress.  I can confirm there were no such options being passed,
> --nologserver was not present, subsequent starting of the backend via CLI as
> below now reveals I have a mysql issue. mysql service is running, and
> netstat -tan shows 127.0.0.1:3306 LISTEN. Do I need to reset permissions on
> the database? I can do a "mysql -u root -p" but what would the command be to
> give access to the mythtv user?
>
>
> emmatodd at htpc:~$ sudo /usr/bin/mythbackend
> 2014-11-17 05:57:48.657912 C  mythbackend version: fixes/0.27
> [v0.27-193-g8ee257c] www.mythtv.org
> 2014-11-17 05:57:48.657930 C  Qt version: compile: 4.8.6, runtime: 4.8.6
> 2014-11-17 05:57:48.657934 N  Enabled verbose msgs:  general
> 2014-11-17 05:57:48.657947 N  Setting Log Level to LOG_INFO
> 2014-11-17 05:57:48.669149 I  Added logging to the console
> 2014-11-17 05:57:48.670582 I  Setup Interrupt handler
> 2014-11-17 05:57:48.670605 I  Setup Terminated handler
> 2014-11-17 05:57:48.670626 I  Setup Segmentation fault handler
> 2014-11-17 05:57:48.670647 I  Setup Aborted handler
> 2014-11-17 05:57:48.670667 I  Setup Bus error handler
> 2014-11-17 05:57:48.670689 I  Setup Floating point exception handler
> 2014-11-17 05:57:48.670711 I  Setup Illegal instruction handler
> 2014-11-17 05:57:48.670734 I  Setup Real-time signal 0 handler
> 2014-11-17 05:57:48.670804 N  Using runtime prefix = /usr
> 2014-11-17 05:57:48.670829 N  Using configuration directory =
> /home/emmatodd/.mythtv
> 2014-11-17 05:57:48.670960 I  Assumed character encoding: en_NZ.UTF-8
> 2014-11-17 05:57:48.671670 N  Empty LocalHostName.
> 2014-11-17 05:57:48.671689 I  Using localhost value of htpc
> 2014-11-17 05:57:48.671758 I  Testing network connectivity to
> '192.168.1.200'
> 2014-11-17 05:57:48.672331 I  Starting IO manager (read)
> 2014-11-17 05:57:48.674260 I  Starting process signal handler
> 2014-11-17 05:57:48.674333 I  Starting IO manager (write)
> 2014-11-17 05:57:48.674407 I  Starting process manager
> 2014-11-17 05:57:48.771267 I  New Client:  (#1)
>
> Cannot login to database
>
> Would you like to configure the database connection now? [no] 2014-11-17
> 05:57:48.786477 E  Unable to connect to database!
> 2014-11-17 05:57:48.786493 E  Driver error was [1/2003]:
> QMYSQL: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.1.200' (111)
>
> yes
> Database host name:  htpc
> Should I test connectivity to this host using the ping command? [yes]
> Database non-default port: [3306]
> Database name: [mythconverg]
> Database user name: [mythtv]
> Database password: [Ql1JJj9D]
> Unique identifier for this machine (if empty, the local host name will be
> used):
> Would you like to use Wake-On-LAN to retry database connections? [no]
>
> Cannot login to database
>
> Would you like to configure the database connection now? [no] 2014-11-17
> 05:58:36.857498 E  Unable to connect to database!
> 2014-11-17 05:58:36.857525 E  Driver error was [1/2003]:
> QMYSQL: Unable to connect
> Database error was:
> Can't connect to MySQL server on 'htpc' (111)
>
> 2014-11-17 05:58:36.857551 A  Cannot login to database
>
> 2014-11-17 05:59:43.534185 C  Failed to init MythContext.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

As I said previously, you need to either fix MySQL or tell mythbackend
to look for the DB at localhost.

-- 
Thanks,

Thomas Mashos