Sen descrición

Markus Hennecke 535870f832 PostgreSQL 16 requires libm when linking		hai 11 meses
htdocs	e6b7f150c1 Add pressure and battery to sensor data	hai 1 ano
input	535870f832 PostgreSQL 16 requires libm when linking	hai 11 meses
output	535870f832 PostgreSQL 16 requires libm when linking	hai 11 meses
sql	4122e1149f Unify param handling and response, add error path	hai 1 ano
.gitignore	e753f13b0c Add output CGI to ignore list	%!s(int64=6) %!d(string=hai) anos
Makefile	27fc3c6ce1 Add HTML/JS plotting of temperature and humidity	%!s(int64=6) %!d(string=hai) anos
README.md	8f74474f97 Add missing config variables to README.md	%!s(int64=6) %!d(string=hai) anos
cflags.mk	2a3d602a10 Fix building with PostgreSQL 12	%!s(int64=4) %!d(string=hai) anos
cgiconfig.mk	b07d3aba67 Add start/end date selectors in overview.html	%!s(int64=6) %!d(string=hai) anos
db.c	0b898a84bd Fix db_disconnect() implementation	hai 11 meses
db.h	4122e1149f Unify param handling and response, add error path	hai 1 ano
util.c	4122e1149f Unify param handling and response, add error path	hai 1 ano
util.h	4122e1149f Unify param handling and response, add error path	hai 1 ano

Weatherdata

CGIs for adding and retrieving weatherdata, at this time temperature and humidity.

Database setup

Create database user weatherdata: createuser -U postgres -D -l -R -S --pwprompt weatherdata

Create the database and make the weatherdata user the owner: createdb -U postgres -E UTF8 -O weatherdata weatherdata

Add the data table to the database: psql -U weatherdata -f sql/database.sql weatherdata

Configuration

An optional make include named 'localconfig.mk' may be used to overwrite variables defined in 'cgiconfig.mk'. Possible configuration settings and their default settings are:

Database

DATABASE_HOSTNAME: 127.0.0.1
DATABASE_PORT: 5432
DATABASE_USER: weatherdata
DATABASE_PASSWORD: The password the weatherdata user is connecting to the database. This will end up in 'localconfig.mk' most likely.

Webserver

HTDOCS_PATH: Path to the document root the webserver uses to serve HTML, defaults to /var/www/htdocs.
WWW_USER: The user that will own the installed files, defaults to www.
WWW_GROUP: The group the files will be installed with, defaults to www.

Building CGIs

Prerequisites

The make files are valid on OpenBSD systems, the postgresql-client and kcgi packages needs to be installed to build the CGIs.

It is assumed that the slowcgi(8) daemon is running.

Build the CGIs

make all

Installation

As root issue make install.

README.md