Monday, May 26, 2014

Email accounts are not showing after migration in cPanel

1. Login destination server, verify the permissions of mail related folders

2. Permission of /home/user/mail  751 and ownership is user.user

You can correct the permission using the command
sudo chown -R user.user /home/user/mail
sudo chmod 751 /home/user/mail/

3. Check the permission of /home/user/etc where it contains passwords of email accounts.
 Permission of /home/user/etc  750 and ownership is user.mail
You can correct the permission using the command
sudo chown -R user.mail /home/user/etc
sudo chmod 750 /home/user/etc

4. You can also correct the mail permission using sudo /scripts/mailperm --verbose username
If the email accounts are still not showing in Cpanel

Check the size of passwd file under /home/user/etc , If it is zero size file, try to copy the files from source server.
If the size of passwd file is zero in source server, then we need to create the mail account with a password manually. Then the password entry will appear under /home/user/etc .

Create mail account with Cpanel script
sudo /scripts/addpop emailaccount passowrd size
sudo /scripts/addpop  test@test.com qwedsa@123 1024

This time, Mail accounts will show in Cpanel for sure. :-)

Sunday, March 2, 2014

MySQL databases not showing in cPanel

When I checked Cpanel to check the database details after I created a database via shell, It was shown only a message "No databases found" .

The issue is the database is not mapped to Cpanel.

It was resolved by rebuilding the DB map using the command  

/usr/local/cpanel/bin/setupdbmap

 The Output of the command :

root@abc [~]# /usr/local/cpanel/bin/setupdbmap
info [setupdbmap] Begin setupdbmap
info [setupdbmap] Updating MySQL users
info [setupdbmap] Processing MySQL databases and database users ...
Adding database testabc_database ownership to testabc
Saving MySQL DB mapping for testabc
info [setupdbmap] Finished with MySQL users
info [setupdbmap] Failed to determine PostgreSQL version from server.
info [setupdbmap] End setupdbmap
info [setupdbmap] Storing Database Index
info [setupdbmap] Database Index Complete

Then the database testabc_database has showed in Cpanel > Mysql Datbases.

 Thus the issue resolved :) !!