Store logs to LMS logs to MySQL

Site Operators Tutor Help
,
1

Hi,

I’m currently writing a python script to process tracking.log for LMS.
I was wondering if there’s a configuration for storing activities on the MySQL database or another format that’s easier to load.
Currently, I need to remove the prefix on each line to extract the JSON which is not scalable.
This is an example of the prefix:
2022-06-24 16:06:22,515 INFO 19 [tracking] [user None] [ip 193.110.106.130] logger.py:41 -

Any help would be appreciated.

2

You can take a look at the built-in segment.io connection to capture most of that data.
6. Analytics — Open edX Developer's Guide documentation