HIP:PMP:Database

From Earlham Cluster Department

(Difference between revisions)
Jump to: navigation, search
(PMP1 Scripts)
Line 5: Line 5:
*The first script is "log.pl"
*The first script is "log.pl"
-
**This script collects speed1, speed2, direction1, direction2 and box_temperature.
+
** This script collects speed1, speed2, direction1, direction2 and box_temperature.
-
**It then records them in files in "/root/logs/".
+
** It then records them in files in "/root/logs/".
-
**The script is run buy cron every 15 minutes and it also records a state value.
+
** The script is run buy cron every 15 minutes and it also records a state value.
-
**When the state value is 4, the script wakes up the network, resets the state value to 0, and executes the second main script.
+
** When the state value is 4, the script wakes up the network, resets the state value to 0, and executes the second main script.
* The second script is "dbi.pl"
* The second script is "dbi.pl"
-
This script simply sends all the data from the files in "/root/logs" to a database called "pmp1" on quark.
+
** This script simply sends all the data from the files in "/root/logs" to a database called "pmp1" on quark.
 +
 
 +
===NOTE===
 +
To prevent "log.pl" from disabling the network through cron, execute the script
 +
"/root/kill_jobs.sh" and don't forget to execute "/root/restore_jobs.sh" after you are done.
 +
** Warning: The network will still get disabled whenever the "log.pl" runs. To avoid this, comment out all lines with:
 +
 
 +
  system("/root/scripts/net_disconnect.sh");
 +
 
 +
or
 +
 
 +
temporarily rename "/root/scripts/net_disconnect.sh"
==Database on Quark==
==Database on Quark==
 +
 +
* To access the database, you have to log to quark and execute:
 +
nerd@quark$ psql -U weather
 +
or
 +
nerd@quark$ psql -U hip
 +
* The password is the "default" hip/weather.
 +
* To view the wind data, execute:
 +
 +
weather=# select * from pmp1 order by id desc;
 +
 +
* This will list the wind data beginning with the latest entries.

Revision as of 19:42, 12 July 2007

PMP1 Scripts

The pmp1 has 2 main scripts that handle wind data. All pmp1 scripts are located in "/root/scripts/"

NOTE

To prevent "log.pl" from disabling the network through cron, execute the script "/root/kill_jobs.sh" and don't forget to execute "/root/restore_jobs.sh" after you are done.

 system("/root/scripts/net_disconnect.sh");

or

temporarily rename "/root/scripts/net_disconnect.sh"

Database on Quark

nerd@quark$ psql -U weather

or

nerd@quark$ psql -U hip

weather=# select * from pmp1 order by id desc;

Personal tools
Namespaces
Variants
Actions
websites
wiki
this semester
Toolbox