Roundcube Community Forum

 

error log for "Check DB Config" when NOT OK

Started by ewong, October 31, 2012, 03:18:35 AM

Previous topic - Next topic

ewong

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


ewong

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