Re: accounting Framed-IP-Address

2010-03-16 Thread Alan DeKok
omega bk wrote: > is it possible to retrieve from dhcp server the ip adress? It's time to stop asking non-RADIUS questions on this list. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: accounting Framed-IP-Address

2010-03-16 Thread omega bk
i tried to put *radius-server attribute 8 include-in-access-req but still the same; is it possible to retrieve from dhcp server the ip adress? * 2010/3/16 omega bk > hi, > > i got cisco 3750 switch > > and for accounting i put > > aaa new-model > aaa authentication dot1x default group radius >

Re: accounting Framed-IP-Address

2010-03-16 Thread omega bk
hi, i got cisco 3750 switch and for accounting i put aaa new-model aaa authentication dot1x default group radius aaa authorization network default group radius aaa accounting dot1x default start-stop group radius but this ip i don't know where it took it lol FramedIPAddress = 3.118.236.192 th

Re: accounting Framed-IP-Address

2010-03-16 Thread Alan Buxey
Hi, > but i noticed that i don't have the real ip address of a workstation > connected. > i got this > > +-+-+-+---+-+ > | FramedIPAddress | AcctStartTime | AcctStopTime | > CallingStationI

Re: accounting Framed-IP-Address

2010-03-16 Thread Alan Buxey
Hi, > destination acct_radius { pipe("/var/log/mysql.pipe" \ > template("UPDATE radacct SET FramedIPAddress = > SUBSTRING_INDEX(SUBSTRING_INDEX('$MSG','on ',-1),' to',1) \ > WHERE TIMESTAMPDIFF(SECOND,AcctStartTime,CONCAT('$YEAR-$MONTH-$DAY',' > ','$HOUR:$MIN:$SEC')) <= 180 AND \ > REPLACE(REPLA

Re: accounting Framed-IP-Address

2010-03-16 Thread omega bk
Hi, i'm trying syslog-ng to get ip address from dhcp log so i need to have the frameipaddress field to be empty in order to replace it from dhcp log so in syslog-ng.conf, i put : source dhcp { tcp(ip(0.0.0.0) port(514)); }; # log { source(dhcp); destination(acct_radius); };

accounting Framed-IP-Address

2010-03-16 Thread omega bk
HI, i can do accounting with mysql, it's working so fine. but i noticed that i don't have the real ip address of a workstation connected. i got this +-+-+-+---+-+ | FramedIPAddress | AcctStartTime |