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, |