Error:


ERROR in Creation : The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.


Solution:

I am using Windows Server 64 bit, MS Office 2010 64 bit.

Download and install 2007 Office System Driver: Data Connectivity Components using the following url.

This download will install a set of components that can be used to facilitate transfer of data between 2010 and 2007 Microsoft Office System files and non-Microsoft Office applications.

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

The above install will fix the error mentioned in this post.
It will work for both Microsoft Office 2010 and 2007.

Error:


When i run the following command in terminal i got an errors as shown below. I got this error in a cpanel 11.32.5 (build 18) server.

# exim -bt test@yourdomain.com


LOG: MAIN PANIC
  failed to expand condition "${perl{check_mail_permissions}}" for check_mail_permissions router: Undefined subroutine &main::check_mail_permissions called.

LOG: MAIN PANIC
  failed to expand condition "${perl{enforce_mail_permissions}}" for enforce_mail_permissions router: Undefined subroutine &main::enforce_mail_permissions called.

LOG: MAIN PANIC
  failed to expand condition "${perl{increment_max_emails_per_hour_if_needed}}" for increment_max_emails_per_hour_if_needed router: Undefined subroutine &main::increment_max_emails_per_hour_if_needed called.




Solution:

The following script helped me to fix the error.

# /scripts/buildeximconf

Issue:

When accessing plesk control panel using non-ssl port(8880) it is redirecting to SSL port(8443).

http://www.yourdomain.com:8880 is redirecting to https://www.yourdomain.com:8443


Solution:

Disabling SSO in Plesk (Single Sign On) will fix this issue.


The Plesk Single Sign-On service is nice for users who use several of Parallels services such as Plesk and Site Builder.

Some users may decide to disable this service due to issues it can cause if not properly configured. One of these issues is incorrect SSL certificate support for the control panel admin interface. If you are still incurring the above mentioned problem, try disabling this service with:

In Windows:

If you are using plesk in windows, login to windows server via remote desktop.
Enter the following commands in the 'cmd'

C:\>%plesk_dir%/bin/
C:\Program Files (x86)\Parallels\Plesk\bin>sso.exe --disable


In Linux:

# /usr/local/psa/bin/sso --disable


Note:

Here in this solution, both http in 8880 and https in 8443 will work. If you want to permanantly disable https in 8443, you can follow the steps shown below.


If you have Windows 2008,

Open IIS.
Expand the Sites menu.
Right click the PleskControlPanel from the site list.
Select Edit Bindings.
Remove the binding for 8443.
Click close.
Restart Plesk for the changes to take effect.

***Most of all sso must be disabled.

There is no direct option to add an additional shared IP in WHM. But you can add more shared IPs if you have SSH root access to the server.

You can add more shared IPs by following the steps shown below.

# cd /var/cpanel/mainips/

If there is no such directory, you have to create it.
   # mkdir -p /var/cpanel/mainips/

# vi /var/cpanel/mainips/root

Add the IPs in this file one by one separated by new line, each line is an additional shared IP in WHM.

If you want to add 11.22.33.44 and 44.33.22.11 as shared IPs, You will get a result as follows.

# cat /var/cpanel/mainips/root
  11.22.33.44
  44.33.22.11

Now if you login to WHM and

Home » IP Functions » Show/Edit Reserved IPs

You can see the status of new IPs as 'Main/shared IP for root'.

Error:

When accessing horde via webmail in cpanel it is howing the follwing error.

A fatal error has occurred
DB Error: no such database
Details have been logged for the administrator.


Solution:

In order to fix the issue forcely update horde using the following script.

# /usr/local/cpanel/bin/update-horde --force

The above script will repair and reinstall horde mail.

Error:

When trying to access PHPMyAdmin the following error appeared on browser.

Fatal error: require_once() [function.require]: Failed opening required './libraries/logging.lib.php' (include_path='/usr/local/cpanel/3rdparty/lib/php/:.') in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/dbi/mysql.dbi.lib.php on line 12

Solution:

It is best to forcely update PHPMyAdmin using the following script. It will fix the issue in accessing PHPMyAdmin.


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

Error:

After adding a new rule in iptables, it is needed to save those rule and restart iptables.
When saving iptables rule,

# root@server [~]# service iptables save

iptables: Saving firewall rules to /etc/sysconfig/iptables: /etc/init.d/iptables: line 268: restorecon: command not found
                                                           [FAILED]

The rules will not be saved and we will keep getting the above error when saving iptables.

Solution:

The reason in getting such an error message is because of the  missisng of restorecon file.

See the result of the follwing command, 'restorecon' is missiing in there.

root@server [~]# ls -l /sbin/ | grep restore
lrwxrwxrwx  1 root root         14 Jan  9 22:23 iptables-restore -> iptables-multi*

restorecon is provided by policycoreutils package. Try re-installing policycoreutils package and see the result of the above command.

# yum update policycoreutils


After the update, run the following command to check whether 'restorecon' available or not.

root@server [~]# ls -l /sbin/ | grep restore
lrwxrwxrwx  1 root root         14 Jan  9 22:23 iptables-restore -> iptables-multi*
lrwxrwxrwx  1 root root          8 Jan 15 19:50 restorecon -> setfiles*

If you get an output as like above, it will fix the above iptables save issue.

Error:


After you change PHP 5 Handler to fcgi mode in cPanel,

Home » Service Configuration » Configure PHP and suEXEC
You can find the following error in the apache error log.


# tail -f /usr/local/apache/logs/error_logs

[warn] (13)Permission denied: mod_fcgid: spawn process /usr/local/cpanel/cgi-sys/php5 error
[error] (13)Permission denied: mod_fcgid: couldn't bind unix domain socket /usr/local/apache/logs/fcgidsock/30113.5

The result of following command will be null in this case.
root@server [~]# netstat -plan | grep fcgi

Solution:

The issue is caused by the permission of /usr/local/apache/logs/fcgidsock directory. Change permission of 'fcgidsock' directory to 777 to solve the issue.

root@server [~]# cd /usr/local/apache/logs/
root@server [~]# chmod 777 fcgidsock


Check the error logs again to verify whether the issue is fixed.


If fcgi is running fine, you will get a result like following for the 'netstat' command.


root@server [~]# netstat -plan | grep fcgi
unix  2   [ ACC ]   STREAM  LISTENING  63760566 32326/php       /usr/local/apache/logs/fcgidsock/30217.17047
unix  2   [ ACC ]   STREAM  LISTENING  63760626 32327/php       /usr/local/apache/logs/fcgidsock/30217.17048
unix  2   [ ACC ]   STREAM  LISTENING  63760689 32328/php       /usr/local/apache/logs/fcgidsock/30217.17049
unix  2   [ ACC ]   STREAM  LISTENING  63760821 32338/php       /usr/local/apache/logs/fcgidsock/30217.17050
unix  2   [ ACC ]   STREAM  LISTENING  63756908 32023/php       /usr/local/apache/logs/fcgidsock/30217.17037
unix  2   [ ACC ]   STREAM  LISTENING  63761043 32350/php       /usr/local/apache/logs/fcgidsock/30217.17051
unix  2   [ ACC ]   STREAM  LISTENING  63761798 32399/php       /usr/local/apache/logs/fcgidsock/30217.17052
unix  2   [ ACC ]   STREAM  LISTENING  63761988 32415/php       /usr/local/apache/logs/fcgidsock/30217.17053