[mythtv-users] mythfrontend can't connect to backend/database

[starcycle]

I'm noticing this error:

==============================
2008-04-20 16:13:15.262 Unexpected DB Schema version.  Waiting to see
if DB is being upg   raded.
2008-04-20 16:13:20.265 Timed out waiting.
2008-04-20 16:13:20.265 This version of MythTV requires an updated
database schema. Please run mythtv-setup or mythbackend to update your
database.
==============================

I've been running mythtv-setup and mythbackend, but apparently the
database "schema" isn't updating. There's an "information_schema" in
mysql, is that referring to the same thing?

I checked the backend.log, it said this - have no idea what it means,
or if 1214 is the version I need or what:

====================================
2008-04-12 19:59:14.972 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-12 19:59:15.052 Empty LocalHostName.
2008-04-12 19:59:15.265 Using localhost value of moe
2008-04-12 19:59:15.403 New DB connection, total: 1
2008-04-12 19:59:15.454 Connected to database 'mythconverg' at host: localhost
2008-04-12 19:59:15.466 Closing DB connection named 'DBManager0'
2008-04-12 19:59:15.469 Connected to database 'mythconverg' at host: localhost
2008-04-12 19:59:15.524 New DB connection, total: 2
2008-04-12 19:59:15.526 Connected to database 'mythconverg' at host: localhost
2008-04-12 19:59:15.538 Current Schema Version:
2008-04-12 19:59:15.540 DataDirectProcessor::FixProgramIDs() -- begin
2008-04-12 19:59:15.543 New DB DataDirect connection
2008-04-12 19:59:15.546 Connected to database 'mythconverg' at host: localhost
2008-04-12 19:59:15.597 DB Error (Fixing program ids in recorded):
Query was:
UPDATE recorded SET programid=CONCAT(SUBSTRING(programid, 1, 2),
               '00', SUBSTRING(programid, 3)) WHERE length(programid)
= 12
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.recorded' doesn't exist

2008-04-12 19:59:15.642 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunStart' AND hostname is NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2008-04-12 19:59:15.685 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES (
'BackupDBLastRunStart', '2008-04-12 19:59:15', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2008-04-12 19:59:15.717 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB
Backups' AND hostname = 'moe'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2008-04-12 19:59:15.738 New DB connection, total: 3
2008-04-12 19:59:15.754 Connected to database 'mythconverg' at host: localhost
2008-04-12 19:59:15.766 SG(DB Backups) Error: Directory value for
Default Storage Group is empty.  Using hardcoded default value of
'/mnt/store'
2008-04-12 19:59:15.772 SG(DB Backups) Error: FindNextDirMostFree:
'/mnt/store' does not exist!
2008-04-12 19:59:15.777 Backing up database to file:
/tmp/mythconverg--20080412195915.sql
2008-04-12 19:59:15.917 Compressing database backup file.
2008-04-12 19:59:16.074 Database Backup filename:
/tmp/mythconverg--20080412195915.sql.gz
2008-04-12 19:59:16.236 Database Backup complete.
2008-04-12 19:59:16.239 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunEnd' AND hostname is NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2008-04-12 19:59:16.240 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES (
'BackupDBLastRunEnd', '2008-04-12 19:59:16', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2008-04-12 19:59:16.255 No current database version. Auto upgrading
2008-04-12 19:59:16.257 Newest Schema Version : 1214
2008-04-12 19:59:16.261 Inserting MythTV initial database information.
2008-04-12 19:59:16.263 Upgrading to schema version 1112
2008-04-12 19:59:16.544 New DB connection, total: 4
2008-04-12 19:59:16.549 Connected to database 'mythconverg' at host: localhost
2008-04-12 19:59:16.551 Upgrading to schema version 1113
2008-04-12 19:59:16.555 Upgrading to schema version 1114
2008-04-12 19:59:16.559 Upgrading to schema version 1115
2008-04-12 19:59:16.567 Upgrading to schema version 1116
2008-04-12 19:59:16.572 Upgrading to schema version 1117
2008-04-12 19:59:16.583 Upgrading to schema version 1118
2008-04-12 19:59:16.636 Upgrading to schema version 1119
2008-04-12 19:59:16.641 Upgrading to schema version 1120
2008-04-12 19:59:16.651 Upgrading to schema version 1121
2008-04-12 19:59:16.656 Upgrading to schema version 1122
2008-04-12 19:59:16.686 Upgrading to schema version 1123
2008-04-12 19:59:16.702 Upgrading to schema version 1124
2008-04-12 19:59:16.715 Upgrading to schema version 1125
2008-04-12 19:59:16.735 Upgrading to schema version 1126
2008-04-12 19:59:16.767 Upgrading to schema version 1127
2008-04-12 19:59:16.787 Upgrading to schema version 1128
2008-04-12 19:59:16.800 Upgrading to schema version 1129
2008-04-12 19:59:16.834 Upgrading to schema version 1130
2008-04-12 19:59:16.839 Upgrading to schema version 1131
2008-04-12 19:59:16.852 Upgrading to schema version 1132
2008-04-12 19:59:16.863 Upgrading to schema version 1133
2008-04-12 19:59:16.875 Upgrading to schema version 1134
2008-04-12 19:59:16.880 Upgrading to schema version 1135
2008-04-12 19:59:16.900 Upgrading to schema version 1136
2008-04-12 19:59:16.912 Upgrading to schema version 1137
2008-04-12 19:59:16.923 Upgrading to schema version 1138
2008-04-12 19:59:16.929 Upgrading to schema version 1139
2008-04-12 19:59:17.126 Upgrading to schema version 1140
2008-04-12 19:59:17.130 Upgrading to schema version 1141
2008-04-12 19:59:17.148 Upgrading to schema version 1142
2008-04-12 19:59:17.158 Upgrading to schema version 1143
2008-04-12 19:59:17.172 Upgrading to schema version 1144
2008-04-12 19:59:17.177 Upgrading to schema version 1145
2008-04-12 19:59:17.185 Upgrading to schema version 1146
2008-04-12 19:59:17.190 Upgrading to schema version 1147
2008-04-12 19:59:17.208 Upgrading to schema version 1148
2008-04-12 19:59:17.228 Upgrading to schema version 1149
2008-04-12 19:59:17.237 Upgrading to schema version 1150
2008-04-12 19:59:17.242 Upgrading to schema version 1151
2008-04-12 19:59:17.261 Upgrading to schema version 1152
2008-04-12 19:59:17.271 Upgrading to schema version 1153
2008-04-12 19:59:17.292 Upgrading to schema version 1154
2008-04-12 19:59:17.332 Upgrading to schema version 1155
2008-04-12 19:59:17.352 Upgrading to schema version 1156
2008-04-12 19:59:17.363 Upgrading to schema version 1157
2008-04-12 19:59:17.368 Upgrading to schema version 1158
2008-04-12 19:59:17.396 Upgrading to schema version 1159
2008-04-12 19:59:17.408 Upgrading to schema version 1160
2008-04-12 19:59:17.412 Upgrading to schema version 1161
2008-04-12 19:59:17.423 Upgrading to schema version 1162
2008-04-12 19:59:17.429 Upgrading to schema version 1163
2008-04-12 19:59:17.432 Upgrading to schema version 1164
2008-04-12 19:59:17.452 Upgrading to schema version 1165
2008-04-12 19:59:17.465 Upgrading to schema version 1166
2008-04-12 19:59:17.484 Upgrading to schema version 1167
2008-04-12 19:59:17.489 Upgrading to schema version 1168
2008-04-12 19:59:17.498 Upgrading to schema version 1169
2008-04-12 19:59:17.503 Upgrading to schema version 1170
2008-04-12 19:59:17.506 Upgrading to schema version 1171
2008-04-12 19:59:17.604 Upgrading to schema version 1172
2008-04-12 19:59:17.611 Upgrading to schema version 1173
2008-04-12 19:59:17.623 Upgrading to schema version 1174
2008-04-12 19:59:17.646 Upgrading to schema version 1175
2008-04-12 19:59:17.651 Upgrading to schema version 1176
2008-04-12 19:59:17.655 Upgrading to schema version 1177
2008-04-12 19:59:17.667 Upgrading to schema version 1178
2008-04-12 19:59:17.800 Upgrading to schema version 1179
2008-04-12 19:59:17.956 Upgrading to schema version 1180
2008-04-12 19:59:17.975 Upgrading to schema version 1181
2008-04-12 19:59:17.995 Upgrading to schema version 1182
2008-04-12 19:59:18.000 Upgrading to schema version 1183
2008-04-12 19:59:18.011 Upgrading to schema version 1184
2008-04-12 19:59:18.025 Upgrading to schema version 1185
2008-04-12 19:59:18.034 Upgrading to schema version 1186
2008-04-12 19:59:18.041 Upgrading to schema version 1187
2008-04-12 19:59:18.051 Upgrading to schema version 1188
2008-04-12 19:59:18.058 Upgrading to schema version 1189
2008-04-12 19:59:18.068 Upgrading to schema version 1190
2008-04-12 19:59:18.141 Upgrading to schema version 1191
2008-04-12 19:59:18.150 Upgrading to schema version 1192
2008-04-12 19:59:18.162 Upgrading to schema version 1193
2008-04-12 19:59:18.176 Upgrading to schema version 1194
2008-04-12 19:59:18.185 Upgrading to schema version 1195
2008-04-12 19:59:18.190 Upgrading to schema version 1196
2008-04-12 19:59:18.194 Upgrading to schema version 1197
2008-04-12 19:59:18.199 Upgrading to schema version 1198
2008-04-12 19:59:18.202 Upgrading to schema version 1199
2008-04-12 19:59:18.206 Upgrading to schema version 1200
2008-04-12 19:59:18.211 Upgrading to schema version 1201
2008-04-12 19:59:18.215 Upgrading to schema version 1202
2008-04-12 19:59:18.248 Upgrading to schema version 1203
2008-04-12 19:59:18.258 Upgrading to schema version 1204
2008-04-12 19:59:18.263 Upgrading to schema version 1205
2008-04-12 19:59:18.271 Upgrading to schema version 1206
2008-04-12 19:59:18.276 Upgrading to schema version 1207
2008-04-12 19:59:18.295 Upgrading to schema version 1208
2008-04-12 19:59:18.308 Upgrading to schema version 1209
2008-04-12 19:59:18.320 Upgrading to schema version 1210
2008-04-12 19:59:18.383 Upgrading to schema version 1211
2008-04-12 19:59:18.436 Upgrading to schema version 1212
2008-04-12 19:59:18.459 Upgrading to schema version 1213
2008-04-12 19:59:18.467 In 1213 upg
2008-04-12 19:59:18.469 Upgrading to schema version 1214
2008-04-12 19:59:18.472 Database Schema upgrade complete, unlocking.
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.
2008-04-13 10:04:44.162 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-13 10:04:44.241 Empty LocalHostName.
2008-04-13 10:04:44.261 Using localhost value of moe
2008-04-13 10:04:44.337 New DB connection, total: 1
2008-04-13 10:04:44.376 Connected to database 'mythconverg' at host: localhost
2008-04-13 10:04:44.386 Closing DB connection named 'DBManager0'
2008-04-13 10:04:44.395 Connected to database 'mythconverg' at host: localhost
2008-04-13 10:04:44.401 New DB connection, total: 2
2008-04-13 10:04:44.404 Connected to database 'mythconverg' at host: localhost
2008-04-13 10:04:44.410 Current Schema Version: 1214
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings
====================================

I'm starting to think these debian "atrpms" packages might be the
problem.  the clients are other distros (fedora, arch), and maybe
there's some incompatibility with the atrpms mythtv???