Date: Fri, 30 Apr 2004 01:37:43 +0300 From: Ion-Mihai Tetcu <itetcu@apropo.ro> To: Gary Kline <kline@thought.org> Cc: Gary Kline <kline@thought.org> Subject: Re: [dspam-users] thanks for dspam, my experiences on FreeBSD, suggestions Message-ID: <20040430013743.79fad551@it.buh.cameradicommercio.ro> In-Reply-To: <20040429202141.GB79110@tao.thought.org> References: <20040425115758.GA40483@titan.klemm.apsfilter.org> <20040426004411.756cc842@it.buh.cameradicommercio.ro> <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>
next in thread | previous in thread | raw e-mail | index | archive | help
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 ? > > > Re a -devel port, my experience with most of the devel suites > > > is that they are risky (to put it politely:). I would advise > > > anybody who installs a -devel port of anything to have the > > > stable/tested port around.... > > > > Agree. For example the 3.x showed, where dspam has been rewrote, showed > > some regressions. > > > > But since all new features are added on the devel branch and some people > > could make good use of them, this -devel port will help them. And it > > would give a chance for changes to be easily tested on FreeBSD before > > they are in the stable release. The bug in my PR is happening only on > > FreeBSD (it seems that our strsep(3) slightly differs from those on some > > linux, despite the their claim that it is from bsd). > > > 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. -- IOnut Unregistered ;) FreeBSD "user"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040430013743.79fad551>