.......... [ZBXNEXT-826] this script is not used since 2.2 appliance, removing

7 files changed, 0 insertions, 299 deletions

diff --git a/misc/appliance/create_data/create_data_sql/create_data_sql.sh b/misc/appliance/create_data/create_data_sql/create_data_sql.sh
deleted file mode 100755
index 947936b0d32..00000000000
--- a/misc/appliance/create_data/create_data_sql/create_data_sql.sh
+++ /dev/null
@@ -1,274 +0,0 @@
-#!/bin/bash
-
-# TODO for 2.0:
-# what to do for host_inventory if inventory_mode=1 (automatic) ?
-
-# screens - items, graphs, custom graphs
-# items-graphs
-# maps - triggers
-# triggers-functions
-# triggers-functions-items (can't be handled currently)
-# trigger deps - not needed
-# items - graph ymax/min id
-
-# don't add active network discovery or autoreg rules (hosts won't be skipped)
-
-
-# This script can be used to create data.sql from a database.
-# It creates sql file that is suitable for importing on top of schema.sql.
-# INSERT statements refer to fields by name to avoid field ordering problems,
-#  and only fields whose content differs from the default are included in the
-#  resulting file.
-#
-# Only accepted parameter currently is database name. If omitted, 'zabbix' is
-#  used. Resulting SQL is stored in FINALFILE file.
-#
-# This script must be run as a user that has write access to files created by
-#  MySQL server user.
-#
-# Only tables listed are considered for data retrieval, and there is support for
-#  additional finetuning:
-#
-# 1. Blacklist by field
-#    Blacklist by field support allows to specify which fields should never be
-#     dumped from the specified tables. This is mostly used to exclude runtime
-#     data like last value, status or error messages. Blacklist entries are
-#     specified in BLACKLISTFILE file. Each line contains space separated:
-#         table field1 field2 field3...
-#
-#    Adding a hash mark (#) in front of the line will indicate that it is a
-#     comment.
-#
-# 2. Blacklist by value
-#    Blacklist by value support allows to exclude rows based on a value of a
-#     specific field. Currently used to exclude low level discovery created
-#     entities. Blacklist entries are specified in BLACKLISTVALFILE file. Each
-#     line contains space separated:
-#         table field value1 value2 value3...
-#
-#    Adding a hash mark (#) in front of the line will indicate that it is a
-#     comment.
-
-# 3. Filter
-#    Filter allows to dump only specific entries from some tables. This is
-#     currently used to dump only interesting entries from the 'profiles' table.
-#    Filter entries are specified in FILTERFILE file. Each line contains space
-#     separated:
-#         table field value1 value2 value3...
-#
-#    From table 'table' only those entries will be dumped where 'field' is
-#     one of values.
-#    Adding a hash mark (#) in front of the line will indicate that it is a
-#     comment.
-#
-# 4. Pre-dump hook
-#    Pre-dump hook allows to execute a query right before dumping as specific
-#     table.
-#    Pre-dump hook entries are specified in PREDUMPHOOKFILE file. Each line
-#     contains space separated:
-#         table query
-#
-#    There is a possible race condition between executing the pre-dump hook and
-#     dumping the table. This feature should not be used for critical changes at
-#     this time.
-#    Adding a hash mark (#) in front of the line will indicate that it is a
-#     comment.
-#
-# 5. Extra clause
-#    Extra clause may be added for a specific table. Extra clauses are specified
-#     in EXTRACLAUSEFILE file.
-#    Adding a hash mark (#) in front of the line will indicate that it is a
-#     comment.
-
-# Do not make configuration changes to the database while running this script.
-
-DB=${1:-zabbix}
-MYSQLLINE="mysql -N $DB"
-TMPFILE=/tmp/data_sql_tmp_dump.sql
-FINALFILE=final_data.sql
-BLACKLISTFILE=data_sql_blacklist.txt
-BLACKLISTVALFILE=data_sql_blacklistbyval.txt
-BLACKLISTVALREFFILE=data_sql_blacklistbyval_ref.txt
-FILTERFILE=data_sql_filter.txt
-EXTRACLAUSEFILE=data_sql_extraclause.txt
-PREDUMPHOOKFILE=data_sql_predumphooks.txt
->"$FINALFILE"
-
-fail() {
-	echo $1
-	exit 1
-}
-
-[[ -f "$BLACKLISTFILE" ]] || echo "warning - blacklist file $BLACKLISTFILE not found"
-
-#UTILS="mysql strings awk cut sed"
-
-[[ "$2" ]] && {
-	TABLES="$2"
-} || {
-# table ordering follows original schema
-TABLES="slideshows \
-slides \
-drules \
-dchecks \
-services_times \
-users \
-hosts \
-groups \
-actions \
-operations \
-opmessage \
-opmessage_grp \
-opmessage_usr \
-opcommand \
-opcommand_hst \
-opcommand_grp \
-opgroup \
-optemplate \
-opconditions \
-conditions \
-usrgrp \
-config \
-triggers \
-valuemaps \
-interface \
-items \
-functions \
-graphs \
-graph_discovery \
-graphs_items \
-graph_theme \
-help_items \
-applications \
-httptest \
-httpstep \
-httpstepitem \
-httptestitem \
-globalmacro \
-hostmacro \
-hosts_groups \
-host_inventory \
-hosts_templates \
-item_discovery \
-items_applications \
-mappings \
-media \
-media_type \
-profiles \
-rights \
-scripts \
-screens \
-screens_items \
-services \
-services_links \
-sysmaps_links \
-sysmaps_link_triggers \
-sysmaps \
-sysmaps_elements \
-sysmap_element_url \
-sysmap_url \
-trigger_discovery \
-trigger_depends \
-users_groups \
-maintenances \
-maintenances_hosts \
-maintenances_groups \
-maintenances_windows \
-timeperiods \
-regexps \
-expressions \
-icon_map \
-icon_mapping"
-# nodes \ - after httptestitem in original schema
-}
-
-for TABLE in $TABLES; do
-	while read line; do
-		FIELD=$(echo $line | cut -d" " -f1)
-		DEFAULT=$(echo $line | cut -d" " -f2-)
-		[[ $(echo "select $FIELD from $TABLE;" | $MYSQLLINE | sed "/^$DEFAULT$/ d") ]] && {
-			# at least one entry differs from the default
-			DIFFERENT_FIELDS="$DIFFERENT_FIELDS,$FIELD"
-		}
-	done < <(echo "show columns from $TABLE;" | $MYSQLLINE -t | awk '{FS="|"}; {print $2,$6}' | strings | awk '{print $1,$2}')
-	[[ "$DIFFERENT_FIELDS" ]] && {
-		# --- blacklist by field file must have table name, followed by blacklisted fields - all space separated
-		BLACKLIST=$(grep -v ^# "$BLACKLISTFILE" 2>/dev/null | grep $TABLE 2>/dev/null)
-		[[ "$BLACKLIST" ]] && {
-			BLACKFIELDS=$(echo $BLACKLIST | cut -d" " -f2-)
-			for BLACKFIELD in $BLACKFIELDS; do
-				DIFFERENT_FIELDS=$(echo "$DIFFERENT_FIELDS" | sed "s/,${BLACKFIELD}\($\|,\)/\1/")
-			done
-		}
-
-		# --- blacklist by value file must have table name, followed by the field to blacklist on, then followed by values to match - all space separated
-		BLACKLISTBYVAL=$(grep -v ^# "$BLACKLISTVALFILE" 2>/dev/null | grep $TABLE 2>/dev/null)
-		[[ "$BLACKLISTBYVAL" ]] && {
-			BLACKLISTBYVALFIELD=$(echo $BLACKLISTBYVAL | cut -d" " -f2)
-			BLACKLISTBYVALVALUES=$(echo $BLACKLISTBYVAL | cut -d" " -f3-)
-			for BLACKLISTBYVALVALUE in $BLACKLISTBYVALVALUES; do
-				FINALBLACKLISTBYVALVALUE="$FINALBLACKLISTBYVALVALUE,$BLACKLISTBYVALVALUE"
-			done
-			FINALBLACKLISTBYVALVALUE="where $BLACKLISTBYVALFIELD not in (${FINALBLACKLISTBYVALVALUE#,})"
-		}
-
-		# --- blacklist by referenced value file must have table name, followed by the field to do the lookup, followed by the field to match in the other table, followed by the table do do the lookup in, then followed by the field to blacklist on, then followed by values to match - all space separated
-		BLACKLISTBYVALREF=$(grep -v ^# "$BLACKLISTVALREFFILE" 2>/dev/null | grep $TABLE 2>/dev/null)
-		[[ "$BLACKLISTBYVALREF" ]] && {
-			BLACKLISTBYVALREFFIELD=$(echo $BLACKLISTBYVALREF | cut -d" " -f2)
-			BLACKLISTBYVALREFFIELDMATCH=$(echo $BLACKLISTBYVALREF | cut -d" " -f3)
-			BLACKLISTBYVALREFTABLE=$(echo $BLACKLISTBYVALREF | cut -d" " -f4)
-			BLACKLISTBYVALREFTABLEFIELD=$(echo $BLACKLISTBYVALREF | cut -d" " -f5)
-			BLACKLISTBYVALREFVALUES=$(echo $BLACKLISTBYVALREF | cut -d" " -f6-)
-			for BLACKLISTBYVALREFVALUE in $BLACKLISTBYVALREFVALUES; do
-				FINALBLACKLISTBYVALREFVALUE="$FINALBLACKLISTBYVALREFVALUE,$BLACKLISTBYVALREFVALUE"
-			done
-			FINALBLACKLISTBYVALREFVALUE="where $BLACKLISTBYVALREFFIELD not in (select $BLACKLISTBYVALREFFIELDMATCH from $BLACKLISTBYVALREFTABLE where $BLACKLISTBYVALREFTABLEFIELD in (${FINALBLACKLISTBYVALREFVALUE#,}))"
-		}
-
-		# --- filter file must have table name, followed by field to filter on, then followed by values to match - all space separated
-		FILTER=$(grep -v ^# "$FILTERFILE" 2>/dev/null | grep $TABLE 2>/dev/null)
-		[[ "$FILTER" ]] && {
-			FILTERFIELD=$(echo $FILTER | cut -d" " -f2)
-			FILTERVALUES=$(echo $FILTER | cut -d" " -f3-)
-			for FILTERVALUE in $FILTERVALUES; do
-				FINALFILTER="$FINALFILTER or $FILTERFIELD='$FILTERVALUE'"
-			done
-			FINALFILTER="where ${FINALFILTER# or }"
-		}
-
-		# --- extra clause file must have table name, followed by the clause itself (like ODRER BY), space separated
-		EXTRACLAUSE=$(grep -v ^# "$EXTRACLAUSEFILE" 2>/dev/null | grep $TABLE 2>/dev/null | cut -d" " -f2-)
-
-		echo "
---
--- Dumping data for table \`$TABLE\`
---
-" >> "$FINALFILE"
-
-		# pre-dump hook to update possibly out of order values in current database
-		# it's still possible that server would change them right after fixing & before dump,
-		#  but that's a smaller chance
-		HOOKLINE=$(grep ^$TABLE $PREDUMPHOOKFILE)
-		[[ "$HOOKLINE" ]] && {
-			HOOK=$(echo "$HOOKLINE" | cut -d" " -f2-)
-			echo "$HOOK" | $MYSQLLINE
-			unset HOOKLINE
-		}
-
-		echo "select ${DIFFERENT_FIELDS#,} from $TABLE $FINALFILTER $EXTRACLAUSE into outfile '$TMPFILE' \
-FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY \"'\";" | $MYSQLLINE || fail "select failed"
-
-		# "into outfile" does not replace newlines with \r\n, thus we just replace them with sed
-		sed -i 's/\r/\\r/g' "$TMPFILE"
-		while grep '\\$' "$TMPFILE" > /dev/null; do
-			sed -i '/\\$/ {N; s/\\\n/\\n/g}' "$TMPFILE"
-		done
-
-		# $TMPFILE is created by mysql user - this script thus has to be run either as that user, or root
-		sed -i "s/\(.*\)/insert into $TABLE (${DIFFERENT_FIELDS#,}) values (\1);/" "$TMPFILE"
-		cat "$TMPFILE" >> "$FINALFILE"
-		rm "$TMPFILE" || fail "can't remove $TMPFILE"
-	}
-	unset DIFFERENT_FIELDS FILTER BLACKLIST FINALFILTER
-done
diff --git a/misc/appliance/create_data/create_data_sql/data_sql_blacklist.txt b/misc/appliance/create_data/create_data_sql/data_sql_blacklist.txt
deleted file mode 100644
index 6de47a78fa3..00000000000
--- a/misc/appliance/create_data/create_data_sql/data_sql_blacklist.txt
+++ /dev/null
@@ -1,8 +0,0 @@
-# comments can be prefixed like this.
-# each line starts with table name, then blacklisted fields - all separated by spaces
-drules nextcheck
-hosts disable_until error available errors_from lastaccess ipmi_disable_until ipmi_available snmp_disable_until snmp_available maintenanceid maintenance_status maintenance_type maintenance_from ipmi_errors_from snmp_errors_from ipmi_error snmp_error jmx_disable_until jmx_available jmx_errors_from jmx_error
-httptest lastcheck nextcheck curstate curstep lastfailedstep error time
-items lastvalue lastclock prevvalue prevorgvalue error lastlogsize mtime lastns
-triggers value lastchange error value_flags
-users attempt_failed attempt_ip attempt_clock
diff --git a/misc/appliance/create_data/create_data_sql/data_sql_blacklistbyval.txt b/misc/appliance/create_data/create_data_sql/data_sql_blacklistbyval.txt
deleted file mode 100644
index 83a08b0b3ee..00000000000
--- a/misc/appliance/create_data/create_data_sql/data_sql_blacklistbyval.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-items flag 4
-triggers flag 4
-graphs flag 4
diff --git a/misc/appliance/create_data/create_data_sql/data_sql_blacklistbyval_ref.txt b/misc/appliance/create_data/create_data_sql/data_sql_blacklistbyval_ref.txt
deleted file mode 100644
index 07d6f83074e..00000000000
--- a/misc/appliance/create_data/create_data_sql/data_sql_blacklistbyval_ref.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-graphs_items graphid graphid graphs flags 4
-items_applications itemid itemid items flags 4
-functions triggerid triggerid triggers flags 4
diff --git a/misc/appliance/create_data/create_data_sql/data_sql_extraclause.txt b/misc/appliance/create_data/create_data_sql/data_sql_extraclause.txt
deleted file mode 100644
index 19bf30348b7..00000000000
--- a/misc/appliance/create_data/create_data_sql/data_sql_extraclause.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-triggers order by triggerid>templateid
-items order by itemid>templateid
-graphs order by graphid>templateid
diff --git a/misc/appliance/create_data/create_data_sql/data_sql_filter.txt b/misc/appliance/create_data/create_data_sql/data_sql_filter.txt
deleted file mode 100644
index 5b6ad767d9a..00000000000
--- a/misc/appliance/create_data/create_data_sql/data_sql_filter.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-# table field value1 value2...
-# we filter profiles table to only grab favourites from it
-profiles idx web.favorite.graphids web.favorite.screenids web.favorite.sysmapids web.messages
diff --git a/misc/appliance/create_data/create_data_sql/data_sql_predumphooks.txt b/misc/appliance/create_data/create_data_sql/data_sql_predumphooks.txt
deleted file mode 100644
index e7776b1fc51..00000000000
--- a/misc/appliance/create_data/create_data_sql/data_sql_predumphooks.txt
+++ /dev/null
@@ -1,5 +0,0 @@
-# format : table query
-
-# if some item in the master config database has became unsupported (maybe
-#  because the server does not support it in that version yet), enable it.
-items update items set status='0' where status='3';