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 <[email protected]>
To: rohan.henry cwjamaica.com <[email protected]>
Cc: radiator <[email protected]>
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
> <[email protected]> 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
> [email protected]
> http://lists.open.com.au/mailman/listinfo/radiator
--
Hugh Irvine
[email protected]
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.
_______________________________________________
radiator mailing list
[email protected]
http://lists.open.com.au/mailman/listinfo/radiator
