Hi all, I have been trying to fetch client details from the SQL database specified by DBSource. I found <ClientListSQL> clause to load clients from the DBSource with the GetClientQuery.
<ClientListSQL> DBSource dbi:Pg:dbname=test;host=127.0.0.1 DBUsername testing DBAuth 123456 GetClientQuery SELECT NAME, SECRET,NASID FROM CLIENTS </ClientListSQL> In database there is CLIENTS table. Basically this table has the IP as the name, Secret and the Nasid for the router. Name always should be '0.0.0.0/0' to avoid network restriction on the IP. name | secret | nasid ----------------+------------------+------------------- 0.0.0.0/0 | xxxxxxxxxxxx | 00-0C-42-FA-53-30 0.0.0.0/0 | yyyyyyyyyyyy | 00-27-22-9A-D9-A1 0.0.0.0/0 | zzzzzzzzzzzz | DC-9F-DB-34-3A-2E With the given sample data above if the secret 'xxxxxxxxxxxx ' fails for the client ' 00-0C-42-FA-53-30', radiator fetches the client "00-0C-42-FA-53-30" with the any secret( yyyyyyyyyyyy or zzzzzzzzzzzz) defined for the name '0.0.0.0/0' . What I want is secret to be fetched per nasid not for the ip(name). So if the secret 'xxxxxxxxxxxx ' fails for the client '00-0C-42-FA-53-30', then radiator should inform client with the "Bad password". I also tried to refactor my table by having only NASID and SECRET since the radiator documentation says that *"**Your database table must include at least the first and second fields (i.e. the NAS name or IP address or MAC address and the shared secret). All the other fields are optional*"( see radiator_doc <http://people.su.se/~kllin/radiator_doc/ref.html#pgfId=388046>). However when radiator receives a SIGHUP signal always interprets NASID as name and complains that "Could not resolve address 00-0C-42-FA-53-30 for Client 00-0C-42-FA-53-30". I have been looking forward to hear any solution. Cheers, Bengi.
_______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator