Server and Hosting

June 12, 2021 by dev

HTTP 500 error

Enable FileInfo in PHP to resolve HTTP Error.
The memory limit is the maximum amount of memory this process can use. If you exceed it, the process fails and Apache reports an HTTP 500 error.

June 11, 2021 by dev

How To Find Duplicate Values in MySQL

Find duplicate values in one column

SELECT 
    col, 
    COUNT(col)
FROM
    table_name
GROUP BY col
HAVING COUNT(col) > 1;

Find duplicate values in multiple columns

SELECT 
    col1, COUNT(col1),
    col2, COUNT(col2),
    ...

FROM
    table_name
GROUP BY 
    col1, 
    col2, ...
HAVING 
       (COUNT(col1) > 1) AND 
       (COUNT(col2) > 1) AND 
       ...

June 11, 2021 by dev

DB Errors

Uncaught Exception: DB Error: Access denied for user ” (using password: YES)
= Check credentials

June 11, 2021 by dev

How do I enable FileInfo in PHP

Enable FileInfo in PHP to resolve HTTP Error.

How to Install a PHP Extension Using EasyApache 4

Log into WHM as root
Type ‘easy‘ into the search field of WHM
Click on EasyApache 4
Click on the Customize button in the Currently Installed Packages section
Then click on the PHP Extensions option from the left
In the Search field, type ‘fileinfo‘ to get the extension
Now toggle to enable or install the extension
Click on the Review option from the left
Then, click the Provision button
Finally Done to complete the task

May 28, 2021 by dev

CWP Security Instructions

Website Protection

Most of the hackers will be denied by ModSecurity and FileSystemLock.

Set for all .php files permissions to 640.

– Disable dangerus PHP functions
http://wiki.centos-webpanel.com/how-to-disable-dangerous-php-functions
* If you are hosting multiple sites for your clients then some sites might need some of this disabled functions.

– PHP Open_Basedir protection
http://wiki.centos-webpanel.com/php-open_basedir
* We recommend to use option per user.

– ModSecurity for CWP: It will block many malware infections.
http://wiki.centos-webpanel.com/mod_security-for-cwp

– File System Lock: It will deny any kind of change on the files system and also disable any file uploads, and that means no more malware infections and website hacks.

– Hide system processes: This will hide all system process from the users. http://wiki.centos-webpanel.com/hide-system-processes-from-users

-Notification Alerts – SECURITY ISSUE
Notification Email Alerts are NOT set on your server. Go to hostname/…./admin/index.php?module=notifications