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 / [EMAIL PROTECTED] 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+(*)
