Automic Workload Automation

Expand all | Collapse all

DB Connection logging

  • 1.  DB Connection logging

    Posted 30 days ago
    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
    ------------------------------


  • 2.  RE: DB Connection logging

    Posted 30 days ago
    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
    ------------------------------



  • 3.  RE: DB Connection logging

    Posted 30 days ago
    Edited by Pete Wirfs 30 days ago
    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
    ------------------------------