Mysql - OnlineSupport4u

Mysql

Install Imagemagick on easyapache4

By Prasad Naik

August 13, 2018

yum install ImageMagick-devel ImageMagick-c++-devel ImageMagick-perl /usr/bin/convert --version /opt/cpanel/ea-php56/root/usr/bin/pecl install imagick

cPanel

[ERROR] Can’t init tc log Mariadb

By Prasad Naik

March 30, 2018

2018-03-30 2:06:19 139671858284288 [Note] InnoDB: Dumping buffer pool(s) not yet started 2018-03-30 2:06:19 139672598403328 [Note] Plugin ‘FEEDBACK’ is disabled. 2018-03-30 2:06:19 139672598403328 [Note] Recovering after a crash using tc.log 2018-03-30 2:06:19 139672598403328 [ERROR] Can’t init tc log 2018-03-30 2:06:19 139672598403328 [ERROR] Aborting Was getting above error in mysql errorlog The solution to this issue was […]

Mysql

Column count of mysql.user is wrong

By Prasad Naik

March 26, 2018

Was getting below error while trying to create mysql user in cpanel Error from MySQL query :(XID 5yuvwf) The system received an error from the “MySQL” database “mysql”: 1805 (Column count of mysql.user is wrong. Expected 43, found 39. The table is probably corrupted): The migration used a “mysqldump –all-databases” so it included the “mysql” […]

cPanel

The system could not create the user “triltch” because it conflicts with an unmanaged MySQL database user and an unmanaged PostgreSQL database user

By Prasad Naik

February 21, 2018

While creating a new account in server was getting below error The issue was due to mysql user already being present in server root@srv1 [~]# /scripts/wwwacct trill.com tritch hood773ud +===================================+ | New Account Info | +===================================+ | Domain: trill.com | UserName: tritch | PassWord: hood773ud +===================================+ This ok? yes Checking input data……Done Validating system setup……Done […]

Linux

Secure Connection Failed while accessing IPMI

By Prasad Naik

November 8, 2017

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

cPanel

Disable WordPress plugins from PHPmyadmin

By Prasad Naik

September 19, 2017

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

cPanel

Cloudflare with Engintron

By Prasad Naik

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

Mysql

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

By Prasad Naik

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

Mysql

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

By Prasad Naik

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

Mysql

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

By Prasad Naik

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

Mysql

Ignore table and dump mysql database

By Prasad Naik

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

Linux

Emails going to Spam folder issue

By Prasad Naik

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