[mythtv-users] mythtv-backend service stops

[Roger Searle]

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.