CP Traffic Calculation


Traffic generated from browsing the Control Panel is not included in the summary traffic. To track it, H-Sphere owners can set up custom packages.

H-Sphere System Database


The H-Sphere system database is used to store system data. In normal H-Sphere configuration, it runs on PostgreSQL server, but it may be installed on a separate Windows-based MSSQL server.

Usually, the system database is located on the same server with the Control Panel.

The system database is not used for hosting. PostgreSQL hosting server could not be installed on the same box with the system database.

The H-Sphere database is executed under the pgsql or postgres user.

System Database Settings


Database settings in hsphere.properties:

DB_DRIVER = org.postgresql.Driver
DB_URL = jdbcostgresql://127.0.0.1/hsphere – the system database name, usually hsphere
DB_USER = wwwuser – the system db user name, usually wwwuser
DB_PASSWORD = your_db_password – the system db user password
DB_NEWID = SELECT nextval(”{0}”)

Logging Into The System Database


To log into the system database:

First of you need to get Login as the cpanel user to the server where the system database is located (usually, CP server).
Then enter the hsphere database (usually, under the wwwuser user name):
# psql hsphere [user_name]

VACUUM Utility


The Postgres VACUUM instruction allows cleaning up the server transactions. vacuum is a time-consuming procedure; it may take up to several hours to complete!

Enter the psql server:

psql hsphere wwwuser and type in the password set in hsphere.properties.

In the psql command line, type the ‘vacuum full’ command:
vacuum full;

CP Mail Queue


The mail queue file is assigned to store unsent CP messages (e.g., trouble tickets, system notifications, mass mail, etc.) when CP is restarted – formerly, they were lost after CP restart. Mail queue location is set in hsphere.properties:

MAIL_SWP=/hsphere/local/home/cpanel/shiva/mail.swp

Changing Hosting Plan


hi,
At present i have a Starter Reseller web hosting plan from cpwebhosting.net but now i want to change plan from Starter Reseller to Professional Reseller plan. how can i do it

For changing your web hosting plan

1. Go to your control panel home.
2. Click the Change icon next to your plan name in the left hand info/control area.
3. Select your new plan and click Submit

Creating Subdomains


hi,
Recently i have purchase Basic Windows plan from cpwebhosting.net, now i want to create subdomain . Plz. help

A subdomain is a lower level domain. It is added on the left of the domain name, e.g. subdomain.example.com. You can create as many subdomains as allowed by the plan. Domains and subdomains have equal functional capabilities, including web site management, e-mail service, FTP, dedicated IPs, etc., but subdomains do not have their own DNS zones and usually cost less.

To create a subdomain, go through the following steps

1. Select Domain Info link in Domain Settings menu in user’s Control Panel.
2. Click Add in the Sub Domains field. You will be asked to enter the subdomain name
3 Enter the new subdomain. It will be displayed in the Subdomain field of the Domain Settings page.

To run H-Sphere in debug mode


To run H-Sphere in debug mode:-

1. Compile classes with debug information:

./configure -javac –with-params=”-g”
make shiva

2. Set the following option “on” in jserv.conf to be able to launch JServ manually:

ApJServManual on

3. Create debug.sh shell script to run JServ in debug mode:

#!/bin/sh
properties=/home/shiva/apache/etc/jserv.properties
log=/home/shiva/apache/logs/jserv_manual.log
CLASSPATH=$CLASSPATH:/usr/local/java/JSDK2.0/lib/jsdk.jar
CLASSPATH=$CLASSPATH:/usr/local/apache/libexec/ApacheJServ.jar
java -Xdebug -Xrunjdwp:transport=dt_socket,address=9999,server=y ,suspend=n
org.apache.jserv.JServ $properties $1 2 >> $log
# address=9999 – port to which the debugger may be attached
# choose any available port you like

4. In IDE, set the following debug configuration:

Transport: Socket
Debuger Mode: Attach
Host: localhost
Port: 9999

5. Start Apache and run debug.sh after Apache start. Set IDE breakpoints and launch debug from IDE.