Hello Jesus -
This is because you are dealing with two different transactions - the
authentication request and the accounting request. The
Reply:Framed-IP-Address is only valid during the authentication
processing - it is not present during the accounting processing.
You could try to put the Framed-IP-Address into the Class attribute
during the authentication, which will cause the Class attribute to be
included in all subsequent accounting packets for the session. Then
you could use the Class attribute in your AddQuery.
hth
Hugh
At 16:06 +0200 28/8/00, Jesus M Diaz wrote:
>Hi all,
>
>cisco routers do not inform about ip-addresses are assigned to
>virtual-access (i.e., users connected through l2tp
>tunnels), so, i try to save the information on RADONLINE table with
>next command at the 'sessiondatabase' clause:
>
>AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
>ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
>NASPORTTYPE, SERVICETYPE, CALLEDPHONE) values ('%u', '%N',
>%{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp}, '%
>{Reply:Framed-IP-Address}', '%{Port-Type}', '%{Service-Type}',
>'%{Called-Station-Id}')
>
>but, i can see than at logs:
>
>Mon Aug 28 15:22:54 2000: DEBUG: do query is: insert into RADONLINE
>(USERNAME,NASIDENTIFIER,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,SERVICETYPE,CALLEDPHONE)
>values ('parachi@maqueta', '212.95.216.16', 1, '00000018',
>967468974, '', '', 'Framed-User', '914842100')
>
>the 6th data is blank, why?
>
>can anyone help me?
>
>
>Jesus M Diaz <[EMAIL PROTECTED]>
>
>Telia Iberia, S.A.
>Planificación y Diseño de Red
>Tfno: +34 91 623 2909
>Fax: +34 91 623 2950
>
>
>
>===
>Archive at http://www.starport.net/~radiator/
>Announcements on [EMAIL PROTECTED]
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
--
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.