Running PostgreSQL Scripts ..................................................................................................... 254
Changing Postgres User Password ........................................................................................... 255
Localizing PostgreSQL .............................................................................................................. 256
Configuring Parallels H-Sphere to Use Non-Default MySQL/PostgreSQL Versions ................ 256
Choosing Remote Web Logical Servers for phpMyAdmin/phpPgAdmin Frontends ................. 258
Downgrading Postgres .............................................................................................................. 259
Windows Servers 261
MSI Packages ............................................................................................................................ 262
Download and Installation ............................................................................................... 263
Packages Requiring Third-party Software ...................................................................... 264
Dependencies Tree ......................................................................................................... 264
Winbox Directory Structure ........................................................................................................ 265
HSphere .......................................................................................................................... 265
HShome ........................................................................................................................... 266
HSlogfiles ........................................................................................................................ 267
Restarting Winbox Service ........................................................................................................ 267
Restarting IIS ............................................................................................................................. 268
Enabling Winbox Shared SSL ................................................................................................... 268
Integrating Winbox Shared SSL ...................................................................................... 269
Updating Winbox Shared SSL ......................................................................................... 269
Winbox Statistics ....................................................................................................................... 270
Statistics Modules ........................................................................................................... 271
Setting Up SharePoint to Use MSSQL Server .......................................................................... 273
Preinstallation Requirements .......................................................................................... 273
Installing and Configuring SharePoint ............................................................................. 274
Adding ODBC Resource ............................................................................................................ 277
Interface ........................................................................................................................... 278
Configuration ................................................................................................................... 281
Configuring ColdFusion ............................................................................................................. 283
Enabling ASP.NET 4.0 .............................................................................................................. 284
Moving Log Files ........................................................................................................................ 284
Removing Old Log Files ............................................................................................................ 285
Moving User Homes .................................................................................................................. 286
Maintaining HShome ................................................................................................................. 286
Changing hsadmin Login and Password ................................................................................... 288
Winbox IP Migration................................................................................................................... 289
Step 1. Bind Target IPs on Winbox ................................................................................. 289
Step 2. Add Double Bindings on IIS ................................................................................ 290
Step 3. Create Migration XML ......................................................................................... 291
Step 4. Run the Migration ................................................................................................ 292
Step 5. Remove Old IP Bindings on IIS .......................................................................... 292
Uninstalling Winbox ................................................................................................................... 293
Winbox Security Scheme .......................................................................................................... 295
Accounts Hierarchy ......................................................................................................... 296
IIS Security Management ................................................................................................ 297
NTFS permissions ........................................................................................................... 298
FrontPage Server Extensions Management Notes ......................................................... 298
ASP.NET Management Notes ......................................................................................... 299
Migration Notes ............................................................................................................... 299
Recovery Notes ............................................................................................................... 299
Migrating Serv-U to MS-FTP ..................................................................................................... 300
Step 1. Create a User Account and User FTP Accounts in IIS FTP ............................... 301
Step 2. Reset NTFS Permissions .................................................................................... 303
Step 3. Recover Winbox quota ........................................................................................ 304
Step 4. Reset Anonymous Access for All User Domains in IIS ...................................... 305
Preparing Servers for MS Exchange Hosting (Hosted Messaging and Collaboration 3.0) ....... 306
Step 1. Install Required Software on the Servers ........................................................... 307