Sanity checking your restore...

Checking for the existance of the backup tar file...
Using file /myth/backup/savedfiles.tar.gz
Backup tar file exists. Checking the compression...
Compression looks OK. Checking backup tar file contents...
Generating a list of the backup contents...
/bin/tar: ./etc/asound.conf: Not found in archive
/bin/tar: ./etc/default/aumix: Not found in archive
Generating a list of the directory contents...
/usr/bin/find: ./etc/asound.conf: No such file or directory
/usr/bin/find: ./etc/default/aumix: No such file or directory
/usr/bin/find: ./var/lib/alsa/asound.state: No such file or directory
Comparing directory versus backup contents...
Live and saved file lists match.

Checking for the existance of the DB dump file...
Using file /myth/backup/mythconverg.sql.gz
DB dump file exists. Checking the compression...
Compression looks OK. Checking DB dump contents...
Generating a list of tables and record counts in the DB dump...
Generating a list of tables and record counts in the live DB...
Comparing live versus saved tables...
Live and saved table lists match.

Restore passes all checks.
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
................................................................................

No UPnP backends found

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [192.168.0.4]
[console is not interactive, using default '192.168.0.4']
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']

Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [192.168.0.4]
[console is not interactive, using default '192.168.0.4']
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']

root@black2:~/scripts/backup# cat test_fixups.sh
#!/bin/bash

PYTHONPATH=/usr/local/bin /usr/bin/python <<'EOF'

import os, file_editor

# This one is a doozy... Note we're only opening /etc/mythtv/mysql.txt to
# get the hostname (which we give precendence) and don't make any changes
# unless the other two files are inconsistent.

p0 = '^DBHostName='
p1 = '[A-Za-z0-9.-]+'  # Matches a hostname
p2 = '^[ \t]*setenv[ \t]+db_server[ \t]+"'
p3 = '^[ \t]*bind-address[ \t]*=[ \t]*'

noed = file_editor.file_editor("/etc/mythtv/mysql.txt")
hostbeg = noed.re_find(p0, 0, file_editor.AFTER)
hostend = noed.re_find(p1, hostbeg, file_editor.AFTER)
hostname = noed.text[hostbeg:hostend].strip()
noed.close()

if hostname.lower() not in ('localhost', '127.0.0.1'):
    print "Fixing /etc/mythtv/mythweb-htaccess and /etc/mysql/my.cnf"
    # OK, so we need to make sure everything else matches...
    ed = file_editor.file_editor("/etc/mythtv/mythweb-htaccess")
    if ed.re_find(p2 + hostname + '"') is None:
        print "Changing /etc/mythtv/mythweb-htaccess"
        ed.re_replace('(' + p2 + ')' + p1 + '(")', '\\1' + hostname + '\\2')
    ed.close()

    ed = file_editor.file_editor("/etc/mysql/my.cnf")
    if ed.re_find(p3 + hostname) is None:
        print "Changing /etc/mysql/my.cnf"
        ed.re_replace('(' + p3 + ')' + p1, '\\1' + hostname)
    ed.close()

EOF