I followed the directions provided by bluehost to setup roundcube but no matter what I do I am getting the same error. This is my primer to msql and myphpadmin so it could be something obvious that I just do not know any better. So here are the instructions I followed to the letter:
http://helpdesk.bluehost.com/kb/index.php?x=&mod_id=2&root=22&id=302
So by using the tutorial along with the others I found I am still getting this in my error log:
[20-Aug-2006 01:40:34 -0600] DB Error: DB Error: insufficient permissions in /home/cajunfab/public_html/rc/program/include/rcube_db.inc on line 105
here is my db.inc.php:
/*
+-----------------------------------------------------------------------+
| Configuration file for database access |
| |
| This file is part of the RoundCube Webmail client |
| Copyright (C) 2005, RoundCube Dev. - Switzerland |
| Licensed under the GNU GPL |
| |
+-----------------------------------------------------------------------+
*/
$rcmail_config = array();
// PEAR database DSN for read/write operations
// format is db_provider://user:password@host/databse
// currentyl suported db_providers: mysql, sqlite
$rcmail_config['db_dsnw'] = 'mysql://cajunfab_brandon:passwordhere@localhost/cajunfab_myroundcube';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';
// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['db_dsnr'] = '';
// database backend to use (only db or mdb2 are supported)
$rcmail_config['db_backend'] = 'db';
// maximum length of a query in bytes
$rcmail_config['db_max_length'] = 512000; // 500K
// use persistent db-connections
$rcmail_config['db_persistent'] = TRUE;
// you can define specific table names used to store webmail data
$rcmail_config['db_table_users'] = 'users';
$rcmail_config['db_table_identities'] = 'identities';
$rcmail_config['db_table_contacts'] = 'contacts';
$rcmail_config['db_table_session'] = 'session';
$rcmail_config['db_table_cache'] = 'cache';
$rcmail_config['db_table_messages'] = 'messages';
// you can define specific sequence names used in PostgreSQL
$rcmail_config['db_sequence_users'] = 'user_ids';
$rcmail_config['db_sequence_identities'] = 'identity_ids';
$rcmail_config['db_sequence_contacts'] = 'contact_ids';
$rcmail_config['db_sequence_cache'] = 'cache_ids';
$rcmail_config['db_sequence_messages'] = 'message_ids';
// end db config file
?>
now in my main.inc.php the only thing i changed was from the instructions at bluehost:
Find this line:
$rcmail_config['enable_caching'] = TRUE;
And change the word TRUE; to FALSE;
Find this line:
$rcmail_config['default_host'] = '';
Between the two single quotations type mail.yourdomain.com
[20-Aug-2006 01:40:34 -0600] DB Error: DB Error: insufficient permissions in /home/cajunfab/public_html/rc/program/include/rcube_db.inc on line 105
cajunfab_brandon has insufficent privileges on cajunfab_myroundcube
well the was checked as "All" for permissions, I manually checked each one and now it let me login. When I try to view an email I get a blank website though, nothing at all shows up. :(
Hi, I'm new to roundcube and I'm having the same problem.
I've finally got to the point where it gives me the login screen (I've spent two days trying to get rid of the database connection error) and now get a 405 error after I login.
Anybody know what to do next?
as told in http://roundcubeforum.net/forum/index.php?topic=443.msg2183#msg2183 FLUSH PRIVILEGES; could be good idea.
@Harry
Error Code 405 ???
Quote from the RFC:
Quote0.4.6 405 Method Not Allowed
The method specified in the Request-Line is not allowed for the resource identified by the Request-URI. The response MUST include an Allow header containing a list of valid methods for the requested resource.
Take a look at this site http://www.checkupdown.com/status/E405.html
especially
QuoteResolving 405 errors - general
405 errors often arise with the POST method. You may be trying to introduce some kind of input form on your Web site, but not all ISPs allow the POST method necessary to process the form.
All 405 errors can be traced to configuration of the Web server and security governing access to the content of the Web site, so should easily be explained by your ISP.
Probably a misconfiguration of your webserver! How did you install RC? Just in your www-root in a subdir or with Alias or Virtualhost??
Thanks for the reply.
I've installed it in a subdirectory in the wwwroot. It's hosted on my home server which I built so there is a very good chance that the server is misconfigured.