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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.