Hi,
This is my first post in this list.
I work for an ISP. We use freeradius with mysql in the radius server,
pptp/pppoe to in nas. I inherited a 5 years old freeradious installation
(version 1.0.0) and its running fine . Now i need to shift it to another
server (because server is too old). I have installed freeradius 2.1.6 in a
new PC with Centos5.3 with mysql 5.
I had dumped the mysql database from the old machine to new machine. There
is a field like "client-type" and there are two types of customer "basic"
and "shared". Bur when i added a nas is the radius, the user cannot be
authenticated, the following error occurs...
I am new with freeradius.
[chap] Setting 'Auth-Type := CHAP'
++[chap] returns ok
[sql] expand: %{User-Name} -> user1
[sql] sql_set_user escaped user --> 'user1'
rlm_sql (sql): Reserving sql socket id: 3
[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 = 'user1' ORDER
BY id
WARNING: Found User-Password == "...".
WARNING: Are you sure you don't mean Cleartext-Password?
WARNING: See "man rlm_pap" for more information.
[sql] User found in radcheck table
[sql] expand: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = '%{SQL-User-Name}' ORDER BY id -> SELECT
id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'user1' ORDER
BY id
rlm_sql: Failed to create the pair: Invalid octet string "basic" for
attribute name "Client-Type"
rlm_sql (sql): Error getting data from database
[sql] SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 3
++[sql] returns fail
Invalid user: [user1/<CHAP-Password>] (from client nas-1 port 0)
Delaying reject of request 0 for 4 seconds
Going to the next request
Waking up in 0.9 seconds.
Waking up in 2.9 seconds.
Sending delayed reject for request 0
Sending Access-Reject of id 155 to *.*.*.* port 1033
Waking up in 4.9 seconds.
Cleaning up request 0 ID 155 with timestamp +46
Ready to process requests.
I googled the problem and find it could be a dictionary issue. So I added
dictionary. But this time freeradius is giving another problem (It is not
running.)
# /usr/local/sbin/radiusd -X
FreeRADIUS Version 2.1.6, for host i686-pc-linux-gnu, built on May 22 2009
at 01:41:36
Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
............
...........
/usr/local/etc/raddb/dictionary.compat[7]: Expecting section start brace '{'
after "ATTRIBUTE Password"
Errors reading /usr/local/etc/raddb/radiusd.conf
#
My system is CENTOS 5.3 (i386)
Mysql-server-5.0.45
Freeradius 2.1.6
I will be glad to have your comments on it. Sorry for such a long mail.
Thank you all for your patients, reading the mail.
Ashfaq.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
