Eric Delorme
- Total activity 556
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 392
Articles
Recent activity by Eric Delorme-
MySQL Password reset Operation ALTER USER failed for user
Symptoms You reset the MySQL user password for a cPanel user but that password doesn't work. Description The database user can't be changed because of error "ERROR 1396 (HY000): Operation ALTER ...
-
How to increase open files limits for MariaDB
Introduction The my.cnf setting for open_files_limit may not be taken as a variable and needs to be set via systemd. Procedure Access the server via SSH as the root user Create the limits file a...
-
MySQL Governor and users getting limited/restricted by max_user_connections
Symptoms CloudLinux is the base operating system with MySQL Governor installed and suddenly a user's max_user_connections gets set to 30. Description This is by design. When a user's LVE CPU lim...
-
How to restrict the number of MySQL connections by users
Introduction Some server administrators want to restrict the number of user connections to MySQL. There needs to be a consideration of how busy a site may be and how many MySQL connections are need...
-
How to enable Dovecot RawLogs on a cPanel server temporarily
Introduction There may be times where emails are missing and there is difficulty determining how they are being removed. If they are being done via IMAP commands via a mail client then there will b...
-
How to convert a database table from InnoDB to MyISAM
Introduction When someone wants to convert a database table to MyISAM, the alter table SQL command can be used. This article provides the steps to convert a table. Please note that a qualified serv...
-
Why are some email addresses not forwarded when using Domain Forwarders?
Question Why are some email addresses not forwarded when using Domain Forwarders? Answer Domain Forwarders for one domain to another is used when the email address or when an autoresponder doesn'...
-
How-To move the mysql tmpdir out /tmp and into /home
QuestionHow do you move the mysql tmpdir out of /tmp and into /home? AnswerMariaDBLog in to the server via SSH as 'root'Create the file /etc/systemd/system/mariadb.service.d/override.conf with your...
-
Web Site cannot establish connection errors with "Server sent charset unknown"
Symptoms New server set up with MySQL 8 and sites transferred give cannot establish connection errors and the PHP error_log shows "PHP Warning: mysqli_connect(): (HY000/2054): Server sent charset u...
-
Custom Exim filter to deliver to multiple email addresses based on multiple filter variables
Introduction Sometimes a user has a need to have more robust filters than what can be set in cPanel itself. In this case, a user wants a variable match to deliver the email to one address and then ...