Once you have logged into the server you via Remote Desktop you will need to take the following steps:

1. Go to ‘Start >> Run’ and type in ‘services.msc’.

2. Now you will need to look for ‘MySql Server’ In the Services window.

3. Right click on ‘MySql Server’ and go to ‘Properties’.

4. Once you have copied the location of the ‘my.ini’ file like the following example you will need to go to ‘Start >> Run’ and then enter in the location of the ‘my.ini’ file.

C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data\my.ini

5. Under the ‘[mysqld]‘ section in the ‘my.ini’ file you will need to add the following line:

skip-grant-tables

6. Restart ‘MySql Server’.

7. Then you will need to login to MySql:

cd C:\Program Files\SWsoft\Plesk\MySQL\bin

C:\Program Files\SWsoft\Plesk\MySQL\bin>mysql -u admin
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.18-nt

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> use mysql;
mysql> UPDATE mysql.user SET Password=PASSWORD(‘newpwd’) WHERE User=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit;

8. Then you will need to remove ‘skip-grant-tables’ from the my.ini file and restart ‘MySql’ after resaving the my.ini file.

Open REGEDIT

Go to…

For 64bit machines [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Mail Enable\Mail Enable\Connectors\SMTP]

For 32bit machines [HKEY_LOCAL_MACHINE\SOFTWARE\Mail Enable\Mail Enable\Connectors\SMTP]

Find “Listen Port” Change the value “DECIMAL”

And change it to new port, and Reboot the Plesk SMTP Connector Service…

NOTE : If firewall is enabled then make sure new SMTP port is opened.

If you see following error while backing up databases through phpmyadmin (this happens with large database)
————–
can’t find the file at https://xx.xx.xx.xx:8443/domains/databases/phpMyAdmin/export.php.
————–
Solution :

You can try to increase the value memory_limit in /usr/local/psa/admin/conf/php.ini to higher value and restart
Plesk CP after that.

# cat /usr/local/psa/admin/conf/php.ini | grep memory_limit
memory_limit = 128M

Set it to 512M for example and restart PSA service.

How to enable register_globals for a domain – Plesk Windows

Solution :

Start – Run – Regedit – go to “HKLM\SOFTWARE\PHP\Per Directory Values\”.

Then create keys (If you site folder is default “C:\Inetpub\vhosts\domain.com”:
“C” – “Inetpub” – “vhosts” – “domain.com” where domain.com should be replaced with the real domain name on which you need to set register_globals to “On” and change this value manually, then add string value “register_globals” and set string “on”.

Image is attached to message :

On some occasions apache will just abruptly fail, and become stopped, failing to restart with an error message like

————————————-
[Tue Aug 18 16:34:45 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/local/apache/bin/suexec)
[Tue Aug 18 16:34:45 2009] [crit] (28)No space left on device: mod_rewrite: could not create rewrite_log_lock
Configuration Failed
[Tue Aug 18 16:38:46 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/local/apache/bin/suexec)
[Tue Aug 18 16:38:46 2009] [crit] (28)No space left on device: mod_rewrite: could not create rewrite_log_lock
Configuration Failed
————————————-

Checking your disk shows that you have plenty of space. The problem is that apache didn’t shut down properly, and it’s left myriads of semaphore-arrays left, owned by my apache-user. Run:-

# ipcs -s | grep nobody

Removing these semaphores immediately should solve the problem and allow apache to start.

# ipcs -s | grep nobody | perl -e ‘while (<STDIN>) { @a=split(/\s+/); print `ipcrm sem $a[1]`}’

If awstats are not working after Plesk upgrade to v8.6 then download updated modules SiteAppStatistics.dll, statistics.exe and copy it to %plesk_bin%. Also make sure to backup old modules before copying.

Next update the stats by running the command -

“%plesk_bin%\statistics.exe” –all

If you see following error message in exim maillogs

==============
2009-08-05 15:30:06 1MYhUc-0007Bz-LU == USER@domain.com R=lookuphost defer (-1): host lookup did not complete
==============

Solution : This is likely because your resolving nameservers are no longer responding to DNS queries. To fix this issue, you can manually edit the /etc/resolv.conf file.

To configure exim to send mail using a different  IP other than the main shared IP.

vi /etc/exim.conf

Search for the following lines in /etc/exim.conf

remote_smtp:
driver = smtp

add the following line ,

interface = IPhere

and restart exim.

This would be helpful when your Main IP is blocked by RBL/CRL/AOL.

Unable to setup password protect directories if Frontpage Extenstion is enabled.

As long as Front Page extensions are not installed on the domain,you can go to Apache in your service menu (in Cpanel) and click on the pencil (edit) icon for a rich set of administrative tools to manage password files and groups.If you are using Front Page to create your website, you will needto password protect directories using the available options in theFront Page software.

How to enable Innodb as default storage engine ?

Solution :

Just edit your /etc/my.cnf file and look for this line:

skip-innodb

If such an entry exists, remove or comment out the entry

#skip-innodb

Next make the storage_engine variable to Innodb by adding following under [mysqld] section.

default-storage_engine = InnoDB
save the file, and restart mysql:

Restart mysql service