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

[Gary Kline]

On Fri, Apr 30, 2004 at 04:35:52AM +0300, Ion-Mihai Tetcu wrote:
> On Thu, 29 Apr 2004 17:57:09 -0700
> Gary Kline <kline at thought.org> wrote:
> 
> > 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 bad thing with this approach is that when something goes wrong one
> would be somehow clueless. And you can't quite reproduce mysql manual in
> dpsam readme ;)


	No, but what you can do in your future write-up/tutorial 
	section is give something like the above with intersperced
	comments on ``why I am doing this''.  My knowledge of
	mysql is too sketchy to know what the "flush-privileges"
	line does.   And unless I've got a burning-knoweldge to
	grep thru the mysql docs, you could add to everyone's
	understanding.  

	((It would've been nice if the BBS ports gave clues on
	How-To set up mysql...))

	(Q: Where sholuld I look for "my.cnf"?  I've created 
	~/.dspam in my /home/test1  directory.  .dspam in a 
	0-length file, tho.  Should it be a directory.  I've
	grep'd thru your docs and found nothing ...  Well:: not
	so far!)

> 
> But I agree with you it would provide a quick start for a new dspam
> user.
> 
> > The only other 'trick' I've learned about mysql
> > 	is: `echo "show databases;" | mysql -u root -p'  
> 
> or  mysql -uroot -p -e 'show databases'


	:-)  Are there any other mysql  cmds that work with the
	-e flag??  Cool, thanks.
> 
> > 	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.
> 
> Asa the best teacher I ever had used to say:
> The hole pedagogics could be reduced to" make people interested in what
> you teach". ;)


	Yup; agree completely.

> 
> >  I had my share of flames for my being too simplistic, too
> >  cookbookish.... but what the hey?  Can't please everybody:)
> > </TOTALLY OT>
> > 
> > 		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*:)
> 
> Don't use dpsam for virus filtering. I will block about 80-90% of M$
> worm of the day, but not beeing its job it is just not sure enough to do
> that; and remember that it requires you to train it first. Of course if
> you are in an pure Unix environment the risks are greatly reduced, but
> if you're planing a setup for windows clients - don't.

	I'm all Unix.   The kind of virus spams I get come with
	Subjects like: "Did I see your porm photo on yahoo" or
	"Your statement enclosed"; these come in clusters, so 
	my guess is that there is some kind of ***vast-conspiracy*** 
	of imbiciles out there who are trying to out-imbicile the
	DOS/DOZE types.  mmmmmm.....

> 
> Eventually use it after your anti-virus or for catching those
> "disinfected" messages that some admins seems to like to let pass from
> their users.
> 

	This is getting interestinger and interestinger by the 
	minute;-)

	thanks much,

	gary



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