August 2025
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031

Categories

August 2025
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031

disable ipv6 on windows

MySQL client fails to connect to localhost on Windows, due to IPv6
A MySQL client running on Windows 2008 or Windows 7 may fail to connect to the host name of “localhost”. This is due to windows resloving the host name of localhost to the IPv6 loopback address of ::1. Windows will resolve localhost to ::1, even if IPv6 is disabled on all local network adapters.

MySQL IPv6 status
MySQL Server version 5.5.3 (March 2010) and later, support IPv6 connections to localhost, using the ::1 IPv6 address. So recent MySQL installations can at least listen for IPv6 client connections. But previous versions of MySQL server interpret ::1 as a string or host name, rather than an IP address.

On the client software side, things are not as simple.
We have the official MySQL Connector client libraries of connector/j, connector/odbc, connector/net, connector/c, connector/c++, connector/mxj, and the MySQL-PHP native driver (mysqlnd). On PHP we have ext/mysql, mysqli and pdo_mysql. ColdFusion uses its own MySQL client, with a different version of that client in each version of ColdFusion (mx, 7, 8, 9). Then there are many third party MySQL client libraries for Perl, ASP.Net, etc, etc, etc.

You just can’t trust the client to support IPv6. Only a few MySQL client libraries currently support IPv6 connections, and of those that do support IPv6, only the most recent versions may properly support IPv6.

The localhost problem
So here is where we run into a problem…

By default, Windows 7 and Windows 2008 R2 resolve the localhost host name to the ::1 IPv6 loopback address, rather than the 127.0.0.1 IPv4 loopback address. Windows will resolve “localhost” to ::1, even if you have disabled IPv6 on all of the installed network addapters.

This doesn’t just affect MySQL. This affects any TCP/IP client/server program that may use “localhost” as a connection parameter.

As you can see in the image below (mouse over images, for larger image) a “Ping localhost” command, on a default w2k8 r2 install, returns the IPv6 ::1 loopback address.

The images below show that ping localhost returns the ::1 IPv6 address, even when IPv6 is disabled on all local network adapters.
  


Fixing localhost IPv4 resolution
So we’ve decideded that we don’t like this sneaky IPv6 result for localhost resolution. The software that we are running prefers that localhost resolve to trusty old 127.0.0.1.
What to do?

We can correct this behavior in the Windows Hosts file, or by using the Windows registry to modify how IPv6 works or disable IPv6 altogether. My personal preference is to use the Windows hosts file to specifically map localhost to 127.0.0.1 and to modify the IPv4/IPv6 resolution preference.

Via Windows Hosts file
First, let’s take a look at the default Windows hosts file, at C:\Windows\System32\drivers\etc\hosts (open with notepad)
In previous versions of Windows, we find the following active entry for “localhost”
127.0.0.1       localhost

But in Windows 7 and Windows 2008 R2, the hosts file is effectively empty. While there are both IPv4 and IPv6 entries for “localhost”, both are disabled by being commented out.
# 127.0.0.1       localhost
# ::1             localhost

The image below shows the default hosts file, on a clean install of w2k8 r2.

If both “localhost” entries are disabled (commented out), localhost will resolve to the ::1 IPv6 address.
If both “localhost” entries are enabled (active), localhost will still resolve to the ::1 IPv6 address.
   

If we only enable the 127.0.0.1 entry for localhost, then we get the proper IPv4 resolution for a ping of localhost.
  

Via Windows Registry
We can modify the behavior of Windows IPv6 from the “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\TCPIP6\Parameters\” registry key. The entry we are interested in is named “DisabledComponents”. But the DisabledComponents entry probably doesn’t exist on your system. So we need to create a new dword entry named “DisabledComponents”.

You can now disable IPv6 support by setting the value of DisabledComponents to a hex value of ffffffff (that’s 8 “f’s”). After you reboot, a ping of localhost will return 127.0.0.1, even if you don’t touch the hosts file.
   

But instead of completely disabling IPv6 support in Windows, you can just tell Windows to prefer IPv4 over IPv6. You can do this by setting the value of DisabledComponents to a hex value of 20. After you reboot, a ping of localhost will return 127.0.0.1, even if you don’t touch the hosts file.
   

My personal preference is a belt and suspenders approach to make sure that localhost resolves to 127.0.0.1, while trying not to break other (or future) Windows features by ripping out IPv6. I set a 127.0.0.1 IPv4 address in the hosts file and I set DisabledComponents to a hex value of 20, to adjust the IPv4/IPv6 preference.
  

April 13th, 2015 | Category: 2012 SERVER | Leave a comment

VNC server on Centos 7

VNC server on Centos 7
a)  yum groupinstall “X Window System”

b) yum install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fonts

unlink /etc/systemd/system/default.target

ln -sf  /lib/systemd/system/graphical.target  /etc/systemd/system/default.target

reboot

After reboot, you will get Centos 7 desktop .

Now start installing VNC packages.

Issue the below command to install VNC package.

yum install tigervnc-server -y

Create a file vncserver@:1.service in /etc/systemd/system/ directory by copying example config file /lib/systemd/system/vncserver@.service

cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:1.service

Now open /etc/systemd/system/vncserver@:1.service file and replace with your username .
Find these lines ..
ExecStart=/sbin/runuser -l <USER> -c “/usr/bin/vncserver %i”
PIDFile=/home/<USER>/.vnc/%H%i.pid

Replace ( Considering username as mohan )
ExecStart=/sbin/runuser -l mohan -c “/usr/bin/vncserver %i”
PIDFile=/home/mohan/.vnc/%H%i.pid

If you are creating for root user .
ExecStart=/sbin/runuser -l root -c “/usr/bin/vncserver %i”
PIDFile=/root/.vnc/%H%i.pid

Reload systemd for changes.

systemctl daemon-reload

Create VNC password for the user .
su – mohan

vncpasswd

Enable and start the service using the below commands.
Enable service at startup ( Permanent ).

systemctl enable vncserver@:1.service

systemctl start vncserver@:1.service

Allow VNC service in firewall.

firewall-cmd –permanent –add-service vnc-server
systemctl restart firewalld.service

You can use VNC client like Tightvnc viewer and Realvnc viewer to connect Server.
For additional users create files with different ports ( Refer Step 2 ) vncserver@:2.service by copying example config file and continue the steps 3,4,5 and 6 by replacing service name. Please make sure you logged in as that particular user for creating vnc password ( Step 5 ).

Additional Commands :
To stop VNC service .
systemctl stop vncserver@:1.service

To disable VNC service from startup ( permanent ).
systemctl disable vncserver@:1.service

To stop firewall ( For troubleshooting ).

April 12th, 2015 | Category: Centos RHEL 7 | Leave a comment

firewalld add

Assuming you’re using the default zone of “public” (you may need to temporarily disable selinux (setenforce 0)):

1. To allow everyone to access port 8080/tcp: 

  firewall-cmd –zone=public –add-port=8080/tcp –permanent

2. Allow a server from the IPv4 address 192.168.1.50 to access this server on port 128 over UDP:

firewall-cmd –zone=public –add-rich-rule=’rule family=”ipv4″ source address=”192.168.1.50/32″ port port=”128″ protocol=”udp” accept’ –permanent

April 12th, 2015 | Category: Centos RHEL 7 | Leave a comment

LAMP server on centos 7

LAMP server on centos 7

LAMP is a group of open source softwares installed together to build a webserver. LAMP refers to Linux (Operating system), Apache (Web service), MySQL/MariaDB (Database) , PHP (Programming language).
This guide helps you to install LAMP server on centos 7.
Before starting installation, you need to setup Static IP and hostname .
You can also refer this guide – Setup network on centos 7 to setup static ip and hostname.
Install LAMP server on centos 7.
1. Apache installation.
2. Mysql installation.
3. PHP installation.
4. Testing all together.
let’s start

Apache installation
Step 1 » Update the repositories.
[root@clusterserver1 ~]# yum check-update

[root@clusterserver1 ~]# yum update

[root@clusterserver1 ~]# yum install httpd
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.vodien.com
* epel: mirrors.vinahost.vn
* extras: mirror.vodien.com
* updates: mirror.vodien.com
Package httpd-2.4.6-31.el7.centos.x86_64 already installed and latest version
Nothing to do
[root@clusterserver1 ~]#

Apache installation
Step 1 » Update the repositories.

[root@clusterserver1 ~]# systemctl start httpd.service
[root@clusterserver1 ~]# systemctl star^Chttpd.service
[root@clusterserver1 ~]# systemctl enable httpd.service
[root@clusterserver1 ~]# systemctl status httpd.service
httpd.service – The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled)
Active: active (running) since Sun 2015-04-12 03:30:50 SGT; 6min ago
Main PID: 25200 (httpd)
Status: “Total requests: 0; Current requests/sec: 0; Current traffic:   0 B/sec”
CGroup: /system.slice/httpd.service
??25200 /usr/sbin/httpd -DFOREGROUND
??25201 /usr/sbin/httpd -DFOREGROUND
??25202 /usr/sbin/httpd -DFOREGROUND
??25203 /usr/sbin/httpd -DFOREGROUND
??25204 /usr/sbin/httpd -DFOREGROUND
??25205 /usr/sbin/httpd -DFOREGROUND

Apr 12 03:30:50 clusterserver1 httpd[25200]: AH00558: httpd: Could not reliably determine the server’s fully qualified domain …essage
Apr 12 03:30:50 clusterserver1 systemd[1]: Started The Apache HTTP Server.
Apr 12 03:37:16 clusterserver1 systemd[1]: Started The Apache HTTP Server.
Hint: Some lines were ellipsized, use -l to show in full.

By default, Apache will listen on port 80. you need to exclude from firewall.
you can simply exclude http service from firewall.

firewall-cmd –permanent –add-service http
or you can exclude using port number. Below command will be useful for ports other than 80

firewall-cmd –permanent –add-port=8080/tcp

Step 5 » Now restart firewall service.
systemctl restart firewalld.service

apache

 

 

MySQL installation.

Start installing MariaDB, MySQL drop-in replacement.
[root@clusterserver1 ~]# yum install mariadb-server mariadb
[root@clusterserver1 ~]# systemctl start mariadb
[root@clusterserver1 ~]#
[root@clusterserver1 ~]# mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we’ll need the current
password for the root user.  If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
Enter current password for root (enter for none):
OK, successfully used password, moving on…

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
… Success!

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB 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? [Y/n] 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? [Y/n] n
… skipping.

By default, MariaDB 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? [Y/n] 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? [Y/n] y
… Success!

Cleaning up…

All done!  If you’ve completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

PHP installation.
Install PHP and other recommended packages.
yum install php php-mysql

Additional packages are required if you would like to install phpmyadmin .

yum install php-gd php-pear php-mbstring php-pgsql

Now restart apache service

systemctl restart httpd.service

 

[root@clusterserver1 html]# cat phpinfo.php
<?php phpinfo(); ?>

apache2

[root@clusterserver1 html]# cat dbtest.php
<?php
$con = mysql_connect(“localhost”,”root”,”test123″);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
else
{
echo “Congrats! connection established successfully”;
}
mysql_close($con);
?>

 

apache3

April 12th, 2015 | Category: Centos RHEL 7 | Leave a comment

mail server on centos 7 Redhat 7

Setup mail server on centos 7

This article helps you to install and configure basic mail server on Centos 7. Here i have used Postfix for SMTP, Dovecot for POP/IMAP and Dovecot SASL for SMTP AUTH.
Before proceeding please make sure you have assigned static IP for the server and have internet connectivity for installing packages.

Setup mail server on centos 7
1. Installing packages
2. Postfix configuration
3. Dovecot configuration
4. User creation

Installing packages
Step 1 » Assign hostname for the server using the below command.
[root@rmohan ~]# hostnamectl set-hostname mail.rmohan.com

Step 2 » Make a host entry with your IP in /etc/hosts file.
192.168.1.20 mail.rmohan.com

Step 3 » Now start installing packages.
[root@rmohan ~]# yum -y install postfix dovecot

After package installation continue with postfix configuration.

Postfix configuration
First create SSL certificate for encryption.
Step 4 » Follow the below steps one by one for creation.
[root@mail ~]# mkdir /etc/postfix/ssl
[root@mail ~]# cd /etc/postfix/ssl
[root@rmohan ssl]# openssl genrsa -des3 -out server.key 2048
[root@rmohan ssl]# openssl rsa -in server.key -out server.key.insecure
[root@rmohan ssl]# mv server.key server.key.secure
[root@rmohan ssl]# mv server.key.insecure server.key
Leave blank for A challenge password [] value in the below step.
[root@rmohan ssl]# openssl req -new -key server.key -out server.csr
[root@rmohan ssl]# openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt

Step 5 » Now open /etc/postfix/main.cf file for changes.
Find and uncomment the below lines.
#inet_interfaces = localhost #—> line no 116
#mydestination = $myhostname, localhost.$mydomain, localhost #–> line no 164

and add below lines at the end of the file. change myhostname and mydomain values with yours and home_mailbox value to your desired directory. Here it will store mails in the users home directory (Eg: /home/rmohan/mail ).

myhostname = mail.rmohan.com
mydomain = rmohan.com
myorigin = $mydomain
home_mailbox = mail/
mynetworks = 127.0.0.0/8
inet_interfaces = all
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
smtpd_sasl_auth_enable = yes
smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unauth_destination
smtp_tls_security_level = may
smtpd_tls_security_level = may
smtp_tls_note_starttls_offer = yes
smtpd_tls_loglevel = 1
smtpd_tls_key_file = /etc/postfix/ssl/server.key
smtpd_tls_cert_file = /etc/postfix/ssl/server.crt
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom

Step 6 » Open /etc/postfix/master.cf file, add the below lines after “smtp inet n – n – – smtpd” line.
submission     inet  n       –       n       –       –       smtpd
-o syslog_name=postfix/submission
-o smtpd_sasl_auth_enable=yes
-o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
-o milter_macro_daemon_name=ORIGINATING
smtps     inet  n       –       n       –       –       smtpd
-o syslog_name=postfix/smtps
-o smtpd_sasl_auth_enable=yes
-o smtpd_recipient_restrictions=permit_sasl_authenticated,reject
-o milter_macro_daemon_name=ORIGINATING
Now check the configuration using postfix check command.
Step 7 » Now configure Dovecot SASL for SMTP Auth. Open /etc/dovecot/conf.d/10-master.conf file, find “# Postfix smtp-auth” line ( line no:95 ) and add the below lines.
# Postfix smtp-auth
unix_listener /var/spool/postfix/private/auth {
mode = 0660
user = postfix
group = postfix
}

Step 8 » Open /etc/dovecot/conf.d/10-auth.conf file, find “auth_mechanisms = plain” ( Line no: 100 ) and add login to the value like below.
auth_mechanisms = plain login

Step 9 » Postfix configuration is over. Now restart both postfix and dovecot services and enable auto start.
[root@mail ~]# systemctl restart postfix
[root@mail ~]# systemctl enable postfix
[root@mail ~]# systemctl restart dovecot
[root@mail ~]# systemctl enable dovecot

Step 10 » Add the firewall rules to allow 25, 587 and 465 ports.
[root@mail ~]# firewall-cmd –permanent –add-service=smtp
[root@mail ~]# firewall-cmd –permanent –add-port=587/tcp
[root@mail ~]# firewall-cmd –permanent –add-port=465/tcp
[root@mail ~]# firewall-cmd –reload
Now start testing connectivity for each ports 25,587 and 465 using telnet and make sure you are getting AUTH PLAIN LOGIN line after issuing ehlo mail.rmohan.com command in telnet.
[root@mail ~]# telnet mail.rmohan.com 465
Trying 192.168.1.20…
Connected to mail.rmohan.com.
Escape character is ‘^]’.
220 mail.rmohan.com ESMTP Postfix
ehlo mail.rmohan.com <——- Type this command
250-mail.rmohan.com
250-PIPELINING
250-SIZE 10240000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN
250-AUTH=PLAIN LOGIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN

Dovecot configuration
Start configuring Dovecot .
Step 11 » Open /etc/dovecot/conf.d/10-mail.conf file, find #mail_location = (line no : 30 ) and add the same directory which is given to home_mailbox in the postfix config file ( Step 5).
mail_location = maildir:~/mail

Step 12 » Open /etc/dovecot/conf.d/20-pop3.conf file, find and uncomment the below line ( line no : 50 ) .
pop3_uidl_format = %08Xu%08Xv

Step 13 » Restart dovecot service.
[root@mail ~]# systemctl restart dovecot

Step 14 » Add firewall rules to allow 110,143,993 and 995.
[root@mail ~]# firewall-cmd –permanent –add-port=110/tcp
[root@mail ~]# firewall-cmd –permanent –add-service=pop3s
[root@mail ~]# firewall-cmd –permanent –add-port=143/tcp
[root@mail ~]# firewall-cmd –permanent –add-service=imaps
[root@mail ~]# firewall-cmd –reload

Check the connectivity for the ports 110,143,993 and 995 using telnet.

User creation
Now create user for testing .
Step 15 » Create user with /sbin/nologin shell to restrict login access.
[root@mail ~]# useradd -m rmohan -s /sbin/nologin
[root@mail ~]# passwd rmohan

April 11th, 2015 | Category: Centos RHEL 7 | Leave a comment

Nmcli

let’s start, Type “nmcli d” command in your terminal for quick identification of Ethernet cards installed in your machine.

[root@clusterserver1 ~]# nmcli d
DEVICE       TYPE      STATE      CONNECTION
eno16777736  ethernet  connected  eno16777736
lo           loopback  unmanaged  —

 

[root@clusterserver1 ~]# nmcli connection show
NAME         UUID                                  TYPE            DEVICE
eno16777736  040b2729-2cc5-4ded-af3a-c4ae09dd3563  802-3-ethernet  eno16777736
[root@clusterserver1 ~]# nmcli device show eno16777736
GENERAL.DEVICE:                         eno16777736
GENERAL.TYPE:                           ethernet
GENERAL.HWADDR:                         00:0C:29:C4:97:7D
GENERAL.MTU:                            1500
GENERAL.STATE:                          100 (connected)
GENERAL.CONNECTION:                     eno16777736
GENERAL.CON-PATH:                       /org/freedesktop/NetworkManager/ActiveConnection/0
WIRED-PROPERTIES.CARRIER:               on
IP4.ADDRESS[1]:                         ip = 192.168.1.20/24, gw = 192.168.1.254
IP4.DNS[1]:                             8.8.8.8
IP6.ADDRESS[1]:                         ip = fe80::20c:29ff:fec4:977d/64, gw = ::

 

[root@clusterserver1 ~]# nmcli device show eno16777736  |grep DNS
IP4.DNS[1]:                             8.8.8.8
[root@clusterserver1 ~]#nmcli [ OPTIONS ] OBJECT { COMMAND | help }

 

[root@clusterserver1 ~]# nmcli general status
STATE      CONNECTIVITY  WIFI-HW  WIFI     WWAN-HW  WWAN
connected  full          enabled  enabled  enabled  disabled

 

[root@clusterserver1 ~]# nmcli device status
DEVICE       TYPE      STATE      CONNECTION
eno16777736  ethernet  connected  eno16777736
lo           loopback  unmanaged  —

 

Disconnect from network

[root@clusterserver1 ~]#nmcli device disconnect eno16777736

[root@clusterserver1 ~]# nmcli device connect eno16777736
Device ‘eno16777736’ successfully activated with ‘040b2729-2cc5-4ded-af3a-c4ae09dd3563’.
[root@clusterserver1 ~]#

Add ip address gateway details

nmcli connection add type ethernet con-name NAME_OF_CONNECTION ifname INTERFACE-NAME ip4 IP_ADDRESS gw4 GW_ADDRESS

nmcli connection add type ethernet con-name NEW_STATIC ifname eno16777736 ip4 192.168.1.11 gw4 192.168.1.1

nmcli connection modify NEW_STATIC ipv4.dns “8.8.8.8 8.8.4.4”

nmcli connection up NEW_STATIC ifname eno16777736

nmcli -p connection show NEW_STATIC

GUI Mode

Recommended for beginners
Step 1 » Type this command “nmtui” to open Network manager and press enter after choosing ” Edit a connection” ( Use TAB for choosing options ) .

[root@clusterserver1 ~]# nmtui
Command Mode
Step 1 » Network interface config files are located in /etc/sysconfig/network-scripts/ directory. Open eno16777736 file

[root@clusterserver1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eno16777736
TYPE=Ethernet
BOOTPROTO=none
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
NAME=eno16777736
UUID=040b2729-2cc5-4ded-af3a-c4ae09dd3563
ONBOOT=yes
HWADDR=00:0C:29:C4:97:7D
IPADDR0=192.168.1.20
PREFIX0=24
GATEWAY0=192.168.1.254
DNS1=8.8.8.8
IPV6_PEERDNS=yes
IPV6_PEERROUTES=yes

» DHCP configuration

Step 2 » For DHCP
Find the below lines in config File.
BOOTPROTO=none
ONBOOT=no
and replace with
BOOTPROTO=dhcp
ONBOOT=yes
Now Restart network service by typing below command.
systemctl restart network
Now your server will get IP Address from DHCP

» Static configuration

Step 3 » For Static IP.
Find the below lines in config File.
BOOTPROTO=none
ONBOOT=no
and replace with
BOOTPROTO=static
ONBOOT=yes
And add the below lines at the end of the file.
IPADDR0=192.168.1.20
GATEWAY0=192.168.1.254
DNS1=8.8.8.8

File will look like below after changes.
TYPE=Ethernet
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
NAME=enp0s17
UUID=f0c5b37d-299a-43cb-b74b-618bb252d129
ONBOOT=yes
HWADDR=00:0C:29:A1:B5:CC
IPV6_PEERDNS=yes
IPV6_PEERROUTES=yes
IPADDR=192.168.1.10
NETMASK=255.255.255.0
GATEWAY=192.168.1.1
DNS1=192.168.1.5

Now Restart network service by typing below command.
systemctl restart network
Now Interface will have static IP.
Additionally you can use /etc/sysconfig/network file for hostname and DNS .
HOSTNAME=cluster1.rmohan.com
DNS1=192.168.1.254
DNS2=8.8.8.8
SEARCH=rmohan.com

April 11th, 2015 | Category: Centos RHEL 7 | Leave a comment

5 Improved Windows Server 2012 Features

Windows Server 2012 is loaded with new features–300 of them, according to Microsoft. But, it isn’t all about new features; improvements and upgrades to existing features have people everywhere talking about Windows Server 2012. Let’s jump right in and look at what makes IT departments ready to roll out Server 2012.

Interface

Windows Server 2012 has the Windows 8 interface. This will eventually be useful in environments where administrators actually interact with servers via their new touchscreen laptops and tablets. For now, you might think that the new Metro interface would just get in the way. Apparently, Microsoft thinks the same thing. Windows Server 2012 boots directly to the desktop interface within the Server Manager dashboard.

Server Manager has been upgraded. Now, you can manage servers in groups via the GUI. Several servers can be grouped for management purposes removing the need to figure out how to script repetitive tasks or sit there making the same mouse clicks again and again.

Virtualization

Perhaps no area has gotten more attention in Windows Server 2012 than the continuing improvements to Microsoft’s Hyper-V virtualization solution. Hyper-V has been around long enough that people are starting to take it for granted as a part of Windows Server, however, as it continues to improve, it’s tight integration and free sticker price make it an increasingly important element of any server platform evaluation.

Hyper-V has been around since the first release of Windows Server 2008. Since then, it’s taken on a major update in the Windows Server 2008 R2 release, and now, in Server 2012, IT is looking at a solid, mature, third generation implementation. Upgraded again to support even more hardware, Hyper-V now supports up to 64 processors, 1 terabyte of memory for Hyper-V guests, and support for up to 64 terabytes of disk space. But, bigger specs aren’t the whole story.

Hyper-V now offers a “shared nothing” live migration feature. Under Windows Server 2008, you could perform a live migration, but it required shared storage with a specific type of controller and disk storage setup. With Sever 2012, you don’t need shared storage, or for the virtual machines to even be on the same cluster, to migrate with zero down time. Similarly, Windows Server 2012 now offers Hyper-V Replica, allowing manual, disaster recovery, replication from one Hyper-V host to another without any additional tools or configuration.

Microsoft also claims increased reliability and scalability with this Hyper-V release.

Files and Storage

For environments that aren’t pushing Hyper-V hard yet, Microsoft went ahead and virtualized disk space itself. The new Storage Spaces feature finally brings the ability to take all of (or part of) your physical hard disks and put it together into one big pool. The disks can be physically anywhere, on different servers, as part of storage arrays, or in standalone disk systems.

From this pool, JBOD (just a bunch of disks) virtual drives are carved out. These virtual drives act just like a regular hard drive to the processes above. However, data is written wherever necessary, regardless of the capacity or capability of a single disk. These virtual drives can be dynamically expanded when they begin to fill up. When the pool itself begins to run out of space, new physical disks can be added with zero downtime. Storage Spaces can be configured under three different options, Simple, Mirror, and Parity, which correspond roughly in functionality to RAID 0, 1 and 5 arrays respectively. The aggregate size of the virtual drives can even be bigger than the physical space available. When physical space gets tight, just add another drive

However, Windows Server 2012 comes with data deduplication available. This feature might mean that the day new disks are needed is far in the future. With data deduplication, files are only stored once. Every time the same file is stored again, by another user, or another program, Windows Server just points to the original file instead of adding another copy. Depending on the environment, the space savings can be mind boggling. (Why do users keep saving the same files in so many places?)

PowerShell 3.0

What started out as a way to finally improve upon the cobbled together scripting of batch files and Virtual Basic has evolved into a full-scale way to manage just about anything in a Windows Server environment. In fact, with the release of PowerShell 3.0, built by default into Server 2012, Microsoft says that there is nothing that can be done via the various management GUIs that can’t be done with PowerShell. As in Server 2008, the PowerShell scripts that actually execute the orders entered via the GUI are visible as they run. These scripts can be copied and used to automate future tasks.

Full remoting now comes standard with PowerShell 3.0. When enabled, administrators can run PowerShell scripts against any system they have the proper credentials for access.

More Server Core Choices

When Microsoft debuted Windows Server Core, it offered the stark choice between a full GUI operated system, and one with no GUI, limited roles, and no additional services whatsoever. Assuming that you would now not need any of those “extra” parts of Windows Sever was a bit of a gamble. Knowing that you would NEVER need those parts, or need to add a new role, was a very hard call to make.

Windows Server 2012 adds several more roles that can run on Windows Core.  You can even install SQL Server 2012 on a Server Core, however, Reporting Services is not supported on Core, so you’ll have to do that elsewhere. More interesting, however, is the ability to go half-way. That is, Server 2012 now offers a Minimal Server Interface mode. To get a Minimal Server Interface server, an administrator installs the server as a full server, uses all the GUIs they like to get the install up, running and configured. Then, just remove the Server Graphical Shell in Server Manager. In other words, do all the hard stuff with all the familiar tools and then before you lock the server away, remove those unnecessary components. The best part is, if you ever need to get the full interface back, via the Install-WindowsFeature PowerShell command.

Improvements

There are plenty of “silent” upgrades where features of Windows Server 2012 just work better than before.

The promise of DirectAccess was secure access from anywhere without the complexity of a VPN. Unfortunately, DirectAccess was every bit as complex as a VPN. Now DirectAccess is easy to configure in Server Manager and is easier to set up on Windows 8 systems as well. Most important of all, you don’t have to use IPv6 anymore!

BranchCache is easier to set up and faster. Failover clusters no longer require higher licenses. Dynamic Access Control offers new ways to manage and audit security within Active Directory. The list goes on and on.

No matter what you do with Windows Servers, or what your environment looks like, people are very excited about all that Windows Server 2012 offers.

April 8th, 2015 | Category: 2012 SERVER | Leave a comment

mariadb

[root@clusterserver1 ~]# yum search mariadb
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.vastspace.net
* epel: ftp.yzu.edu.tw
* extras: mirror.vastspace.net
* updates: mirror.vastspace.net
==================================================================================== N/S matched: mariadb =====================================================================================
mariadb-bench.x86_64 : MariaDB benchmark scripts and data
mariadb-devel.i686 : Files for development of MariaDB/MySQL applications
mariadb-devel.x86_64 : Files for development of MariaDB/MySQL applications
mariadb-embedded.i686 : MariaDB as an embeddable library
mariadb-embedded.x86_64 : MariaDB as an embeddable library
mariadb-embedded-devel.i686 : Development files for MariaDB as an embeddable library
mariadb-embedded-devel.x86_64 : Development files for MariaDB as an embeddable library
mariadb-libs.i686 : The shared libraries required for MariaDB/MySQL clients
mariadb-libs.x86_64 : The shared libraries required for MariaDB/MySQL clients
mariadb-server.x86_64 : The MariaDB server and related files
innotop.noarch : A MySQL and InnoDB monitor program
mariadb.x86_64 : A community developed branch of MySQL
mariadb-test.x86_64 : The test suite distributed with MariaD
nodejs-mysql.noarch : A node.js driver for mysql
phpMyAdmin.noarch : Handle the administration of MySQL over the World Wide Web

Name and summary matches only, use “search all” for everything.

[root@clusterserver1 ~]# yum -y  install mariadb*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.vastspace.net
* epel: mirror.nus.edu.sg
* extras: mirror.vastspace.net
* updates: mirror.vastspace.net
Package 1:mariadb-libs-5.5.41-2.el7_0.x86_64 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package mariadb.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: perl(Sys::Hostname) for package: 1:mariadb-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(IPC::Open3) for package: 1:mariadb-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Getopt::Long) for package: 1:mariadb-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(File::Temp) for package: 1:mariadb-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Fcntl) for package: 1:mariadb-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Exporter) for package: 1:mariadb-5.5.41-2.el7_0.x86_64
–> Processing Dependency: /usr/bin/perl for package: 1:mariadb-5.5.41-2.el7_0.x86_64
—> Package mariadb-bench.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: perl(GD) for package: 1:mariadb-bench-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-bench-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(DBI) for package: 1:mariadb-bench-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Cwd) for package: 1:mariadb-bench-5.5.41-2.el7_0.x86_64
—> Package mariadb-devel.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: openssl-devel(x86-64) for package: 1:mariadb-devel-5.5.41-2.el7_0.x86_64
—> Package mariadb-embedded.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: 1:mariadb-embedded-5.5.41-2.el7_0.x86_64
–> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: 1:mariadb-embedded-5.5.41-2.el7_0.x86_64
–> Processing Dependency: libaio.so.1()(64bit) for package: 1:mariadb-embedded-5.5.41-2.el7_0.x86_64
—> Package mariadb-embedded-devel.x86_64 1:5.5.41-2.el7_0 will be installed
—> Package mariadb-server.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(File::Path) for package: 1:mariadb-server-5.5.41-2.el7_0.x86_64
—> Package mariadb-test.x86_64 1:5.5.41-2.el7_0 will be installed
–> Processing Dependency: perl(constant) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Time::HiRes) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Test::More) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Storable) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Socket) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Env) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Processing Dependency: perl(Carp) for package: 1:mariadb-test-5.5.41-2.el7_0.x86_64
–> Running transaction check
—> Package libaio.x86_64 0:0.3.109-12.el7 will be installed
—> Package openssl-devel.x86_64 1:1.0.1e-34.el7_0.7 will be installed
–> Processing Dependency: zlib-devel(x86-64) for package: 1:openssl-devel-1.0.1e-34.el7_0.7.x86_64
–> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.1e-34.el7_0.7.x86_64
—> Package perl.x86_64 4:5.16.3-283.el7 will be installed
–> Processing Dependency: perl-libs = 4:5.16.3-283.el7 for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl-macros for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl-libs for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-283.el7.x86_64
–> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-283.el7.x86_64
—> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
—> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
—> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
–> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
–> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
—> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
—> Package perl-Env.noarch 0:1.04-2.el7 will be installed
—> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
—> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
—> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
—> Package perl-GD.x86_64 0:2.49-3.el7 will be installed
–> Processing Dependency: gd >= 2.0.28 for package: perl-GD-2.49-3.el7.x86_64
–> Processing Dependency: libpng15.so.15()(64bit) for package: perl-GD-2.49-3.el7.x86_64
–> Processing Dependency: libjpeg.so.62()(64bit) for package: perl-GD-2.49-3.el7.x86_64
–> Processing Dependency: libgd.so.2()(64bit) for package: perl-GD-2.49-3.el7.x86_64
–> Processing Dependency: libfontconfig.so.1()(64bit) for package: perl-GD-2.49-3.el7.x86_64
–> Processing Dependency: libXpm.so.4()(64bit) for package: perl-GD-2.49-3.el7.x86_64
–> Processing Dependency: libX11.so.6()(64bit) for package: perl-GD-2.49-3.el7.x86_64
—> Package perl-Getopt-Long.noarch 0:2.40-2.el7 will be installed
–> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-2.el7.noarch
–> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-2.el7.noarch
—> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
—> Package perl-Socket.x86_64 0:2.010-3.el7 will be installed
—> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
—> Package perl-Test-Simple.noarch 0:0.98-243.el7 will be installed
–> Processing Dependency: perl(Test::Harness) >= 2.03 for package: perl-Test-Simple-0.98-243.el7.noarch
—> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
—> Package perl-constant.noarch 0:1.27-2.el7 will be installed
–> Running transaction check
—> Package fontconfig.x86_64 0:2.10.95-7.el7 will be installed
–> Processing Dependency: fontpackages-filesystem for package: fontconfig-2.10.95-7.el7.x86_64
—> Package gd.x86_64 0:2.0.35-26.el7 will be installed
—> Package krb5-devel.x86_64 0:1.11.3-49.el7 will be installed
–> Processing Dependency: libverto-devel for package: krb5-devel-1.11.3-49.el7.x86_64
–> Processing Dependency: libselinux-devel for package: krb5-devel-1.11.3-49.el7.x86_64
–> Processing Dependency: libcom_err-devel for package: krb5-devel-1.11.3-49.el7.x86_64
–> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.11.3-49.el7.x86_64
—> Package libX11.x86_64 0:1.6.0-2.1.el7 will be installed
–> Processing Dependency: libX11-common = 1.6.0-2.1.el7 for package: libX11-1.6.0-2.1.el7.x86_64
–> Processing Dependency: libxcb.so.1()(64bit) for package: libX11-1.6.0-2.1.el7.x86_64
—> Package libXpm.x86_64 0:3.5.10-5.1.el7 will be installed
—> Package libjpeg-turbo.x86_64 0:1.2.90-5.el7 will be installed
—> Package libpng.x86_64 2:1.5.13-5.el7 will be installed
—> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
—> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
–> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
–> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
—> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
–> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
–> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
—> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
–> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
–> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
—> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
—> Package perl-Test-Harness.noarch 0:3.28-2.el7 will be installed
—> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
—> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
—> Package perl-libs.x86_64 4:5.16.3-283.el7 will be installed
—> Package perl-macros.x86_64 4:5.16.3-283.el7 will be installed
—> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
—> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
—> Package zlib-devel.x86_64 0:1.2.7-13.el7 will be installed
–> Running transaction check
—> Package fontpackages-filesystem.noarch 0:1.44-8.el7 will be installed
—> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed
—> Package libX11-common.noarch 0:1.6.0-2.1.el7 will be installed
—> Package libcom_err-devel.x86_64 0:1.42.9-4.el7 will be installed
—> Package libselinux-devel.x86_64 0:2.2.2-6.el7 will be installed
–> Processing Dependency: libsepol-devel >= 2.1.9-1 for package: libselinux-devel-2.2.2-6.el7.x86_64
–> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.2.2-6.el7.x86_64
–> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.2.2-6.el7.x86_64
—> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed
—> Package libxcb.x86_64 0:1.9-5.el7 will be installed
–> Processing Dependency: libXau.so.6()(64bit) for package: libxcb-1.9-5.el7.x86_64
—> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
—> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
–> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
–> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
—> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
—> Package perl-Pod-Escapes.noarch 1:1.04-283.el7 will be installed
—> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
–> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
–> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
—> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
–> Running transaction check
—> Package libXau.x86_64 0:1.0.8-2.1.el7 will be installed
—> Package libsepol-devel.x86_64 0:2.1.9-3.el7 will be installed
—> Package pcre-devel.x86_64 0:8.32-12.el7 will be installed
—> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
—> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
—> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
—> Package perl-parent.noarch 1:0.225-244.el7 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================================================================
Package                                                Arch                                  Version                                             Repository                              Size
===============================================================================================================================================================================================
Installing:
mariadb                                                x86_64                                1:5.5.41-2.el7_0                                    updates                                8.9 M
mariadb-bench                                          x86_64                                1:5.5.41-2.el7_0                                    updates                                386 k
mariadb-devel                                          x86_64                                1:5.5.41-2.el7_0                                    updates                                747 k
mariadb-embedded                                       x86_64                                1:5.5.41-2.el7_0                                    updates                                3.6 M
mariadb-embedded-devel                                 x86_64                                1:5.5.41-2.el7_0                                    updates                                7.4 M
mariadb-server                                         x86_64                                1:5.5.41-2.el7_0                                    updates                                 11 M
mariadb-test                                           x86_64                                1:5.5.41-2.el7_0                                    updates                                8.0 M
Installing for dependencies:
fontconfig                                             x86_64                                2.10.95-7.el7                                       base                                   228 k
fontpackages-filesystem                                noarch                                1.44-8.el7                                          base                                   9.9 k
gd                                                     x86_64                                2.0.35-26.el7                                       base                                   146 k
keyutils-libs-devel                                    x86_64                                1.5.8-3.el7                                         base                                    37 k
krb5-devel                                             x86_64                                1.11.3-49.el7                                       base                                   611 k
libX11                                                 x86_64                                1.6.0-2.1.el7                                       base                                   605 k
libX11-common                                          noarch                                1.6.0-2.1.el7                                       base                                   181 k
libXau                                                 x86_64                                1.0.8-2.1.el7                                       base                                    29 k
libXpm                                                 x86_64                                3.5.10-5.1.el7                                      base                                    52 k
libaio                                                 x86_64                                0.3.109-12.el7                                      base                                    24 k
libcom_err-devel                                       x86_64                                1.42.9-4.el7                                        base                                    30 k
libjpeg-turbo                                          x86_64                                1.2.90-5.el7                                        base                                   134 k
libpng                                                 x86_64                                2:1.5.13-5.el7                                      base                                   212 k
libselinux-devel                                       x86_64                                2.2.2-6.el7                                         base                                   174 k
libsepol-devel                                         x86_64                                2.1.9-3.el7                                         base                                    71 k
libverto-devel                                         x86_64                                0.2.5-4.el7                                         base                                    12 k
libxcb                                                 x86_64                                1.9-5.el7                                           base                                   169 k
openssl-devel                                          x86_64                                1:1.0.1e-34.el7_0.7                                 updates                                1.2 M
pcre-devel                                             x86_64                                8.32-12.el7                                         base                                   477 k
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-Env                                               noarch                                1.04-2.el7                                          base                                    16 k
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-GD                                                x86_64                                2.49-3.el7                                          base                                   173 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-Test-Harness                                      noarch                                3.28-2.el7                                          base                                   302 k
perl-Test-Simple                                       noarch                                0.98-243.el7                                        base                                   170 k
perl-Text-ParseWords                                   noarch                                3.29-4.el7                                          base                                    14 k
perl-Time-HiRes                                        x86_64                                4:1.9725-3.el7                                      base                                    45 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
zlib-devel                                             x86_64                                1.2.7-13.el7                                        base                                    49 k

Transaction Summary
===============================================================================================================================================================================================
Install  7 Packages (+59 Dependent packages)

===============================================================================================================================================================================================
Install  7 Packages (+59 Dependent packages)

Total download size: 57 M
Installed size: 327 M
Downloading packages:
(1/66): fontpackages-filesystem-1.44-8.el7.noarch.rpm                                                                                                                   | 9.9 kB  00:00:00
(2/66): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm                                                                                                                      |  37 kB  00:00:00
(3/66): libX11-common-1.6.0-2.1.el7.noarch.rpm                                                                                                                          | 181 kB  00:00:00
(4/66): libXau-1.0.8-2.1.el7.x86_64.rpm                                                                                                                                 |  29 kB  00:00:00
(5/66): krb5-devel-1.11.3-49.el7.x86_64.rpm                                                                                                                             | 611 kB  00:00:00
(6/66): libXpm-3.5.10-5.1.el7.x86_64.rpm                                                                                                                                |  52 kB  00:00:00
(7/66): libcom_err-devel-1.42.9-4.el7.x86_64.rpm                                                                                                                        |  30 kB  00:00:00
(8/66): libjpeg-turbo-1.2.90-5.el7.x86_64.rpm                                                                                                                           | 134 kB  00:00:00
(9/66): libX11-1.6.0-2.1.el7.x86_64.rpm                                                                                                                                 | 605 kB  00:00:00
(10/66): libpng-1.5.13-5.el7.x86_64.rpm                                                                                                                                 | 212 kB  00:00:00
(11/66): libaio-0.3.109-12.el7.x86_64.rpm                                                                                                                               |  24 kB  00:00:00
(12/66): libverto-devel-0.2.5-4.el7.x86_64.rpm                                                                                                                          |  12 kB  00:00:00
(13/66): libsepol-devel-2.1.9-3.el7.x86_64.rpm                                                                                                                          |  71 kB  00:00:00
(14/66): libxcb-1.9-5.el7.x86_64.rpm                                                                                                                                    | 169 kB  00:00:00
(15/66): libselinux-devel-2.2.2-6.el7.x86_64.rpm                                                                                                                        | 174 kB  00:00:00
(16/66): fontconfig-2.10.95-7.el7.x86_64.rpm                                                                                                                            | 228 kB  00:00:01
(17/66): gd-2.0.35-26.el7.x86_64.rpm                                                                                                                                    | 146 kB  00:00:01
(18/66): mariadb-devel-5.5.41-2.el7_0.x86_64.rpm                                                                                                                        | 747 kB  00:00:01
(19/66): mariadb-bench-5.5.41-2.el7_0.x86_64.rpm                                                                                                                        | 386 kB  00:00:01
(20/66): mariadb-5.5.41-2.el7_0.x86_64.rpm                                                                                                                              | 8.9 MB  00:00:03
(21/66): mariadb-test-5.5.41-2.el7_0.x86_64.rpm                                                                                                                         | 8.0 MB  00:00:04
(22/66): mariadb-embedded-5.5.41-2.el7_0.x86_64.rpm                                                                                                                     | 3.6 MB  00:00:06
(23/66): pcre-devel-8.32-12.el7.x86_64.rpm                                                                                                                              | 477 kB  00:00:00
(24/66): perl-Carp-1.26-244.el7.noarch.rpm                                                                                                                              |  19 kB  00:00:00
(25/66): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm                                                                                                                 |  32 kB  00:00:00
(26/66): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm                                                                                                                  |  57 kB  00:00:00
(27/66): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                                                                                                                          | 140 kB  00:00:00
(28/66): perl-DBI-1.627-4.el7.x86_64.rpm                                                                                                                                | 802 kB  00:00:00
(29/66): perl-Data-Dumper-2.145-3.el7.x86_64.rpm                                                                                                                        |  47 kB  00:00:00
(30/66): perl-Encode-2.51-7.el7.x86_64.rpm                                                                                                                              | 1.5 MB  00:00:00
(31/66): perl-Env-1.04-2.el7.noarch.rpm                                                                                                                                 |  16 kB  00:00:00
(32/66): perl-Exporter-5.68-3.el7.noarch.rpm                                                                                                                            |  28 kB  00:00:00
(33/66): perl-File-Path-2.09-2.el7.noarch.rpm                                                                                                                           |  26 kB  00:00:00
(34/66): perl-File-Temp-0.23.01-3.el7.noarch.rpm                                                                                                                        |  56 kB  00:00:00
(35/66): perl-Filter-1.49-3.el7.x86_64.rpm                                                                                                                              |  76 kB  00:00:00
(36/66): perl-GD-2.49-3.el7.x86_64.rpm                                                                                                                                  | 173 kB  00:00:00
(37/66): perl-Getopt-Long-2.40-2.el7.noarch.rpm                                                                                                                         |  56 kB  00:00:00
(38/66): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                                                                                                                          |  38 kB  00:00:00
(39/66): perl-IO-Compress-2.061-2.el7.noarch.rpm                                                                                                                        | 260 kB  00:00:00
(40/66): perl-Net-Daemon-0.48-5.el7.noarch.rpm                                                                                                                          |  51 kB  00:00:00
(41/66): perl-PathTools-3.40-5.el7.x86_64.rpm                                                                                                                           |  82 kB  00:00:00
(42/66): perl-PlRPC-0.2020-14.el7.noarch.rpm                                                                                                                            |  36 kB  00:00:00
(43/66): perl-Pod-Escapes-1.04-283.el7.noarch.rpm                                                                                                                       |  49 kB  00:00:00
(44/66): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                                                                                                                         |  87 kB  00:00:00
(45/66): perl-Pod-Simple-3.28-4.el7.noarch.rpm                                                                                                                          | 216 kB  00:00:00
(46/66): perl-Pod-Usage-1.63-3.el7.noarch.rpm                                                                                                                           |  27 kB  00:00:00
(47/66): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm                                                                                                                 |  36 kB  00:00:00
(48/66): perl-Socket-2.010-3.el7.x86_64.rpm                                                                                                                             |  49 kB  00:00:00
(49/66): perl-Storable-2.45-3.el7.x86_64.rpm                                                                                                                            |  77 kB  00:00:00
(50/66): perl-Test-Harness-3.28-2.el7.noarch.rpm                                                                                                                        | 302 kB  00:00:00
(51/66): perl-Test-Simple-0.98-243.el7.noarch.rpm                                                                                                                       | 170 kB  00:00:00
(52/66): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                                                                                                                     |  14 kB  00:00:00
(53/66): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm                                                                                                                        |  45 kB  00:00:00
(54/66): perl-Time-Local-1.2300-2.el7.noarch.rpm                                                                                                                        |  24 kB  00:00:00
(55/66): mariadb-server-5.5.41-2.el7_0.x86_64.rpm                                                                                                                       |  11 MB  00:00:09
(56/66): perl-constant-1.27-2.el7.noarch.rpm                                                                                                                            |  19 kB  00:00:00
(57/66): perl-macros-5.16.3-283.el7.x86_64.rpm                                                                                                                          |  42 kB  00:00:00
(58/66): perl-parent-0.225-244.el7.noarch.rpm                                                                                                                           |  12 kB  00:00:00
(59/66): perl-podlators-2.5.1-3.el7.noarch.rpm                                                                                                                          | 112 kB  00:00:00
(60/66): perl-threads-1.87-4.el7.x86_64.rpm                                                                                                                             |  49 kB  00:00:00
(61/66): perl-threads-shared-1.43-6.el7.x86_64.rpm                                                                                                                      |  39 kB  00:00:00
(62/66): zlib-devel-1.2.7-13.el7.x86_64.rpm                                                                                                                             |  49 kB  00:00:00
(63/66): perl-libs-5.16.3-283.el7.x86_64.rpm                                                                                                                            | 686 kB  00:00:00
(64/66): openssl-devel-1.0.1e-34.el7_0.7.x86_64.rpm                                                                                                                     | 1.2 MB  00:00:10
(65/66): mariadb-embedded-devel-5.5.41-2.el7_0.x86_64.rpm                                                                                                               | 7.4 MB  00:00:13
(66/66): perl-5.16.3-283.el7.x86_64.rpm                                                                                                                                 | 8.0 MB  00:00:11
———————————————————————————————————————————————————————————————–
Total                                                                                                                                                          3.0 MB/s |  57 MB  00:00:19
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libaio-0.3.109-12.el7.x86_64                                                                                                                                               1/66
Installing : libjpeg-turbo-1.2.90-5.el7.x86_64                                                                                                                                          2/66
Installing : 2:libpng-1.5.13-5.el7.x86_64                                                                                                                                               3/66
Installing : 1:mariadb-embedded-5.5.41-2.el7_0.x86_64                                                                                                                                   4/66
Installing : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                         5/66
Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                          6/66
Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                         7/66
Installing : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                          8/66
Installing : 1:perl-Pod-Escapes-1.04-283.el7.noarch                                                                                                                                     9/66
Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                          10/66
Installing : perl-Encode-2.51-7.el7.x86_64                                                                                                                                             11/66
Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                    12/66
Installing : 4:perl-libs-5.16.3-283.el7.x86_64                                                                                                                                         13/66
Installing : perl-Exporter-5.68-3.el7.noarch                                                                                                                                           14/66
Installing : perl-constant-1.27-2.el7.noarch                                                                                                                                           15/66
Installing : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                       16/66
Installing : perl-Socket-2.010-3.el7.x86_64                                                                                                                                            17/66
Installing : perl-Carp-1.26-244.el7.noarch                                                                                                                                             18/66
Installing : perl-Storable-2.45-3.el7.x86_64                                                                                                                                           19/66
Installing : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                          20/66
Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                21/66
Installing : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                       22/66
Installing : perl-File-Path-2.09-2.el7.noarch                                                                                                                                          23/66
Installing : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                     24/66
Installing : perl-threads-1.87-4.el7.x86_64                                                                                                                                            25/66
Installing : perl-Filter-1.49-3.el7.x86_64                                                                                                                                             26/66
Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                       27/66
Installing : perl-Getopt-Long-2.40-2.el7.noarch                                                                                                                                        28/66
Installing : 4:perl-macros-5.16.3-283.el7.x86_64                                                                                                                                       29/66
Installing : 4:perl-5.16.3-283.el7.x86_64                                                                                                                                              30/66
Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                                       31/66
Installing : 1:mariadb-5.5.41-2.el7_0.x86_64                                                                                                                                           32/66
Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                     33/66
Installing : perl-Test-Harness-3.28-2.el7.noarch                                                                                                                                       34/66
Installing : perl-Test-Simple-0.98-243.el7.noarch                                                                                                                                      35/66
Installing : perl-Env-1.04-2.el7.noarch                                                                                                                                                36/66
Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                                                37/66
Installing : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                                         38/66
Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                                               39/66
Installing : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                                       40/66
Installing : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                                           41/66
Installing : perl-DBI-1.627-4.el7.x86_64                                                                                                                                               42/66
Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                                                                                                                                         43/66
Installing : 1:mariadb-server-5.5.41-2.el7_0.x86_64                                                                                                                                    44/66
Installing : libXau-1.0.8-2.1.el7.x86_64                                                                                                                                               45/66
Installing : libxcb-1.9-5.el7.x86_64                                                                                                                                                   46/66
Installing : libverto-devel-0.2.5-4.el7.x86_64                                                                                                                                         47/66
Installing : zlib-devel-1.2.7-13.el7.x86_64                                                                                                                                            48/66
Installing : pcre-devel-8.32-12.el7.x86_64                                                                                                                                             49/66
Installing : fontpackages-filesystem-1.44-8.el7.noarch                                                                                                                                 50/66
Installing : fontconfig-2.10.95-7.el7.x86_64                                                                                                                                           51/66
Installing : libcom_err-devel-1.42.9-4.el7.x86_64                                                                                                                                      52/66
Installing : libX11-common-1.6.0-2.1.el7.noarch                                                                                                                                        53/66
Installing : libX11-1.6.0-2.1.el7.x86_64                                                                                                                                               54/66
Installing : libXpm-3.5.10-5.1.el7.x86_64                                                                                                                                              55/66
Installing : gd-2.0.35-26.el7.x86_64                                                                                                                                                   56/66
Installing : perl-GD-2.49-3.el7.x86_64                                                                                                                                                 57/66
Installing : libsepol-devel-2.1.9-3.el7.x86_64                                                                                                                                         58/66
Installing : libselinux-devel-2.2.2-6.el7.x86_64                                                                                                                                       59/66
Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                                                                    60/66
Installing : krb5-devel-1.11.3-49.el7.x86_64                                                                                                                                           61/66
Installing : 1:openssl-devel-1.0.1e-34.el7_0.7.x86_64                                                                                                                                  62/66
Installing : 1:mariadb-devel-5.5.41-2.el7_0.x86_64                                                                                                                                     63/66
Installing : 1:mariadb-embedded-devel-5.5.41-2.el7_0.x86_64                                                                                                                            64/66
Installing : 1:mariadb-bench-5.5.41-2.el7_0.x86_64                                                                                                                                     65/66
Installing : 1:mariadb-test-5.5.41-2.el7_0.x86_64                                                                                                                                      66/66
Verifying  : 4:perl-macros-5.16.3-283.el7.x86_64                                                                                                                                        1/66
Verifying  : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                                                                     2/66
Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                          3/66
Verifying  : 1:mariadb-embedded-5.5.41-2.el7_0.x86_64                                                                                                                                   4/66
Verifying  : libsepol-devel-2.1.9-3.el7.x86_64                                                                                                                                          5/66
Verifying  : libX11-common-1.6.0-2.1.el7.noarch                                                                                                                                         6/66
Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                      7/66
Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                      8/66
Verifying  : 2:libpng-1.5.13-5.el7.x86_64                                                                                                                                               9/66
Verifying  : perl-Exporter-5.68-3.el7.noarch                                                                                                                                           10/66
Verifying  : perl-constant-1.27-2.el7.noarch                                                                                                                                           11/66
Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                          12/66
Verifying  : libcom_err-devel-1.42.9-4.el7.x86_64                                                                                                                                      13/66
Verifying  : libaio-0.3.109-12.el7.x86_64                                                                                                                                              14/66
Verifying  : libXpm-3.5.10-5.1.el7.x86_64                                                                                                                                              15/66
Verifying  : perl-Test-Harness-3.28-2.el7.noarch                                                                                                                                       16/66
Verifying  : fontpackages-filesystem-1.44-8.el7.noarch                                                                                                                                 17/66
Verifying  : 1:openssl-devel-1.0.1e-34.el7_0.7.x86_64                                                                                                                                  18/66
Verifying  : perl-Env-1.04-2.el7.noarch                                                                                                                                                19/66
Verifying  : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                        20/66
Verifying  : perl-Test-Simple-0.98-243.el7.noarch                                                                                                                                      21/66
Verifying  : perl-GD-2.49-3.el7.x86_64                                                                                                                                                 22/66
Verifying  : 1:mariadb-test-5.5.41-2.el7_0.x86_64                                                                                                                                      23/66
Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                       24/66
Verifying  : 1:mariadb-server-5.5.41-2.el7_0.x86_64                                                                                                                                    25/66
Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                       26/66
Verifying  : 4:perl-libs-5.16.3-283.el7.x86_64                                                                                                                                         27/66
Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                       28/66
Verifying  : pcre-devel-8.32-12.el7.x86_64                                                                                                                                             29/66
Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                        30/66
Verifying  : perl-DBI-1.627-4.el7.x86_64                                                                                                                                               31/66
Verifying  : perl-Socket-2.010-3.el7.x86_64                                                                                                                                            32/66
Verifying  : 1:mariadb-5.5.41-2.el7_0.x86_64                                                                                                                                           33/66
Verifying  : libxcb-1.9-5.el7.x86_64                                                                                                                                                   34/66
Verifying  : 4:perl-5.16.3-283.el7.x86_64                                                                                                                                              35/66
Verifying  : perl-Carp-1.26-244.el7.noarch                                                                                                                                             36/66
Verifying  : libselinux-devel-2.2.2-6.el7.x86_64                                                                                                                                       37/66
Verifying  : 1:mariadb-bench-5.5.41-2.el7_0.x86_64                                                                                                                                     38/66
Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                                       39/66
Verifying  : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                         40/66
Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                                                41/66
Verifying  : libjpeg-turbo-1.2.90-5.el7.x86_64                                                                                                                                         42/66
Verifying  : perl-Storable-2.45-3.el7.x86_64                                                                                                                                           43/66
Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                44/66
Verifying  : gd-2.0.35-26.el7.x86_64                                                                                                                                                   45/66
Verifying  : zlib-devel-1.2.7-13.el7.x86_64                                                                                                                                            46/66
Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                                         47/66
Verifying  : libX11-1.6.0-2.1.el7.x86_64                                                                                                                                               48/66
Verifying  : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                                       49/66
Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                          50/66
Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                                                                                                                         51/66
Verifying  : perl-Encode-2.51-7.el7.x86_64                                                                                                                                             52/66
Verifying  : libverto-devel-0.2.5-4.el7.x86_64                                                                                                                                         53/66
Verifying  : perl-Getopt-Long-2.40-2.el7.noarch                                                                                                                                        54/66
Verifying  : 1:mariadb-embedded-devel-5.5.41-2.el7_0.x86_64                                                                                                                            55/66
Verifying  : libXau-1.0.8-2.1.el7.x86_64                                                                                                                                               56/66
Verifying  : perl-File-Path-2.09-2.el7.noarch                                                                                                                                          57/66
Verifying  : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                                           58/66
Verifying  : 1:mariadb-devel-5.5.41-2.el7_0.x86_64                                                                                                                                     59/66
Verifying  : perl-threads-1.87-4.el7.x86_64                                                                                                                                            60/66
Verifying  : fontconfig-2.10.95-7.el7.x86_64                                                                                                                                           61/66
Verifying  : perl-Filter-1.49-3.el7.x86_64                                                                                                                                             62/66
Verifying  : 1:perl-Pod-Escapes-1.04-283.el7.noarch                                                                                                                                    63/66
Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                    64/66
Verifying  : krb5-devel-1.11.3-49.el7.x86_64                                                                                                                                           65/66
Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                                               66/66

Installed:
mariadb.x86_64 1:5.5.41-2.el7_0                      mariadb-bench.x86_64 1:5.5.41-2.el7_0        mariadb-devel.x86_64 1:5.5.41-2.el7_0       mariadb-embedded.x86_64 1:5.5.41-2.el7_0
mariadb-embedded-devel.x86_64 1:5.5.41-2.el7_0       mariadb-server.x86_64 1:5.5.41-2.el7_0       mariadb-test.x86_64 1:5.5.41-2.el7_0

Dependency Installed:
fontconfig.x86_64 0:2.10.95-7.el7           fontpackages-filesystem.noarch 0:1.44-8.el7     gd.x86_64 0:2.0.35-26.el7                      keyutils-libs-devel.x86_64 0:1.5.8-3.el7
krb5-devel.x86_64 0:1.11.3-49.el7           libX11.x86_64 0:1.6.0-2.1.el7                   libX11-common.noarch 0:1.6.0-2.1.el7           libXau.x86_64 0:1.0.8-2.1.el7
libXpm.x86_64 0:3.5.10-5.1.el7              libaio.x86_64 0:0.3.109-12.el7                  libcom_err-devel.x86_64 0:1.42.9-4.el7         libjpeg-turbo.x86_64 0:1.2.90-5.el7
libpng.x86_64 2:1.5.13-5.el7                libselinux-devel.x86_64 0:2.2.2-6.el7           libsepol-devel.x86_64 0:2.1.9-3.el7            libverto-devel.x86_64 0:0.2.5-4.el7
libxcb.x86_64 0:1.9-5.el7                   openssl-devel.x86_64 1:1.0.1e-34.el7_0.7        pcre-devel.x86_64 0:8.32-12.el7                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-Env.noarch 0:1.04-2.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-GD.x86_64 0:2.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-Test-Harness.noarch 0:3.28-2.el7          perl-Test-Simple.noarch 0:0.98-243.el7
perl-Text-ParseWords.noarch 0:3.29-4.el7    perl-Time-HiRes.x86_64 4:1.9725-3.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         zlib-devel.x86_64 0:1.2.7-13.el7

Complete!

[root@clusterserver1 ~]# systemctl start mariadb
[root@clusterserver1 ~]# systemctl enable mariadb
ln -s ‘/usr/lib/systemd/system/mariadb.service’ ‘/etc/systemd/system/multi-user.target.wants/mariadb.service’
[root@clusterserver1 ~]#

[root@clusterserver1 ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> show databases;
+——————–+
| Database           |
+——————–+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+——————–+
4 rows in set (0.00 sec)

MariaDB [(none)]>

MariaDB [(none)]> create database serverdb;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> use serverdb;
Database changed
MariaDB [serverdb]>
MariaDB [serverdb]> create table student (id int not null auto_increment, name varchar(10), birthday date, primary key (id));
Query OK, 0 rows affected (0.01 sec)

MariaDB [serverdb]> insert into student (name,birthday) values (“july”,”1981-93-03″), (“david”,”1988-09-02″);
Query OK, 2 rows affected, 1 warning (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 1

MariaDB [serverdb]> select * from student;
+—-+——-+————+
| id | name  | birthday   |
+—-+——-+————+
|  1 | july  | 0000-00-00 |
|  2 | david | 1988-09-02 |
+—-+——-+————+
2 rows in set (0.00 sec)

MariaDB [serverdb]> update student set birthday=”1988-10-01″ where name=”Jack”;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [serverdb]> create table student2 select * from student;
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [serverdb]> select * from student2;
+—-+——-+————+
| id | name  | birthday   |
+—-+——-+————+
|  1 | july  | 0000-00-00 |
|  2 | david | 1988-09-02 |
+—-+——-+————+
2 rows in set (0.00 sec)

MariaDB [serverdb]>
MariaDB [serverdb]> alter table student2 add column sex varchar(10);
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

MariaDB [serverdb]> select * from student2;
+—-+——-+————+——+
| id | name  | birthday   | sex  |
+—-+——-+————+——+
|  1 | july  | 0000-00-00 | NULL |
|  2 | david | 1988-09-02 | NULL |
+—-+——-+————+——+
2 rows in set (0.00 sec)

MariaDB [serverdb]> insert into student2 set birthday=”1988-10-01″, name=”raj”;
Query OK, 1 row affected (0.00 sec)

MariaDB [serverdb]> select * from student2;
+—-+——-+————+——+
| id | name  | birthday   | sex  |
+—-+——-+————+——+
|  1 | july  | 1933-10-01 | NULL |
|  2 | david | 1988-09-02 | NULL |
|  0 | raj   | 1988-10-01 | NULL |
+—-+——-+————+——+
3 rows in set (0.00 sec)

MariaDB [serverdb]> create table math (stuid int, result int, foreign key(stuid) references student(id) on delete cascade);
Query OK, 0 rows affected (0.00 sec)

MariaDB [serverdb]> select user();
+—————-+
| user()         |
+—————-+
| root@localhost |
+—————-+
1 row in set (0.00 sec)

MariaDB [serverdb]>

MariaDB [serverdb]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mysql]> show tables;
+—————————+
| Tables_in_mysql           |
+—————————+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+—————————+
24 rows in set (0.00 sec)

[root@clusterserver1 ~]# mysqladmin -u root password test123
[root@clusterserver1 ~]# mysqladmin -u root password ‘test123’
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’

[root@clusterserver1 ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> set password=password(‘test123’);
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit

Bye

vi /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

skip-grant-table

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[root@clusterserver1 ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> create user mohan@’localhost’
-> ;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]>

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> create user mohan@’localhost’
-> ;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> set password for mohan@’localhost’=password(‘test123’);
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye
[root@clusterserver1 ~]#

[root@clusterserver1 ~]# mysql -u mohan -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> set password for mohan@’localhost’=password(‘test123’);
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> select host,user,password from mysql.user;
ERROR 1142 (42000): SELECT command denied to user ‘mohan’@’localhost’ for table ‘user’
MariaDB [(none)]>

MariaDB [(none)]> show grants for mohan@’localhost’;
+————————————————————————————————————–+
| Grants for mohan@localhost                                                                                   |
+————————————————————————————————————–+
| GRANT USAGE ON *.* TO ‘mohan’@’localhost’ IDENTIFIED BY PASSWORD ‘*676243218923905CF94CB52A3C9D3EB30CE8E20D’ |
+————————————————————————————————————–+
1 row in set (0.00 sec)

MariaDB [(none)]>

MariaDB [(none)]> SHOW PRIVILEGES\G
*************************** 1. row ***************************
Privilege: Alter
Context: Tables
Comment: To alter the table
*************************** 2. row ***************************
Privilege: Alter routine
Context: Functions,Procedures
Comment: To alter or drop stored functions/procedures
*************************** 3. row ***************************
Privilege: Create
Context: Databases,Tables,Indexes
Comment: To create new databases and tables
*************************** 4. row ***************************
Privilege: Create routine
Context: Databases
Comment: To use CREATE FUNCTION/PROCEDURE
*************************** 5. row ***************************
Privilege: Create temporary tables
Context: Databases
Comment: To use CREATE TEMPORARY TABLE
*************************** 6. row ***************************
Privilege: Create view
Context: Tables
Comment: To create new views
*************************** 7. row ***************************
Privilege: Create user
Context: Server Admin
Comment: To create new users
*************************** 8. row ***************************
Privilege: Delete
Context: Tables
Comment: To delete existing rows
*************************** 9. row ***************************
Privilege: Drop
Context: Databases,Tables
Comment: To drop databases, tables, and views
*************************** 10. row ***************************
Privilege: Event
Context: Server Admin
Comment: To create, alter, drop and execute events
*************************** 11. row ***************************
Privilege: Execute
Context: Functions,Procedures
Comment: To execute stored routines
*************************** 12. row ***************************
Privilege: File
Context: File access on server
Comment: To read and write files on the server
*************************** 13. row ***************************
Privilege: Grant option
Context: Databases,Tables,Functions,Procedures
Comment: To give to other users those privileges you possess
*************************** 14. row ***************************
Privilege: Index
Context: Tables
Comment: To create or drop indexes
*************************** 15. row ***************************
Privilege: Insert
Context: Tables
Comment: To insert data into tables
*************************** 16. row ***************************
Privilege: Lock tables
Context: Databases
Comment: To use LOCK TABLES (together with SELECT privilege)
*************************** 17. row ***************************
Privilege: Process
Context: Server Admin
Comment: To view the plain text of currently executing queries
*************************** 18. row ***************************
Privilege: Proxy
Context: Server Admin
Comment: To make proxy user possible
*************************** 19. row ***************************
Privilege: References
Context: Databases,Tables
Comment: To have references on tables
*************************** 20. row ***************************
Privilege: Reload
Context: Server Admin
Comment: To reload or refresh tables, logs and privileges
*************************** 21. row ***************************
Privilege: Replication client
Context: Server Admin
Comment: To ask where the slave or master servers are
*************************** 22. row ***************************
Privilege: Replication slave
Context: Server Admin
Comment: To read binary log events from the master
*************************** 23. row ***************************
Privilege: Select
Context: Tables
Comment: To retrieve rows from table
*************************** 24. row ***************************
Privilege: Show databases
Context: Server Admin
Comment: To see all databases with SHOW DATABASES
*************************** 25. row ***************************
Privilege: Show view
Context: Tables
Comment: To see views with SHOW CREATE VIEW
*************************** 26. row ***************************
Privilege: Shutdown
Context: Server Admin
Comment: To shut down the server
*************************** 27. row ***************************
Privilege: Super
Context: Server Admin
Comment: To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.
*************************** 28. row ***************************
Privilege: Trigger
Context: Tables
Comment: To use triggers
*************************** 29. row ***************************
Privilege: Create tablespace
Context: Server Admin
Comment: To create/alter/drop tablespaces
*************************** 30. row ***************************
Privilege: Update
Context: Tables
Comment: To update existing rows
*************************** 31. row ***************************
Privilege: Usage
Context: Server Admin
Comment: No privileges – allow connect only
31 rows in set (0.00 sec)

MariaDB [(none)]>

 

 

o begin, sign into MySQL or MariaDB with the following command:

mysql -u root -p

Enter the administrator password you set up during installation. You will be given a MySQL/MariaDB prompt.

We can now create a database by typing the following command:

CREATE DATABASE new_database;
Query OK, 1 row affected (0.00 sec)

To avoid errors in the event that the database name we’ve chosen already exists, use the following command:

CREATE DATABASE IF NOT EXISTS new_database;
Query OK, 1 row affected, 1 warning (0.01 sec)

The warning indicates that the database already existed and no new database was created.

If we leave the “IF NOT EXISTS” option off, and the database already exists, we will receive the following error:

ERROR 1007 (HY000): Can't create database 'other_database'; database exists

How to View Databases in MySQL and MariaDB

To view a list of the current databases that you have created, use the following command:

SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| new_database       |
| other_database     |
| performance_schema |
+--------------------+
5 rows in set (0.00 sec)

The “information_schema”, “performance_schema”, and “mysql” databases are set up by default in most cases and should be left alone unless you know what you are doing.

How to Change Databases in MySQL and MariaDB

Any operations performed without explicitly specifying a database will be performed on the currently selected database.

Find out which database is currently selected with the following command:

SELECT database();
+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.01 sec)

We have received a result of “null”. This means that no database is currently selected.

To select a database to use for subsequent operations, use the following command:

USE new_database;
Database changed

We can see that the database has been selected by re-issuing the command we ran previously:

SELECT database();
+--------------+
| database()   |
+--------------+
| new_database |
+--------------+
1 row in set (0.00 sec)

How to Delete a Database in MySQL and MariaDB

To delete a database in MySQL or MariaDB, use the following command:

DROP DATABASE new_database;
Query OK, 0 rows affected (0.00 sec)

This operation cannot be reversed! Make certain you wish to delete before pressing enter!

If this command is executed on a database that does not exist, the following error message will be given:

DROP DATABASE new_database;
ERROR 1008 (HY000): Can't drop database 'new_database'; database doesn't exist

To prevent this error, and ensure that the command executes successfully regardless of if the database exists, call it with the following syntax:

DROP DATABASE IF EXISTS new_database;
Query OK, 0 rows affected, 1 warning (0.00 sec)

Lost Root Password

When you install MariaDB on Linux you have the option to create a root password. Chances are you immediately forgot it. No worries, because as long as you have Linux root access you can get into MariaDB.

First stop your database if it’s running. On Red Hat Linux, CentOS, and Fedora use the systemctl command:

$ sudo systemctl stop mariadb.service

On Debian, Ubuntu, and Linux Mint you can still use the service command:

$ sudo service mysql stop
 * Stopping MariaDB database server mysqld

Next, restart MariaDB with the mysqld_safe command, which is the safest way to start MariaDB. --skip-grant-tables starts the server with no user restrictions, so it’s wide open:

$ sudo mysqld_safe --skip-grant-tables --skip-networking &
[1] 11278
carla@studio:~/Documents/1articles/linuxcom$ 141029 19:37:57 mysqld_safe Logging to 
syslog.
141029 19:37:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

The --skip-networking option prevents anyone from sneaking in over the network. Obviously, don’t use this if you’re logging in remotely. Now you can reset the root password by using the mysql command shell. Login to MariaDB, select the mysql database, reset the root password, and then immediately exit:

$ mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 5.5.39-MariaDB-0ubuntu0.14.04.1 (Ubuntu)
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 [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> update user set password=PASSWORD("new-password") where User='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit
Bye

Now try logging in with your new password:

$ mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.39-MariaDB-0ubuntu0.14.04.1 (Ubuntu)

Use this one-liner to change the password of any user without logging in to the MariaDB shell:

$ mysqladmin -u carla -p 'old-password' password 'new-password'



Backup of the database 


[root@server ~]#  mysqldump --all-databases --user=root --password --master-data > backupdatabase.sql
Enter password: 
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
March 31st, 2015 | Category: mariadb | Leave a comment

Apache – Custom Error Page

Error handling is one of the important parts when running a server. The application running inside the server provides the necessary services to the client but it is the responsibility of the server to serve custom pages for errors. In this article we will see how we can configure custom error page 404 for Apache web server along with Tomcat.

  1. Create a 404 error page as

<html>

<head> Hello This a 404 Error page </head>

<body bgcolor=”green”>

</h3> this is green and 404 </h3>

</body>

</html>

Copy the file to /var/www/webroot/ROOT/ location

  1. Once the file is created, configure Apache Configuration file as

<VirtualHost *:80>

ServerAdmin webmaster@dummy-host.example.com

DocumentRoot /var/www/webroot/ROOT/

 ErrorDocument 404 /404.html

ServerName dummy-host.example.com

ErrorLog logs/dummy-host.example.com1-error_log

CustomLog logs/dummy-host.example.com1-access_log common

ProxyRequests Off

ProxyPreserveHost On

<Proxy *>

Order deny,allow

Allow from all

Options +Indexes

</Proxy>

ProxyPass /application1 http://localhost:8080/myApp/

ProxyPass /application2 http://localhost:8080/Sample-app/test.html

ProxyPassReverse /application1/ http://localhost:8080/myApp/

ProxyPassReverse /application2/ http://localhost:8080/Sample-app/test.html

</VirtualHost>

All we need to do is add an ErrorDocument entry to our http.conf file. On the ErrorDocument line, we specify the error code, which in this case is a 404. After that, we can specify either a text message or the page to display and then file to be displayed ( 404.html ). Restart the Apache server.

Now once we access a different path, we see the 404 error page as,

apache

March 31st, 2015 | Category: Apache | Leave a comment

Tomcat Version Change

While working with Tomcat, we observed that Tomcat displays Error Page which has the Tomcat version on it. When ever we call a page which is not available , the tomcat server will push a Error page along with the version like –

tomcat safas

 

The Error page will also display the Version of the apache which may allow people to exploit the server since old tomcat server has some known exploits.

In this article we will see how we can change the version number on the error page to a different one.

Create a Directory location in  Tomcat Server lib location as

mkdir –p /lib/org/apache/catalina/util/

In the util location, create a properties file as

[root@localhost util]# cat ServerInfo.properties

server.info=Apache Tomcat Version XXX

Now restart tomcat and access a application which is not available and we will see this,

 

tomcat 3

March 31st, 2015 | Category: tomcat | Leave a comment
« Newer Entries  
  Older Entries »