[mythtv-users] Odd frontend start up problem after 'ssh -X mythtv-setup'

Wed Aug 23 08:59:55 UTC 2006

On Monday 21 Aug 2006 13:20, Bryan Bennetts wrote:
> Hi all,
>
> I have a rather odd problem when I start up my frontend+backend machine - I
> end up looking at one of the mythtv-setup pages!
>
> I have kdm setup to auto login as my mythtv user, my .xinit/.xsession kick
> off mythwelcome which in turn kicks off mythfrontend when I manually start
> the machine.  One day I decided to try ssh -X to run mythtv-setup.  This
> didn't work too well, not giving me aything but the mythtv-setup window,
> blue but with no contents.  However, from this point on whenever I turn my
> machine on instead of going to mythfrontend I get one of the mythtv-setup
> windows. Hitting escape causes what appears to be a crash and I have to
> start the frontend by killing X and logging in as my mythtv user.
>
> I'm not sure what happens whent he machine automagically turns itself on
> for a recording, but I can only guess that it is correctly staying on the
> mythwelcome screen as the machine is turning itself off correctly.
>
> As far as I can tell there isn't a mythtv-setup running when it is in this
> state.
>
> Does anyone have any ideas?  I've obviusly knackered it somehow but am not
> sure how...
>
> Cheers, Bry.

Hm, the plot thickens.  I've taken a look in my front and back end logs and I 
*think* I may have a hostname problem.  I've not changed the host name from 
'localhost', but for some reason my frontend log file seems to believe that I 
have set the name to the machine name, and the database seems to confirm 
this :

frontend log :
2006-08-23 09:52:25.316 Using runtime prefix = /usr
2006-08-23 09:52:25.355 DPMS is disabled.
2006-08-23 09:52:25.685 New DB connection, total: 1
2006-08-23 09:52:25.686 Unable to connect to database!
2006-08-23 09:52:25.686 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-08-23 09:52:25.740 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-08-23 09:52:25.792 Unable to connect to database!
2006-08-23 09:52:25.792 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-08-23 09:52:25.844 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-08-23 09:52:25.896 Database not open while trying to load setting: 
GuiVidModeResoluti
on
2006-08-23 09:52:25.896 Unable to connect to database!
2006-08-23 09:52:25.896 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-08-23 09:52:25.948 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-08-23 09:52:26.000 Database not open while trying to load setting: 
GuiVidModeWidth
2006-08-23 09:52:26.000 Unable to connect to database!
2006-08-23 09:52:26.000 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-08-23 09:52:26.052 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-08-23 09:52:26.104 Database not open while trying to load setting: 
GuiVidModeHeight
2006-08-23 09:52:27.113 Connected to database 'mythconverg' at host: localhost
2006-08-23 09:52:27.228 MSqlQuery: SELECT data FROM settings WHERE value = 
'DisplaySizeRes
olution' AND hostname = 'stella' ;
                                    ^^^^^^^^
eek!-----------------------------------^

database :
mysql> select * from settings;    
<snip>
| Language                                           | EN_GB                                                       
| stella   |
| BackendServerIP                                    | 127.0.0.1                                                       
| stella   |
| BackendServerPort                                  | 6543                                                       
| stella   |
| BackendStatusPort                                  | 6544                                                       
| stella   |
| MasterServerIP                                     | 127.0.0.1                                                      
<snip>

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user,password from user;
+-----------+--------+-------------------------------------------+
| host      | user   | password                                  |
+-----------+--------+-------------------------------------------+
| localhost | root   | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
| stella    | root   |                                           |
| stella    |        |                                           |
| localhost |        |                                           |
| localhost | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC |
+-----------+--------+-------------------------------------------+
5 rows in set (0.00 sec)

I don't know if this is the cause of my other problem, but it certainly 
doesn't look right!  Does anyone have an idea of what would be the best ay to 
resolve this?  Should I change over to use the actual hostname, or should I 
try reverting back to localhost?

Cheers, Bry.