Markus Hennecke 535870f832 PostgreSQL 16 requires libm when linking | 11 kuukautta sitten | |
---|---|---|
htdocs | 1 vuosi sitten | |
input | 11 kuukautta sitten | |
output | 11 kuukautta sitten | |
sql | 1 vuosi sitten | |
.gitignore | 6 vuotta sitten | |
Makefile | 6 vuotta sitten | |
README.md | 6 vuotta sitten | |
cflags.mk | 4 vuotta sitten | |
cgiconfig.mk | 6 vuotta sitten | |
db.c | 11 kuukautta sitten | |
db.h | 1 vuosi sitten | |
util.c | 1 vuosi sitten | |
util.h | 1 vuosi sitten |
CGIs for adding and retrieving weatherdata, at this time temperature and humidity.
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
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_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.
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
.
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.
make all
As root issue make install
.