I was able to fix it by loading the right sql file. Seems I had the wrong sql file loaded in mysql.
Any advice on a good corpus to use? I've also made the single user on the system be dspam itself, which is now working. The only other issue I'm having on this system is that dspam isn't adding X-DSPAM headers. The signature gets added. Working through that problem now. Thank you, Greg Borbonus *Nix Server Administrator On 2/4/2012 6:04 AM, Tom Hendrikx wrote: > On 29/01/12 12:41, Greg Borbonus wrote: >> Hi, >> >> I'm new to this list, but got a task that I'll have to skip >> introductions for. >> >> I'm attempting to setup an outbound mail gateway that will scan outbound >> e-mails from our servers for spam. If it finds one, it should silently >> discard it, and alert support staff to the problem. >> >> I need this to be able to handle multiple servers. >> >> So far, I've got the following installed and configured. >> >> 1, postfix as an outbound relay(does not allow anyone other than my >> network to connect to it at all). >> 2, clamav(easiest thing in the world to setup). >> >> >> For the last couple of days, I've been fighting dspam to get it to >> function without a user base(I don't want user level security at all, >> would require we add a user to the system with every e-mail. Not to >> mention no user is on the system). >> I've got dspam functioning, with postfix via pipe(not lmtp). and I think >> I've got the whole configuration working. Dspam doesn't like postfix >> running chrooted, so I've had to come up with alternative methods to get >> around that issue, but right now I'm running into various sql inserts >> that are failing due to the column not being able to be null(uid cannot >> be null for example). >> >> Postfix handles the mail if dspam fails, and I cannot seem to get dspam >> to function without a ton of errors, I've had to fix a lot of em >> already, but this is my latest and who knows what's next. >> >> Any ideas? >> >> Btw, I've put this setup together by reading on the configs and coming >> up with the best setting and such. I've ready various howto's. None of >> which seem to explicitly address what I'm looking to do. I'm positive >> I've not got this configured seamlessly as this is my first time working >> with dspam. >> > In stead of trying to run a real user-less setup, use a single dedicated > user for all email. You can use classification groups for that. See the > README for the general idea. > > Tom > > ------------------------------------------------------------------------------ > Try before you buy = See our experts in action! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-dev2 > _______________________________________________ > Dspam-user mailing list > Dspam-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspam-user ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
