Hi Im having problem with that freeradius doesn't recognize the clients (NAS) in the NAS table of MySQL.. It keeps throwing me: Unknown client nothing to do. So, I have set up sql.conf to trace mysql qureys in -X debug mode to YES, but I still don't see any qureys shown to the NAS table to see is the client is authorized. So how can I check if freeradius sends the query to the NAS table of the DB to SELECT * NAS where NASNAME = 'xxx.xxx.xxx.xxx' and SECRET='testing123' ??? I MUST make this work!!! Please help!
"Alex M" <alexm@lrcommunications.net> wrote:
So, I have set up sql.conf to trace mysql qureys in -X debug mode to YES, but I still don't see any qureys shown to the NAS table to see is the client is authorized.
The queries are NOT done "live". They are done once when the server starts. Alan DeKok.
Ok, that information is good thing to know, which will creates another two questions: 1. How can I find if server obtained the records from the table? 2. If you add lets say new user (user as user, not a NAS) to DB, when I have to restart the server in order for settings to take affect? -----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, October 26, 2005 2:06 PM To: FreeRadius users mailing list Subject: Re: cheking mysql requests "Alex M" <alexm@lrcommunications.net> wrote:
So, I have set up sql.conf to trace mysql qureys in -X debug mode to YES, but I still don't see any qureys shown to the NAS table to see is the client is authorized.
The queries are NOT done "live". They are done once when the server starts. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
"Alex M" <alexm@lrcommunications.net> wrote:
1. How can I find if server obtained the records from the table?
Read the debug output on startup. Or, send it a packet from a client configured in SQL. Or, read the sqltrace file, I *think* the queries are in there.
2. If you add lets say new user (user as user, not a NAS) to DB, when I have to restart the server in order for settings to take affect?
No. Alan DeKok.
1. How can I find if server obtained the records from the table?
"Read the debug output on startup." I can read that, but the question if I can understand what it is saying, cause its not usual SQL Reply outputs there....
Or, send it a packet from a client configured in SQL. That wher im getting rely that client is unknown
Or, read the sqltrace file Can you sagest where to look for it? I can't find it... :-(
Thanks! -----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, October 26, 2005 2:27 PM To: FreeRadius users mailing list Subject: Re: cheking mysql requests "Alex M" <alexm@lrcommunications.net> wrote:
1. How can I find if server obtained the records from the table?
Read the debug output on startup. Or, send it a packet from a client configured in SQL. Or, read the sqltrace file, I *think* the queries are in there.
2. If you add lets say new user (user as user, not a NAS) to DB, when I have to restart the server in order for settings to take affect?
No. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Ok, here are the answers to my own questions: 1. In order to read NAS table you have to unquote "reedclients=yes" to allow to connect to NAS table in sql.config (at the end of the file) 2. My table was modified as was suggested by another post, but freeradius qureys the table in TABULAR frmat, so results obrained where messed up 3. Despite that the short name in the table is set to allow null, the server will not allow to use the record without short name so you have to have nasname, shirtname, and secret field fielded up.... Hope it will help to ppl who have same questions that I did -----Original Message----- From: freeradius-users-bounces@lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, October 26, 2005 2:27 PM To: FreeRadius users mailing list Subject: Re: cheking mysql requests "Alex M" <alexm@lrcommunications.net> wrote:
1. How can I find if server obtained the records from the table?
Read the debug output on startup. Or, send it a packet from a client configured in SQL. Or, read the sqltrace file, I *think* the queries are in there.
2. If you add lets say new user (user as user, not a NAS) to DB, when I have to restart the server in order for settings to take affect?
No. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Alex M