Sysadmin Guide

Welcome to the H-Sphere Sysadmin Guide. It aims at system administrators and explains how to install, configure and maintain H-Sphere and its components.

Legend: (15 Jul) - document added; (15 Jul) - document revised.

H-Sphere Installation and Update

• Preparing Servers for H-Sphere Installation
• Update/Installation Options (HS 3.0+)
• Mirror Servers for HS Install/Update
• H-Sphere Installation Wizard (HS 3.0+)
• H-Sphere Installation
• H-Sphere Update
• Packages Installed With H-Sphere
• Packages Download Locations
• H-Sphere Updater (HS 2.5-3.0)
• H-Sphere Updater (HS 3.1+)
• Post-Installation Reference
• Config File Templates

System Packages

• Managing H-Sphere System Packages
• hsphere-info
• hsphere-update
• hsphere-perl
• H-Sphere SiteStudio Packages

H-Sphere Single Server Edition

• H-Sphere SSE Installation
• H-Sphere SSE Update
• Packages Installed With H-Sphere SSE
• H-Sphere SSE Installation Options

General Info

• Adding Servers and Services
• Used Software
• NAT Support
• Supported Perl Versions
• Upgrading Perl Modules
• FreeBSD Kernel Update
• Fixing Quota
• Server Time Synchronization
• Cron Scripts
• Traffic Calculation
• Script Runner Update
• Updating Linux
• Trustix SWUP
• Apt-Get
• RedHat up2date
• H-Sphere Security (courtesy of Dynamic Net™)
• H-Sphere Jail (HS 3.1+)

Restarting Services

• Restarting H-Sphere Services
• Restart H-Sphere
• Restart H-Sphere System Database
• Restart Web Server
• Restart Mail Server
• Restart PostgreSQL
• Restart MySQL

Control Panel Server

• CP Server Configuration
• Logging As cpanel User
• Logging Into H-Sphere System Database
• Tomcat Configuration
• CP Cron Jobs
• Java Command Line Tools
• CP SSL
• Upgrading Java
• Converting System Database
• Upgrading HS Database
• Converting HS Database To UNICODE
• CP Acceleration
• Changing CP URL
• SSH Key Generation
• PGP Encryption in Trouble Tickets

Web Server

• Web Server Configuration
• Apache Web Server (HS 2.5-3.0)
• Apache 1.3 and 2.2 Web Server (HS 3.1+)
• Altering Virtual Host Configuration
• FTP Server
• WebShell
• MnoGoSearch
• Third Party Log Analyzers
• Webbox Security Scheme
• Web Traffic Calculation
• PHP
• Standalone PHP Installation
• PHP Modules
• Adding PHP Extensions
• PHP Safe Mode Configuration
• PHP IMAP Compilation
• Ruby On Rails Installation (HS 3.1+)
• FrontPage Extensions
• Fixing FrontPage Extensions
• Chili!Soft ASP Installation
• mod_perl Installation
• Zend Optimizer Installation
• Adding Directories for User Homes

Mail Server

• Mail Server
• Mail Service
• Webmail
• Remote Web and MySQL Logical Servers for Horde Webmail (HS 3.0+)
• IMAP Server
• ImapProxy
• Installation/Upgrade From Sources
• Mail Server Roles
• Blocking IPs on Mail Servers
• Adding Qmail Settings To IP/Subnet (HS 3.0+)
• Bouncing Mail (HS 3.0+)
• Qmail Configuration
• Remote MySQL Logical Servers for SpamAssassin DB (HS 3.0+)
• SPF and SRS
• SpamAssassin Configuration
• Sa-update and RulesDuJour
• Moving Mail Service
• Moving Mail Domains
• Mail Traffic Calculation
• SpamGuard Setup

DNS Server

• DNS Server Configuration
• Restarting Named
• Bind 9.3
• Adding DNS Boxes
• Single DNS Configuration
• MyDNS Installation and Configuration
• DNS migration from BIND to MyDNS
• Moving DNS
• Removing Broken DNS zones
• DNS Creator

MySQL and PostgreSQL Servers

• MySQL Server
• PhpMyAdmin
• Enabling Linked Tables in phpMyAdmin
• Changing MySQL Root Password
• Moving MySQL
• Moving MySQL Accounts
• PostgreSQL Server
• PhpPgAdmin
• Changing Postgres User Password
• PostgreSQL Localization
• Using Non-Default MySQL/PostgreSQL Versions (HS 3.0+)
• Remote Web Logical Servers for phpMyAdmin/phpPgAdmin Frontends (HS 3.0+)

Windows Server

• Winbox Preinstallation
• H-Sphere Winbox Installation
• H-Sphere Winbox MSI Packages (HS 3.1 Beta 2+)
• Winbox Directory Structure
• Restarting H-Sphere Winbox
• Restart IIS
• Winbox Shared SSL (HS 3.0+)
• Winbox Shared SSL (before HS 3.0)
• Winbox Statistics
• WebShell 4 Installation
• PHP Installation on Winbox (HS 3.0+)
• FrontPage 5.0 Installation
• Setting Up SharePoint
• ODBC Resource
• ColdFusion Installation
• ASP.NET Support
• Moving Log Files
• Removing Old Log Files
• Moving User Homes
• HShome Maintenance
• Changing hsadmin Login and Password
• Uninstalling Winbox
• Winbox Security Scheme
• MS Exchange Hosting
• Traffic Calculation
• Creating Mail Plan on MPS Server

MS SQL Server

• MS SQL Server Installation
• MS SQL Server 2005 Installation
• Moving MS SQL Across Servers
• Moving MS SQL Databases To a New Location

Virtual Private Servers

• VPS Concept
• H-Sphere VPS Releases
• Preparing for H-Sphere VPS Installation
• H-Sphere VPS Installation
• H-Sphere VPS Update
• VPS Scripts
• Backing Up H-Sphere VPS
• VPS Network Gateways
• H-Sphere VPS Configuration Parameters
• VPS Templates (HS VPS 1.x)
• VPS Limits
• Building H-Sphere VPS
• FreeVPS Quota
• FreeVPS Kernel
• FreeVPS Tools
• Building FreeVPS Kernel
• Building FreeVPS Tools

Dedicated Servers

• MRTG Server

File Storage and Load Balancing

• Load Balancing in H-Sphere (HS 3.0+)
• Installation of Load Balanced Web Clusters in H-Sphere (HS 3.0+)
• Implementation of Load Balanced Cluster in H-Sphere (HS 3.0+)
• Third Party Storage Quota Managers
• NetApp Load Balanced Clusters (deprecated since HS 3.0)

Migration

• Migrating Users And Plans
• Creating Migration XMLs in H-Sphere
• DTD Structure of Reseller XML Migration File
• Creating Migration XMLs outside H-Sphere
• Migrating Users From CPanel
• Migrating Plans with XML
• DTD Structure of Reseller XML Migration File
• Migrating Control Panel
• IP Migration
• CP Server Migration
• Migrating Winbox
• Winbox IP Migration
• Migration of Serv-U to MS-FTP in H-Sphere

Backup And Recovery

• Backing Up H-Sphere
• Recovering Control Panel
• H-Sphere Backup And Recovery List
• Recovering Unix Hosted Servers
• Recreating Unix Hosted Servers
• Recovering Unix Hosted Services
• Restoring HS System DB From Backup
• Fixing Crashed HS Database
• Windows Backup
• Recovering Winbox
• Recovering Winbox Quota

Miva

• Miva Installation for Unix
• Miva Installation for Windows
• Miva Resource From The Inside

Urchin

• Urchin 4&5 Installation for Unix
• Urchin 4&5 Installation for Windows
• Urchin 4&5 Database Utilities

RealServer

• RealServer Installation for Unix
• RealServer Installation for Windows
• RealServer Config File Example