Date: Thu, 29 Apr 2004 17:57:09 -0700 From: Gary Kline <kline@thought.org> To: Ion-Mihai Tetcu <itetcu@apropo.ro> Cc: Gary Kline <kline@thought.org> Subject: Re: [dspam-users] thanks for dspam, my experiences on FreeBSD, suggestions Message-ID: <20040430005708.GA23286@tao.thought.org> In-Reply-To: <20040430013743.79fad551@it.buh.cameradicommercio.ro> References: <20040426062108.GA2118@titan.klemm.apsfilter.org> <20040426104719.3182a631@it.buh.cameradicommercio.ro> <408D90FD.6090704@debank.tv> <20040427024247.5f93b88c@it.buh.cameradicommercio.ro> <20040428054454.GA3571@titan.klemm.apsfilter.org> <20040428093220.575afb78@it.buh.cameradicommercio.ro> <20040428193010.GA71823@tao.thought.org> <20040429104646.052e08cc@it.buh.cameradicommercio.ro> <20040429202141.GB79110@tao.thought.org> <20040430013743.79fad551@it.buh.cameradicommercio.ro>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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@localhost identified by 'foo234'; > > grant insert, delete, update on dspamdb.* to dspamdb_user@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@thought.org www.thought.org Public service Unix
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040430005708.GA23286>