Log all status to MySQL DataBase
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
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
Comments
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,
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