comparison db/mkconfig @ 0:9dab44dcb331

Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz
author Daniel O'Connor <darius@dons.net.au>
date Tue, 09 Feb 2010 13:44:25 +1030
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:9dab44dcb331
1 /*
2 * Create MySQL config
3 * Edit to appropriate values before running.
4 * $Id: mkdb,v 1.3 2009/12/20 00:44:15 grog Exp grog $
5 */
6 insert into config
7 ( version, /* format version number */
8 latitude, /* In ° */
9 longitude,
10 elevation, /* metres */
11 pressure_error, /* difference between actual and real, hPa */
12 poll_interval,
13 station_id, /* this is the one we use for the database */
14 address, /* Address to display on web pages */
15 wunderground_station_id,
16 wunderground_passwd,
17 wunderground_report_interval, /* how many seconds between reports to Wunderground */
18 weatheforyou_station_id,
19 weatheforyou_passwd,
20 weatherforyou_report_interval, /* how many seconds between reports to Weather for you */
21 website_generation_interval, /* how many seconds between generating PHP header file */
22 db_host, /* database on this host */
23 db_user, /* user ID on host */
24 db_passwd, /* and password */
25 db, /* database name */
26 db_table, /* table */
27 php_header, /* php header file with weather data */
28 comparefile) /* file to compare local weather stations */
29 values (
30 /* version */ 1, /* don't change this */
31 /* latitude */ -37.8185,
32 /* longitude */ 143.739473,
33 /* elevation */ 340, /* elevation of the station in metres */
34 /* pressure_error */ -13.5, /* offset of pressure measurements, hPa */
35 /* poll_interval */ 60, /* poll once a minute */
36 /* station_id */ "MYID",
37 /* address */ "MYADDRESS",
38 /* wunderground_station_id */ "MYID",
39 /* wunderground_passwd */ "insecure",
40 /* wunderground_report_interval */ 300, /* how many seconds between reports to Wunderground */
41 /* weatheforyou_station_id */ "",
42 /* weatheforyou_passwd */ "",
43 /* weatherforyou_report_interval */ 300, /* how many seconds between reports to Weather for you */
44 /* website_generation_interval */ 60, /* how many seconds between generating PHP header file */
45 /* db_host */ "dereel.lemis.com",
46 /* db_user */ "grog",
47 /* db_passwd */ "",
48 /* db */ "weather",
49 /* db_table */ "observations",
50 /* php_header */ "/home/grog/public_html/weather/current.php",
51 /* comparefile */ "/home/grog/public_html/weather/BoM-compare"
52 );
53
54
55 insert into config
56 ( version, /* format version number */
57 latitude, /* In ° */
58 longitude,
59 elevation, /* metres */
60 pressure_error, /* difference between actual and real, hPa */
61 poll_interval, /* between reading the device */
62 station_id, /* this is the one we use for the database */
63 address, /* Address to display on web pages */
64 wunderground_station_id,
65 wunderground_passwd,
66 wunderground_report_interval, /* how many seconds between reports to Wunderground */
67 weatheforyou_station_id,
68 weatheforyou_passwd,
69 weatherforyou_report_interval, /* how many seconds between reports to Weather for you */
70 website_generation_interval, /* how many seconds between generating PHP header file */
71 db_table, /* table */
72 php_header, /* php header file with weather data */
73 comparefile) /* file to compare local weather stations */
74 values (
75 /* version */ 1, /* don't change this */
76 /* latitude */ -37.8185,
77 /* longitude */ 143.739473,
78 /* elevation */ 340, /* elevation of the station in metres */
79 /* pressure_error */ -13.5, /* offset of pressure measurements, hPa */
80 /* poll_interval */ 60, /* poll once a minute */
81 /* station_id */ "Dereel",
82 /* address */ "Dereel, Victoria, Australia",
83 /* wunderground_station_id */ "IVICTORI124",
84 /* wunderground_passwd */ "breached",
85 /* wunderground_report_interval */ 300, /* how many seconds between reports to Wunderground */
86 /* weatheforyou_station_id */ "",
87 /* weatheforyou_passwd */ "",
88 /* weatherforyou_report_interval */ 300, /* how many seconds between reports to Weather for you */
89 /* website_generation_interval */ 60, /* how many seconds between generating PHP header file */
90 /* db_table */ "observations",
91 /* php_header */ "/home/grog/public_html/weather/current.php",
92 /* comparefile */ "/home/grog/public_html/weather/BoM-compare",
93 );