Sunday, January 13, 2008

SongketMail at SourceForge.net Project Approved Email

Subject: SourceForge.net Project Approved

Your project registration for SourceForge.net has been approved.


Project Information:

Project Descriptive Name: songketmail
Project Unix Name: songketmail
CVS Server: songketmail.cvs.sourceforge.net
Shell Server: shell.sourceforge.net
Web Server: songketmail.sourceforge.net


Project Administration:

The Project Admin page for your project may be accessed at
https://sourceforge.net/project/admin/?group_id=213253
after logging-in.


Service Availability for New Projects:

The DNS for your project web site may take up to 24 hours to become
active. Until DNS is active for your project, attempts to access
your project web site will result in 404 errors. Once DNS is active,
you will see an empty directory index when accessing your project
web site, until you have placed content in your project web space
(remember: project web space is provided solely for use in storing
project-related information; see the Web section of the Project Admin
page for additional details).

Your access to the project shell and CVS servers (including your
new CVS repository, which has already been initialized and is ready
for your first import) are typically available within four hours
from the time when your project was approved. If after 6 hours
your shell/CVS accounts still do not work, please submit a Support
Request (on the "alexandria" project, see below), so as that we may
look in to the problem.


Site Documentation and Support:

SourceForge.net maintains a large amount of documentation about
the SourceForge.net site and services offered to hosted projects.
This documentation may be accessed using the "Site Docs" link in the
left navbar, or directly at: https://sourceforge.net/docman/?group_id=1

Should you need to contact the SourceForge.net team, we may be reached
by submitting a Support Request at:
https://sourceforge.net/tracker/?func=add&group_id=1&atid=200001


Reminder: Acceptable Use and Project Licensing:

By using the SourceForge.net site, you agree to be bound by the terms
and conditions of the SourceForge.net Terms of Use Agreement.

SourceForge.net provides hosting solely for Open Source software
development projects; if your project is not being released under an
Open Source license, or is not developing software, please contact
the SourceForge.net team immediately for assistance. Questions
regarding acceptable use of the SourceForge.net site and resources
should be directed to the SourceForge.net team by submitting a
Support Request (see above).


Donation System:

SourceForge.net provides a donation system that allows users and
projects to accept donations on an opt-in basis.

You may opt-in your user account to receive donations at:
https://sourceforge.net/my/donate_manage.php

You may opt-in this project to receive donations at:
https://sourceforge.net/project/admin/donations.php?group_id=213253

Documentation on the donation system may be found at:
https://sourceforge.net/docman/display_doc.php?docid=20244&group_id=1


Getting Started:

A significant amount of project service information may be found
on the Project Admin pages for your project, as seen at:
https://sourceforge.net/project/admin/?group_id=213253

The Project Admin page for your project is the best place to start.
Please ensure that you have established a suitable Public Description
for your project, and have categorized your project within the Trove;
both of these operations may be performed using the "Public Info"
section of your Project Admin pages.


Enjoy the system, and please tell others about SourceForge.net. Let us know
if there is anything we can do to help you (we can always be reached
by submitting a Support Request on the "alexandria" project (see above)).

-- the SourceForge.net crew

SongketMail Version 1 Project Roadmap

SongketMail Version 1 Project Roadmap

http://songketmail.wiki.sourceforge.net/songketmail-roadmap
http://code.google.com/p/songketmail/wiki/SongketMailRoadmap

SongketMail Project is devided into two projects, SongketMail and SongketMailFilter.

SongketMail

An automation solution using RPM and YUM to configure and customization of Email server in Linux Operating System. This will help in minimize the numbers of steps needed to configure an email system in Linux enviroment.

Softwares in Open Source that have been identified to be used with SongketMail

CentOS 5 http://www.centos.org/
- The Operating system

Postfix http://www.postfix.org/
- For SMTP

Dbmail http://www.dbmail.org/
- For email storage and POP3/IMAP4 server

MySQL http://www.mysql.org/
- For database solution

Horde IMP http://www.horde.org/
- For WebMail

Apache http://httpd.apache.org/
- For web server

SongketMail Version 1 by June 2008

SongketMailFilter

An automation solution using RPM and YUM to configure and customization of spam and anti virus filtering system in Linux Operating System. SongketMailFilter combine with SongketMail will create a total Email server solution from SongketMail Project.

Spamassassin Using Bayesian MySQL http://spamassassin.apache.org/
- Spam identify program

MailScanner http://www.mailscanner.info/
- Anti-virus and anti-spam filter

MailWatch http://mailwatch.sourceforge.net/
- Web Interface for MailScanner

Clamav http://www.clamav.net/
- Anti virus program

SongketMailFilter Version 1 by March 2008

Tasks summary can be view at
http://sourceforge.net/pm/?group_id=213253

Saturday, January 12, 2008

Bayesian SpamAssassin MySQL SPEC RPM

Bayesian SpamAssassin MySQL SPEC RPM

Internet links :

http://songketmail.wiki.sourceforge.net/bayesian-mysql
http://code.google.com/p/songketmail/wiki/BayesianMySql

This documentation need to refer to files residing in BayesianMySql at
SongketMail Project Wiki. This RPM will configure Spamassassin to used
Bayesian with MySql. This document refer to bayesian-mysql version
0.0.1. This version is tested using MySql 5.0.22 and spamassassin 3.1.9.

SPEC RPM can be found here
http://songketmail.wiki.sourceforge.net/bayesmysql-specrpm
http://code.google.com/p/songketmail/wiki/BayesianMySqlCode

Source to be used with SPEC RPM
http://sourceforge.net/project/showfiles.php?group_id=213253&package_id=257222
http://code.google.com/p/songketmail/downloads/list

Building RPM
http://www.rpm.org/RPM-HOWTO/build.html

Simple steps

(1) Copy the tar.bz2 file to /usr/src/redhat/SOURCE
(2) Copy the above spec file to /usr/src/redhat/SPEC and name it
bayesian-mysql.spec
(3) Run rpmbuild -bb /usr/src/redhat/SPEC/bayesian-mysql.spec


You need to install development packages and rpmbuild to build RPM.

This installation is using CentOS 5 as the main Linux Operating
System. Your installation may be different with Red Hat and Fedora.
Opensuse may vary need to get the right RPM name for the packages.

(1) Install Packages needed as per CentOS 5.

spamassassin, mysql, mysql-server, perl-DBI, perl-DBD-MySQL,
perl-Net-Daemon, perl-libwww-perl

or by yum

yum install spamassassin mysql mysql-server perl-DBI perl-DBD-MySQL
perl-Net-Daemon perl-libwww-perl

(2) Start the Mysql Server and create database name bayesianmysql
(login as root)

mysqladmin create bayesianmysql

Assign the user

GRANT ALL ON bayesianmysql.* to bayesianmysql@localhost identified by
'yourpassword1234';

Change the password yourpassword1234 to your own.

(3) Create the tables needed by the database.

http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadme
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeAwl

or load the SQL file used by Bayesianmysql SPEC RPM

http://code.google.com/p/songketmail/wiki/BayesianMySqlSkeletonTables
http://songketmail.wiki.sourceforge.net/bayesianmysql-sql

mysql -p -u bayesianmysql bayesianmysql < nameofsqlfile.sql

(4) Copy 2 spamassassin cf files to /etc/mail/spamassassin

Get the file name bayesian-mysql.cf

http://songketmail.wiki.sourceforge.net/bayesian-mysql.cf
http://code.google.com/p/songketmail/wiki/BayesianMySqlCf

and file name bayesian-mysql-mysql.cf

http://code.google.com/p/songketmail/wiki/BayesianMysqlSpamassassinCf
http://songketmail.wiki.sourceforge.net/bayesian-mysql-mysql.cf

Remember to change password as per your site or item 2.

(5) You need at least to trained spamassassin one ham and spam email
using sa-learn.

Spamassassin Public Corpus can be used if you don't have any examples.

http://spamassassin.apache.org/publiccorpus/
http://spamassassin.apache.org/publiccorpus/readme.html

The command :-

http://spamassassin.apache.org/full/3.1.x/dist/doc/sa-learn.html

sa-learn --ham hamemail.txt
sa-learn --spam spamemail.txt

(6) Finishing the setup

Sync the dataset

sa-learn --sync --force-expire

Update the rules

sa-updates

Run the LINT test

spamassassin --lint -D

Watch the debug output from spamd and look for the following debug
line:

debug: bayes: Database connection established
debug: bayes: Using username:

Forum and discussion

http://sourceforge.net/forum/?group_id=213253
http://groups.google.com/group/songketmail

Blog

http://songketmail.harisfazillah.info/


Harisfazillah Jamel for SongketMail
version 1.0
12 Jan 2008

http://songketmail.wiki.sourceforge.net/bayesian-mysql-guide
http://code.google.com/p/songketmail/wiki/BayesianMysqlGuide

SongketMail Project Website

http://www.songketmail.org/

My Blog List