1 Topic by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Topic: Unable to login to awstats.

Dear members !

I am unable to login to awstats. Is there any way to find out the problem ? or change the credentials ?

Thanks in Advance
Waseem


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

----

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

Re: Unable to login to awstats.

*) Did you login as global admin?
*) Show us your /etc/httpd/conf.d/awstats.conf here. Please remove password before pasting.

3 Reply by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Re: Unable to login to awstats.

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

# Note: Please refer to /etc/httpd/conf.d/ssl.conf for SSL/TLS setting.
#Alias /awstats/icon "/var/www/awstats/icon/"
#Alias /awstats/css "/var/www/awstats/css/"
#Alias /awstats/js "/var/www/awstats/js/"
#ScriptAlias /awstats "/var/www/awstats/"

<Directory /var/www/awstats/>
    DirectoryIndex awstats.pl
    Options ExecCGI
    Order allow,deny
    allow from all
    #allow from 127.0.0.1

    AuthName "Authorization Required"
    AuthType Basic

    AuthMYSQLEnable On
    AuthMySQLHost 127.0.0.1
    AuthMySQLPort 3306
    AuthMySQLUser vmail
    AuthMySQLPassword ##################REMOVED############
    AuthMySQLDB vmail
    AuthMySQLUserTable mailbox
    AuthMySQLNameField username
    AuthMySQLPasswordField password
    AuthMySQLUserCondition "isadmin=1 AND isglobaladmin=1"

    Require valid-user
</Directory>
~
There you go.

4 Reply by ZhangHuangbin

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

Re: Unable to login to awstats.

*) Do you have columns "isadmin" and "isglobaladmin" in MySQL table "vmail.mailbox"?
*) Did you login with correct username and password?

5 Reply by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Re: Unable to login to awstats.

Yes i have these both columns in database table and value for postmaster@.. (default user) is 1 for both.

I am using correct password and username. but still unable to login.

ZhangHuangbin wrote:

*) Do you have columns "isadmin" and "isglobaladmin" in MySQL table "vmail.mailbox"?
*) Did you login with correct username and password?

6 Reply by ZhangHuangbin

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

Re: Unable to login to awstats.

*) No idea yet, sorry. It should work with correct username and password.
*) What's the error message in Apache log file (/var/log/httpd/ssl_error_log)?
*) Did you try to create another global admin account and login with it? The URL is httpS://[your_server/awstats/

7 Reply by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Re: Unable to login to awstats.

There are my logs for ssl_error_log. i guess password incorrect, but i havnt change password ! and every thing else is going smooth.
will changing the password effect other things ? if yes which ?

Thanks
Best Regards,

[Wed Mar 13 07:20:23 2013] [error] [client 125.209.116.158] MySQL ERROR: Access denied for user 'vmail'@'localhost' (using password: YES)
[Wed Mar 13 07:20:23 2013] [error] [client 125.209.116.158] MySQL user postmaster not found: /awstats


ZhangHuangbin wrote:

*) No idea yet, sorry. It should work with correct username and password.
*) What's the error message in Apache log file (/var/log/httpd/ssl_error_log)?
*) Did you try to create another global admin account and login with it? The URL is httpS://[your_server/awstats/

8 Reply by ZhangHuangbin

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

Re: Unable to login to awstats.

whmemon wrote:

[Wed Mar 13 07:20:23 2013] [error] [client 125.209.116.158] MySQL ERROR: Access denied for user 'vmail'@'localhost' (using password: YES)

Please paste related log (lines above it) to help identify the source file, not just this line.

9 Reply by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Re: Unable to login to awstats.

There is nothing above it, I have removed log file and tried to login and got this error in file.

ZhangHuangbin wrote:
whmemon wrote:

[Wed Mar 13 07:20:23 2013] [error] [client 125.209.116.158] MySQL ERROR: Access denied for user 'vmail'@'localhost' (using password: YES)

Please paste related log (lines above it) to help identify the source file, not just this line.

10 Reply by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Re: Unable to login to awstats.

Is that possible that is error comes due to certificate error ?
Please see bellow
[Wed Mar 13 10:10:26 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Mar 13 10:10:26 2013] [warn] RSA server certificate CommonName (CN) `localhost.localdomain' does NOT match server name!?
[Wed Mar 13 10:10:26 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Wed Mar 13 10:10:26 2013] [warn] RSA server certificate CommonName (CN) `localhost.localdomain' does NOT match server name!?
[Wed Mar 13 10:10:51 2013] [error] [client 125.209.116.158] MySQL ERROR: Access denied for user 'vmail'@'localhost' (using password: YES)
[Wed Mar 13 10:10:51 2013] [error] [client 125.209.116.158] MySQL user postmaster@shc.gov.pk not found: /awstats

if so, then how to overcome this error ?

ZhangHuangbin wrote:

*) No idea yet, sorry. It should work with correct username and password.
*) What's the error message in Apache log file (/var/log/httpd/ssl_error_log)?
*) Did you try to create another global admin account and login with it? The URL is httpS://[your_server/awstats/

11 Reply by ZhangHuangbin

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

Re: Unable to login to awstats.

Are MySQL username and password correct in /etc/httpd/conf.d/awstats.conf?

AuthMySQLUser vmail
    AuthMySQLPassword ##################REMOVED############

12 Reply by whmemon

  • whmemon
  • Member
  • Offline
  • Registered: 2013-02-14
  • Posts: 30

Re: Unable to login to awstats.

yes, it changed in this forum, other wise intact every where else.

ZhangHuangbin wrote:

Are MySQL username and password correct in /etc/httpd/conf.d/awstats.conf?

AuthMySQLUser vmail
    AuthMySQLPassword ##################REMOVED############