ULOG and MySQL

[Harald Welte]

On Tue, Mar 26, 2002 at 12:22:20PM +1100, Gawain Lynch wrote:
> Hi,
> 
> I have a couple of questions regarding ULOG and MySQL, I have set them
> up and they are working a treat.

Cool, nice to hear :)

> Firstly why is it not recomended to compile ulogd with
> --with-mysql-log-ip-as-string feature?

Didn't I document this somewhere?

Anyway, the idea is that at one time you will want to run a script making
reports from the mysql database. And maybe you want to filter on particular
ip/mask pairs.  if the IP is stored as an unsigned int, you can easily
convert the IP address and mask into a range and do 

WHERE ((srcip>=min) AND (src<=max))

Matching against strings is way more difficult - and has less performance.

> Second hs anyone got any front end scripts to compile the information
> logged into teh SQL database is a useable "report" form.

Not yet, sorry. I've just completed scripts for my nacctd+MySQL accounting :)

> Thanks.

-- 
Live long and prosper
- Harald Welte / laforge@gnumonks.org               http://www.gnumonks.org/
============================================================================
GCS/E/IT d- s-: a-- C+++ UL++++$ P+++ L++++$ E--- W- N++ o? K- w--- O- M+ 
V-- PS++ PE-- Y++ PGP++ t+ 5-- !X !R tv-- b+++ !DI !D G+ e* h--- r++ y+(*)