Cloud Guru Online

We simplify everything!

Change mail IP

If your primary IP of the server is blacklisted or having poor reputation, the emails send from you can end up in recipients spam folder. Un til you get the IP issue sorted, you can change the Exim’s mail sending IP to another fresh IP preset in the server.

1.Edit /etc/mailips.

If you wish to change the IP for all domains in the server, add
*: new_IP
If you wish to change the IP for only one domain, add : new_IP

2. Enable “Reference /etc/mailips for outgoing SMTP connections” in WHM >> Exim Configuration

3. Enable “Allow users to relay mail if they use an IP address through which someone has validated an IMAP or POP3 login within the last hour (Pop-before-SMTP)” in WHM >> Tweak Settings

4. Modify the domain’s SPF record to include the new IP.

5. Restart Exim

MySQL temp directory full

In such situations, you will have to change the MySQL’s tmpdir.

  1. Create the new temp directory

mkdir /var/lib/mysql/tmp
chmod 1777 /var/lib/mysql/tmp

  1. Make the new folder as the tmpdir by adding the below to server’s /etc/my.cnf

tmpdir = /var/lib/mysql/tmp

  1. Restart mysql

service mysqld restart

MySQL – Convert all tables from MyISAM to InnoDB

1. Convert the engine using the below command and dump the database.

mysql -e "SELECT concat('ALTER TABLE ', TABLE_NAME,' ENGINE=InnoDB;') FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'successc_wordpress' AND ENGINE = 'MyISAM' AND TABLE_TYPE = 'BASE TABLE'" | tail -n+2 >> alter.sql

2. Restore the dump created above to the original database.

mysql original_database < alter.sql

cPanel new feature “Manage Team”

cPanel now provides “Manage Team” feature in version 112.This allows the creation of team user accounts, allowing several people to access, manage, and work on a single cPanel account without putting their credentials at risk.

cPanel account owner can use “Manage Team” to enable developers and administrators to manage their company’s websites. Each team member will have own logins to access cPanel resources. This allows for the separation of works and offers an audit trail for all accounts.

More details in cPanel official docs: