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. _______________________________________________ radiator mailing list [email protected] https://lists.open.com.au/mailman/listinfo/radiator
