improved post server setup code in Monitor.spec
[monitor.git] / monitor-server.init
index df00751..ee7c469 100644 (file)
 
 # Source function library and configuration
 . /etc/plc.d/functions
+. /etc/plc.d/monitor.functions
 . /etc/planetlab/plc_config
 local_config=/etc/planetlab/configs/site.xml
 
-MONITORPATH=/usr/share/monitor-server
+MONITORPATH=/usr/share/monitor
 
 # Be verbose
 set -x
@@ -30,81 +31,25 @@ pghba_conf=$PGDATA/pg_hba.conf
 export PGPORT=$PLC_DB_PORT
 
 
-ZABBIX_DB_USER="zabbixuser"
-ZABBIX_DB_NAME="zabbix"
+MONITOR_DB_USER="monitoruser"
+MONITOR_DB_NAME="monitor"
 
-function check_pg_hba ()
-{
-       #### SETUP ACCESS to this user and database
-       mkdir -p $PGDATA/pg_hba.conf.d
-       ZABCONF=$PGDATA/pg_hba.conf.d/zabbix.conf
-       if [ ! -f $ZABCONF ] ; then
-               echo "host $ZABBIX_DB_NAME $ZABBIX_DB_USER 127.0.0.1/32 password"   > $ZABCONF
-               echo "host $ZABBIX_DB_NAME $ZABBIX_DB_USER $PLC_MONITOR_IP/32 password" >> $ZABCONF
-
-               # NOTE: restart db to enable access by users granted above.
-               service plc restart posgresql
-       fi
-}
+WROTE_PG_CONFIG=
 
-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
-}
+if [ -z "$PLC_MONITOR_IP" ] ; then
+       PLC_MONITOR_IP=$( gethostbyname $PLC_MONITOR_HOST )
+fi
 
-function check_schema_and_data() 
+function check_monitor_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
+       # NOTE: call create_all() to setup the database from the info model.
+       python -c "from monitor.database.info.model import *; from elixir import create_all; create_all()"
 }
 
 function check_monitor_conf ()
 {
        MONITOR_CONFIG=/etc/monitor.conf
 
-       if [ -z "$PLC_MONITOR_IP" ] ; then
-               PLC_MONITOR_IP=$( gethostbyname $PLC_MONITOR_HOST )
-       fi
-
        # Using plcsh add default, monitor user
        plcsh <<EOF &>/dev/null 
 AddPerson({'first_name' : 'Monitor', 'last_name' : 'Server', 'password' : '${PLC_MONITOR_DBPASSWORD}', 'email' : '${PLC_MONITOR_EMAIL}'})
@@ -135,13 +80,17 @@ API_AUTH_USER=${PLC_MONITOR_EMAIL}
 API_AUTH_PASSWORD=${PLC_MONITOR_DBPASSWORD}
 
 # SERVER PATHS
-MONITOR_SCRIPT_ROOT=/usr/share/monitor-server
-MONITOR_DATA_ROOT=/var/lib/monitor-server
-MONITOR_ARCHIVE_ROOT=/var/lib/monitor-server/archive-pdb
+MONITOR_SCRIPT_ROOT=${MONITORPATH}
+MONITOR_DATA_ROOT=/var/lib/monitor
+MONITOR_ARCHIVE_ROOT=/var/lib/monitor/archive-pdb
+MONITOR_BOOTMANAGER_LOG=/var/www/html/monitorlog
 
 MONITOR_HOSTNAME=${PLC_MONITOR_HOST}
 MONITOR_IP=${PLC_MONITOR_IP}
 
+PLC_WWW_HOSTNAME=${PLC_WWW_HOST}
+PLC_NAME=${PLC_NAME}
+
 # used for debug mode
 email=
 
@@ -155,12 +104,16 @@ support_email=${PLC_MAIL_SUPPORT_ADDRESS}
 cc_email=
 
 [monitordatabase]
-monitor_dburi=postgres://monitoruser:${PLC_MONITOR_DBPASSWORD}@localhost:5432/monitor
-zabbix_dburi=postgres://zabbixuser:${PLC_MONITOR_DBPASSWORD}@localhost:5432/zabbix
+monitor_dburi=postgres://${MONITOR_DB_USER}:${PLC_MONITOR_DBPASSWORD}@localhost:5432/${MONITOR_DB_NAME}
+zabbix_dburi=postgres://${ZABBIX_DB_USER}:${PLC_MONITOR_DBPASSWORD}@localhost:5432/${ZABBIX_DB_NAME}
 
 cachetime=60
 
+# Evaluated as true or false
 [commandline]
+cachecalls=True
+embedded=False
+
 echo=False
 debug=False
 mail=True
@@ -174,60 +127,61 @@ EOF
        fi
 }
 
-function check_zab_server ()
+function create_httpd_conf ()
 {
-       ZABBIXCFG=/etc/zabbix
-       TMP_FILE=`mktemp /tmp/zbxtmpXXXXXX`
-
-       if [ -f ${ZABBIXCFG}/zabbix_server.conf ] ; then
-               sed -e "s/#DBHost=.*/DBHost=$PLC_MONITOR_HOST/g" \
-                   -e "s#DBName=.*#DBName=$ZABBIX_DB_NAME#g" \
-                   -e "s#DBUser=.*#DBUser=$ZABBIX_DB_USER#g" \
-                   -e "s#DBPassword=.*#DBPassword=$PLC_MONITOR_DBPASSWORD#g" \
-                   ${ZABBIXCFG}/zabbix_server.conf > $TMP_FILE
-               cat $TMP_FILE > ${ZABBIXCFG}/zabbix_server.conf
+       MONITOR_HTTP_CONF=/etc/httpd/conf.d/monitorweb.conf
+
+       if [ ! -f ${MONITOR_HTTP_CONF} ] ; then
+               # note: we need to either start this script before httpd, or always
+               # restart httpd, since there's no way to know beyond file's existence
+               # whether the values have changed or not.
+               WROTE_HTTP_CONFIG="true"
        fi
-       service zabbix_server start
-       rm -f $TMP_FILE
 
+       # TODO: support HTTPS as well as port 80.  currently not specifying port
+       #               80 breaks https for other content on the myplc.
+       # TODO: make proxy port configurable.
+
+       cat <<EOF > ${MONITOR_HTTP_CONF}
+
+# NOTE: I've tried other means of redirection, including mod_rewrite, but did
+#      not have any success.  The means below is not idea, b/c it does not keep
+#      non-ssl session as non-ssl.  But it works.
+
+# NOTE: redirect path without trailing '/' to path with.  Favor SSL.
+Redirect /monitor https://${PLC_MONITOR_HOST}:${PLC_WWW_SSL_PORT}/monitor/
+
+# NOTE: this directive strips '/monitor/' from the requested path and pastes
+#       the remaining part to the end of the ProxyPass url below.  All TG urls
+#       should be relative to their current position, or the absolute path
+#       that includes /monitor/ at the beginning.  
+# TODO: make location configurable.
+<Location '/monitor/'>
+    #LogLevel debug
+    #Errorlog /var/log/httpd/monitorwebapp-error_log
+    #Customlog /var/log/httpd/monitorwebapp-access_log common
+
+    ProxyPass http://127.0.0.1:8082/
+    ProxyPassReverse http://127.0.0.1:8082/
+</Location>
+
+EOF
 }
-function check_zab_agentd ()
+
+function start_tg_server ()
 {
-       ZABBIXCFG=/etc/zabbix
-       TMP_FILE=`mktemp /tmp/zbxtmpXXXXXX`
-       if [ -f ${ZABBIXCFG}/zabbix_agentd.conf ] ; then
-               HOST=`hostname`
-               sed -e "s#Server=.*#Server=$PLC_MONITOR_HOST#g" \
-                   -e "s#Hostname=.*#Hostname=$HOST#g" \
-                   ${ZABBIXCFG}/zabbix_agentd.conf > $TMP_FILE
-               cat $TMP_FILE > ${ZABBIXCFG}/zabbix_agentd.conf 
-       fi
-       service zabbix_agentd start
-       rm -f $TMP_FILE
+       stop_tg_server
+       pushd ${MONITORPATH}/web/MonitorWeb/
+       ./start-monitorweb.py ${MONITORPATH}/web/MonitorWeb/prod.cfg &> /var/log/monitorweb.log &
+       popd
 }
-function check_zab_webconfig()
+
+function stop_tg_server ()
 {
-       # SETUP zabbix gui configuration
-       ZABBIX_WEB_CFG=/var/www/html/zabbix/conf/zabbix.conf.php 
-       if [ ! -f $ZABBIX_WEB_CFG ] ; then
-               touch  $ZABBIX_WEB_CFG
-               cat <<EOF > $ZABBIX_WEB_CFG
-<?php
-global \$DB;
-
-\$DB["TYPE"]           = "POSTGRESQL";
-\$DB["SERVER"]         = "localhost";
-\$DB["PORT"]           = "0";
-\$DB["DATABASE"]               = "$ZABBIX_DB_NAME";
-\$DB["USER"]           = "$ZABBIX_DB_USER";
-\$DB["PASSWORD"]               = "$PLC_MONITOR_DBPASSWORD";
-\$ZBX_SERVER           = "$PLC_MONITOR_HOST";
-\$ZBX_SERVER_PORT      = "10051";
-\$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
-?>
-EOF
-               chmod 644 $ZABBIX_WEB_CFG
-       fi
+        pid=$( cat /var/run/monitorweb.pid )
+        if [ -n "$pid" ] ; then
+                kill $pid
+        fi
 }
 
 if [ "$PLC_MONITOR_ENABLED" != "1" ] ; then
@@ -236,43 +190,65 @@ fi
 
 case "$1" in
        start)
-               MESSAGE=$"Bootstrap Monitoring"
+               MESSAGE=$"Bootstrap Monitoring (please wait...)"
                dialog "$MESSAGE"
 
-
                # DATABASE acces, creation, and data loading
-               check_pg_hba
-               check_user_and_db 
-               check_schema_and_data
-
+               check_pg_hba $MONITOR_DB_NAME $MONITOR_DB_USER
+               check_user_and_db $MONITOR_DB_NAME $MONITOR_DB_USER
                # WRITE default /etc/monitor.conf
                check_monitor_conf
 
-               # START zabbix services.  SETUP default config files.
-               check_zab_server
-               check_zab_agentd
-               check_zab_webconfig
-
+               if [ -n "$WROTE_PG_CONFIG" ] ; then
+                       # NOTE: restart db to enable access by users granted above.
+                       service plc restart postgresql
+                       service plc restart httpd
+                       MESSAGE=$"Bootstrap Monitoring 2 (please wait...)"
+                       dialog "$MESSAGE"
+               fi
+
+               check_monitor_schema_and_data
+
+               # create /etc/httpd/conf.d/monitorweb.conf
+               create_httpd_conf
+               if [ -n "$WROTE_HTTP_CONFIG" ] ; then
+                       # NOTE: restart web server to enable access web cfg
+                       service plc restart httpd
+                       MESSAGE=$"Bootstrap Monitoring 3 (please wait...)"
+                       dialog "$MESSAGE"
+               fi
+               start_tg_server
 
                result "$MESSAGE"
        ;;
 
-       sync)
-               MESSAGE=$"Syncing PLC db with Zabbix DB"
+       restartweb)
+               MESSAGE=$"Restarting monitor web app..."
                dialog "$MESSAGE"
 
-               $MONITORPATH/zabbix/zabbixsync.py --setupglobal &> /var/log/monitor-server
+               stop_tg_server
+               start_tg_server
                
                result "$MESSAGE"
        ;;
 
+       delete)
+               MESSAGE=$"Deleting databases..."
+               dialog "$MESSAGE"
+
+               dropdb -U postgres $MONITOR_DB_NAME
+               dropuser -U postgres $MONITOR_DB_USER
+
+               result "$MESSAGE"
+       ;;
+
        stop)
                MESSAGE=$"Stopping Monitor"
                dialog "$MESSAGE"
 
-               service zabbix_server stop
-               service zabbix_agentd stop
-               # TODO: is there anything to stop?
+               stop_tg_server
+               # todo: disable cron entry?
+
                result "$MESSAGE"
        ;;
 esac