| View previous topic :: View next topic |
| Author |
Message |
apokalyptik
n00b
Joined: 18 Jun 2002
Posts: 62
|
 Posted: Tue Dec 23, 2003 9:42 pm Post subject: vpopmail + spamassassin + sql + web based prefs editor |
 |
|
make sure vpopmail is setup and 100% working before trying this...
Install Spamassassin
| Code: | | emerge dev-perl/Mail-SpamAssassin |
Create a Mysql username/password/database combination of spamassassin/spamassassin/spamassassin
populate the database with the following table
| Code: | CREATE TABLE userpref (
username varchar(100) NOT NULL default '',
preference varchar(30) NOT NULL default '',
value varchar(100) NOT NULL default '',
prefid int(11) NOT NULL auto_increment,
PRIMARY KEY (prefid)
) TYPE=MyISAM; |
install sql.cf so spamassassin knows how to connect to the spamassassin user prefs database (assuming localhost is your db server)
| Code: | echo 'user_scores_dsn DBI:mysql:spamassassin:localhost
user_scores_sql_username spamassassin
user_scores_sql_password spamassassin
user_scores_sql_table userpref' > /etc/mail/spamassassin/sql.cf |
Create some directories, files, and set permissions/ownership
| Code: | mkdir /var/qmail/supervise/qmail-spamd
mkdir /var/qmail/supervise/qmail-spamd/log
mkdir /var/log/qmail/qmail-spamd
echo '#!/bin/bash
exec softlimit -m 25000000 /usr/bin/spamd -D -x -q -c -v -m 5 -s stderr -u vpopmail 2>&1' > /var/qmail/supervise/qmail-spamd/run
echo '#!/bin/sh
exec /usr/bin/setuidgid qmaill /usr/bin/multilog t s10000000 /var/log/qmail/qmail-spamd' > /var/qmail/supervise/qmail-spamd/log/run
chown qmaill.wheel /var/log/qmail/qmail-spamd
chown root.root /var/qmail/supervise/qmail-spamd -R
chmod 755 /var/qmail/supervise/qmail-spamd -R |
install service, and restart svscan
| Code: | /etc/init.d/svscan stop
ln -s /var/qmail/supervise/qmail-spamd /service
/etc/init.d/svscan start |
you can then put | Code: | | "| /usr/bin/spamc -f -u $EXT@$USER | /var/vpopmail/bin/vdelivermail '' bounce-no-mailbox" |
for per-mailbox settings, or | Code: | | "| /usr/bin/spamc -f -u postmaster@$USER | /var/vpopmail/bin/vdelivermail '' bounce-no-mailbox" |
for global domain settings, into the .qmail-default file for the domain.
| Code: | cd {web directory}
wget http://www.pipegrep.net/webuserprefs/webuserprefs-0.5.tar.gz
eagle@rs1 public_html $ tar -zxf webuserprefs-0.5.tar.gz
eagle@rs1 public_html $ cd webuserprefs-0.5
eagle@rs1 webuserprefs-0.5 $ mv * ..
nano -w config.inc.php |
change th following settins to match your setup:
| Code: |
// require("auth/server.php");
// require("auth/imap.php"); // (technically I use this)
// require("auth/pop3.php");
require("auth/pop3_noimap.php");
// require("auth/squirrelmail.php");
$prefs_source = "db";
$db_host = "localhost";
$db_username = "youruser";
$db_password = "yourpw";
$db_database = "spamassassin";
$db_table = "userpref";
$db_sauser = "$auth_user"; |
you should now have spamassassin enabled for the entire domain, and users can visit the web interface, enter their full e-mail address and password, and modify their personal settings (or postmaster@domain.com/pass to modify global domain settings...)
_________________
http://www.apokalyptik.com/ |
|
| Back to top |
|
 |
apokalyptik
n00b
Joined: 18 Jun 2002
Posts: 62
|
| Posted: Thu Dec 25, 2003 11:20 pm Post subject: |
|
|
sorry... you have to have th seekable patch installed for this to work... here's a modified /usr/portage/net-mail/vpopmail/vpopmail-5.2.1-r8.ebuild
| Code: | # Copyright 1999-2003 Gentoo Technologies, Inc.
# Distributed under the terms of the GNU General Public License v2
# $Header: /home/cvsroot/gentoo-x86/net-mail/vpopmail/vpopmail-5.2.1-r8.ebuild,v 1.2 2003/12/08 22:31:03 robbat2 Exp $
IUSE="mysql ipalias clearpasswd"
inherit eutils
# TODO: all ldap, sybase support
HOMEPAGE="http://www.inter7.com/vpopmail"
DESCRIPTION="A collection of programs to manage virtual email domains and accounts on your Qmail or Postfix mail servers."
SRC_URI="http://www.inter7.com/${PN}/${P}.tar.gz
http://www.thesafebox.com/seekable-5.2.diff
mysql? ( http://gentoo.twobit.net/misc/${P}-mysql.diff )"
SLOT="0"
LICENSE="GPL-2"
KEYWORDS="x86 sparc"
DEPEND_COMMON="net-mail/qmail
mysql? ( >=dev-db/mysql-3.23* )"
DEPEND="sys-apps/sed
sys-apps/ucspi-tcp
${DEPEND_COMMON}"
RDEPEND="${DEPEND_COMMON}
virtual/cron"
# Define vpopmail home dir in /etc/password if different
VPOP_DEFAULT_HOME="/var/vpopmail"
VPOP_HOME="$VPOP_DEFAULT_HOME"
# This makes sure the variable is set, and that it isn't null.
vpopmail_set_homedir() {
VPOP_HOME=`getent passwd vpopmail | cut -d: -f6`
if [ -z "$VPOP_HOME" ]; then
echo -ne "\a"
eerror "vpopmail's home directory is null in passwd data!"
eerror "You probably want to check that out."
eerror "Continuing with default."
sleep 1; echo -ne "\a"; sleep 1; echo -ne "\a"
VPOP_HOME="${VPOP_DEFAULT_HOME}"
else
einfo "Setting VPOP_HOME to: $VPOP_HOME"
fi
}
pkg_setup() {
if [ -z `getent group vpopmail` ]; then
(groupadd -g 89 vpopmail 2>/dev/null || groupadd vpopmail ) || die "problem adding vpopmail group"
fi
if [ -z `getent passwd vpopmail` ]; then
useradd -g vpopmail -u 89 -d ${VPOP_DEFAULT_HOME} -c "vpopmail_directory" -s /bin/false -m vpopmail || \
useradd -g vpopmail -u `getent group vpopmail | awk -F":" '{ print $3 }'` -d ${VPOP_DEFAULT_HOME} -c "vpopmail_directory" \
-s /bin/false -m vpopmail || die "problem adding vpopmail user"
fi
}
src_unpack() {
cd ${WORKDIR}
unpack ${P}.tar.gz
cd ${S}
epatch ${FILESDIR}/vpopmail-5.2.1-showall.patch
epatch ${DISTDIR}/seekable-5.2.diff
if use mysql; then
einfo "Applying MySQL patch..."
# Thanks to Nicholas Jones (carpaski@gentoo.org)
epatch ${DISTDIR}/vpopmail-5.2.1-mysql.diff
# gcc3.3 fix
epatch ${FILESDIR}/vpopmail-5.2.1-gcc33mysql.diff
fi
# Thanks to Vadim Berezniker (vadim@berezniker.com)
# This patch backports a bug fix from the devel version re: logons
epatch ${FILESDIR}/vpopmail.diff
}
src_compile() {
vpopmail_set_homedir
use ipalias && myopts="${myopts} --enable-ip-alias-domains=y" \
|| myopts="${myopts} --enable-ip-alias-domains=n"
use mysql && myopts="${myopts} --enable-mysql=y \
--enable-libs=/usr/include/mysql \
--enable-sqllibdir=/usr/lib/mysql \
--enable-mysql-logging=y \
--enable-auth-logging=y \
--enable-valias=y \
--enable-mysql-replication=n" \
|| myopts="${myopts} --enable-mysql=n"
# the configure script tries to force root and make directories not using ${D}
sed -e '1282,1289d' -e '1560,1567d' -e '2349d' -e '2107d' -e '2342d' configure > configure.new
mv --force configure.new configure
chmod u+x configure
# Bug 20127
use clearpasswd &&
myopts="${myopts} --enable-clear-passwd=y" ||
myopts="${myopts} --enable-clear-passwd=n"
econf ${myopts} --sbindir=/usr/sbin \
--bindir=/usr/bin \
--sysconfdir=${VPOP_HOME}/etc \
--enable-qmaildir=/var/qmail \
--enable-qmail-newu=/var/qmail/bin/qmail-newu \
--enable-qmail-inject=/var/qmail/bin/qmail-inject \
--enable-qmail-newmrh=/var/qmail/bin/qmail-newmrh \
--enable-vpopuser=vpopmail \
--enable-many-domains=y \
--enable-vpopgroup=vpopmail \
--enable-file-locking=y \
--enable-file-sync=y \
--enable-md5-passwords=y \
--enable-defaultquota=30000000,1000C \
--enable-roaming-users=y --enable-relay-clear-minutes=60 \
--enable-tcprules-prog=/usr/bin/tcprules --enable-tcpserver-file=/etc/tcp.smtp \
--enable-logging=y \
--enable-log-name=vpopmail
use mysql && echo '#define MYSQL_PASSWORD_FILE "/etc/vpopmail.conf"' >> config.h
emake || die "Make failed."
}
src_install () {
vpopmail_set_homedir
make DESTDIR=${D} install-strip || die
# Install documentation.
dodoc AUTHORS ChangeLog COPYING FAQ INSTALL NEWS TODO
dodoc README README.* RELEASE.NOTES UPGRADE.*
dodoc doc/doc_html/* doc/man_html/*
rm -rf ${D}/${VPOP_HOME}/doc
dosym /usr/share/doc/${PF}/ ${VPOP_HOME}/doc
# Create /etc/vpopmail.conf
if use mysql; then
einfo "Installing vpopmail mysql configuration file"
dodir /etc
insinto /etc
doins ${FILESDIR}/vpopmail.conf
fowners vpopmail:vpopmail /etc/vpopmail.conf
fperms 600 /etc/vpopmail.conf
fi
# Install a proper cronjob instead of the old nastiness
einfo "Installing cronjob"
dodir /etc/cron.hourly
insinto /etc/cron.hourly
doins ${FILESDIR}/vpopmail.clearopensmtp
fperms +x /etc/cron.hourly/vpopmail.clearopensmtp
einfo "Installing env.d entry"
dodir /etc/env.d
insinto /etc/env.d
doins ${FILESDIR}/99vpopmail
# Configure b0rked. We'll do this manually
echo "-I${VPOP_HOME}/include" > ${D}/${VPOP_HOME}/etc/inc_deps
local libs_extra
use mysql && libs_extra="-L/usr/lib/mysql -lmysqlclient -lz" || libs_extra=""
echo "-L${VPOP_HOME}/lib -lvpopmail ${libs_extra}" > ${D}/${VPOP_HOME}/etc/lib_deps
einfo "Locking down vpopmail permissions"
# secure things more, i don't want the vpopmail user being able to write this stuff!
chown -R root:root ${D}${VPOP_HOME}/{bin,etc,include}
}
pkg_preinst() {
vpopmail_set_homedir
# Keep DATA
keepdir ${VPOP_HOME}/domains
# This is a workaround until portage handles binary packages+users better.
pkg_setup
}
pkg_postinst() {
einfo "Performing post-installation routines for ${P}."
if use mysql; then
echo
einfo "You have 'mysql' turned on in your USE"
einfo "Vpopmail needs a VALID MySQL USER. Let's call it 'vpopmail'"
einfo "You MUST add it and then specify its passwd in the /etc/vpopmail.conf file"
echo
einfo "First log into mysql as your mysql root user and pass. Then:"
einfo "> create database vpopmail;"
einfo "> use mysql;"
einfo "> grant select, insert, update, delete, create, drop on vpopmail.* to"
einfo " vpopmail@localhost identified by 'your password';"
einfo "> flush privileges;"
echo
einfo "If you have problems with vpopmail not accepting mail properly,"
einfo "please ensure that /etc/vpopmail.conf is chmod 600 and"
einfo "owned by vpopmail:vpopmail"
fi
# do this for good measure
if [ -e /etc/vpopmail.conf ]; then
chmod 600 /etc/vpopmail.conf
chown vpopmail:vpopmail /etc/vpopmail.conf
fi
}
pkg_postrm() {
vpopmail_set_homedir
einfo "The vpopmail DATA will NOT be removed automatically."
einfo "You can delete them manually by removing the ${VPOP_HOME} directory."
} |
_________________
http://www.apokalyptik.com/ |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Documentation, Tips & Tricks
