[dspam-users] thanks for dspam, my experiences on FreeBSD, suggestions

[Gary Kline]

On Fri, Apr 30, 2004 at 01:37:43AM +0300, Ion-Mihai Tetcu wrote:
> On Thu, 29 Apr 2004 13:21:42 -0700
> Gary Kline <kline at thought.org> wrote:
> 
> [..]
> 
> > 		For people with little mysql || database bg, 
> > 		I hope your future doc will be more tutorial-like.
> > 		e.g:
> > 
> > mysql -u root -p
> > Enter password:
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 2 to server version: 4.XY.ZA
> >   
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > 
> > mysql> create database dspamdb;
> > Query OK, 1 row affected (0.00 sec)
> > 
> > mysql> grant all on dspamdb.* to dspamdb_user at localhost identified by 'foo234';
> 
> grant insert, delete, update on dspamdb.* to dspamdb_user at localhost identified by 'foo234';
> 
> > mysql> quit
> 
> # mysqladmin -uroot -p flush-privileges
> 
> # mysql -Ddspamdb -uroot -p < \
> /usr/local/share/examples/dspam/mysql_objects.sql.speed.optimized
> 
>  (and since you won't find for now mysql_objects.sql.speed.optimized
> there, od a make extract in mail/dspam and run the above with
> /usr/local/ports/mail/dspam/work/dpsam-2.10.3/tools.mysq_drv/mysql_objects.sql.speed.optimized)
> 
> edit your my.cnf and put "myisam-recover" in the [mysqld] section.
> 
> Put in /usr/local/etc/dspam/mysql.data :
> /tmp/mysql.sock
> 
> dspam
> foo1234
> dspamdb
> 
> You're done.
> 
> Something like this ?
> 


	YES! Exactly, sir.  wHat you have added are hints to whoever
	wants to learn <somethinng>/<enough> about both mysql and
	dspam, but who doesn't necessarily care about becoming an
	SQL expert.  The only other 'trick' I've learned about mysql
	is: `echo "show databases;" | mysql -u root -p'  
	which saved me keystrokes while telling me that I did, in fact,
	*not* have anything dspam under the mysql directory.

	<TOTALLY OT>
	One goal of the Answer Crew during the several years it ran 
	was to teach this kind of tidbit:: enough to whet people's
	interest/curiosity.  I had my share of flames for my being 
	too simplistic, too cookbookish.... but what the hey?  Can't
	please everybody:)
	</TOTALLY OT>


> > 	Have you ever checked our Lars Wirzenius' publib string
> > 	functions?  When I've stubbed my toe on Unix-compat problems
> > 	as you'rehaving wth strsep(), I've resolved the issue by
> > 	including the function (from wherever) in my code. Putting
> > 	the FBSD strsep() code in there --- or something equally
> > 	fuctional from publib --- might work.  Just a thought.
> 
> Thanks.
> 
> 

		I'm looking forward to getting dspam running, then  to 
		catch thde remaining few dozen virus-spams or "GET BETTER
		LIFE INS HERE, NOW!" spams.  (*mumble*:)

		gary
> 

-- 
   Gary Kline     kline at thought.org   www.thought.org     Public service Unix