View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 4 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Thu Jul 09, 2009 11:15 am 
Offline
Joined: Thu Jul 09, 2009 11:05 am
Posts: 28
Hi all.

I'm attempting to upgrade R5F27 to R5.5 and am not achieving any success. cesman has been a big help in working with me so far in IRC but I still get errors during the auto upgrade.

My setup is a standalone box with two PVR-150 tuners, single 500gb hard drive, and snapstream remote. I've run and rerun the auto upgrade several times now and it seems to do the same thing. I have tried burning new cd media and even used the media verifier during the install.

Currently I am downloading the R6 iso but was wondering if we can save R5.5 while that is happening.

Thoughts? Thanks.
Code:
2009-07-09 09:00:03.707 Using runtime prefix = /usr
2009-07-09 09:00:03.774 Empty LocalHostName.
2009-07-09 09:00:03.775 Using localhost value of htpc
2009-07-09 09:00:03.828 New DB connection, total: 1
2009-07-09 09:00:03.834 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.835 Closing DB connection named 'DBManager0'
2009-07-09 09:00:03.836 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.860 New DB connection, total: 2
2009-07-09 09:00:03.861 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.863 Current Schema Version:
2009-07-09 09:00:03.864 DataDirectProcessor::FixProgramIDs() -- begin
2009-07-09 09:00:03.865 New DB DataDirect connection
2009-07-09 09:00:03.866 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.867 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

2009-07-09 09:00:03.868 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

2009-07-09 09:00:03.869 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunStart', '2009-07-09 09:00:03', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2009-07-09 09:00:03.870 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB Backups' AND hostname = 'htpc'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2009-07-09 09:00:03.871 New DB connection, total: 3
2009-07-09 09:00:03.872 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.873 SG(DB Backups) Error: Directory value for Default Storage Group is empty.  Using hardcoded default value of '/mnt/store'
2009-07-09 09:00:03.895 SG(DB Backups) Error: FindNextDirMostFree: '/mnt/store' does not exist!
2009-07-09 09:00:04.006 Database Backup filename: /tmp/mythconverg--20090709090003.sql.gz
2009-07-09 09:00:04.034 Database Backup complete.
2009-07-09 09:00:04.043 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

2009-07-09 09:00:04.046 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunEnd', '2009-07-09 09:00:04', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist

2009-07-09 09:00:04.058 No current database version. Auto upgrading
2009-07-09 09:00:04.059 Newest Schema Version : 1214
2009-07-09 09:00:04.068 Inserting MythTV initial database information.
2009-07-09 09:00:04.080 Upgrading to schema version 1112
2009-07-09 09:00:04.318 New DB connection, total: 4
2009-07-09 09:00:04.337 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:04.344 Upgrading to schema version 1113
2009-07-09 09:00:04.351 Upgrading to schema version 1114
2009-07-09 09:00:04.353 Upgrading to schema version 1115
2009-07-09 09:00:04.357 Upgrading to schema version 1116
2009-07-09 09:00:04.359 Upgrading to schema version 1117
2009-07-09 09:00:04.364 Upgrading to schema version 1118
2009-07-09 09:00:04.379 Upgrading to schema version 1119
2009-07-09 09:00:04.382 Upgrading to schema version 1120
2009-07-09 09:00:04.385 Upgrading to schema version 1121
2009-07-09 09:00:04.388 Upgrading to schema version 1122
2009-07-09 09:00:04.392 Upgrading to schema version 1123
2009-07-09 09:00:04.399 Upgrading to schema version 1124
2009-07-09 09:00:04.403 Upgrading to schema version 1125
2009-07-09 09:00:04.409 Upgrading to schema version 1126
2009-07-09 09:00:04.414 Upgrading to schema version 1127
2009-07-09 09:00:04.421 Upgrading to schema version 1128
2009-07-09 09:00:04.427 Upgrading to schema version 1129
2009-07-09 09:00:04.435 Upgrading to schema version 1130
2009-07-09 09:00:04.437 Upgrading to schema version 1131
2009-07-09 09:00:04.441 Upgrading to schema version 1132
2009-07-09 09:00:04.446 Upgrading to schema version 1133
2009-07-09 09:00:04.450 Upgrading to schema version 1134
2009-07-09 09:00:04.453 Upgrading to schema version 1135
2009-07-09 09:00:04.459 Upgrading to schema version 1136
2009-07-09 09:00:04.463 Upgrading to schema version 1137
2009-07-09 09:00:04.468 Upgrading to schema version 1138
2009-07-09 09:00:04.471 Upgrading to schema version 1139
2009-07-09 09:00:04.482 Upgrading to schema version 1140
2009-07-09 09:00:04.484 Upgrading to schema version 1141
2009-07-09 09:00:04.490 Upgrading to schema version 1142
2009-07-09 09:00:04.494 Upgrading to schema version 1143
2009-07-09 09:00:04.498 Upgrading to schema version 1144
2009-07-09 09:00:04.510 Upgrading to schema version 1145
2009-07-09 09:00:04.531 Upgrading to schema version 1146
2009-07-09 09:00:04.533 Upgrading to schema version 1147
2009-07-09 09:00:04.540 Upgrading to schema version 1148
2009-07-09 09:00:04.547 Upgrading to schema version 1149
2009-07-09 09:00:04.559 Upgrading to schema version 1150
2009-07-09 09:00:04.562 Upgrading to schema version 1151
2009-07-09 09:00:04.568 Upgrading to schema version 1152
2009-07-09 09:00:04.656 Upgrading to schema version 1153
2009-07-09 09:00:04.698 Upgrading to schema version 1154
2009-07-09 09:00:04.707 Upgrading to schema version 1155
2009-07-09 09:00:04.717 Upgrading to schema version 1156
2009-07-09 09:00:04.724 Upgrading to schema version 1157
2009-07-09 09:00:04.727 Upgrading to schema version 1158
2009-07-09 09:00:04.738 Upgrading to schema version 1159
2009-07-09 09:00:04.744 Upgrading to schema version 1160
2009-07-09 09:00:04.746 Upgrading to schema version 1161
2009-07-09 09:00:04.749 Upgrading to schema version 1162
2009-07-09 09:00:04.752 Upgrading to schema version 1163
2009-07-09 09:00:04.753 Upgrading to schema version 1164
2009-07-09 09:00:04.768 Upgrading to schema version 1165
2009-07-09 09:00:04.774 Upgrading to schema version 1166
2009-07-09 09:00:04.781 Upgrading to schema version 1167
2009-07-09 09:00:04.783 Upgrading to schema version 1168
2009-07-09 09:00:04.787 Upgrading to schema version 1169
2009-07-09 09:00:04.789 Upgrading to schema version 1170
2009-07-09 09:00:04.790 Upgrading to schema version 1171
2009-07-09 09:00:04.802 Upgrading to schema version 1172
2009-07-09 09:00:04.804 Upgrading to schema version 1173
2009-07-09 09:00:04.808 Upgrading to schema version 1174
2009-07-09 09:00:04.811 Upgrading to schema version 1175
2009-07-09 09:00:04.813 Upgrading to schema version 1176
2009-07-09 09:00:04.814 Upgrading to schema version 1177
2009-07-09 09:00:04.817 Upgrading to schema version 1178
2009-07-09 09:00:04.854 Upgrading to schema version 1179
2009-07-09 09:00:04.883 Upgrading to schema version 1180
2009-07-09 09:00:04.889 Upgrading to schema version 1181
2009-07-09 09:00:04.895 Upgrading to schema version 1182
2009-07-09 09:00:04.897 Upgrading to schema version 1183
2009-07-09 09:00:04.902 Upgrading to schema version 1184
2009-07-09 09:00:04.907 Upgrading to schema version 1185
2009-07-09 09:00:04.911 Upgrading to schema version 1186
2009-07-09 09:00:04.914 Upgrading to schema version 1187
2009-07-09 09:00:04.920 Upgrading to schema version 1188
2009-07-09 09:00:04.943 Upgrading to schema version 1189
2009-07-09 09:00:04.958 Upgrading to schema version 1190
2009-07-09 09:00:04.961 Upgrading to schema version 1191
2009-07-09 09:00:04.965 Upgrading to schema version 1192
2009-07-09 09:00:04.971 Upgrading to schema version 1193
2009-07-09 09:00:04.976 Upgrading to schema version 1194
2009-07-09 09:00:05.076 Upgrading to schema version 1195
2009-07-09 09:00:05.082 Upgrading to schema version 1196
2009-07-09 09:00:05.100 Upgrading to schema version 1197
2009-07-09 09:00:05.104 Upgrading to schema version 1198
2009-07-09 09:00:05.105 Upgrading to schema version 1199
2009-07-09 09:00:05.106 Upgrading to schema version 1200
2009-07-09 09:00:05.108 Upgrading to schema version 1201
2009-07-09 09:00:05.110 Upgrading to schema version 1202
2009-07-09 09:00:05.152 Upgrading to schema version 1203
2009-07-09 09:00:05.156 Upgrading to schema version 1204
2009-07-09 09:00:05.159 Upgrading to schema version 1205
2009-07-09 09:00:05.180 Upgrading to schema version 1206
2009-07-09 09:00:05.196 Upgrading to schema version 1207
2009-07-09 09:00:05.233 Upgrading to schema version 1208
2009-07-09 09:00:05.245 Upgrading to schema version 1209
2009-07-09 09:00:05.249 Upgrading to schema version 1210
2009-07-09 09:00:05.268 Upgrading to schema version 1211
2009-07-09 09:00:05.286 Upgrading to schema version 1212
2009-07-09 09:00:05.289 Upgrading to schema version 1213
2009-07-09 09:00:05.291 In 1213 upg
2009-07-09 09:00:05.293 Upgrading to schema version 1214
2009-07-09 09:00:05.293 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.
2009-07-09 09:43:38.371 Using runtime prefix = /usr
2009-07-09 09:43:38.396 Empty LocalHostName.
2009-07-09 09:43:38.402 Using localhost value of htpc
2009-07-09 09:43:38.446 New DB connection, total: 1
2009-07-09 09:43:38.457 Unable to connect to database!
2009-07-09 09:43:38.464 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
2009-07-09 09:43:38.819 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-09 09:44:43.674 Using runtime prefix = /usr
2009-07-09 09:44:43.728 Empty LocalHostName.
2009-07-09 09:44:43.740 Using localhost value of htpc
2009-07-09 09:44:43.827 New DB connection, total: 1
2009-07-09 09:44:43.835 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.837 Closing DB connection named 'DBManager0'
2009-07-09 09:44:43.838 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.859 New DB connection, total: 2
2009-07-09 09:44:43.860 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.874 Current Schema Version: 1214
2009-07-09 09:44:43.875 DataDirectProcessor::FixProgramIDs() -- begin
2009-07-09 09:44:43.876 New DB DataDirect connection
2009-07-09 09:44:43.877 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.878 DataDirectProcessor::FixProgramIDs() -- end
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.
2009-07-09 10:01:07.274 Using runtime prefix = /usr
2009-07-09 10:01:07.293 Empty LocalHostName.
2009-07-09 10:01:07.294 Using localhost value of htpc
2009-07-09 10:01:07.336 New DB connection, total: 1
2009-07-09 10:01:07.345 Unable to connect to database!
2009-07-09 10:01:07.347 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'sending password information', system error: 32

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:07.399 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
................................................................................
2009-07-09 10:01:09.900 UPnPautoconf() - No UPnP backends found
2009-07-09 10:01:09.901 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:09.909 Writing settings file /home/mythtv/.mythtv/mysql.txt
2009-07-09 10:01:09.910 Closing DB connection named 'DBManager0'
2009-07-09 10:01:09.911 Unable to connect to database!
2009-07-09 10:01:09.911 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
2009-07-09 10:01:09.962 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-09 10:01:10.013 Cannot login to database?
2009-07-09 10:01:10.013 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.021 Unable to connect to database!
2009-07-09 10:01:10.021 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
2009-07-09 10:01:10.073 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-09 10:01:10.123 Cannot login to database?
2009-07-09 10:01:10.124 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.132 Unable to connect to database!
2009-07-09 10:01:10.132 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
2009-07-09 10:01:10.183 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-09 10:01:10.234 Cannot login to database?
2009-07-09 10:01:10.234 Cannot login to database?
Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.242 Unable to connect to database!
2009-07-09 10:01:10.243 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
2009-07-09 10:01:10.295 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-09 10:01:10.345 Cannot login to database?
2009-07-09 10:01:10.346 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.354 Unable to connect to database!
2009-07-09 10:01:10.354 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
2009-07-09 10:01:10.405 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2009-07-09 10:01:10.456 Cannot login to database?
2009-07-09 10:01:10.457 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.475 Unable to connect to database!
2009-07-09 10:01:10.476 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)

[/code]


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 09, 2009 4:35 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
Check out this thread, it should solve your problem.

http://mysettopbox.tv/phpBB2/viewtopic.php?t=18548&highlight=

Good luck!


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 09, 2009 5:42 pm 
Offline
Joined: Thu Jul 09, 2009 11:05 am
Posts: 28
turns out the main problem i had was that my fstab file got borked somewhere during this ordeal.

/dev/hda3 was mounting to /media instead of /myth

we changed the fstab entry, remounted /dev/hda3 then reran mythrestore

then I had to run mythtv-setup and set the local backend and master backend to my public ip instead of localhost (127.0.0.1).

after the above changes, the backend finally started.

Next up was the tuners. They had to be remapped, which wasnt a big issue.

Third is now the remote and lirc. Still working on that :)

Cecil has been amazing at helping me troubleshoot this so big props goes out to him for that.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 15, 2009 2:21 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
:) Happy to have been able to help. Thanks for using KnoppMyth and sticking with us.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu