OpenPKG CVS Repository
http://cvs.openpkg.org/
____________________________________________________________________________
Server: cvs.openpkg.org Name: Ralf S. Engelschall
Root: /e/openpkg/cvs Email: [EMAIL PROTECTED]
Module: openpkg-src openpkg-web openpkg$ Date: 05-Jan-2004 15:44:26
Branch: HEAD Handle: 2004010514442302
Added files:
openpkg-re/vcheck vc.mysql41
openpkg-src/mysql41 my.cnf my.pwd mysql41.patch mysql41.spec rc.mysql
Modified files:
openpkg-web news.txt
Log:
new package: mysql41 4.1.1 (Fast Relational Database Management
System)
Summary:
Revision Changes Path
1.1 +9 -0 openpkg-re/vcheck/vc.mysql41
1.1 +56 -0 openpkg-src/mysql41/my.cnf
1.1 +3 -0 openpkg-src/mysql41/my.pwd
1.1 +80 -0 openpkg-src/mysql41/mysql41.patch
1.1 +232 -0 openpkg-src/mysql41/mysql41.spec
1.1 +98 -0 openpkg-src/mysql41/rc.mysql
1.7982 +1 -0 openpkg-web/news.txt
____________________________________________________________________________
patch -p0 <<'@@ .'
Index: openpkg-re/vcheck/vc.mysql41
============================================================================
$ cvs diff -u -r0 -r1.1 vc.mysql41
--- /dev/null 2004-01-05 15:44:24.000000000 +0100
+++ vc.mysql41 2004-01-05 15:44:24.000000000 +0100
@@ -0,0 +1,9 @@
+config = {
+}
+
+prog mysql41 = {
+ version = 4.1.1-alpha
+ url = http://www.mysql.com/downloads/mysql-4.1.html
+ regex = mysql-(__VER__)\.tar\.gz
+}
+
@@ .
patch -p0 <<'@@ .'
Index: openpkg-src/mysql41/my.cnf
============================================================================
$ cvs diff -u -r0 -r1.1 my.cnf
--- /dev/null 2004-01-05 15:44:26.000000000 +0100
+++ my.cnf 2004-01-05 15:44:26.000000000 +0100
@@ -0,0 +1,56 @@
+##
+## my.cnf -- MySQL configuration
+##
+
+[client]
+socket = @l_prefix@/var/mysql/mysql.sock
+port = 3306
+
+[mysqld]
+bind-address = 127.0.0.1
+port = 3306
+# logfile destinations (overwrite values of rc.mysql in rc.conf accordingly)
+log = @l_prefix@/var/mysql/common.log
+log-update = @l_prefix@/var/mysql/update.log
+# binary log (use instead of log-update, server-id must be unique for replication)
+#log-bin = @l_prefix@/var/mysql/binary.log
+#server-id = 1
+
+[mysqld_safe]
+datadir = @l_prefix@/var/mysql
+socket = @l_prefix@/var/mysql/mysql.sock
+set-variable = [EMAIL PROTECTED]@/var/mysql/mysqld.pid
+user = @l_rusr@
+basedir = @l_prefix@
+
+# most important tuning parameters for mysqld
+set-variable = key_buffer_size=16M
+set-variable = table_cache=64
+
+# less important tuning parameters (change if special problems occur)
+set-variable = join_buffer_size=1M
+set-variable = max_connections=1000
+set-variable = max_connect_errors=10
+set-variable = max_delayed_threads=20
+set-variable = max_heap_table_size=16777216
+set-variable = max_sort_length=1024
+set-variable = max_user_connections=1000
+set-variable = record_buffer=131072
+set-variable = record_rnd_buffer=131072
+set-variable = sort_buffer=2M
+set-variable = key_buffer=1M
+set-variable = tmp_table_size=32M
+
+# Berkeley DB
+set-variable = [EMAIL PROTECTED]@
+set-variable = [EMAIL PROTECTED]@
+set-variable = [EMAIL PROTECTED]@
+
+# Innobase DB
+#set-variable = innodb_buffer_pool_size=70M
+#set-variable = innodb_additional_mem_pool_size=2M
+#set-variable = innodb_log_files_in_group=3
+#set-variable = innodb_log_file_size=20M
+#set-variable = innodb_log_buffer_size=8M
+#set-variable = innodb_lock_wait_timeout=50
+
@@ .
patch -p0 <<'@@ .'
Index: openpkg-src/mysql41/my.pwd
============================================================================
$ cvs diff -u -r0 -r1.1 my.pwd
--- /dev/null 2004-01-05 15:44:26.000000000 +0100
+++ my.pwd 2004-01-05 15:44:26.000000000 +0100
@@ -0,0 +1,3 @@
+[mysqladmin]
+user = root
+password =
@@ .
patch -p0 <<'@@ .'
Index: openpkg-src/mysql41/mysql41.patch
============================================================================
$ cvs diff -u -r0 -r1.1 mysql41.patch
--- /dev/null 2004-01-05 15:44:26.000000000 +0100
+++ mysql41.patch 2004-01-05 15:44:26.000000000 +0100
@@ -0,0 +1,80 @@
+Index: mysys/default.c
+--- mysys/default.c.orig 2003-12-01 13:55:03.000000000 +0100
++++ mysys/default.c 2004-01-05 14:12:26.000000000 +0100
+@@ -48,7 +48,7 @@
+ #elif defined(__NETWARE__)
+ "sys:/etc/",
+ #else
+-"/etc/",
++"@l_prefix@/etc/mysql/",
+ #endif
+ #ifdef DATADIR
+ DATADIR,
+Index: scripts/msql2mysql.sh
+--- scripts/msql2mysql.sh.orig 2003-12-01 13:55:06.000000000 +0100
++++ scripts/msql2mysql.sh 2004-01-05 14:12:26.000000000 +0100
+@@ -13,4 +13,4 @@
+ # described in the License. Among other things, the License requires that
+ # the copyright notice and this notice be preserved on all copies.
+
[EMAIL PROTECTED]@/replace msqlConnect mysql_connect msqlListDBs mysql_list_dbs
msqlNumRows mysql_num_rows msqlFetchRow mysql_fetch_row msqlFetchField
mysql_fetch_field msqlFreeResult mysql_free_result msqlListFields mysql_list_fields
msqlListTables mysql_list_tables msqlErrMsg 'mysql_error(mysql)' msqlStoreResult
mysql_store_result msqlQuery mysql_query msqlField mysql_field msqlSelect mysql_select
msqlSelectDB mysql_select_db msqlNumFields mysql_num_fields msqlClose mysql_close
msqlDataSeek mysql_data_seek m_field MYSQL_FIELD m_result MYSQL_RES m_row MYSQL_ROW
msql mysql mSQL mySQL MSQL MYSQL msqlCreateDB mysql_create_db msqlDropDB mysql_drop_db
msqlFieldSeek mysql_field_seek -- $*
[EMAIL PROTECTED]@/replace msqlConnect mysql_connect msqlListDBs mysql_list_dbs
msqlNumRows mysql_num_rows msqlFetchRow mysql_fetch_row msqlFetchField
mysql_fetch_field msqlFreeResult mysql_free_result msqlListFields mysql_list_fields
msqlListTables mysql_list_tables msqlErrMsg 'mysql_error(mysql)' msqlStoreResult
mysql_store_result msqlQuery mysql_query msqlField mysql_field msqlSelect mysql_select
msqlSelectDB mysql_select_db msqlNumFields mysql_num_fields msqlClose mysql_close
msqlDataSeek mysql_data_seek m_field MYSQL_FIELD m_result MYSQL_RES m_row MYSQL_ROW
msql mysql mSQL mySQL MSQL MYSQL msqlCreateDB mysql_create_db msqlDropDB mysql_drop_db
msqlFieldSeek mysql_field_seek -- $*
+Index: scripts/mysql_install_db.sh
+--- scripts/mysql_install_db.sh.orig 2003-12-01 13:55:04.000000000 +0100
++++ scripts/mysql_install_db.sh 2004-01-05 14:12:26.000000000 +0100
+@@ -177,9 +177,8 @@
+
+ if test ! -d $ldata; then mkdir $ldata; chmod 700 $ldata ; fi
+ if test ! -d $ldata/mysql; then mkdir $ldata/mysql; chmod 700 $ldata/mysql ; fi
+- if test ! -d $ldata/test; then mkdir $ldata/test; chmod 700 $ldata/test ; fi
+ if test -w / -a ! -z "$user"; then
+- chown $user $ldata $ldata/mysql $ldata/test;
++ chown $user $ldata $ldata/mysql
+ fi
+
+ if test ! -f $mdata/db.frm
+@@ -234,10 +233,7 @@
+ if test "$in_rpm" = "0"
+ then
+ echo "You can start the MySQL daemon with:"
+- echo "cd @prefix@ ; $bindir/mysqld_safe &"
+- echo
+- echo "You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:"
+- echo "cd sql-bench ; perl run-all-tests"
++ echo "@l_prefix@/etc/rc mysql start"
+ echo
+ fi
+ echo "Please report any problems with the @scriptdir@/mysqlbug script!"
+Index: scripts/mysql_create_system_tables.sh
+--- scripts/mysql_create_system_tables.sh.orig 2003-12-01 13:55:05.000000000
+0100
++++ scripts/mysql_create_system_tables.sh 2004-01-05 15:25:57.000000000 +0100
+@@ -68,9 +68,6 @@
+ c_d="$c_d KEY User (User)"
+ c_d="$c_d )"
+ c_d="$c_d comment='Database privileges';"
+-
+- i_d="INSERT INTO db VALUES
('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');
+- INSERT INTO db VALUES
('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');"
+ fi
+
+ if test ! -f $mdata/host.frm
+@@ -145,17 +142,13 @@
+ then
+ i_u="INSERT INTO user VALUES
('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
+ INSERT INTO user VALUES
('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
+- REPLACE INTO user VALUES
('127.0.0.1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
+- INSERT INTO user (host,user) values ('localhost','');
+- INSERT INTO user (host,user) values ('$hostname','');"
++ REPLACE INTO user VALUES
('127.0.0.1','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);"
+ else
+ i_u="INSERT INTO user VALUES
('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);"
+ if test "$windows" = "0"
+ then
+ i_u="$i_u
+- INSERT INTO user VALUES
('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
+- INSERT INTO user (host,user) values ('$hostname','');
+- INSERT INTO user (host,user) values ('localhost','');"
++ INSERT INTO user VALUES
('$hostname','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);"
+ else
+ i_u="INSERT INTO user VALUES
('localhost','','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);"
+ fi
@@ .
patch -p0 <<'@@ .'
Index: openpkg-src/mysql41/mysql41.spec
============================================================================
$ cvs diff -u -r0 -r1.1 mysql41.spec
--- /dev/null 2004-01-05 15:44:26.000000000 +0100
+++ mysql41.spec 2004-01-05 15:44:26.000000000 +0100
@@ -0,0 +1,232 @@
+##
+## mysql41.spec -- OpenPKG RPM Specification
+## Copyright (c) 2000-2003 The OpenPKG Project <http://www.openpkg.org/>
+## Copyright (c) 2000-2003 Ralf S. Engelschall <[EMAIL PROTECTED]>
+## Copyright (c) 2000-2003 Cable & Wireless <http://www.cw.com/>
+##
+## Permission to use, copy, modify, and distribute this software for
+## any purpose with or without fee is hereby granted, provided that
+## the above copyright notice and this permission notice appear in all
+## copies.
+##
+## THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
+## WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
+## MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
+## IN NO EVENT SHALL THE AUTHORS AND COPYRIGHT HOLDERS AND THEIR
+## CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
+## SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
+## LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
+## USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+## ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
+## OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
+## OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
+## SUCH DAMAGE.
+##
+
+# package version
+%define V_major 4.1
+%define V_minor 1
+%define V_mysql %{V_major}.%{V_minor}-alpha
+%define V_opkg %{V_major}.%{V_minor}
+
+# package information
+Name: mysql41
+Summary: Fast Relational Database Management System
+URL: http://www.mysql.com/
+Vendor: MySQL AB
+Packager: The OpenPKG Project
+Distribution: OpenPKG [BASE]
+Group: Database
+License: GPL
+Version: %{V_opkg}
+Release: 20040105
+
+# package options
+%option with_berkeleydb yes
+%option with_innobase no
+
+# list of sources
+Source0:
http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/MySQL-%{V_major}/mysql-%{V_mysql}.tar.gz
+Source1: my.cnf
+Source2: my.pwd
+Source3: rc.mysql
+Patch0: mysql41.patch
+
+# build information
+Prefix: %{l_prefix}
+BuildRoot: %{l_buildroot}
+BuildPreReq: OpenPKG, openpkg >= 20030909, perl, gcc
+PreReq: OpenPKG, openpkg >= 20030909, perl
+BuildPreReq: zlib
+PreReq: zlib
+AutoReq: no
+AutoReqProv: no
+Provides: mysql = %{version}-%{release}
+
+%description
+ MySQL is a multi-user Relational Database Management System (RDBMS),
+ which is controlled through Structured Query Language (SQL) operating in
+ full multi-threading mode. The main goals of MySQL are speed, robustness
+ and ease of use. MySQL was originally developed because of the need for
+ a SQL server that could handle very big databases with magnitude higher
+ speed than what any database vendor could offer.
+
+ NOTICE: This package contains the new and forthcoming MySQL 4.1
+ version. Please use the "mysql" package, containing the current
+ stable MySQL 4.0 version.
+
+%prep
+ %setup -q -n mysql-%{V_mysql}
+ exit 0
+ %patch -p0
+
+%build
+ # patch file search path
+ %{l_shtool} subst %{l_value -s -a} \
+ mysys/default.c
+
+ # determine additional configure options
+ case "%{l_platform -t}" in
+ *-freebsd* ) opt="--with-client-ldflags=-static
--with-mysqld-ldflags=-static" ;;
+ *-linux* ) opt="--with-client-ldflags=-static
--with-mysqld-ldflags=-static" ;;
+ *-sunos* ) opt="--with-client-ldflags=-static
--with-mysqld-ldflags=-static" ;;
+ esac
+
+ # configure source tree
+ CC="%{l_cc}" \
+ CXX="%{l_cxx}" \
+ CFLAGS="%{l_cflags -O}" \
+ CXXFLAGS="%{l_cxxflags -O}" \
+ ./configure \
+ --prefix=%{l_prefix} \
+ --sysconfdir=%{l_prefix}/etc/mysql \
+ --localstatedir=%{l_prefix}/var/mysql \
+ --libexecdir=%{l_prefix}/libexec/mysql \
+ --with-unix-socket-path=%{l_prefix}/var/mysql/mysql.sock \
+ --with-mysqld-user=%{l_musr} \
+ --enable-thread-safe-client \
+%if "%{with_berkeleydb}" == "yes"
+ --with-berkeley-db \
+%endif
+%if "%{with_innobase}" == "no"
+ --without-innodb \
+%endif
+ --with-named-z-libs=no \
+ --with-low-memory \
+ --disable-shared \
+ $opt
+
+ # build source tree
+ %{l_make} %{l_mflags}
+
+%install
+ rm -rf $RPM_BUILD_ROOT
+
+ # patch init script
+ %{l_shtool} subst %{l_value -s -a} \
+ scripts/mysql_install_db.sh
+
+ # perform standard installation procedure
+ %{l_make} %{l_mflags} install \
+ AM_MAKEFLAGS="DESTDIR=$RPM_BUILD_ROOT" \
+ DESTDIR=$RPM_BUILD_ROOT
+
+ # move utility 'replace', msql2mysql is patched for new path
+ mv $RPM_BUILD_ROOT%{l_prefix}/bin/replace \
+ $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/
+
+ # strip installation area
+ rm -rf $RPM_BUILD_ROOT%{l_prefix}/mysql-test
+ rm -rf $RPM_BUILD_ROOT%{l_prefix}/sql-bench
+ rm -f $RPM_BUILD_ROOT%{l_prefix}/info/dir
+ rm -f $RPM_BUILD_ROOT%{l_prefix}/share/mysql/mysql*.spec
+ rm -f $RPM_BUILD_ROOT%{l_prefix}/share/mysql/binary-configure
+ strip $RPM_BUILD_ROOT%{l_prefix}/bin/* 2>/dev/null || true
+ strip $RPM_BUILD_ROOT%{l_prefix}/libexec/mysql/* 2>/dev/null || true
+
+ # determine default parameters
+%if "%{with_berkeleydb}" == "yes"
+ l_mysql_bdb_cache_size=8M
+ l_mysql_bdb_log_buffer_size=32k
+ l_mysql_bdb_max_lock=10000
+%else
+ l_mysql_bdb_cache_size=0
+ l_mysql_bdb_log_buffer_size=0
+ l_mysql_bdb_max_lock=0
+%endif
+%if "%{with_berkeleydb}" == "yes" || "%{with_innobase}" == "yes"
+ l_mysqld=mysqld
+%else
+ l_mysqld=mysqld-max
+%endif
+
+ # install global configuration
+ %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/etc/mysql
+ %{l_shtool} install -c -m 644 %{l_value -s -a} \
+ -e "s;@l_mysql_bdb_cache_size@;${l_mysql_bdb_cache_size};g" \
+ -e "s;@l_mysql_bdb_log_buffer_size@;${l_mysql_bdb_log_buffer_size};g" \
+ -e "s;@l_mysql_bdb_max_lock@;${l_mysql_bdb_max_lock};g" \
+ %{SOURCE my.cnf} \
+ $RPM_BUILD_ROOT%{l_prefix}/etc/mysql/
+ %{l_shtool} install -c -m 600 \
+ %{SOURCE my.pwd} \
+ $RPM_BUILD_ROOT%{l_prefix}/etc/mysql/
+
+ # install run-command script
+ %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d
+ %{l_shtool} install -c -m 755 %{l_value -s -a} \
+ -e "s;@l_mysqld@;${l_mysqld};g" \
+ %{SOURCE rc.mysql} $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d/
+
+ # make sure the database directory exists
+ %{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/var/mysql
+
+ # determine the package files
+ %{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
+ %{l_files_std} \
+ '%config %{l_prefix}/etc/mysql/my.cnf' \
+ '%config %{l_prefix}/etc/mysql/my.pwd' \
+ '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql'
+
+%files -f files
+
+%clean
+ rm -rf $RPM_BUILD_ROOT
+
+%pre
+ # before upgrade, save status and stop service
+ [ $1 -eq 2 ] || exit 0
+ eval `%{l_rc} mysql status 2>/dev/null | tee %{l_tmpfile}`
+ %{l_rc} mysql stop 2>/dev/null
+ exit 0
+
+%post
+ if [ $1 -eq 1 ]; then
+ # after install, create initial database
+ $RPM_INSTALL_PREFIX/bin/mysql_install_db \
+ --defaults-file=$RPM_INSTALL_PREFIX/etc/mysql/my.cnf
+ chown %{l_rusr}:%{l_rgrp} \
+ $RPM_INSTALL_PREFIX/etc/mysql/my.cnf \
+ $RPM_INSTALL_PREFIX/etc/mysql/my.pwd
+ chown -R %{l_rusr}:%{l_rgrp} $RPM_INSTALL_PREFIX/var/mysql/*
+ ( echo "The MySQL package includes automated maintenance procedures"
+ echo "that require administrator access to the database. For this"
+ echo "to work you must keep a copy (plain text) of the administrator"
+ echo "account in '$RPM_INSTALL_PREFIX/etc/mysql/my.pwd'."
+ ) | %{l_rpmtool} msg -b -t notice
+ fi
+ if [ $1 -eq 2 ]; then
+ # after upgrade, restore status
+ { eval `cat %{l_tmpfile}`; rm -f %{l_tmpfile}; true; } >/dev/null 2>&1
+ [ ".$mysql_active" = .yes ] && %{l_rc} mysql start
+ fi
+ exit 0
+
+%preun
+ # before erase, stop service and remove log files
+ [ $1 -eq 0 ] || exit 0
+ %{l_rc} mysql stop 2>/dev/null
+ rm -f $RPM_INSTALL_PREFIX/var/mysql/*.log* >/dev/null 2>&1 || true
+ rm -f $RPM_INSTALL_PREFIX/var/mysql/*.err* >/dev/null 2>&1 || true
+ exit 0
+
@@ .
patch -p0 <<'@@ .'
Index: openpkg-src/mysql41/rc.mysql
============================================================================
$ cvs diff -u -r0 -r1.1 rc.mysql
--- /dev/null 2004-01-05 15:44:26.000000000 +0100
+++ rc.mysql 2004-01-05 15:44:26.000000000 +0100
@@ -0,0 +1,98 @@
[EMAIL PROTECTED]@/lib/openpkg/bash @l_prefix@/etc/rc
+##
+## rc.mysql -- Run-Commands
+##
+
+%config
+ mysql_enable="$openpkg_rc_def"
+ [EMAIL PROTECTED]@/etc/mysql/my.pwd
+ [EMAIL PROTECTED]@/etc/mysql/my.cnf
+ mysql_common_prolog="true"
+ mysql_common_epilog="true"
+ mysql_common_numfiles="10"
+ mysql_common_minsize="1M"
+ mysql_common_complevel="9"
+ mysql_update_prolog="true"
+ mysql_update_epilog="true"
+ mysql_update_numfiles="10"
+ mysql_update_minsize="1M"
+ mysql_update_complevel="9"
+ mysql_err_prolog="true"
+ mysql_err_epilog="true"
+ mysql_err_numfiles="10"
+ mysql_err_minsize="1M"
+ mysql_err_complevel="9"
+
+%common
+ # same paths as in my.cnf
+ [EMAIL PROTECTED]@/var/mysql/mysqld.pid
+ [EMAIL PROTECTED]@/var/mysql/mysqld.err
+ [EMAIL PROTECTED]@/var/mysql/common.log
+ [EMAIL PROTECTED]@/var/mysql/update.log
+
+%status -u @l_rusr@ -o
+ mysql_usable="unknown"
+ mysql_active="no"
+ @l_prefix@/bin/mysqladmin \
+ --defaults-extra-file=${mysql_pwd_file} \
+ ping >/dev/null 2>&1 && mysql_active="yes"
+ if [ $mysql_active = "no" -a -f $mysql_pid_file ] ; then
+ kill -0 `cat $mysql_pid_file` && mysql_active="unknown"
+ fi
+ echo "mysql_enable=\"$mysql_enable\""
+ echo "mysql_usable=\"$mysql_usable\""
+ echo "mysql_active=\"$mysql_active\""
+
+%start -p 400 -u @l_rusr@
+ rcService mysql enable yes || exit 0
+ rcService mysql active yes && exit 0
+ cd @l_prefix@
+ @l_prefix@/bin/mysqld_safe >/dev/null 2>&1 \
+ [EMAIL PROTECTED]@ \
+ --pid-file="$mysql_pid_file" \
+ --err-log="$mysql_log_err" &
+
+%stop -p 400 -u @l_rusr@
+ rcService mysql enable yes || exit 0
+ rcService mysql active no && exit 0
+ @l_prefix@/bin/mysqladmin \
+ --defaults-extra-file=${mysql_pwd_file} \
+ flush-logs
+ @l_prefix@/bin/mysqladmin \
+ --defaults-extra-file=${mysql_pwd_file} \
+ shutdown
+
+%restart -p 400 -u @l_rusr@
+ rcService mysql enable yes || exit 0
+ rcService mysql active no && exit 0
+ rc mysql stop start
+
+%daily -u @l_susr@
+ rcService mysql enable yes || exit 0
+
+ # rotate logfiles
+ rcTmp -i
+ hintfile=`rcTmp -f -n hint`
+ shtool rotate -f \
+ -n ${mysql_common_numfiles} -s ${mysql_common_minsize} -d \
+ -z ${mysql_common_complevel} -m 660 -o @l_rusr@ -g @l_rgrp@ \
+ -P "${mysql_common_prolog}" \
+ -E "${mysql_common_epilog} && echo 1 >$hintfile" \
+ ${mysql_common_log}
+ shtool rotate -f \
+ -n ${mysql_update_numfiles} -s ${mysql_update_minsize} -d \
+ -z ${mysql_update_complevel} -m 660 -o @l_rusr@ -g @l_rgrp@ \
+ -P "${mysql_update_prolog}" \
+ -E "${mysql_update_epilog} && echo 1 >$hintfile" \
+ ${mysql_update_log}
+ shtool rotate -f \
+ -n ${mysql_err_numfiles} -s ${mysql_err_minsize} -d \
+ -z ${mysql_err_complevel} -m 660 -o @l_rusr@ -g @l_rgrp@ \
+ -P "${mysql_err_prolog}" \
+ -E "${mysql_err_epilog} && echo 1 >$hintfile" \
+ ${mysql_err_log}
+ if [ -s $hintfile ]; then
+ rc mysql restart
+ fi
+ rcTmp -k
+
@@ .
patch -p0 <<'@@ .'
Index: openpkg-web/news.txt
============================================================================
$ cvs diff -u -r1.7981 -r1.7982 news.txt
--- openpkg-web/news.txt 5 Jan 2004 14:18:17 -0000 1.7981
+++ openpkg-web/news.txt 5 Jan 2004 14:44:24 -0000 1.7982
@@ -1,3 +1,4 @@
+05-Jan-2004: New package: P<mysql41-4.1.1-20040105>
05-Jan-2004: Upgraded package: P<abiword-2.1.0-20040105>
05-Jan-2004: Upgraded package: P<mysql-4.0.17-20040105>
05-Jan-2004: Upgraded package: P<openpkg-20040105-20040105>
@@ .
______________________________________________________________________
The OpenPKG Project www.openpkg.org
CVS Repository Commit List [EMAIL PROTECTED]
