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 <[email protected]> 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 = "[email protected]" > 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 > [email protected] > Thu May 9 13:49:45 2019: DEBUG: Handling request with Handler '' > Thu May 9 13:49:45 2019: DEBUG: Deleting session for > [email protected], 212.119.67.28, 640 > Thu May 9 13:49:45 2019: DEBUG: do query is: 'delete from RADONLINE where > USERNAME=lower('[email protected]') 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='[email protected]'': > Thu May 9 13:49:45 2019: DEBUG: Radius::AuthSQL looks for match with > [email protected] [[email protected]] > Thu May 9 13:49:45 2019: DEBUG: Query is: 'select NASIDENTIFIER, NASPORT, > ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where > USERNAME='[email protected]'': > Thu May 9 13:49:45 2019: DEBUG: Radius::AuthSQL ACCEPT: : > [email protected] [[email protected]] > Thu May 9 13:49:45 2019: DEBUG: AuthBy SQL result: ACCEPT, > Thu May 9 13:49:45 2019: DEBUG: Access accepted for > [email protected] > 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:[email protected]] > Sent: Thursday, May 9, 2019 1:44 PM > To: '[email protected]' <[email protected]> > 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 > [email protected] > https://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] https://lists.open.com.au/mailman/listinfo/radiator
