E-Monitoring notes

isys

Isys provides a website for viewing the data collected by Magrathea. It also runs the mysql database that holds the data.

It also runs mail for e-monitoring.net

the key on root@mail should let you ssh w/o pass to isys.e-monitoring.net

isys has a mail queue problem where it gets big and we run out of inodes. we setup a cronjob to clear that out.

isys - out of inodes

1. ssh to root@isys.e-monitoring.net
2. isys# cd /var/spool/mqueue
3. isys# sh
4. # for f in `ls`; do rm $f; done

(wait awhile)

	wrote a script:

	isys# cat > /root/clearqueue.sh
	#!/bin/sh
	for f in `ls /var/spool/mqueue`; do rm /var/spool/mqueue/$f; done
	isys# sh /root/clearqueue.sh

crontabed for 3am on the 1st of the month

polling / magrathea

Magrathea polls the wells every 5 minutes. It getit.pl uses the expect script poll.exp to get the data from the logger and log the raw data in a local file (el1, el2, el3, el4). getit.pl then applies a correction factor and inserts the data into a database on Isys.

The website http://gwsci.e-monitoring.net is also hosted on isys.

Magrathea2 polls the wells every 5 minutes by calling getit.pl from the crontab. getit.pl uses the perl routine poll to get the data from the new style loggers and log the raw data in a local file (el1, el2, el3, el4). getit.pl then applies a correction factor and inserts the data into a database on magrathea2.

The website http://gwsci2.e-monitoring.net is also hosted on magrathea2.

Current IP addresses

Current IP addresses in Texas are located here

 Private_IP_Mapping#Ground_Water_in_Texas

config new IP

Edit:

/etc/defaultrouter
/export/home/groundwater/bin/getit.pl
/etc/hosts
/etc/hostname.le1

On production:

/home/htdocs/gw/index.pl
/home/htdocs/isys/pollscan.pl
/home/gw/shipley/etc/config.pl
/home/gw/owrd/etc/config.pl
/home/dboodman/www/isys/pollscan.pl
Apache conf

stop it from trying to dial out

mysql> select * from resources;
+------------+------------+----------------+-------+---------+----------+
| resourceID | resource   | connectionType | inUse | inUseBy | inUseFor |
+------------+------------+----------------+-------+---------+----------+
|          1 | /dev/cuaa0 |              1 |  NULL |    NULL |     NULL |
|          2 | network    |              2 |  NULL |    NULL |     NULL |
|          3 | network    |              2 |  NULL |    NULL |     NULL |
|          4 | network    |              2 |  NULL |    NULL |     NULL |
|          5 | network    |              2 |  NULL |    NULL |     NULL |
|          6 | network    |              2 |  NULL |    NULL |     NULL |
|          7 | network    |              2 |  NULL |    NULL |     NULL |
|          8 | network    |              2 |  NULL |    NULL |     NULL |
|          9 | network    |              2 |  NULL |    NULL |     NULL |
|         10 | network    |              2 |  NULL |    NULL |     NULL |
|         11 | network    |              2 |  NULL |    NULL |     NULL |
+------------+------------+----------------+-------+---------+----------+
11 rows in set (0.00 sec)
delete from resources where resourceID =1;