Bugzilla Bug 158194

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.

How about ebuild name?

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.

Noone will notice again if you don't reopen the bug...

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.

I can't imagine how choosing the uids would be useful on a relay server.
Please elaborate.

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.

Fixed in -r1, but not through a USE flag. Now pkg_config asks you what table
you want to use.