Roundcube Community Forum

Release Support => Pending Issues => Topic started by: ewong on October 31, 2012, 03:18:35 AM

Title: error log for "Check DB Config" when NOT OK
Post by: ewong on October 31, 2012, 03:18:35 AM
I'm installing roundcube 0.8.2 on a linux mail server.

I get the following message:

   Check DB config
   DSN (write):  NOT OK(MDB2 Error: connect failed)

   Make sure that the configured database exists and that the user has write privileges
   DSN: mysql://roundcube:password@localhost/roundcubemail

I've deleted the database and recreated it via:
   
    create database roundcubemail;
    grant all privileges on roundcubemail.* to roundcube@localhost identified by 'password';

I've looked in roundcube/logs, but there's no log in there.
I've looked in the mysql log, but no information regarding this access is detected.
(i.e.  mysql log isn't updated)

I've set up roundcube on a different machine (test machine) and it was ok.

I've changed the debug_level to 8.  Still no logs in webmail/logs.

This machine doesn't have a firewall installed.

Any help appreciated

Title: Re: error log for "Check DB Config" when NOT OK
Post by: ewong on October 31, 2012, 05:34:32 AM
Found the issue. 

Roundcube was trying to connect to a ip:port, when mysql was run in under a socket.

changed

  mysql://roundcube:password@localhost/roundcubemail

to

  mysql://roundcube:password@unix(/tmp/mysql.sock)/roundcubemail

and it works now