Bug 158194 - mail-filter/dspam - add -relay-server flag
Bug#: 158194 Product:  Gentoo Linux Version: unspecified Platform: All
OS/Version: Other Status: RESOLVED Severity: enhancement Priority: P2
Resolution: FIXED Assigned To: mrness@gentoo.org Reported By: kilburna@iservnetworks.com
Component: Ebuilds
URL: 
Summary: mail-filter/dspam - add -relay-server flag
Keywords:  
Status Whiteboard: 
Opened: 2006-12-15 01:06 0000
Description:   Opened: 2006-12-15 01:06 0000 
How about adding a -relay-server flag.

In dspam ebuild, add
newins src/tools.mysql_drv/virtual_user_aliases.sql virtual_user_aliases.sql

if use relay ; then
    einfo "Creating DSPAM MySQL database for virtual-users users in relay mode"
    /usr/bin/mysql -u root -p ${DSPAM_MySQL_DB} < <
{CONFDIR}/virtual_user_aliases.sql
fi

The virtual-users flag is used if the MTA is local, but if the MTA is external
it is best to virtual_user_aliases.sql in the DB.

------- Comment #1 From Jakub Moc (RETIRED) 2006-12-15 01:22:27 0000 ------- 
How about ebuild name?

------- Comment #2 From Kilburn Abrahams 2006-12-15 01:42:57 0000 ------- 
How about adding a -relay-server flag.

In dspam ebuild, add
newins src/tools.mysql_drv/virtual_user_aliases.sql virtual_user_aliases.sql

if use relay-server ; then
    einfo "Creating DSPAM MySQL database for virtual-users users in relay mode"
    /usr/bin/mysql -u root -p ${DSPAM_MySQL_DB} < 
{CONFDIR}/virtual_user_aliases.sql
fi

The virtual-users flag should use the mysql_virtual_users script to populate
the DB if the MTA is local, but if the MTA is external it is best to use the
virtual_user_aliases.sql script.

------- Comment #3 From Jakub Moc (RETIRED) 2006-12-15 08:28:00 0000 ------- 
Noone will notice again if you don't reopen the bug...

------- Comment #4 From Kilburn Abrahams 2006-12-15 17:18:54 0000 ------- 
Created an attachment (id=104108) [details]
Modified dspam 3.6.8 to include dspam in relay mode

This modification is only for mysql, as there are no virtual_user_aliases
script for other databases.

------- Comment #5 From Alin Năstac 2006-12-15 23:28:15 0000 ------- 
I can't imagine how choosing the uids would be useful on a relay server.
Please elaborate.

------- Comment #6 From Kilburn Abrahams 2006-12-16 12:22:59 0000 ------- 
Use the virtual_user_aliases.sql instead of virtual_users.sql in order to
prevent the database from becoming ridiculously large in a small amount of
time.

virtual_users.sql creates a new virtual user in the database for every single
'From:' and 'To:' header it sees. This can get very ugly very fast. The
virtual_user_aliases.sql will allow multiple email addresses with the same uid,
which is how DSPAM recognizes users.

Please see the dspam wiki for examples.

------- Comment #7 From Alin Năstac 2006-12-19 01:52:03 0000 ------- 
Fixed in -r1, but not through a USE flag. Now pkg_config asks you what table
you want to use.