Atmail webmail system offers a webmail client, email server platform and mailserver appliance for Linux, Unix and Windows. Plesk 9.x supports Atmail and while sending emails using Atmail every email shows following message in the footer of the email sent.

Msg sent via @Mail - http://atmail.com/

This message is quite irritating and look un-proffestional. This message can be removed by editing AtMail Configuration file which can be located at following location

Plesk Windows: C:\Inetpub\vhosts\webmail\atmail\libs\Atmail\config.php for Win
Plesk Linux: /var/www/atmail/libs/Atmail/Config.php
Normal Location: [Atmail installtion location]/libs/Atmail/Config.php

Search for ‘footer_msg’ option and change the message you want to set OR keep it blank

FROM:
'footer_msg' => 'Msg sent via @Mail - http://atmail.com/',

TO:
'footer_msg' => 'YOUR COMPANY NAME OR ANY TEXT',
OR
'footer_msg' => '',

Restart the webserver.

Sometime while connecting to MSSQL Server Configuration Manager it throws following Error

Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable. Note that you can only manage SQL Server 2005 servers with the SQL Server Configuration Manager.
Invalid namespace[0x8004100e]

I have searched on Google and found that it happens when 32bit MSSSQL application is installed on 64bit Server and they suggested to execute the following command to fix the issue.

mofcomp "%programfiles%\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

MOF files are appropriate for static management data or dynamic management data. Static data includes details such as the computer user’s phone number, office number, and name. Dynamic data includes details such as Microsoft SQL Server(tm) database sizes and applications installed with Windows Installer.

While deleting one domain from Plesk it was throwing following error

When we checked the domain on server (from shell) we have found that all physical Address (/var/www/vhost/domain.com) of the domain has been deleted but still Plesk shows the domain.

Following are the steps to remove the domain from Plesk manually.

1) Connect the server using SSH

2) Login into MySQL Prompt as Plesk admin

3) Delete the DNS Zone of the domain

You can verify if any records still persists using following commands

4) Now delete the Domain from Domains table which will remove it from Plesk Domains List

Verify it using select Command.

NOTE: PLEASE Make Sure To Verify The DOMAIN NAME before you make any changes as it might delete some other domain. Also the changes made are irreversible.

Sometime while deleting domain from Plesk it throws following Error:

DNSZone::Table::select() failed: no such row in the table

This error occurs when there were invalid columns in DNS table of Plesk Database.

You can check if there is a invalid column in database using following command

"%plesk_bin%"\dbclient.exe --direct-sql --sql="SELECT domains.name FROM domains LEFT JOIN dns_zone ON domains.dns_zone_id = dns_zone.id WHERE dns_zone.id IS NULL"

The server on which I have face has following invalid columns

dns_zone.serial default value: actual = "0" expected = no value
dns_zone.serial NULL attribute: actual = false

Solution:

1) We have removed the vhost setting by following command :

C:\Parallels\Plesk\admin\bin>websrvmng.exe --remove-vhost --vhost-name=[domainname.com]

2) Then reconfigured it :

C:\Parallels\Plesk\admin\bin>websrvmng.exe --reconfigure-vhost --vhost-name=[domainaname.com]

3) Then updated the DNS Zones :

C:\Parallels\Plesk\admin\bin>DNSMng.exe UPDATE [domainname.com]

Now try to delete the domain from Plesk.

Microsoft SQL Server is a relational model database server produced by Microsoft and it’s Installation is quite Easy using GUI where a user has to selects the options which he/she needs with the database server and install it. We can automate the installation procedure and make it so simple that MSSQL can be installed using a single command.

Automating SQL server installation is made easier in MSSQL 2005 version and we can define the components which need to be installed with setup.exe via command prompt OR we can create an ini file which will contain all the information about the installation. In this post I will explain the steps to install MSSQL 2005 using command prompt with the help of single command.

Install MSSQL using Command Prompt (By Defining all modules in command)

1) Insert the MSSQL installation media into the disk drive.

2) Open Command Prompt (Start >> Run >> cmd >> Enter)

3) Execute following command

Here, ADDLOCAL is set to “All” which will install all the components and modules bundled with the MSSQL. If you want customized modules then you can declare the modules instead of “All“.

Install MSSQL using .ini file

1) Open Notepad (Start >> Run >> Notepad >> Enter)

2) Insert all the “Installation Parameters” in that file. Following is the sample file which I have used to install MSSQL on my System

Here, PIDKEY will be the Product Key of the product shipped with MSSQL.

3) Save this file with extension .ini (like sqlsetup.ini)

4) Execute following command to run the setup

Points to Note:

1) While specifying the accounts like SQLACCOUNT, AGTACCOUNT and SQLBROWSERACCOUNT make sure you define proper users. Users can be

2) Microsoft provides a template.ini file in the installation media but I would strongly recommend to remove the options that you don’t want.

You can refer to Microsoft tutorial for more information and component help at http://msdn.microsoft.com/en-us/library/ms144259.aspx

Sometime Plesk show following ERROR after login

Fatal error: Call to undefined function isKeyProp() in C:\Parallels\Plesk\admin\auto_prepend\auth.php3 on line 40

This problems normally comes due to conflicts/difference between Plesk DLL’s and System DLLS. This problem can be solved by replacing libeay32.dll and ssleay32.dll of the server with the DLL’s provided by Plesk.

Following are the steps to replace the file

1) Search for libeay32.dll and ssleay32.dll in %plesk_bin% folder (C:\Parallels\Plesk\admin\bin).

2) Stop Plesk Service.

3) copy and paste them to %windir%\system32 folder (C:\WINDOWS\System32).

4) Start Plesk Service.

Sometime Schedule tasks on Microsoft doesn’t run and which checking them from Schedule tasks it give a pop up with following Error

ERROR: General page initialization failed. The specific error is: 0x8007000d: The data is invalid. An error has occurred attempting to retrieve task account information. You may continue editing the task object, but will be unable to change task account information.

Following are the steps to fix this problem/Error

1. Delete the offending “SYSTEM” account tasks in Task Scheduler.

2. Stop the Task Scheduler Service.

3. Delete all files in C:/Documents and Settings/All Users/Application Data/Microsoft/Crypto/RSA/S-1-5-18

4. Restart the service (I’d restart the system).

While Accessing Horde Webmail interface in Plesk it gives following error

To fix this error first go to C:/Parallels/Plesk/Additional/Php OR any Directory where Plesk PHP4 is installed and execute Following commands

After that copy the contents of “PEAR/DB” folder to “horde/pear/Db” (where horde is installed). Restart Plesk and try to access Webmail now.

Sometime while creating Additional FTP account or Updating Domain user it shows following Error

Error: Unable to update FTP account: Unable to create web user: Update FTP user failed:
ftpmng --add-user failed: Empty error message from utility.

This problem comes when .Security file of the domain get corrupted. This file can be found at C:\Inetpub\vhosts\domainname.com OR D:\Inetpub\vhosts\domainname.com OR in the domain home directory. Rename the file to OLD.Security and run following command:

C:\Parallels\Plesk\admin\bin>websrvmng.exe --reconfigure-vhost --vhost-name=domainname.com
						OR
C:\> "%plesk_bin%\ftpmng.exe" --reconfigure-vhost --vhost-name=domainname.com

Above command will create a new .Security file based on the Plesk Database and then try to create new FTP user or try to update domain user.