[RADIATOR] users-unable-to-connect

Mon May 13 06:54:15 UTC 2019

Thanks a lot Irvin. Our problem is solved. Yes it was blank space in end. 

Hope your remember us. We are Cyberia Middle East internet co. of Saudi
arabia. Earlier we used to have official subscription with you ..but we are
no more now.. 

Stop selling ADSL only leased lines. Therefore caring for existing customer
which becomes very minimal.. 

Ejaz  

-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au] 
Sent: Friday, May 10, 2019 1:46 AM
To: MEjaz <mejaz at cyberia.net.sa>
Cc: radiator at lists.open.com.au
Subject: Re: [RADIATOR] users-unable-to-connect

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.