Hi Guys!

im newbie in roundcube business and i have got a problem with connection with mysql database.

there is my configuration:

config.inc.php

// Database connection string (DSN) for read+write operations
// Format (compatible with PEAR MDB2): db_provider://user:password@host/database
// Currently supported db_providers: mysql, pgsql, sqlite, mssql or sqlsrv
// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-d$
// NOTE: for SQLite use absolute path: 'sqlite:////full/path/to/sqlite.db?mode=$
$config['db_dsnw'] = 'mysql://roundcube:xxxxxxx@localhost/roundcube';


i already tested my database connection with a php script:

<?php
$banco = "roundcube";
$usuario = "roundcube";
$senha = "xxxxxxx";
$hostname = "localhost";
$conn = mysql_connect($hostname,$usuario,$senha); mysql_select_db($banco) or di$
if (!$conn) {echo "Não foi possível conectar ao banco MySQL.
"; exit;}
else {echo "Parabéns!! A conexão ao banco de dados ocorreu normalmente!.
";}
mysql_close();
?>


this script worked and shows me the database connection is ok.

the error message occurs when i access the address   "http://192.168.56.101/roundcubemail/":

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.


In error logs this lines appeared:

[14-Oct-2014 09:26:29 -0300]: DB Error: [1046] No database selected (SQL Query: SELECT vars, ip, changed, now() AS ts FROM session WHERE sess_id = '1v2pbh7mn0obojf8eu864mlgn1') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 467 (GET /roundcubemail/)
[14-Oct-2014 09:26:29 -0300]: DB Error: [1046] No database selected (GET /roundcubemail/)
[14-Oct-2014 09:26:29 -0300]: DB Error: [1046] No database selected (SQL Query: SELECT * FROM identities WHERE del <> 1 AND user_id = NULL ORDER BY `standard` DESC, name ASC, identity_id ASC) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 467 (GET /roundcubemail/)
[14-Oct-2014 09:26:29 -0300]: DB Error: [1062] Duplicate entry '1v2pbh7mn0obojf8eu864mlgn1' for key 'PRIMARY' (SQL Query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('1v2pbh7mn0obojf8eu864mlgn1', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGFza3xzOjU6ImxvZ2luIjs=', '192.168.56.1', now(), now())) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 467 (GET /roundcubemail/)


someone could help me?

ATT


--


Vinicius Masiero
Técnico de Informática Sênior
Telefone: 51 3553-2049