Ticket #42694: Portfile

# -*- coding: utf-8; mode: tcl; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- vim:fenc=utf-8:ft=tcl:et:sw=4:ts=4:sts=4
# $Id: Portfile 111353 2013-09-19 07:21:56Z ryandesign@macports.org $

PortSystem          1.0

name                simplerisk
version             20141129-001
categories          security
platforms           darwin
maintainers         yahoo.fr:jul_bsd openmaintainer
license             GPL-2

description         Enterprise Risk Management Simplified
long_description    ${description}

supported_archs     noarch

homepage            http://www.simplerisk.org/
## https://code.google.com/p/simplerisk/
master_sites        https://github.com/simplerisk/bundles/raw/master/:a \
                    https://github.com/simplerisk/database/raw/master/:d
#master_sites        googlecode ## No more updated since 201312
extract.suffix      .tgz
distfiles           ${distname}${extract.suffix}:a ${name}-en-${version}.sql:d

checksums           simplerisk-${version}.tgz \
                    rmd160  bb2143e779bb682ba0f98c060a132ee93e097073 \
                    sha256  6b334aafe1863426016b31058cb618ef6647da6e82e1a8a4987a1acfb8b4cd2d \
                    simplerisk-en-${version}.sql \
                    rmd160  b9ecbbbfe998548113689eff6e84618ab6dbb3cc \
                    sha256  c63f2ba8756a8e2bdf266c8adc9d8f9f120b0e1f435cefb6f41dbe413934b1f5

patchfiles          patch-includes-functions.php.diff patch-includes-config.php.diff

worksrcdir           ${name}

use_configure        no
build {}


set webroot          ${prefix}/www/${name}
destroot {
    copy ${worksrcpath} ${destroot}/${webroot}/
    copy ${distpath}/${name}-en-${version}.sql ${destroot}/${webroot}/

    xinstall -d -m 755 ${destroot}${prefix}/share/examples/${name}/
    copy ${filespath}/nginx-${name}.conf ${destroot}${prefix}/share/examples/${name}/nginx-${name}.conf.sample
}

post-activate {
    if ![file exists ${prefix}/etc/nginx/nginx-${name}.conf] {
        copy ${prefix}/share/examples/${name}/nginx-${name}.conf.sample ${prefix}/etc/nginx/nginx-${name}.conf
    }
}

notes "
**** To complete simplerisk installation ****

1) Install PHP and Mysql5 w extensions php*-mysql, php*-iconv, php*-mbstring
   Example:
        $ sudo port install php55-mysql php55-iconv php55-mbstring
2) Setup simplerisk database

   Configure MySQL (new MySQL installs)
        $ sudo -u mysql ${prefix}/lib/mysql5/bin/mysql_install_db

  Start MySQL:
        $ sudo ${prefix}/share/mysql5/mysql/mysql.server start
        (if problems, check mysql user has permissions on ${prefix}/var/db/mysql5)

   Set MySQL to start at system boot
        $ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist

   Set a root MySQL password.
        Follow the instructions that were given after you executed 'mysql_install_db' above
    Or execute ${prefix}/lib/mysql5/bin/mysql_secure_installation

   Create a simplerisk MySQL user and simplerisk database.
        $ mysql5 -u root -p (login with root password set above when prompted)
        mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON simplerisk.* to simplerisk@localhost;
        mysql> SET PASSWORD FOR simplerisk@localhost = PASSWORD('<my-simpleriskdb-pwd>');
        mysql> flush privileges;
        mysql> create database simplerisk;
        mysql> exit;

   Import the simplerisk database.
        $ cat ${webroot}/${name}-en-${version}.sql | mysql5 -u root -p simplerisk (simplerisk is the db name)

3) Edit ${webroot}/includes/config.php to match your MySQL information and url path.

4) Configure your webserver
    If Apache, Place a symlink for simplerisk inside your Apache document root.
        # ln -s ${webroot}  <Apache-docroot>/simplerisk

    If Nginx, include this file in your configuration,
    ${prefix}/etc/nginx/nginx-simplerisk.conf

5) Connect on http://127.0.0.1/simplerisk
    Default login/pass: admin/admin

"

livecheck.type      regex
livecheck.url       ${homepage}/downloads
livecheck.regex     "<td>(\\d+-\\d+)</td>"