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
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
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:
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
:[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
-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
: 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
-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
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
9 matches
Mail list logo