Hello Ejaz - Yes of course I remember you - I hope all is well.
I’m pleased I was able to help. regards Hugh > On 13 May 2019, at 16:54, MEjaz <[email protected]> wrote: > > 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:[email protected]] > Sent: Friday, May 10, 2019 1:46 AM > To: MEjaz <[email protected]> > Cc: [email protected] > 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 <[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. > > -- 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
