HIP:PMP:Database

From Earlham Cluster Department

(Difference between revisions)
Jump to: navigation, search
(PMP1 Scripts)
(PMP1 Scripts)
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.
-
'''Warning:'''The network will still get disabled whenever the "log.pl" runs. To avoid this, comment out all lines with:
+
''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");
   system("/root/scripts/net_disconnect.sh");

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

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