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