On 3/8/02 12:49 PM, "Greg Ward" <[EMAIL PROTECTED]> wrote:

> On 08 March 2002, Craig Hughes said:
>> I think for this setup, where most of the addresses are not mapped in
>> /etc/passwd (and so have no ~ directory), you should look at storing the
>> configurations in a database and use the SQL stuff.
> 
> Blech.  I don't want to have to run a big hairy database just so I can
> put SA config stuff somewhere.  The filesystem is a perfectly good
> database for many applications, and I so no reason why I should load
> this machine down with yet more semi-relevant software.  It's supposed
> to be a mail server -- that's it.

You could have a small, non-hairy database instead, and might find it yields
considerably better performance than your filesystem, since the config files
will be very small (less than a filesystem block no doubt) and so will yield
severely suboptimal caching.  The disk footprint would probably be smaller
too, even with significant indexing, again because of the blocking issue.

> (Yes, I realize lots of mail servers do need industrial strength
> databases.  Good for them.  If I were an ISP with X thousand users, I'd
> probably look into this.  But I'm not.)

Not sure when the "industrial strength" bit came in -- this is basically a
read-only DB you're talking about, so pretty much anything will do.

>> If nothing else, it'll
>> make your exim/python/whatever code easier to write, since you can just
>> invoke spamc with the address, and not have to do the
>> address->configlocation lookup in your own code.
> 
> I very much doubt that that lookup would be anything more complicated
> than
>   spamc -C /etc/spamassassin/config-$domain/$local_part
> (assuming a hypothetical -C option to specify an alternate
> user_prefs-like file), which is a heck of a lot easier than selecting,
> installing, maintaining, and updating a relational database.

Ok, well if you're naming the files like that anyway, you might as well just
create pseudo-users and stick them in /etc/passwd.

>> Another option would be to
>> just create those ~100 users in /etc/passwd and give them home directories,
>> and set their login shells to /bin/false, uid/gid to be the same as user
>> nobody or something, and then just use the standard user_prefs location.
> 
> That sounds like almost as much fun as selecting, installing,
> maintaining, and updating a relational database.  No thanks.

Yeah, but doing all the modification to the spamc/d protocol, modifying the
client, the server, and the SA libs would be trivial compared to all the
other suggestions.

C


_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk

Reply via email to