Updating the Socialengine License Key from a MySQL command

You will need to execute the following SQL query on your database:


 UPDATE `engine4_core_settings` SET value='________' WHERE `name`='core.license.key' LIMIT 1;

Be sure to replace "1234-1234-1234-1234" in the above query with your license key

Reference : support.socialengine.com 

421 Too many connections (8) from this IP

If user is receiving an error similar to this:

421 Too many connections  from this IP

The client needs to change his FTP settings to limit the number of simultaneous connections.

If using Filezilla:

File -> Site manager -> Transfer Settings -> check "Limit number of simultaneous connections" -> set it to "1"

For others, some research needs to be done.

If anyone knows the maximum number of connections allowed, please post it.

Check

Here are some settings from the /etc/pure-ftpd.conf:

# Maximum number of simultaneous users

MaxClientsNumber 50

# Maximum number of sim clients with the same IP address

MaxClientsPerIP 8

Databases show 0MB in MySQL Databases

Edit /var/cpanel/cpanel.config

Change:
disk_usage_include_sqldbs=0

To:
disk_usage_include_sqldbs=1

Then run:
$ /scripts/update_db_cache

Awstats doesn't properly update

On cPanel, if Awstats only shows a small percentage of the actual visitors, do the following -

chmod 644 /home/USERNAME/tmp/awstats/awstats.domain.com.conf

Account does not exist error when trying to delete email account

 To resolve this:

• Logout of cPanel
• SSH to the server he is on
• $ cd /home/<user>/.cpanel/
• $ mv -v email_accounts.yaml email_accounts.yaml.orig
• $ mv -v email_accounts.cache email_accounts.cache.orig
• Log back into the cPanel -> Email Account ; and the issue should have been resolved

 

500 Internal Server Error on Suspended Account

If an account is suspended, the domains are redirected to http://domain.com/cgi-sys/suspendedpage.cgi. If this URL generates Internal Server Error, then the fix is:

chgrp wheel /usr/local/cpanel/cgi-sys/suspendedpage.cgi
chattr +i /usr/local/cpanel/cgi-sys/suspendedpage.cgi

Its a temporary fix. Seems cPanel updates revert the ownership back to root.root and the error reappears. 

Can't login to PHPMyAdmin via cPanel

can't login to PHPMyAdmin via cPanel, here's the fix:

If the cPanel user password and MySQL password are not the same, you can try resetting the account password in

WHM using Main >> Account Functions >> Password Modification. 

This function will attempt to reset the cPanel user password for the system and MySQL. This should result in the system password and MySQL password again being in sync, allowing the user to log in using the phpMyAdmin log-in page.

If its a server-wide issue with PHPMyAdmin, run the following command to force a reinstall of PHPMyAdmin:

/usr/local/cpanel/bin/updatephpmyadmin --force

If that doesn't fix the issue, rebuild cPanel/WHM's internal PHP:

/scripts/makecpphp