(RADIATOR) session database not logging variable %{Framed-IP-Address}

[Hugh Irvine]

Hello John -

Can you send me a trace 4 debug showing the packet dumps and so on please?

thanks

Hugh

On Friday 08 June 2001 16:26, John Coy wrote:
> I just upgraded to Radiator 2.18.1 on a Sun Solaris box.  After
> my upgrade, my session database is no longer logging the
> %{Framed-IP-Address} variable.  It appears to be undefined.  Included
> below are my session database config and a debug output from
> a Trace 4 on the insertion process.
>
> The variable %{Framed-IP-Address} is being logged on my RADIUS
> accounting packets, however.
>
> I'm curious if this is a bug with the session database that someone
> else has encountered?  Advice appreciated.
>
> PS - I saw today that 2.18.2 was released, but no mention of
> a bug that affects the session database.
>
> <SessionDatabase SQL>
>          DBSource        dbi:Oracle:XYZ
>          DBUsername      ABC
>          DBAuth          123
>
>          AddQuery \
>              INSERT INTO radonline \
>                  ( username, \
>                    server, \
>                    port, \
>                    session_id, \
>                    login_time, \
>                    framed_address ) \
>              VALUES \
>                  ( LOWER(SUBSTR('%{User-Name}', 0, 50)), \
>                    '%{NAS-Identifier}', \
>                    NVL((%{NAS-Port}-0), 0), \
>                    '%{Acct-Session-Id}', \
>                    NVL((%{Timestamp}-0), 0), \
>                    '%{Framed-IP-Address}' )
>
>          DeleteQuery \
>              DELETE FROM radonline \
>              WHERE username = LOWER(SUBSTR('%{User-Name}', 0, 50)) \
>              AND   port     = NVL((%{NAS-Port}-0), 0) \
>              AND   server   = '%{NAS-Identifier}'
>
>          ClearNasQuery \
>              DELETE FROM radonline \
>              WHERE  server = '%{NAS-Identifier}'
>
>          CountQuery \
>              SELECT server, port, session_id \
>              FROM   radonline \
>              WHERE  username = LOWER(SUBSTR('%{User-Name}', 0, 50))
>
> </SessionDatabase>
>
> Fri Jun  8 01:23:51 2001: DEBUG: do query is: INSERT INTO radonline (
> username,
> server, port, session_id, login_time, framed_address ) VALUES (
> LOWER(SUBSTR('ch
> rist', 0, 50)), '216.152.9.3', NVL((20203-0), 0), '360159532',
> NVL((991981431-0)
> , 0), '' )
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.