openpkg-packages/cockroach/cockroach.spec

##
##  cockroach.spec -- OpenPKG RPM Package Specification
##  Copyright (c) 2000-2017 OpenPKG Foundation e.V. <http://openpkg.net/>
##
##  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_cockroach_base 1.0.6
%define       V_cockroach_snap 20170921

#   package information
Name:         cockroach
Summary:      Scalable, Geo-Replicated, Transactional SQL Database
URL:          http://www.cockroachlabs.com/
Vendor:       Spencer Kimball & Peter Mattis
Packager:     OpenPKG Foundation e.V.
Distribution: OpenPKG Community
Class:        EVAL
Group:        Database
License:      Apache
Version:      %{V_cockroach_base}.%{V_cockroach_snap}
Release:      20170921

#   list of sources
Source0:      http://download.openpkg.org/components/versioned/cockroach/cockroach-%{V_cockroach_snap}.tar.xz
Source1:      rc.cockroach
Source2:      cockroach-sql.sh
Source3:      cockroach-psql.sh
Source4:      cockroach-cert.sh
Source5:      cockroach-user.sh
Source6:      cockroach-haproxy.cfg
Patch0:       cockroach.patch

#   build information
BuildPreReq:  OpenPKG, openpkg >= 20160101, go, pkgconfig, cmake
PreReq:       OpenPKG, openpkg >= 20160101
BuildPreReq:  lzo, zlib
PreReq:       lzo, zlib

%description
    CockroachDB is a distributed SQL database built on top of the
    transactional and consistent key/value store RocksDB. The primary
    design goals are support for ACID transactions, horizontal
    scalability, and survivability, hence the name. CockroachDB uses
    the RAFT consensus algorithm for consistency across its nodes.
    CockroachDB aims to tolerate disk, machine, rack, and even
    datacenter failures with minimal latency disruption and no manual
    intervention. CockroachDB nodes are symmetric; a design goal is
    homogenous deployment with minimal configuration. CockroachDB
    speaks the PostgreSQL wire protocol and hence can be used with
    any PostgreSQL client. CockroachDB supports many PostgreSQL SQL
    functionalities, too.

%track
    prog cockroach:release = {
        version   = %{V_cockroach_base}
        url       = https://github.com/cockroachdb/cockroach/releases
        regex     = v(\d+\.\d+\.\d+)\.tar\.gz
    }
    prog cockroach:snapshot = {
        version   = %{V_cockroach_snap}
        url       = http://download.openpkg.org/components/versioned/cockroach/
        regex     = cockroach-(__VER__)\.tar\.xz
    }

%prep
    %setup -q -n cockroach
    %patch -p0

%build
    #   build program
    export GOPATH=`pwd`
    export CGO_CFLAGS="%{l_cflags} -Wno-deprecated-declarations"
    export CGO_CXXFLAGS="%{l_cxxflags} -Wno-deprecated-declarations"
    export CGO_LDFLAGS="%{l_ldflags} -lstdc++ -lm"
    export GOFLAGS="-x"
    export CC="%{l_cc}"
    export CFLAGS="%{l_cflags -O}"
    export CPPFLAGS="%{l_cppflags}"
    export LDFLAGS="%{l_ldflags}"
    cd src/github.com/cockroachdb/cockroach
    %{l_make} %{l_mflags} build

    #   build manual pages
    ./cockroach gen man

    #   build bash autocomplete script
    ./cockroach gen autocomplete

%install
    #   create directory hierarchy
    %{l_shtool} mkdir -f -p -m 755 \
        $RPM_BUILD_ROOT%{l_prefix}/bin \
        $RPM_BUILD_ROOT%{l_prefix}/man/man1 \
        $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d \
        $RPM_BUILD_ROOT%{l_prefix}/etc/cockroach \
        $RPM_BUILD_ROOT%{l_prefix}/var/cockroach/log \
        $RPM_BUILD_ROOT%{l_prefix}/var/cockroach/run \
        $RPM_BUILD_ROOT%{l_prefix}/var/cockroach/db

    #   install program
    %{l_shtool} install -c -s -m 755 \
        src/github.com/cockroachdb/cockroach/cockroach \
        $RPM_BUILD_ROOT%{l_prefix}/bin/cockroach

    #   install wrapper scripts
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        %{SOURCE cockroach-sql.sh} \
        $RPM_BUILD_ROOT%{l_prefix}/bin/cockroach-sql
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        %{SOURCE cockroach-psql.sh} \
        $RPM_BUILD_ROOT%{l_prefix}/bin/cockroach-psql
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        %{SOURCE cockroach-cert.sh} \
        $RPM_BUILD_ROOT%{l_prefix}/bin/cockroach-cert
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        %{SOURCE cockroach-user.sh} \
        $RPM_BUILD_ROOT%{l_prefix}/bin/cockroach-user

    #   install manual pages
    %{l_shtool} install -c -m 644 \
        src/github.com/cockroachdb/cockroach/man/man1/*.1 \
        $RPM_BUILD_ROOT%{l_prefix}/man/man1/

    #   install bash autocomplete script
    %{l_shtool} install -c -m 644 \
        src/github.com/cockroachdb/cockroach/cockroach.bash \
        $RPM_BUILD_ROOT%{l_prefix}/etc/cockroach/

    #   install haproxy configuration
    %{l_shtool} install -c -m 644 \
        %{SOURCE cockroach-haproxy.cfg} \
        $RPM_BUILD_ROOT%{l_prefix}/etc/cockroach/

    #   install run-command script
    %{l_shtool} install -c -m 755 %{l_value -s -a} \
        %{SOURCE rc.cockroach} $RPM_BUILD_ROOT%{l_prefix}/etc/rc.d/

    #   determine installation files
    %{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
        %{l_files_std} \
        '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/etc/cockroach' \
        '%config %attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/etc/cockroach/*' \
        '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/cockroach/*'

%files -f files

%clean

%post
    if [ $1 -eq 1 ]; then
        #   on initial installation, create database and certs/keys
        echo "Generating Certificates/Keys" | %{l_rpmtool} msg -b -t notice
        $RPM_INSTALL_PREFIX/bin/cockroach-cert ca
        $RPM_INSTALL_PREFIX/bin/cockroach-cert server localhost 127.0.0.1
        $RPM_INSTALL_PREFIX/bin/cockroach-cert client root

        #   display some initial hints, too
        ( echo "An initial CockroachDB was configured with the standard"
          echo "certificate/key pairs. You can start CockroachDB and connect"
          echo "to it on \"localhost\" with database user \"root\":"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/openpkg rc cockroach start"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-sql root 127.0.0.1 system"
          echo ""
          echo "For production use, you can reconfigure it to listen on external"
          echo "IP address. But for this the server certificate has to be regenerated:"
          echo "    \$ vi $RPM_INSTALL_PREFIX/etc/rc.conf"
          echo "    | cockroach_flags=\"--host=<ipaddress> --port=26257"
          echo "    | --http-host=<ipaddress> --http-port=8080\""
          echo "    \$ rm -f $RPM_INSTALL_PREFIX/etc/cockroach/node.{crt,key}"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-cert server <ipaddress>"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/openpkg rc cockroach stop start"
          echo "Then you have to connect through the external IP address from now on:"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-sql root <ipaddress> system"
          echo ""
          echo "For production use, you usually also want to establish a non-privileged"
          echo "user with a dedicated database:"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-cert client <username>"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-user root set <username> --password"
          echo "    | Enter password:   <password>"
          echo "    | Confirm password: <password>"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-sql root <ipaddress> system"
          echo "    | CREATE DATABASE <database>;"
          echo "    | GRANT ALL ON DATABASE <database> TO <username>;"
          echo "    | \\q"
          echo "After this, user <username> can connect with the CockroachDB CLI:"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-sql <username> <ipaddress> <database>"
          echo "Alternatively, you can also use the more convenient PostgreSQL psql(1) CLI:"
          echo "    \$ $RPM_INSTALL_PREFIX/bin/cockroach-psql <username> <ipaddress> <database>"
          echo ""
          echo "The CockroachDB admin interface you can reach under URL:"
          echo "    https://<ipaddress>:8080/"
          echo "CockroachDB uses the PostgreSQL protocol. The connection string is:"
          echo "    postgresql://<username>@<ipaddress>:26257/<database>?sslmode=require&%{l_nil}"
          echo "    sslcert=$RPM_INSTALL_PREFIX/etc/cockroach/client.root.crt&%{l_nil}"
          echo "    sslkey=$RPM_INSTALL_PREFIX/etc/cockroach/client.root.key"
        ) | %{l_rpmtool} msg -b -t notice
    elif [ $1 -eq 2 ]; then
        #   after upgrade, restart service
        eval `%{l_rc} cockroach status 2>/dev/null`
        [ ".$cockroach_active" = .yes ] && %{l_rc} cockroach restart
    fi
    exit 0

%preun
    #   before erase, stop service and remove log files
    if [ $1 -eq 0 ]; then
        %{l_rc} cockroach stop 2>/dev/null
        rm -f  $RPM_INSTALL_PREFIX/etc/cockroach/*.crt >/dev/null 2>&1 || true
        rm -f  $RPM_INSTALL_PREFIX/etc/cockroach/*.key >/dev/null 2>&1 || true
        rm -f  $RPM_INSTALL_PREFIX/var/cockroach/log/* >/dev/null 2>&1 || true
        rm -f  $RPM_INSTALL_PREFIX/var/cockroach/run/* >/dev/null 2>&1 || true
        rm -rf $RPM_INSTALL_PREFIX/var/cockroach/db/*  >/dev/null 2>&1 || true
    fi
    exit 0