← Back Home

FX - Log @ Server @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Log

log trace log write log show log current id log retention day log remove log archive size log archive path log reset log search log show_time

log trace <text>

Description

To write a message into the log system

Parameters

text: The text - string - required

admin
log trace test;

mentdb
1

log write <msg> <status> <clientKey> <clientValue>

Description

To write a message into MySQL

Parameters

msg: The message to write - string - required
status: The status - string - required
clientKey: The client key - string - required
clientValue: The client value - string - required

admin
log write "My message ..." OK "cmd" 425;

mentdb
1

log show <nbLine>

Description

To show last write text into the log system

Parameters

nbLine: The number of line - integer - not required

admin
log show 5;

mentdb
2017-06-05 10:35:42.375+0400: 43
2017-06-05 10:35:42.375+0400: 44
2017-06-05 10:35:42.380+0400: 1: your messffage ...
2017-06-05 10:35:42.896+0400: test

admin
log show

mentdb
2017-06-05 10:35:42.375+0400: 43
2017-06-05 10:35:42.375+0400: 44
2017-06-05 10:35:42.380+0400: 1: your messffage ...
2017-06-05 10:35:42.896+0400: test

log current id

Description

To show the current log id

admin
log current id

mentdb
1

log retention day

Description

To show the log retention day

admin
log retention day

mentdb
50

log remove

Description

To remove logs with retention day

admin
log remove;

mentdb
1

log archive size

Description

To show the size for one archive file

admin
log archive size

mentdb
30

log archive path

Description

Get the path to save archives

admin
log archive path

mentdb
archives/logs

log reset <code>

Description

To reset the log system

Parameters

code: The code to reset all tables (18061980) - integer - not required

admin
log reset "xxx";

mentdb
1

log search <status> <script> <c_key> <c_value> <msgFilter> <dtMin> <dtMax> <dtOrder> <page> <nbByPage>

Description

To search log

Parameters

status: The status (ok|ko) - string - required
script: The script (can be null) - string - required
c_key: The client key - string - required
c_value: The client value - string - required
msgFilter: The message filter - string - required
dtMin: The min date - string - required
dtMax: The max date - string - required
dtOrder: The order (ASC|DESC) - string - required
page: The page - number - required
nbByPage: The number of line by page - number - required

admin
log search "ko" 
	null 
	null 
	null 
	null 
	(date datedifft (concat (date sysdate) " 00:00:00") "DAY" 0)
	(concat (date sysdate) " 23:59:59") 
	ASC 1 5;

mentdb
{"column_types":["STRING","STRING","STRING","STRING","STRING","STRING","STRING","STRING","LONG"],"data":[],"columns":["dtInsert","status","script","parent_pid","pid","c_key","c_val","msg","id"],"title":"log "}"

log show_time <nodename> <pid>

Description

To show log throught the time

Parameters

nodename: The node name - string - not required
pid: The process id - string - required

admin
log show_time 17

mentdb
{"column_types":["STRING","STRING","STRING","STRING","STRING","STRING","STRING","STRING","LONG"],"data":[{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-01-09 15:44:40","parent_pid":"","pid":"17","id":"887","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-01-09 15:44:40","parent_pid":"","pid":"17","id":"888","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-01-22 07:12:22","parent_pid":"","pid":"17","id":"1307","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-01-22 07:12:22","parent_pid":"","pid":"17","id":"1308","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-02-13 16:08:54","parent_pid":"","pid":"17","id":"2589","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-02-13 16:08:54","parent_pid":"","pid":"17","id":"2590","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-02-20 10:15:29","parent_pid":"","pid":"17","id":"2781","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-02-20 10:15:29","parent_pid":"","pid":"17","id":"2782","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-02-23 13:51:35","parent_pid":"","pid":"17","id":"3029","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-02-23 13:51:35","parent_pid":"","pid":"17","id":"3030","c_key":"","script":"boot.execute.on.start.post","status":"ok"}],"columns":["dtInsert","status","script","parent_pid","pid","c_key","c_val","msg","id"],"title":"PID <17>"}

start: 2026-02-02end: 2026-02-02v_start: 401v_end: