Author Topic: 2.3 Beta Webmail database error  (Read 3016 times)

justinesmithies

  • Zen Apprentice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
2.3 Beta Webmail database error
« on: June 14, 2012, 10:19:38 am »
I have just installed 2.3 Beta and installed all packages. Setup mail and webmail but when i goto localhost/webmail i get the roundcube page saying unable to connect to database.

Help ??


spqr-ti

  • Zen Apprentice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Re: 2.3 Beta Webmail database error
« Reply #1 on: November 09, 2012, 09:32:02 pm »
help please, we're having the same problem ....

spqr-ti

  • Zen Apprentice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
Re: 2.3 Beta Webmail database error
« Reply #2 on: November 09, 2012, 10:01:45 pm »
Problema SOLVED !! ;)

This problem is easy to indentify chaking log in /var/log/roundcube/errors if it be show error:

[09-Nov-2012 18:28:32 -0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]

So you can solve it change the privilegies in mysql on roundcube database setting the correct password to roundcube user found in /etc/roundcube/debian-db.php to use the mysql command below:

~# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 95
Server version: 5.5.28-0ubuntu0.12.04.2 (Ubuntu)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT SELECT ON roundcube.* TO roundcube@'localhost' IDENTIFIED BY '<$dbpass in /etc/roundcube/debian-db.php>';
Query OK, 0 rows affected (0.00 sec)

mysql> \q
~#


DONE !!!
now you can test agin to access roundcube by Browser.

Best Regards

SPQR Team!