LinHES Forums :: View topic - Help My upgrade has gone horribly wrong

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]#

Author:	simonf [ Thu Aug 05, 2010 3:57 pm ]
Post subject:	Help My upgrade has gone horribly wrong
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

Author:	simonf [ Thu Aug 05, 2010 4:12 pm ]
Post subject:	A bit more info
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]#

Author:	simonf [ Thu Aug 05, 2010 7:21 pm ]
Post subject:
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

LinHES Forums http://forums.linhes.org/

Help My upgrade has gone horribly wrong http://forums.linhes.org/viewtopic.php?f=21&t=21269	Page 1 of 1

Page 1 of 1	All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/