[RADIATOR] users-unable-to-connect

Thu May 9 22:45:36 UTC 2019

Hello MEjaz -

It looks to me like there is an extra character after each of the values in the attributes that are returned from the database.

You should check the contents of the replyattr field for the users who are having problems.

regards

Hugh

> On 9 May 2019, at 20:45, MEjaz <mejaz at cyberia.net.sa> wrote:
> 
> Here complete snippet logs  for the users who unable to connect.. 
>  
> Thu May  9 13:49:45 2019: DEBUG: Packet dump:
> *** Received from 212.119.67.28 port 21811 ....
> Code:       Access-Request
> Identifier: 60
> Authentic:  <199><225><244><147><201><183><7>Br<191><172><208>jeh<29>
> Attributes:
>         Framed-Protocol = PPP
>         User-Name = "dosari5 at 512.corp.nesma.net.sa"
>         CHAP-Password = <1><178><222>T2<148>5<240><6><1><218><28>b<160>}<246><140>
>         Calling-Station-Id = "RY-DSL-HU06#3/1/0#Hofuf-324-D atm 0/12/03#512.corp.nesma.net.sa#7cad-74c1-9b74#13-585-5737#"
>         Connect-Info = "1000000000"
>         NAS-Port-Type = Virtual
>         NAS-Port = 640
>         NAS-Port-Id = "Uniq-Sess-ID640"
>         Service-Type = Framed-User
>         NAS-IP-Address = 212.119.67.28
>  
> Thu May  9 13:49:45 2019: DEBUG: Rewrote user name to dosari5 at 512.corp.nesma.net.sa
> Thu May  9 13:49:45 2019: DEBUG: Handling request with Handler ''
> Thu May  9 13:49:45 2019: DEBUG:  Deleting session for dosari5 at 512.corp.nesma.net.sa, 212.119.67.28, 640
> Thu May  9 13:49:45 2019: DEBUG: do query is: 'delete from RADONLINE where USERNAME=lower('dosari5 at 512.corp.nesma.net.sa') and NASIDENTIFIER='212.119.67.28' and NASPORT=640':
> Thu May  9 13:49:45 2019: DEBUG: Handling with Radius::AuthSQL:
> Thu May  9 13:49:45 2019: DEBUG: Handling with Radius::AuthSQL:
> Thu May  9 13:49:45 2019: DEBUG: Query is: 'select password, replyattr, checkattr  from NB_Authentication_Nesma where username='dosari5 at 512.corp.nesma.net.sa'':
> Thu May  9 13:49:45 2019: DEBUG: Radius::AuthSQL looks for match with dosari5 at 512.corp.nesma.net.sa [dosari5 at 512.corp.nesma.net.sa]
> Thu May  9 13:49:45 2019: DEBUG: Query is: 'select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='dosari5 at 512.corp.nesma.net.sa'':
> Thu May  9 13:49:45 2019: DEBUG: Radius::AuthSQL ACCEPT: : dosari5 at 512.corp.nesma.net.sa [dosari5 at 512.corp.nesma.net.sa]
> Thu May  9 13:49:45 2019: DEBUG: AuthBy SQL result: ACCEPT,
> Thu May  9 13:49:45 2019: DEBUG: Access accepted for dosari5 at 512.corp.nesma.net.sa
> Thu May  9 13:49:45 2019: ERR: There is no value named PPP  for attribute Framed-Protocol. Using 0.
> Thu May  9 13:49:45 2019: ERR: There is no value named None  for attribute Framed-Routing. Using 0.
> Thu May  9 13:49:45 2019: ERR: There is no value named 1442  for attribute Framed-MTU. Using 0.
> Thu May  9 13:49:45 2019: DEBUG: Packet dump:
> *** Sending to 212.119.67.28 port 21811 ....
> Code:       Access-Accept
> Identifier: 60
> Authentic:  <199><225><244><147><201><183><7>Br<191><172><208>jeh<29>
> Attributes:
>         Framed-IP-Address = 213.210.245.109
>         Filter-Id = "190 "
>         cisco-avpair = "ip:sub-qos-policy-out=b512"
>         Framed-Protocol = PPP
>         Framed-IP-Netmask = 255.255.255.255
>         Framed-Routing = None
>         Framed-MTU = 1442
>         Service-Type = Framed-User
>  
> From: MEjaz [mailto:mejaz at cyberia.net.sa] 
> Sent: Thursday, May 9, 2019 1:44 PM
> To: 'radiator at lists.open.com.au' <radiator at lists.open.com.au>
> Subject: users-unable-to-connect
>  
> Hello, 
>  
> Any idea for the below error,  I can see the below entries in my debug logs  when a user tried to connect 
>  
> Thu May  9 13:49:39 2019: ERR: There is no value named PPP  for attribute Framed-Protocol. Using 0.
> Thu May  9 13:49:39 2019: ERR: There is no value named None  for attribute Framed-Routing. Using 0.
> Thu May  9 13:49:39 2019: ERR: There is no value named 1442  for attribute Framed-MTU. Using 0.
>  
>  
> Thanks in advance.. 
>  
>  
> Thanks,
> Mohammed Ejaz
> Asst. Operation Director of Systems.
> Cyberia SAUDI ARABIA
> P.O.Box: 301079, Riyadh 11372
> Phone:  (+966) 11 464 7114 Ext. 140
> Mobile:  (+966) 562311787
> Fax:      (+966) 11 465 4735
> Website: http://www.cyberia.net.sa
>  
>  
>  
> _______________________________________________
> radiator mailing list
> radiator at lists.open.com.au
> https://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.