Implementación Servidor de Base de Datos

 ------
 Install LAMP
 -------
 yum -y update
 
 sudo yum install httpd
 
 sudo service httpd start

1. vi /etc/yum.repos.d/MariaDB.repo

[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

# yum install MariaDB-server MariaDB-client -y 
 
 

1. service mysql start
2. chkconfig --level 35 mysql on
3. service mysql status

 # mysql_secure_installation
 
 muyuyoFCD.753
 
 sudo yum install php php-mysql php-gd
 
 chkconfig httpd on
 
 iptables -I INPUT 5 -i eth0 -p tcp --dport 80 -m state --state NEW,ESTABLISHED -j ACCEPT
 iptables -I INPUT 6 -i eth0 -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT
 service iptables save 
 
 rpm -Uvh http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
 yum -y update
 yum -y install phpmyadmin
 
 Agregar accesos a la red
 vi /etc/httpd/conf.d/phpMyAdmin.conf
 service httpd restart
 
 yum install fail2ban
 cp /etc/fail2ban/jail.conf /etc/fail2ban/jail.local
 vi /etc/fail2ban/jail.local
 
 interface GigabitEthernet1/0/2
description Switch Uplink Port
switchport trunk encapsulation dot1q
switchport trunk allowed vlan 100,200

interface GigabitEthernet1/0/24
macro apply access_port $allowed_vlan 101
end

yum install centos-release-scl
yum install python27


[Webmin]

name=Webmin Distribution Neutral

1. baseurl=http://download.webmin.com/download/yum

mirrorlist=http://download.webmin.com/download/yum/mirrorlist enabled=1 wget http://www.webmin.com/jcameron-key.asc rpm --import jcameron-key.asc

You will now be able to install with the command : yum install webmin

iptables -A INPUT -p tcp -m tcp --dport 10000 -j ACCEPT

yum install ntp ntpdate ntp-doc
chkconfig ntpd on

ntpdate -u ec.pool.ntp.org

CREATE DATABASE kmwiki; GRANT ALL PRIVILEGES ON kmwiki.* TO 'wiki'@'localhost' IDENTIFIED BY 'k159265M';

1. wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
2. wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
3. rpm -Uvh epel-release-6-8.noarch.rpm remi-release-6.rpm

 yum install yum-utils
yum-config-manager --enable remi-php56    [Intall PHP 5.6]