Skip to main content

OnlineSupport4u

x
Discover More Discover More

Cloudflare with Engintron

By PrasadNaik
July 24, 2017

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

By PrasadNaik
July 20, 2017

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

By PrasadNaik
July 20, 2017

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

Sorry, the domain xx.xx.104.in-addr.arpa is owned by another user (nobody)

By PrasadNaik
March 6, 2017

While adding rDNS file in cpanel server I was getting below mentioned error Sorry, the domain xx.xx.104.in-addr.arpa is owned by another user (nobody) I have found that at one point in the past this domain was present on this server. I have removed remnants of the domain from /var/cpanel/users/system and removed references to it from […]

Read More

Ignore table and dump mysql database

By PrasadNaik
January 20, 2017

-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

By PrasadNaik
October 19, 2016

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

By PrasadNaik
August 23, 2016

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

By PrasadNaik
July 20, 2016

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

mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’

By PrasadNaik
July 15, 2016

While creating of backup of mysql I was getting below error mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’ (Errcode: 24 “Too many open files”)’ The error is due to Mysql exceeding the limit of open files on mysql So I just went ahead and saw the open file limit MariaDB [(none)]> SHOW VARIABLES […]

Read More
1 … 10 11 12 … 15