1 Topic by mihanus

  • mihanus
  • Member
  • Offline
  • Registered: 2014-05-21
  • Posts: 6

Topic: Cluebringer web interface

==== Required information ====
- iRedMail version: iRedMail-0.8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu 14.04 LTS
- Related log if you're reporting an issue:
====

Greetings!
After install iRedMail package I cannot log into cluebringer using the data from iRedMail.tips. I've checked /etc/apache2/conf-available/cluebringer.conf , but settings looks normal:

<Directory /usr/share/postfix-cluebringer-webui/webui/>
    DirectoryIndex index.php
    AuthType basic
    AuthName "Authorization Required"
    AuthMYSQL on
    AuthBasicAuthoritative Off
    AuthUserFile /dev/null

    # Database related.
    AuthMySQL_Password_Table mailbox
    Auth_MySQL_Username_Field username
    Auth_MySQL_Password_Field password

    # Password related.
    AuthMySQL_Empty_Passwords off
    AuthMySQL_Encryption_Types Crypt_MD5
    Auth_MySQL_Authoritative On
    Order allow,deny
    Allow from all
    Require valid-user
</Directory>

Nevetheless, when I'm trying to log in, after few attempt of authorization, I get on my brouser Error 9 (net::ERR_UNEXPECTED): Unknown error.
Could someone tell me, where else should I look.

Thank's in advance

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Cluebringer web interface

Try this solution:
http://www.iredmail.org/forum/post30290.html#p30290

3 Reply by mihanus (edited by mihanus 2014-05-22 18:05:46)

  • mihanus
  • Member
  • Offline
  • Registered: 2014-05-21
  • Posts: 6

Re: Cluebringer web interface

ZhangHuangbin wrote:

Try this solution:
http://www.iredmail.org/forum/post30290.html#p30290

Thank's for answering!

And now I've got another problem. Here is my /var/log/apache2/error.log

[Thu May 22 13:33:27.386449 2014] [ssl:warn] [pid 5718] AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu May 22 13:33:27.389971 2014] [mpm_prefork:notice] [pid 5718] AH00163: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f mod_wsgi/3.4 Python/2.7.6 configured -- resuming normal operations
[Thu May 22 13:33:27.390010 2014] [core:notice] [pid 5718] AH00094: Command line: '/usr/sbin/apache2'
[Thu May 22 13:33:27.392435 2014] [dbd:error] [pid 9187] (20014)Internal error: AH00629: Can't connect to mysql: Access denied for user 'vmail'@'localhost' (using password: NO)
[Thu May 22 13:33:27.392489 2014] [dbd:error] [pid 9187] (20014)Internal error: AH00633: failed to initialise
[Thu May 22 13:33:27.392494 2014] [dbd:crit] [pid 9187] (20014)Internal error: AH00636: child init failed!

I cheked that user 'vmail' in MySQL get usage privilege for vmail data base. Password for connection with MySQL for vmail user was taken from iRedMail.tips.
Any suggestions?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Cluebringer web interface

mihanus wrote:

[Thu May 22 13:33:27.392435 2014] [dbd:error] [pid 9187] (20014)Internal error: AH00629: Can't connect to mysql: Access denied for user 'vmail'@'localhost' (using password: NO)

It says it doesn't use password for connection. So please double check your settings.

5 Reply by mihanus

  • mihanus
  • Member
  • Offline
  • Registered: 2014-05-21
  • Posts: 6

Re: Cluebringer web interface

ZhangHuangbin wrote:
mihanus wrote:

[Thu May 22 13:33:27.392435 2014] [dbd:error] [pid 9187] (20014)Internal error: AH00629: Can't connect to mysql: Access denied for user 'vmail'@'localhost' (using password: NO)

It says it doesn't use password for connection. So please double check your settings.

Can you tell me, please, where should I look for them? In MySQL I can see entry for 'vmail' user with password set up

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Cluebringer web interface

Your Apache config file which has dbd authentication enabled: /etc/apache2/conf-available/cluebringer.conf.

7 Reply by mihanus (edited by mihanus 2014-05-23 13:19:53)

  • mihanus
  • Member
  • Offline
  • Registered: 2014-05-21
  • Posts: 6

Re: Cluebringer web interface

Here is my /cluebringer.conf file.


DBDriver mysql
DBDParams "host=127.0.0.1 port=3306 dbname=vmail user=vmail password=****"

<Directory /usr/share/postfix-cluebringer-webui/webui/>

AuthType Basic
AuthName "My Server"
AuthBasicProvider dbd

AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE user = %s"

Require valid-user

</Directory>

Does it has something wrong? May be I missed something?

8 Reply by mihanus

  • mihanus
  • Member
  • Offline
  • Registered: 2014-05-21
  • Posts: 6

Re: Cluebringer web interface

Here what I've found after some research
http://stackoverflow.com/questions/2290 … horization

I resumed to my previous cluebringer.conf and set Auth_MySQL_Authoritative Off, as it was described in link. This helps me to connect to both cluebringer and awstats (after same operations in awstats.conf) webUI's, with correct credentials.
May be this is the true solution?

9 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Cluebringer web interface

mihanus wrote:

DBDParams "host=127.0.0.1 port=3306 dbname=vmail user=vmail password=****"

It's 'pass=', not 'password='.

10 Reply by mihanus

  • mihanus
  • Member
  • Offline
  • Registered: 2014-05-21
  • Posts: 6

Re: Cluebringer web interface

Damn! Where were my eyes? )))
Thank you Zhang and sorry for my inattention!

11 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Cluebringer web interface

It's ok. Actually, it uses 'pass=' for MySQL, 'password=' for PostgreSQL. WTF...