PGM3 dbLog: Unterschied zwischen den Versionen
(→Hints) |
K (Links auf contrib eingefügt; geringfügig überarbeitet) |
||
| Zeile 1: | Zeile 1: | ||
Description on how to use the module '''DbLog''' instead of plain files. | |||
== Description == | == Description == | ||
The module FileLog works fine. Perhaps you want to store your files in a MySQL-Database. In this case pgm3 has the ability to use this information instead of the plain logfiles from FileLog. | The module FileLog works fine. Perhaps you want to store your files in a MySQL-Database. In this case the pgm3 [[:Kategorie:FHEM Frontends|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). | '''This is only for experienced Users.''' Beginners should use the FileLog (default). | ||
Advantages: | 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 == | == Installation == | ||
* install pgm3 v100312 from the CVS or from fhem-4.9 | * install pgm3 v100312 from the CVS or from fhem-4.9 | ||
* read the documentation about DbLog in contrib/dbLog and install the module '''93_DbLog.pm''' and the MySQL-Database | * read the documentation about DbLog in [http://sourceforge.net/p/fhem/code/HEAD/tree/trunk/fhem/contrib/dblog/ contrib/dbLog], and [http://fhem.de/commandref.html#DbLog 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 | * write something like "'''define logdb DbLog db.conf .*:.*'''" into your fhem.cfg and restart Fhem | ||
== Limitations == | == 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. | You need at least pgm3 v100312 which is included in fhem-4.9. | ||
Version vom 6. November 2013, 14:39 Uhr
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