View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Thu Aug 05, 2010 3:57 pm 
Offline
Joined: Wed Nov 09, 2005 1:21 pm
Posts: 161
Location: Manchester UK
I ran the upgrade-linhes script today and it went horibly wrong

It was doing the schema update and came up with the following error

I carried on with it and rebooted only to find my backend no longer starts, is there anyway to repair the database, I have no tv without the backend and the wife is giving me daggers..

I don't know what I was upgrading from I last did an update about 3 months ago...




Code:
login as: root
root@mythtv's password:
Access denied
root@mythtv's password:
Last login: Thu Aug  5 22:34:05 2010 from unknown-00-1c-bf-7a-f2-79.config
[root@mythtv ~]# cd /
[root@mythtv /]# ls
bin   data  etc      home  lost+found  mnt   opt   root  srv  tmp  var
boot  dev   etc.old  lib   media       myth  proc  sbin  sys  usr
[root@mythtv /]# cd usr
[root@mythtv usr]# cd var
[root@mythtv var]# ls
cache  empty  games  lib  local  lock  log  mail  opt  run  service  spool  tmp
[root@mythtv var]# cd log
[root@mythtv log]# ls
Xorg.0.log      errors.log        lircd                    soundon.log
Xorg.0.log.old  errors.log.1      lircd.1                  sv
acpid.log       errors.log.2      lircd.2                  syslog.log
acpid.log.1     errors.log.3      lircd.3                  syslog.log.1
acpid.log.2     errors.log.4      lircd.4                  syslog.log.2
acpid.log.3     everything.log    messages.log             syslog.log.3
acpid.log.4     everything.log.1  messages.log.1           syslog.log.4
auth.log        everything.log.2  messages.log.2           user.log
auth.log.1      everything.log.3  messages.log.3           user.log.1
auth.log.2      everything.log.4  messages.log.4           user.log.2
auth.log.3      faillog           mysqld.log               user.log.3
auth.log.4      fluxbox.log       mythtv                   user.log.4
btmp            kernel.log        mythvantage_install.log  utmp
daemon.log      kernel.log.1      network.init             webmin
daemon.log.1    kernel.log.2      network.init.error       wtmp
daemon.log.2    kernel.log.3      old                      wtmp.1
daemon.log.3    kernel.log.4      pacman.log
daemon.log.4    lastlog           sa
dmesg.log       lighttpd          samba
[root@mythtv log]# cd mythtv
[root@mythtv mythtv]# ls
hulu_grabber.log      mythbackend.log.4.gz  mythfrontend.log.1.gz
myth2x264.log         mythbackend.log.5.gz  mythfrontend.log.2.gz
myth_mtc.log          mythbackend.log.6.gz  mythfrontend.log.3.gz
mythbackend.log       mythbackend.log.7.gz  mythfrontend.log.4.gz
mythbackend.log.1.gz  mythexport.log        mythfrontend.log.5.gz
mythbackend.log.2.gz  mythfilldatabase.log  mythfrontend.log.6.gz
mythbackend.log.3.gz  mythfrontend.log      mythfrontend.log.7.gz
[root@mythtv mythtv]# vi mythbackend.log
2010-08-05 21:40:57.773 UPnpMedia: BuildMediaMap Done. Found 385 objects
2010-08-05 21:42:04.095 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2010-08-05 21:57:04.161 AutoExpire: CalcParams(): Max required Free Space: 1.0 GB w/freq: 15 min
2010-08-05 22:01:02.198 MainServer::ANN Monitor
2010-08-05 22:01:02.201 adding: mythtv as a client (events: 0)
2010-08-05 22:01:02.208 DB Error (ProgramList::FromRecorded):
Query was:
SELECT recorded.chanid,recorded.starttime,recorded.endtime,recorded.title,recorded.subtitle,recorded.description,recorded.hostname,channum,name,callsign,commflagged,cutlist,recorded.autoexpire,editing,bookmark,recorded.category,recorded.recgroup,record.dupin,record.dupmethod,recorded.recordid,channel.outputfilters,recorded.seriesid,recorded.programid,recorded.filesize, recorded.lastmodified, recorded.findid, recorded.originalairdate, recorded.playgroup, recorded.basename, recorded.progstart, recorded.progend, recorded.stars, recordedprogram.audioprop+0, recordedprogram.videoprop+0, recordedprogram.subtitletypes+0, recorded.watched, recorded.storagegroup, recorded.transcoded, recorded.recpriority, recorded.preserve, recordedprogram.airdate FROM recorded LEFT JOIN record ON recorded.recordid = record.recordid LEFT JOIN channel ON recorded.chanid = channel.chanid LEFT JOIN recordedprogram ON  ( recorded.chanid    = recordedprogram.chanid AND    recorded.progstart = recordedprogram.starttime ) WHERE (
~
-- VISUAL --                                        8         61887,1       Bot


This is what is in the backend log

_________________
Running:-
Intel 930 3GHz dual Core
Thermaltake Fanless CPU Cooler
Asus P5GS
Samsung 750G Sata HDD
8400 512m Video Card
2 * jetway DVB-t
1 * Haupage DVB-S2 Card
Samsung Sata 16x DVDRW
2048M Ram
1 * Netop Ion 330


Top
 Profile  
 
 Post subject: A bit more info
PostPosted: Thu Aug 05, 2010 4:12 pm 
Offline
Joined: Wed Nov 09, 2005 1:21 pm
Posts: 161
Location: Manchester UK
mysql seems to be pooched when I try to start the backend manually it dosn't start with a mysql error..

Code:
login as: root
root@mythtv's password:
Access denied
root@mythtv's password:
Last login: Thu Aug  5 22:34:05 2010 from unknown-00-1c-bf-7a-f2-79.config
[root@mythtv ~]# cd /
[root@mythtv /]# ls
bin   data  etc      home  lost+found  mnt   opt   root  srv  tmp  var
boot  dev   etc.old  lib   media       myth  proc  sbin  sys  usr
[root@mythtv /]# cd usr
[root@mythtv usr]# cd var
[root@mythtv var]# ls
cache  empty  games  lib  local  lock  log  mail  opt  run  service  spool  tmp
[root@mythtv var]# cd log
[root@mythtv log]# ls
Xorg.0.log      errors.log        lircd                    soundon.log
Xorg.0.log.old  errors.log.1      lircd.1                  sv
acpid.log       errors.log.2      lircd.2                  syslog.log
acpid.log.1     errors.log.3      lircd.3                  syslog.log.1
acpid.log.2     errors.log.4      lircd.4                  syslog.log.2
acpid.log.3     everything.log    messages.log             syslog.log.3
acpid.log.4     everything.log.1  messages.log.1           syslog.log.4
auth.log        everything.log.2  messages.log.2           user.log
auth.log.1      everything.log.3  messages.log.3           user.log.1
auth.log.2      everything.log.4  messages.log.4           user.log.2
auth.log.3      faillog           mysqld.log               user.log.3
auth.log.4      fluxbox.log       mythtv                   user.log.4
btmp            kernel.log        mythvantage_install.log  utmp
daemon.log      kernel.log.1      network.init             webmin
daemon.log.1    kernel.log.2      network.init.error       wtmp
daemon.log.2    kernel.log.3      old                      wtmp.1
daemon.log.3    kernel.log.4      pacman.log
daemon.log.4    lastlog           sa
dmesg.log       lighttpd          samba
[root@mythtv log]# cd mythtv
[root@mythtv mythtv]# ls
hulu_grabber.log      mythbackend.log.4.gz  mythfrontend.log.1.gz
myth2x264.log         mythbackend.log.5.gz  mythfrontend.log.2.gz
myth_mtc.log          mythbackend.log.6.gz  mythfrontend.log.3.gz
mythbackend.log       mythbackend.log.7.gz  mythfrontend.log.4.gz
mythbackend.log.1.gz  mythexport.log        mythfrontend.log.5.gz
mythbackend.log.2.gz  mythfilldatabase.log  mythfrontend.log.6.gz
mythbackend.log.3.gz  mythfrontend.log      mythfrontend.log.7.gz
[root@mythtv mythtv]# vi mythbackend.log
[root@mythtv mythtv]# mysql -umythtv -p mythconverg -e 'status;'
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
[root@mythtv mythtv]# mysql -u mythtv -p mythconverg -e 'status;'
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
[root@mythtv mythtv]#
[root@mythtv mythtv]# mysyl
-bash: mysyl: command not found
[root@mythtv mythtv]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
[root@mythtv mythtv]# mythbackend start
Invalid argument: start
mythbackend version: branches/release-0-23-fixes [25458] www.mythtv.org
Valid options are:
-h or --help                   List valid command line parameters
-l or --logfile filename       Writes STDERR and STDOUT messages to filename
-p or --pidfile filename       Write PID of mythbackend to filename
-d or --daemon                 Runs mythbackend as a daemon
-v or --verbose debug-level    Use '-v help' for level info
--setverbose debug-level       Change debug level of running master backend
--user username                Drop permissions to username after starting
--printexpire                  List of auto-expire programs
--printsched                   Upcoming scheduled programs
--testsched                    Test run scheduler (ignore existing schedule)
--resched                      Force the scheduler to update
--nosched                      Do not perform any scheduling
--noupnp                       Do not enable the UPNP server
--nojobqueue                   Do not start the JobQueue
--nohousekeeper                Do not start the Housekeeper
--noautoexpire                 Do not start the AutoExpire thread
--clearcache                   Clear the settings cache on all myth servers
-O or --override-setting KEY=VALUE
                               Force the setting named 'KEY' to value 'VALUE'
                               This option may be repeated multiple times
--override-settings-file <file>
                               File containing KEY=VALUE pairs for settings
                               Use a comma seperated list to return multiple values
--version                      Version information
--generate-preview             Generate a preview image
--upnprebuild                  Force an update of UPNP media
--infile                       Input file for preview generation
--outfile                      Optional output file for preview generation
--chanid                       Channel ID for preview generation
--starttime                    Recording start time for preview generation
--event EVENTTEXT              Send a backend event test message
--systemevent EVENTTEXT        Send a backend SYSTEM_EVENT test message

[root@mythtv mythtv]# mythbackend
2010-08-05 23:04:51.895 mythbackend version: branches/release-0-23-fixes [25458] www.mythtv.org
2010-08-05 23:04:51.895 Using runtime prefix = /usr
2010-08-05 23:04:51.896 Using configuration directory = /root/.mythtv
2010-08-05 23:04:51.903 DBHostName is not set in mysql.txt
2010-08-05 23:04:51.903 Assuming localhost
2010-08-05 23:04:51.903 Empty LocalHostName.
2010-08-05 23:04:51.903 Using localhost value of mythtv
2010-08-05 23:04:51.911 New DB connection, total: 1
2010-08-05 23:04:51.912 Unable to connect to database!
2010-08-05 23:04:51.912 Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

................................................................................
2010-08-05 23:04:54.471 UPnPautoconf() - No UPnP backends found
2010-08-05 23:04:54.471 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]
2010-08-05 23:05:38.414 Deleting UPnP client...
2010-08-05 23:05:39.026 Failed to init MythContext, exiting.
[root@mythtv mythtv]# mythbackend
2010-08-05 23:05:43.887 mythbackend version: branches/release-0-23-fixes [25458] www.mythtv.org
2010-08-05 23:05:43.888 Using runtime prefix = /usr
2010-08-05 23:05:43.888 Using configuration directory = /root/.mythtv
2010-08-05 23:05:43.888 DBHostName is not set in mysql.txt
2010-08-05 23:05:43.889 Assuming localhost
2010-08-05 23:05:43.889 Empty LocalHostName.
2010-08-05 23:05:43.889 Using localhost value of mythtv
2010-08-05 23:05:43.895 New DB connection, total: 1
2010-08-05 23:05:43.896 Unable to connect to database!
2010-08-05 23:05:43.896 Driver error was [1/2002]:
QMYSQL: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

2010-08-05 23:05:43.897 MCP::InitUPnP() - HttpServer Create Error
2010-08-05 23:05:43.897 Deleting UPnP client...
2010-08-05 23:05:43.897 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no]  yes
Database host name:  192.168.1.65
Should I test connectivity to this host using the ping command? [yes]  yes
Database non-default port: [0]
Database name: [mythconverg]
Database user name: [mythtv]
Database password: [mythtv]
Unique identifier for this machine (if empty, the local host name will be used):
Would you like to use Wake-On-LAN to retry database connections? [no]
2010-08-05 23:06:31.181 Writing settings file /root/.mythtv/mysql.txt
2010-08-05 23:06:31.181 Closing DB connection named 'DBManager0'
2010-08-05 23:06:31.181 Testing network connectivity to '192.168.1.65'
2010-08-05 23:06:31.192 Closing DB connection named 'DBManager0'
2010-08-05 23:06:31.193 Unable to connect to database!
2010-08-05 23:06:31.193 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.1.65' (111)

2010-08-05 23:06:31.193 Cannot login to database?
2010-08-05 23:06:31.193 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [no]  ^Z
[1]+  Stopped                 mythbackend
[root@mythtv mythtv]#

_________________
Running:-
Intel 930 3GHz dual Core
Thermaltake Fanless CPU Cooler
Asus P5GS
Samsung 750G Sata HDD
8400 512m Video Card
2 * jetway DVB-t
1 * Haupage DVB-S2 Card
Samsung Sata 16x DVDRW
2048M Ram
1 * Netop Ion 330


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 05, 2010 7:21 pm 
Offline
Joined: Wed Nov 09, 2005 1:21 pm
Posts: 161
Location: Manchester UK
I could not get to the files using samba to back them up

I could see the files but soon as i tried to copy them the network connection errored


so I decided to try to do an upgrade from disk

It failed at 98% prepairing for life

FAILED

Running SYSTEMCON????


I forgot to write down the wording


Any one got any ideas on how to install to this drive witout loosing the data

Gallery / Music / Video /TV are most important the Mysql DB I can live without

Ill just copy the tv files to the video directory and rename them as I open them

_________________
Running:-
Intel 930 3GHz dual Core
Thermaltake Fanless CPU Cooler
Asus P5GS
Samsung 750G Sata HDD
8400 512m Video Card
2 * jetway DVB-t
1 * Haupage DVB-S2 Card
Samsung Sata 16x DVDRW
2048M Ram
1 * Netop Ion 330


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 166 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