[policyd-users] A Few Questions

2008-04-09 Thread Maple Thorpe
I have downloaded cluebringer-snapshot-200803151435 and followed
instructions in INSTALL.

There are files left like cbpadmin and cbpolicyd, where should
they be
placed? And, which file is use to start cluebringer in daemon
mode?

Is there a README?

===
Installing Policyd v2.


1. Setup MySQL  (or whichever database you plan to use)

a. In database/ run...
$ for i in  core.tsql access_control.tsql quotas.tsql
amavis.tsql
checkhelo.tsql checkspf.tsql
$ do 
$./convert-tsql mysql $i
$ done > policyd.mysql

b. Load policyd.mysql into MySQL


2. Adjust cbpolicyd.conf with your MySQL database details


3. Install the webui/*  into your apache directory, check out
includes/config.php  and adjust the MySQL server details.


4. Setup Postfix to use cbpolicyd...
Add the following Postfix config...
check_policy_service inet:127.0.0.1:10031
in BOTH  smtpd_recipient_restrictions and
smtpd_end_of_data_restrictions.


5. Copy your amavisd from /usr/sbin/amavisd and patch it with
contrib/amavisd-new-2.5.3_policyd-200802070918.patch like
this...
$ patch < contrib/amavisd-new-2.5.3_policyd-200802070918.patch
After this change your initscripts to start the patched amavisd.


6. Copy amavisd-policyd.pm where you see fit, and add this
configuration
line to your amavisd.conf file...
include_config_files('/path/to/amavisd-policyd.pm');

7. Edit the top of amavisd-policyd.pm and change ...
use lib('/root/cluebringer-trunk');  # to point to the directory
which
contains cbp/

my $DB_dsn = "DBI:SQLite:dbname=/tmp/cluebringer.sqlite";  # to
point to
your MySQL DB


7. Fire everything up and browse to the web gui to configure

=



-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
___
policyd-users mailing list
policyd-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/policyd-users


Re: [policyd-users] A Few Questions

2008-04-17 Thread Maple Thorpe

On Wed, 2008-04-09 at 20:01 -0400, Maple Thorpe wrote:
> I have downloaded cluebringer-snapshot-200803151435 and followed
> instructions in INSTALL.
> 
> There are files left like cbpadmin and cbpolicyd, where should
> they be
> placed? And, which file is use to start cluebringer in daemon
> mode?
> 
> Is there a README?
> 
> ===
> Installing Policyd v2.
> 
> 
> 1. Setup MySQL  (or whichever database you plan to use)
> 
> a. In database/ run...
> $ for i in  core.tsql access_control.tsql quotas.tsql
> amavis.tsql
> checkhelo.tsql checkspf.tsql
> $ do 
> $./convert-tsql mysql $i
> $ done > policyd.mysql
> 
> b. Load policyd.mysql into MySQL
> 
> 
> 2. Adjust cbpolicyd.conf with your MySQL database details
> 
> 
> 3. Install the webui/*  into your apache directory, check out
> includes/config.php  and adjust the MySQL server details.
> 
> 
> 4. Setup Postfix to use cbpolicyd...
> Add the following Postfix config...
> check_policy_service inet:127.0.0.1:10031
> in BOTH  smtpd_recipient_restrictions and
> smtpd_end_of_data_restrictions.
> 
> 
> 5. Copy your amavisd from /usr/sbin/amavisd and patch it with
> contrib/amavisd-new-2.5.3_policyd-200802070918.patch like
> this...
> $ patch < contrib/amavisd-new-2.5.3_policyd-200802070918.patch
> After this change your initscripts to start the patched amavisd.
> 
> 
> 6. Copy amavisd-policyd.pm where you see fit, and add this
> configuration
> line to your amavisd.conf file...
> include_config_files('/path/to/amavisd-policyd.pm');
> 
> 7. Edit the top of amavisd-policyd.pm and change ...
> use lib('/root/cluebringer-trunk');  # to point to the directory
> which
> contains cbp/
> 
> my $DB_dsn = "DBI:SQLite:dbname=/tmp/cluebringer.sqlite";  # to
> point to
> your MySQL DB
> 
> 
> 7. Fire everything up and browse to the web gui to configure
> 
> =
> 
> 
> 
> -
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> ___
> policyd-users mailing list
> policyd-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/policyd-users

Thanks for response.

On my Fedora 8 system, while working on the installation of cluebringer,
I revered back to policyd-1.82. postfix main.cf remains configured with
check policy statements described in the cluebringer INSTALL
instructions, i.e smtpd_recipient_restrictions and
smtpd_end_of_data_restrictions.

Noe Postfix is generating warnings and notices in the maillog:

warning: access table inet:IP.ADD.RE.SS:10031: action PREPEND must be
used before smtpd_end_of_data_restrictions

Apr 17 08:15:26 gobot postfix/smtpd[4640]: 894B6804E9: reject:
END-OF-MESSAGE from unknown[IP.ADD.RE.SS]: 450 4.7.1 :
End-of-data rejected: Policy Rejection- Invalid data;

IF these notices will disappear as soon as the configuration for
cluebringer is complete, I'm OK, otherwise, I need help to understand
the reason for these notices.

On to cluebringer installation. As I crosswalk the configurations of
policyd v1 to cluebringer, I believe that all files are installed
correctly. 

The exception is, what is the replacement for the policyd v1 daemon that
is used at system startup. i.e. /etc/init.d/policyd:

# Init file for Policy Daemon
#
# chkconfig: - 70 25
# description: Postfix Policy Daemon
#
# processname: policyd

# source function library
. /etc/rc.d/init.d/functions

RETVAL=0
PROG="/usr/local/policyd/policyd"
CONF="/usr/local/policyd/policyd.conf"

[ -f $PROG ] || exit 0
[ -f $CONF ] || exit 0

start()
{
echo -n $"Starting $PROG:"
daemon "$PROG -c $CONF"
RETVAL=$?
[ "$RETVAL" = 0 ] && touch /var/lock/subsys/policyd
echo
}

In other words, what are the cluebringer substitutions, if any, for the

[policyd-users] Where is IniFiles.pm?

2008-04-17 Thread Maple Thorpe
I using Fedora Core 8 and downloaded cluebringer-snapshot-200803151435].
Where is IniFiles.pm?

perl /usr/local/bin/cbpolicyd 
Can't locate Config/IniFiles.pm in @INC (@INC
contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 
/usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 
/usr/lib/perl5/site_perl 
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 
/usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 
/usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi 
/usr/lib/perl5/5.8.8 .) at /usr/local/bin/cbpolicyd line 29.
BEGIN failed--compilation aborted at /usr/local/bin/cbpolicyd line 29.



-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
___
policyd-users mailing list
policyd-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/policyd-users


Re: [policyd-users] Where is IniFiles.pm?

2008-04-17 Thread Maple Thorpe
If you would be so kind as to resubmit your response. It appears as an
attachment and not visible from the web interface, nor did it arrive via
email.

All I see is:

Re: [policyd-users] Where is IniFiles.pm?
From: Jacco van Koll <[EMAIL PROTECTED]> - 2008-04-17 21:34 
Attachments: HTML-Email.html 

Clicking on the attachment response is: "File not found on server".



-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
___
policyd-users mailing list
policyd-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/policyd-users


Re: [policyd-users] Where is IniFiles.pm?

2008-04-18 Thread Maple Thorpe

On Thu, 2008-04-17 at 23:34 +0200, Jacco van Koll wrote:
> Maple,
> 
> This should be included in your Perl installation :-) So, download it
> from your fedora repository and install. Else, use CPAN.
> 
> On 17-04-08 22:00, Maple Thorpe wrote: 
> > I using Fedora Core 8 and downloaded cluebringer-snapshot-200803151435].
> > Where is IniFiles.pm?
> > 
> > perl /usr/local/bin/cbpolicyd 
> > Can't locate Config/IniFiles.pm in @INC (@INC
> > contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi 
> > /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi 
> > /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi 
> > /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi 
> > /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 
> > /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 
> > /usr/lib/perl5/site_perl 
> > /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi 
> > /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi 
> > /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi 
> > /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi 
> > /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 
> > /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 
> > /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi 
> > /usr/lib/perl5/5.8.8 .) at /usr/local/bin/cbpolicyd line 29.
> > BEGIN failed--compilation aborted at /usr/local/bin/cbpolicyd line 29.
> > 
> > 
> > 
> > -
> > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> > Don't miss this year's exciting event. There's still time to save $100. 
> > Use priority code J8TL2D2. 
> > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> > ___
> > policyd-users mailing list
> > policyd-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/policyd-users
> >   
> 
> -- 
> Regards,
> 
> Jacco van Koll
> 
> [EMAIL PROTECTED]
> 
> -
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Don't miss this year's exciting event. There's still time to save $100. 
> Use priority code J8TL2D2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> ___ policyd-users mailing list 
> policyd-users@lists.sourceforge.net 
> https://lists.sourceforge.net/lists/listinfo/policyd-users

Hopefully, I am near a successful installation.

Cluebringer and missing perl modules are installed

Remaining complaints:
+++
Searched CPAN. Mail::SPF::qv unknown  
===
/var/log/cbpolicyd.log 
===
[2008/04/18-04:49:34 - 15742] Process Backgrounded
[2008/04/18-04:49:34 - 15742] Initializing system modules.
[2008/04/18-04:49:34 - 15742] System modules initialized.
[2008/04/18-04:49:34 - 15742] Module load started...
[2008/04/18-04:49:34 - 15742]   => AccessControl: enabled
[2008/04/18-04:49:34 - 15742]   => CheckHelo: enabled
[2008/04/18-04:49:34 - 15742] WARNING: Error loading plugin
modules/CheckSPF (Undefined subroutine &Mail::SPF::qv called
at /usr/lib/perl5
/site_perl/5.8.8/Mail/SPF.pm line 24.
Compilation failed in require at cbp/modules/CheckSPF.pm line 29.
BEGIN failed--compilation aborted at cbp/modules/CheckSPF.pm line 29.
Compilation failed in require at (eval 15) line 2.
BEGIN failed--compilation aborted at (eval 15) line 2.

NOTE:
cpan -i Mail::SPF
CPAN: File::HomeDir loaded ok (v0.69)
CPAN: Storable loaded ok (v2.18)
Going to read /root/.cpan/Metadata
  Database was generated on Fri, 18 Apr 2008 05:29:51 GMT
Mail::SPF is up to date (v2.005).

+++
Patched Amavisd produces:
===
/var/log/maillog (snippet)
===
Apr 18 07:27:59 brey amavis[16084]: (16084-09) (!)custom new err:
Undefined subroutine &cbp::dblayer::DBConnect called
at /usr/local/include//amavisd-policyd.pm line 115,  line 1086.
Apr 18 07:28:06 brey amavis[16084]: (16084-09) (!)SA failed: Can't
locate object method "get_tag" via package
"Mail::SpamAssassin::PerMsgStatus" at (eval 87) line 410. at (eval 87)
line 432.

NOTE:
cpan -i Mai

Re: [policyd-users] Where is IniFiles.pm?

2008-04-19 Thread Maple Thorpe
Thanks for responses. Ready to update as soon as its available.

On Sat, 2008-04-19 at 05:16 +, Nigel Kukard wrote:
> 
> > > This should be included in your Perl installation :-) So, download it
> > > from your fedora repository and install. Else, use CPAN.
> > > 
> > > On 17-04-08 22:00, Maple Thorpe wrote: 
> > > > I using Fedora Core 8 and downloaded cluebringer-snapshot-200803151435].
> > > > Where is IniFiles.pm?
> > > > 
> > > > perl /usr/local/bin/cbpolicyd 
> > > > Can't locate Config/IniFiles.pm in @INC (@INC
> > > > contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi 
> > > > /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi 
> > > > /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi 
> > > > /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi 
> > > > /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 
> > > > /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 
> > > > /usr/lib/perl5/site_perl 
> > > > /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi 
> > > > /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi 
> > > > /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi 
> > > > /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi 
> > > > /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7 
> > > > /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 
> > > > /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi 
> > > > /usr/lib/perl5/5.8.8 .) at /usr/local/bin/cbpolicyd line 29.
> > > > BEGIN failed--compilation aborted at /usr/local/bin/cbpolicyd line 29.
> 
> > Hopefully, I am near a successful installation.
> > 
> > Cluebringer and missing perl modules are installed
> > 
> > Remaining complaints:
> > +++
> > Searched CPAN. Mail::SPF::qv unknown  
> > ===
> > /var/log/cbpolicyd.log 
> > ===
> > [2008/04/18-04:49:34 - 15742] Process Backgrounded
> > [2008/04/18-04:49:34 - 15742] Initializing system modules.
> > [2008/04/18-04:49:34 - 15742] System modules initialized.
> > [2008/04/18-04:49:34 - 15742] Module load started...
> > [2008/04/18-04:49:34 - 15742]   => AccessControl: enabled
> > [2008/04/18-04:49:34 - 15742]   => CheckHelo: enabled
> > [2008/04/18-04:49:34 - 15742] WARNING: Error loading plugin
> > modules/CheckSPF (Undefined subroutine &Mail::SPF::qv called
> > at /usr/lib/perl5
> > /site_perl/5.8.8/Mail/SPF.pm line 24.
> > Compilation failed in require at cbp/modules/CheckSPF.pm line 29.
> > BEGIN failed--compilation aborted at cbp/modules/CheckSPF.pm line 29.
> > Compilation failed in require at (eval 15) line 2.
> > BEGIN failed--compilation aborted at (eval 15) line 2.
> > 
> > NOTE:
> > cpan -i Mail::SPF
> > CPAN: File::HomeDir loaded ok (v0.69)
> > CPAN: Storable loaded ok (v2.18)
> > Going to read /root/.cpan/Metadata
> >   Database was generated on Fri, 18 Apr 2008 05:29:51 GMT
> > Mail::SPF is up to date (v2.005).
> 
> You don't need to load the CheckSPF module in the config file if you
> don't want SPF support.
> 
> Can you try latest SVN checkout of cluebringer?
> 
> > +++
> > Patched Amavisd produces:
> > ===
> > /var/log/maillog (snippet)
> > ===
> > Apr 18 07:27:59 brey amavis[16084]: (16084-09) (!)custom new err:
> > Undefined subroutine &cbp::dblayer::DBConnect called
> > at /usr/local/include//amavisd-policyd.pm line 115,  line 1086.
> > Apr 18 07:28:06 brey amavis[16084]: (16084-09) (!)SA failed: Can't
> > locate object method "get_tag" via package
> > "Mail::SpamAssassin::PerMsgStatus" at (eval 87) line 410. at (eval 87)
> > line 432.
> > 
> > NOTE:
> > cpan -i Mail::SpamAssassin::PerMsgStatus
> > CPAN: File::HomeDir loaded ok (v0.69)
> > CPAN: Storable loaded ok (v2.18)
> > Going to read /root/.cpan/Metadata
> >   Database was generated on Fri, 18 Apr 2008 05:29:51 GMT
> > Mail::SpamAssassin::PerMsgStatus is up to date (undef).
> > ==