1 Topic by Diablsoblizz

  • Diablsoblizz
  • Member
  • Offline
  • Registered: 2014-11-22
  • Posts: 5

Topic: Cannot Log into ClueBringer

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

Hi, I'm having problems logging into ClueBringer (and probably AWStats, I haven't checked). I've tried following this guide to try and resolve this. I've gotten further than before, but am now getting an Internal Server Error.

/apache/error.log wrote:

Failed to run mod-auth-mysql for /cluebringer/: No database name specified
AH01796: AuthType basic configured without corresponding module

Here are my configuration files (and the password listed for vmail has been changed, so what you see isn't actually the password):

/etc/apache2/apache.conf wrote:

#Auth_MySQL_Info 127.0.0.1 vmail La1QRIqW5aDGnHlhuP6ZWl345K6BwtZ1
#Auth_MySQL_General_DB vmail
<IfModule mod_dbd.c>
  DBDriver mysql
  DBDParams "host=127.0.0.1 dbname=vmail user=vmail pass=La1QRIqW5aDGnHlhuP6ZWl345K6BwtZ1"
  DBDMin 1
  DBDKeep 8
  DBDMax 20
  DBDExptime 300
</IfModule>

/etc/cluebringer/cluebringer.conf wrote:

# File generated by iRedMail:
#
#
# File generated by iRedMail:
#
# Version:  0.8.7
# Project:  http://www.iredmail.org/
#
# Community: http://www.iredmail.org/forum/
#

#
# SECURITY WARNING:
#
# Since libapache2-mod-auth-mysql doesn't support advance SQL query, both
# global admins and normal domain admins are able to login to this webui.

# Note: Please refer to /etc/apache2/sites-available/default-ssl.conf for SSL/TLS setting.

<Directory /usr/share/postfix-cluebringer-webui/webui/>
    DirectoryIndex index.php
    AuthType basic
    AuthName "Authorization Required"

    ##############################
    # mod_auth_mysql (deprecated)#
    ##############################
    # 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

    #################
    # mod_authn_dbd #
    #################
    # Password related.
    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE mailbox.username=%s"

    Order allow,deny
    Allow from all
    Require valid-user
</Directory>

Can somebody please help me with this?

Thanks!

----

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: 30,770

Re: Cannot Log into ClueBringer

You should modify /etc/cluebringer/cluebringer.conf too.

3 Reply by Diablsoblizz

  • Diablsoblizz
  • Member
  • Offline
  • Registered: 2014-11-22
  • Posts: 5

Re: Cannot Log into ClueBringer

ZhangHuangbin wrote:

You should modify /etc/cluebringer/cluebringer.conf too.

Hi, the cluebringer.conf file is exactly as the post described it as. Can you clarify what exactly needs to be modified?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot Log into ClueBringer

Diablsoblizz wrote:

Failed to run mod-auth-mysql for /cluebringer/: No database name specified
AH01796: AuthType basic configured without corresponding module

Did you disable all "Auth_MySQL_Info" and "Auth_MySQL_General_DB" setting in Apache config file? There may be two duplicate settings. Please double check.

5 Reply by Diablsoblizz

  • Diablsoblizz
  • Member
  • Offline
  • Registered: 2014-11-22
  • Posts: 5

Re: Cannot Log into ClueBringer

Hi Zhang,

Apache2.conf only has those two commented out lines of Auth_*.

Thanks

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot Log into ClueBringer

You can try to find them with 'grep' command. for example:

# cd /etc/apache2/
# grep -r 'Auth_MySQL_Info' *

Also, please disable Apache module 'auth_mysql' too:

# a2dismod auth_mysql

Then restart Apache and try again. If it still doesn't work, please comment below.

7 Reply by Diablsoblizz (edited by Diablsoblizz 2014-11-26 06:46:21)

  • Diablsoblizz
  • Member
  • Offline
  • Registered: 2014-11-22
  • Posts: 5

Re: Cannot Log into ClueBringer

ZhangHuangbin wrote:

You can try to find them with 'grep' command. for example:

# cd /etc/apache2/
# grep -r 'Auth_MySQL_Info' *

Also, please disable Apache module 'auth_mysql' too:

# a2dismod auth_mysql

Then restart Apache and try again. If it still doesn't work, please comment below.

Hi there, grep helped me determine what the issue was. Despite the configuration being changed in ClueBringer.conf in /etc/cluebringer/cluebringer.conf, it was not changed in /etc/apache2/conf-enabled/cluebringer.conf. I changed the configuration there, and it's working properly now.

Unfortunately, I stopped receiving emails since I changed the /etc/cluebringer/cluebringer.conf file. I've replaced the one I changed with the original, and cluebringer starts properly now via /etc/init.d/postfix-cluebringer start command. Now I just wait to see if emails roll in.

I realize now that I wanted to modify /etc/apache2/conf-available for this change. I had thought that enabling the configuration in the /etc/cluebringer/ folder it would copy over to apache, I realize now that it takes it from conf-available. Welp, I am glad I learned something!

One last question, how does ClueBringer / greylisting work? I am starting to receive a lot of spam, but I do have greylisting disabled. When I have it enabled, messages get delayed with a message of "greylisting in effect, please try again later." How does greylisting prevent spam from coming in? In addition will blocking a domain in ClueBringer stop the email if greylisting is disabled? I have the domain blocked under HELO/EHLO blacklisting, but will that stop spam from coming in? Here is my configuration:

http://i.imgur.com/N6yr8Y5.png

I'm just curious which option is correct, should I include the @ or not? I am worried that if I enable greylisting, I won't receive emails and they'll be stuck in that loop.

Thanks for your help!

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot Log into ClueBringer

Diablsoblizz wrote:

how does ClueBringer / greylisting work?

Check its web site for more details: http://greylisting.org/

Diablsoblizz wrote:

I have the domain blocked under HELO/EHLO blacklisting, but will that stop spam from coming in?

HELO/EHLO blacklisting is applied to HELO identity during smtp session, not to sender email address.

9 Reply by Diablsoblizz

  • Diablsoblizz
  • Member
  • Offline
  • Registered: 2014-11-22
  • Posts: 5

Re: Cannot Log into ClueBringer

Hi,

Is it possible to block domain name via ClueBringer or another method?

Thanks

10 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cannot Log into ClueBringer

Diablsoblizz wrote:

Is it possible to block domain name via ClueBringer or another method?

Sure. you can manage it with Cluebringer webui (https://<your_server>/cluebringer/ or iRedAdmin-Pro.