RE: matching on IP Address

2008-06-18 Thread King, Adam
www.intechnology.com -Original Message- From: [EMAIL PROTECTED] rg [mailto:[EMAIL PROTECTED] radius.org] On Behalf Of Ivan Kalik Sent: 17 June 2008 17:46 To: FreeRadius users mailing list Subject: RE: matching on IP Address Hi, thanks for the help so far, the match based on the ip and the realm now

RE: matching on IP Address

2008-06-18 Thread Ivan Kalik
In the default file the if statement has the sql1: or sql2: prefix as if it is left as the sql: prefix it doesn't seem to read the redundant section to connect to the 2nd database. That's how it should be. You don't have an sql instance named sql, just sql1 and sql2. Ivan Kalik Kalik

Re: matching on IP Address

2008-06-17 Thread Ivan Kalik
Is that table in the database sql instance is connecting to? Ivan Kalik Kalik Informatika ISP Dana 17/6/2008, King, Adam [EMAIL PROTECTED] piše: Hi, I am running this query: if (%{sql: SELECT COUNT(nas_ip) FROM `nas_ip` WHERE nas_ip='127.0.0.1'}0){ redundant { sql1 sql2 } } But the if (%{sql:

RE: matching on IP Address

2008-06-17 Thread King, Adam
www.intechnology.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Kalik Sent: 17 June 2008 11:50 To: FreeRadius users mailing list Subject: Re: matching on IP Address Is that table in the database sql instance is connecting to? Ivan Kalik Kalik

RE: matching on IP Address

2008-06-17 Thread Ivan Kalik
:[EMAIL PROTECTED] On Behalf Of Ivan Kalik Sent: 17 June 2008 11:50 To: FreeRadius users mailing list Subject: Re: matching on IP Address Is that table in the database sql instance is connecting to? Ivan Kalik Kalik Informatika ISP Dana 17/6/2008, King, Adam [EMAIL PROTECTED] piše: Hi, I am

RE: matching on IP Address

2008-06-17 Thread King, Adam
-Original Message- From: [EMAIL PROTECTED] rg [mailto:[EMAIL PROTECTED] radius.org] On Behalf Of Ivan Kalik Sent: 17 June 2008 12:26 To: FreeRadius users mailing list Subject: RE: matching on IP Address You have multiple sql instances. Are you sure that instance called sql is connecting

RE: matching on IP Address

2008-06-17 Thread Ivan Kalik
: 17 June 2008 12:26 To: FreeRadius users mailing list Subject: RE: matching on IP Address You have multiple sql instances. Are you sure that instance called sql is connecting to that database? Or should it be sql1: or sql2:? Ivan Kalik Kalik Informatika ISP This is an email from InTechnology plc

RE: matching on IP Address

2008-06-17 Thread King, Adam
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ivan Kalik Sent: 17 June 2008 13:50 To: FreeRadius users mailing list Subject: RE: matching on IP Address In 2.0 you can also use unlang to update the request: http://freeradius.org/radiusd/man/unlang.html Ivan

RE: matching on IP Address

2008-06-17 Thread Ivan Kalik
Hi, thanks for the help so far, the match based on the ip and the realm now works! As mentioned below the redundant section from the sites-enabled/default file does not process so the if statement needs sql1: or sql2: in there instead of sql: Wrong. The statement needs hose prefixes because