1

Topic: Error access awstats cluebringer

==== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
======== Required information ====
- iRedMail version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Linux/BSD distribution name and version:
- Related log if you're reporting an issue:
====I'm trying install iRedMail 0.8.7 in a new machine to upgrade a old one.
I can't access the  https://server_ip/awstats and cluebringer, the msg error is:

Unauthorized
This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser doesn't understand how to supply the credentials required.
Apache Server at 192.168.0.210 Port 443

I copy/paste the user and password from config email from postmaster. I can access roundcube, admin and phpmyadmin.
I don't find any error msg in apache or syslog logs.

I create a VM and install a clean Ubuntu 14.04 LTS, but the same error occurs.


- iRedMail version: 0.8.7 (new install)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu 14.04 lts

----

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

2

Re: Error access awstats cluebringer

Try alternative authentication settings:

- http://www.iredmail.org/forum/topic7014 … rface.html
- http://www.iredmail.org/forum/topic7094 … stats.html

3 (edited by RafaelMass 2014-06-05 00:42:23)

Re: Error access awstats cluebringer

I try this http://www.iredmail.org/forum/topic7094 … stats.html
But don't work.
libaprutil1-dbd-mysql ok
a2enmod dbd authn_dbd ok

but now I have some data in logs.
my apache2.conf

# This is the main Apache server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See http://httpd.apache.org/docs/2.4/ for detailed information about
# the directives and /usr/share/doc/apache2/README.Debian about Debian specific
# hints.
#
#
# Summary of how the Apache 2 configuration works in Debian:
# The Apache 2 web server configuration in Debian is quite different to
# upstream's suggested way to configure the web server. This is because Debian's
# default Apache2 installation attempts to make adding and removing modules,
# virtual hosts, and extra configuration directives as flexible as possible, in
# order to make automating the changes and administering the server as easy as
# possible.

# It is split into several files forming the configuration hierarchy outlined
# below, all located in the /etc/apache2/ directory:
#
#    /etc/apache2/
#    |-- apache2.conf
#    |    `--  ports.conf
#    |-- mods-enabled
#    |    |-- *.load
#    |    `-- *.conf
#    |-- conf-enabled
#    |    `-- *.conf
#     `-- sites-enabled
#         `-- *.conf
#
#
# * apache2.conf is the main configuration file (this file). It puts the pieces
#   together by including all remaining configuration files when starting up the
#   web server.
#
# * ports.conf is always included from the main configuration file. It is
#   supposed to determine listening ports for incoming connections which can be
#   customized anytime.
#
# * Configuration files in the mods-enabled/, conf-enabled/ and sites-enabled/
#   directories contain particular configuration snippets which manage modules,
#   global configuration fragments, or virtual host configurations,
#   respectively.
#
#   They are activated by symlinking available configuration files from their
#   respective *-available/ counterparts. These should be managed by using our
#   helpers a2enmod/a2dismod, a2ensite/a2dissite and a2enconf/a2disconf. See
#   their respective man pages for detailed information.
#
# * The binary is called apache2. Due to the use of environment variables, in
#   the default configuration, apache2 needs to be started/stopped with
#   /etc/init.d/apache2 or apache2ctl. Calling /usr/bin/apache2 directly will not
#   work with the default configuration.


# Global configuration
#

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# NOTE!  If you intend to place this on an NFS (or otherwise network)
# mounted filesystem then please read the Mutex documentation (available
# at <URL:http://httpd.apache.org/docs/2.4/mod/core.html#mutex>);
# you will save yourself a lot of trouble.
#
# Do NOT add a slash at the end of the directory path.
#
#ServerRoot "/etc/apache2"

#
# The accept serialization lock file MUST BE STORED ON A LOCAL DISK.
#
Mutex file:${APACHE_LOCK_DIR} default

#
# PidFile: The file in which the server should record its process
# identification number when it starts.
# This needs to be set in /etc/apache2/envvars
#
PidFile ${APACHE_PID_FILE}

#
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 300

#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5


# These need to be set in /etc/apache2/envvars
User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}

#
# HostnameLookups: Log the names of clients or just their IP addresses
# e.g., www.apache.org (on) or 204.62.129.132 (off).
# The default is off because it'd be overall better for the net if people
# had to knowingly turn this feature on, since enabling it means that
# each client request will result in AT LEAST one lookup request to the
# nameserver.
#
HostnameLookups Off

# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog ${APACHE_LOG_DIR}/error.log

#
# LogLevel: Control the severity of messages logged to the error_log.
# Available values: trace8, ..., trace1, debug, info, notice, warn,
# error, crit, alert, emerg.
# It is also possible to configure the log level for particular modules, e.g.
# "LogLevel info ssl:warn"
#
LogLevel warn

# Include module configuration:
IncludeOptional mods-enabled/*.load
IncludeOptional mods-enabled/*.conf

# Include list of ports to listen on
Include ports.conf


# Sets the default security model of the Apache2 HTTPD server. It does
# not allow access to the root filesystem outside of /usr/share and /var/www.
# The former is used by web applications packaged in Debian,
# the latter may be used for local directories served by the web server. If
# your system is serving content from a sub-directory in /srv you must allow
# access here, or in any related virtual host.
<Directory />
    Options FollowSymLinks
    AllowOverride None
    Require all denied
</Directory>

<Directory /usr/share>
    AllowOverride None
    Require all granted
</Directory>

<Directory /var/www/>
    Options Indexes FollowSymLinks
    AllowOverride None
    Require all granted
</Directory>

#<Directory /srv/>
#    Options Indexes FollowSymLinks
#    AllowOverride None
#    Require all granted
#</Directory>




# AccessFileName: The name of the file to look for in each directory
# for additional configuration directives.  See also the AllowOverride
# directive.
#
AccessFileName .htaccess

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^\.ht">
    Require all denied
</FilesMatch>


#
# The following directives define some format nicknames for use with
# a CustomLog directive.
#
# These deviate from the Common Log Format definitions in that they use %O
# (the actual bytes sent including headers) instead of %b (the size of the
# requested file), because the latter makes it impossible to detect partial
# requests.
#
# Note that the use of %{X-Forwarded-For}i instead of %h is not recommended.
# Use mod_remoteip instead.
#
LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent

# Include of directories ignores editors' and dpkg's backup files,
# see README.Debian for details.

# Include generic snippets of statements
IncludeOptional conf-enabled/*.conf

# Include the virtual host configurations:
IncludeOptional sites-enabled/*.conf

# vim: syntax=apache ts=4 sw=4 sts=4 sr noet
# MySQL auth (libapache2-mod-auth-apache2).
# Global config of MySQL server, username, password.
### Auth_MySQL_Info 127.0.0.1 vmail flgH0sJKIiXuUHEa1smTXUzHLsx6Qo
### Auth_MySQL_General_DB vmail
# MySQL auth (libapache2-mod-auth-apache2).
# Global config of MySQL server address, username, password.
### Auth_MySQL_Info 127.0.0.1 vmail flgH0sJKIiXuUHEa1smTXUzHLsx6Qo
### Auth_MySQL_General_DB vmail

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

awstats.conf:

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

# Note: Please refer to /etc/apache2/sites-available/default-ssl.conf for SSL/TLS setting.
#Alias /awstats/icon "/usr/share/awstats/icon/"
#Alias /awstats/css "/usr/share/awstats/css/"
#Alias /awstats/js "/usr/share/awstats/js/"
#ScriptAlias /awstats "/usr/lib/cgi-bin/"

<Directory /usr/lib/cgi-bin/>
    DirectoryIndex awstats.pl
    Options ExecCGI

    AuthName "Authorization Required"
    AuthType Basic
#    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
#    #AuthMySQLUserCondition "isglobaladmin=1"

    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE mailbox.username=%s"

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

cluebringer.conf

#
# File generated by iRedMail (2014.06.03.15.18.45):
#
# 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"

#    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
    
    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE mailbox.mailname=%s"

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

apache2 error.log

[Wed Jun 04 11:00:10.662419 2014] [dbd:error] [pid 2718] (20014)Internal error: AH00632: failed to prepare SQL statements: Unknown column 'mailbox.mailname' in 'where clause'
[Wed Jun 04 11:00:10.666091 2014] [dbd:error] [pid 2718] (20014)Internal error: AH00633: failed to initialise
[Wed Jun 04 11:00:10.666189 2014] [dbd:crit] [pid 2718] (20014)Internal error: AH00636: child init failed!

4

Re: Error access awstats cluebringer

iRedMail doesn't have SQL column "mailbox.mailname". It should be 'username'.

5

Re: Error access awstats cluebringer

I also tried the solution at http://www.iredmail.org/forum/topic7094 … tats.html, except I wanted to use this to password protect a subdir of one of my sites I set up after installing iRedMail. I got the configtest error and not even a server reboot helped. I had to comment out the suggested changes in order to get Apache to start.