Aarvi

cPanel

How to fix innodb_table_stats and innodb_index_stats has length mismatch

While Checking Mysql error logs could see below error 2021-03-31 0:04:00 1222 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-03-31 0:04:00 1222 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-03-31 0:04:00 1222 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch […]
Read more

admin bin cPanel/cpmysql/DBCACHE: exit 11

Currently aware of an issue when updating to MariaDB 10.3.26 or MariaDB 10.2.35. Which causes MySQL Databases interface within cPanel to display invalid errors such as, but not limited to: “The MySQL server is currently offline”. While the error in cPanel may indicate that the MySQL service is offline, it is an issue with grants […]
Read more

WHMCS client area blank

I was having an issue where WHMCS admin panel was working fine However, client area was showing a blank page So I enabled error logging in WHMCS in configuration.php file using below parameter $display_errors = true; and tried accessing WHMCS client area It showed Memory error which was a PHP memory issue Increasing PHP memory […]
Read more

Too many concurrent SMTP connections errors exim

The default value for smtp_Accept_max in exim.conf is 30 in cpanel You need to login to WHM > Home »Service Configuration »Exim Configuration Manager >> Advanced Editor Search for parameter smtp_Accept_max and change the value to 100 and save this will save file and restart exim and resolve the issue
Read more

Magento error Invalid command ‘

Invalid command ‘<IfVersion’, perhaps misspelled or defined by a module not included in the server configuration The above error is due to missing mod_version which needs to be added in apache using easyapache it was fixed once the mod_version module was added          
Read more

[ERROR] Can’t init tc log Mariadb

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

umount: /backup: device is busy

While trying to unmount a secondary drive I see below error umount: /backup: device is busy. (In some cases useful info about processes that use the device is found by lsof(8) or fuser(1)) The issue was due to the drive /dev/sdb being used by some process Below is the process on how to find process […]
Read more

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

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

SMTP AUTH is required for message submission on port 587

The ‘SMTP AUTH’ error usually happens when users try to send mails without properly authenticating their mail account in email clients such as Outlook or Thunderbird. What causes the error ‘SMTP AUTH is required for message submission on port 587’ in cPanel/WHM servers With the latest cPanel/WHM update, email accounts that were working fine till […]
Read more

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