• Mystic BBS Logs DB Loader

    From shinobi@21:1/153 to All on Saturday, March 31, 2018 21:49:37
    Hello All,

    I had like hour of time and while talking to Avon I had an idea.

    Not a particular new one... to load my mutil and fidopoll logs
    to database for easier searching ... or rather querying.

    So I just made a simple set of scripts that will help to achieve
    that. I don't know if it's rather to try. And it's for linux only.

    The set is released under lolo1a.zip.

    There are two init*.py scripts to prepare the sqlite database.
    And then ldr*.py scripts to load fidopoll*.log and mutil*.log to
    it. As first argument the filename that has to be loaded has to
    be given.

    All the scripts has to be prepare before run. And that means change
    path to mystic bbs logs directory.

    I'm thinking about continuing in this path. But my BBS is not large
    enough to comfort any bigger usage. But if it grows. Who knows.

    Regards

    Shinobi

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)
  • From shinobi@21:1/153 to shinobi on Saturday, March 31, 2018 22:07:22
    There are two init*.py scripts to prepare the sqlite database.
    And then ldr*.py scripts to load fidopoll*.log and mutil*.log to
    it. As first argument the filename that has to be loaded has to
    be given.

    I suppose the logs are rotate with something like e.g. that: /etc/logrotate.d/bbs
    <path_to_bbs/logs/*.log {
    missingok
    sharedscripts
    delaycompress
    postrotate
    endscript
    }

    And the point is to have all the recent files in one place and be able to query it.

    Best regards

    Shinobi

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)