1 Topic by neliasen

  • neliasen
  • Member
  • Offline
  • Registered: 2009-08-01
  • Posts: 13

Topic: awstats and MySQL setup?

hi guys
Using iRedMail ... I wondered that I might as well put the various components to other use as well...
in particular awstats...
but I am a bit dumbfounded by the awstats.conf... as I cannot find the the table "admin" .... nor the script for creating this table...
from the awstats.conf:

    AuthName "Authorization Required"
    AuthType Basic
    AuthMYSQL on
    AuthBasicAuthoritative Off
    AuthUserFile /dev/null
    # Database related.
    AuthMySQL_Password_Table admin
    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

there is probably some step I have missed here...
how to recreate this? so I can use awstats for various virtual hosts as well ...

regards
niels

----

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

Re: awstats and MySQL setup?

It should be in database "vmail". Seems you misses database name in awstats.conf.

3 Reply by neliasen

  • neliasen
  • Member
  • Offline
  • Registered: 2009-08-01
  • Posts: 13

Re: awstats and MySQL setup?

ZhangHuangbin wrote:

It should be in database "vmail". Seems you misses database name in awstats.conf.

this is from the 0.5.1 release of iRedMail... no manual part was done ...

but ... generically speaking.. if I just want to recreate the "awstats" part... how to do so ?

4 Reply by ZhangHuangbin

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

Re: awstats and MySQL setup?

Reference:
http://iredmail.googlecode.com/hg/iRedMail/conf/awstats
http://iredmail.googlecode.com/hg/iRedM … awstats.sh

5 Reply by neliasen

  • neliasen
  • Member
  • Offline
  • Registered: 2009-08-01
  • Posts: 13

Re: awstats and MySQL setup?

ZhangHuangbin wrote:

Reference:
http://iredmail.googlecode.com/hg/iRedMail/conf/awstats
http://iredmail.googlecode.com/hg/iRedM … awstats.sh

Okay... what I can se from the awstats.sh(you mentioned above).. is that the "AuthMySQL_DB vmail" is missing..
should it not be part of the MySQl configuration part as well ?

6 Reply by ZhangHuangbin

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

Re: awstats and MySQL setup?

It must be part of mysql configuration.