[dspam-users] thanks for dspam, my experiences on FreeBSD,
kline at thought.org
Thu Apr 29 17:57:25 PDT 2004
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 < \
> (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
> edit your my.cnf and put "myisam-recover" in the [mysqld] section.
> Put in /usr/local/etc/dspam/mysql.data :
> 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.
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
> > 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.
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 Kline kline at thought.org www.thought.org Public service Unix
More information about the freebsd-ports