Roundcube Community Forum

Release Support => Pending Issues => Topic started by: actuel on August 25, 2006, 05:57:59 PM

Title: Service Not Available / (105) DB Error / Site5
Post by: actuel on August 25, 2006, 05:57:59 PM
Hello. I'm trying to install Roundcube on my Site5 account and have hit some walls. Intially I was following the steps laid out in this tutorial for Site5 users: http://forums.site5.com/showthread.php?t=9374&highlight=roundcube (http://forums.site5.com/showthread.php?t=9374&highlight=roundcube)

After becoming frustrated I spent some time in the RoundCubeForum reading folks with similiar problems. I know its possible because others have done it, but i'm hitting my head against the wall at this point. Below is my original post over at Site5. Please help if you can...thanks:

Ok so i've followed the steps (all but chmod 600...i don't know how to do this...yet) and this is what i'm getting:

DB Error in /home/indycdan/public_html/webmail/program/include/rcube_db.inc (105): DB Error: connect failed

SERVICE CURRENTLY NOT AVAILABLE!

DB Error: connect failed

I've went through the install instructions here many times and additionally have spent hours over at roundcubeforum.net trying to figure this out. So now i ask for help.

here's 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://userassword@host/databse
// currentyl suported db_providers: mysql, sqlite

$rcmail_config['db_dsnw'] = 'mysql://admin:PASSWORD@webmail.indycdandvinyl/roundcube';
// postgres example: 'pgsql://roundcubeass@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 it should be noted the the database i created through Netadmin was done as 'roundcube' but shows up in mysql as indycdan_roundcube. I placed roundcubes files in a folder called 'webmail' via ftp. I also created webmail.indycdandvinyl.com. Additionally made a user and granted permission.

On the main.inc.php i replaced localhost w/ indycdandvinyl.com but was a little confused about the $rcmail_config['des_key'] = 'change this key'; part. I made up a key but wasn't sure if that was all that was necessary.

I spent 4 hours reading and working on. I finally realized I needed sleep...today it seems wiser to just ask for help.

Thanks,
Ryan
Title: Re: Service Not Available / (105) DB Error / Site5
Post by: yllar on August 26, 2006, 05:19:34 AM
$rcmail_config['db_dsnw'] = 'mysql://admin:PASSWORD@YOUR_MYSQL_SERVER/indycdan_roundcube';
Title: Re: Service Not Available / (105) DB Error / Site5
Post by: actuel on August 26, 2006, 04:03:53 PM
thx Yilar! after rereading the Site5 RC tutorial, reading your post, and sleeping I've managed to strike gold.

thx
ryan