Ladies/Gents,
Second message reference this subject, first one seems to have lost it's way !!
Has anyone implemented an IVR application using FreeRadius and Lucent MAX TNT gateways WITHOUT using Lucent's MVAM gatekeeper/controller software ?
We successfully have those gateways registering to GnuGK and and FreeRadius for whole sale voice without any problems. Has anyone been able to achieve a calling card platform utilising a similar setup ?
Thanks
Ahmad Ibrahim Director ABC (Europe) LTD web: www.abc-europe.com
[EMAIL PROTECTED] wrote:
Send Freeradius-Users mailing list submissions to [EMAIL PROTECTED]
To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeradius.org/mailman/listinfo/freeradius-users or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED]
You can reach the person managing the list at [EMAIL PROTECTED]
When replying, please edit your Subject line so it is more specific than "Re: Contents of Freeradius-Users digest..."
Today's Topics:
1. Re: RH9 and Freeradius make error (Alan DeKok) 2. Re: FW: Need Assistance please (Alan DeKok) 3. Re: MS-CHAP/PEAP (Alan DeKok) 4. Help - a very different network config (Christopher M Bailey) 5. Freeradius + Mysql Issues! (Alexander Khoo) 6. RE: Freeradius + Mysql Issues! (Manjunath M Prabhu)
--__--__--
Message: 1
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: RH9 and Freeradius make error Date: Wed, 26 May 2004 21:25:58 -0400
Reply-To: [EMAIL PROTECTED]
amar <[EMAIL PROTECTED]> wrote:
I installed RH9 issue of mysql (not dev.)
Install the MySQL development RPM. Nothing else will solve the problem.
Alan DeKok.
--__--__--
Message: 2
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: FW: Need Assistance please Date: Wed, 26 May 2004 21:27:37 -0400
Reply-To: [EMAIL PROTECTED]
"Rivera, Denis" <[EMAIL PROTECTED]> wrote:
Alan,
I'd first would like to extend my gratitude for answering my email.
No need to be nice... I don't bruise easily.
Alan, the "User" "Change Password" "Administrator" etc., are already part of the LDAP schema (under the attribute securityRole) e.g.
Uid=testuser
Attribute Value
securityRole Users
The value should have the operator in it. e.g. +=Users
I've modified the file ldap.attrmap as follow (this is the only change I've made)
replyItem Login-LAT-Group securityRole
That should work.
I thought by modifying this line to match the LDAP attribute would return
all values for the user (testuser) in the LDAP schema.
No. The operators are still important.
Alan DeKok.
--__--__--
Message: 3
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: MS-CHAP/PEAP Date: Wed, 26 May 2004 21:29:24 -0400
Reply-To: [EMAIL PROTECTED]
Damjan <[EMAIL PROTECTED]> wrote:
What are the differences between PEAP and EAP-TTLS?
From a user perspective, both are similar. From a protocol design, PEAP is terrible, and EAP-TTLS is sane. But XP comes with PEAP, so what are you going to do?
Which one is more secure?
Both are pretty much the same.
Which one has broader support in supplicants?
XP comes with PEAP. Other than that, most supplicants support both.
Can I use both eap-ttls and peap?
Yes.
Alan DeKok.
--__--__--
Message: 4 Subject: Help - a very different network config From: Christopher M Bailey <[EMAIL PROTECTED]> To: FreeRADIUS <[EMAIL PROTECTED]> Date: Thu, 27 May 2004 12:40:43 +1000 Reply-To: [EMAIL PROTECTED]
Hi all
Looking for some help. What I need to find out is how to config a radius to auth all my Wireless traffic before issuing an IP via DHCP, then letting it auth on a Windows, Novell or Apple LAN. the other catch is that I need to authenticate to a LDAP server upstream, while allowing all me hardwired PC's to obtain an IP via DHCP but by passing the radius server. I believe I can do this with FreeRADIUS. I don't want much do I?
Thanks, Chris Bailey
--__--__--
Message: 5 Date: Wed, 26 May 2004 20:47:28 -0700 (PDT) From: Alexander Khoo <[EMAIL PROTECTED]> Subject: Freeradius + Mysql Issues! To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]
--0-1727261780-1085629648=:78369 Content-Type: text/plain; charset=us-ascii
Hi all,
My goal is to use Freeradius with the sql module for authenticating
users. I'm using version 0.9.3 (installed from rpms i created with the
specfile that came with the tarball).I've been working
off of this tutorial: http://www.frontios.com/freeradius.html
I got but then I proceeded to follow the instructions for sql and have run in to some trouble. I followed all of the required steps and am unable to authenticate. I'm using the following command to test the server:
radtest alexander jujai localhost 17 password
and i get the following result:
[EMAIL PROTECTED] root]# radtest alexander jujai localhost 17 password
Sending Access-Request of id 240 to 127.0.0.1:1812
User-Name = "alexander"
User-Password = "jujai"
NAS-IP-Address = gk.orbit2000.net
NAS-Port = 17
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=240, length=20
Here is a snippet of the output produced when i run in debug mode:
rad_recv: Access-Request packet from host 127.0.0.1:32769, id=240, length=61
User-Name = "alexander"
User-Password = "jujai"
NAS-IP-Address = 255.255.255.255
NAS-Port = 17
modcall: entering group authorize for request 0
modcall[authorize]: module "preprocess" returns ok for request 0
modcall[authorize]: module "chap" returns noop for request 0
modcall[authorize]: module "eap" returns noop for request 0
rlm_realm: No '@' in User-Name = "alexander", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for request 0
radius_xlat: 'alexander'
rlm_sql (sql): sql_set_user escaped user --> 'alexander'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'alexander' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'alexander' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'alexander' ORDER BY id'
radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'alexander' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): No matching entry in the database for request from user [alexander]
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound for request 0
users: Matched DEFAULT at 152
modcall[authorize]: module "files" returns ok for request 0
modcall[authorize]: module "mschap" returns noop for request 0
modcall: group authorize returns ok for request 0
rad_check_password: Found Auth-Type System
auth: type "System"
modcall: entering group authenticate for request 0
modcall[authenticate]: module "unix" returns notfound for request 0
modcall: group authenticate returns notfound for request 0
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Sending Access-Reject of id 240 to 127.0.0.1:32769
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 240 with timestamp 40b49ae9
Nothing to do. Sleeping until we see a request.
And here's the only entry in my radcheck table:
+----+----------+-----------+----+---------+
| id | UserName | Attribute | op | Value |
+----+----------+-----------+----+---------+
| 1 | alexander| Password | == | password|
+----+----------+-----------+----+---------+
Any suggestions would be greatly appreciated. I've been working on this
for several days now and haven't made much progress. I hope I've done
enough footwork on my own to keep away the flames :)
Thanks in advance,
--------------------------------- Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger --0-1727261780-1085629648=:78369 Content-Type: text/html; charset=us-ascii
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><PRE><SPAN style="COLOR: black">Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">My goal is to use Freeradius with the sql module for authenticating<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">users. I'm using version 0.9.3 (installed from rpms i created with the<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">specfile that came with the tarball).I've been working<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">off of this tutorial:<SPAN style="mso-spacerun: yes"> </SPAN><A href="http://www.frontios.com/freeradius.html";>http://www.frontios.com/freeradius.html</A><o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p></o:p></SPAN><SPAN style="COLOR: black">I got but then I proceeded to follow the instructions for sql and have <SPAN style="mso-spacerun: yes"> </SPAN>run in to some trouble. I followed all of the required steps and am unable to authenticate. I'm using the following command to test the server:<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">radtest alexander jujai localhost 17 password<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">and i get the following result:<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p></o:p></SPAN><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">[EMAIL PROTECTED] root]# radtest alexander jujai localhost 17 password<o:p></o:p></SPAN></PRE> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Sending Access-Request of id 240 to 127.0.0.1:1812<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>User-Name = "alexander"<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>User-Password = "jujai"<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>NAS-IP-Address = gk.orbit2000.net<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>NAS-Port = 17<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=240, length=20<o:p></o:p></SPAN></P><PRE><SPAN style="COLOR: black"></SPAN> </PRE><PRE><SPAN style="COLOR: black">Here is a snippet of the output produced when i run in debug mode:<o:p></o:p></SPAN></PRE></SPAN> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rad_recv: Access-Request packet from host 127.0.0.1:32769, id=240, length=61<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>User-Name = "alexander"<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>User-Password = "jujai"<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>NAS-IP-Address = 255.255.255.255<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>NAS-Port = 17<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: entering group authorize for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "preprocess" returns ok for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "chap" returns noop for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "eap" returns noop for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>rlm_realm: No '@' in User-Name = "alexander", looking up realm NULL<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>rlm_realm: No such realm "NULL"<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "suffix" returns noop for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">radius_xlat:<SPAN style="mso-spacerun: yes"> </SPAN>'alexander'<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): sql_set_user escaped user --> 'alexander'<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">radius_xlat:<SPAN style="mso-spacerun: yes"> </SPAN>'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'alexander' ORDER BY id'<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): Reserving sql socket id: 4<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">radius_xlat:<SPAN style="mso-spacerun: yes"> </SPAN>'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op<SPAN style="mso-spacerun: yes"> </SPAN>FROM radgroupcheck,usergroup WHERE<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">usergroup.Username = 'alexander' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">radius_xlat:<SPAN style="mso-spacerun: yes"> </SPAN>'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'alexander' ORDER BY id'<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">radius_xlat:<SPAN style="mso-spacerun: yes"> </SPAN>'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op<SPAN style="mso-spacerun: yes"> </SPAN>FROM radgroupreply,usergroup WHERE<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">usergroup.Username = 'alexander' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): No matching entry in the database for request from user [alexander]<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): Released sql socket id: 4<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "sql" returns notfound for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>users: Matched DEFAULT at 152<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "files" returns ok for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authorize]: module "mschap" returns noop for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: group authorize returns ok for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>rad_check_password:<SPAN style="mso-spacerun: yes"> </SPAN>Found Auth-Type System<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">auth: type "System"<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: entering group authenticate for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN style="mso-spacerun: yes"> </SPAN>modcall[authenticate]: module "unix" returns notfound for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: group authenticate returns notfound for request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">auth: Failed to validate the user.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Delaying request 0 for 1 seconds<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Finished request 0<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Going to the next request<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">--- Walking the entire request list ---<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Waking up in 1 seconds...<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">--- Walking the entire request list ---<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Sending Access-Reject of id 240 to 127.0.0.1:32769<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Waking up in 4 seconds...<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">--- Walking the entire request list ---<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Cleaning up request 0 ID 240 with timestamp 40b49ae9<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Nothing to do.<SPAN style="mso-spacerun: yes"> </SPAN>Sleeping until we see a request.<o:p></o:p></SPAN></P><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">And here's the only entry in my radcheck table:<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">+----+----------+-----------+----+---------+<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">| id | UserName | Attribute | op | Value <SPAN style="mso-spacerun: yes"> </SPAN>|<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">+----+----------+-----------+----+---------+<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">|<SPAN style="mso-spacerun: yes"> </SPAN>1 | alexander| Password<SPAN style="mso-spacerun: yes"> </SPAN>| == | password|<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">+----+----------+-----------+----+---------+<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">Any suggestions would be greatly appreciated. I've been working on this<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">for several days now and haven't made much progress. I hope I've done<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">enough footwork on my own to keep away the flames :)<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">Thanks in advance,<o:p></o:p></SPAN></PRE></DIV><p> <hr size=1><font face=arial size=-1>Do you Yahoo!?<br>Friends. Fun. <a href="http://messenger.yahoo.com/";>Try the all-new Yahoo! Messenger</a> --0-1727261780-1085629648=:78369--
--__--__--
Message: 6 From: Manjunath M Prabhu <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Freeradius + Mysql Issues! Date: Thu, 27 May 2004 09:41:06 +0530 Reply-To: [EMAIL PROTECTED]
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
------_=_NextPart_001_01C443A0.A2006620 Content-Type: text/plain; charset="iso-8859-1"
hi, i think you have to modify sql.conf and add the table names correctly because your output suggests that radius server is not able to connect to sql server. hence not able to retrieve the user credentials. regards, manjunath
-----Original Message----- From: Alexander Khoo [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 9:17 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Freeradius + Mysql Issues!
Hi all,
My goal is to use Freeradius with the sql module for authenticating
users. I'm using version 0.9.3 (installed from rpms i created with the
specfile that came with the tarball).I've been working
off of this tutorial: http://www.frontios.com/freeradius.html
<http://www.frontios.com/freeradius.html>
I got but then I proceeded to follow the instructions for sql and have run in to some trouble. I followed all of the required steps and am unable to authenticate. I'm using the following command to test the server: radtest alexander jujai localhost 17 password and i get the following result:
[EMAIL PROTECTED] root]# radtest alexander jujai localhost 17 password
Sending Access-Request of id 240 to 127.0.0.1:1812
User-Name = "alexander"
User-Password = "jujai"
NAS-IP-Address = gk.orbit2000.net
NAS-Port = 17
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=240, length=20
Here is a snippet of the output produced when i run in debug mode:
rad_recv: Access-Request packet from host 127.0.0.1:32769, id=240, length=61
User-Name = "alexander"
User-Password = "jujai"
NAS-IP-Address = 255.255.255.255
NAS-Port = 17
modcall: entering group authorize for request 0
modcall[authorize]: module "preprocess" returns ok for request 0
modcall[authorize]: module "chap" returns noop for request 0
modcall[authorize]: module "eap" returns noop for request 0
rlm_realm: No '@' in User-Name = "alexander", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for request 0
radius_xlat: 'alexander'
rlm_sql (sql): sql_set_user escaped user --> 'alexander'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'alexander' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'alexander' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'alexander' ORDER BY id'
radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'alexander' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): No matching entry in the database for request from user [alexander]
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound for request 0
users: Matched DEFAULT at 152
modcall[authorize]: module "files" returns ok for request 0
modcall[authorize]: module "mschap" returns noop for request 0
modcall: group authorize returns ok for request 0
rad_check_password: Found Auth-Type System
auth: type "System"
modcall: entering group authenticate for request 0
modcall[authenticate]: module "unix" returns notfound for request 0
modcall: group authenticate returns notfound for request 0
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Sending Access-Reject of id 240 to 127.0.0.1:32769
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 240 with timestamp 40b49ae9
Nothing to do. Sleeping until we see a request.
And here's the only entry in my radcheck table:
+----+----------+-----------+----+---------+ | id | UserName | Attribute | op | Value | +----+----------+-----------+----+---------+ | 1 | alexander| Password | == | password| +----+----------+-----------+----+---------+
Any suggestions would be greatly appreciated. I've been working on this for several days now and haven't made much progress. I hope I've done enough footwork on my own to keep away the flames :)
Thanks in advance,
_____
Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! <http://messenger.yahoo.com/> Messenger
------_=_NextPart_001_01C443A0.A2006620 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns:o =3D "urn:schemas-microsoft-com:office:office"><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD> <BODY> <DIV><SPAN class=3D113441604-27052004><FONT face=3DArial = color=3D#0000ff=20 size=3D2>hi,</FONT></SPAN></DIV> <DIV><SPAN class=3D113441604-27052004><FONT face=3DArial = color=3D#0000ff size=3D2>i=20 think you have to modify sql.conf and add the table names correctly = because your=20 output suggests that radius server is not able to connect to sql=20 server.</FONT></SPAN></DIV> <DIV><SPAN class=3D113441604-27052004><FONT face=3DArial = color=3D#0000ff size=3D2>hence=20 not able to retrieve the user credentials.</FONT></SPAN></DIV> <DIV><SPAN class=3D113441604-27052004><FONT face=3DArial = color=3D#0000ff=20 size=3D2>regards,</FONT></SPAN></DIV> <DIV><SPAN class=3D113441604-27052004><FONT face=3DArial = color=3D#0000ff=20 size=3D2>manjunath</FONT></SPAN></DIV> <BLOCKQUOTE> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> Alexander Khoo=20 [mailto:[EMAIL PROTECTED]<BR><B>Sent:</B> Thursday, May 27, = 2004 9:17=20 AM<BR><B>To:</B> [EMAIL PROTECTED]<BR><B>Cc:</B>=20 [EMAIL PROTECTED]; [EMAIL PROTECTED]<BR><B>Subject:</B> = Freeradius +=20 Mysql Issues!<BR><BR></FONT></DIV> <DIV><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'"><PRE><SPAN style=3D"COLOR: black">Hi = all,<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: black">My goal = is to use Freeradius with the sql module for = authenticating<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">users. I'm using version 0.9.3 (installed from rpms i created = with the<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">specfile that came with the tarball).I've been = working<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: black">off of = this tutorial:<SPAN style=3D"mso-spacerun: yes"> </SPAN><A = href=3D"http://www.frontios.com/freeradius.html";>http://www.frontios.com= /freeradius.html</A><o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black"><o:p></o:p></SPAN><SPAN style=3D"COLOR: black">I got but then I = proceeded to follow the instructions for sql and have <S! = style=3D"mso-spacerun: yes" PAN> </SPAN>run in to some trouble. I = followed all of the required steps and am unable to authenticate. I'm = using the following command to test the = server:<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">radtest alexander jujai localhost 17 = password<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: black">and i = get the following result:<o:p></o:p></SPAN></PRE><PRE><SPAN = style=3D"COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN = style=3D"COLOR: black"><o:p></o:p></SPAN><SPAN style=3D"FONT-SIZE: = 10pt; FONT-FAMILY: 'Courier New'">[EMAIL PROTECTED] root]# radtest alexander = jujai localhost 17 password<o:p></o:p></SPAN></PRE> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Sending = Access-Request of=20 id 240 to 127.0.0.1:1812<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN>User-Name =3D "alexander"<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> </SPAN>User-Password =3D=20 "jujai"<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN>NAS-IP-Address =3D gk.orbit2000.net<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN>NAS-Port =3D 17<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rad_recv: = Access-Reject=20 packet from host 127.0.0.1:1812, id=3D240, = length=3D20<o:p></o:p></SPAN></P><PRE><SPAN style=3D"COLOR: = black"></SPAN> </PRE><PRE><SPAN style=3D"COLOR: black">Here is a = snippet of the output produced when i run in debug = mode:<o:p></o:p></SPAN></PRE></SPAN> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rad_recv: = Access-Request=20 packet from host 127.0.0.1:32769, id=3D240, = length=3D61<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN>User-Name =3D "alexander"<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN><SPAN=20 style=3D"mso-spacerun: = yes"> </SPAN>User-Password =3D=20 "jujai"<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN>NAS-IP-Address =3D 255.255.255.255<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: = yes"> =20 </SPAN>NAS-Port =3D 17<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: = entering group=20 authorize for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module=20 "preprocess" returns ok for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module = "chap"=20 returns noop for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module = "eap"=20 returns noop for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>rlm_realm: No = '@' in=20 User-Name =3D "alexander", looking up realm = NULL<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>rlm_realm: No = such realm=20 "NULL"<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module = "suffix"=20 returns noop for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">radius_xlat:<SPAN=20 style=3D"mso-spacerun: yes"> = </SPAN>'alexander'<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql):=20 sql_set_user escaped user --> 'alexander'<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">radius_xlat:<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>'SELECT = id,UserName,Attribute,Value,op=20 FROM radcheck WHERE Username =3D 'alexander' ORDER BY = id'<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): = Reserving=20 sql socket id: 4<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">radius_xlat:<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>'SELECT=20 = radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou= pcheck.Value,radgroupcheck.op<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>FROM = radgroupcheck,usergroup=20 WHERE<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">usergroup.Username =3D=20 'alexander' AND usergroup.GroupName =3D radgroupcheck.GroupName ORDER = BY=20 radgroupcheck.id'<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">radius_xlat:<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>'SELECT = id,UserName,Attribute,Value,op=20 FROM radreply WHERE Username =3D 'alexander' ORDER BY = id'<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">radius_xlat:<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>'SELECT=20 = radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou= preply.Value,radgroupreply.op<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>FROM = radgroupreply,usergroup=20 WHERE<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier = New'">usergroup.Username =3D=20 'alexander' AND usergroup.GroupName =3D radgroupreply.GroupName ORDER = BY=20 radgroupreply.id'<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): = No matching=20 entry in the database for request from user = [alexander]<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">rlm_sql (sql): = Released=20 sql socket id: 4<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module = "sql"=20 returns notfound for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>users: Matched = DEFAULT at=20 152<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module = "files"=20 returns ok for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authorize]: module = "mschap"=20 returns noop for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: group = authorize=20 returns ok for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>rad_check_password:<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>Found Auth-Type=20 System<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">auth: type=20 "System"<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: = entering group=20 authenticate for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>modcall[authenticate]: = module "unix"=20 returns notfound for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">modcall: group=20 authenticate returns notfound for request 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">auth: Failed to = validate=20 the user.<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Delaying = request 0 for 1=20 seconds<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Finished = request=20 0<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Going to the = next=20 request<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">--- Walking the = entire=20 request list ---<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Waking up in 1=20 seconds...<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">--- Walking the = entire=20 request list ---<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Sending = Access-Reject of=20 id 240 to 127.0.0.1:32769<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Waking up in 4=20 seconds...<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">--- Walking the = entire=20 request list ---<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Cleaning up = request 0 ID=20 240 with timestamp 40b49ae9<o:p></o:p></SPAN></P> <P class=3DMsoNormal=20 style=3D"MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><SPAN=20 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Nothing to = do.<SPAN=20 style=3D"mso-spacerun: yes"> </SPAN>Sleeping until we see a=20 request.<o:p></o:p></SPAN></P><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">And here's the only entry in my radcheck = table:<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">+----+----------+-----------+----+---------+<o:p></o:p></SPAN></P= RE><PRE><SPAN style=3D"COLOR: black">| id | UserName | Attribute | op | = Value <SPAN style=3D"mso-spacerun: = yes"> </SPAN>|<o:p></o:p></SPAN></PRE><PRE><SPAN = style=3D"COLOR: = black">+----+----------+-----------+----+---------+<o:p></o:p></SPAN></P= RE><PRE><SPAN style=3D"COLOR: black">|<SPAN style=3D"mso-spacerun: = yes"> </SPAN>1 | alexander| Password<! SPAN style=3D"mso-spacerun: yes"> </SPAN>| =3D=3D | = password|<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">+----+----------+-----------+----+---------+<o:p></o:p></SPAN></P= RE><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">Any suggestions would be greatly appreciated. I've been working = on this<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: black">for = several days now and haven't made much progress. I hope I've = done<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: black">enough = footwork on my own to keep away the flames = :)<o:p></o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style=3D"COLOR: = black">Thanks in advance,<o:p></o:p></SPAN></PRE></DIV> <P> <HR SIZE=3D1> <FONT face=3Darial size=3D-1>Do you Yahoo!?<BR>Friends. Fun. <A=20 href=3D"http://messenger.yahoo.com/";>Try the all-new Yahoo!=20 Messenger</A></FONT></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C443A0.A2006620--
--__--__--
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
End of Freeradius-Users Digest
begin:vcard fn:Ahmad Ibrahim n:Ibrahim;Ahmad org:ABC (Europe) LTD adr:;;89 Edgware Road;London;;W2 2HX;UK email;internet:[EMAIL PROTECTED] title:Director tel;work:+44(0)7005 964 636 tel;fax:+44(0)7005 964 640 tel;cell:+44(0)7833 904 990 x-mozilla-html:FALSE url:http://www.abc-europe.com version:2.1 end:vcard
