1 Topic by glacierdigital

  • glacierdigital
  • glacierdigital
  • Member
  • Offline
  • From: Canada
  • Registered: 2011-01-26
  • Posts: 33

Topic: Cluebringer or AWStats not working. "No requires line available"

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

[:error] [pid ####] No requires line available

I was wondering if there was a concisely documented fix to this issue or a planned release that corrects the problem coming out shortly?

This is broken straight from a fresh install.

Thank you in advance.

----

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: 30,770

Re: Cluebringer or AWStats not working. "No requires line available"

Try this solution (libaprutil1-dbd-*):
http://www.iredmail.org/forum/post30290.html#p30290

According to this UNOFFICIAL document, looks like Apache-2.4 doesn't support for mod_auth_mysql:
http://iosnow.net/?p=21

3 Reply by glacierdigital

  • glacierdigital
  • glacierdigital
  • Member
  • Offline
  • From: Canada
  • Registered: 2011-01-26
  • Posts: 33

Re: Cluebringer or AWStats not working. "No requires line available"

Thank you Zhang.

4 Reply by glacierdigital

  • glacierdigital
  • glacierdigital
  • Member
  • Offline
  • From: Canada
  • Registered: 2011-01-26
  • Posts: 33

Re: Cluebringer or AWStats not working. "No requires line available"

Hi Zhang,

This is my zawstats.conf

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

    DBDriver mysql
    DBDParams "host=127.0.0.1 port=3306 dbname=vmail user=vmail pass=xxxxxxxxxxxxxxxxxxxxxx"
    DBDMin  4
    DBDKeep 8
    DBDMax  20
    DBDExptime 300



<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"
    ## Order allow,deny
    ## Allow from all
    ## Require valid-user

    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE username=%s"
    Require valid-user


</Directory>

"No requires line available" remains.

Not sure what I missed...

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Cluebringer or AWStats not working. "No requires line available"

This works for me:

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

DBDMin  4
DBDKeep 8
DBDMax  20
DBDExptime 300

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

    AuthName "Authorization Required"
    AuthType Basic
    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE username=%s AND isglobaladmin=1 LIMIT 1"
    Order allow,deny
    Allow from all
    Require valid-user
</Directory>