DB Connection logging

[Phil Frankford]

Greetings -
We are trying to audit our Automic DB connection successes and failures.
1) Where are the logs kept for all DB connection attempts?
2) Are there any INI settings that control the DB connection logging?
3) Can we see the DB connection string attempted for each success and failure?
    We want to see the full connect parms:  server/port, db, user, and psw (if available).

Thanks for your help.
Be Well,
Phil

------------------------------
Colony Brands
------------------------------

[Pete Wirfs]

Why?  What problem are you trying to solve?

DB logging is typically turned on only when needed.  Otherwise it can harm product performance.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Pete Wirfs]

The Automic engine stores its log files in a "temp" folder right beside the "bin" folder that it executes from.  There are many different sets of files, one set for each Automic service you are running.  The files numbered "_00" are the currently active file, "_01" is the next oldest, etc.  The number of files available is an administrative setting.  However I don't think you can control when the engine decides to close a log file and start writing a new one.  So the number of days of history you have available can flux.

DBlogging(tracing) can be altered from the Administration/AutomationEngineManagement/ProcessAndUtilization screen.  Right-click on the desired service, select AdvancedOptions, and change the Database rule dropdown.  However I doubt that this will give you all of the details you have asked for, particularly password?  No product should ever allow you to write out passwords to a log file.


------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------