PGM3 dbLog

Aus FHEMWiki
Version vom 18. Februar 2015, 19:54 Uhr von Krikan (Diskussion | Beiträge) (Hinweis auf Entwicklungsstillstand und Verlinkung)
Info green.pngDas Frontend PGM3 wird seit längerem nicht aktiv weiterentwickelt!
Aktuellste Version im SVN

Description on how to use the module DbLog instead of plain files.

Description

The module FileLog works fine. Perhaps you want to store your files in a MySQL-Database. In this case the pgm3 frontend has the ability to use this information instead of the plain logfiles from FileLog.

This is only for experienced Users. Beginners should use the FileLog (default).

Advantages:

  • on weak machines like the NSLU2 it is faster than file logging.
  • if fhem and pgm3 are on different machines you do not need nfs any more to get the logs.

Installation

  • install pgm3 v100312 from the CVS or from fhem-4.9
  • read the documentation about DbLog in contrib/dbLog, and commandref, and install the module 93_DbLog.pm and the MySQL-Database
  • write something like "define logdb DbLog db.conf .*:.*" into your fhem.cfg and restart Fhem

Limitations

At the moment every supported device except the UserDefs are supported for dbLog. You need at least pgm3 v100312 which is included in fhem-4.9.

Hints

  • install "phpmyadmin" to administrate and test your database
  • backup your database with mysqldump fhem --user=<USER> --password=<PASSWD> --add-drop-table -c > fhem.sql

Links