[mythtv-users] Database problem?

[Tom Lichti]

Peter Crighton wrote:
> On Mon, 09 Oct 2006 12:38:55 +0100, you wrote:
>
>   
>> On Fri, 06 Oct 2006 14:52:52 -0400, you wrote:
>>
>>
>> This has not worked, as have none of the other suggestions. Maybe it's
>> not entirely a database issue. I have captured the output from
>> executing mythtv-setup and pasted it below in the hope that it might
>> help.  Not captured (displayed on screen) where also multiple
>> "QSqlQuery::exec: database not open" responses and a final line
>> "QMultiInputContext::changeInputMethod(): index=0, slave=xim.
>>
>> ---
>>
>> 2006-10-09 12:32:03.741 Using runtime prefix = /usr/local
>> 2006-10-09 12:32:03.757 DPMS is active.
>> 2006-10-09 12:32:03.766 New DB connection, total: 1
>> 2006-10-09 12:32:03.767 Unable to connect to database!
>> 2006-10-09 12:32:03.768 No error type from QSqlError?  Strange...
>> 2006-10-09 12:32:03.839 DB Error (KickDatabase):
>> Query was:
>> SELECT NULL;
>> No error type from QSqlError?  Strange...
>> 2006-10-09 12:32:03.897 Unable to connect to database!
>> 2006-10-09 12:32:03.900 No error type from QSqlError?  Strange...
>>     
>
> <snip>
>
> So does no-one have any further ideas where I can go from here to find
> out what is wrong with my installation?
>   
I just quickly read through the previous posts, so forgive me  if I 
missed something. I was seeing the same problem last night, and it was 
an IP issue. What user are you running mythtv-setup as? It appears that 
you are using 'peter'. You should run mythtv under the 'mythtv' user, as 
that will simplify things. If this is a combined frontend/backend, you 
should use '127.0.0.1' as the database server config in mythtv-setup. As 
user mythtv, you should be able to run

mysql -umythtv -pmythtv mythconverg

and get into Mysql. If that does not work, then it is likely that the 
permissions are not setup correctly in Mysql.

Also, what is the contents of /home/{user running 
mythtv-setup}/.mythtv/mysql.txt?

Tom