Author Topic: cant see what I am doing wrong  (Read 6986 times)

Offline brandon

  • Newbie
  • *
  • Posts: 2
cant see what I am doing wrong
« on: August 20, 2006, 04:17:31 PM »
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

Offline yllar

  • Full Member
  • ***
  • Posts: 106
Re: cant see what I am doing wrong
« Reply #1 on: August 20, 2006, 04:38:19 PM »
[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
irc://irc.freenode.net:6667/#roundcube

Offline brandon

  • Newbie
  • *
  • Posts: 2
Re: cant see what I am doing wrong
« Reply #2 on: August 20, 2006, 05:15:46 PM »
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. :(

Offline Harry

  • Newbie
  • *
  • Posts: 2
Re: cant see what I am doing wrong
« Reply #3 on: August 24, 2006, 04:31:48 AM »
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?

Offline yllar

  • Full Member
  • ***
  • Posts: 106
Re: cant see what I am doing wrong
« Reply #4 on: August 24, 2006, 04:43:05 AM »
as told in http://roundcubeforum.net/forum/index.php?topic=443.msg2183#msg2183 FLUSH PRIVILEGES; could be good idea.
irc://irc.freenode.net:6667/#roundcube

Offline Tucker

  • Newbie
  • *
  • Posts: 6
Re: cant see what I am doing wrong
« Reply #5 on: August 24, 2006, 07:27:17 AM »
@Harry

Error Code 405 ???

Quote from the RFC:
Quote
0.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
Quote
Resolving 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??

Offline Harry

  • Newbie
  • *
  • Posts: 2
Re: cant see what I am doing wrong
« Reply #6 on: August 24, 2006, 09:40:33 AM »
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.