Installing SupportSuite with cpanel - database help please

[Jr2swiss]

Can anyone tell me how to install Kayako with cpanel. Manual.kayako.net doesn't cover cpanel db creation. I know how to create the database but I don't know what the db name should be.

I created a db called kayako_suite but after I created the db it renamed itself to gp32z2_kayakosuite. I tried to set a username and password but it wouldn't work. You can check out the error that I get at http://www.gp2xstore.com/support/

Is there a specific step that i'm missing or am I naming the database wrong? Any help would be appreciated.

[supportskins]

You can name the db to anything you want. Usually on cPanel the created dbname is cpaneluser_dbname (chosen by you). Make sure you enter the same dbname in /config/config.php. Once entered correctly it should work fine.

[Jamie Edwards]

Creating the database in cPanel:

1. Go to MySQL.
2. Under "New Database", enter a database name. Do this in the knowledge that it will be renamed to yourcpanelusername_databasename by cPanel.

Create the database user in cPanel:

1. Go to MySQL.
2. Under "Current Users" type in a database username and password. These can be anything you like. Do this in the knowledge that the username will be renamed to yourcpanelusername_username by cPanel.

Adding the database user to your database in cPanel:

1. Go to MySQL.
2. Under "Add Users To Your Databases" select the username you have just created, followed by the database you have just created.
3. Check the "ALL" box and leave all others unchecked.
4. Click "Add User To Database"

Configuring SupportSuite to connect to this database

1. Assuming you have the following database name: cpanelusername_ssdb
2. Assuming you have the following database username: cpanelusername_supportsuite with password 45y24g24g
3. Open up config/config.php and add the respective values, as in the example shown below:

/**
* DATABASE HOSTNAME
*/
$_DB["hostname"] = "localhost";

/**
* DATABASE USERNAME
*/
$_DB["username"] = "cpanelusername_supportsuite";

/**
* DATABASE PASSWORD
*/
$_DB["password"] = "45y24g24g";

/**
* DATABASE NAME
*/
$_DB["name"] = "cpanelusername_ssdb;

And you should be good to go

Note: Within a normal cPanel installation, you should use localhost as your database hostname as shown above.

[supportskins]

Could not explain it better. Good job!

[Jr2swiss]

Thank you for the quick responses. Got it up and running now.