Log all status to MySQL DataBase

  1. 11 years ago

    Hi Everyone,

    I am really new to FOP2 and Perl so I am not really sure where to start, been searching google and this forum about what I want to accomplish but unfortunately I can't find anything that will help me, probably just a few info like about the FOP2Callbacks.pm. I am hoping that someone from here can lead me to the right path.

    So this is what I am planning to implement. I want to log all status changes from a user to a mysql database(I might just need to learn Perl and MySQL for this) but my problem is with FOP2, where I can insert my Perl code to log the status changes.

    What I want to log is just a simple information; the user's ext number, the time stamp and the status.

    Can I do this from FOP2Callbacks.pm ? But how do I get the user's ext?

    Thanks

  2. admin

    23 Nov 2013 Administrator

    Hi,

    I think we already chatted about it. Using the audit log (-a /var/log/fop2_audit.log) is the easiest way, let fop2 log all activity and write a parser of that log files that feeds your mysql database as you like.

    Best regards,

  3. Hi Nicolas,

    Yes and thank you very much for the fast support.

    I already created a Perl script to collect the logs from fop2_audit.log and exported the data to mysql database.

    Thanks

or Sign Up to reply!