Hi all,

I’m trying to use mod_dbd to retrieve data based on user’s IP address and use that data for a customized http request header using mod_headers, but can’t seems to get dbd to work and I can’t find any good example on mod_dbd usage anywhere. This apache is setup for proxy using mod_proxy and I use the following to get remote address:

SetEnvIfNoCase Remote_Addr "(.*)" HTTP_MY_REMOTE_ADDR=$1

RequestHeader add Test-IPADDR “%{HTTP_MY_REMOTE_ADDR}e”

I use the following info below to test (I use static instead of Remote Addr to test):

DBDriver mysql

DBDPersist On

DBDParams host=192.168.12.13,user=username,pass=password,dbname=freeradius

DBDPrepareSQL "select calledstationid from radacct where framedIPAddress = ‘192.168.12.51' and AcctStartTime = (select max(AcctStarttime) from radacct where framedIPAddress = '192.168.12.51')" STATIONID

I need to know what do I need to do so that DBD sql query use Remote_Addr for query and how can I pass the result so that I can use it with “RequestHeader add”?

Cheers,