Cannot connect to mythbackend server.

[popatopalous]

I have mythtv installed using the instructions in Sabayon wiki. But the frontend can't connect to Master backend server. When I run 'mythfrontend' and select 'Watch TV' I get this error Could not connect to the Master backend server -- is it running? Is the IP address set for it in the set-up program correct?

1. backend is running

Code: Select all

~ # /etc/init.d/mythbackend start
 * WARNING:  mythbackend has already been started.

2.

Code: Select all

~ # mythfrontend
2008-01-13 06:09:10.555 Using runtime prefix = /usr
2008-01-13 06:09:10.636 DPMS is active.
2008-01-13 06:09:10.681 New DB connection, total: 1
2008-01-13 06:09:10.687 Connected to database 'mythconverg' at host: localhost
2008-01-13 06:09:10.688 Total desktop dim: 1680x1050, with 1 screen[s].
2008-01-13 06:09:10.692 Using screen 0, 1680x1050 at 0,0
2008-01-13 06:09:10.713 Current Schema Version: 1160
2008-01-13 06:09:10.715 mythfrontend version: 0.20.20070821-1 www.mythtv.org
2008-01-13 06:09:10.715 Enabled verbose msgs:  important general
2008-01-13 06:09:11.282 Total desktop dim: 1680x1050, with 1 screen[s].
2008-01-13 06:09:11.285 Using screen 0, 1680x1050 at 0,0
2008-01-13 06:09:11.286 Switching to square mode (G.A.N.T.)
2008-01-13 06:09:11.334 Using the Qt painter
QMultiInputContext::changeInputMethod(): index=0, slave=xim
mythtv: could not connect to socket
2008-01-13 06:09:12.480 Joystick disabled.
mythtv: No such file or directory
lirc_init failed for mythtv, see preceding messages
2008-01-13 06:09:13.035 Loading from: /usr/share/mythtv/themes/G.A.N.T./base.xml
2008-01-13 06:09:13.059 Loading from: /usr/share/mythtv/themes/default/base.xml
2008-01-13 06:09:13.081 Registering Internal as a media playback plugin.
2008-01-13 06:09:15.626 New DB connection, total: 2
2008-01-13 06:09:15.626 Connected to database 'mythconverg' at host: localhost
2008-01-13 06:09:15.637 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2008-01-13 06:09:15.637 Connection timed out.
                        You probably should modify the Master Server
                        settings in the setup program and set the
                        proper IP address.
2008-01-13 06:09:16.584 TV: Attempting to change from None to None
2008-01-13 06:09:18.715 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)
2008-01-13 06:09:18.715 Connection timed out.
                        You probably should modify the Master Server
                        settings in the setup program and set the
                        proper IP address.
QInputContext: cannot create input context for non-toplevel widgets
QMultiInputContext::changeInputMethod(): index=0, slave=xim
QInputContext: cannot create input context for non-toplevel widgets
QInputContext: cannot create input context for non-toplevel widgets
QMultiInputContext::changeInputMethod(): index=0, slave=xim
QInputContext: cannot create input context for non-toplevel widgets


3.From '/etc/mysql/my.cnf':

Code: Select all

 security:
# using "localhost" in connects uses sockets by default
# skip-networking
bind-address                            = 127.0.0.1

4./usr/share/mythtv/database/mc.sql:

Code: Select all

CREATE DATABASE if not exists mythconverg;
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;

5. Distro: Sabayon Linux 3.5 Beta Loop 1
Card: Hauppage WIN PVR-500
Mythtv version: Gentoo/Portage media-tv/mythtv-0.20.2_p15332

I know from cruising the Mythtv forum this is a common problem and possibly related to mysql. Does anyone know how to fix this or where to look? I'm going to reboot and run 'mythfrontend' [backend starts automagically] and post '/var/log/mythtv/mythbackend.log'. If there is any other data to provide to resolve this issue I'll happily post it just ask. I'm also working on this on the Mythtv forum but have yet to see anyone identified as a SL user.

[popatopalous]

Here's todays contents of '/var/log/mythtv/mythbackend.log':

Code: Select all

2008-01-13 05:46:53.352 Using runtime prefix = /usr
2008-01-13 05:46:53.839 New DB connection, total: 1
2008-01-13 05:46:53.925 Connected to database 'mythconverg' at host: localhost
2008-01-13 05:46:53.988 Current Schema Version: 1160
Starting up as the master server.
2008-01-13 05:46:54.046 New DB connection, total: 2
2008-01-13 05:46:54.052 Connected to database 'mythconverg' at host: localhost
2008-01-13 05:46:54.074 EITHelper: localtime offset -7:00:00
2008-01-13 05:46:54.105 New DB connection, total: 3
2008-01-13 05:46:54.106 Connected to database 'mythconverg' at host: localhost
2008-01-13 05:46:54.261 EITHelper: localtime offset -7:00:00
2008-01-13 05:46:54.377 New DB scheduler connection
2008-01-13 05:46:54.607 Connected to database 'mythconverg' at host: localhost
2008-01-13 05:46:54.931 QMulticastSocket: setsockopt - IP_ADD_MEMBERSHIP Error
2008-01-13 05:46:54.957 QMulticastSocket: setsockopt - IP_ADD_MEMBERSHIP Error
2008-01-13 05:46:56.640 Main::Registering HttpStatus Extension
2008-01-13 05:46:56.644 mythbackend version: 0.20.20070821-1 www.mythtv.org
2008-01-13 05:46:56.645 Enabled verbose msgs: important general
2008-01-13 05:46:56.666 QMulticastSocket: setsockopt - IP_ADD_MEMBERSHIP Error
/mnt/store//nfslockfile.lock: Permission denied
Unable to open lockfile!
Be sure that '/mnt/store/' exists and that both
the directory and that file are writeable by this user.
2008-01-13 08:03:34.310 Using runtime prefix = /usr
2008-01-13 08:03:35.067 New DB connection, total: 1
2008-01-13 08:03:35.216 Connected to database 'mythconverg' at host: localhost
2008-01-13 08:03:35.288 Current Schema Version: 1160
Starting up as the master server.
2008-01-13 08:03:35.350 New DB connection, total: 2
2008-01-13 08:03:35.359 Connected to database 'mythconverg' at host: localhost
2008-01-13 08:03:35.390 EITHelper: localtime offset -7:00:00
2008-01-13 08:03:35.421 New DB connection, total: 3
2008-01-13 08:03:35.422 Connected to database 'mythconverg' at host: localhost
2008-01-13 08:03:35.586 EITHelper: localtime offset -7:00:00
2008-01-13 08:03:35.710 New DB scheduler connection
2008-01-13 08:03:35.856 Connected to database 'mythconverg' at host: localhost
2008-01-13 08:03:37.531 Main::Registering HttpStatus Extension
2008-01-13 08:03:37.535 mythbackend version: 0.20.20070821-1 www.mythtv.org
2008-01-13 08:03:37.536 Enabled verbose msgs: important general
/mnt/store//nfslockfile.lock: Permission denied
Unable to open lockfile!
Be sure that '/mnt/store/' exists and that both
the directory and that file are writeable by this user.


FWIW I did run 'mkdir /mnt/store'.

Code: Select all

# cd /mnt/store
store # ls
nfslockfile.lock


There is also a Mythtv 'mysql configuration verification script':

http://www.mythtvtalk.com/forum/viewtopic.php?t=4975

The disturbing results of running that script are:

Code: Select all

# ./mythtv.mysql
./mythtv.mysql: line 12: ={HOME}./.mythtv: No such file or directory
./mythtv.mysql: line 13: =/mysql.txt: No such file or directory
./mythtv.mysql: line 14: root={USER}: command not found
./mythtv.mysql: line 15: /bin/su=/bin/bash: No such file or directory
./mythtv.mysql: line 16: =/usr/bin/mysql: No such file or directory
./mythtv.mysql: line 18: =0: command not found
./mythtv.mysql: line 20: print: command not found
./mythtv.mysql: line 21: print: command not found
./mythtv.mysql: line 23: syntax error near unexpected token `{'
./mythtv.mysql: line 23: `if ($USER eq "root") {'


Indicating that something is mighty unhappy in my Mythtv install. That makes me wonder if there may be issues with file paths and/or names? As does this:

http://www.mythtvtalk.com/forum/viewtopic.php?t=999

"Installing 0.19 on my Gentoo box I couldn't get the backend daemon to work.

The reason?

/etc/mythtv/mysq.txt is now /etc/mythtv/.mythtv/mysql.txt ! "

So I:

Code: Select all

# cp /etc/mythtv/.mythtv/mysql.txt /etc/mythtv/mysq.txt

but that didn't change anything. At least not yet. I'm stumped. Send help!

Code: Select all

# nano /etc/mythtv/.mythtv/mysql.txt
DBHostName=localhost
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

# Set the following if you want to use something other than the
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise
# you'll need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
# Set the time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#WOLsqlReconnectWaitTime=0
#
#
# This is the amount of retries to wake the MySQL server until the frontend
# gives up
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'


[mindstorms6]

security:
# using "localhost" in connects uses sockets by default
# skip-networking
bind-address = 127.0.0.1

try making it

security:
# using "localhost" in connects uses sockets by default
# skip-networking
#bind-address = 127.0.0.1

cause you want everyone to be able to connect, not just localhost

[popatopalous]

security:
# using "localhost" in connects uses sockets by default
# skip-networking
bind-address = 127.0.0.1

try making it

security:
# using "localhost" in connects uses sockets by default
# skip-networking
#bind-address = 127.0.0.1

cause you want everyone to be able to connect, not just localhost

Thanks I did that but I'm still getting the same error/problem... I've been over setting up mythtv here and in my Mandriva partition quite a bit and that [# bind-address = 127.0.0.1] is part of the instructions.