Can use control attribute in sql.conf (sql module config file) query ?
if yes so
what about a new control attribute that define dictionary ?
Best regards.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dear ALL
I use this query by calling stored procedure in database :
simul_count_query = SELECT
findout_cuncurrent_sessions_for_a_user('%{User-Name}','%{NAS-IP-Address}','%{CalledStationId}','%{CallingStationId}')
but I can not access to the value of CallingStationId and CalledStationId.
my
On 03/23/2013 10:31 AM, Mehdi Ravanbakhsh wrote:
Dear ALL
I use this query by calling stored procedure in database :
simul_count_query = SELECT
findout_cuncurrent_sessions_for_a_user('%{User-Name}','%{NAS-IP-Address}','%{CalledStationId}','%{CallingStationId}')
but I can not access to the
Thanks i am find correct name .
On Sat, Mar 23, 2013 at 5:35 PM, Phil Mayers p.may...@imperial.ac.ukwrote:
On 03/23/2013 10:31 AM, Mehdi Ravanbakhsh wrote:
Dear ALL
I use this query by calling stored procedure in database :
simul_count_query = SELECT
On 12/27/2012 06:20 AM, Fajar A. Nugraha wrote:
On Thu, Dec 27, 2012 at 1:00 PM, ichiro tanaka i_tan...@hotmail.co.jp wrote:
I made a set of 'safe-character' connection config of the sql.conf.
However,the safe-character's being used in connection is the last(B)
(When I use the A.but B
On 12/27/2012 06:00 AM, ichiro tanaka wrote:
Hello
I'm using freeradius 2.1.12. I'm trying to set up sql.conf.
But there is one question.
I made a set of 'safe-character' connection config of the sql.conf.
However,the safe-character's being used in connection is the last(B)
(When I use
Hello
I'm using freeradius 2.1.12. I'm trying to set up sql.conf.
But there is one question.
I made a set of 'safe-character' connection config of the sql.conf.
However,the safe-character's being used in connection is the last(B)
(When I use the A.but B will be used in this case)
Do you
On Thu, Dec 27, 2012 at 1:00 PM, ichiro tanaka i_tan...@hotmail.co.jp wrote:
I made a set of 'safe-character' connection config of the sql.conf.
However,the safe-character's being used in connection is the last(B)
(When I use the A.but B will be used in this case)
Do you think
Thanks Alan,
I've been working with a modified version of sql.conf for years and just
copying it over to new servers and must have missed the move of config options
to dialup.conf assuming that dialup had something to do with dialup modems. I
purged freeradius-mysql and reinstalled it and now
The version of sql.conf found in
ftp://ftp.freeradius.org/pub/freeradius/freeradius-server-2.1.12.tar.gz seems
to be quite different from the version found at
http://freeradius.org/radiusd/raddb/sql.conf
I was expecting the latter file on a new build but was wondering what happened
to all
Hi,
The version of sql.conf found in
ftp://ftp.freeradius.org/pub/freeradius/freeradius-server-2.1.12.tar.gz seems
to be quite different from the version found at
http://freeradius.org/radiusd/raddb/sql.conf
I was expecting the latter file on a new build but was wondering what
Hi,
when setting up a brand-new server, I fell over one caveat (and did so
more than once, actually): almost all modules are placed in modules/*
and get get auto-loaded when they are needed by the actual configuration.
Except eap.conf and sql.conf - these need explicit $INCLUDEs
Stefan Winter wrote:
when setting up a brand-new server, I fell over one caveat (and did so
more than once, actually): almost all modules are placed in modules/*
and get get auto-loaded when they are needed by the actual configuration.
Except eap.conf and sql.conf - these need explicit
): almost all modules are placed in modules/*
and get get auto-loaded when they are needed by the actual configuration.
Except eap.conf and sql.conf - these need explicit $INCLUDEs in
radiusd.conf.
Yes...
I wonder why - couldn't sql.conf just become modules/sql? It's commented
out anyway, so
configuration.
Except eap.conf and sql.conf - these need explicit $INCLUDEs in
radiusd.conf.
Yes...
I wonder why - couldn't sql.conf just become modules/sql? It's commented
out anyway, so wouldn't get loaded with the default config. But it would
enable auto-loading when uncommenting sql
information from
another redundant database
Thanks a lot!
--
View this message in context:
http://www.nabble.com/sql.conf-failover-readclients%3Dyes-tp23103617p23158513.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http
leopold wrote:
Please tell me not to change code and ignore SQL errors during startup time
when your read NAS table.
The only way to fix this is to change the source code of the server.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
--
View this message in context:
http://www.nabble.com/sql.conf-failover-readclients%3Dyes-tp23103617p23162460.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http
leopold wrote:
Could you please add this as a feature request for the next release and
solve it properly?
I have a long list of new features, and a short amount of time.
The major issue is that if we ignore error of NAS table loading at startup
time then it will never recover and load NAS
Recently in rel 2.1.4 you fixed and issue for replicated databases that allow
readclients=yes option in sql.conf. This worked great if ALL databases are
up and running.
The issue happens if radiusd can't connect to a database and process cannot
start even though it can read NAS info from sql2
rlm_sql (sql2): starting 12
rlm_sql (sql2): starting 13
rlm_sql (sql2): starting 14
rlm_sql (sql2): starting 15
rlm_sql (sql2): Failed to connect to any SQL server.
rlm_sql (sql2): Processing generate_sql_clients
--
View this message in context:
http://www.nabble.com/sql.conf-failover-readclients
Hello all,
Here I am again. I need to make that every virtual server I have
running look for it's data on different mysql database and tables. For
this I need to set up each virtual server too look into it's own
sql.conf... I could not find any doc about this.
PS.: Why even
PS.: Why even if a client gets reject from the server the still sends
reply like this:
Sending Access-Reject of id 138 to 127.0.0.1 port 44881
Mikrotik-Rate-Limit = 100k/200k 200k/400k 80k/160k 180/180 8
60k/120k
This was answered in last few days. Read the list posts again.
Ivan
: hi
sql.conf is your mysql database config , you use it when u need to have
AAA with radius , like freeradius with mysql backend
what distro your using? linux redhat? debain? slackware? fedora?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
list freeradius-users@lists.freeradius.org
Date: Tue, 14 Aug 2007 21:31:24 -0700 (PDT)
Subject: Re: sql.conf file
I use fedora core6. when I active sql for accunting ,radiusd -x gives
error with sql.conf.there isn't rlm_sql_mysql.so. when I searched find
out that I should install
On Wed 15 Aug 2007, zahra bahar wrote:
I use fedora core6. when I active sql for accunting ,radiusd -x gives
error with sql.conf.there isn't rlm_sql_mysql.so. when I searched find out
that I should install freeradius_mysql package.but installing it wants
alot of system files. what is wrong?
Hi,
I had freeradius.1.0.2 that hasn't rlm_sql.so. now I installed freeradius.1.1.3
but there isn't sql.conf .
why it doesn't have this necessary file?what should I do?
thanks.
-
Pinpoint customers who are looking for what you sell. -
List info/subscribe
hi
sql.conf is your mysql database config , you use it when u need to have
AAA with radius , like freeradius with mysql backend
what distro your using? linux redhat? debain? slackware? fedora?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
the accounting queries in sql.conf and the sample sql_log module in
radiusd.conf are not identical. For consistency, I'd expect to find the same
things there. Any specific reason, or can I just copy over the usual queries
from sql.conf into that module and expect them to work?
Greetings
Stefan Winter wrote:
the accounting queries in sql.conf and the sample sql_log module in
radiusd.conf are not identical. For consistency, I'd expect to find the same
things there. Any specific reason, or can I just copy over the usual queries
from sql.conf into that module and expect them
.
I need to make new sql query in a table with a list of mac-address, if
the CallingStationId will be equal to the some mac-adress of the table
then will not have to be connected.
A system of mac-adress blacklist.
I tried to make adding one query in sql.conf but it does not function.
I find
in sql.conf but it does not function.
I find that it would have to add a new function in rlm_sql.c, but am not
habil C programmer.
Somebody can help me?
Sorry for my english
Thanks
Jean
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
for authentication of pppoe wifi.
I need to make new sql query in a table with a list of mac-address, if
the CallingStationId will be equal to the some mac-adress of the table
then will not have to be connected.
A system of mac-adress blacklist.
I tried to make adding one query in sql.conf but it does
to be connected.
A system of mac-adress blacklist.
I tried to make adding one query in sql.conf but it does not function.
I find that it would have to add a new function in rlm_sql.c, but am not
habil C programmer.
Somebody can help me?
Sorry for my english
Thanks
Jean
-
List info/subscribe
of mac-adress blacklist.
I tried to make adding one query in sql.conf but it does not function.
I find that it would have to add a new function in rlm_sql.c, but am not
habil C programmer.
Somebody can help me?
Sorry for my english
Thanks
Jean
-
List info/subscribe/unsubscribe? See
one query in sql.conf but it does not function.
I find that it would have to add a new function in rlm_sql.c, but am not
habil C programmer.
Somebody can help me?
Sorry for my english
Thanks
Jean
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/usershtml
Hi!
How can I configure radius to always check the group table for a user without
utilizing the Fall-Through parameter in the radreply table for a particular
user??
I tried to use read_groups=yes in the sql.conf but it didn't help.
Thanks in advanced
-tomasz
-
List info/subscribe
Hi,
I am looking to set radcheck.activeDate and radcheck.activated when a
user logs in for the first time.
At this same time I want to update or insert an expiration attribute for
that user. I tried putting an
update in the sql.conf file for the radcheck table with the queries that
insert
Alan DeKok schrieb:
Norbert Wegener [EMAIL PROTECTED] wrote:
In a certain context I want to accept all incoming requests.
Ok...
mysql select * from radcheck where UserName='0009';
+-+--+--++--+-+
| id
Norbert Wegener [EMAIL PROTECTED] wrote:
So how could I assign a Hint using MySQL and use it later? Is it
possible at all the way I would like to use it?
It may work, I just haven't checked.
Alan DeKok.
--
http://deployingradius.com - The web site of the book
| NULL|
++--+--++---++--+-+
1 row in set (0.00 sec)
authorize_check_query from sql.conf is:
authorize_check_query = SELECT id, UserName, Attribute, Value, op \
FROM ${authcheck_table} \
WHERE
Norbert Wegener [EMAIL PROTECTED] wrote:
In a certain context I want to accept all incoming requests.
Ok...
mysql select * from radcheck where UserName='0009';
+-+--+--++--+-+
| id | UserName | Attribute|
Hello,
Im running freeradius with mysql module.
How could I add a second query to the statement
accounting_stop_query in sql.conf?
I found this: http://lists.cistron.nl/pipermail/freeradius-users/2005-November/048711.html
So I add a section to sql.conf (myTEST {}) and copy
Norbert Wegener [EMAIL PROTECTED] wrote:
and radius -AX tells me:
WARNING: Unknown variable '%y': See 'doc/variables.txt'
How would I escape that kind of variable to pass it to the sql query?
%%
Alan DeKok.
--
http://deployingradius.com - The web site of the book
in sql.conf I use something like:
usergroup.GroupName like 'v%y'
and radius -AX tells me:
WARNING: Unknown variable '%y': See 'doc/variables.txt'
How would I escape that kind of variable to pass it to the sql query?
The usual \ did not work.
Thanks
Norbert Wegener
-
List info/subscribe
fvt3 [EMAIL PROTECTED] wrote:
How do you convert the SQL-User-Name sent to upper
case? I have my mac address store in upper case but
the client is sending its mac address in lower case.
You can't really.
Why not do a case-insensitive match in SQL?
Alan DeKok.
--
Ok, so how do you set freeradius to do a
case-insensitive match? I have AB:CD:EF::: in mysql
and when a user authenticate with ab:cd:ef::: ,
radius reply with login incorect... Thanks in advance
--- Alan DeKok [EMAIL PROTECTED] wrote:
fvt3 [EMAIL PROTECTED] wrote:
How do you convert the
Le Mon, Aug 07, 2006 at 09:10:56AM -0700, fvt3 ecrivait:
Ok, so how do you set freeradius to do a
case-insensitive match? I have AB:CD:EF::: in mysql
and when a user authenticate with ab:cd:ef::: ,
radius reply with login incorect... Thanks in advance
Did you try to set lower_user to yes
- Original Message -
From: Francois-Xavier GAILLARD [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Monday, August 07, 2006 9:19 PM
Subject: Re: sql.conf
Le Mon, Aug 07, 2006 at 09:10:56AM -0700, fvt3 ecrivait:
Ok, so how do you set
thanks peter
but can is there any way where i can specify radius to use authetication
query a for calls from user a, and query b for users b.
--
View this message in context:
http://www.nabble.com/Having-multiple-authentication-query-in-sql.conf-t1353830.html#a3647212
Sent from the FreeRadius
On Tue 28 Mar 2006 09:13, vignesh wrote:
Hello all
Can I have multiple authentication queries in sql.conf file. There are
different ways by which we want to autheticate the users. I will let you
know what I exactly want. I want to authenticate users based on the CLID
and the remote ip address
Hello all
Can I have multiple authentication queries in sql.conf file. There are
different ways by which we want to autheticate the users. I will let you
know what I exactly want. I want to authenticate users based on the CLID
and the remote ip address. The problem is that the remote address has
Hello guys
I am trying to modify the query for authorization in sql.conf file. I
will let you know what I exactly want
I want to authenticate users based on the CLID and the remote ip
address. The problem is that the remote address has to be searched from
a set of ips. I will give you a example
rlm_sql_mysql: Mysql error 'Access denied for user
'radius'@'localhost' (using password: YES)'
...snip...
I have put this in my sql.conf like so:
# Connect info
server = localhost
login = radius
password = x
# Database table configuration
Guy Fraser wrote:
First of all for stability, I would suggest FreeBSD. The
Fedora Core Releases are, cutting edge with a short life
span.
Or, if you are more comfortable with RedHat, try CentOS which is
rebranded RH Enterprise.
--
Dennis Skinner
Systems Administrator
BlueFrog Internet
)'
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.
I have put this in my sql.conf like so:
# Connect info
server =
localhost
login
): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.
I have put this in my sql.conf like so:
# Connect info
server
If it's a new install check that your iptables aren't blocking your access also
- Original Message -
From: Laker Netman [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Monday, March 20, 2006 5:23 PM
Subject: Re: sql.conf
in radiusd.conf
before including sql.conf. In sql.conf i commented out the variables.
But then there is reported an error, that the variable acct_table1 is
unknown.
Is there a possibility to set the variables acct_table1 and acct_table2
in the sections for the different instances
Andreas Engler [EMAIL PROTECTED] wrote:
Is there a possibility to set the variables acct_table1 and acct_table2
in the sections for the different instances in radiusd.conf? Or have i
to provide for every instance an own sql.conf.
I think you have to have multiple SQL instances.
Or, you
Hi Hashim, please look at
http://lists.freeradius.org/pipermail/freeradius-devel/2006-February/009440.
html
I've done it simply adding a call to a function defined on database (mySQL)
in an existing query.
Ragards
-
List info/subscribe/unsubscribe? See
Thanks.
Will this allow me to run 1 of a number of queries in sql.conf depending
on whats in the access-request the server receives? So I need to run
some queries every time an access-request packet is received and then
choose which authorize query to run in sql.conf.
Alan DeKok wrote
Maqbool Hashim [EMAIL PROTECTED] wrote:
Will this allow me to run 1 of a number of queries in sql.conf
You said script not additional queries.
Please describe *accurately* what you want to do. Giving
information in bits and pieces is annoying.
So I need to run some queries every time
Hi,
Is it possible to reference a script from within sql.conf? I'd like to
do some checks and inserts on the sql database just before the
auth_check query in sql.conf. Whats the best way of doing this?
Thanks
Maqbool
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list
Hi Everyone,
I am sending this
Hi Everyone,
I am sending this message at very first time, and I hope that I'll get
response.
My Question is that:
In sql.conf's Authorization section, can I write my own queries and can I
use the result of my own query. For detailed elaboration I will give you
following example:
I want
Ok, problem solved, as you can see at this post
http://lists.freeradius.org/pipermail/freeradius-devel/2006-February/009446.
html
Thank you to everyone
Regards,
Carlo
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Carlo Prestopino wrote:
I've tried to insert a semicolon after the first query, but it didn't work,
so I'm trying to modify the source code.
There is no need to modify the source code. You can run two SQL statements
if you have two instances of rlm_sql module.
If I correctly understood, I
Ive tried to
insert a semicolon after the first query, but it didnt work, so Im
trying to modify the source code.
If I correctly
understood, I have to modify the file rlm_sql, creating an entry also for the
new defined query (e.g. mac_auth_query).
May I use as sample
postauth_query?
Thank you both Richard/Alan,
Ill try it on Monday
when at office and let you know.
Regards,
Carlo
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Rich Marriner wrote:
Would seperating the queries with a semicolon work, but keeping both
queries under postauth_query? SQL should distinguish it as a seperate
query. I haven't tried this so I am not sure if it would work or not.
I guess it won't work because FreeRADIUS doesn't use the
Thats too bad. I suppose that in 99% of the installations you would
actually want that behavior anyway.
Nicolas Baradakis wrote:
Rich Marriner wrote:
Would seperating the queries with a semicolon work, but keeping both
queries under postauth_query? SQL should distinguish it as a
A: FreeRadius users mailing list
Oggetto: Re: R: SQL.conf new query
I would like to build a new query to insert
user's MAC address into radcheck table, as users log-out (accounting-stop
packet).
Just append the query to the existing ones.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
Thank you Alan for your reply.
As written by Paolo, we simply added a query (postauth_mac_query) to sql.conf file that gives back users MAC
address:
...
...
postauth_query
= INSERT into ${postauth_table} (id, user, pass,
reply, date) values ('', '%{User
Carlo Prestopino [EMAIL PROTECTED] wrote:
The problem is that it seems that freeRADIUS does not recognize the new
defined query (postauth_mac_query) in fact, looking at debug output, we
can
see calls to all other queries but not to the new one.
The source code to the module contains the
changing the source code and recompiling...
Hope this helps!
Richard
Carlo Prestopino wrote:
Thank you Alan for your reply.
As written by Paolo, we simply added a query (postauth_mac_query) to
sql.conf file that gives back user’s MAC address:
...
...
postauth_query
Rich Marriner [EMAIL PROTECTED] wrote:
Would seperating the queries with a semicolon work, but keeping both
queries under postauth_query? SQL should distinguish it as a seperate
query. I haven't tried this so I am not sure if it would work or not.
That's what I thought I suggested earlier.
That is what I thought but wasn't sure, I don't think the original
poster realized this though. I was directing this mostly toward him.
Thanks!
Alan DeKok wrote:
Rich Marriner [EMAIL PROTECTED] wrote:
Would seperating the queries with a semicolon work, but keeping both
queries
hello, type is possible to insert one new query in
the rows sql.conf this:
postauth_query = INSERT into ${postauth_table}
(id, user, pass, reply, date) values ('', '%{User-Name}',
'%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())
modified in this way with name
Please find here below a correction
of the previous post in understandable English format
;-)
Hi all,
I have installed freeRADIUS with mySQL backend.
Into sql.conf there are defined several queries, on
of these is the following:
postauth_query =
INSERT into ${postauth_table} (id
I would like to build a new query to insert
user's MAC address into radcheck table, as users log-out (accounting-stop
packet).
Just append the query to the existing ones.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
If i understand the sql.conf from freeradius-1.0.5 right, then the
default queries do a case sensitive check for the UserName.
The alternate queries are marked for case insensitive usernames. So i
understand the default queries are for case sensitive usernames.
Am i wrong in this understanding
If i understand the sql.conf from freeradius-1.0.5 right, then the default
queries do a case sensitive check for the UserName.
The alternate queries are marked for case insensitive usernames. So i
understand the default queries are for case sensitive usernames.
Am i wrong
Andreas Engler wrote:
If i understand the sql.conf from freeradius-1.0.5 right, then the
default queries do a case sensitive check for the UserName.
The alternate queries are marked for case insensitive usernames. So i
understand the default queries are for case sensitive usernames.
Am i
Hi,
I try to add an additional query in the query update in sql.conf. This
is possible to make it ?
Here what I have test:
accounting_update_query = UPDATE ${acct_table1} \
SET FramedIPAddress = '%{Framed-IP-Address}', \
AcctSessionTime = '%{Acct-Session-Time
Hello,
I thought a second time about it and i guess it is an performance
related decision, because it is most likely that no entry exits.
/ to prevent duplicate entries in the radacct table, shouldn't the
// accounting_start_query be the UPDATE query and the
/
How are you going to UPDATE
Andreas Engler wrote:
So now for me remains in which case won't an Insert work but the
alternate Update, or what for is accounting_start_query_alt.
INSERT may fail if your SQL schema defines a unique index to prevent
insertion of duplicate accounting records.
With MySQL 4.1 you could use the
my NAS and freeradius will run at one machine.
how to configure these .conf s ?
is there a guider?
thanx.
shenwei
zack musa wrote:
HI
there is something that confused me. In sql.conf. the
server field should be any IP of a server running
Mysql. Is it? When i try using localhost, the radius
running properly (from the debug mode) but when i used
the IP addr of which the same mechine i run radius
server using
HI
there is something that confused me. In sql.conf. the
server field should be any IP of a server running
Mysql. Is it? When i try using localhost, the radius
running properly (from the debug mode) but when i used
the IP addr of which the same mechine i run radius
server using localhost, there's
[EMAIL PROTECTED] wrote:
I have create the first query and try to insert in the
table radpostauth. But when I execute the radiusd in
debug mode I see this:
WARNING: Attempt to use unknown xlat function, or
non-existent attribute in string %{postauth_profile}
Read doc/variables.txt for
Hello folks, I'm using an MySQL database to
authenticate my users. I'm trying to create new sql
queries to put new values in new fields.
I try to do like this:
postauth_profile = SELECT Value FROM
${authreply_table} WHERE UserName = '%{SQL-User-Name}'
AND STRCMP(Attribute, 'State') = 0
Does freeradius 0.9.1 not support
readclients = yes
in sql.conf
Amit Gupta
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 06 October 2004 03:14, Amit Gupta wrote:
Does freeradius 0.9.1 not support
readclients = yes
in sql.conf
Amit Gupta
According to the FR website, 0.9.1 is over a year old. Sorry, but I can't
think that far back. :)
Looking
I've just copied the queries from the CVS-snapshot in sql.conf to my running (0.9.3)
for getting updated acct-session time etc and noticed one possible wrong query in the
sql.conf of the CVS-snapshot/sql.conf, maybe something to correct:
it reads (DATE_SUB for starttime
On Thu, Apr 29, 2004 at 12:29:28PM +0200, Michael Markstaller wrote:
I've just copied the queries from the CVS-snapshot in sql.conf to my running (0.9.3)
for getting updated acct-session time etc and noticed one possible wrong query in
the sql.conf of the CVS-snapshot/sql.conf, maybe
Hi All,
I can see accounting_update_query in SQl.conf which updates RADACCT
table for each ACCOUNTINGT_UPDATE PACKET form NAS.
My question is can I specify more than one query here.
I want to decrement SESSION_TIMEOUT in RERPLY by min each time I receive
Accounting update packets.
So
[EMAIL PROTECTED] escreveu:
Hi All,
I can see accounting_update_query in SQl.conf which updates RADACCT
table for each ACCOUNTINGT_UPDATE PACKET form NAS.
My question is can I specify more than one query here.
I want to decrement SESSION_TIMEOUT in RERPLY by min each time I receive
Accounting
if someone is going over their top-up limits.
All I want to do is
Remaining time = Remaining time-1 minute each minute.
Is it 100% sure we can't have more than one query in SQL.conf?
Any thoughts guys?
Regards,
Sagar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list
need one copy of the counter (or sqlcoutner) module.
All I want to do is
Remaining time = Remaining time-1 minute each minute.
Hmm... the counter and sqlcounter modules don't listen to interim
updates, only accounting stop messages.
Is it 100% sure we can't have more than one query in SQL.conf
1 - 100 of 104 matches
Mail list logo