1 Topic by lderksen (edited by lderksen 2014-05-08 05:48:24)

  • lderksen
  • Member
  • Offline
  • Registered: 2014-05-07
  • Posts: 5

Topic: [SOLVED] Access denied after successful cluebringer login

==== Required information ====
- iRedMail version: development build 2014-05-05
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: FreeBSD 10.0-RELEASE-p2
- Related log if you're reporting an issue: no log, just error below
====

Recently I installed the development version of iRedMail on FreeBSD 10 because version 0.8.6 was not succesful (recent php ports change). As far as I can tell everything is working by default (only had to change one line in config file from roundcube).

Only problem i can't solve is after logging into cluebringer I recieve the error/fault below. I tested the cluebringer database with user/pass from cluebringer.conf and it works; I can login with adminer (small, powerful database editor webgui).

The error:
Error connecting to Policyd v2 DB: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

I don't know what must be checked or changed, although it's obviously related to database settings somewhere.

Any help or clue is appreciated, thanks in advance,

Regards,
LD
--
p.s. Thank you ZhangHuangbin for your awesome email solution

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by lderksen (edited by lderksen 2014-05-07 18:10:39)

  • lderksen
  • Member
  • Offline
  • Registered: 2014-05-07
  • Posts: 5

Re: [SOLVED] Access denied after successful cluebringer login

I found the solution in a tutorial for setting up Cluebringer:
https://signalboxes.net/howto/freebsd-mail-gateway/

Problem was the file  '/usr/local/www/policyd/includes/config.php'

changed from:
#$DB_DSN="sqlite:////tmp/cluebringer.sqlite";
$DB_DSN="mysql:host=localhost;dbname=cluebringer";
$DB_USER="root";
#$DB_PASS="";

to:
#$DB_DSN="sqlite:////tmp/cluebringer.sqlite";
$DB_DSN="mysql:host=localhost;dbname=cluebringer";
$DB_USER="cluebringer";
$DB_PASS="mysupersecretpassword";

Now changes can be made after logging in. Solutions makes sense wink but if you don't know where to look for it,.. ah well