1 (edited by mrbasic 2016-02-05 18:37:32)

Topic: Can't acces Awstats. credentials not accepted.

==== Required information ====
- iRedMail version (check /etc/iredmail-release): Iredmail version: 0.9.4
- Linux/BSD distribution name and version: Debian 8.3 x64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Web server (Apache or Nginx):Apache
- Manage mail accounts with iRedAdmin-Pro? NO
- Related log if you're reporting an issue:
====

Apache error log when i try to access awstats:
[Fri Feb 05 14:27:46.867628 2016] [auth_basic:error] [pid 7022] [client 1.1.1.1:8968] AH01617: user postmaster@domain.com: authentication failure for "/awstats": Password Mismatch

access.log: postmaster@domain.com [05/Feb/2016:14:29:51 +0400] "GET /awstats HTTP/1.1" 401 957 "-" "Mozilla/5.0 (Windows NT 6.3; WOW64; rv:43.0) Gecko/20100101 Firefox/43.0"

awstats.conf in apache2:

DBDriver mysql
# Important note: use 'pass=' for MySQL, 'password=' for PostgreSQL.
DBDParams "host=127.0.0.1 port=3306 dbname=vmail user=vmail pass=PASSWORD"

<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>


I don't know where to search for problem.
sad

UPD: The installation made on Fresh system.

----

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

2

Re: Can't acces Awstats. credentials not accepted.

iRedMail uses SSHA512 password hash by default, but Apache doesn't support it, you have to reset your admin password to MD5 hash instead.

3

Re: Can't acces Awstats. credentials not accepted.

Thank you for your response.
How do i do this?

4

Re: Can't acces Awstats. credentials not accepted.

Tutorial: http://www.iredmail.org/docs/reset.user.password.html

You can find more tutorials here: http://www.iredmail.org/docs/

5

Re: Can't acces Awstats. credentials not accepted.

Where should i put MD5 Salt??
Please. I can't understand...

6

Re: Can't acces Awstats. credentials not accepted.

I suggest you read our tutorial first:
http://www.iredmail.org/docs/reset.user.password.html

7

Re: Can't acces Awstats. credentials not accepted.

Thank you. Created MD5 for my password. added {CRYPT} to beginning. IN mysql, did command to change password for my postmaster. STILL can't access AWSTATS..

8

Re: Can't acces Awstats. credentials not accepted.

Try without '{CRYPT}' prefix.

9

Re: Can't acces Awstats. credentials not accepted.

THANK YOU!!!!.
It worked! Without {CRYPT} solved the problem.

Also, is there way to manage Antispam?

10

Re: Can't acces Awstats. credentials not accepted.

mrbasic wrote:

Also, is there way to manage Antispam?

I suggest you create a new forum topic for this new question, and please clearly explain what "antispam" problem you want to solve.