HIP:PMP:Database

From Earlham Cluster Department

(Difference between revisions)
Jump to: navigation, search
(NOTE)
Line 14: Line 14:
** 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===
+
'''NOTE'''
To prevent "log.pl" from disabling the network through cron, execute the script
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.
"/root/kill_jobs.sh" and don't forget to execute "/root/restore_jobs.sh" after you are done.

Revision as of 19:43, 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