Category Archives: Mysql

RTNETLINK answers: File exists

Openvz architecture in Centos 6.5 has an issue

If you are facing issues where ifconfig shows no ip address or below error

root@server [/]# ifconfig
root@server [/]# /etc/init.d/network restart
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: RTNETLINK answers: Operation not supported
Failed to bring up lo.
[FAILED]
Bringing up interface venet0: RTNETLINK answers: Operation not supported
Failed to bring up venet0.
[FAILED]
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists

Below is the solution for this issue

Its due to package iproute which is causing this issue

Use below method to fix it

Login to main node of the server

[root@hostonine ~]# wget http://repo.smartservermanagement.com/misc/iproute-2.6.32-23.el6.x86_64.rpm
–2014-06-03 08:21:42– http://repo.smartservermanagement.com/misc/iproute-2.6.32-23.el6.x86_64.rpm
Resolving repo.smartservermanagement.com… 95.154.203.53
Connecting to repo.smartservermanagement.com|95.154.203.53|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 351552 (343K) [application/x-rpm]
Saving to: `iproute-2.6.32-23.el6.x86_64.rpm’

100%[====================================================================================================================>] 351,552 421K/s in 0.8s

2014-06-03 08:21:44 (421 KB/s) – `iproute-2.6.32-23.el6.x86_64.rpm’ saved [351552/351552]

#Copy the package to vps using below command where 180 is VPS ID

[root@hostonline ~]# scp -r iproute-2.6.32-23.el6.x86_64.rpm /vz/private/180/var/

#Now login to VPS

[root@hostonline ~]# vzctl enter 180
entered into CT 180
root@server [/]# cd /var/

Check for the rpm iproute

root@server [/var]# rpm -q iproute
iproute-2.6.32-31.el6.x86_64

#Remove the old rpm

root@server [/var]# rpm -e iproute-2.6.32-31.el6.x86_64 –nodeps

#Install the new RPM

root@server [/var]# rpm -Uvh iproute-2.6.32-23.el6.x86_64.rpm
warning: iproute-2.6.32-23.el6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 192a7d7d: NOKEY
Preparing… ########################################### [100%] 1:iproute ########################################### [100%]

#Now restart networking and check

root@server [/var]# service network restart
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface venet0: Determining if ip address 127.0.0.1 is already in use for device venet0…
[ OK ]
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists
RTNETLINK answers: File exists

WordPress Asking For FTP details every time you want to add, delete or upgrade a plugin?

Facing issues on wordpress blog where its asking for ftp login when trying to install new plugin ?

Add the below lines in wp-config.php and save it

This should do the trick in solving this issue

//*added ftp login credentials to avoid WordPress asking for FTP details every time I wanted to upgrade a plugin*

define('FTP_HOST', 'ftp.yoursite.com');
define('FTP_USER', 'Your_FTP_Username');
define('FTP_PASS', 'Your_FTP_password');
//*If you can use a SSL connection set this to true*
define('FTP_SSL', true);

Removing a LVM Volume Group in Linux

[root@host1Z1 ~]# vgdisplay

— Volume group —
VG Name               vol_grp1
System ID
Format                lvm2
Metadata Areas        1
Metadata Sequence No 165
VG Access             read/write
VG Status             resizable
MAX LV                0
Cur LV                10
Open LV               2
Max PV                0
Cur PV                1
Act PV                1
VG Size               839.84 GiB
PE Size               4.00 MiB
Total PE              214999
Alloc PE / Size       212480 / 830.00 GiB
Free PE / Size       2519 / 9.84 GiB
VG UUID               FOtjrl-D7bL-WH71-Ls55-fDEu-7es3-mjkhAu

# lvmdiskscan

/dev/ram0                [      16.00 MiB]
/dev/sda                 [     931.51 GiB]
/dev/ram1                [      16.00 MiB]
/dev/vol_grp1/vs1003     [     120.00 GiB]
/dev/ram2                [      16.00 MiB]
/dev/ram3                [      16.00 MiB]
/dev/vol_grp1/nteraabb9q [     120.00 GiB]
/dev/ram4                [      16.00 MiB]
/dev/vol_grp1/vs1013     [     120.00 GiB]
/dev/ram5                [      16.00 MiB]
/dev/ram6                [      16.00 MiB]
/dev/vol_grp1/vs1014     [      60.00 GiB]
/dev/ram7                [      16.00 MiB]
/dev/ram8                [      16.00 MiB]
/dev/vol_grp1/ntsrmdeedm [      60.00 GiB]
/dev/ram9                [      16.00 MiB]
/dev/vol_grp1/vs1015     [     210.00 GiB]
/dev/ram10               [      16.00 MiB]
/dev/ram11               [      16.00 MiB]
/dev/vol_grp1/vs1016     [     150.00 GiB]
/dev/ram12               [      16.00 MiB]
/dev/ram13               [      16.00 MiB]
/dev/ram14               [      16.00 MiB]
/dev/ram15               [      16.00 MiB]
/dev/vol_grp1/vs1017     [      70.00 GiB]
/dev/sdb1                [      78.12 GiB]
/dev/sdb2                [     839.84 GiB] LVM physical volume
/dev/sdb3                [       7.81 GiB]
3 disks
24 partitions
0 LVM physical volume whole disks
1 LVM physical volume

[root@host1AZ ~]# lvscan

ACTIVE   Original ‘/dev/vol_grp1/vs1003’ [120.00 GiB] inherit
ACTIVE            ‘/dev/vol_grp1/vs1013’ [120.00 GiB] inherit
ACTIVE   Original ‘/dev/vol_grp1/vs1014’ [60.00 GiB] inherit
ACTIVE            ‘/dev/vol_grp1/vs1015’ [210.00 GiB] inherit
inactive Original ‘/dev/vol_grp1/vs1016’ [150.00 GiB] inherit
ACTIVE   Snapshot ‘/dev/vol_grp1/ntsrmdeedm’ [25.00 GiB] inherit
ACTIVE   Snapshot ‘/dev/vol_grp1/nteraabb9q’ [25.00 GiB] inherit
ACTIVE            ‘/dev/vol_grp1/vs1017’ [70.00 GiB] inherit
inactive Snapshot ‘/dev/vol_grp1/ntdraalemj’ [25.00 GiB] inherit
inactive Snapshot ‘/dev/vol_grp1/nt0ymc1zi2’ [25.00 GiB] inherit

vgchange -ay

10 logical volume(s) in volume group “vol_grp1” now active

[root@host11Z ~]# lvchange -an /dev/vol_grp1/vs1015

[root@host144 ~]# lvremove /dev/vol_grp1/vs1015

Logical volume “vs1015” successfully removed

[root@host12Z ~]# vgdisplay

— Volume group —
VG Name               vol_grp1
System ID
Format                lvm2
Metadata Areas        1
Metadata Sequence No 166
VG Access             read/write
VG Status             resizable
MAX LV                0

MX Logic blocking my mails with “554 Denied CS [*.mxlogic.net]“?

Your mails are blocked with the error message “554 Denied [CS] [*.mxlogic.net] (Mode: normal) (in reply to end of DATA command)”

What does it mean?

The mail was rejected by Mxlogic / Mcafee because of the content of the message.

Try using different message

Fatal error: Cannot make static method SGL_FrontController::run() non static in class RVSWebInit in

If you are facing issues with rvsitebuilder on cpanel server with error

“Fatal error: Cannot make static method SGL_FrontController::run() non static in class RVSWebInit in”

Run the below commands to fix it

perl /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller/autoinstaller.cgi –force=rvseagullmod

Then run update RVSitebuilder again.
perl /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller/autoinstaller.cgi –force=rvsitebuilder

Now republish the website, the error will be fixed

How to remove a logical volume

SSH to server and use the below steps

Check active volume first using

[root@load ~]# lvscan
ACTIVE            ‘/dev/vg_load/lv_root’ [50.00 GiB] inherit
ACTIVE            ‘/dev/vg_load/lv_home’ [53.80 GiB] inherit
ACTIVE            ‘/dev/vg_load/lv_swap’ [7.50 GiB] inherit

Say you want to remove the volume /dev/vg_load/lv_home

Type the below command

[root@load ~]# lvremove /dev/vg_load/lv_home
Do you really want to remove active logical volume lv_home? [y/n]: y
Logical volume “lv_home” successfully removed

Now the logical volume is deleted

which you can confirm using

[root@load ~]# lvscan
ACTIVE            ‘/dev/vg_load/lv_root’ [50.00 GiB] inherit
ACTIVE            ‘/dev/vg_load/lv_swap’ [7.50 GiB] inherit
[root@load ~]# lvdisplay
— Logical volume —
LV Path                /dev/vg_load/lv_root
LV Name                lv_root
VG Name                vg_load
LV UUID                jFKRVb-kzMk-bOkE-DZIR-T5PW-fkyf-Tb6txr
LV Write Access        read/write
LV Creation host, time load.onlinesupport4u.in, 2014-04-07 00:28:58 -0400
LV Status              available
# open                 1
LV Size                50.00 GiB
Current LE             12800
Segments               1
Allocation             inherit
Read ahead sectors     auto
– currently set to     256
Block device           253:0

— Logical volume —
LV Path                /dev/vg_load/lv_swap
LV Name                lv_swap
VG Name                vg_load
LV UUID                zNsC2f-9vxE-9cgA-6eFv-0Yrk-JWqG-GFEsId
LV Write Access        read/write
LV Creation host, time load.onlinesupport4u.in, 2014-04-07 00:29:30 -0400
LV Status              available
# open                 1
LV Size                7.50 GiB
Current LE             1920
Segments               1
Allocation             inherit
Read ahead sectors     auto
– currently set to     256
Block device           253:1

Domain name Transfer

To transfer the domain name from your old domain registrar to us Please apply using below URL

Once done please make sure the at your old domain registrar

1) You need to disable the privacy Protection 2) Disable Theft Protection 3) Get the EPP or Authorization code and email it to us at support@onlinesupport4u.in along with domain name

Domain name transfer take minimum 5 days to get transferred.

The mod_security plugin could not connect to the database: cPanel

If you have been getting the error “The mod_security plugin could not connect to the database”

Below are the steps to rectify it

SSH to server

Check the password set for modsec database using below command,

In my case below was the password

root@vps [~]# grep “dbpassword” /etc/cron.hourly/modsecparse.pl

my $dbpassword = ‘qS_lqkU5mXkA’;
my $dbh = DBI->connect( “DBI:mysql:$dbname:$dbhost”, $dbuser, $dbpassword )

The password set in my case as qS_lqkU5mXkA

Now login into mysql and use below steps

root@vps [~]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1569
Server version: 5.5.36-cll MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> 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
mysql> UPDATE user SET Password=PASSWORD(‘qS_lqkU5mXkA’) WHERE USER=’modsec’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit

You should be able to see working Mod_security

Connection To Storage Server Failed (Roundcube login issue, installed from cpanel)

Edit: /home/mydomain/pathtoroundcube/config/main.inc.php and changed
$rcmail_config[‘default_host’] = ‘ssl://imap.site.com’;
to
$rcmail_config[‘default_host’] = ‘mail.mydomain.com‘;

ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)

When I run the following command at mysql> I get an error which read as follows:

mysql> use dbname;

mysql> show tables;

ERROR 1018 (HY000): Can’t read dir of ‘./dbname/’ (errno: 13)

Solution to this is to set right permissions

#cd /var/lib/

chown mysql.mysql mysql -R

This fixed the issue and can run any commands on Mysql now.