Talologger, Talologgerpi + mysql
When the talologger was first set up the talologgerpi script did not install mysql database but instead used sqlite database. Now after a year of running the logger it was time to add the mysql data storage and ditch the sqlite. It is pretty easy and to my surprise after typing all the config it did just work. A little miracle. Copy paste could have been understandable but after typing.
Well.. The documentation of the talologger project is lagging a bit but fortunately there are other pieces of information available. For the mysql there was some other application to analyze talologger data – Logintutkija (log analyzer) and the instruction there explained on how to set up mysql with talologger. http://www.railers.fi/nalle/tools/Logintutkija_ohje.pdf
The most interesting and usable lines were from 13) on including creation of database, user and granting access to user. Also settings on talologger.conf were interesting.
One part of that:
drop database if exists talologger;
create database talologger;
use talogger;
The rest you can read from the instruction. It is in finnish but the commands are easy to follow. You will also need to change database settings in talologgergraph.conf if you stop using the sqlite database.
One year of logging was around 400MB of data. The hardware is raspberry pi and some ds18b20 temperature sensors in 1-wire network that is wired to raspberry gpio. For the oil burner there is a ldr to detect the operation.
