Differences

This shows you the differences between two versions of the page.

--- niota-docs:niota_grid_config_logging [2021/11/28 13:00]
admin created
+++ niota-docs:niota_grid_config_logging [2025/07/17 14:11] (current)
@@ Line 1: / Line 1: @@
-===== configure grid logging =====
+===== configure grid edit logging =====
-With this feature you can configure logging for an **existing** database connection.
+With this feature you can configure logging for an **existing** database connection. Grid edit logging means that all SQL commands that changes data are logged.
-  * Navigate to the menu item
-**generell settings->logging**
+**[[niota_grid_config_sitemap|navigate to the menu item]]**
+  * add/edit a record -> enter valid values for fields listed below
-  * Add/edit a record.
+=== DB connection to be logged ===
-  * enter valid values for fields listed below
+Database connection for which updates in tables, triggered by niota web editor, will be logged. Select a database connection from the drop down list.
-=== DB connection ===
+=== Log to file ===
-Name of a valid database connection or webservice connection defined in connection.php.
+Switch checkbox on if you want the logs to be written into the file entered in ''Logfile''.
-=== Description DB connection ===
+=== Log to DB table ===
-Description of this connection. This description is used only in the admin pages. In the grid pages the description from connections.php is used.
+Switch checkbox on if you want the logs to be written into a database table. The structure of the database table must be like [[niota_metadb_table_etx_useraction|user action table]].
-=== DB connection messages ===
+=== Logfile ===
-A valid database connection from which messages will be retrieved. If you don't want to save messages/display messages at all then leave this column empty.
+Filename and file extensions of the file where the logs are written in case ''Log to file'' is on. The logfile is located on the niota server in directory ''app\logs''.
-If you want to save messages in a database, a table **''etx_message''** in the given structur must exist in the database where this connection points to.
-=== connection type ===
+=== Callable object for logging ===
-Choose type of this connection from pulldown list.
+Choose a valid callable object (stored procedure) that handles the logging finally. This can be a delivered system log procedure or your own procedure in case you do not want to log to N-MDDB.
-{{:niota-docs:grid_config_logging_01.png|}}
+=== Logging of callable objects ===
+When logging a callable object call the logging connection is set according to the followings:
+  * When a callable object is bound to a catalog instance and called from the grid-custom-menu then the log-connection of the catalog instance is used.
+  * When a callable object is called from the transaction menu then the log-connection of the callable object connection is used.
+  * If a callable object content is placed in a file (web service or batch sql call) then only the file name is logged in the case of a successful call.
+  * If a callable object content is placed in a file (web service or batch sql call) and the call is unsuccessful then the final command / web service call is logged in the error log files.
+=== System log files ===
+There are log files which are not configurable. Those are created automatically during the running of the program.
+  * debug.log => Stores debug info. Can be activated by using debug feature.
+  * error.log => Stores error messages generated during the running of the server side conde - PHP error messages.
+  * error_sql.log => Stores sql statements which could not be executed. Also stores the database server response.
+  * error_ws.log => Stores xml contents which could not be executed. Also stores the server response.
+----
+{{:niota-docs:m_01_020_logging_01.png?nolink|}}
+----

niota

User Tools

Site Tools

Differences

Page Tools