[mythtv-users] MYSQL problems on upgrade to ubuntu 16.04

Sun Aug 28 17:06:58 UTC 2016

I decided to take the plunge, and upgraded  backend to 16.04.

|sudo do-release-upgrade|

|is the command I used.|

|I don't believe MYSQL server is running:
|

|When the backend came back up, mythbackend will not start.|

|Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I 
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Hangup 
handler
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: N thread_unknown 
mythdirs.cpp:192 (InitializeMythDirs) Using runtime prefix = /usr
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: N thread_unknown 
mythdirs.cpp:194 (InitializeMythDirs) Using configuration directory = 
/home/mythtv/.mythtv
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I CoreContext 
mythcorecontext.cpp:266 (Init) Assumed character encoding: en_US.UTF-8
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: N CoreContext 
mythcontext.cpp:505 (LoadDatabaseSettings) Empty LocalHostName.
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I CoreContext 
mythcontext.cpp:513 (LoadDatabaseSettings) Using localhost value of amethi
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: E CoreContext 
mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable to connect to database!
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)
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: C CoreContext 
main.cpp:132 (main) Failed to init MythContext.
Aug 28 11:25:28 amethi mythbackend: mythbackend[10753]: I LogForward 
loggingserver.cpp:295 (SyslogLogger) Added syslogging|

|
|

|
I have backups of the database:|

|ythuser at amethi:/mnt/media3/backups/mythtv$ ls -l
total 874384
-rw-rw-r-- 1 mythuser mythuser 89373125 Aug 20 02:14 
mythconverg-1317-20160820021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 88390111 Aug 21 02:14 
mythconverg-1317-20160821021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 89734827 Aug 22 02:14 
mythconverg-1317-20160822021401.sql.gz
-rw-r--r-- 1 root     root     89734842 Aug 22 07:41 
mythconverg-1317-20160822074111.sql.gz
-rw-rw-r-- 1 mythuser mythuser 89706166 Aug 23 02:14 
mythconverg-1317-20160823021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 89987519 Aug 24 02:14 
mythconverg-1317-20160824021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 90054763 Aug 25 02:14 
mythconverg-1317-20160825021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 89875693 Aug 26 02:14 
mythconverg-1317-20160826021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 89164046 Aug 27 02:14 
mythconverg-1317-20160827021401.sql.gz
-rw-rw-r-- 1 mythuser mythuser 89330018 Aug 28 02:14 
mythconverg-1317-20160828021401.sql.gz|

|
|

|but cannot figure out how to restore them.|

|mythuser at amethi:/usr/share/mythtv$ perl mythconverg_restore.pl --verbose

Configuring environment:
   -    username: mythuser
   -        HOME: /home/mythuser
   - MYTHCONFDIR: /home/mythuser/.mythtv

Parsing configuration files:
   - checking: /home/mythuser/.mythtv/config.xml
      parsing: /home/mythuser/.mythtv/config.xml
   - checking: /home/mythuser/.mythtv/backuprc
      parsing: /home/mythuser/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

No filename specified. Attempting to find the newest database backup.
Using database backup file:
/mnt/media3/backups/mythtv/mythconverg-1317-20160828021401.sql.gz

Database Information:
          DBHostName: amethi
              DBPort: 3306
          DBUserName: mythtv
          DBPassword: XXX
              DBName: mythconverg
         DBSchemaVer:
   DBBackupDirectory: /mnt/media3/backups/mythtv
    DBBackupFilename: mythconverg-1317-20160828021401.sql.gz
       drop_database: no
     create_database: no

Executables:
        mysql_client: mysql
          uncompress: gzip -d

Miscellaneous:
     partial_restore: no
    restore_xmltvids: no
     change_hostname: no

Checking database.

Unable to connect to database.
            database: mythconverg
                host: amethi
            username: mythtv
            password: mythtv

Please check your configuration files to verify the database connection
information is correct.  The files that are used to retrieve connection
information are prefixed with "parsing" in the "Parsing configuration files"
section of the --verbose output.

Also note that any [client] or [mysql] password specified in the MySQL 
options
file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take 
precedence over
the password specified in the MythTV configuration files.

ERROR: Unable to connect to database.
|

|and
|

|
|

|mythuser at amethi:/usr/share/mythtv$ cat /etc/mysql/my.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

|

|
|

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160828/baf76f6b/attachment.html>