Hello Griff - If you just add the IDENTIFIER field to the list of fields in the select (at the end of the list), it will work (in Radiator 2.18.2): select NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL, \ DEFAULTREALM,NASTYPE,SNMPCOMMUNITY,LIVINGSTONOFFS, \ LIVINGSTONHOLE,FRAMEDGROUPBASEADDRESS, \ FRAMEDGROUPMAXPORTSPERCLASSC,REWRITEUSERNAME, \ NOIGNOREDUPLICATES,PREHANDLERHOOK, IDENTIFIER from \ RADCLIENTLIST Then you can use the following for a Handler: <Handler Client-Identifier = myradclient> ..... </Handler> hth Hugh At 15:16 -0700 01/7/9, Griff Hamlin wrote: >Hello, > >Is it possible to have a handler that uses an 'identifier' from and SQL >client list? In the docs, it says that the following sql statement is >the default, and that the fields must come in this order. However, I >don't see 'identifier' or any such device listed unless NASIDENTIFIER is >an identifier that I can make up, similar to the regular client list, >instead of the nas IP address as I'm guessing. > >select NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL, > >DEFAULTREALM,NASTYPE,SNMPCOMMUNITY,LIVINGSTONOFFS, > LIVINGSTONHOLE,FRAMEDGROUPBASEADDRESS, > FRAMEDGROUPMAXPORTSPERCLASSC,REWRITEUSERNAME, > NOIGNOREDUPLICATES,PREHANDLERHOOK from >RADCLIENTLIST > >Furthermore, assuming that I have an identifier in a client block (not >in sql format, though I'd prefer that if I can): > ><Client 192.168.25.6) #the ip address is irrelevant >secret mysecret >identifier myradclient ></Client> > >can I then do > ><Handler identifier = myradclient> > #stuff ></Handler> > >If this is not possible, is it possible to make a handler that utilizes >the ip address of the actual radius client instead of the NAS ip address >in case they are different which sometimes happens from some of our >clients? > >Griff Hamlin, III -- NB: I am travelling this week, so there may be delays in our correspondence. Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.