Prev Previous Post   Next Post Next
  #1  
Old 8th December 2008, 09:53
SaFi2266 SaFi2266 is offline
HowtoForge Supporter
 
Join Date: Aug 2007
Posts: 2
Thanks: 0
Thanked 1 Time in 1 Post
Default Freeradius configure issue [SOLVED]

Dear All
This is my first post here.
I'm trying to Setting Up A FreeRADIUS Based AAA Server With MySQL & Management With Daloradius on Ubuntu 8.10 (intrepid) As is well known that the intrepid come with FR 2.x and Because I do not need (openssl, tls, and ttls) I just install FR and it's dependencies from apt-get, then I fellow the tutorial on Authentication, Authorization & Accounting With FreeRadius & MySQL Backend & Web Based Management with Daloradius to proceed with this howto I reached to the point where how can test FR working properly or not, firstly with files module, at this point I am completely confused because after running FR in debug mode with
Code:
freeradius -X
and from another shell test it with
Code:
radtest abc 123 localhost 1812 testing123
I get the answer like this
Code:
Sending Access-Request of id 46 to 127.0.0.1 port 1812
        User-Name = "abc"
        User-Password = "123"
        NAS-IP-Address = 10.10.0.11
        NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=46, length=32
        Reply-Message = "Hello, abc"
but on debug screen I get this
Code:
rad_recv: Access-Request packet from host 127.0.0.1 port 47363, id=46, length=55
        User-Name = "abc"
        User-Password = "123"
        NAS-IP-Address = 10.10.0.11
        NAS-Port = 1812
+- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
[suffix] No '@' in User-Name = "abc", looking up realm NULL
[suffix] No such realm "NULL"
++[suffix] returns noop
[eap] No EAP-Message, not doing EAP
++[eap] returns noop
++[unix] returns notfound
[files] users: Matched entry abc at line 204
        expand: Hello, %{User-Name} -> Hello, abc
++[files] returns ok
        expand: %{User-Name} -> abc
[sql] sql_set_user escaped user --> 'abc'
rlm_sql (sql): Reserving sql socket id: 3
        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 = 'abc'           ORDER BY id
        expand: SELECT groupname           FROM radusergroup           WHERE username = '%{SQL-User-Name}'           ORDER BY priority -> SELECT groupname           FROM radusergroup           WHERE username = 'abc'           ORDER BY priority
rlm_sql (sql): Released sql socket id: 3
[sql] User abc not found
++[sql] returns notfound
++[expiration] returns noop
++[logintime] returns noop
++[pap] returns updated
Found Auth-Type = PAP
+- entering group PAP {...}
[pap] login attempt with password "123"
[pap] Using clear text password "123"
[pap] User authenticated successfully
++[pap] returns ok
+- entering group post-auth {...}
        expand: %{User-Name} -> abc
[sql] sql_set_user escaped user --> 'abc'
        expand: %{User-Password} -> 123
        expand: INSERT INTO radpostauth                           (username, pass, reply, authdate)                           VALUES (                           '%{User-Name}',                           '%{%{User-Password}:-%{Chap-Password}}',                           '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth                           (username, pass, reply, authdate)                           VALUES (                           'abc',                           '123',                           'Access-Accept', '2008-12-08 09:13:52')
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth                           (username, pass, reply, authdate)                           VALUES (                           'abc',                           '123',                           'Access-Accept', '2008-12-08 09:13:52')
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql (sql) in sql_postauth: Database query error - Unknown column 'username' in 'field list'
rlm_sql (sql): Released sql socket id: 2
++[sql] returns fail
Using Post-Auth-Type Reject
+- entering group REJECT {...}
        expand: %{User-Name} -> abc
 attr_filter: Matched entry DEFAULT at line 11
++[attr_filter.access_reject] returns updated
Delaying reject of request 0 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 0
Sending Access-Reject of id 46 to 127.0.0.1 port 47363
        Reply-Message = "Hello, abc"
Waking up in 4.9 seconds.
Cleaning up request 0 ID 46 with timestamp +95
What is supposed that's mean is it FR working or not, forgive me if this is stupid question but I need confirmation to proceed or rechech the configuration from beginning

TIA
SaFi

Last edited by SaFi2266; 11th December 2008 at 19:20.
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
pdo_mysql install issue digen Server Operation 3 7th January 2008 15:16
Error compile Courier-Authlib pcom11 Server Operation 1 29th September 2007 13:15
Howto configure Glue Records DVS Suggest HOWTO 1 27th May 2007 10:11
Configure Mail Server (Post) Mariel Installation/Configuration 3 25th April 2007 15:01
Configure Mail Server (PostFix) Mariel Installation/Configuration 4 24th April 2007 20:10


All times are GMT +2. The time now is 07:56.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.