Log all status to MySQL DataBase

[real_skinner]

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

[nicolas]

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,

[real_skinner]

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