Tommi Lätti wrote: > On 14 Jun 2005, at 12:17, Sunny (Yion Kwang) Koh wrote:
>> I would like to know if anyone has used the users table in dbmail as >> a basis for an internal corporate wiki which users are check against >> that table for user id and password to allow them to surf and edit >> wiki pages? Any suggestions in doing something similar or using >> dbmail as a basis for a corperate Single Sign On or single >> userid/password as I don't want to issue a second set of user ids and >> passwords just for this purpose. > > Well, I've used the tables for apache http auth, there's a module for > that. Worked out-of-the-box with plaintext passwords. I use the PAM module for Apache and let pam-pg access the database. For software that uses its own tables I created a trigger and stored procedure: whenever the dbmail users table is changed the other tables are as well. >> P.S. I finally moved to dbmail when forced to with the failure of our >> old email system based on SuSe eMail Sever 2.0 and have yet added >> anti-spam functions. > > I would suggest to take a look in dspam, quite a lot more efficient > than spamassasin. Works for me on postfix-dspam-dbmail. Exim4 + SpamAssassin is nice as well: I do spam (and virus and some more) checks at smtp level. This way I can reject mails that are above some spam level (never had false positives above some level). That's very useful for virus checks: if you accept and bounce later you have to inform the faked sender or recipient. If you reject at smtp level you don't have to pester the faked sender - the smtp engine of the virus simply can't deliver the virus. Nice. Thomas -- http://www.tmueller.com for pgp key (95702B3B)
