are you able to run sql queries?
there should be a .sql file for mysql that you would run
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.
Last edited by cshowe80; 10-16-2009 at 09:39 PM. Reason: add more info
are you able to run sql queries?
there should be a .sql file for mysql that you would run
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;
![]()
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.
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.
![]()
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.
![]()
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/.
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.
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)