[RADIATOR] Session DB error

[rohan.henry cwjamaica.com]

Hello Hugh,

Interestingly, by default NAS check (NASType is set to unknown by default) should be disabled by default but radiator is still checking user status. How do we disable NAS check?

We are using version 4.14

I am seeing following with trace 4 debug.

Thu Aug 30 23:59:40 2018: DEBUG: Query to 'dbi:mysql:radius_session:XXX.XXX.XXX.XXX': 'select username from jam_session_database where username='altheabennett'': 
Thu Aug 30 23:59:50 2018: WARNING: JAM_SDB Could not find a Client for NAS altheabennett to double-check Simultaneous-Use. Perhaps you do not have a reverse DNS for that NAS?
Thu Aug 30 23:59:50 2018: DEBUG: Radius::AuthSQL REJECT: Simultaneous-Use of 1 exceeded: altheabennett [altheabennett]
Thu Aug 30 23:59:50 2018: DEBUG: AuthBy SQL result: REJECT, Simultaneous-Use of 1 exceeded

Following is our Session DB config:

<SessionDatabase SQL>
        Identifier      JAM_SDB
        DBSource        dbi:mysql:radius_session:XXX.XXX.XXX.XXX
        DBUsername      xxxxxxxx
        DBAuth          xxxxxxxx
        AddQuery insert into jam_session_database (username, \
                 acct_session_id, timestamp, framed_ip_address, \
                 calling_station_id, nasport, circuit_id, remote_id, \
                 nas_identifier, class_message, dsl_actual_data_rate_up, dsl_actual_data_rate_down, \
                 dsl_attainable_data_rate_up, dsl_attainable_data_rate_down, bng_mac_address) \
                 values ('%n', '%{Acct-Session-Id}', '%{Timestamp}', \
                 '%{Framed-IP-Address}', '%{Calling-Station-Id}', '%{NAS-Port}', \
                 '%{DSLForum-Agent-Circuit-Id}', '%{DSLForum-Agent-Remote-Id}', '%{NAS-Identifier}', '%{Class}',\
                 '%{DSLForum-Actual-Data-Rate-Upstream}', '%{DSLForum-Actual-Data-Rate-Downstream}', \
                 '%{DSLForum-Attainable-Data-Rate-Upstream}', '%{DSLForum-Attainable-Data-Rate-Downstream}', \
                 '%{Alc-Client-Hardware-Addr}')
        CountQuery select username from jam_session_database where username='%{User-Name}'
        DeleteQuery delete from jam_session_database where nasport='%{NAS-Port}'
</SessionDatabase>

Thanks.
Rohan


----- Original Message -----
From: Hugh Irvine <hugh at open.com.au>
To: rohan.henry cwjamaica.com <rohan.henry at cwjamaica.com>
Cc: radiator <radiator at lists.open.com.au>
Sent: Mon, 30 Jul 2018 01:41:12 -0400 (EDT)
Subject: Re: [RADIATOR] Session DB error

Hello Rohan -

As usual we will need to see a copy of your configuration file together with a trace 4 debug showing what is happening.

regards

Hugh


> On 28 Jul 2018, at 16:01, rohan.henry cwjamaica.com <rohan.henry at cwjamaica.com> wrote:
> 
> Hello All,
> 
> Can you say why my session db clause is seeing username "cigreen" as a NAS?
> 
> "WARNING: JAM_SDB Could not find a Client for NAS cigreen to double-check Simultaneous-Use. Perhaps you do not have a reverse DNS for that NAS?"
> 
> My CountQuery is:
> 
> CountQuery select username from jam_session_database where username='%{User-Name}'
> 
> And even if I specify NAS_Identifier variable the correct NAS identifier is displayed but the session db clause still cannot find a client (log below).
> 
> WARNING: JAM_SDB Could not find a Client for NAS BNAS2 to double-check Simultaneous-Use. Perhaps you do not have a reverse DNS for that NAS?
> 
> Regards,
> Rohan
> _______________________________________________
> radiator mailing list
> radiator at lists.open.com.au
> http://lists.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER, SIM, etc. 
Full source on Unix, Linux, Windows, macOS, Solaris, VMS, NetWare etc.