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

[John Coy]

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.