Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: Canna on July 01, 2010, 03:45:27 AM

Title: Windows 2003 Roundcube mssql
Post by: Canna on July 01, 2010, 03:45:27 AM
Hi,

I have one problem with my roundcube database when i try to connect on:

http://127.0.0.1/index.php (roudcube)

Quote
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.


so this is my configuration:

php 5.3.2
IIS 6
windows serveur 2003
microsoft sql serveur 2005 express
hmail 5.3.2-b1769

this is my db.inc.php

Quote

/*
 +-----------------------------------------------------------------------+
 | Configuration file for database access                                |
 |                                                                       |
 | This file is part of the RoundCube Webmail client                     |
 | Copyright (C) 2005-2009, 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/database
// For examples see Manual :: The Data Source Name (http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php)
// currently supported db_providers: mysql, mysqli, pgsql, sqlite, mssql

$rcmail_config['db_dsnw'] = 'mssql://roundcube:password@localhost\\SQLEXPRESS/roundcubemail';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// Warning: for SQLite use absolute path in DSN:
// sqlite example: 'sqlite:////full/path/to/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'] = '';

// maximum length of a query in bytes
$rcmail_config['db_max_length'] = 512000;  // 500K

// use persistent db-connections
// beware this will not "always" work as expected
// see: PHP: Persistent Database Connections - Manual (http://www.php.net/manual/en/features.persistent-connections.php)
$rcmail_config['db_persistent'] = FALSE;


// 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
?>


$rcmail_config['db_dsnw'] = 'mssql://roundcube:password@localhost/roundcubemail';
i have try this to
roundcube is my user
password is my password
roundcubemail is my DB