smchamberlin / node-red-contrib-ibm-db2

Node-RED nodes to work with a Db2 LUW database. Works with "Db2 on Cloud" and "Db2 Warehouse on Cloud" services as well as standalone installation of Db2 LUW.
4 stars 14 forks source link

Switch off logging other than errors and warnings #9

Open tonykambo opened 7 years ago

tonykambo commented 7 years ago

In looking at the Bluemix logs whenever the dashDB in node reads from the database it adds the following into the Bluemix application log:

Fetching rows: [object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object] value 1: {....actual data retrieved from dashDB....}

It would be very helpful from a security perspective if this type of logging could be disabled. Whilst useful for debugging it is not desired for production.

sirvio commented 7 years ago

This case is valid also on inserts! ALL the inserted data is written to log and then one additional log row for every successfull insert. This kind of logging should definitely be on finest trace level only!

sirvio commented 7 years ago

did make a pull request to change logging according https://nodered.org/docs/configuration pages "Runtime Configuration/logging" -section