Mythbackend problem

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
andrewj720
Newcomer
Posts: 7
Joined: Mon Jun 09, 2014 7:50 pm
Location: Cambridgeshire, UK
Contact:
Great Britain

Mythbackend problem

Post by andrewj720 »

When I start Mythbackend I'm presented with the country selection screen, then databse configuration screens 1 & 2, after which it loops back to the country/language screen.

If I start mythbackend from terminal, this is the output:
everyone@LivingRoomPC:~$ mythbackend
2014-08-07 13:29:54.064986 C mythbackend version: fixes/0.27 [v0.27-196-g3ca3f6d] http://www.mythtv.org
2014-08-07 13:29:54.065003 C Qt version: compile: 4.8.6, runtime: 4.8.6
2014-08-07 13:29:54.065006 N Enabled verbose msgs: general
2014-08-07 13:29:54.065013 N Setting Log Level to LOG_INFO
2014-08-07 13:29:54.065555 I Added logging to the console
2014-08-07 13:29:54.065648 I Setup Interrupt handler
2014-08-07 13:29:54.065657 I Setup Terminated handler
2014-08-07 13:29:54.065665 I Setup Segmentation fault handler
2014-08-07 13:29:54.065672 I Setup Aborted handler
2014-08-07 13:29:54.065678 I Setup Bus error handler
2014-08-07 13:29:54.065685 I Setup Floating point exception handler
2014-08-07 13:29:54.065693 I Setup Illegal instruction handler
2014-08-07 13:29:54.065702 I Setup Real-time signal 0 handler
2014-08-07 13:29:54.065732 N Using runtime prefix = /usr/local
2014-08-07 13:29:54.065741 N Using configuration directory = /home/everyone/.mythtv
2014-08-07 13:29:54.065825 I Assumed character encoding: en_GB.UTF-8
2014-08-07 13:29:54.066439 I Using localhost value of LoungeMythTV
2014-08-07 13:29:54.066489 I Testing network connectivity to '192.168.0.6'
2014-08-07 13:29:54.067096 I Starting process manager
2014-08-07 13:29:54.067326 I Starting IO manager (read)
2014-08-07 13:29:54.067364 I Starting process signal handler
2014-08-07 13:29:54.069137 I Starting IO manager (write)

Cannot login to database

Would you like to configure the database connection now? [no] 2014-08-07 13:29:54.173873 E Unable to connect to database!
2014-08-07 13:29:54.173890 E Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.6' (111)

2014-08-07 13:29:54.297707 I Starting mythlogserver
2014-08-07 13:29:54.468217 I Added logging to mythlogserver at TCP:35327
2014-08-07 13:29:59.177349 I Starting mythlogserver
2014-08-07 13:30:29.136039 I Starting mythlogserver
2014-08-07 13:30:59.109059 I Starting mythlogserver
q
2014-08-07 13:31:24.522911 C Failed to init MythContext.
I've trawled numerous forums and google looking for a solution but none of the suggestions have worked, or the commands return error messages so I'm unable to follow them.

I'd really appreciate help on getting the backend server working, as this has got me stumped
Using Tapatalk
User avatar
rwagner
Developer
Posts: 217
Joined: Thu Feb 06, 2014 11:37 pm
United States of America

Re: Mythbackend problem

Post by rwagner »

Is your database server running? Is your database server configured to listen on 192.168.0.6?
andrewj720
Newcomer
Posts: 7
Joined: Mon Jun 09, 2014 7:50 pm
Location: Cambridgeshire, UK
Contact:
Great Britain

Re: Mythbackend problem

Post by andrewj720 »

Yes - it's a primary backend server at 192.168.0.6 and is the only server I'm using at present (using 192.168.0.6 instead of 127.0.0.1 as I intend to connect to primary backend from a Raspberry Pi frontend server in another room).
Using Tapatalk
User avatar
rwagner
Developer
Posts: 217
Joined: Thu Feb 06, 2014 11:37 pm
United States of America

Re: Mythbackend problem

Post by rwagner »

I'm not asking about your backend. I'm asking about your database. The frontend, backend, and database server are three separate entities.
andrewj720
Newcomer
Posts: 7
Joined: Mon Jun 09, 2014 7:50 pm
Location: Cambridgeshire, UK
Contact:
Great Britain

Re: Mythbackend problem

Post by andrewj720 »

How can i check if database server is running?
Using Tapatalk
wesnewell
Senior
Posts: 731
Joined: Mon Jun 23, 2014 6:54 pm
Location: Wylie TX, USA
United States of America

Re: Mythbackend problem

Post by wesnewell »

wes@mythfe0:~$ mysql
ERROR 1045 (28000): Access denied for user 'wes'@'localhost' (using password: NO)
This is normal
wes@mythfe0:~$ service mysql status
mysql start/running, process 1162
wes@mythfe0:~$
BE/FE-Asrock AB350 Pro Ryzen 3 3200G, 6 atsc tuners. FE's-GF8200's Athlon II, Ryzen 3 2200G. Mythtv user since 2005.
andrewj720
Newcomer
Posts: 7
Joined: Mon Jun 09, 2014 7:50 pm
Location: Cambridgeshire, UK
Contact:
Great Britain

Re: Mythbackend problem

Post by andrewj720 »

Here is the output of mysql status in terminal:
everyone@LivingRoomPC:~$ mysql
ERROR 1045 (28000): Access denied for user 'everyone'@'localhost' (using password: NO)
everyone@LivingRoomPC:~$ service mysql status
status: Unknown job: mysql
everyone@LivingRoomPC:~$
Using Tapatalk
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythbackend problem

Post by bill6502 »

The above says that mysqld is running. From your original post:

2014-08-07 13:29:54.065741 N Using configuration directory = /home/everyone/.mythtv

says that you're probably starting your backend as user 'everyone'. So, look at that home
directory for .mythtv/config.xml. Repeat the above test with the password between
<Password>...</Password> in that file. Or, do you (more properly) have a /home/mythtv
user with the same file and a different password. One way to start the backend as user
mythtv is: sudo mythbackend --user mythtv ... other options... Typically, you'd start the
backend automatically via Upstart or systemd or a script in /etc/init.d (whatever your
distribution prefers.)
andrewj720
Newcomer
Posts: 7
Joined: Mon Jun 09, 2014 7:50 pm
Location: Cambridgeshire, UK
Contact:
Great Britain

Re: Mythbackend problem

Post by andrewj720 »

Thanks for the replies - I got the backend working again by reinstalling it and mysql. I really don't knwo what the issue was, but at least I can start the backend from command line now.

Just need to iron out a few other issues and then we're rocking:
1. No sound on HD channels via XBMC
2. No EPG data unless called from within a playing TV channel
3. Can't play live TV on Raspberry Pi OpenElec via Cmyth addon - says "Channel unavailable" when asking Mythbackend for stream.

Will head to the relevant forums for answers...
Using Tapatalk
wesnewell
Senior
Posts: 731
Joined: Mon Jun 23, 2014 6:54 pm
Location: Wylie TX, USA
United States of America

Re: Mythbackend problem

Post by wesnewell »

Welcome to the mythtv forum****Do this before your first post or now (it's retroactive)*****
Please go to the User Control Panel, select Profile, and then enter your city, state/province, and country into the Location field (country minimum) and save it. Once done, your location will appear in every post so you won't have people asking where you are ever again. This will help people help you. Example: Wylie, TX, USA. or just USA, but country as a minimum, and country is the most important. There are many cities with the same name all over the world. Without knowing what country you are in it's hard to make any recommendations. Or you can just select your Country and have its flag flown in your post. This info will let people know the the type of tuner you are using, which may be relevant. Thank you.
BE/FE-Asrock AB350 Pro Ryzen 3 3200G, 6 atsc tuners. FE's-GF8200's Athlon II, Ryzen 3 2200G. Mythtv user since 2005.
Post Reply