-function check_user_and_db()
-{
- CREATED=
- # confirm user is present or create it
- user_present=$( psql -U postgres -c "select * from pg_user;" -d template1 | grep $ZABBIX_DB_USER )
- if [ -z $user_present ] ; then
- createuser --no-superuser --no-createdb --no-createrole --login --unencrypted --echo $ZABBIX_DB_USER -U postgres
- CREATED="true"
- fi
-
- # confirm database is present or create it
- db_present=$( psql -U postgres -c "select * from pg_database;" -d template1 | grep $ZABBIX_DB_NAME )
- if [ -z $db_present ] ; then
- createdb --owner=$ZABBIX_DB_USER $ZABBIX_DB_NAME -U postgres
- CREATED="true"
- fi
-
- # Create/update the unprivileged database user and password
- if [ -z "$PLC_MONITOR_DBPASSWORD" ] ; then
- # Zabbix doesn't like plain uuidgen passwords
- PLC_MONITOR_DBPASSWORD=$( uuidgen | md5sum - | awk '{print $1}' )
- plc-config --category=plc_monitor --variable=dbpassword --value="$PLC_MONITOR_DBPASSWORD" --save=$local_config $local_config
- service plc reload
- CREATED="true"
- fi
- if [ -n "$CREATED" ] ; then
- psql -d template1 -U postgres -c "ALTER USER $ZABBIX_DB_USER WITH PASSWORD '$PLC_MONITOR_DBPASSWORD';"
- fi
-}
-
-function if_present_load ()
-{
- file=$1
- if [ -f $file ] ; then
- psql -d $ZABBIX_DB_NAME -U $ZABBIX_DB_USER < $file
- fi
-}
-
-function check_schema_and_data()
-{
- schema_present=$( psql -U $ZABBIX_DB_USER $ZABBIX_DB_NAME -c "\d;" < /dev/null | grep hosts )
- if [ -z $schema_present ] ; then
- echo "... initial import can take SEVERAL minutes. please wait ..."
- if_present_load "/usr/local/zabbix/misc/create/schema/postgresql.sql"
- if_present_load "/usr/local/zabbix/misc/create/data/data.sql"
- if_present_load "/usr/local/zabbix/misc/create/data/images_pgsql.sql"
- ## TODO: update ZABBIX Server entry, "update hosts set status=0, host='MyPLC Server' where hostid=10017"
- fi
-}