Roundcube Community Forum
News and Announcements => General Discussion => Topic started by: cshowe80 on October 16, 2009, 04:37:36 PM
-
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.
-
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;
(http://img132.imageshack.us/img132/9818/phpadmin.jpg)
-
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.
(http://img26.imageshack.us/img26/8199/mysqltables.jpg)
(http://img243.imageshack.us/img243/1916/roundcubeerror.jpg)
-
Try deleting the .htaccess file in the root directory.
-
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.
(http://img62.imageshack.us/img62/2301/installererror.jpg)
-
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/.
-
Try deleting the .htaccess file in the root directory.
had the same problem, i need to modify .htaccess as well
-
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.
(http://img502.imageshack.us/img502/9476/installerror2.jpg)
-
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.
-
I only get the second screen of the installer. Here is what I have on the 2 screens
(http://img249.imageshack.us/img249/3082/instalscreen01.jpg)
(http://img265.imageshack.us/img265/3131/instalscreen02.jpg)
-
Try removing the RoundCube database tables and use the installer again.
-
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?
-
I would see if that works.
-
I have since resolved this issue and successfully have this installed and running on my Myhosting.com hosting account. I believe they will be posting a article on how to do this on their customer wiki site located at Main Page - myhosting.com Wiki (http://wiki.myhosting.com) in the near future.
The only thing I would like to suggest to the Roundcube developers is using the files in the SQL directory with a prefix of some kind to make it simpler on users with existing DBs
-
It would be nice to know how you solved that problem as I have the same one here.
First I created a new database in the MySQL menu of my webhoster, imported the mysql.initial.sql to create the tables and ran the installer. Both config files created properly with correct access details to the database (username, DB, password,...). But initializing the database causes this error:
DB Schema: NOT OK(Error creating database schema: MDB2 Error: syntax error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: /*!40014 SET FOREIGN_KEY_CHECKS=0 */; ] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; ' at line 5] )
Even if I drop all tables in the DB and run the installer (to maybe create the tables bit itself) does not work.
http://img280.imagevenue.com/img.php?image=70343_Unbenannt_122_207lo.JPG
The DB is a MySQL 5 one.
The advice in the install-file also does not work:
# mysql
CREATE DATABASE roundcubemail /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
IDENTIFIED BY 'password';
quit
>> "#1044 - Access denied for user 'db305468_1'@'127.0.0.3' to database 'roundcubemail' "
Can anybody help me? I am getting really frustrated and it will take not long and I will delete Roundcube.