<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi All;<BR>
<BR>
I have been reading unlang and also digging the Internet for help with my issue.<BR>
<BR>
I have added the following line to "vi sql/mysql/dialup.conf"<BR><BR>
#Comented out this line<BR>
#sql_user_name = "%{User-Name}"<BR><BR>
#as per the man pages:<BR>
# Double-quoted strings are expanded by inserting the value of any variables <BR>
# Single-quoted strings are evaluated as-is.<BR>
<BR>
<BR>
if("%{User-Name}" == 'london'){<BR>
sql_user_name = "hasworked"<BR>
}<BR><BR>
And i try to logon using the username london<BR>
<BR>
Still not working!!<BR>
<BR>
I get:<BR>
<BR>
Listening on authentication address * port 1812<BR>Listening on accounting address * port 1813<BR>Listening on command file /var/run/radiusd/radiusd.sock<BR>Listening on proxy address * port 1814<BR>Ready to process requests.<BR>rad_recv: Access-Request packet from host 192.168.2.253 port 4981, id=41, length=222<BR> Acct-Session-Id = "1096"<BR> NAS-IP-Address = 192.168.2.253<BR> Service-Type = Framed-User<BR> Framed-Protocol = PPP<BR> NAS-Port = 0<BR> MS-RAS-Vendor = 311<BR> MS-RAS-Version = "MSRASV5.20"<BR> NAS-Port-Type = Virtual<BR> Tunnel-Type:0 = PPTP<BR> Tunnel-Medium-Type:0 = IPv4<BR> Calling-Station-Id = "10.10.108.136"<BR> Tunnel-Client-Endpoint:0 = "10.10.108.136"<BR> MS-RAS-Client-Version = "MSRASV5.10"<BR> MS-RAS-Client-Name = "MSRAS-0-CRIS_D620_LAPTO"<BR> User-Name = "london"<BR> CHAP-Challenge = 7006be2aedd9dca01<BR> CHAP-Password = 2f9fea3082b5bae5fb<BR>+- entering group authorize {...}<BR>[preprocess] expand: %{User-Name} -> london<BR>++[preprocess] returns ok<BR>[chap] Setting 'Auth-Type := CHAP'<BR>++[chap] returns ok<BR>++[mschap] returns noop<BR>rlm_sql (sql): Reserving sql socket id: 3<BR>[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '' ORDER BY id<BR>[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup <STRONG> WHERE username = '' ORDER </STRONG>BY priority<BR>rlm_sql (sql): Released sql socket id: 3<BR>[<STRONG>sql] User not found</STRONG><BR>++[sql] returns notfound<BR>++[expiration] returns noop<BR>++[logintime] returns noop<BR>[pap] WARNING! No "known good" password found for the user. Authentication may fail because of this.<BR>++[pap] returns noop<BR>Found Auth-Type = CHAP<BR>+- entering group CHAP {...}<BR>[chap] login attempt by "london" with CHAP password<BR>[chap] Cleartext-Password is required for authentication<BR>++[chap] returns invalid<BR>Failed to authenticate the user.<BR>Using Post-Auth-Type Reject<BR>+- entering group REJECT {...}<BR>[attr_filter.access_reject] expand: %{User-Name} -> london<BR> attr_filter: Matched entry DEFAULT at line 11<BR>++[attr_filter.access_reject] returns updated<BR>Delaying reject of request 0 for 1 seconds<BR>Going to the next request<BR>Waking up in 0.9 seconds.<BR>Sending delayed reject for request 0<BR>Sending Access-Reject of id 41 to 192.168.2.253 port 4981<BR>Waking up in 4.9 seconds.<BR>Cleaning up request 0 ID 41 with timestamp +3<BR>Ready to process requests.<BR><BR> <br /><hr />Not got a Hotmail account? <a href='http://clk.atdmt.com/UKM/go/197222280/direct/01/' target='_new'>Sign-up now - Free</a></body>
</html>