H-Sphere was down


My H-Sphere was down, and when it finally came up, it gives me 500 error when accessed by browser.

Seemingly your PostgreSQL database is down. If you use Linux, restart it with the command:
etc/rc.d/init.d/postgresql restart

Logging problem


I have created a reseller account, logged in, but can’t enter admin cp.

Make sure:
– you have configured DNS for reseller
– you are using a registered domain.
If you need to use an unregistered domain for your own use only, add this domain to your hosts file (/etc/hosts on *nix systems)

H-Sphere templates


I have a web hosting account with H-Sphere control panel. can anyone tell me what are H-Sphere templates.

H-Sphere templates is basically what lays behind the H-Sphere Control Panel Web interface. For the most part, templates are written using Freemarker Java processing language for dynamic content generation.

What is the Location of Templates in H-Sphere control panel.

Location of Templates

1) Template root directory
2) Default (common) design directory
3) Custom template directory

InTemplate root directory:-

H-Sphere template root directory is by default /hsphere/local/home/cpanel/shiva-templates. It is set by the TEMPLATE_PATH parameter in the ~cpanel/shiva/psoft_config/hsphere.properties file:

TEMPLATE_PATH = /hsphere/local/home/cpanel/shiva/shiva-templates/

2) Default (common) design directory

Design, or skin, is the Control Panel GUI representation. Each design is defined by its own sets of templates, images, CSS styles, JavaScripts, etc. The most important part of GUI, templates, are placed in separate subdirectories of the template root directory in accordance to a design they belong to. The special common subdirectory is used to store templates that are the same for different designs. Also, this directory contains templates for the Left Menu design which is the default H-Sphere design. The path to this directory, relative to TEMPLATE_PATH, is set in hsphere.properties:

DEFAULT_TEMPLATES = common/

3) Custom template directory

Custom template directory is usually /hsphere/local/home/cpanel/shiva/custom/templates. Its location is set in hsphere.properties:

USER_TEMPLATE_PATH=/hsphere/local/home/cpanel/shiva/custom/templates/

Custom templates directory structure should correspond the default template root directory (shiva-templates) tree. However, you should be aware that templates in the custom template directory override the corresponding templates in the default template directory, thus all modifications and new features in existing default templates coming with new H-Sphere releases would be also overriden by custom templates. Therefore, only customized templates should be placed to your custom template directory.

Types of Templates

* System E-Mail Notification Templates
* Skeletons
* Web Interface Templates
o Main Templates
o Control Templates (Controls)
o Submit Templates (Submits)
o Function Templates
o Templates For Special Purposes
o Context Help Templates

Disable directory listings


How do I disable directory listings?

To disable directory listing (directory Indexes):

  1. Log into your control panel.
  2. Click the Web Options link.
  3. In the Settings field select Disabled for the Indexes setting.
  4. Click Submit.
  5. Click the Apply link to restart Apache with the new settings.

What items are used by H-Sphere to measure traffic and other data


What items are used by H-Sphere to measure traffic and other data (Gigabytes, Megabytes, Gigabits)?

Usually H-Sphere uses MB (Megabytes) to measure disk space. Traffic is measured in GB (Gigabytes). Gigabits are usually specified in Gb.

changing the password for the H-Sphere database


How do we go about changing the password for the H-Sphere database?

To change the password for the H-Sphere database:-

1) Log in to the CP server as root.
2) Log in as postgres user:
su – postgres
3) Find file passwd. Typically, it is located in ~postgres/data/
4) Type pg_passwd passwd
5) Type wwwuser
6) Enter and confirm your new password.
7) Log in as root.
8) Open file ~cpanel/shiva/psoft_config/hsphere.properties and change password in the following line:
#OBS_DB_PASSWORD =
9) Go to the directory with SiteStudio config files:
cd /hsphere/shared/SiteStudio/psoft_config/
10) In each .properties file, change value in the line:
DB_PASSWORD =
11) Restart control panel.

Alternatively, you can do it with the following SQL query:
ALTER USER wwwuser WITH PASSWORD ‘new_password’;

Why doesn’t H-Sphere create MS SQL db user with db owner permissions?


Why doesn’t H-Sphere create MS SQL db user with db owner permissions?

H-Sphere creates MS SQL users without db owner’s permission, because such permissions would allow users to change quotas which is not what most providers would like them to be able to do. H-Sphere shouldn’t be treated in any aspects as a db management tool. It just provides the access to dbs. To import and export dbs and execute similar management operations, users should use Enterprise Management or other similar clients.