[mythtv-users] Unable to start front end on PPC Mac w Linux Back-end

[Stuart Fox]

> I've been successfully running MythTV for a few months now as a back/
> front end on a Linux box in the Living room. I've recently purchased
> a 12' powerbook that I'd like to use as a front-end. On the Mac I'm
> running a .19 build. Unfortunately I'm unable to get the front-end to
> see the database on the Linux back-end.
>
> If I run the front end from a terminal I get:
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2006-06-14 08:00:14.247 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2006-06-14 08:00:14.298 Database not open while trying to save
> setting: Language
> 2006-06-14 08:00:14.300 Unable to connect to database!
> 2006-06-14 08:00:14.301 Driver error was [1/2003]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.1.51' (61)
>
> I'm unsure of where the problem is, I think everything should be set
> up correctly. I've modified access to the Mysql database to allow for
> multiple systems using the "no security" option per instructions
> found at the bottom of the page here http://mythtv.org/docs/mythtv-
> HOWTO-6.html#modify_perm_mysql
>
> Anyone have any clue what I should try next. I can ssh into the linux
> box, and have the correct address.
>

Check the mysql server isnt listening on localhost or a domain socket only.
something like --skip-networking or --bind=127.0.0.1 in the config file.

If it is listening, use the mysql -h <host> -u <mythuser> -p <password>
and check if that works. If it doesnt, check your local firewall settings.

Stuart

-- 
The problem with the world is stupidity. Not saying there should be a
capital punishment for stupidity, but why don't we just take the safety
labels off of everything and let the problem solve itself?