ULOG and MySQL
Wed, 27 Mar 2002 08:41:39 +0100
On Tue, Mar 26, 2002 at 12:22:20PM +1100, Gawain Lynch wrote:
> 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 :)
Live long and prosper
- Harald Welte / firstname.lastname@example.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+(*)