Re: NAS-IP-Address in mysql

On Thu, 15 Feb 2007, VeNoMouS wrote: > Hi guys After doing some tests, I just discovered that I cant have more then > one NAS-IP-Address in radgroupcheck (it seems to ignore the others) does > anyone know of a work around as i dont want to use the huntgroup file (makes > it kinda anonying since im

Re: SQL help from someone who groks c, please?

On Thu, 8 Feb 2007, ChristosH wrote: > > > Phil Mayers wrote: >> >> A stored procedure is one solution to a particular set of problems. >> Whether it's appropriate depends on what you're trying to do. >> >> What do you want to achieve? You can certainly vary the reply info based >> on NAS without

Re: SQL help from someone who groks c, please?

hes.id WHERE`ip_customer`.`ipc_rmtreboot` = 'y' AND ip_customer.ipc_rmtusername = '%{SQL-User-Name}' AND ipc_rmtip = \ '%{NAS-IP-Address}' AND switches.role = '4' GROUP BY interface_address, `ip_customer`.`ipc_rmtusername`" If they are a customer, retur

Re: SQL help from someone who groks c, please?

On Mon, 5 Feb 2007, Phil Mayers wrote: > Dan Mahoney, System Admin wrote: >> >> That said, I figured out two possible ways to handle my previous question >> regarding advanced SQL auth (including multiple occurances of the same > > Minor point of terminology - SQL doesn

SQL help from someone who groks c, please?

Hey all... Disclaimer: If I should ask this on the devel list, let me know and I will. As I'm not qualified in the languages to be a developer, this seemed the more logical place. I'm decent with Radius but have just come to freeradius over Cistron...I'm still in the process of assimilating t

Advanced SQL Auth/Generate clients.conf from SQL?

Hey all, Two questions, related to SQL... 1: I recently became enamored by the power of SQL, and while I find no easy way through SQL to do multiple check-items easily in a logical fall-throughable order. I.e. through SQL how would one do (for an entry level tech): Jeremy nas-ip-address="the