PGM3 dbLog: Unterschied zwischen den Versionen

Aktuelle Version vom 30. Juli 2019, 08:37 Uhr

Das Frontend PGM3 wurde eingestellt. Von einer weiteren Nutzung wird daher abgeraten.
Alte 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/DbLog, 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

@@ Zeile 1: / Zeile 1: @@
-= Use the module DbLog instead of plain files =
+{{Randnotiz|RNTyp=Info|RNText=Das Frontend PGM3 wurde eingestellt. Von einer weiteren Nutzung wird daher abgeraten.<br>Alte Version im [http://svn.fhem.de/trac/browser/trunk/fhem/webfrontend/pgm3 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 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:
+* 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.
-* on weak machines like the NSLU2 it is more fast 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 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 {{Link2CmdRef|Anker=DbLog}}, 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
+* write something like "'''define logdb DbLog db.conf .*:.*'''" into your fhem.cfg and restart Fhem
 == Limitations ==
-In the moment every supported device except the UserDefs are supported for dbLog.
+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.
@@ Zeile 20: / Zeile 23: @@
 * install "phpmyadmin" to administrate and test your database
 * backup your database with ''mysqldump fhem --user=&lt;USER&gt; --password=&lt;PASSWD&gt; --add-drop-table -c &gt; fhem.sql''
+== Links ==
+* [[PGM3_Optimize_for_Smartphones|PGM3 Optimize for Smartphones]]
+* [[PGM3_NewSkins|PGM3 NewSkins]]
+* [[PGM3_Installation_and_Troubleshooting|PGM3 Installation and Troubleshooting]]
+* [[PGM3_und_AVM_Fritz!Box|PGM3 und AVM Fritz!Box]]
+[[Kategorie:HOWTOS]]
+[[Kategorie:Logging]]