======== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.4
- Linux/BSD distribution name and version: Ubuntu 14.04.4 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Apache/2.4.7 (Ubuntu)
- Manage mail accounts with iRedAdmin-Pro? No.
- Related log if you're reporting an issue:
====

Hello,

I changed my postmaster account password through iRedAdmin (non pro) and I can't log into awstats with the new one or the old one. I don't know that it ever worked because I didn't try before the password change. The new password works for Roundcube and iRedAdmin.

Identifying info redacted:

My /etc/apache2/conf-available/awstats.conf (it is enabled)
DBDriver mysql
# Important note: use 'pass=' for MySQL, 'password=' for PostgreSQL.
DBDParams "host=127.0.0.1 port=3306 dbname=vmail user=vmail pass=xxxxxx"

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

    AuthType Basic
    AuthName "Authentication required"
    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE username = %s AND isglobaladmin=1 LIMIT 1"

    Require valid-user
</Directory>

Relevant from /var/log/access.log
<my IP> - - [20/Apr/2016:16:27:47 -0600] "GET /awstats HTTP/1.1" 404 3766 "-" "Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"

Relevant from /var/log/error.log
[Wed Apr 20 16:29:21.984716 2016] [auth_basic:error] [pid 2104] [client <my IP>:62478] AH01617: user postmaster@example.com: authentication failure for "/awstats": Password Mismatch