My user is trying to install a certificate and key on the site and gets the following error: Invalid certificate format, file: server.key

To install your certificate and key on your site, you need to remove encryption and enter it in clear-text format. Encryption can be removed with the OpenSSL utility of Unix Shell on any Unix server where OpenSSL utilities pack is installed, for example on the Control Panel box.

1. Put you encrypted Private Key into a separate file and save it as server_old.key
2. In Unix Shell, execute the following command: openssl rsa -in server_old.key -out server.key
3. Enter the password when prompted.
4. A new file (server.key) will be generated. It will contain the Private Key in a plain text format.

I Just changed disk quota in one of our plans and our customers were not affected by this change.

If you want these changes to affect some of your existing users, you need to enter their control panels one by one, go to Web Options page and click Apply changes.

One of my customers shows disk quota Used 0 MB of 0 MB limit, but actually has about 5MB.

The disk space problem appears when a check-paying user tries to increase the disk space quota. Disk quota resource is changed on the add/remove basis. The old disk space quota is removed and the new disk space quota fails to be created but fails, because this would go beyond the credit limit. The solution is to increase this user’s credit limit and then restore the disk quota resource.

Why neither dbs nor users are created under my end-user accounts?

If you have two *SQL logical servers available for signup, then the servers for dbs/logins/users creation are chosen by randomize. Imagine wwwuser creates database A and A1 and A2 users and they all go to sql1.mydomain.com. Then even if you prohibit it for signup, the system will still try to create new dbs and db users of wwwuser on sql1.mydomain.com. And as the signup is turned off on it, neither dbs nor users for this db will be created.

I have suspended my master admin account. How do I resume it?

Log into your H-Sphere database and run the command:
update accounts set suspended=null where id=1;
Then restart H-Sphere.

Hi,

How can I Create MySQL Database and Its Users ?

MySQL users cannot exist separately from MySQL databases. You must stick to the following sequence:

1. Create a database
2. Add MySQL users to each created database.

However, MySQL users can be shared by different databases.

To create a MySQL database, do the following:

1. Click MySQL Server on your control panel home page.
2. Click Add database at the bottom of the form:
3. On the form that shows enter the name of the database and database description if needed
4. agree with additional charges if any.
5. In the form that appears, create a new user or grant privileges to users of other databases:

* Add a new user to the database you have just created.
* Choose roles for users of other databases so they can use your new database.

6. Click Finish to complete creating your MySQL database.

Editing MySQL databases (phpMyAdmin)

You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel. To run phpMyAdmin, do the following:

1. Click MySQL Server on your control panel home page.
2. In the form that appears, click the name of the existing MySQL Database you want to edit or the Edit icon on its right:
3. In the form that appears, click Built in phpMyAdmin control panel to start editing your database
4. Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.

Hi

I want to change my MySQL disk quota. How can i do it?

To change MySQL disk quota, do the following:

1. Click MySQL Server on your control panel home page.
2. Click the MySQL Database or the Edit icon on its right:
3. Click the Change button against the Quota field:
4. Enter the new quota.
5. Click Submit.
6. Agree to additional charges.