If you receive error while compiling easyapache shown at following image then run following cPanel scripts and then run easyapache

1)/scripts/checkperlmodules
2)/scripts/upcp –force

If horde webmail is not working on windows + plesk server and receiving following errors when login to horde….

Warning: main() [function.include]: Failed opening ‘PEAR.php’ for inclusion (include_path=’C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear’) in C:\Inetpub\vhosts\webmail\horde\lib\core.php on line 46

Warning: main(): Failed opening ‘PEAR.php’ for inclusion (include_path=’C:\Inetpub\vhosts\webmail\horde\lib;.;./includes;./pear’) in C:\Inetpub\vhosts\webmail\horde\lib\core.php on line 26

And so on………

This happens mainly because PHP and Zend installers force PHP to use a default configuration file for all applications, but horde uses a special configuration file which is placed to its folder.

Solution:
Please edit registry by command regedit and clean up the default configuration location by removing the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\php\IniFilePath

If you are receiving following errors while running easyapache or any other script then go through following solutions to fix this issue.

=====================================================
Can’t locate loadable object for module Template::Stash::XS in @INC (@INC contains: /usr/local/cpanel /scripts /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 31

BEGIN failed–compilation aborted at /usr/lib/perl5/site_perl/5.8.8/Template/Stash/XS.pm line 31.
Compilation failed in require at /scripts/cPScript/Template.pm line 14.
BEGIN failed–compilation aborted at /scripts/cPScript/Template.pm line 14.
Compilation failed in require at /scripts/cPScript/AdvConfig.pm line 9.
BEGIN failed–compilation aborted at /scripts/cPScript/AdvConfig.pm line 9.
Compilation failed in require at /scripts/cPScript/AdvConfig/apache.pm line 19.
BEGIN failed–compilation aborted at /scripts/cPScript/AdvConfig/apache.pm line 19.
Compilation failed in require at /scripts/cPScript/EditHttpdconf.pm line 37.
BEGIN failed–compilation aborted at /scripts/cPScript/EditHttpdconf.pm line 37.
Compilation failed in require at /scripts/fixmailmanwithsuexec line 14.
BEGIN failed–compilation aborted at /scripts/fixmailmanwithsuexec line 14.
======================================================

Solution: Read more »

mssql_connect() is a function which establishes a connection to a MS SQL server using PHP. To use MSSQL database in PHP page make sure that MSSQL dll is enabled in PHP. To check open php.ini file and search for following

extension=php_mssql.dll

Sometime it happens that when you try to connect MSSQL database using PHP it throws following Error (espiceally when you have installed PHP 5)

Warning:  mssql_connect() [function.mssql-connect]: Unable to connect to server:  SERVER\SQLEXPRESS in C:\Inetpub\wwwroot\dbconnection.php on line 6

The problem come due to higher version ntwdblib.dll available with PHP 5. The simple fix for this problem is to replace the ntwdblib.dll with old version. You can download the Old version of dll file from http://trulymanaged.com/downloads/ntwdblib.dll OR if you have Plesk Control Panel you can directly copy/replace C:\WINDOWS\system32\ntwdblib.dll with C:\Parallels\Plesk\additional\PleskPHP5\ntwdblib.dll

While accessing plesk control panel, somtime we get following Error

ERROR: PleskMainDBException
MySQL query failed: Table 'psa.APSApplicationItems' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:218
        db_query(string 'SHOW CREATE TABLE `APSApplicationItems`')
1: /usr/local/psa/admin/plib/SQLParser.php:27
        SQLParser->handleDatabase()
2: /usr/local/psa/admin/plib/MySQL5FixBinaryColumns.php:36
        MySQL5FixBinaryColumns::run()
3: /usr/local/psa/admin/auto_prepend/auth.php3:90

SOLUTION:

The Main reason of this problem is corrupted Plesk Database. We can check that using following command

[root@server ~]#  mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow ` psa
psa.APSApplicationItems
error    : Table 'psa.APSApplicationItems' doesn't exist
psa.APSClientApplicationItems
error    : Table 'psa.APSClientApplicationItems' doesn't exist
psa.APSLicenseTypes
error    : Table 'psa.APSLicenseTypes' doesn't exist
psa.APSLicenses
error    : Table 'psa.APSLicenses' doesn't exist

To resolve the issue, please do the following:

- remove corrupted tables from plesk database
- restore them from plesk database distributive

you can do above using following Steps

1.  Backup undamaged Tables

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -NB -e'show tables' > ../tables
for i in `cat ../tables`
 do
  mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa $i > $i.sql
 done

2. Remove Plesk database from /var/lib/mysql/ manually.

3. Restore the latest valid daily dump which can be found in /var/lib/psa/dumps/ directory.

4. Finally Restore the backup which we have taken on step 1.

for i in `cat ../tables`
 do echo $i
  mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < $i.sql
 done

NOTE: Fix for this problem is completely depends upon the error you are getting. So, be careful before trying this fix.

It is ALWAYS recommended to create additional two (2) users, apart from Administrator. These two users are - another member of “Administrators” group (to avoid actually logging on with the Administrator account, but you have the same privileges) & a regular user, who is part of “Users” group. It is recommended to only log on with regular user, and use the “runas” command when you need to run any particular program as an Administrator; log on with the secondary Administrator user when it is absolutely needed. This will show you how to create a secondary Administrator.

==========

Click the Start button, then Run…

Then type lusrmgr.msc

In window that opens, right click in the right panel and click “New User”

In the New User dialog, type in desired user name and password (secondary Administrator account).  Uncheck User must change password, & check Password never expires. Now, go to the Properties of new User; Go to the “Member of” tab and press the Add button.

Then Type Administrators, and press the Check Names button (to complete the name) and press OK when it is done, then press OK on the Local Users and Groups dialog

Now you have a secondary Administrator account; The above steps will be same to add a regular user (highly recommended) until the User properties.

Certificate Signing Request (CSR) contains all the information regarding certificate application. It also includes the Public key.

Following steps will show how to generate a pair of private key and public Certificate Signing Request (CSR) for a webserver, “server” using Apache mod_ssl/OpenSSL.

root@vps [~]# openssl req -new -nodes -keyout vps.key -out vps.csr

This creates a two files. The file vps.key contains a private key;

Following is the output from the above command, you will have to fill some of the fields here:

root@vps [~]# openssl req -new -nodes -keyout vps.key -out vps.csr

Generating a 1024 bit RSA private key
……………++++++
……++++++
writing new private key to ‘vps.key’
—–
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter ‘.’, the field will be left blank.
—–
Country Name (2 letter code) [GB]:GB
State or Province Name (full name) [Berkshire]:Berkshire
Locality Name (eg, city) [Newbury]:Newbury
Organization Name (eg, company) [My Company Ltd]:Trulymanaged
Organizational Unit Name (eg, section) []:Webhosting
Common Name (eg, your name or your server’s hostname) []:vps.server.com
Email Address []:vps@server.com

Please enter the following ‘extra’ attributes
to be sent with your certificate request
A challenge password []:sdfhsdfj
An optional company name []:

Your CSR will now have been created. Open the vps.csr in a text editor and copy and paste the contents into the online enrollment form when requested.

Difference Between MSSQL Server 2005 Express, Standard and Work group Edition

MS SQL 2005 Express Edition features are as follows :

* CPU : No
* 1 GB max memory limit for buffer pool : Yes
* 4GB max database size : Yes
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : No
* Basic Integration Services : No
* Advanced Integration Services : Yes

MSSQL 2005 Standard Edition features are as follows :

* CPU : Yes
* 1 GB max memory limit for buffer pool : No
* 4GB max database size : No
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : Yes
* Basic Integration Services : Yes
* Advanced Integration Services : Yes

MSSQL 2005 Workgroup Edition features are as follows :

* CPU : Yes
* 1 GB max memory limit for buffer pool : No
* 4GB max database size : No
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : Yes
* Basic Integration Services : No
* Advanced Integration Services : No

How to fix Input/Output error on a VPS?

Recently we came up with the following error on one of our server and could not fix the same.

The server is a Virtuozzo Server with Plesk but this fix works for cPanel and other Control Panels as well.

And the error is as follows;

mv: cannot stat ‘<filename>: Input/Output error
**Note with the filename indicating the corrupt files or broken files

1) Now fora temporary fix Input/Output error try the following:

• find /vz/private/vps_ID/ | grep “file_name”

**Note with the filename indicating the corrupt files or broken files

• Then “ls” on directory where file is stored.

• Remove the broken file and try to restart the VPS.

Explanation for the error with an e.g.

Now the Problem occurs when there are a few broken files inside private area of of the VPS here for e.g we use vps_ID as 1000000

[root@xx ~]# ls /vz/private/1000000/root/var/www/vhosts/domainname.com/httpdocs/images/
ls: /vz/private/1000000/root/var/www/vhosts/domainname.com/httpdocs/images/ln_9.gif: Input/output error
ls: /vz/private/1000000/root/var/www/vhosts/domainname.com/httpdocs/images/logo.jpg: Input/output error
ls: /vz/private/1000000/root/var/www/vhosts/domainname.com/httpdocs/images/ln_7.gif: Input/output error

Here the system cannot stat the files and cannot move them away and these are the files which suggest that the file system on server can be corrupted.

2) Now for a permanent fix for the Input/Output error perform “fsck” for /vz partition.

What is udev?

udev - /dev/ and hotplug management daemon

udev is a daemon which dynamically creates and removes device nodes from /dev/, handles hotplug events and loads drivers at boot time. It replaces the hotplug package and requires a kernel not older than 2.6.12.

Install udev in Debian

NOTE :: After installing this you need to reboot your machine.

When you install the Udev package in VPS based on Debian-4.0 template, you can may the following message:

Setting up udev (0.105-4) …
/var/lib/dpkg/info/udev.postinst: line 125: echo: write error: Operation not permitted

The problem is postinstall script tries to write to /proc/sys/kernel/hotplug file, and this operation is prohibited in a VPS.

To work around this problem ::