Untitled

[root@localhost ~]# date
Thu Jan 19 07:52:05 EST 2017
[root@localhost ~]# yum -y remove SyncGEM
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package SyncGEM.i686 0:2.0.20170117-1.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================
 Package                   Arch                   Version                               Repository                                           Size
==================================================================================================================================================
Removing:
 SyncGEM                   i686                   2.0.20170117-1.el6                    @/SyncGEM-2.0.20170117-1.el6.i686                    27 M

Transaction Summary
==================================================================================================================================================
Remove        1 Package(s)

Installed size: 27 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : SyncGEM-2.0.20170117-1.el6.i686                                                                                                1/1
  Verifying  : SyncGEM-2.0.20170117-1.el6.i686                                                                                                1/1

Removed:
  SyncGEM.i686 0:2.0.20170117-1.el6

Complete!
[root@localhost ~]# mysql -e "DROP SCHEMA syncgem"
[root@localhost ~]# yum -y install SyncGEM-1.4.00-1.el6.i686.rpm
Loaded plugins: fastestmirror
Setting up Install Process
Examining SyncGEM-1.4.00-1.el6.i686.rpm: SyncGEM-1.4.00-1.el6.i686
Marking SyncGEM-1.4.00-1.el6.i686.rpm to be installed
Loading mirror speeds from cached hostfile
 * base: mirrors.vooservers.com
 * epel: mirrors.ukfast.co.uk
 * extras: mirrors.vooservers.com
 * updates: mirror.as29550.net
Resolving Dependencies
--> Running transaction check
---> Package SyncGEM.i686 0:1.4.00-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================
 Package                      Arch                      Version                             Repository                                       Size
==================================================================================================================================================
Installing:
 SyncGEM                      i686                      1.4.00-1.el6                        /SyncGEM-1.4.00-1.el6.i686                       37 M

Transaction Summary
==================================================================================================================================================
Install       1 Package(s)

Total size: 37 M
Installed size: 37 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : SyncGEM-1.4.00-1.el6.i686                                                                                                      1/1
Converting SyncGEM v1.1 metrics log files to new format...
Configuring SELinux...
checkmodule:  loading policy configuration from /var/tmp/syncgem-gui-selinux-module.te
checkmodule:  policy configuration loaded
checkmodule:  writing binary representation (version 10) to /var/tmp/syncgem-gui-selinux-module.mod
Configuring services...
INFO: No database configuration file given, looking for file: /var/syncgem/db.conf
INFO: No database schema file given, looking for file: /usr/share/syncgem/db-schema.sql
INFO: Database 'syncgem' does not exist. Attempting to create database now.
INFO: Creating database 'syncgem' was successful
  Verifying  : SyncGEM-1.4.00-1.el6.i686                                                                                                      1/1

Installed:
  SyncGEM.i686 0:1.4.00-1.el6

Complete!
[root@localhost ~]# yum -y update SyncGEM-2.0.20170117-1.el6.i686.rpm
Loaded plugins: fastestmirror
Setting up Update Process
Examining SyncGEM-2.0.20170117-1.el6.i686.rpm: SyncGEM-2.0.20170117-1.el6.i686
Marking SyncGEM-2.0.20170117-1.el6.i686.rpm as an update to SyncGEM-1.4.00-1.el6.i686
Loading mirror speeds from cached hostfile
 * base: mirrors.vooservers.com
 * epel: mirrors.ukfast.co.uk
 * extras: mirrors.vooservers.com
 * updates: mirror.as29550.net
Resolving Dependencies
--> Running transaction check
---> Package SyncGEM.i686 0:1.4.00-1.el6 will be updated
---> Package SyncGEM.i686 0:2.0.20170117-1.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================
 Package                   Arch                   Version                                Repository                                          Size
==================================================================================================================================================
Updating:
 SyncGEM                   i686                   2.0.20170117-1.el6                     /SyncGEM-2.0.20170117-1.el6.i686                    27 M

Transaction Summary
==================================================================================================================================================
Upgrade       1 Package(s)

Total size: 27 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : SyncGEM-2.0.20170117-1.el6.i686                                                                                                1/2
Configuring SELinux...
INFO: Found an existing policy named 'syncgem'. It will be overwritten.
checkmodule:  loading policy configuration from /var/tmp/syncgem-gui-selinux-module/syncgem.te
checkmodule:  policy configuration loaded
checkmodule:  writing binary representation (version 10) to /var/tmp/syncgem-gui-selinux-module/syncgem.mod
Configuring services...
  Cleanup    : SyncGEM-1.4.00-1.el6.i686                                                                                                      2/2
Configuring database...
INFO: No database configuration file given, looking for default: /var/syncgem/db.conf
INFO: No database schema filepath given, looking for default: /usr/share/syncgem
INFO: Database 'syncgem' exists! Found version: 1.4.00 (GA Release)
WARNING: Attempting to upgrade/downgrade to an alpha or beta build: 2.0.20170117 (GA Release)
  Use -f or --force to upgrade/downgrade.
    Please resolve issue and try again.
    You may run script /usr/local/bin/syncgem-update-db.sh at any time
warning: %posttrans(SyncGEM-2.0.20170117-1.el6.i686) scriptlet failed, exit status 1
Non-fatal POSTTRANS scriptlet failure in rpm package SyncGEM-2.0.20170117-1.el6.i686
  Verifying  : SyncGEM-2.0.20170117-1.el6.i686                                                                                                1/2
  Verifying  : SyncGEM-1.4.00-1.el6.i686                                                                                                      2/2

Updated:
  SyncGEM.i686 0:2.0.20170117-1.el6

Complete!
[root@localhost ~]# date
Thu Jan 19 07:55:18 EST 2017
[root@localhost ~]# syncgem-backup-database.sh
INFO: No database configuration file given, looking for file: /var/syncgem/db.conf
INFO: Backing-up database: 'syncgem'...
INFO: Backup has completed successfully.
[root@localhost ~]# ls -lastr syncgem-db-backup-20170119-07
syncgem-db-backup-20170119-074508.sql  syncgem-db-backup-20170119-075537.sql
[root@localhost ~]# ls syncgem-db-backup-20170119-075537.sql
syncgem-db-backup-20170119-075537.sql
[root@localhost ~]#vi syncgem-db-backup-20170119-075537.sql

   1644 LOCK TABLES `Schema` WRITE;
   1645 /*!40000 ALTER TABLE `Schema` DISABLE KEYS */;
   1646 INSERT INTO `Schema` VALUES ('2017-01-19 12:54:04','1.4.00','GA Release');
   1647 /*!40000 ALTER TABLE `Schema` ENABLE KEYS */;
   1648 UNLOCK TABLES;