Heizung, Volkszaehler
The visualisation software volkszaehler does a very good job, as I have seen in the project VolkszaehlerACE3000 (Dockstar). So, I like to use it also for my Heizung temperature measurement.
The old style diagram was drawn by GNUplot, see the diagram below. Every 5 minutes a new diagram was calculated and ready for web visualization. But there was no interactive element to walk along the time axis. Also an automatic scaling in the vertical axis was difficult to make.
By finding the volkszaehler software it is now possible to do all that, what I missed in the old system.
![/!\](/moin_static199/modern/img/alert.png "/!\"){kind=small}
Update 2019-12-22
Now volkszaehler works with an i5 server (1 GB RAM).
.
.
.
.
|
.
.
.
.
.
Data Input
Because the temperature data are located on another computer (EeePC900) in the local network, they have to be transfered to the local server, every 5 minutes. This transfer is triggered via cron job.
The simple way is to use scp with the utiliy sshpass and insert the password per script. In order to protect the remote password, this is done with root rights.
In order to avoid the sshd logging reverse mapping checking getaddrinfo for . [192.168.17.72] failed - POSSIBLE BREAK-IN ATTEMPT! add in the server side file /etc/hosts the string
192.168.17.72 rudiswiki14
If the transfer does not work, add for debugging the option -v to the scp call and start it manually.
# shell script to transfer temperature data $ sudo cat /root/cp_heizung.sh #!/bin/sh # File: cp_heizung.sh # 2014-02-14 RudolfReuter # copy actual temperatures from Heizung to local folder # remote: /var/volatile/www/heizdata.csv # local: /run/user/heizdata.csv sshpass -p 'xxx' scp -pq -o StrictHostKeyChecking=no rudi@192.168.17.90:/var/volatile/www/heizdata.csv /run/user/heizdata.csv # END # setup on target computer $ sudo nano /root/cp_heizung.sh $ man sshpass # check for sshpass installed # if sshpass is not yet installed $ sudo apt install sshpass # Temperature data transfer every 5 minutes (root level) $ sudo crontab -l # for heizung volkszaehler copy remote data to local every 5 minutes */5 * * * * /root/cp_heizung.sh >/dev/null 2>&1 # setup on target computer # edit crontab $ sudo crontab -e # restart cron $ sudo service cron restart
The cron jobs have 4 pitfalls, which are difficult to debug. Take care about:
root level (sudo) and user level, those are two different systems.
The last line in a crontab file must be empty (just New Line).
If you do not run the computer 24h a day, a cron job does not run if the computer is powered down, the event is just canceled. For such cases use anacron, which also looks for waiting jobs, but it does not make sense for periodic 5 minute jobs.
search path: originally cron has in the search path just /bin:/usr/bin. This is also true for any called shell scripts. So, it is good practice, that in the crontab file, other bin paths are added to the search path, for example:
$ sudo crontab -l PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin ...
Volkszaehler Web Frontend
For the setup of the channels and the interaction please have a look at Data Web Visualzation
|
phpmyadmin Utility
Now install first the database utility phpmyadmin.
If there was already a mySQL/MariaDB setup made, the root password must be cleared, see here for the explanation, and later restored. Otherwise you get an error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).
# remove root password
$ mysql -u root -p
ENTER password
MariaDB [(none)]> SET PASSWORD FOR root@localhost=PASSWORD('');
Query OK, 0 rows affected (0.01 sec)Now install phpmyadmin.
$ sudo apt-get install phpmyadmin [sudo] Passwort für rudi: Paketlisten werden gelesen... Fertig ... Creating config file /etc/php/7.2/mods-available/bz2.ini with new version ... Creating config file /etc/dbconfig-common/config with new version ... Creating config file /etc/dbconfig-common/phpmyadmin.conf with new version ... Creating config file /etc/phpmyadmin/config-db.php with new version ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) # see before how to remove the database root password. Verbindungsmethode: Unix-Socket MySQL-Datenbankname für phpmyadmin: phpmyadmin MySQL-Benutzername: phpmyadmin@localhost MySQL-Anwendungspasswort: o.. # READY
Now restore the database root password:
$ mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n] y
New password: ...
Re-enter new password: ...
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] n
... skipping.
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] n
... skipping.
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!
Install Volkszaehler
Installation on Ubuntu 18.04-64.
Install and setup the volkszaehler per shell script:
$ mkdir $HOME/Install/volkszaehler
# Get the install script
$ cd $HOME/Install/volkszaehler
$ wget https://raw.github.com/volkszaehler/volkszaehler.org/master/bin/install.sh
# Make it executable
$ sudo chmod u+x install.sh
# Run the script
$ sudo bash install.sh
volkszaehler.org installation script
checking prerequisites: php: /usr/bin/php
mysql: /usr/bin/mysql
awk: /usr/bin/awk
sed: /bin/sed
grep: /bin/grep
wget: /usr/bin/wget
mktemp: /bin/mktemp
mkdir: /bin/mkdir
git: /usr/bin/git
checking php version: 7.2.24-0ubuntu0.18.04.1 >= 7.1, ok
volkszaehler setup...
volkszaehler path? [/home/rudi/volkszaehler.org]
git clone volkszaehler.org into /home/rudi/volkszaehler.org
Klone nach '/home/rudi/volkszaehler.org' ...
remote: Enumerating objects: 16, done.
remote: Counting objects: 100% (16/16), done.
remote: Compressing objects: 100% (16/16), done.
remote: Total 12105 (delta 5), reused 4 (delta 0), pack-reused 12089
Empfange Objekte: 100% (12105/12105), 7.56 MiB | 4.67 MiB/s, Fertig.
Löse Unterschiede auf: 100% (6843/6843), Fertig.
link from webserver to volkszaehler directory? [/var/www/volkszaehler.org]
linking /var/www/volkszaehler.org to /home/rudi/volkszaehler.org
[sudo] Passwort für rudi:
checking composer...
~/volkszaehler.org ~/Install/volkszaehler
composer not found, downloading...
All settings correct for using Composer
Downloading...
Composer (version 1.9.1) successfully installed to: /home/rudi/volkszaehler.org/composer.phar
Use it: php composer.phar
~/Install/volkszaehler
composer: /home/rudi/volkszaehler.org/composer.phar
installing dependencies...
~/volkszaehler.org ~/Install/volkszaehler
Loading composer repositories with package information
Updating dependencies
# 5 min wait time ***********
Package operations: 58 installs, 0 updates, 0 removals
- Installing symfony/routing (v4.4.2): Downloading (100%)
- Installing symfony/polyfill-mbstring (v1.13.1): Downloading (100%)
- Installing symfony/polyfill-php72 (v1.13.1): Downloading (100%)
- Installing symfony/polyfill-intl-idn (v1.13.1): Downloading (100%)
- Installing symfony/mime (v5.0.2): Downloading (100%)
- Installing symfony/http-foundation (v4.4.2): Downloading (100%)
- Installing ralouphie/getallheaders (3.0.3): Downloading (100%)
- Installing psr/http-message (1.0.1): Downloading (100%)
- Installing guzzlehttp/psr7 (1.6.1): Downloading (100%)
- Installing evenement/evenement (v3.0.1): Downloading (100%)
- Installing react/event-loop (v1.1.0): Downloading (100%)
- Installing react/stream (v1.1.0): Downloading (100%)
- Installing react/promise (v2.7.1): Downloading (100%)
- Installing react/promise-timer (v1.5.1): Downloading (100%)
- Installing react/cache (v1.0.0): Downloading (100%)
- Installing react/dns (v1.2.0): Downloading (100%)
- Installing react/socket (v1.3.0): Downloading (100%)
- Installing ratchet/rfc6455 (v0.2.6): Downloading (100%)
- Installing cboden/ratchet (v0.4.1): Downloading (100%)
- Installing psr/container (1.0.0): Downloading (100%)
- Installing symfony/service-contracts (v2.0.1): Downloading (100%)
- Installing symfony/polyfill-php73 (v1.13.1): Downloading (100%)
- Installing symfony/console (v4.4.2): Downloading (100%)
- Installing doctrine/lexer (1.2.0): Downloading (100%)
- Installing doctrine/annotations (v1.8.0): Downloading (100%)
- Installing doctrine/reflection (v1.0.0): Downloading (100%)
- Installing doctrine/event-manager (1.1.0): Downloading (100%)
- Installing doctrine/collections (1.6.4): Downloading (100%)
- Installing doctrine/cache (1.10.0): Downloading (100%)
- Installing doctrine/persistence (1.3.3): Downloading (100%)
- Installing doctrine/instantiator (1.3.0): Downloading (100%)
- Installing doctrine/dbal (v2.10.0): Downloading (100%)
- Installing doctrine/inflector (1.3.1): Downloading (100%)
- Installing doctrine/common (v2.11.0): Downloading (100%)
- Installing doctrine/orm (v2.7.0): Downloading (100%)
- Installing symfony/polyfill-ctype (v1.13.1): Downloading (100%)
- Installing symfony/yaml (v4.4.2): Downloading (100%)
- Installing guzzlehttp/promises (v1.3.1): Downloading (100%)
- Installing guzzlehttp/guzzle (6.5.2): Downloading (100%)
- Installing influxdb/influxdb-php (1.15.0): Downloading (100%)
- Installing symfony/event-dispatcher-contracts (v1.1.7): Downloading (100%)
- Installing symfony/event-dispatcher (v4.4.2): Downloading (100%)
- Installing andig/dbcopy (1.3.3): Downloading (100%)
- Installing andig/php-shunting-yard (1.0.2): Downloading (100%)
- Installing react/promise-stream (v1.2.0): Downloading (100%)
- Installing ringcentral/psr7 (1.2.2): Downloading (100%)
- Installing react/http (v0.8.5): Downloading (100%)
- Installing psr/log (1.1.2): Downloading (100%)
- Installing symfony/var-dumper (v5.0.2): Downloading (100%)
- Installing symfony/debug (v4.4.2): Downloading (100%)
- Installing symfony/error-handler (v4.4.2): Downloading (100%)
- Installing symfony/http-kernel (v4.4.2): Downloading (100%)
- Installing psr/http-server-handler (1.0.1): Downloading (100%)
- Installing react/child-process (v0.6.1): Downloading (100%)
- Installing symfony/process (v5.0.2): Downloading (100%)
- Installing php-pm/php-pm (2.0.2): Downloading (100%)
- Installing php-pm/httpkernel-adapter (2.0.2): Downloading (100%)
- Installing webpatser/laravel-uuid (3.0.2): Downloading (100%)
Writing lock file
Generating autoload files
~/Install/volkszaehler
volkszaehler.org is not configured yet. creating new config from sample config file.
mysql root user? [root]
mysql root password? [] ... see KeePass
mysql database? [volkszaehler]
mysql admin to volkszaehler database? [vz-admin]
mysql admin password? [] ..... see KeePass
mysql user? [vz]
mysql password? [demo]
create volkszaehler.org database and admin user? [y] y
creating database volkszaehler...
[sudo] Passwort für rudi: ...
creating db user vz-admin...
creating database schema...
~/volkszaehler.org ~/Install/volkszaehler
!
! [CAUTION] This operation should not be executed in a production environment!
!
Creating database schema...
[OK] Database schema created successfully!
Processing entity "Volkszaehler\Model\Aggregate"
Processing entity "Volkszaehler\Model\Entity"
Processing entity "Volkszaehler\Model\Channel"
Processing entity "Volkszaehler\Model\Aggregator"
Processing entity "Volkszaehler\Model\Property"
Processing entity "Volkszaehler\Model\Data"
Proxy classes generated to "/home/rudi/volkszaehler.org/lib/Model/Proxy"
~/Install/volkszaehler
create volkszaehler.org database user? [y]
creating db user vz with proper rights...
allow channel deletion? [n] y
granting db user vz delete rights...
insert demo data in to database? [n] n
# READY
Install Web Server
The easiest setup is with the PPM (PHP based) web server on port 8080.
1. Systemd Service setup
# Edit with editor "nano": $ sudo nano /etc/systemd/system/middleware.service [Unit] Description=Volkszaehler.org Middleware After=syslog.target network.target Requires= [Service] ExecStart=/usr/bin/php /var/www/volkszaehler.org/vendor/bin/ppm start -c /var/www/volkszaehler.org/etc/middleware.json --cgi-path=/usr/bin/php ExecReload=/bin/kill -HUP $MAINPID StandardOutput=journal Restart=always [Install] WantedBy=multi-user.target
2. Server configuration setup:
# Edit:
$ nano ~/volkszaehler.org/etc/middleware.json
change: „static-directory“: „/var/www/volkszaehler.org/htdocs“, (was "htdocs")3. Middleware routing URL setup
# Edit: $ nano ~/volkszaehler.org/htdocs/js/options.js title: 'Local (default)', url: '' # was 'api' //live: 8082
4. Activate Systemd Service at boot time:
# Edit: $ sudo systemctl enable middleware Created symlink /etc/systemd/system/multi-user.target.wants/middleware.service > /etc/systemd/system/middleware.service
5. Start Systemd Service:
$ sudo systemctl start middleware
6. Test:
# Web-browser: 192.168.17.74:8080 # show volkszaehler empty diagram - OK
Port old Database
I wanted to transfer an old Volkszaehler database (about 5 years) to a new computer.
First try was with dbcopy, but I could not make it to work for transfering the database via network to another computer.
Next try was with the Mariadb/mySQL tools mysqldump and mysql, see:
# Export data: $ mysqldump -u root -p volkszaehler > sicherung-vz-2019121959.sql # 117 MB size # Enter password and wait some minutes # Transfer file to other computer
then save back:
# Import data: $ mysql -u root -p volkszaehler < sicherung-vz-2019121959.sql # Enter password # Test: Web-browser: 192.168.17.74:8080
Install on Dockstar
The little computer DockStarOverview does have a minimum Debian Linux (architecture armel). Most commands are included in busybox. The web server in implemented in a moin wiki. So, a lot of dependencies have to be installed.
This installation is mainly a copy of an already existing installation (i386). Fortunately most programs of volkszaehler are architecture independent (exception vzlogger, which is not needed in this case).
If you want to know, what programs and versions are installed on the source computer, you can do with:
# 1 columns output
$ dpkg-query --show
adduser 3.113+nmu3
...
# 2 columns output, for printing
$ dpkg-query --show | pr --columns 2 -T -w 120 -l1
accountsservice 0.6.15-2ubuntu9.7 acl 2.2.51-5ubuntu1
...
or with full info
$ dpkg -l
Gewünscht=Unbekannt/Installieren/R=Entfernen/P=Vollständig Löschen/Halten
| Status=Nicht/Installiert/Config/U=Entpackt/halb konFiguriert/
Halb installiert/Trigger erWartet/Trigger anhängig
|/ Fehler?=(kein)/R=Neuinstallation notwendig (Status, Fehler: GROSS=schlecht)
||/ Name Version Architektur Beschreibung
+++-==========================-==================-==========-=================================
ii adduser 3.113+nmu3 all add and remove users and groups
...Then to install:
$ sudo apt-get update $ sudo apt-get install apache2-mpm-prefork $ sudo apt-get install php5 $ sudo apt-get install git-core libapache2-mod-php5 php5-cli php5-mysql php-apc mysql-server mysql-client # phpmyadmin does work very slow $ sudo apt-get install phpmyadmin
Setup the volkszaehler configuration, mainly checking the dependencies and database setup:
# install.sh does not work at checking the dependencies, change the script:
deps=( bash php mysql awk sed grep wget mktemp mkdir tar )
for binary in "${deps[@]}"; do
#binpath="$(which $binary)"
#if [ -n "$binpath" ] ; then
if hash $binary 2>/dev/null; then
binpath="$(which $binary)"
echo " $binary: $binpath"
# because the busybox "which" command does not work as expected, see "Link".
$ sudo ./install.sh
...
configure volkszaehler.org? [y]
mysql user? [vz]
mysql password? [demo] oz...
mysql database? [volkszaehler]
create database? [y]
mysql admin user? [root]
mysql admin password? [] oz...
creating database volkszaehler...
...
Creating database schema...
Database schema created successfully!
/home/rudi/Install/volkszaehler
creating db user vz with proper rights...
insert demo data in to database? [n]
# set rights for web server
$ sudo chown -R www-data:www-data /var/www
# dump the database on the old computer 192.168.17.72
# Attention, a dump with phpmyadmin does NOT work.
$ sudo mysqldump -u root -p volkszaehler >vz_heizung2.sql
[sudo] password for rudi:
Enter password:
# restore the database
$ sudo mysql -u root -p volkszaehler < vz_heizung2.sql
[sudo] password for rudi:
Enter password:
# 5 min wait timeAccess is via web browser to http://192.168.17.90/volkszaehler.org/htdocs, and setup the channels.
Setup the local data collection:
# script needs calculator "bc" $ sudo apt-get install bc # create a link to vzclient $ sudo ln -s /var/www/volkszaehler.org/bin/vzclient /usr/local/bin/vzclient # old installation $ sudo ln -s /var/www/volkszaehler.org/misc/tools/vzclient /usr/local/bin/vzclient # setup cron job $ crontab -e # If you get a permission problem: $ sudo chown rudi:rudi /var/spool/cron/crontabs/rudi # append to the file PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin # copy heizung values to volkszaehler database, every 3 minutes */3 * * * * $HOME/Install/volkszaehler/heizung_vz.sh > /dev/null
Setup Volkszaehler Web Frontend
Open web URL volkszaehler.
Create 6 channels:
- Temperatur Aussen UUID=0af2cbe0-9642-11e3-bf0b-274d1fdbb6da color=red
- Temperatur Dachboden UUID=f6995100-9641-11e3-acef-63b96b2c09da color=aqua
- Ventil Pumpe UUID=6ac83df0-9641-11e3-8754-0b95768ead82 color=black
- Temperatur Ruecklauf UUID=c51f9a00-9641-11e3-a372-8333daeea385 color=blue
- Temperatur Vorlauf UUID=a6f48e80-9641-11e3-b827-cbf068cc797d color=green
Temperatur WarmWasser UUID=e5fd14f0-9641-11e3-a6ea-2f1617b797f9 color=purple
Copy data to database
Now, that the temperature data are on the local computer, they can be inserted into the database, with the following shell script.
# show example data $ cat /run/user/heizdata.csv 2014-02-16 09:22:13;1;566;519;431;151;71 $ cat heizung_vz.sh #!/bin/sh # File: heizung_vz.sh # 2014-02-15 RudolfReuter # Separate heizung data and copy in database # setup /etc/vzclient.conf UUID_VP=6ac83df0-9641-11e3-8754-0b95768ead82 UUID_TV=a6f48e80-9641-11e3-b827-cbf068cc797d UUID_TR=c51f9a00-9641-11e3-a372-8333daeea385 UUID_TW=e5fd14f0-9641-11e3-a6ea-2f1617b797f9 UUID_TD=f6995100-9641-11e3-acef-63b96b2c09da UUID_TA=0af2cbe0-9642-11e3-bf0b-274d1fdbb6da HPATH=/run/user/heizdata.csv HDATA=`cat $HPATH` #echo $HDATA # extract proper field and adjust decimal point, pumpe*2 for better visability VP=`cut -d ";" -f 2 $HPATH` VP=$(echo "scale=1; $VP*2" | bc) TV=`cut -d ";" -f 3 $HPATH` TV=$(echo "scale=1; $TV/10" | bc) TR=`cut -d ";" -f 4 $HPATH` TR=$(echo "scale=1; $TR/10" | bc) TW=`cut -d ";" -f 5 $HPATH` TW=$(echo "scale=1; $TW/10" | bc) TD=`cut -d ";" -f 6 $HPATH` TD=$(echo "scale=1; $TD/10" | bc) TA=`cut -d ";" -f 7 $HPATH` TA=$(echo "scale=1; $TA/10" | bc) # copy existing values to database [ -z "$VP" ] || /usr/local/bin/vzclient -u $UUID_VP add data value=$VP > /dev/null [ -z "$TV" ] || /usr/local/bin/vzclient -u $UUID_TV add data value=$TV > /dev/null [ -z "$TR" ] || /usr/local/bin/vzclient -u $UUID_TR add data value=$TR > /dev/null [ -z "$TW" ] || /usr/local/bin/vzclient -u $UUID_TW add data value=$TW > /dev/null [ -z "$TD" ] || /usr/local/bin/vzclient -u $UUID_TD add data value=$TD > /dev/null [ -z "$TA" ] || /usr/local/bin/vzclient -u $UUID_TA add data value=$TA > /dev/null
Database Channels
- Temperature - in °C
- Valve/Ventil - 0 - 100%
- Power/Leistung - in Watt
more channel definitions, see at Links, or local volkszaehler.org/lib/Volkszaehler/Definition/
Database utility vzclient
For the maintenance of the volkszaehler database there is a utility vzclient, written in Python. For easier use, setup a configuration file:
$ cat /etc/vzclient.conf [default] url:http://localhost/volkszaehler.org/htdocs/middleware.php format:json
Give the user the right to delete channels:
$ mysql -u root -p
Enter password:
mysql > grant delete on volkszaehler.* to 'vz'@'localhost';
Query OK, 0 rows affected (0.01 sec)
mysql> quit
# delete unused channel
$ vzclient -u cdb2cbc0-926a-11e3-badc-c5ffaebea3fc delete channel
{"version":"0.3"}
# show channel property
$ vzclient -u 6ac83df0-9641-11e3-8754-0b95768ead82 get channel
{"version":"0.3","entity":{"uuid":"6ac83df0-9641-11e3-8754-0b95768ead82","type":"valve","active":true,"color":"black","style":"lines","title":"Pumpe"}}
# edit channel property
$ vzclient -u a9774800-934a-11e3-87f8-81f5f2axxxxx edit channel cost=0.0003
or, if you have forgotten to set the property "public"
$ vzclient -u 6ac83df0-9641-11e3-8754-0b95768ead82 edit channel public=true
{"version":"0.3","entity":{"uuid":"6ac83df0-9641-11e3-8754-0b95768ead82","type":"valve","active":"1","color":"black","style":"lines","title":"Pumpe","public":"1"}}
# get data tuples
$ vzclient -u a9774800-934a-11e3-87f8-81f5f2axxxxx get data tuples=10
{"version":"0.3","data":{"uuid":"a9774800-934a-11e3-87f8-81f5f2axxxxx","from":1392202238170,"to":1392210316212,"min":[1392204998518,269.701],"max":[1392202312007,2169643.945],"average":40955.469,"consumption":91900,"rows":12,"tuples":[[1392202312007,2169643.945,1],[1392203663705,123844.231,1],[1392204998518,269.701,1],[1392206116693,321.953,1],[1392206416642,1200.204,1],[1392207316192,400.2,1],[1392208516781,299.853,1],[1392208816626,1200.62,1],[1392209416681,599.945,1],[1392209716603,1200.312,1],[1392210316212,600.391,1]]}}
Database service
With the program pgpmyadmin it is much easier to service data in the mysql database. But it is more dangerous to have this program online. Therefore the configuration file is usually moved to another place, and just used in case:
# to use phpmyadmin do: $ cd Install $ sudo mv phpmyadmin.conf /etc/apache2/conf.d/phpmyadmin.conf $ sudo /etc/init.d/apache2 reload
For data compression over time there is the tool vzcompress2.php. See at the Links for the operation.
* By default we assume the following resolution scheme: * Newer than 7 Days Keep Original * Older than 7 Days Datapoint per 1 Minute * Older than 30 Days Datapoint per 5 Minutes * Older than 6 Month Datapoint per 15 Minutes * Older than 1 Year Datapoint per 30 Minutes # setup in crontab $ $ crontab -e # min h dom mon dow command # for volkszaehler run script on first Sonntag in month at 9 o'clock 0 9 1-7 * * [ "$(date '+%a')" == "So" ] && php /var/www/volkszaehler.org/misc/tools/vzcompress2.php > $HOME/Install/volkszaehler/vzcompress.log
Ingredients
In the Volkszaehler package some libraries are used:
volkszaehler software
The frontend has a code size of 434 KB (Javascript).
The basic library volkszaehler has just a code size of 360 KB (PHP, json).
The misc folder holds 2.4 MB (interpreter language).
jQuery
jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML. It was released in January 2006 at BarCamp NYC by John Resig. Used by over 80% of the 10,000 most visited websites, jQuery is the most popular JavaScript library in use today. Package size: minified 96 KB.
jQuery UI
jQuery UI is a curated set of user interface interactions, effects, widgets, and themes built on top of the jQuery JavaScript Library. Whether you're building highly interactive web applications or you just need to add a date picker to a form control, jQuery UI is the perfect choice. Package size: minified 230 KB.
Composer
Composer is a tool for dependency management in PHP. It allows you to declare the dependent libraries your project needs and it will install them in your project for you. Package size: 102 KB.
Doctrine
The Doctrine Project is the home to several PHP libraries primarily focused on database storage and object mapping. The core projects are a Object Relational Mapper (ORM) and the Database Abstraction Layer (DBAL) it is built upon. Package size: 6.4 MB
Object relational mapper (ORM) for PHP that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.
Powerful database abstraction layer (DBAL) with many features for database schema introspection, schema management and PDO abstraction.
jpgraph
JpGraph is an Object-Oriented Graph creating library for PHP >= 5.1 The library is completely written in PHP and ready to be used in any PHP scripts (both CGI/APXS/CLI versions of PHP are supported). Package size: 47.1 MB
phpunit
PHPUnit is a programmer-oriented testing framework for PHP. Package size: 4.3 MB
Even good programmers make mistakes. The difference between a good programmer and a bad programmer is that the good programmer uses tests to detect mistakes as soon as possible. The sooner you test for a mistake the greater your chance of finding it and the less it will cost to find and fix. This explains why leaving testing until just before releasing software is so problematic. Most errors do not get caught at all, and the cost of fixing the ones you do catch is so high that you have to perform triage with the errors because you just cannot afford to fix them all.
Testing with PHPUnit is not a totally different activity from what you should already be doing. It is just a different way of doing it. The difference is between testing, that is, checking that your program behaves as expected, and performing a battery of tests, runnable code-fragments that automatically test the correctness of parts (units) of the software. These runnable code-fragments are called unit tests.
symfony
Symfony is a PHP framework for web projects. Package size: 1.3 MB
Speed up the creation and maintenance of your PHP web applications. Replace the repetitive coding tasks by power, control and pleasure.
Links
Libraries
List of pages in this category:
-- RudolfReuter 2014-02-15 14:08:07
Go back to CategoryVolkszaehler or StartSeite ; KontaktEmail (ContactEmail)