Plesk for Windows does NOT auto update, the feature is entierly not implemented.
What you do it Download plesk for Windows from the Parallels website, and run the installer, I upgraded today from 9.0.1 to 9.2.1
Sounds like it went smoothly (Did not check yet), but the update from 8.6 to 9.0.1 went smooth that is for sure
As for this update, the setup file (About 600MB) can be extracted if you open it with 7ZIP
Setting up MySQL to connect to from PLESK for example is very simple
apt-get install mysql-server
Then, you will need to allow mysql to listen to the outside world
Edit /etc/mysql/my.cnf
and comment out the line
bind-address = 127.0.0.1
then, you will need to allow the root user to connect from outside the server
On the command prompt
mysql -uroot –password=”aPassWord”
use mysql;
select host, user from user;
Now look for the root user with the hostname of the machine, assuming it came out as thishost
update user set host=’%’ where user=’root’ and host=’thishost’;
flush privileges;
quit
And you should be all set
If you don’t perform the above operations, PLESK will complain when you add the server to the list of database servers, You will probably see an error like
Error: Test connection to the database server has failed because of network problems:
Failed to connect to database: Can’t connect to MySQL server on ‘host.domain.com’ (10061)
The three options for this on a PLESK server running plesk 9.01 and IIS6 is as follows
We will choseto always have everyone in the shared application pool, CPU limit will come after some investigation
So, I setup Windows in a VM with that old version of windows i had on the shelf for some time. (Thanks XEN HVM), Installed .NET 3.5 SP1 and the KB959209 , Setup MSSQL Express 2008
Things that got setup
SQL SERVER REPLICATION
FULL TEXT SEARCH
REPORTING SERVICES
BUSINESS INTELLIGENCE DEV STUDIO
Management Tools
SQL Client Connectivity
ms sync framework
From the SQL SERVER CONFIGURATION MANAGER, i enabled TCP/IP from protocols for SQL express
Opened a hole in the firewall for both MSSQL\Binn\sqlservr.exe and \90\Shared\sqlbrowser.exe
and then from within Plesk i added the server
Server Host: mywin.server.com.\MSSQLExpress
Admin User: sa
Admin Pass: Same pass i entered in Mixed authentication for the sa user !
Done, Plesk thinks this is a great thing i have done and accepts the thing instantly
MS advises that i read Understanding Surface Area – In setup help Minimize SQL Server 2008 surface Area
So, My PLESK 9.0.1 comes with .NET 2.0 Version 2.0.50727.0 is what PLESK reports, Installing .NET 3.5 SP1 and the KB959209 did not bump that from within PLESK.
So maybe with IIS i can assign 3.5 ?
Well, i am just setting up this server so i don’t know how plesk works in this regard yet, But i sure will very very soon.
As you may well know 3.5 is an upgrade to 2.0, it is not really different at the core, it is just a larger 2.0
I will let you know as soon as i do about how this thing works, for now i have to go finish setting up this thing to use MS SQL Express edition 2008.
UPDATE: Now plesk allows you to disable the horde side menu ads from within the CP, more details here
When on Plesk, Horde becomes PSA-HORDE that has one real major difference that the original HORDE does not, it has advertising to it’s left
If there is one thing that differentiates Paid mail hosting from Free hosting (Since google allows you to host your mail domain), it is the No-Advertising feature, and plesk took that away.
Anyway, i am not taking any of this advertising thing, i know horde and i know they can not possibly hide it from me, After all the PHP code of horde is there.
The file that needs edeting is
/usr/share/psa-horde/templates/portal/sidebar.inc
Find the line that reads
if (window.NewsFeeds) {
and make it
if (false) {
Even when you do this, when Plesk updates Horde again, it will probably overwrite this, But modifeying this at every update is the easiest sollution i can think of besides dissabeling Plesk updates (Which is very dangerous)