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? 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}" ] 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? - 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? Thanks... Ed ------------------------------------------------------------------------------ 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