Installing on Hosting Account

[cshowe80]

I am trying to install roundcube on a hosting account and it does not allow me to log into the Linux server and create new databases. I have to add tables to the already existing MySQL database but I can not find any information anywhere on how to do this. I'd like to use a prefix like rc_ for all the required roundcube tables. I am new to installing PHP applications but generally savvy with Hosting/PC operations.

[tekone]

are you able to run sql queries?

there should be a .sql file for mysql that you would run

[cshowe80]

I do have a tool to run queries but I got an error when I ran this following code. I changed the variables in red to my DB specifics and it was unsuccessful. Is there something I am missing here?

CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO username@localhost IDENTIFIED BY 'password;

[SKaero]

A lot of shared servers don't allow users to create databases that way, if you only have the one database just run the [RC root]/SQL/mysql.initial.sql file that will create the database tables.

[cshowe80]

So I thought this would be so simple when I started and now due to pure stubbornness I refuse to give up easily. The DB tables have been created but when I go to the roundcube/installer url I don't get the installer still. Should there be any special permissions for that folder? I have full 777 on temp and log folders.

Thanks for the help BTW. I would be lost without all your help.

[SKaero]

Try deleting the .htaccess file in the root directory.

[cshowe80]

Removed .htaccess in the main folder of roundcube. I then got a message it couldnt find 2 files. I checked the config folder and renamed db.inc.php.dist and main.inc.php.dist to not include the.dist. Today I am going to go through the files and have a peek at the contents variable etc but when i did all this I got this error.

[SKaero]

Just taking the .dist off just gives it the default configuration witch doesn't have your database information, you need to set it up by going to http://url-to-roundcube/installer/.

[fartman]

Try deleting the .htaccess file in the root directory.

had the same problem, i need to modify .htaccess as well

[cshowe80]

I think I am one step from finally getting this completed. I got the installer to open and I played around with the main.inc.php & db.inc.php files and I got this far.

Now it seems like the only issue is in the DB Schema at this point. I am thinking either the db tables did not get added properly or something of the sort. Again any help will be greatly appreciated.

[SKaero]

Does it gives you the login screen? If it doesn't check that your database configuration is correct, if that still doesn't work then delete the RoundCube tables form the database and run the installer again.

[cshowe80]

I only get the second screen of the installer. Here is what I have on the 2 screens

[SKaero]

Try removing the RoundCube database tables and use the installer again.

[cshowe80]

I removed them and used the mysql.initial.sql file again to create them. Maybe it is a better idea to try and let the installer create the tables?

[SKaero]

I would see if that works.