[sam] help with spamassassin and mysql

[Chris Bowlby]

On Thu, 13 Jun 2002, Devin Drown wrote:

I've included this into the CVS version of SAM.

> That was simple enough.  Thanks.  I noticed that the sql statements in the set
> was geared for pgsql.  Based on the info on the spamassassin web page:
>
> http://www.spamassassin.org/dist/sql/README
>
> I think that this might be a suitable for setting up the tables in mysql:
>
> CREATE TABLE userpref (
>   prefid int(11) NOT NULL auto_increment,
>   horde_id varchar(100) NOT NULL,
>   username varchar(8) NOT NULL,
>   preference varchar(30) NOT NULL,
>   value varchar(100) NOT NULL,
>   PRIMARY KEY  (prefid),
>   KEY username (username)
> ) TYPE=MyISAM;
>
>
> > Quoting Devin Drown <drown@banzai.org>:
> >
> > > What i'm looking for is some help in diagnosing what could be going on.
> >
> > I had to run spamd with -qx to get it to work...
> >
> > -chuck
>
>
> --
> sam mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: sam-unsubscribe@lists.horde.org
>

 Chris Bowlby,
 -----------------------------------------------------
 Manager of Information and Technology.
 excalibur@hub.org
 www.hub.org
 1-902-542-3657
 -----------------------------------------------------