* Re: ulog2-mysql-schema
2011-11-21 21:49 ` ulog2-mysql-schema Jan Engelhardt
@ 2011-11-21 23:51 ` Pablo Neira Ayuso
2011-11-22 9:25 ` ulog2-mysql-schema Pierre Chifflier
1 sibling, 0 replies; 3+ messages in thread
From: Pablo Neira Ayuso @ 2011-11-21 23:51 UTC (permalink / raw)
To: Jan Engelhardt; +Cc: marty, Netfilter Developer Mailing List, eric
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.
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: ulog2-mysql-schema
2011-11-21 21:49 ` ulog2-mysql-schema Jan Engelhardt
2011-11-21 23:51 ` ulog2-mysql-schema Pablo Neira Ayuso
@ 2011-11-22 9:25 ` Pierre Chifflier
1 sibling, 0 replies; 3+ messages in thread
From: Pierre Chifflier @ 2011-11-22 9:25 UTC (permalink / raw)
To: marty
Cc: Netfilter Developer Mailing List, eric, Pablo Neira Ayuso,
Jan Engelhardt
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
^ permalink raw reply [flat|nested] 3+ messages in thread