Aarvi

Mysql

Secure Connection Failed while accessing IPMI

Secure Connection Failed An error occurred during a connection to 216.1x.1xx.xxx. You have received an invalid certificate. Please contact the server administrator or email correspondent and give them the following information: Your certificate contains the same serial number as another certificate issued by the certificate authority. Please get a new certificate containing a unique serial […]
Read more

Disable WordPress plugins from PHPmyadmin

You can easily disable all WordPress plugins directly from your database. This is useful when you have problems with your WordPress installation, such as not being able to log in to the admin Dashboard, or having blank pages on the website. If you don’t know which is the database used by your WordPress website, you […]
Read more

Cloudflare with Engintron

We had a issue where domain which is using cloudflare and server had engintron those domains were not working correctly Engintron does support Cloudflare . There are few custom rules which needs to be setup from WHM > Plugin > Emgintron  > Edit your custom_rules for Nginx For domains which have dedicated IP below is […]
Read more

mysqldump: Got error: 1017: Can’t find file: ‘wp_wfBadLeechers’ (errno: 2) when using LOCK TABLES

While making full backup of mysql using below command we got error mysqldump: Got error: 1017: Can’t find file: ‘wp_wfBadLeechers’ (errno: 2) when using LOCK TABLES # mysqldump –all-databases > /backup/all_databases.sql The issue was due to some corrupt tables Below is the fix used for  making a full dump of database ignoring error mysqldump –skip-lock-tables […]
Read more

Your server’s MySQL/MariaDB RPM target is set to “unmanaged”. cPanel

Was getting this error while trying to upgrade mysql in WHM/cPanel, Your server’s MySQL/MariaDB RPM target is set to “unmanaged”. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state. The issue was due to entry in file /var/cpanel/rpm.versions.d/local.versions set mysql to unmanaged Went ahead and set it to managed and […]
Read more

Ignore table and dump mysql database

-bash-4.1# mysqldump satmn13_drup189 > satmn13_drup1891.sql mysqldump: Got error: 1146: Table ‘satmn13_drup189.dr_cache_admin_menu’ doesn’t exist when using LOCK TABLES -bash-4.1# mysqldump satmn13_drup189 –ignore-table=satmn13_drup189.dr_cache_admin_menu > satmn13_drup1891.sql
Read more

Emails going to Spam folder issue

We do get complaints of emails going to spam folder most of the times while working. The solution to such a issues depends on 3 things rdns for the IP address and matching A record for the domain name in question. Need to setup right SPF Need to setup right DKIM a) To setup SPF […]
Read more

Error: exim logged Undefined subroutine &main::user2uid called. LOG: MAIN

Exim error : LOG: MAIN cwd=/root 4 args: /usr/sbin/exim -i -v testemail@gmail.com LOG: MAIN REJECT F=<root@darkmatter.dnsprotect.com> rejected by non-SMTP ACL: failed to expand ACL string "${if eq{$originator_uid}{${perl{user2uid}{nobody}}}{1}{0}}": Undefined subroutine &main::user2uid called. LOG: MAIN cwd=/var/spool/exim 8 args: /usr/sbin/exim -v -t -oem -oi -f <> -E1UY3r2-000 root@server-web [~]# /scripts/buildeximconf Configuration file passes test! New configuration file was […]
Read more

Disable Strict Mode mysql mariadb

While working on WHMCS I was not able to generate tickets I found out issue was due to mysql being in strict mode I tried disabling mysql strict mode  by adding entries in  /etc/my.cnf sql_mode=”” However it didnt work out. I have found that there is a /usr/my.cnf file that is enabling strict mode on  […]
Read more

Aarvi server solutions Is a Web Hosting Support Company that has built a solid reputation for quality, reliability, and true professional service