Adicionar RPMforge Repository en Servidor CentOS 6/RHEL 6

Para adicionar el repositorio RPMforge debemos en primer lugar revisar si tenemos 32 o 64 bit, que lo hacemos con lo siguiente:

Version de Centos/RHEL
# cat /etc/redhat-release

Arquitectura
# uname -a

Para 32 Bits
http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm

Para 64 Bits
http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

1. Descargamos el paquete

# wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

--2016-05-16 14:39:50--  http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Resolviendo pkgs.repoforge.org... 78.46.17.228
Connecting to pkgs.repoforge.org|78.46.17.228|:80... conectado.
Petición HTTP enviada, esperando respuesta... 302 Moved Temporarily
Localización: http://rpmforge.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm [siguiendo]
--2016-05-16 14:39:51--  http://rpmforge.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Resolviendo rpmforge.sw.be... 78.46.17.228
Reusing existing connection to pkgs.repoforge.org:80.
Petición HTTP enviada, esperando respuesta... 301 Moved Permanently
Localización: http://tree.repoforge.org/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm [siguiendo]
--2016-05-16 14:39:51--  http://tree.repoforge.org/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Resolviendo tree.repoforge.org... 78.46.17.228
Reusing existing connection to pkgs.repoforge.org:80.
Petición HTTP enviada, esperando respuesta... 301 Moved Permanently
Localización: http://apt.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm [siguiendo]
--2016-05-16 14:39:52--  http://apt.sw.be/redhat/el6/en/x86_64/rpmforge/RPMS/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
Resolviendo apt.sw.be... 193.1.193.67
Connecting to apt.sw.be|193.1.193.67|:80... conectado.
Petición HTTP enviada, esperando respuesta... 200 OK
Longitud: 12700 (12K) [application/x-redhat-package-manager]
Saving to: `rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm'

100%[===========================================================================================================================================================>] 12.700      --.-K/s   in 0s

2016-05-16 14:39:52 (816 MB/s) - `rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm' saved [12700/12700]

2. Descargamos la llave

# wget http://apt.sw.be/RPM-GPG-KEY.dag.txt

--2016-05-16 14:40:07--  http://apt.sw.be/RPM-GPG-KEY.dag.txt

Resolviendo apt.sw.be... 193.1.193.67

Connecting to apt.sw.be|193.1.193.67|:80... conectado.

Petición HTTP enviada, esperando respuesta... 200 OK

Longitud: 1672 (1,6K) [text/plain]

Saving to: `RPM-GPG-KEY.dag.txt'

100%[========================================================================================================================================================

2016-05-16 14:40:08 (341 MB/s) - `RPM-GPG-KEY.dag.txt' saved [1672/1672]

3. Instalamos la llave

# rpm --import RPM-GPG-KEY.dag.txt

4. Procedemos a instalar

# rpm -ivh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

Preparando...               ########################################### [100%]

   1:rpmforge-release       ########################################### [100%]

5. Configuramos el repositorio, abriendo el archivo e insertando “priority=3” despues de “enabled = 1” en la seccion [rpmforge] 

# nano /etc/yum.repos.d/rpmforge.repo

Nos quedaria asi:

### Name: RPMforge RPM Repository for RHEL 6 - dag

### URL: http://rpmforge.net/

[rpmforge]

name = RHEL $releasever - RPMforge.net - dag

baseurl = http://apt.sw.be/redhat/el6/en/$basearch/rpmforge

mirrorlist = http://apt.sw.be/redhat/el6/en/mirrors-rpmforge

#mirrorlist = file:///etc/yum.repos.d/mirrors-rpmforge

enabled = 1

priority=3

protect = 0

gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-rpmforge-dag

gpgcheck = 1

[rpmforge-extras]

name = RHEL $releasever - RPMforge.net - extras

baseurl = http://apt.sw.be/redhat/el6/en/$basearch/extras

mirrorlist = http://apt.sw.be/redhat/el6/en/mirrors-rpmforge-extras

#mirrorlist = file:///etc/yum.repos.d/mirrors-rpmforge-extras

enabled = 0

protect = 0

gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-rpmforge-dag

gpgcheck = 1

[rpmforge-testing]

name = RHEL $releasever - RPMforge.net - testing

baseurl = http://apt.sw.be/redhat/el6/en/$basearch/testing

mirrorlist = http://apt.sw.be/redhat/el6/en/mirrors-rpmforge-testing

#mirrorlist = file:///etc/yum.repos.d/mirrors-rpmforge-testing

enabled = 0

protect = 0

gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-rpmforge-dag

gpgcheck = 1

6. Revisamos la actualizacion realizada

# yum repolist

Complementos cargados:fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

 * base: mirror.edatel.net.co

 * extras: mirror.edatel.net.co

 * rpmforge: apt.sw.be

 * updates: mirror.edatel.net.co

rpmforge

rpmforge/primary_db

id del repositorio

base

extras

rpmforge

updates

repolist: 12.977

Mysql 5.7 en Centos 6.7

Fuente: https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html

Podemos verificar con estos comandos

Versión de Centos
[root@localhost ~]# cat /etc/redhat-release

Arquitectura, con lo que sabremos los paquetes que debemos utilizar en 32 0 64 bits
[root@localhost ~]# uname -a

Para revisar todos los paquetes instalados
[root@localhost ~]# rpm -qa | less

1. Instalar el repositorio

[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm

2. Revisamos los paquetes que se van a instalar

[root@localhost ~]# rpm -qa | grep mysql

la salida será así
mysql-community-libs-compat-5.7.12-1.el6.x86_64
mysql-community-libs-5.7.12-1.el6.x86_64
mysql57-community-release-el6-8.noarch
mysql-community-client-5.7.12-1.el6.x86_64
mysql-community-server-5.7.12-1.el6.x86_64
mysql-community-common-5.7.12-1.el6.x86_64

3. Revisar que este activo el repositorio de MySQL 5.7

[root@localhost ~]# yum repolist enabled | grep "mysql.*-community.*"

la salida nnos indica el mysql57-community

mysql-connectors-community           MySQL Connectors Community              21

mysql-tools-community                    MySQL Tools Community                        35

mysql57-community                         MySQL 5.7 Community Server                 82

en el caso que no se tenga, podemos editar el siguiente archivo y configurar

[root@localhost ~]# nano /etc/yum.repos.d/mysql-community.repo

Revisamos que la opción de enabled este en 1

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

4. Finalmente realizamos la instalación

[root@localhost ~]# yum install mysql-community-server

Iniciamos el servicio

[root@localhost ~]# service mysqld start 

Configuramos el servicio para que se inicie automaticamente

[root@localhost ~]# chkconfig mysqld on

Podemos comprobar la versión instalada con

[root@localhost ~]# mysql --version

5. Seguridad

El comando mysql_secure_installation es importante y utilizado para la configuración del password del usurio root, remover el usuario anonymous, remover login root.

IMPORTANTE: En MySQL version 5.7 o superiores se genera un password ramdómico temporal que se encuentra en /var/log/mysqld.log.

Para poder obtenerlo usamos el siguiente comando y con este poder correo elmysql secure command.

[root@localhost ~]#  grep 'temporary password' /var/log/mysqld.log

Con esto podemos ya correr el comando y continuar con la asignación del password para el usuario root.

[root@localhost ~]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

The 'validate_password' plugin is installed on the server.

The subsequent steps will run with the existing configuration

of the plugin.

Using existing password for root.

Estimated strength of the password: 100

Change the password for root ? ((Press y|Y for Yes, any other key for No) : y

 ... skipping.

By default, a MySQL installation has an anonymous user,

allowing anyone to log into MySQL without having to have

a user account created for them. This is intended only for

testing, and to make the installation go a bit smoother.

You should remove them before moving into a production

environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y

Success.

Normally, root should only be allowed to connect from

'localhost'. This ensures that someone cannot guess at

the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y

Success.

By default, MySQL comes with a database named 'test' that

anyone can access. This is also intended only for testing,

and should be removed before moving into a production

environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y

 - Dropping test database...

Success.

 - Removing privileges on test database...

Success.

Reloading the privilege tables will ensure that all changes

made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

Success.

All done!

Para comprobar accedemos a MySQL

[root@localhost ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 28

Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

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

mysql>

Para abrir el puerto en iptables

[root@localhost ~]# iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

[root@localhost ~]# service iptables save