Re: ulog2-mysql-schema

Re: ulog2-mysql-schema

[Jan Engelhardt]

Cc-forwarding to nf-dev, and Eric and Pablo, who do ulogd2.

On Monday 2011-11-21 04:09, marty wrote:

> I use ulog2 to log syslog and packet data to mysql.
> I parse the data for web display using cron scripts; mostly php.
> All work very reliably and I really love ulog2 despite it's beta...
> (but the latest beta was very broken for me. I use orig beta4.)
>
> The example MySQL schemas with ulog2 are very complex and problematic, plus
> have errors and no guidance. Not being updated either...
>
> I wrote my own sql to handle logging tcp/udp packets.
> My schema is quite simple and works fine for me on Linux-3, so I took the time
> to add some complete tutorial stuff to that sql file.
> Should make it easier to get ulog/mysql working.
> I have attached my sql (zipped) to this message, as a donation.
> Please take a look.
> If you think this is useful in the ulog docs dir feel free to push
> it with any filename you choose.
> If you choose not, I won't feel hurt and you need not explain...
>
> Best wishes,
>
> Marty B.
>
>
>
>

Re: ulog2-mysql-schema

[Pablo Neira Ayuso]

On Mon, Nov 21, 2011 at 10:49:07PM +0100, Jan Engelhardt wrote:
> Cc-forwarding to nf-dev, and Eric and Pablo, who do ulogd2.
> 
> On Monday 2011-11-21 04:09, marty wrote:
> 
> > I use ulog2 to log syslog and packet data to mysql.
> > I parse the data for web display using cron scripts; mostly php.
> > All work very reliably and I really love ulog2 despite it's beta...
> > (but the latest beta was very broken for me. I use orig beta4.)
> >
> > The example MySQL schemas with ulog2 are very complex and problematic, plus
> > have errors and no guidance. Not being updated either...
> >
> > I wrote my own sql to handle logging tcp/udp packets.
> > My schema is quite simple and works fine for me on Linux-3, so I took the time
> > to add some complete tutorial stuff to that sql file.
> > Should make it easier to get ulog/mysql working.
> > I have attached my sql (zipped) to this message, as a donation.
> > Please take a look.
> > If you think this is useful in the ulog docs dir feel free to push
> > it with any filename you choose.
> > If you choose not, I won't feel hurt and you need not explain...

$ ls *.sql
mysql-ulogd2-flat.sql  pgsql-ulogd2-flat.sql
mysql-ulogd2.sql       pgsql-ulogd2.sql

I think mysql-ulogd2-flat.sql is what you want.

Please, use current ulogd2 git snapshot.

I need to find some spare to release final ulogd 2.0, it's ready for
prime time since quite some time, blame me for not having done so
before. I'll try to make it before end of this year.

Re: ulog2-mysql-schema

[Pierre Chifflier]

On Mon, Nov 21, 2011 at 10:49:07PM +0100, Jan Engelhardt wrote:
> Cc-forwarding to nf-dev, and Eric and Pablo, who do ulogd2.
> 
> On Monday 2011-11-21 04:09, marty wrote:
> 
> > I use ulog2 to log syslog and packet data to mysql.
> > I parse the data for web display using cron scripts; mostly php.
> > All work very reliably and I really love ulog2 despite it's beta...
> > (but the latest beta was very broken for me. I use orig beta4.)
> >
> > The example MySQL schemas with ulog2 are very complex and problematic, plus
> > have errors and no guidance. Not being updated either...
> >
> > I wrote my own sql to handle logging tcp/udp packets.
> > My schema is quite simple and works fine for me on Linux-3, so I took the time
> > to add some complete tutorial stuff to that sql file.
> > Should make it easier to get ulog/mysql working.
> > I have attached my sql (zipped) to this message, as a donation.
> > Please take a look.
> > If you think this is useful in the ulog docs dir feel free to push
> > it with any filename you choose.
> > If you choose not, I won't feel hurt and you need not explain...
> >
> > Best wishes,
> >

Hi,

As Pablo said, I think the schema you want is the -flat one (with one
table).

Your SQL schema was not attached in the forwarded mail from Jan, can you
resend it (to the list, or directly to me if too big) ?

Pierre