Thursday, June 4, 2015

Fixing missing RPM issues when install mysql workbench on Oracle Linux


[root@mysql03 repo]# yum localinstall ./mysql-workbench-commercial-6.3.3-1.el7.x86_64.rpm
Loaded plugins: langpacks
Examining ./mysql-workbench-commercial-6.3.3-1.el7.x86_64.rpm: mysql-workbench-commercial-6.3.3-1.el7.x86_64
Marking ./mysql-workbench-commercial-6.3.3-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-commercial.x86_64 0:6.3.3-1.el7 will be installed
--> Processing Dependency: tinyxml for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: libzip for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: python-paramiko for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: proj for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: libodbc.so.2()(64bit) for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Running transaction check
---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed
---> Package mysql-workbench-commercial.x86_64 0:6.3.3-1.el7 will be installed
--> Processing Dependency: tinyxml for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: python-paramiko for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: proj for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
---> Package unixODBC.x86_64 0:2.3.1-10.el7 will be installed
--> Finished Dependency Resolution
Error: Package: mysql-workbench-commercial-6.3.3-1.el7.x86_64 (/mysql-workbench-commercial-6.3.3-1.el7.x86_64)
           Requires: python-paramiko
Error: Package: mysql-workbench-commercial-6.3.3-1.el7.x86_64 (/mysql-workbench-commercial-6.3.3-1.el7.x86_64)
           Requires: proj
Error: Package: mysql-workbench-commercial-6.3.3-1.el7.x86_64 (/mysql-workbench-commercial-6.3.3-1.el7.x86_64)
           Requires: tinyxml
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
 

 These packages could be found in EPEL.
EPEL (Extra Packages for Enterprise Linux) is open source and free community based repository project from Fedora team which provides 100% high quality add-on software packages for Linux distribution including RHEL (Red Hat Enterprise Linux), CentOS, and Scientific Linux.
 

[root@mysql03 repo]# wget http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
--2015-06-03 20:04:48--  http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
Resolving dl.fedoraproject.org (dl.fedoraproject.org)... 209.132.181.23, 209.132.181.27, 209.132.181.24, ...
Connecting to dl.fedoraproject.org (dl.fedoraproject.org)|209.132.181.23|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 14524 (14K) [application/x-rpm]
Saving to: ‘epel-release-7-5.noarch.rpm’
 
100%[=============================================================================================================>] 14,524      75.9KB/s   in 0.2s
 
2015-06-03 20:04:50 (75.9 KB/s) - ‘epel-release-7-5.noarch.rpm’ saved [14524/14524]
 
[root@mysql03 repo]# yum localinstall epel-release-7-5.noarch.rpm
Loaded plugins: langpacks
Examining epel-release-7-5.noarch.rpm: epel-release-7-5.noarch
Marking epel-release-7-5.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package epel-release.noarch 0:7-5 will be installed
--> Finished Dependency Resolution
 
Dependencies Resolved
 
=======================================================================================================================================================
 Package                             Arch                          Version                       Repository                                       Size
=======================================================================================================================================================
Installing:
 epel-release                        noarch                        7-5                           /epel-release-7-5.noarch                         24 k
 
Transaction Summary
=======================================================================================================================================================
Install  1 Package
 
Total size: 24 k
Installed size: 24 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : epel-release-7-5.noarch                                                                                                             1/1
  Verifying  : epel-release-7-5.noarch                                                                                                             1/1
 
Installed:
  epel-release.noarch 0:7-5
 

 

[root@mysql03 repo]# yum localinstall ./mysql-workbench-commercial-6.3.3-1.el7.x86_64.rpm
Loaded plugins: langpacks
Examining ./mysql-workbench-commercial-6.3.3-1.el7.x86_64.rpm: mysql-workbench-commercial-6.3.3-1.el7.x86_64
Marking ./mysql-workbench-commercial-6.3.3-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-commercial.x86_64 0:6.3.3-1.el7 will be installed
--> Processing Dependency: tinyxml for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: libzip for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: python-paramiko for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: proj for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Processing Dependency: libodbc.so.2()(64bit) for package: mysql-workbench-commercial-6.3.3-1.el7.x86_64
--> Running transaction check
---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed
---> Package proj.x86_64 0:4.8.0-4.el7 will be installed
---> Package python-paramiko.noarch 0:1.15.1-1.el7 will be installed
--> Processing Dependency: python-crypto >= 2.1 for package: python-paramiko-1.15.1-1.el7.noarch
--> Processing Dependency: python-ecdsa for package: python-paramiko-1.15.1-1.el7.noarch
---> Package tinyxml.x86_64 0:2.6.2-3.el7 will be installed
---> Package unixODBC.x86_64 0:2.3.1-10.el7 will be installed
--> Running transaction check
---> Package python-crypto.x86_64 0:2.6.1-1.el7 will be installed
---> Package python-ecdsa.noarch 0:0.11-3.el7 will be installed
--> Finished Dependency Resolution
 
Dependencies Resolved
 
============================================================================================
 Package           Arch   Version      Repository                                      Size
============================================================================================
Installing:
 mysql-workbench-commercial
                   x86_64 6.3.3-1.el7  /mysql-workbench-commercial-6.3.3-1.el7.x86_64 119 M
Installing for dependencies:
 libzip            x86_64 0.10.1-8.el7 ol7_latest                                      47 k
 proj              x86_64 4.8.0-4.el7  epel                                           181 k
 python-crypto     x86_64 2.6.1-1.el7  epel                                           469 k
 python-ecdsa      noarch 0.11-3.el7   epel                                            69 k
 python-paramiko   noarch 1.15.1-1.el7 epel                                           999 k
 tinyxml           x86_64 2.6.2-3.el7  epel                                            49 k
 unixODBC          x86_64 2.3.1-10.el7 ol7_latest                                     407 k
 
Transaction Summary
============================================================================================
Install  1 Package (+7 Dependent packages)
 
Total size: 121 M
Total download size: 2.2 M
Installed size: 128 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/epel/packages/python-paramiko-1.15.1-1.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID 352c64e5: NOKEY
Public key for python-paramiko-1.15.1-1.el7.noarch.rpm is not installed
(1/7): python-paramiko-1.15.1-1.el7.noarch.rpm                       | 999 kB  00:00:02
(2/7): tinyxml-2.6.2-3.el7.x86_64.rpm                                |  49 kB  00:00:00
(3/7): python-ecdsa-0.11-3.el7.noarch.rpm                            |  69 kB  00:00:05
(4/7): unixODBC-2.3.1-10.el7.x86_64.rpm                              | 407 kB  00:00:04
(5/7): libzip-0.10.1-8.el7.x86_64.rpm                                |  47 kB  00:00:08
(6/7): python-crypto-2.6.1-1.el7.x86_64.rpm                          | 469 kB  00:00:08
(7/7): proj-4.8.0-4.el7.x86_64.rpm                                   | 181 kB  00:00:08
--------------------------------------------------------------------------------------------
Total                                                       255 kB/s | 2.2 MB  00:00:08
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
Importing GPG key 0x352C64E5:
 Userid     : "Fedora EPEL (7) "
 Fingerprint: 91e9 7d7c 4a5e 96f1 7f3e 888f 6a2f aea2 352c 64e5
 Package    : epel-release-7-5.noarch (@/epel-release-7-5.noarch)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : tinyxml-2.6.2-3.el7.x86_64                                               1/8
  Installing : libzip-0.10.1-8.el7.x86_64                                               2/8
  Installing : python-ecdsa-0.11-3.el7.noarch                                           3/8
  Installing : unixODBC-2.3.1-10.el7.x86_64                                             4/8
warning: /etc/odbcinst.ini created as /etc/odbcinst.ini.rpmnew
  Installing : python-crypto-2.6.1-1.el7.x86_64                                         5/8
  Installing : python-paramiko-1.15.1-1.el7.noarch                                      6/8
  Installing : proj-4.8.0-4.el7.x86_64                                                  7/8
  Installing : mysql-workbench-commercial-6.3.3-1.el7.x86_64                            8/8
  Verifying  : proj-4.8.0-4.el7.x86_64                                                  1/8
  Verifying  : python-crypto-2.6.1-1.el7.x86_64                                         2/8
  Verifying  : mysql-workbench-commercial-6.3.3-1.el7.x86_64                            3/8
  Verifying  : unixODBC-2.3.1-10.el7.x86_64                                             4/8
  Verifying  : python-ecdsa-0.11-3.el7.noarch                                           5/8
  Verifying  : libzip-0.10.1-8.el7.x86_64                                               6/8
  Verifying  : tinyxml-2.6.2-3.el7.x86_64                                               7/8
  Verifying  : python-paramiko-1.15.1-1.el7.noarch                                      8/8
 
Installed:
  mysql-workbench-commercial.x86_64 0:6.3.3-1.el7
 
Dependency Installed:
  libzip.x86_64 0:0.10.1-8.el7                    proj.x86_64 0:4.8.0-4.el7
  python-crypto.x86_64 0:2.6.1-1.el7              python-ecdsa.noarch 0:0.11-3.el7
  python-paramiko.noarch 0:1.15.1-1.el7           tinyxml.x86_64 0:2.6.2-3.el7
  unixODBC.x86_64 0:2.3.1-10.el7
 
Complete!
[root@mysql03 repo]#