#
# Server configuration
#
[server]

# Protocols to load
protocols=<<EOT
Postfix
Bizanga
EOT

# Modules to load
modules=<<EOT
Core
AccessControl
CheckHelo
CheckSPF
Greylisting
Quotas
EOT

# User to run this daemon as
user=cluebringer
group=cluebringer

# Filename to store pid of parent process
pid_file=/var/run/cluebringer/cbpolicyd.pid

# Uncommenting the below option will prevent cbpolicyd going into the background
#background=no

# Preforking configuration
#
# min_server        - Minimum servers to keep around
# min_spare_servers    - Minimum spare servers to keep around ready to 
#               handle requests
# max_spare_servers    - Maximum spare servers to have around doing nothing
# max_servers        - Maximum servers alltogether
# max_requests        - Maximum number of requests each child will serve
#
# One may want to use the following as a rough guideline...
# Small mailserver:  2, 2, 4, 10, 1000
# Medium mailserver: 4, 4, 12, 25, 1000
# Large mailserver: 8, 8, 16, 64, 1000
#
#min_servers=4
#min_spare_servers=4
#max_spare_servers=12
#max_servers=25
#max_requests=1000



# Log level:
# 0 - Errors only
# 1 - Warnings and errors
# 2 - Notices, warnings, errors
# 3 - Info, notices, warnings, errors
# 4 - Debugging 
log_level=0

# File to log to instead of stdout
log_file=/var/log/cbpolicyd.log

# Log destination for mail logs...
# main        - Default. Log to policyd's main log mechanism, accepts NO args
# syslog    - log mail via syslog
#            format: log_mail=facility@method,args
#
# Valid methods for syslog:
# native    - Let Sys::Syslog decide
# unix        - Unix socket
# udp        - UDP socket
# stream    - Stream (for Solaris)
#
# Example: unix native
#log_mail=mail@syslog:native
#
# Example: unix socket 
#log_mail=mail@syslog:unix
#
# Example: udp
#log_mail=mail@syslog:udp,127.0.0.1
#
# Example: Solaris 
#log_mail=local0@syslog:stream,/dev/log
#log_mail=maillog
log_mail=mail@syslog:native

# Things to log in extreme detail
# modules     - Log detailed module running information
# tracking     - Log detailed tracking information
# policies     - Log policy resolution
# protocols     - Log general protocol info, but detailed
# bizanga     - Log the bizanga protocol
#
# There is no default for this configuration option. Options can be
# separated by commas. ie. protocols,modules
#
#log_detail=

# IP to listen on, * for all
host=127.0.0.1
host=127.0.0.1

# Port to run on
port=10031

# Timeout in communication with clients
#timeout=120

# cidr_allow/cidr_deny
# Comma, whitespace or semi-colon separated. Contains a CIDR block to 
# compare the clients IP to.  If cidr_allow or cidr_deny options are 
# given, the incoming client must match a cidr_allow and not match a 
# cidr_deny or the client connection will be closed.
#cidr_allow=0.0.0.0/0
#cidr_deny=



[database]
#DSN=DBI:SQLite:dbname=policyd.sqlite
DSN=DBI:mysql:host=127.0.0.1;database=cluebringer;user=cluebringer;password=4H9gZJDk07Q3ZN3eMJMlJ0cZQBMYKV
#DSN=DBI:Pg:database=policyd;host=localhost
#DSN=DBI:_DBC_DBTYPE_:dbname=_DBC_DBNAME_;host=_DBC_DBSERVER_
## Debian
# DB_Type can be one of - pgsql, mysql or sqlite3
# DB_Host is ignored for sqlite3. For pgsql and mysql it should be left 
#         unset or as 'localhost' if you wish to use unix sockets to communicate
#         with the database. To use TCP/IP to connect to a local database set 
#         '127.0.0.1' as the value. Otherwise use the hostname or IP address of 
#         the database server.
# DB_Port is ignored for sqlite3. For pgsql it will default to '5432' and 
#         for mysql the default is '3306'. If you are running your database server
#         on a non-standard port you should set it's value here.
# DB_Name defaults to '/var/lib/cluebringer/cluebringer.db' for sqlite3, if you 
#         wish to use another file for the database set it's full path here and 
#         ensure that the cluebringer user can read and write not only the file
#         but the directory it lives in. For pgsql and mysql this will 
#         default to 'cluebringer', otherwise you should set the name of the 
#         database here.

DB_Type=mysql
DB_Host=127.0.0.1
DB_Port=3306
DB_Name=cluebringer
Username=cluebringer
Password=4H9gZJDk07Q3ZN3eMJMlJ0cZQBMYKV


# What do we do when we have a database connection problem
# tempfail    - Return temporary failure
# pass        - Return success
bypass_mode=pass

# How many seconds before we retry a DB connection
bypass_timeout=10



# Access Control module
[AccessControl]
enable=1


# Greylisting module
[Greylisting]
enable=1


# CheckHelo module
[CheckHelo]
enable=1


# CheckSPF module
[CheckSPF]
enable=1


# Quotas module
[Quotas]
enable=1

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

#
# SECURITY WARNING:
#
# Since libapache2-mod-auth-mysql doesn't support advance SQL query, both
# global admins and normal domain admins are able to login to this webui.

# Note: Please refer to /etc/apache2/sites-available/default-ssl.conf for SSL/TLS setting.

<Directory /usr/share/postfix-cluebringer-webui/webui/>
    DirectoryIndex index.php
    AuthType basic
    AuthName "Authorization Required"
     ## Added next three to test   
#    AuthBasicProvider dbd
#    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE username=%s"
#    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
    Order allow,deny
    Allow from all
    Require valid-user
</Directory>

 The following NEW packages will be installed:                                   
  libaprutil1-dbd-mysql                                                         
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.                  
Need to get 12.2 kB of archives.                                                
After this operation, 75.8 kB of additional disk space will be used.            
Get:1 http://ap-southeast-2.ec2.archive.ubuntu.com/ubuntu/ trusty/universe libap
rutil1-dbd-mysql amd64 1.5.3-1 [12.2 kB]                                        
Fetched 12.2 kB in 0s (123 kB/s)                                                
Selecting previously unselected package libaprutil1-dbd-mysql:amd64.            
(Reading database ... 114355 files and directories currently installed.)        
Preparing to unpack .../libaprutil1-dbd-mysql_1.5.3-1_amd64.deb ...             
Unpacking libaprutil1-dbd-mysql:amd64 (1.5.3-1) ...                             
Setting up libaprutil1-dbd-mysql:amd64 (1.5.3-1) ...                            
root@VBoX:/root# 

 root@VBoX:/root# service apache2 restart                                        
 * Restarting web server apache2                                         [fail] 
 * The apache2 configtest failed.                                               
Output of config test was:                                                      
AH00526: Syntax error on line 47 of /etc/apache2/conf-enabled/zawstats.conf:    
Unknown Authn provider: dbd                                                     
Action 'configtest' failed.                                                     
The Apache error log may have more information.                                 
root@VBoX:/root#  

root@VBoX:/root# service apache2 restart                                        
 * Restarting web server apache2                                         [fail] 
 * The apache2 configtest failed.                                               
Output of config test was:                                                      
AH00526: Syntax error on line 47 of /etc/apache2/conf-enabled/zawstats.conf:    
Unknown Authn provider: dbd                                                     
Action 'configtest' failed.                                                     
The Apache error log may have more information.                                                                                              
root@VBoX:/root#                                

root@VBoX:/root# service apache2 restart                                        
 * Restarting web server apache2                                         [fail] 
 * The apache2 configtest failed.                                               
Output of config test was:                                                      
AH00526: Syntax error on line 46 of /etc/apache2/conf-enabled/zcluebringer.conf:
Unknown Authn provider: dbd                                                     
Action 'configtest' failed.                                                     
The Apache error log may have more information.                                 
root@VBoX:/root# 

 [Fri May 30 09:12:56.084113 2014] [mpm_prefork:notice] [pid 2099] AH00169: caught SIGTERM, shutting down 

 ## // Changes marked with advised by iRedEmail admin 30 May 2014 //
## Commented out marked by #/

# vim: syntax=apache ts=4 sw=4 sts=4 sr noet
# MySQL auth (libapache2-mod-auth-apache2). #/ DEPECIATED
# Global config of MySQL server, username, password.
#/Auth_MySQL_Info 127.0.0.1 vmail tAJRMLRoLjfyGe671q7W9HAUyoSkD3
#/Auth_MySQL_General_DB vmail

# MySQL auth (mod_dbd, libaprutil1-dbd-mysql).
<IfModule mod_dbd.c>
  DBDriver mysql
  DBDParams "host=127.0.0.1 dbname=vmail user=vmail pass=tAJRMLRoLjfyGe671q7W9HAUyoSkD3"
  DBDMin 1
  DBDKeep 8
  DBDMax 20
  DBDExptime 300
</IfModule>
#/ End add code 

 ## // Changes marked with advised by iRedEmail admin 30 May 2014 //
## Commented out marked by #/

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

    AuthName "Authorization Required"
    AuthType Basic
#/    ##############################
#/    # mod_auth_mysql (deprecated)#
#/    ##############################
#/    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"
#/
    #################
    # mod_authn_dbd #
    #################
    # Password related.
    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE mailbox.username=%s"
#/ End add in

    Order allow,deny
    Allow from all
    Require valid-user
</Directory> 

 <Directory /usr/share/postfix-cluebringer-webui/webui/>
    DirectoryIndex index.php
    AuthType basic
    AuthName "Authorization Required"

## // Changes marked with advised by iRedEmail admin 30 May 2014 //
## Commented out marked by #/
#/    ##############################
#/  # mod_auth_mysql (deprecated)#
#/    ##############################
#/
#/    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
#/
#/    #################
#/    # mod_authn_dbd #
#/    #################
#/    # Password related.
    AuthBasicProvider dbd
    AuthDBDUserPWQuery "SELECT password FROM mailbox WHERE mailbox.username=%s"
#/ End add code

    Order allow,deny
    Allow from all
    Require valid-user
</Directory>