From 0af17d28124558254094dffcf037056379db6e05 Mon Sep 17 00:00:00 2001 From: Mario Preksavec Date: Wed, 29 Apr 2015 21:31:53 +0700 Subject: network/sqlrelay: Added (DB Connection Management). Signed-off-by: Willy Sudiarto Raharjo --- network/sqlrelay/README | 7 +++ network/sqlrelay/README.SLACKWARE | 23 +++++++ network/sqlrelay/doinst.sh | 28 +++++++++ network/sqlrelay/slack-desc | 19 ++++++ network/sqlrelay/sqlrelay.SlackBuild | 118 +++++++++++++++++++++++++++++++++++ network/sqlrelay/sqlrelay.info | 10 +++ 6 files changed, 205 insertions(+) create mode 100644 network/sqlrelay/README create mode 100644 network/sqlrelay/README.SLACKWARE create mode 100644 network/sqlrelay/doinst.sh create mode 100644 network/sqlrelay/slack-desc create mode 100644 network/sqlrelay/sqlrelay.SlackBuild create mode 100644 network/sqlrelay/sqlrelay.info diff --git a/network/sqlrelay/README b/network/sqlrelay/README new file mode 100644 index 0000000000..aafdf2b8ac --- /dev/null +++ b/network/sqlrelay/README @@ -0,0 +1,7 @@ +With SQL Relay, you can speed up and enhance the scalability of database-driven +web-based applications, access databases from unsupported platforms, throttle +database access, distribute load over clustered or replicated databases, +route queries and migrate applications from one database to another. + +Two optional dependencies, postgresql and freetds will be auto detected at +build time, they can be found on SlackBuilds.org diff --git a/network/sqlrelay/README.SLACKWARE b/network/sqlrelay/README.SLACKWARE new file mode 100644 index 0000000000..b578fff249 --- /dev/null +++ b/network/sqlrelay/README.SLACKWARE @@ -0,0 +1,23 @@ +You may wish to add these lines to /etc/rc.d/rc.local to start the service: + +if [ -x /etc/rc.d/rc.sqlrcachemanager ]; then + /etc/rc.d/rc.sqlrcachemanager start +fi + +if [ -x /etc/rc.d/rc.sqlrelay ]; then + /etc/rc.d/rc.sqlrelayr start +fi + +You may also add these lines to /etc/rc.d/rc.local_shutdown: + +if [ -x /etc/rc.d/rc.sqlrelay ]; then + /etc/rc.d/rc.sqlrelayr stop +fi + +if [ -x /etc/rc.d/rc.sqlrcachemanager ]; then + /etc/rc.d/rc.sqlrcachemanager stop +fi + +Remember to give executable permission to /etc/rc.d/rc.local_shutdown: + + chmod 0755 /etc/rc.d/rc.local_shutdown diff --git a/network/sqlrelay/doinst.sh b/network/sqlrelay/doinst.sh new file mode 100644 index 0000000000..7722eb4e25 --- /dev/null +++ b/network/sqlrelay/doinst.sh @@ -0,0 +1,28 @@ +config() { + NEW="$1" + OLD="$(dirname $NEW)/$(basename $NEW .new)" + # If there's no config file by that name, mv it over: + if [ ! -r $OLD ]; then + mv $NEW $OLD + elif [ "$(cat $OLD | md5sum)" = "$(cat $NEW | md5sum)" ]; then + # toss the redundant copy + rm $NEW + fi + # Otherwise, we leave the .new copy for the admin to consider... +} + +preserve_perms() { + NEW="$1" + OLD="$(dirname $NEW)/$(basename $NEW .new)" + if [ -e $OLD ]; then + cp -a $OLD ${NEW}.incoming + cat $NEW > ${NEW}.incoming + mv ${NEW}.incoming $NEW + fi + config $NEW +} + +preserve_perms etc/rc.d/rc.sqlrelay.new +preserve_perms etc/rc.d/rc.sqlrcachemanager.new +config etc/sqlrelay/sqlrelay.xsd.new +config etc/sqlrelay/sqlrelay.dtd.new diff --git a/network/sqlrelay/slack-desc b/network/sqlrelay/slack-desc new file mode 100644 index 0000000000..d3c6984a64 --- /dev/null +++ b/network/sqlrelay/slack-desc @@ -0,0 +1,19 @@ +# HOW TO EDIT THIS FILE: +# The "handy ruler" below makes it easier to edit a package description. +# Line up the first '|' above the ':' following the base package name, and +# the '|' on the right side marks the last column you can put a character in. +# You must make exactly 11 lines for the formatting to be correct. It's also +# customary to leave one space after the ':' except on otherwise blank lines. + + |-----handy-ruler------------------------------------------------------| +sqlrelay: sqlrelay (a powerful database connection management solution) +sqlrelay: +sqlrelay: With SQL Relay, you can speed up and enhance the scalability of +sqlrelay: database-driven web-based applications, access databases from +sqlrelay: unsupported platforms, throttle database access, distribute load over +sqlrelay: clustered or replicated databases, route queries and migrate +sqlrelay: applications from one database to another. +sqlrelay: +sqlrelay: Homepage: http://sqlrelay.sourceforge.net/ +sqlrelay: +sqlrelay: diff --git a/network/sqlrelay/sqlrelay.SlackBuild b/network/sqlrelay/sqlrelay.SlackBuild new file mode 100644 index 0000000000..bdd0cec643 --- /dev/null +++ b/network/sqlrelay/sqlrelay.SlackBuild @@ -0,0 +1,118 @@ +#!/bin/sh + +# Slackware build script for sqlrelay + +# Copyright 2015 Mario Preksavec, Zagreb, Croatia +# All rights reserved. +# +# Redistribution and use of this script, with or without modification, is +# permitted provided that the following conditions are met: +# +# 1. Redistributions of this script must retain the above copyright +# notice, this list of conditions and the following disclaimer. +# +# THIS SOFTWARE IS PROVIDED BY THE AUTHOR "AS IS" AND ANY EXPRESS 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 AUTHOR 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. + +PRGNAM=sqlrelay +VERSION=${VERSION:-0.59} +BUILD=${BUILD:-1} +TAG=${TAG:-_SBo} + +if [ -z "$ARCH" ]; then + case "$( uname -m )" in + i?86) ARCH=i486 ;; + arm*) ARCH=arm ;; + *) ARCH=$( uname -m ) ;; + esac +fi + +CWD=$(pwd) +TMP=${TMP:-/tmp/SBo} +PKG=$TMP/package-$PRGNAM +OUTPUT=${OUTPUT:-/tmp} + +if [ "$ARCH" = "i486" ]; then + SLKCFLAGS="-O2 -march=i486 -mtune=i686" + LIBDIRSUFFIX="" +elif [ "$ARCH" = "i686" ]; then + SLKCFLAGS="-O2 -march=i686 -mtune=i686" + LIBDIRSUFFIX="" +elif [ "$ARCH" = "x86_64" ]; then + SLKCFLAGS="-O2 -fPIC" + LIBDIRSUFFIX="64" +else + SLKCFLAGS="-O2" + LIBDIRSUFFIX="" +fi + +set -e + +rm -rf $PKG +mkdir -p $TMP $PKG $OUTPUT +cd $TMP +rm -rf $PRGNAM-$VERSION +tar xvf $CWD/$PRGNAM-$VERSION.tar.gz +cd $PRGNAM-$VERSION +chown -R root:root . +find -L . \ + \( -perm 777 -o -perm 775 -o -perm 750 -o -perm 711 -o -perm 555 \ + -o -perm 511 \) -exec chmod 755 {} \; -o \ + \( -perm 666 -o -perm 664 -o -perm 640 -o -perm 600 -o -perm 444 \ + -o -perm 440 -o -perm 400 \) -exec chmod 644 {} \; + +CFLAGS="$SLKCFLAGS" \ +CXXFLAGS="$SLKCFLAGS" \ +./configure \ + --prefix=/usr \ + --libdir=/usr/lib${LIBDIRSUFFIX} \ + --sysconfdir=/etc/sqlrelay \ + --localstatedir=/var \ + --mandir=/usr/man \ + --with-perl-prefix=/usr \ + --with-perl-site-arch=/usr/lib${LIBDIRSUFFIX}/perl5 \ + --with-perl-site-lib=/usr/share/perl5 \ + --with-perl-install-man3-dir=/usr/man/man3 \ + --enable-static=no \ + --build=$ARCH-slackware-linux + +# There is only html documentation and --docdir doesn't work +sed -i "s/^\(docdir = \).*$/\1\${prefix}\/doc\/$PRGNAM-$VERSION\/html/" config.mk + +# Examples should also go to doc dir +sed -i "s/^\(EXAMPLEDIR = \).*$/\1\${prefix}\/doc\/$PRGNAM-$VERSION\/examples/" config.mk + +# It needs -j1 :-/ +make -j1 +make -j1 install DESTDIR=$PKG + +# Change SysV style init scripts to BSD run control style +mv $PKG/etc/init.d $PKG/etc/rc.d +(cd $PKG/etc/rc.d ; for i in * ; do mv $i rc.$i.new; done) + +for i in $PKG/etc/sqlrelay/sqlrelay.{xsd,dtd} ; do mv $i $i.new ; done + +find $PKG -print0 | xargs -0 file | grep -e "executable" -e "shared object" | grep ELF \ + | cut -f 1 -d : | xargs strip --strip-unneeded 2> /dev/null || true + +find $PKG/usr/man -type f -exec gzip -9 {} \; +for i in $( find $PKG/usr/man -type l ) ; do ln -s $( readlink $i ).gz $i.gz ; rm $i ; done + +mkdir -p $PKG/usr/doc/$PRGNAM-$VERSION +cp -a AUTHORS COPYING ChangeLog $CWD/README.SLACKWARE $PKG/usr/doc/$PRGNAM-$VERSION +cat $CWD/$PRGNAM.SlackBuild > $PKG/usr/doc/$PRGNAM-$VERSION/$PRGNAM.SlackBuild + +mkdir -p $PKG/install +cat $CWD/slack-desc > $PKG/install/slack-desc +cat $CWD/doinst.sh > $PKG/install/doinst.sh + +cd $PKG +/sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.${PKGTYPE:-tgz} diff --git a/network/sqlrelay/sqlrelay.info b/network/sqlrelay/sqlrelay.info new file mode 100644 index 0000000000..666922f435 --- /dev/null +++ b/network/sqlrelay/sqlrelay.info @@ -0,0 +1,10 @@ +PRGNAM="sqlrelay" +VERSION="0.59" +HOMEPAGE="http://sqlrelay.sourceforge.net/" +DOWNLOAD="http://downloads.sourceforge.net/sqlrelay/sqlrelay-0.59.tar.gz" +MD5SUM="afdc7049e01b25473193060a6e4309df" +DOWNLOAD_x86_64="" +MD5SUM_x86_64="" +REQUIRES="rudiments" +MAINTAINER="Mario Preksavec" +EMAIL="mario at slackware dot hr" -- cgit v1.2.3