Counting ip addresses with #lua #mod_security and #Firebird

I will use lua and mod_security to log some ip or content activity to firebird database
also we can show them in real time if we want to (selecting the last 10 visits for example)

The basic architecture is depicted in the following diagram



I count the ip addresses for one url and if it reaches certain threshold then i will trigger
an action (iptables) or deny access directly from lua (mod_sec rule)

I have a basic simple select example for lua and firebird database just to get a idea how it will look and how easy is to write one, also is good to test if lua + firebird installation is ok

	local fb = require 'fbclient.class'
	local at = fb.attach('localhost:/var/lib/firebird/2.1/data/firedjango.fdb', 'SYSDBA', 'masterkey')
	local sql = 'SELECT a.ID, a.FIRST_NAME FROM BOOKS_AUTHOR a where a.FIRST_NAME=?'
	for st, id, firstname in at:exec(sql,'Jack') do
	print(id, firstname)
	end
	at:close()

view raw test_firebird.lua hosted with ❤ by GitHub

First i have created a Security Rule Script in lua