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
_______________________________________________
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users