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

[sarvin]

I found "bind-address" and assigned the frontend/backend address.
The only linux box I currently have is actually running mythtv.

Now I'm getting messages like this:

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-14 12:53:18.370 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-14 12:53:18.420 Database not open while trying to load  
setting: VidModeResolution0
2006-06-14 12:53:23.460 Unable to connect to database!
2006-06-14 12:53:23.460 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'root'@'192.168.1.3' (using password: YES)

I'm thinking it has something to do with the Mysql database. I  
origionally built the Mysql database as root. Should I substitute  
mythtv@"%" for root?

On Jun 14, 2006, at 8:18 AM, Stuart Fox wrote:

>
>> 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?
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users