Re: Freeradius+Postfresqk+MAC problem

[Christoffer Dahl Petersen]

Hi again.... 1. It doesn't seem to be casesensitive. 2. I have tried to turn on the debug option on the pgsql, and I can see that the query is accepted and the db is returning a result set (with the information requested). I'm not sure that I understand how the Freeradius works with a db as backend, could you (or anyone else) confirm that I'm on the right track: As you can see in my earlier mail I have comment out authorize_reply_query and authenticate_query, which only leave the authorize_check_query back, when this query is tried against the db, it should return a result set, if the MAC is allowed to access my net. So if result set != null    Access-Accept Is that right? - Christoffer tir, 2004-07-13 kl. 12:46 skrev Gary McKinney:  Hmmm,   Looks like most everything is correct - from what you have sent here...   A couple of things:   1. Is postgresql case sensitive ( I play with MySQL)???  If so check the case (caps or lower case) of the record field names to make sure the schema's match for the database and queries.   2. Check the debug logs for the database to see exactly what is being done on the database side!   From what I see here it looks like the Freeradius is doing it's job properly...   As an aside note: When you had the users file setup and the Auth-Type := Accept you were basically telling Freeradius to "accept" any default caller unconditionally - that is what the "Accept" means {grin}...     gm...