---
name: firebird-server
version: 2.1.5_1
origin: databases/firebird21-server
comment: Firebird-2 relational database (server)
arch: freebsd:9:x86:64
www: http://sourceforge.net/projects/firebird/
maintainer: acm@FreeBSD.org
prefix: /usr/local
licenselogic: single
flatsize: 5122753
desc: |
  Firebird is a relational database offering many ANSI SQL-99 features
  that runs on Linux, Windows, and a variety of Unix platforms.  Firebird
  offers excellent concurrency, high performance, and powerful language
  support for stored procedures and triggers.  It has been used in
  production systems, under a variety of names since 1981.

  Firebird is completely free of any registration, licensing or deployment
  fees.  It may be deployed freely for use with any third-party software,
  whether commercial or not.

  WWW: http://sourceforge.net/projects/firebird/
  WWW: http://www.firebirdsql.org/
deps:
  firebird-client: {origin: databases/firebird21-client, version: 2.1.5_1}
  icu: {origin: devel/icu, version: 50.1.2}
categories: [databases]
users: [firebird]
groups: [firebird]
files:
  /usr/local/bin/fb_inet_server: 30fe09032c21b98c5fd6e80627a7e78501eef7e77319cc14f1b6625475542fd2
  /usr/local/bin/fb_lock_mgr: ca11f307443b21a8f9bf5c67e32791d5db41bbf944ebe5de044c07c5e5477eda
  /usr/local/bin/fb_lock_print: 0ed3d1535ad9a436a71cbd6c08adb4551c96bdfff6efbdd9b588a50533fe3179
  /usr/local/bin/fbstat: 57a1f46391ed6c15bc30cea4cc07ff8589bb1d693e7359e7211cd7a3828bd3e9
  /usr/local/bin/gbak: 5b16662e9836f21a1e301045e923d15c542150b4a5059687a250240399504786
  /usr/local/bin/gdef: a99f872a61c7ef391cb53a17903df9d1c860877ae984915babee8831c30ccff8
  /usr/local/bin/gds_drop: 6c19906e453b1b1c538c91e0ae076bf16c7e07fafed42b7ee0d32055eaf83222
  /usr/local/bin/gfix: 283bbc58a712e0388767eb8d68fe37c21f6eda61a2397f1d8d279fadc1f0af80
  /usr/local/bin/gsec: 4c8e64dca69fa84a208c667862d2e96644102ad766eab3394dda3e58f8a372ac
  /usr/local/bin/nbackup: 275ab70e0446240e0c2ab3d6d8c67da605a4ddad64c0e8e2386182d5796a657d
  /usr/local/etc/firebird/aliases.conf.sample: 0556cee2b10dcb76e2250d541f4ca3f7665c2d5c315ce1bdbafb365379da56cc
  /usr/local/etc/firebird/fbintl.conf.sample: 6fd3ba77ff25d1031ca2ade0774df760de41a6c76723ab814f78ed2e9e21fa64
  /usr/local/libexec/firebird/intl/fbintl: b6e9b5dae7a42912fc28bf16337bb4029f4c3b85fd5631aebe419eff4c24a5d7
  /usr/local/libexec/firebird/udf/fbudf.so: 6b26d4a5691aea23a80a3dc79ba455d1e8a1f891e38042a7b0b652de9a940360
  /usr/local/libexec/firebird/udf/fbudf.sql: f560ec275c4fe9438c14abcbf31d98cc8cd61d5c07e06ce50f82499b39f97720
  /usr/local/libexec/firebird/udf/ib_udf.so: f9ae0f6d4713b81162de62e3535668e6671d7f2911d9c5a6067442dcc65cc1a0
  /usr/local/libexec/firebird/udf/ib_udf2.sql: 3253f86ab916b2635f960b5ddf6c320a0bd46198d2dbcf4eb261889bbbd3a60e
  /var/db/firebird/help/help.fdb: 1f40d5af000338b73001b4f882c2971893785a2d91a5fdc9b473040c4efeef39
  /var/db/firebird/security2.fdb.sample: b6adce6742a2b6f40944e5a5d97f348addbab6add52ec697e4aceee7a84fbd97
directories:
  /var/db/firebird/help/: n
  /var/db/firebird/: y
  /usr/local/libexec/firebird/udf/: n
  /usr/local/libexec/firebird/intl/: n
  /usr/local/libexec/firebird/: n
  /usr/local/etc/firebird/: y
scripts:
  post-install: |
    echo "===> Creating users and/or groups."
    if ! /usr/sbin/pw groupshow firebird >/dev/null 2>&1; then  echo "Creating group 'firebird' with gid '90'.";  /usr/sbin/pw groupadd firebird -g 90; else echo "Using existing group 'firebird'."; fi
    if ! /usr/sbin/pw usershow firebird >/dev/null 2>&1; then  echo "Creating user 'firebird' with uid '90'.";  /usr/sbin/pw useradd firebird -u 90 -g 90  -c "Firebird Database Administrator" -d /var/db/firebird -s /bin/sh;  else echo "Using existing user 'firebird'."; fi
    install -d -g 90 -o 90 /var/db/firebird
    [ -f /usr/local/etc/firebird/aliases.conf ] || cp /usr/local/etc/firebird/aliases.conf.sample /usr/local/etc/firebird/aliases.conf
    [ -f /usr/local/etc/firebird/aliases.conf ] || cp /usr/local/etc/firebird/fbintl.conf.sample /usr/local/etc/firebird/aliases.conf
    cd /
    [ -f //var/db/firebird/security2.fdb ] || cp //var/db/firebird/security2.fdb.sample //var/db/firebird/security2.fdb
  pre-deinstall: |
    (cmp -s /usr/local/etc/firebird/aliases.conf /usr/local/etc/firebird/aliases.conf.sample && rm -f /usr/local/etc/firebird/aliases.conf) || true
    (cmp -s /usr/local/etc/firebird/fbintl.conf /usr/local/etc/firebird/fbintl.conf.sample && rm -f /usr/local/etc/firebird/fbintl.conf) || true
    cd /
    (cmp -s //var/db/firebird/security2.fdb //var/db/firebird/security2.fdb.sample && rm -f //var/db/firebird/security2.fdb) || true
    [ -s //var/db/firebird/firebird.log ] || rm -f //var/db/firebird/firebird.log
    rm -f //var/db/firebird/isc_event1.`hostname` 2>/dev/null || true
    rm -f //var/db/firebird/isc_init1.`hostname` 2>/dev/null || true
    rm -f //var/db/firebird/isc_lock1.`hostname` 2>/dev/null || true
    if /usr/sbin/pw usershow firebird >/dev/null 2>&1; then  echo "==> You should manually remove the \"firebird\" user. "; fi
  post-deinstall: |
    cd /
  install: "#!/bin/sh\n\n# $FreeBSD: /tmp/pcvs/ports/databases/firebird21-server/files/pkg-install.in,v
    1.1 2010-12-20 09:05:05 acm Exp $\n\nPATH=/bin:/usr/bin:/usr/sbin\n\nbuildwarning()
    {\ncat <<EOF\n###############################################################################\n\n
    \                            ** IMPORTANT **\n\nKeep in mind that if you build
    firebird server as 'root', this may cause\nconflicts with SysV semaphores of running
    services.\n\nIf you want to cancel it, press ctrl-C now if you need check some
    things\nbefore of build it.\n\n###############################################################################\nEOF\n\tsleep
    5\n}\n\ncase $2 in\nPRE-INSTALL)\n\tbuildwarning\n;;\n\nPOST-INSTALL)\ncd /var/db/firebird\n\n#
    Lock files\n\nfor i in isc_init1 isc_lock1 isc_event1\ndo\n\tFileName=$i.`hostname`\n\ttouch
    $FileName\n\tchmod uga=rw $FileName\n\tchown firebird:firebird $FileName\ndone\n\ntouch
    firebird.log\nchown firebird:firebird firebird.log security2.fdb\n\n;;\n\nesac\n"
message: "###############################################################################\n\nFirebird
  was installed.\n\n1) Before start the server ensure that the following line exists
  in /etc/services:\n\ngds_db\t\t3050/tcp  #InterBase Database Remote Protocol\n\n2)
  If you use inetd then add the following line to /etc/inetd.conf\n\ngds_db\tstream\ttcp\tnowait\tfirebird\t/usr/local/bin/fb_inet_server
  \ fb_inet_server\n\nAnd finally restart inetd.\n\n3) It is STRONGLY recommended
  that you change the SYSDBA\npassword with:\n\n%25 gsec -user SYSDBA -pass masterkey\nGSEC>
  modify SYSDBA -pw newpassword\nGSEC> quit\n\nbefore doing anything serious with
  Firebird.\n\n4) See documentation in /usr/local/share/doc/firebird/ for more information.\n5)
  Enjoy it ;)\n\n################################################################################\n"
