Personal tools
You are here: Home Linux MythTV Onyx, a CentOS 7.x MySQL Server for MythTV
 

Onyx, a CentOS 7.x MySQL Server for MythTV

Quick notes on upgrade of the MySQL server for MythTV (was on CentOS 6).

 

mariadb-server

Install the mariadb package (was mysql):

# systemctl enable mariadb
# systemctl start mariadb

Apply the timezones to the 'mysql' database using the root identity (add a '-p' option if the root user has a password):

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Links

Appendices

Yum install mariadb-server

Dependencies Resolved

=====================================================================================================
 Package                          Arch            Version                     Repository        Size
=====================================================================================================
Installing:
 mariadb-server                   x86_64          1:5.5.37-1.el7_0            updates           11 M
Installing for dependencies:
 libaio                           x86_64          0.3.109-12.el7              base              24 k
 mariadb                          x86_64          1:5.5.37-1.el7_0            updates          8.9 M
 perl                             x86_64          4:5.16.3-283.el7            base             8.0 M
 perl-Carp                        noarch          1.26-244.el7                base              19 k
 perl-Compress-Raw-Bzip2          x86_64          2.061-3.el7                 base              32 k
 perl-Compress-Raw-Zlib           x86_64          1:2.061-4.el7               base              57 k
 perl-DBD-MySQL                   x86_64          4.023-5.el7                 base             140 k
 perl-DBI                         x86_64          1.627-4.el7                 base             802 k
 perl-Data-Dumper                 x86_64          2.145-3.el7                 base              47 k
 perl-Encode                      x86_64          2.51-7.el7                  base             1.5 M
 perl-Exporter                    noarch          5.68-3.el7                  base              28 k
 perl-File-Path                   noarch          2.09-2.el7                  base              26 k
 perl-File-Temp                   noarch          0.23.01-3.el7               base              56 k
 perl-Filter                      x86_64          1.49-3.el7                  base              76 k
 perl-Getopt-Long                 noarch          2.40-2.el7                  base              56 k
 perl-HTTP-Tiny                   noarch          0.033-3.el7                 base              38 k
 perl-IO-Compress                 noarch          2.061-2.el7                 base             260 k
 perl-Net-Daemon                  noarch          0.48-5.el7                  base              51 k
 perl-PathTools                   x86_64          3.40-5.el7                  base              82 k
 perl-PlRPC                       noarch          0.2020-14.el7               base              36 k
 perl-Pod-Escapes                 noarch          1:1.04-283.el7              base              49 k
 perl-Pod-Perldoc                 noarch          3.20-4.el7                  base              87 k
 perl-Pod-Simple                  noarch          1:3.28-4.el7                base             216 k
 perl-Pod-Usage                   noarch          1.63-3.el7                  base              27 k
 perl-Scalar-List-Utils           x86_64          1.27-248.el7                base              36 k
 perl-Socket                      x86_64          2.010-3.el7                 base              49 k
 perl-Storable                    x86_64          2.45-3.el7                  base              77 k
 perl-Text-ParseWords             noarch          3.29-4.el7                  base              14 k
 perl-Time-Local                  noarch          1.2300-2.el7                base              24 k
 perl-constant                    noarch          1.27-2.el7                  base              19 k
 perl-libs                        x86_64          4:5.16.3-283.el7            base             686 k
 perl-macros                      x86_64          4:5.16.3-283.el7            base              42 k
 perl-parent                      noarch          1:0.225-244.el7             base              12 k
 perl-podlators                   noarch          2.5.1-3.el7                 base             112 k
 perl-threads                     x86_64          1.87-4.el7                  base              49 k
 perl-threads-shared              x86_64          1.43-6.el7                  base              39 k

Transaction Summary
=====================================================================================================
Install  1 Package (+36 Dependent packages)

Total download size: 32 M
Installed size: 144 M
Is this ok [y/d/N]: y
Downloading packages:
(1/37): libaio-0.3.109-12.el7.x86_64.rpm                                      |  24 kB  00:00:02
(2/37): perl-Carp-1.26-244.el7.noarch.rpm                                     |  19 kB  00:00:02
(3/37): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm                        |  32 kB  00:00:00
(4/37): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm                         |  57 kB  00:00:00
(5/37): perl-DBI-1.627-4.el7.x86_64.rpm                                       | 802 kB  00:00:01
(6/37): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                                 | 140 kB  00:00:01
(7/37): perl-Data-Dumper-2.145-3.el7.x86_64.rpm                               |  47 kB  00:00:00
(8/37): perl-Exporter-5.68-3.el7.noarch.rpm                                   |  28 kB  00:00:00
(9/37): perl-Encode-2.51-7.el7.x86_64.rpm                                     | 1.5 MB  00:00:00
(10/37): perl-File-Path-2.09-2.el7.noarch.rpm                                 |  26 kB  00:00:00
(11/37): perl-Filter-1.49-3.el7.x86_64.rpm                                    |  76 kB  00:00:00
(12/37): perl-File-Temp-0.23.01-3.el7.noarch.rpm                              |  56 kB  00:00:00
(13/37): perl-Getopt-Long-2.40-2.el7.noarch.rpm                               |  56 kB  00:00:00
(14/37): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                                |  38 kB  00:00:00
(15/37): perl-Net-Daemon-0.48-5.el7.noarch.rpm                                |  51 kB  00:00:00
(16/37): perl-IO-Compress-2.061-2.el7.noarch.rpm                              | 260 kB  00:00:00
(17/37): perl-PathTools-3.40-5.el7.x86_64.rpm                                 |  82 kB  00:00:00
(18/37): perl-PlRPC-0.2020-14.el7.noarch.rpm                                  |  36 kB  00:00:00
(19/37): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                               |  87 kB  00:00:00
(20/37): perl-Pod-Simple-3.28-4.el7.noarch.rpm                                | 216 kB  00:00:00
(21/37): perl-Pod-Escapes-1.04-283.el7.noarch.rpm                             |  49 kB  00:00:00
(22/37): perl-Pod-Usage-1.63-3.el7.noarch.rpm                                 |  27 kB  00:00:00
(23/37): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm                       |  36 kB  00:00:00
(24/37): perl-Socket-2.010-3.el7.x86_64.rpm                                   |  49 kB  00:00:00
(25/37): perl-Storable-2.45-3.el7.x86_64.rpm                                  |  77 kB  00:00:00
(26/37): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                           |  14 kB  00:00:00
(27/37): perl-Time-Local-1.2300-2.el7.noarch.rpm                              |  24 kB  00:00:00
(28/37): perl-constant-1.27-2.el7.noarch.rpm                                  |  19 kB  00:00:00
(29/37): perl-macros-5.16.3-283.el7.x86_64.rpm                                |  42 kB  00:00:00
(30/37): perl-parent-0.225-244.el7.noarch.rpm                                 |  12 kB  00:00:00
(31/37): perl-libs-5.16.3-283.el7.x86_64.rpm                                  | 686 kB  00:00:00
(32/37): perl-podlators-2.5.1-3.el7.noarch.rpm                                | 112 kB  00:00:00
(33/37): perl-threads-1.87-4.el7.x86_64.rpm                                   |  49 kB  00:00:00
(34/37): perl-threads-shared-1.43-6.el7.x86_64.rpm                            |  39 kB  00:00:00
(35/37): perl-5.16.3-283.el7.x86_64.rpm                                       | 8.0 MB  00:00:20
(36/37): mariadb-server-5.5.37-1.el7_0.x86_64.rpm                             |  11 MB  00:00:24
(37/37): mariadb-5.5.37-1.el7_0.x86_64.rpm                                    | 8.9 MB  00:01:39
-----------------------------------------------------------------------------------------------------
Total                                                                333 kB/s |  32 MB  00:01:39
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : 1:perl-parent-0.225-244.el7.noarch                                               1/37
  Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                2/37
  Installing : perl-podlators-2.5.1-3.el7.noarch                                                3/37
  Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                               4/37
  Installing : 1:perl-Pod-Escapes-1.04-283.el7.noarch                                           5/37
  Installing : perl-Encode-2.51-7.el7.x86_64                                                    6/37
  Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                           7/37
  Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                 8/37
  Installing : 4:perl-libs-5.16.3-283.el7.x86_64                                                9/37
  Installing : 4:perl-macros-5.16.3-283.el7.x86_64                                             10/37
  Installing : perl-Storable-2.45-3.el7.x86_64                                                 11/37
  Installing : perl-Exporter-5.68-3.el7.noarch                                                 12/37
  Installing : perl-constant-1.27-2.el7.noarch                                                 13/37
  Installing : perl-Time-Local-1.2300-2.el7.noarch                                             14/37
  Installing : perl-Socket-2.010-3.el7.x86_64                                                  15/37
  Installing : perl-Carp-1.26-244.el7.noarch                                                   16/37
  Installing : perl-PathTools-3.40-5.el7.x86_64                                                17/37
  Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                      18/37
  Installing : perl-File-Temp-0.23.01-3.el7.noarch                                             19/37
  Installing : perl-File-Path-2.09-2.el7.noarch                                                20/37
  Installing : perl-threads-shared-1.43-6.el7.x86_64                                           21/37
  Installing : perl-threads-1.87-4.el7.x86_64                                                  22/37
  Installing : perl-Filter-1.49-3.el7.x86_64                                                   23/37
  Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                             24/37
  Installing : perl-Getopt-Long-2.40-2.el7.noarch                                              25/37
  Installing : 4:perl-5.16.3-283.el7.x86_64                                                    26/37
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                             27/37
  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                      28/37
  Installing : perl-Net-Daemon-0.48-5.el7.noarch                                               29/37
  Installing : 1:mariadb-5.5.37-1.el7_0.x86_64                                                 30/37
  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                     31/37
  Installing : perl-IO-Compress-2.061-2.el7.noarch                                             32/37
  Installing : perl-PlRPC-0.2020-14.el7.noarch                                                 33/37
  Installing : perl-DBI-1.627-4.el7.x86_64                                                     34/37
  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                               35/37
  Installing : libaio-0.3.109-12.el7.x86_64                                                    36/37
  Installing : 1:mariadb-server-5.5.37-1.el7_0.x86_64                                          37/37
  Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                1/37
  Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                            2/37
  Verifying  : perl-Storable-2.45-3.el7.x86_64                                                  3/37
  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                                              4/37
  Verifying  : perl-Exporter-5.68-3.el7.noarch                                                  5/37
  Verifying  : perl-constant-1.27-2.el7.noarch                                                  6/37
  Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                 7/37
  Verifying  : 1:perl-Pod-Escapes-1.04-283.el7.noarch                                           8/37
  Verifying  : libaio-0.3.109-12.el7.x86_64                                                     9/37
  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                      10/37
  Verifying  : 1:perl-parent-0.225-244.el7.noarch                                              11/37
  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                                               12/37
  Verifying  : 1:mariadb-server-5.5.37-1.el7_0.x86_64                                          13/37
  Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                             14/37
  Verifying  : 4:perl-libs-5.16.3-283.el7.x86_64                                               15/37
  Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                             16/37
  Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                              17/37
  Verifying  : perl-DBI-1.627-4.el7.x86_64                                                     18/37
  Verifying  : perl-Socket-2.010-3.el7.x86_64                                                  19/37
  Verifying  : 4:perl-macros-5.16.3-283.el7.x86_64                                             20/37
  Verifying  : 4:perl-5.16.3-283.el7.x86_64                                                    21/37
  Verifying  : perl-Carp-1.26-244.el7.noarch                                                   22/37
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                             23/37
  Verifying  : 1:mariadb-5.5.37-1.el7_0.x86_64                                                 24/37
  Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                      25/37
  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                     26/37
  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                                                 27/37
  Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                28/37
  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                               29/37
  Verifying  : perl-Encode-2.51-7.el7.x86_64                                                   30/37
  Verifying  : perl-podlators-2.5.1-3.el7.noarch                                               31/37
  Verifying  : perl-Getopt-Long-2.40-2.el7.noarch                                              32/37
  Verifying  : perl-File-Path-2.09-2.el7.noarch                                                33/37
  Verifying  : perl-threads-1.87-4.el7.x86_64                                                  34/37
  Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                             35/37
  Verifying  : perl-Filter-1.49-3.el7.x86_64                                                   36/37
  Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                          37/37

Installed:
  mariadb-server.x86_64 1:5.5.37-1.el7_0

Dependency Installed:
  libaio.x86_64 0:0.3.109-12.el7                    mariadb.x86_64 1:5.5.37-1.el7_0
  perl.x86_64 4:5.16.3-283.el7                      perl-Carp.noarch 0:1.26-244.el7
  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7      perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7
  perl-DBD-MySQL.x86_64 0:4.023-5.el7               perl-DBI.x86_64 0:1.627-4.el7
  perl-Data-Dumper.x86_64 0:2.145-3.el7             perl-Encode.x86_64 0:2.51-7.el7
  perl-Exporter.noarch 0:5.68-3.el7                 perl-File-Path.noarch 0:2.09-2.el7
  perl-File-Temp.noarch 0:0.23.01-3.el7             perl-Filter.x86_64 0:1.49-3.el7
  perl-Getopt-Long.noarch 0:2.40-2.el7              perl-HTTP-Tiny.noarch 0:0.033-3.el7
  perl-IO-Compress.noarch 0:2.061-2.el7             perl-Net-Daemon.noarch 0:0.48-5.el7
  perl-PathTools.x86_64 0:3.40-5.el7                perl-PlRPC.noarch 0:0.2020-14.el7
  perl-Pod-Escapes.noarch 1:1.04-283.el7            perl-Pod-Perldoc.noarch 0:3.20-4.el7
  perl-Pod-Simple.noarch 1:3.28-4.el7               perl-Pod-Usage.noarch 0:1.63-3.el7
  perl-Scalar-List-Utils.x86_64 0:1.27-248.el7      perl-Socket.x86_64 0:2.010-3.el7
  perl-Storable.x86_64 0:2.45-3.el7                 perl-Text-ParseWords.noarch 0:3.29-4.el7
  perl-Time-Local.noarch 0:1.2300-2.el7             perl-constant.noarch 0:1.27-2.el7
  perl-libs.x86_64 4:5.16.3-283.el7                 perl-macros.x86_64 4:5.16.3-283.el7
  perl-parent.noarch 1:0.225-244.el7                perl-podlators.noarch 0:2.5.1-3.el7
  perl-threads.x86_64 0:1.87-4.el7                  perl-threads-shared.x86_64 0:1.43-6.el7

Complete!

Timezone tables

# mysql -u root mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mythconverg]> SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');
+----------------------------------------+
| CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |
+----------------------------------------+
| NULL                                   |
+----------------------------------------+
1 row in set (0.00 sec)

 

 

Document Actions