| Author |
Message |
|
RacerX
|
 Posted: Tue Jul 16, 2013 12:57 am |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
Trying to restore the database. I go thru the link in mythweb/system heath/select database and chose restore then press go. The script starts but then stops with this error Code: <type 'exceptions.NameError'> Python 2.7.3: /usr/bin/python2
Tue Jul 16 01:49:44 2013
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
/data/srv/httpd/htdocs/process.py in ()
315
316 #print mainpage % body
=> 317 selection=radio
318 myhost=hidden.lower()
319
selection undefined, radio undefined
<type 'exceptions.NameError'>: name 'radio' is not defined
args = ("name 'radio' is not defined",)
message = "name 'radio' is not defined"
Kinda stuck, I have the backups just no way to restore
|
|
| Top |
|
 |
|
jams
|
Posted: Tue Jul 16, 2013 7:54 am |
|
 |
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
Do you get the same error when attempting to use the other radio buttons..like maybe WOL ? (it's harmless)
Also the restore can be run from the command line.
/usr/LH/bin/lh_system_restore_job $filename cleanup
$filename is the name or the file to restore WITHOUT the full path, just the filename
The file must be in /data/storage/disk0/backup/system_backups
|
|
| Top |
|
|
|
jams
|
Posted: Tue Jul 16, 2013 8:11 am |
|
|
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
Looks like that error is showing up because the submitted form is blank. What browser are you using?
|
|
| Top |
|
|
|
RacerX
|
Posted: Tue Jul 16, 2013 11:00 am |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
Using command line instead of Chromium Mythweb as root Code: /usr/LH/bin/lh_system_restore_job backup.2013-07-13_21-50.tgz cleanup script works fine but when I reboot "Waiting for connection to MythBackend" over and over manually run Code: mythfrontend the select your country flags come out In the command line it says Code: 2013-07-16 11:43:12.955105 E Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname IS NULL
2013-07-16 11:43:12.955124 E Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.settings' doesn't exist
|
|
| Top |
|
|
|
jams
|
Posted: Tue Jul 16, 2013 11:12 am |
|
|
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
So either the database didn't restore or it's pointing to the wrong address.
What do these commands show
mysql -e "show databases"
mysql mythconverg -e "show tables"
|
|
| Top |
|
|
|
RacerX
|
Posted: Tue Jul 16, 2013 11:34 am |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
Code: mysql -e "show databases Code: Database |
+---------------------+
| information_schema |
| #mysql50#lost+found |
| mysql |
| mythconverg |
| ncid |
| performance_schema |
| test |
+---------------------+ Code: mysql mythconverg -e "show tables" Code: +---------------------------+
| Tables_in_mythconverg |
+---------------------------+
| archiveitems |
| callsignnetworkmap |
| capturecard |
| cardinput |
| channel |
| channelgroup |
| channelgroupnames |
| channelscan |
| channelscan_channel |
| channelscan_dtv_multiplex |
| codecparams |
| credits |
| customexample |
| diseqc_config |
| diseqc_tree |
| displayprofilegroups |
| dtv_multiplex |
| dtv_privatetypes |
| dvdbookmark |
| dvdinput |
| dvdtranscode |
| eit_cache |
| filemarkup |
| gallerymetadata |
| gamemetadata |
| gameplayers |
| housekeeping |
| inputgroup |
| internetcontent |
| internetcontentarticles |
| inuseprograms |
| jobqueue |
| jumppoints |
| jumppoints_default_1 |
| jumppoints_default_2 |
| jumppoints_user1 |
| jumppoints_user2 |
| jumppoints_user3 |
| keybindings |
| keybindings_default_1 |
| keybindings_default_2 |
| keybindings_user1 |
| keybindings_user2 |
| keybindings_user3 |
| keyword |
| livestream |
| logging |
| schemalock |
+---------------------------+
|
|
| Top |
|
|
|
jams
|
Posted: Tue Jul 16, 2013 11:40 am |
|
|
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
The mythconverg database looks like half the tables are there which is the problem.
Do you have another file that you could restore from?
|
|
| Top |
|
|
|
RacerX
|
Posted: Tue Jul 16, 2013 12:24 pm |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
/usr/LH/bin/lh_system_restore_job backup.2013-07-08_01-03.tgz cleanup Code: mysql -e "show databases Code: +---------------------+
| Database |
+---------------------+
| information_schema |
| #mysql50#lost+found |
| mysql |
| mythconverg |
| ncid |
| performance_schema |
| test |
+---------------------+ Code: mysql mythconverg -e "show tables" Code: +---------------------------+
| Tables_in_mythconverg |
+---------------------------+
| archiveitems |
| callsignnetworkmap |
| capturecard |
| cardinput |
| channel |
| channelgroup |
| channelgroupnames |
| channelscan |
| channelscan_channel |
| channelscan_dtv_multiplex |
| codecparams |
| credits |
| customexample |
| diseqc_config |
| diseqc_tree |
| displayprofilegroups |
| displayprofiles |
| dtv_multiplex |
| dtv_privatetypes |
| dvdbookmark |
| dvdinput |
| dvdtranscode |
| eit_cache |
| filemarkup |
| gallerymetadata |
| gamemetadata |
| gameplayers |
| housekeeping |
| inputgroup |
| internetcontent |
| internetcontentarticles |
| inuseprograms |
| jobqueue |
| jumppoints |
| jumppoints_default_1 |
| jumppoints_default_2 |
| jumppoints_user1 |
| jumppoints_user2 |
| jumppoints_user3 |
| keybindings |
| keybindings_default_1 |
| keybindings_default_2 |
| keybindings_user1 |
| keybindings_user2 |
| keybindings_user3 |
| keyword |
| livestream |
| logging |
| schemalock |
+---------------------------+
Code: ls -l /data/storage/disk0/backup/system_backups/ Code: total 10963096
drwxr-xr-x 5 root root 130 Jul 14 22:56 2013-07-14_22-56
-rw-r--r-- 1 root root 1217402008 Jul 3 22:26 backup.2013-07-03_22-23.tgz
-rw-r--r-- 1 root root 1218068004 Jul 4 21:15 backup.2013-07-04_21-13.tgz
-rw-r--r-- 1 root root 1755212081 Jul 6 22:20 backup.2013-07-06_22-16.tgz
-rw-r--r-- 1 root root 1755015631 Jul 8 01:07 backup.2013-07-08_01-03.tgz
-rw-r--r-- 1 root root 1757406802 Jul 13 21:54 backup.2013-07-13_21-50.tgz
-rw-r--r-- 1 root root 1761941667 Jul 16 01:12 backup.2013-07-16_01-08.tgz
-rw-r--r-- 1 root root 1761145209 Jul 16 01:21 backup.2013-07-16_01-17.tgz
-rw-r--r-- 1 root root 20 Jul 16 01:29 backup.2013-07-16_01-26.tgz
drwxr-xr-x 3 root root 125 Jul 16 13:05 restore
still stuck
|
|
| Top |
|
|
|
RacerX
|
Posted: Wed Jul 17, 2013 4:36 pm |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
Update Today completely reloaded my system from scratch. Then restored backup.2013-07-04_21-13,tgz This is what occurs at the beginning of the system restore. Code: /usr/LH/bin/lh_system_restore_job backup.2013-07-04_21-13.tgz cleanup
Full restore
---------------------------------
Stopping mythbackend
Restoring database 2013-07-04_21-13
Restore of mythconverg complete
ERROR 1008 (HY000) at line 1: Can't drop database 'ncid'; database doesn't exist
Restoring database 2013-07-04_21-13
Restore of ncid complete
Starting mythbackend
*** WILL RUN ALL MODULES ***
____Start of network____
Setting up the network
Checking nss-mdns for install
nss-mdns is already installed, will not install
Unfortunately doesn't work and wrecks mythconverge. Back to the flags again UGH! Next I decided to restore today's backup. This one has nothing in the database and it restores correctly. So still unable to restore database 
|
|
| Top |
|
|
|
jams
|
Posted: Thu Jul 18, 2013 7:44 am |
|
|
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
Would you be able to send me one of the backup files that doesn't work?
|
|
| Top |
|
|
|
RacerX
|
Posted: Thu Jul 18, 2013 12:23 pm |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
|
Point me to the link then I will upload the backup to you....
|
|
| Top |
|
|
|
jams
|
Posted: Thu Jul 18, 2013 2:05 pm |
|
|
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
Assuming the file is less the 50MB Email it to jams at linhes.org
|
|
| Top |
|
|
|
RacerX
|
Posted: Thu Jul 18, 2013 2:55 pm |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
Code: [quote]Select all
total 10963096
drwxr-xr-x 5 root root 130 Jul 14 22:56 2013-07-14_22-56
-rw-r--r-- 1 root root 1217402008 Jul 3 22:26 backup.2013-07-03_22-23.tgz
-rw-r--r-- 1 root root 1218068004 Jul 4 21:15 backup.2013-07-04_21-13.tgz
-rw-r--r-- 1 root root 1755212081 Jul 6 22:20 backup.2013-07-06_22-16.tgz
-rw-r--r-- 1 root root 1755015631 Jul 8 01:07 backup.2013-07-08_01-03.tgz
-rw-r--r-- 1 root root 1757406802 Jul 13 21:54 backup.2013-07-13_21-50.tgz
-rw-r--r-- 1 root root 1761941667 Jul 16 01:12 backup.2013-07-16_01-08.tgz
-rw-r--r-- 1 root root 1761145209 Jul 16 01:21 backup.2013-07-16_01-17.tgz
-rw-r--r-- 1 root root 20 Jul 16 01:29 backup.2013-07-16_01-26.tgz
drwxr-xr-x 3 root root 125 Jul 16 13:05 restore[/quote]
|
|
| Top |
|
|
|
jams
|
Posted: Thu Jul 18, 2013 3:42 pm |
|
|
| Site Admin |
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
|
|
if you unzip one of those files how large is mythconverg ?
|
|
| Top |
|
|
|
RacerX
|
Posted: Thu Jul 18, 2013 4:48 pm |
|
|
Joined: Sun Sep 05, 2004 7:06 pm
Posts: 690
|
Code: total 1268240
-rw-r--r-- 1 root root 44500545 Jul 5 02:13 all_databases
drwxrwxr-x 88 root root 8192 Jun 24 17:20 etc
-rw-r--r-- 1 root root 1209651649 Jul 5 02:14 home_dir.tar.gz
-rw-r--r-- 1 root root 2964319 Jul 5 02:13 mysql_table
-rw-r--r-- 1 root root 41537003 Jul 5 02:13 mythconverg
-rw-r--r-- 1 root root 2018 Jul 5 02:13 ncid
drwxr-xr-x 3 root root 23 Jun 8 19:37 pki
drwxr-xr-x 4 root root 45 Jun 8 19:37 settings
|
|
| Top |
|
|
View unanswered posts
View active topics
Print view
Previous topic Next topic 
LinHES Home
Board index
FAQ
Search
Login 
Register