cheking mysql requests

[Alex M]

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 at lists.freeradius.org
[mailto:freeradius-users-bounces at 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 at 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