Discussion of Spells and Grimoire items

[Sergey A Lipnevich <sergeyli AT pisem.net>]

Hi Julian,

I wanted to suggest an improvement to `mysql' spell. Following is the 
description, but you can skip it and just apply the patch below ;-) .

On my two systems, I was having problems with mysql after rebuilding: it 
refused to start completely, crashing on me regardless of what I tried. 
It would spit "mysqld got signal 11;", and then during backtracing say 
that stack is broken etc. Finally, I made it work again by removing 
"static linking" option (--with-mysqld-ldflags=-all-static) from 
./configure arguments. According to this page, 
http://www.mysql.com/doc/en/configure_options.html, it is only needed in 
case of problems, to make binary distribution of mysql, or for slight 
speed improvement.
Then, I added a couple of options to make things like user name and 
config directory explicit, and added Berkeley DB dependency (it compiles 
with db 4.0.14, but I didn't try to create a BDB-type table). I also 
moved creation of `mysql' user under the "do-if-server" path.
At the least, I'd be glad if "--with-mysqld-ldflags=-all-static" is dropped.
Thanks!

Sergey.

Index: BUILD
===================================================================
RCS file: /cvsroot/sourcemage/sourcemage/grimoire/devel/mysql/BUILD,v
retrieving revision 1.3
diff -u -r1.3 BUILD
--- BUILD       2002/05/29 18:41:02     1.3
+++ BUILD       2002/09/19 00:11:23
@@ -1,23 +1,25 @@
(

-
-  groupadd  mysql             2>/dev/null
-  useradd   mysql  -g  mysql  2>/dev/null
-
  LD_PRELOAD_OLD="$LD_PRELOAD"                            &&
  unset  LD_PRELOAD                                       &&
-  ./configure  --prefix=/usr                              \
+  ./configure  --build=$BUILD                             \
+               --prefix=/usr                              \
+               --sysconfdir=/etc                          \
+               --localstatedir=/var/lib/mysql             \
+               --with-mysqld-user=mysql                   \
               --without-bench                            \
               --enable-assembler                         \
-               --with-mysqld-ldflags=-all-static          \
-               --localstatedir=/var/lib/mysql             \
               $OPTS                                      &&
  export  LD_PRELOAD="$LD_PRELOAD_OLD"                    &&
  make  pkglibdir=/usr/lib                                &&
  prepare_install                                         &&
  make  pkglibdir=/usr/lib  install                       &&
  rm    -rf  /usr/mysql-test                              &&
+
  if ! grep  -q  "\--without-server" $SPELL_CONFIG;  then
+    groupadd  mysql             2>/dev/null
+    useradd   mysql  -g  mysql  2>/dev/null
+
    mysql_install_db
    chown  -R  mysql.mysql  /var/lib/mysql
    cp  /usr/share/mysql/mysql.server  /etc/init.d
Index: DEPENDS
===================================================================
RCS file: /cvsroot/sourcemage/sourcemage/grimoire/devel/mysql/DEPENDS,v
retrieving revision 1.3
diff -u -r1.3 DEPENDS
--- DEPENDS     2002/05/29 18:41:02     1.3
+++ DEPENDS     2002/09/19 00:11:23
@@ -1,2 +1,4 @@
depends  zlib  &&
-depends  perl
+depends  perl  &&
+
+optional_depends db "--with-berkeley-db" "--without-berkeley-db" "for 
Berkeley DB tables type support"