Bayesian-MySql SPEC RPM

# http://code.google.com/p/songketmail/wiki/BayesianMySql
# Please don't copy directly from this blog entry. Visit the link above.
# This entry is for record purpose only. Missing entry detected.

Summary: Spamassassin Bayesian using Mysql
Name: bayesian-mysql
Version: 0.0.1
Release: 1
Source0: %{name}-%{version}.tar.bz2
License: GPL
Vendor: Harisfazillah Jamel and LinuxDotMy
Packager: Harisfazillah Jamel 
Group: Development/Tools
BuildArchitectures: noarch
BuildRoot: %{_tmppath}/%{name}-%{version}-root
Requires: spamassassin, mysql, mysql-server >= 4.1.3 , perl-DBI, perl-DBD-MySQL, perl-Net-Daemon, perl-libwww-perl

%description

This will installed Bayesian with Mysql for Spamassassin. Already with sa-learn dataset.
Bayesian and whitelist using mysql.

Part of this SPEC from
http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html

Harisfazillah Jamel
30 Dec 2007

For SongketMailFilter http://songketmail.harisfazillah.info/

linuxmalaysia @ gmail.com
linuxmalaysia @ harisfazillah.info

# Macro for generating an environment variable (%1) with %2 random characters
# from gforge RPM spec http://gforge.org/
%define randstr() %1=`perl -e 'for ($i = 0, $bit = "!", $key = ""; $i < %2; $i++) {while ($bit !~ /^[0-9A-Za-z]$/) { $bit = chr(rand(90) + 32); } $key .= $bit; $bit = "!"; } print "$key";'`  %prep  %setup  %build  %install  rm -rf %{buildroot}  # Make directory  install -d  %{buildroot}%{_sysconfdir}/bayesianmysql install -d -m0755  %{buildroot}/usr/share/spam-global install -d -m0755  %{buildroot}/usr/local/bin  # copy files  install -Dp -m0644 ham-melayu.txt %{buildroot}%{_sysconfdir}/bayesianmysql/ham-melayu.txt install -Dp -m0644 spam-melayu.txt %{buildroot}%{_sysconfdir}/bayesianmysql/spam-melayu.txt install -Dp -m0644 bayesian-mysql-mysql.sql %{buildroot}%{_sysconfdir}/bayesianmysql/bayesian-mysql-mysql.sql install -Dp -m0644 bayesian-mysql-mysql-basic.sql %{buildroot}%{_sysconfdir}/bayesianmysql/bayesian-mysql-mysql-basic.sql install -Dp -m0644 bayesian-mysql.cf %{buildroot}%{_sysconfdir}/mail/spamassassin/bayesian-mysql.cf install -Dp -m0644 bayesian-mysql-mysql.cf %{buildroot}%{_sysconfdir}/mail/spamassassin/bayesian-mysql-mysql.cf install -Dp -m0755 awlcleanup.sh  %{buildroot}/usr/local/bin/awlcleanup.sh  %clean rm -rf %{buildroot}  %post  #Need to create the database  if [ $1 -eq 1 ]; then    # Initial install.  Create and populate DB.     echo "Configuration Start. Please answer all the questions, if any."     service mysqld status | grep 'is running' >/dev/null 2>&1 || service mysqld start

  mysqladmin create bayesianmysql

if [ $? -eq 0 ]; then

  %randstr GFPASS 8

  #####echo "GRANT ALL ON bayesianmysql.* to bayesianmysql@localhost identified by '$GFPASS';" > /tmp/bayesianmysql-install-$$.tmp
echo "GRANT ALL ON bayesianmysql.* to bayesianmysql@localhost identified by 'kambing1234';" > /tmp/bayesianmysql-install-$$.tmp
echo "quit" >> /tmp/bayesianmysql-install-$$.tmp

  mysql bayesianmysql < /tmp/bayesianmysql-install-$$.tmp     echo "Loading Database named bayesianmysql. Please wait this make take a while."     mysql bayesianmysql < /etc/bayesianmysql/bayesian-mysql-mysql.sql  ###sed -i -e 's/\(^bayes_sql_password\W*=\)\(.*$\)/\1 '$GFPASS'/' %{buildroot}%{_sysconfdir}/mail/spamassassin/bayesian-mysql.cf  else  echo "Your bayesianmysql database is may already created or having error or creation or your upgrading your osccbayesian. You may change the password in the /etc/mail/spamassassin/bayesian-mysql.cf"  echo "This rpm assume the root@localhost for Mysql without any password" echo "If error occur and database bayesianmysql not created. Load it manual" echo " cd /etc/bayesianmysql mysql -p -u root <>
- version 0.0.1 for Centos RedHat Fedora
- fork oscc-bayesian version beta 0.0.2

Bayesian-MySql Version 0.0.1 For SongketMailFilter

The first release of Bayesian-Mysql to be used with Spamassassin version 3.x.x.

Bayesian-MySql will be used by SongketMailFilter.

RPM build on Centos 5. Tested on Centos 5 and Spamassassin version 3.1.9 with MySql 5.0.22. Perl version is 5.8.8.

Tarball to be used with this spec rpm can be download at

http://code.google.com/p/songketmail/downloads/list

Forum And Discussion Groups For SongketMail and SongketMailFilter

Dear friends,

Forum And Discussion Groups For SongketMail and SongketMailFilter.

You can used this forum to ask for support and to discuss for any bugs that you find in our products. Don't SPAM this lists or you will be block.

Thank you.

Forum
http://www.nabble.com/SongketMail-f29751.html

Yahoogroups
http://tech.groups.yahoo.com/group/songketmail/

SongketMail at Googlegroups
http://groups.google.com.my/group/songketmail

SongketMailFilter

SongketMailFilter is a combination of Open Source Softwares that related to email filtering. SongketMailFilter Suite will filter spam and scan all email for any viruses trojans and attacks against security vulnerabilities, and plays a major part in the security of a network.

SongketMailFilter used MailScanner as the main engine for scanning email. Together with well tune Spamassassin, it will help to minimize the number of spam email entering a organization network.

Open Source Software For SongketMailFilter

SongketMailFilter is a combination of Open Source Softwares that related to email filtering. SongketMailFilter Suite will filter spam and scan email for any virus and trojan.

SongketMailFilter used MailScanner as the main engine for scanning email. Together with well tune Spamassassin, it will help to minimize the number of spam email entering a organization network.

The list of software used as of December 2007.

===========================
Package Arch Version Repository Size
===========================

Installing:

SongketMailFilter

Installing for dependencies:

MailScanner-perl-MIME-Base64 i386 3.05-5 recompile 44 k
mailscanner noarch 4.64.3-2 recompile 687 k

Download source from http://www.mailscanner.info/ for RedHat. install it
and get the RPM from /usr/src/redhat/RPMS

apr i386 1.2.7-11 base 122 k
apr-util i386 1.2.7-6 base 75 k

clamav i386 0.91.2-1.el5.rf DAG 1.1 M
clamav-db i386 0.91.2-1.el5.rf DAG 10 M
clamd i386 0.91.2-1.el5.rf DAG 81 k
http://dag.wieers.com/rpm/packages/clamav/

gmp i386 4.1.4-10.el5 base 664 k
mysql i386 5.0.22-2.1.0.1 base 3.0 M
mysql-server i386 5.0.22-2.1.0.1 base 10 M
perl-Archive-Tar noarch 1.30-1.fc6 base 47 k

perl-Archive-Zip noarch 1.20-1.el5.rf DAG 100 k
http://dag.wieers.com/rpm/packages/perl-Archive-Zip/

perl-Compress-Zlib i386 1.42-1.fc6 base 52 k

perl-Convert-BinHex noarch 1.119-2.2.el5.rf DAG 34 k
http://dag.wieers.com/rpm/packages/perl-Convert-BinHex/

perl-Convert-TNEF noarch 0.17-3.2.el5.rf DAG 18 k
http://dag.wieers.com/rpm/packages/perl-Convert-TNEF/

perl-DBD-MySQL i386 3.0007-1.fc6 base 147 k

perl-DBD-SQLite i386 1.13-1.el5.rf DAG 50 k
http://dag.wieers.com/rpm/packages/perl-DBD-SQLite/

perl-DBI i386 1.52-1.fc6 base 605 k
perl-Digest-HMAC noarch 1.01-15 base 12 k
perl-Digest-SHA1 i386 2.11-1.2.1 base 48 k

perl-Error noarch 0.17008-2.el5.rf DAG 26 k
http://dag.wieers.com/rpm/packages/perl-Error/

perl-Filesys-Df i386 0.92-1.el5.rf DAG 35 k
http://dag.wieers.com/rpm/packages/perl-Filesys-Df/

perl-HTML-Parser i386 3.56-1 DAG 124 k
http://dag.wieers.com/rpm/packages/perl-HTML-Parser/

perl-HTML-Tagset noarch 3.10-2.1.1 base 15 k
perl-IO-Socket-INET6 noarch 2.51-2.fc6 base 13 k

perl-IO-Socket-SSL noarch 1.07-2.el5.rf DAG 43 k
http://dag.wieers.com/rpm/packages/perl-IO-Socket-SSL/

perl-IO-Zlib noarch 1.04-4.2.1 base 15 k

perl-IO-stringy noarch 2.110-1.2.el5.rf DAG 70 k
http://dag.wieers.com/rpm/packages/perl-IO-stringy/

perl-MIME-tools noarch 5.420-2.el5.rf DAG 276 k
http://dag.wieers.com/rpm/packages/perl-MIME-tools/

perl-Mail-SPF noarch 2.005-1.el5.rf DAG 142 k
http://dag.wieers.com/rpm/packages/perl-Mail-SPF/

perl-MailTools noarch 1.77-1.el5.rf DAG 85 k
http://dag.wieers.com/rpm/packages/perl-MailTools/

perl-Net-CIDR noarch 0.11-1.2.el5.rf DAG 15 k
http://dag.wieers.com/rpm/packages/perl-Net-CIDR/

perl-Net-DNS i386 0.61-1.el5.rf DAG 276 k
http://dag.wieers.com/rpm/packages/perl-Net-DNS/

perl-Net-Daemon noarch 0.43-1 DAG 44 k
http://dag.wieers.com/rpm/packages/perl-Net-Daemon/

perl-Net-IP noarch 1.25-2.fc6 base 31 k
perl-Net-SSLeay i386 1.30-4.fc6 base 195 k

perl-NetAddr-IP i386 4.007-1.el5.rf DAG 129 k
http://dag.wieers.com/rpm/packages/perl-NetAddr-IP/

perl-Socket6 i386 0.19-3.fc6 base 22 k

perl-Sys-Hostname-Long noarch 1.4-1.2.el5.rf DAG 12 k
http://dag.wieers.com/rpm/packages/perl-Sys-Hostname-Long/

perl-TimeDate noarch 1:1.16-5.el5 base 32 k
perl-URI noarch 1.35-3 base 116 k
perl-libwww-perl noarch 5.805-1.1.1 base 376 k

perl-version i386 0.72.3-1.el5.rf DAG 75 k
http://dag.wieers.com/rpm/packages/perl-Perl-Version/

postfix i386 2:2.3.3-2 base 3.6 M
postgresql-libs i386 8.1.9-1.el5 base 196 k
spamassassin i386 3.1.9-1.el5 base 922 k

tnef i386 1.4.3-1.el5.rf DAG 44 k
http://dag.wieers.com/rpm/packages/tnef/


(B) mailwatch noarch 1.0.4-4 recompile 2.4 M
http://mailwatch.sourceforge.net/

Need to recompile.
http://sourceforge.net/project/showfiles.php?group_id=87163&package_id=90748

RPM need by MailWatch :-

(b1) httpd i386 2.2.3-11.el5.centos base 1.1 M
(b2) php i386 5.1.6-15.el5 base 1.2 M
(b3) php-cli i386 5.1.6-15.el5 base 2.3 M
(b4) php-common i386 5.1.6-15.el5 base 140 k
(b5) php-gd i386 5.1.6-15.el5 base 111 k
(b6) php-mysql i386 5.1.6-15.el5 base 83 k
(b7) php-pdo i386 5.1.6-15.el5 base 61 k

(C) Optional

(c1) oscc-bayesian noarch 0.0.2-2.oscc oscc-repo 2.2 M

RPM SPEC will be release. This RPM for configuration Spamassassin to used Mysql.
This is related to issue site will high traffic would have file extension mutex
could not lock.

Transaction Summary

=============================================================================

Install 57 Package(s)
Update 0 Package(s)
Remove 0 Package(s)

Total download size: 44 M

Dbmail The Engine For SongketMail

Dbmail http://www.dbmail.org/ is selected as the main engine for storing email in SongketMail Email Server system. The Email will provided IMAP4 and POP3 access to SongketMail.

Mysql is used as the database for the email storage. Combine with master to master copy of Mysql a redundancy email server can be setup for backup and disaster recovery.

More detail about Dbmail can found at there website.

From Dbmail Website.

DBMail is made up of several components. A normal MTA (Postfix, SendMail, QMail, Exim) is used for accepting messages. The MTA hands the messages over to dbmail-smtp, using a pipe interface, or dbmail-lmtpd, using LMTP (Local Mail Transport Protocol). These programs take care of delivering the message into the database. Messages can be retreived from the database using dbmail-pop3d, using the POP3 protocol, and dbmail-imapd, using the IMAP4Rev1 protocol.

The whole email is stored in the database. That includes attachments. The DBMail programs do not have to touch the filesystem to retreive or insert emails. User information is also stored in the database, so users do not need an account on the machines DBMail is running on.

Terms And Condition

Terms And Condition

The price is for a new installation without any special customization. We will install the Email with the default configuration, email can be sent and received. This not include users creation.

The price is not outsite including transport and accommodation cost outsite Klang Valley.

The price does not include migration of any users or data or customization. A different fee will change.

The price is alway and will be a negotiable item.

This is a consultant service. Customer need to buy there own server hardware. The server specification will be given bys us after the customer requirement is study and propose.

Customer also need to prepare the domain name they want to used for their email.

Work will done after domain and the hardware as per requirement are ready and we have received LO or PO.

It takes about 4 to 5 business weeks to complete the installation.

Contact Us

For more information about SongketMail, contact

Harisfazillah Jamel 0196085482 (Malaysia) or Email linuxmalaysia @ gmail.com

SongketMail Advertisement At OLX Friendster

This is a link for SongketMail advertisement at OLX Friendster

http://olx.friendster.com/songketmail-for-easy-installation-of-linux-and-open-source-email-server-iid-6026712

SongketMail For Easy Installation Of Linux And Open Source Email Server

SongketMail For Easy Installation Of Linux And Open Source Email Server

SongketMail is a installer and package with consultant service, base on RPM and YUM for Linux Distribution CentOS, RedHat and Fedora. SongketMail is a continue research and development by Harisfazillah Jamel and LinuxDotMy Team members.

Included in SongketMail installation and consultant service :-

• The installation and configuration of SMTP service using Postfix and Dbmail.
• The installation and configuration of IMAP4 or POP3 service using Dbmail.
• The installation and configuration of Web Email Using Horde IMP.
• The installation and configuration of SPAM and virus filtering using MailScanner.

Training will be provided for Email administrator.

More information For SongketMail, Linux and Open Source Support

http://linuxmalaysia.harisfazillah.info/

Open Source Products used in SongketMail installation

CentOS
http://www.centos.org/

Postfix for SMTP
http://www.postfix.org/

Dbmail For Email Storage and IMAP
http://www.dbmail.org/

Horde IMP for Web Email
http://www.horde.org/

MailScanner For Virus and SPAM Filtering
http://www.mailscanner.info/

All Open Source products are with Licenses free from any licensing free. This cost and fee are for consultancy and support.

All in one solution for Open Source Email Server

http://linuxmalaysia.harisfazillah.info/2007/12/songketmail.html