Project LIRE & Project CYBER SENTRY

[Francis J. Lacoste]

On mer, 2003-06-18 at 09:16, Nöel Bardelot wrote:
> I wrote a mail to ask if someone was working on the 
> "Data Base" part of LIRE and after the answer of      
>  Mr Lacoste here is the global idea for this project.
> I'm sorry that the texts are in french but I think
> that only the doc file will be obscure if you don't
> speak french. For any question just ask me, and if you
> think an english version is to help, tell me, and I'll
> make a translation.
> I must precise that PostgreSQL has been chosen for
> this project. If some LIRE tools must be built in aim
> to make LIRE compatible with Cyber Sentry then I think
> I'll have to create them.


>From what I understand from your schemas, I think the simplest
solution for you would be to adapt the lr_dlf2sql script to
support PostgreSQL. This should be only a matter of allowing the
DBD-Pg driver and adapting the table schemas to not use MySQL specific
types.

You can then use lr_sql2report to generate your reports. (This script
exports the data to the DLF format used by lr_dlf2xml to generate
reports).

As a side note, the DLF format is an ASCII file (your schemas seem to
indicate that it was an XML file.) 

In that architecture, the flow of information would be :

Client's Log File -> VPN -> Convert the log file to DLF and 
                            store it in the database.

  -> Create reports using lr_sql2report

> Cyber Sentry will run under OpenBSD so I'm now
> practicing an install of OpenBSD with PostgreSQL and
> LIRE 1.3...
> 

There should be no problem installing on OpenBSD, but please report any
problems you might encounter. 

> 
> All the files added to this mail were made with Open
> Office 1.0 tools.

Take this only has a suggestion, but I think it is preferable to 
send this kinds of documents as PDF as not all people have
OpenOffice installed. I know it is a free tool, but it is not the most 
convenient to have to install such a big application only to view
documents.

P.S. I'm going away on vacation this week. I'll be back the following 
week. 


Francis J. Lacoste

-- 
Francis J. Lacoste              . .           http://www.logreport.org
/^LogReport$/               . .               flacoste at logreport.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.logreport.org/pipermail/development/attachments/20030621/7dc89797/attachment.bin