- Update to 2.0.0 after repocopy from

  net-mgmt/zabbix-{agent,frontend,proxy,server} [1]
- Convert to optionsNG
- Remove the need for SQL patches by using REINPLACE
- Remove manual installation of config files.
- Change config include directories from dirrm to dirrmtry in
  pkg-plist - users may put files there.

PR:		ports/169153 [1]
Submitted by:	Pakhom Golynga <pakhom706@gmail.com> (maintainer)
Approved by:	flo (mentor)

2 files changed, 37 insertions, 18 deletions

diff --git a/net-mgmt/zabbix2-server/files/patch-create-data-data.sql b/net-mgmt/zabbix2-server/files/patch-create-data-data.sql
deleted file mode 100644
index 78be5949c224..000000000000
--- a/net-mgmt/zabbix2-server/files/patch-create-data-data.sql
+++ /dev/null
@@ -1,13 +0,0 @@
---- create/data/data.sql.orig	2011-08-04 09:48:23.785558036 -0500
-+++ create/data/data.sql	2011-08-04 09:48:41.277736192 -0500
-@@ -27,8 +27,8 @@
- -- Dumping data for table `scripts`
- --
- 
--INSERT INTO scripts VALUES (1,'Ping','/bin/ping -c 3 {HOST.CONN}',2,0,0);
--INSERT INTO scripts VALUES (2,'Traceroute','/usr/bin/traceroute {HOST.CONN}',2,0,0);
-+INSERT INTO scripts VALUES (1,'Ping','/sbin/ping -c 3 {HOST.CONN}',2,0,0);
-+INSERT INTO scripts VALUES (2,'Traceroute','/usr/sbin/traceroute {HOST.CONN}',2,0,0);
- 
- --
- -- Dumping data for table `users`
diff --git a/net-mgmt/zabbix2-server/files/pkg-message.in b/net-mgmt/zabbix2-server/files/pkg-message.in
index 754f2c90ce66..f08a1e5dac46 100644
--- a/net-mgmt/zabbix2-server/files/pkg-message.in
+++ b/net-mgmt/zabbix2-server/files/pkg-message.in
@@ -1,11 +1,43 @@
 ======================================================================
-Zabbix requires a database.  If you are using SQLite, one will be
-created automatically.  Otherwise you can install one as follows (<db>
-is your database engine and <db_client> is its client program):
+For Zabbix server and proxy daemons, as well as Zabbix frontend, a database is required. It is not needed to run Zabbix agent. 
+% cd %%DATADIR%%/%%ZABBIX_BUILD%%/database
+
+PostgreSQL: 
+shell> psql -U <username>
+psql> create database zabbix; 
+psql> \q 
+shell> cd database/postgresql
+shell> psql -U <username> zabbix < schema.sql
+shell> psql -U <username> zabbix < images.sql
+shell> psql -U <username> zabbix < data.sql
+
+MySQL: 
+shell> mysql -u<username> -p<password>
+mysql> create database zabbix character set utf8;
+mysql> quit;
+shell> mysql -u<username> -p<password> zabbix < database/mysql/schema.sql
+shell> mysql -u<username> -p<password> zabbix < database/mysql/images.sql
+shell> mysql -u<username> -p<password> zabbix < database/mysql/data.sql
+
+SQLite: 
+shell> cd database/sqlite3
+shell> sqlite3 /var/lib/sqlite/zabbix.db < schema.sql
+shell> sqlite3 /var/lib/sqlite/zabbix.db < images.sql
+shell> sqlite3 /var/lib/sqlite/zabbix.db < data.sql
+
+
+IBM DB2: 
+shell> db2 "create database zabbix using codeset utf-8 territory us pagesize 32768"
+shell> cd database/ibm_db2
+shell> db2batch -d zabbix -f schema.sql
+shell> db2batch -d zabbix -f images.sql
+shell> db2batch -d zabbix -f data.sql 
 
-% cd %%DATADIR%%/%%ZABBIX_BUILD%%/create
-% cat schema/<db>.sql data/data.sql data/images_<db>.sql | <db_client>
 
 To upgrade an existing database, see the scripts in
 %%DATADIR%%/%%ZABBIX_BUILD%%/upgrades.
+
+Please see http://www.zabbix.com/documentation/2.0/manual/installation/install for installation instructions.
+
+For use NMAP please edit sudoers
 ======================================================================