Mysql - OnlineSupport4u

Mysql

RTNETLINK answers: File exists

By Prasad Naik

June 3, 2014

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: […]

Mysql

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

By Prasad Naik

June 2, 2014

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* […]

Mysql

Removing a LVM Volume Group in Linux

By Prasad Naik

May 21, 2014

[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 […]

Mysql

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

By Prasad Naik

April 30, 2014

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

Mysql

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

By Prasad Naik

April 26, 2014

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

Mysql

How to remove a logical volume

By Prasad Naik

April 10, 2014

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 […]

Linux

Domain name Transfer

By Prasad Naik

March 30, 2014

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 […]

Mysql

The mod_security plugin could not connect to the database: cPanel

By Prasad Naik

March 23, 2014

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 = […]

Mysql

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

By Prasad Naik

October 28, 2013

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‘;

Mysql

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

By Prasad Naik

August 20, 2013

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 […]

Mysql

Repair table in Virtualizor

By Prasad Naik

August 17, 2013

Facing issues in Virtualizor for database crash ? The mysql library is not located in normal /var/lib/mysql it located in /usr/local/emps/bin/ To repair database you need to use below command [root@hostabc.virtualizor]# /usr/local/emps/bin/myisamchk -r *.MYI Once completed all things should back to normal 🙂