[Help-gnu-radius] Problem related to Authentication

[Farooq Ahmed]

Hi friends ,
I have installed gnu-radius-0.96.4 on Redhat 7.3 with Mysql support.


result of "radiusd -v"
----------------------------------------
radiusd: GNU Radius version 0.96.4 (i686-pc-linux-gnu)
Compilation platform: linux
Debugging flags:
Compilation flags: PWD_SHADOW USE_PAM USE_SQL_MYSQL USE_SQL_ODBC
Ports in use:
 AUTH: 1645
 ACCT: 1646
Paths:
 configuration directory: /usr/local/etc/raddb
 logging directory:       /var/log
 accounting directory:    /var/log/radacct
 pidfile:                 /var/run/radiusd.pid



users file contains
----------------------------------
DEFAULT Auth-Type = SQL,
Simultaneous-Use = 1
Service-Type = Framed-User,
Framed-Protocol = PPP




I have establish MYSQL Database RADIUS and the tables contents is following:
-----------------------------------------------------------------
mysql> select * from passwd;
+-----------+------------+----------+--------+
| user_name | service    | password | active |
+-----------+------------+----------+--------+
| farooq    | Framed-User| 123456   | Y      |
+-----------+------------+----------+--------+
1 row in set (0.00 sec)

mysql> select * from groups;
+-----------+------------+
| user_name | user_group |
+-----------+------------+
| farooq    | staff      |
+-----------+------------+
1 row in set (0.00 sec)

mysql> select * from attrib;
+-----------+-------------------+-----------+------+
| user_name | attr              | value     | op   |
+-----------+-------------------+-----------+------+
| farooq    | NAS-IP-ADDRESS    |172.17.1.86| NULL |
| farooq    | NAS-Port-Id       | 20        | <=   |
| farooq    | Framed-Protocol   | PPP       | NULL |
| farooq    | Framed-IP-Address | NULL      | NULL |
+-----------+-------------------+-----------+------+
4 rows in set (0.00 sec)


in sqlserver file all options are at its default settings i have not chaged any 
query.
---------------------

****************************************************************************************************************88

Now For TESTING i used command
radauth -v farooq
the results:
--------------------------------------------------
server 172.17.1.86:1645
send code 1 (RT_AUTHENTICATION_REQUEST)
      send: User-Name = farooq
      send: Password = 123456
      send: NAS-Port-Id = 0
recv code 3 (RT_AUTHENTICATION_REJECT)
      recv: Reply-Message = \015\012Access denied\015\012
expect 2
got    3
FAIL
----------------------------------------------------------

in the 'radius.log' file :
----------------------------------------------------------------------------
Mar 07 05:26:20: Main.info: Starting - reading configuration files ...
Mar 07 05:26:20: Main.info: reading /usr/local/etc/raddb//config
Mar 07 05:26:20: Main.info: ready
Mar 07 05:26:20: Main.info: /usr/local/etc/raddb//users reloaded.
Mar 07 05:26:20: Main.info: Ready to process requests.
Mar 08 01:17:14: Auth.notice: Invalid user: [farooq]: CLID unknown (from nas 
localradius)

----------------------------------------------------------------------------

mysqld.log file verifies that
---------------------------------------------------------------------------
13 Connect     address@hidden on
                     13 Init DB     RADIUS
                     13 Query       SELECT attr,value,op FROM attrib WHERE 
user_name='farooq' AND op IS NOT NULL
                     13 Query       SELECT attr,value FROM attrib WHERE 
user_name='farooq' AND op IS NULL
030308  1:17:14      13 Query       SELECT password FROM passwd WHERE 
user_name='farooq' AND active='Y'
030308  5:17:13      13 Quit




What wrong with my RADIUS server? I have become tired of reading listings 
archives and documents.
Please help me :)
Thanks !

Farooq Ahmed



_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus