<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">I had a previous post titled. <br><br>upgrade database schema from 1224 to 1242 fails<br>That is now fixed thanks to you guys.<br><br>Now. a new issue<br><br>I just moved to trunk .22<br>
I have finally got my backend running. I upgraded the frontend to .22 also.<br>
When I start mythtv on the frontend, I get an error message.<br>
Mythtv is using all inputs, but there are no active recordings<br>
Here is a post from the error log.<br>
<br>
2009-08-25 00:20:29.585 Driver error was [1/2003]:<br>
QMYSQL: Unable to connect<br>
Database error was:<br>
Can't connect to MySQL server on 'myth-backend' (111)<br>
<br>
QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2009-08-25 00:20:29.635 No error type from QSqlError? Strange...<br>
2009-08-25 00:20:29.685 Database not open while trying to load setting: Theme<br>
2009-08-25 00:20:29.686 Unable to connect to database!<br>
2009-08-25 00:20:29.686 Driver error was [1/2003]:<br>
QMYSQL: Unable to connect<br>
Database error was:<br>
Can't connect to MySQL server on 'myth-backend' (111)<br>
<br>
QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2009-08-25 00:20:29.736 No error type from QSqlError? Strange...<br>
2009-08-25 00:20:29.786 Database not open while trying to load setting: Theme<br>
2009-08-25 00:20:29.787 Unable to connect to database!<br>
2009-08-25 00:20:29.787 Driver error was [1/2003]:<br>
QMYSQL: Unable to connect<br>
Database error was:<br>
Can't connect to MySQL server on 'myth-backend' (111)<br>
<br>
QSqlQuery::exec: database not open<br>
QSqlQuery::exec: database not open<br>
2009-08-25 00:20:29.837 No error type from QSqlError? Strange...<br>
2009-08-25 00:20:29.888 Database not open while trying to load setting: Theme<br>
2009-08-25 00:20:34.349 Deleting UPnP client...<br><br>Here is the errors if I start from a command line.<br>
<br>
kevin@mythtv:/var/log/mythtv$ mythtv<br>
2009-08-25 00:45:42.397 Using runtime prefix = /usr<br>
2009-08-25 00:45:42.397 Empty LocalHostName.<br>
2009-08-25 00:45:42.398 Using localhost value of mythtv<br>
2009-08-25 00:45:42.398 Testing network connectivity to 'myth-backend'<br>
2009-08-25 00:45:42.416 New DB connection, total: 1<br>
2009-08-25 00:45:42.418 Connected to database 'mythconverg' at host: myth-backend<br>
2009-08-25 00:45:42.418 Closing DB connection named 'DBManager0'<br>
2009-08-25 00:45:42.489 ScreenSaverX11Private: Gnome screen saver support enabled<br>
2009-08-25 00:45:42.574 DPMS is active.<br>
2009-08-25 00:45:42.577 Primary screen: 0.<br>
2009-08-25 00:45:42.578 Connected to database 'mythconverg' at host: myth-backend<br>
2009-08-25 00:45:42.580 Using screen 0, 1280x720 at 0,0<br>
2009-08-25 00:45:42.601 MythUI Image Cache size set to 20971520 bytes<br>
2009-08-25 00:45:42.606 Current Schema Version: 1242<br>
2009-08-25 00:45:42.724 Primary screen: 0.<br>
2009-08-25 00:45:42.725 Using screen 0, 1280x720 at 0,0<br>
2009-08-25 00:45:42.727 Using theme base resolution of 800x600<br>
2009-08-25 00:45:42.780 LIRC: Successfully initialized '/dev/lircd' using '/home/kevin/.mythtv/lircrc' config<br>
2009-08-25 00:45:42.801 JoystickMenuThread Error: Joystick disabled - Failed to read /home/kevin/.mythtv/joystickmenurc<br>
2009-08-25 00:45:43.008 Using the Qt painter<br>
2009-08-25 00:45:43.257 Loading base theme from /usr/share/mythtv/themes/G.A.N.T/base.xml<br>
2009-08-25 00:45:43.755 Loading base theme from /usr/share/mythtv/themes/default/base.xml<br>
2009-08-25 00:45:43.960 TV: ctor<br>
2009-08-25 00:45:44.055 New DB connection, total: 2<br>
2009-08-25 00:45:44.056 Connected to database 'mythconverg' at host: myth-backend<br>
2009-08-25 00:45:44.353 TV: StartTV() -- begin<br>
2009-08-25 00:45:44.353 TV: ctor<br>
2009-08-25 00:45:44.515 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)<br>
2009-08-25 00:45:44.515 Connection timed out. <br>
You probably should modify the Master Server <br>
settings in the setup program and set the <br>
proper IP address.<br>
2009-08-25 00:45:44.626 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5)<br>
2009-08-25 00:45:44.627 Connection timed out. <br>
You probably should modify the Master Server <br>
settings in the setup program and set the <br>
proper IP address.<br>
2009-08-25 00:45:44.627 TV Error: Failed to get recording show list<br>
2009-08-25 00:45:46.412 TV: StartTV -- process events 2 begin<br>
2009-08-25 00:45:46.429 TV: StartTV -- process events 2 end<br>
2009-08-25 00:45:46.430 TV::~TV() -- begin<br>
2009-08-25 00:45:46.430 TV::~TV() -- lock<br>
2009-08-25 00:45:46.431 TV::~TV() -- end<br>
2009-08-25 00:45:46.431 TV: StartTV -- end<br>
<br>
Which would leave me to believe that I cant connect to the database.<br>
But if I do a mysql -h myth-backend -u mythtv -p mythconverg<br>
it will bring me to the mysql prompt.<br>I am pretty sure the backend is set up correctly. ( I set it up like I had it before the upgrade )<br>
<br>
Any ideas?<br>
I use a hdhomerun and 2 ati hdtv wonder cards. The wonder cards are not yet installed, but they are in the pci slots. (I have not istalled them in the setup of myth backend)<br> I want to get it working with the hdhomerun first.<br></td></tr></table><br>