Archive for February, 2005

Plesk for Windows 7.5.0 & MySQL

Sunday, February 27th, 2005

There are two instances of MySQL running, one on port 3306 (default) and one on port 8306. The instance running on port 8306 is the intstance that is used by the Plesk contol panel.

Use the -P option of the mysql.exe client tool to specify the port:

mysql -u admin -p -P 8306

SpinRite 6.0

Sunday, February 20th, 2005

SpinRite now brings its legendary data recovery and drive maintenance magic to the latest file systems, operating systems, and hard drives. It runs MUCH faster than ever before, can help maintain all of your drives in tip top shape, can warn of impending disaster, and wrestle data from dying and nearly dead drives . . . before it’s too late.

This industry-standard data recovery tool is operating system independent, so it can be applied by users of Windows XP, 2000, Linux, and all other Intel/AMD PC‑platform hard drives and file systems.

SpinRite 6.0 home page ….

Anti-Virus Testing Tool

Sunday, February 20th, 2005

Test your email account’s anti-virus protection by sending a harmless “EICAR” virus attachment to your mail server. The EICAR test virus is completely safe and contains no viral code. For more information, please visit www.eicar.org.

Anti-Virus Testing Tool

Plesk 7.1.6′s psadump and MySQL version

Saturday, February 12th, 2005

The psadump utility that is shipped with Plesk 7.1.6, expect the version number of the MySQL server to always be in the format x.x.x, where x is a digit. We have however had cases where the MySQL version was x.x.xX, where x is a digit and X is a letter. Below is a hack on the regex to make psadump work properly again.

In the {PSA_BASE_DIRECTORY}/lib/perl5/BU/PSA/Const.pm file, change:

$mysql_version_str =~ m/[Vv][Ee][Rr]\s+[0-9\.]+\s+Distrib\s+([0-9\.]+)[\s,]/;

to:

$mysql_version_str =~ m/[Vv][Ee][Rr]\s+[0-9\.]+\s+Distrib\s+([0-9\.\w]+)[\s,]/;

UPDATE:
This problem has been resolved in Plesk for Linux version 7.1.7.

Plesk 7.1.6 & rpm errors

Saturday, February 12th, 2005

RedHat Enterprise Linux 3 (RHEL3), Update 4, in certain cases breaks your Plesk 7.1.6 installation. When you attempt to login you might get the following error message:

Unable to exec utility packagemng: packagemng: Unable to open rpm db: cannot
open Packages using index db3 (-30982)

System error 2: No such file or directory

Below is my WORKAROUND for the problem, until a permanent solution can be found.

I have edited my /etc/sysconfig/rhn/up2date file so that the pkgSkipList entry reads as follows: pkgSkipList=kernel*;rpm*;.

up2date will now, no longer upgrade the rpm system.

If you have already upgraded your rpm system, you could run the following commands:

up2date --get rpm-4.2.3-10 rpm-python-4.2.3-10 rpm-build-4.2.3-10 rpm-devel-4.2.3-10 rpm-libs-4.2.3-10
cd /var/spool/up2date/
rpm -Uvh --oldpackage rpm-4.2.3-10.i386.rpm rpm-build-4.2.3-10.i386.rpm rpm-devel-4.2.3-10.i386.rpm rpm-libs-4.2.3-10.i386.rpm rpm-python-4.2.3-10.i386.rpm
rm /var/lib/rpm/__db.00*

The above commands should get you up and running with the older rpm system.

RedHat did release the updated rpm system, due to a bug, as explained by in this Errata.

Run any program as a Service

Sunday, February 6th, 2005

You have installed a program on your Windows server and needs to have it starting everytime the server reboots. The obvious solution is to have the program installed as a service, but how do you do it if the program does not support it by default? Well Microsoft provides the solution.

How To Create a User-Defined Service [Open New Window]

Windows 2003 Tools

Sunday, February 6th, 2005

You may want to have a little bit more control over your Windows 2003 server. Microsoft does provide you with the tools, if you know where to find them. Below is links to tools that I have found useful.

Windows Server 2003 Resource Kit Tools [ Open New Window]
Windows Server 2003 Administration Tools Pack [ Open New Window]

Mail Enable 1.8 on Plesk 7.0.3 & the default email message

Saturday, February 5th, 2005

When creating a new email address (mailbox) on Plesk 7.0.3 for Windows, you will recieve a default email in the mailbox. This default email is stored in the following locations:

Filename: DEFAULT.MAI
System default: C:\Program Files\SWsoft\Plesk\Mail Enable\Config\Postoffices
Domain default: C:\Program Files\SWsoft\Plesk\Mail Enable\Config\Postoffices\<domainname>

To alter the email is very easy. All you need to do is to create the email message as you would like it to appear to your clients and then send it to one of the defined email addresses on the system. You will be able to retrieve the email from the location below.

Email file locaton: C:\Program Files\SWsoft\Plesk\Mail Enable\Postoffices\<domainname>\MAILROOT\<mailbox>\Inbox\*.MAI

Plesk backups and psadump

Wednesday, February 2nd, 2005

/usr/local/psa/bin/psadump -F -z --nostop --nostop-domain --tar-ignore-failed-read --do-not-dump-logs -f - | split -b 1000m - /backup/psa-`cat /usr/local/psa/version | cut -d ' ' -f 1`-backup-`date +%Y%m%d%H`.

Basically it does a full dump and doesn’t stop services, doesn’t switch a domain off, ignores misread files (files which are being modified whilst psadump is backing them up), doesn’t backup logfiles (waste of time/space/resources) and splits the backup into 1000MB chunks, labeling them with the Plesk version and that date and hour of the backup.

Plesk and CentOS

Wednesday, February 2nd, 2005

Plesk will run fine on RedHat Enterprise Linux 3 (RHEL 3). CentOS is a distibution based on the RHEL 3 source RPMS and is almost totally compatible with RHEL 3. Plesk does however not recognise the OS identification string, to fix it do the following:

cp /etc/redhat-release /etc/redhat-release_original
echo "Red Hat Enterprise Linux ES release 3 (Taroon Update 4)" > /etc/redhat-release

Plesk 7.1.6 and osCommerce (Application Vault)

Tuesday, February 1st, 2005

After installing osCommerce on a clients website, the osCommerce installation gave a number of errors. Searching the web and forums, let to the discovery that you have to have register_globals on and safe_mode off.

Add a vhost.conf file with the following entries:

<IfModule sapi_apache2.c>
php_admin_flag register_globals On
php_admin_flag safe_mode Off
</IfModule>

and then reconfigure the webserver:

/usr/local/psa/admin/bin/websrvmng --reconfigure-vhost --vhost-name=<domainname>

and restart the webserver:

/usr/local/psa/admin/bin/websrvmng --restart

Plesk 7.1.6 and Dr. Web Antivirus

Tuesday, February 1st, 2005

We purchased the Dr. Web Antivirus solution for 2 of our Plesk 7.1.6 installations. When we recieved the key files, we were instructed to upload the keys via the Pleskcontrol panel.

Every time we tried, Plesk informed us that the file did not contain a valid key file.

To resolve the problem, we finally installed the key file manually, by copying the key file to the /opt/drweb/drweb32.key and then restarting Dr. Web using service drwebd restart.

The above solved the problem on both, a RedHat 9 and RHEL 3 box.

Plesk 7.0.3 for Windows & PASV FTP

Tuesday, February 1st, 2005

After playing with the defautl install of Plesk 7.0.3 for Windows we reliased that it does not support PASV FTP if you enable the Firewall. After a few minutes of searching, the solution was found.

You need to tell IIS to only use a certain range of ports for PASV FTP connections. Microsof provides the following knowledge base article on how to achive this: How To Configure PassivePortRange In IIS

After you have limited IIS to only use a certain port range, you have to configure the default firewall management file Plesk\admin\bin\pfwmng.js to listen on the TCP ports for incomming connections. Yes, this does mean adding each port seperated by a comma in this file. For more information please visit the followin link: Plesk Firewall question