<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>I decided to take the plunge, and upgraded backend to 16.04.</p>
<p><br>
</p>
<p><code>sudo do-release-upgrade</code></p>
<p><code>is the command I used.</code></p>
<p><code>I don't believe MYSQL server is running:<br>
</code></p>
<p><code>When the backend came back up, mythbackend will not start.</code></p>
<p><code>Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
Hangup handler<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: N
thread_unknown mythdirs.cpp:192 (InitializeMythDirs) Using
runtime prefix = /usr<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: N
thread_unknown mythdirs.cpp:194 (InitializeMythDirs) Using
configuration directory = /home/mythtv/.mythtv<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I
CoreContext mythcorecontext.cpp:266 (Init) Assumed character
encoding: en_US.UTF-8<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: N
CoreContext mythcontext.cpp:505 (LoadDatabaseSettings) Empty
LocalHostName.<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I
CoreContext mythcontext.cpp:513 (LoadDatabaseSettings) Using
localhost value of amethi<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: E
CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable
to connect to database!<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: E
CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was
[1/2002]:#012QMYSQL: Unable to connect#012Database error
was:#012Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: C
CoreContext main.cpp:132 (main) Failed to init MythContext.<br>
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I
LogForward loggingserver.cpp:295 (SyslogLogger) Added syslogging</code></p>
<p><code><br>
</code></p>
<p><code><br>
I have backups of the database:</code></p>
<p><code>ythuser@amethi:/mnt/media3/backups/mythtv$ ls -l<br>
total 874384<br>
-rw-rw-r-- 1 mythuser mythuser 89373125 Aug 20 02:14
mythconverg-1317-20160820021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 88390111 Aug 21 02:14
mythconverg-1317-20160821021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 89734827 Aug 22 02:14
mythconverg-1317-20160822021401.sql.gz<br>
-rw-r--r-- 1 root root 89734842 Aug 22 07:41
mythconverg-1317-20160822074111.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 89706166 Aug 23 02:14
mythconverg-1317-20160823021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 89987519 Aug 24 02:14
mythconverg-1317-20160824021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 90054763 Aug 25 02:14
mythconverg-1317-20160825021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 89875693 Aug 26 02:14
mythconverg-1317-20160826021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 89164046 Aug 27 02:14
mythconverg-1317-20160827021401.sql.gz<br>
-rw-rw-r-- 1 mythuser mythuser 89330018 Aug 28 02:14
mythconverg-1317-20160828021401.sql.gz</code></p>
<p><code><br>
</code></p>
<p><code>but cannot figure out how to restore them.</code></p>
<p><code>mythuser@amethi:/usr/share/mythtv$ perl
mythconverg_restore.pl --verbose<br>
<br>
Configuring environment:<br>
- username: mythuser<br>
- HOME: /home/mythuser<br>
- MYTHCONFDIR: /home/mythuser/.mythtv<br>
<br>
Parsing configuration files:<br>
- checking: /home/mythuser/.mythtv/config.xml<br>
parsing: /home/mythuser/.mythtv/config.xml<br>
- checking: /home/mythuser/.mythtv/backuprc<br>
parsing: /home/mythuser/.mythtv/backuprc<br>
<br>
Applying command-line arguments.<br>
<br>
Checking configuration.<br>
<br>
No filename specified. Attempting to find the newest database
backup.<br>
Using database backup file:<br>
/mnt/media3/backups/mythtv/mythconverg-1317-20160828021401.sql.gz<br>
<br>
Database Information:<br>
DBHostName: amethi<br>
DBPort: 3306<br>
DBUserName: mythtv<br>
DBPassword: XXX<br>
DBName: mythconverg<br>
DBSchemaVer: <br>
DBBackupDirectory: /mnt/media3/backups/mythtv<br>
DBBackupFilename: mythconverg-1317-20160828021401.sql.gz<br>
drop_database: no<br>
create_database: no<br>
<br>
Executables:<br>
mysql_client: mysql<br>
uncompress: gzip -d<br>
<br>
Miscellaneous:<br>
partial_restore: no<br>
restore_xmltvids: no<br>
change_hostname: no<br>
<br>
Checking database.<br>
<br>
Unable to connect to database.<br>
database: mythconverg<br>
host: amethi<br>
username: mythtv<br>
password: mythtv<br>
<br>
Please check your configuration files to verify the database
connection<br>
information is correct. The files that are used to retrieve
connection<br>
information are prefixed with "parsing" in the "Parsing
configuration files"<br>
section of the --verbose output.<br>
<br>
Also note that any [client] or [mysql] password specified in the
MySQL options<br>
file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take
precedence over<br>
the password specified in the MythTV configuration files.<br>
<br>
ERROR: Unable to connect to database.<br>
</code></p>
<p><code>and <br>
</code></p>
<p><code><br>
</code></p>
<p><code>mythuser@amethi:/usr/share/mythtv$ cat /etc/mysql/my.cnf<br>
# The MariaDB configuration file<br>
#<br>
# The MariaDB/MySQL tools read configuration files in the
following order:<br>
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global
defaults,<br>
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.<br>
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only
options.<br>
# 4. "~/.my.cnf" to set user-specific options.<br>
#<br>
# If the same option is defined multiple times, the last one
will apply.<br>
#<br>
# One can use all long options that the program supports.<br>
# Run program with --help to get a list of available options and
with<br>
# --print-defaults to see which it would actually understand and
use.<br>
<br>
#<br>
# This group is read both both by the client and the server<br>
# use it for options that affect everything<br>
#<br>
[client-server]<br>
<br>
# Import all .cnf files from configuration directory<br>
!includedir /etc/mysql/conf.d/<br>
!includedir /etc/mysql/mariadb.conf.d/<br>
<br>
</code></p>
<p><code><br>
</code></p>
<p><br>
</p>
</body>
</html>