On Wed, 28 Jul 2010 19:12:39 +0200
news...@acrocat.com wrote:
> I am playing around w/ getting dspam_maintenance.sh working, and I am
> seeing a couple of things:
>
> Is the database, user, port, and password supposed to be applied as
> command line arguments?
>
No. They are queried/used form dspam.conf
> It seems that I should be replacing them on
> this line, or can I set this with a parameter:
> read_dspam_params MySQLServer MySQLPort MySQLUser MySQLPass
> MySQLDb MySQLCompress && \
> [ -n "${MySQLServer}" -a -n "${MySQLUser}" -a -n "${MySQLDb}" ]
>
Don't change the lines. Those values are life queried dspam.conf.
> The purge-4.1.sql script that I am plugging in, from src/tools:
> - It has: SET @TrainingMode = 'TEFT'; -- Default training mode
> Q: why is that important? If I have some users using TOE and others
> TEFT, what do I do here?
>
Nothing. The TrainingMode in the purge script is just a default.
> - For this line: WHERE COALESCE(CONVERT(p.value USING latin1) COLLATE
> latin1_general_ci,CONVERT(d.value USING latin1) COLLATE
> latin1_general_ci,CONVERT(@TrainingMode USING latin1) COLLATE
> latin1_general_ci) = _latin1 'TUM'
> Q: Since I have my db setup as UTF8, and I would like to leave it that
> way for now, can I remove this line, or must I replace latin1 with utf8?
>
You can leave it. The SQL script is doing already the conversation for you,
regardless what collation you use.
> Thanks...
> Ed
>
--
Kind Regards from Switzerland,
Stevan Bajić
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
