use control attribute in sql.conf (sql module config file) query

2013-03-31 Thread Mehdi Ravanbakhsh
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

Re: how to access CallingStationId and CalledStationId propertes in diaup.conf (sql.conf) in a SQL query

2013-03-23 Thread Mehdi Ravanbakhsh
Thanks i am find correct name . On Sat, Mar 23, 2013 at 5:35 PM, Phil Mayers wrote: > 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('%

Re: how to access CallingStationId and CalledStationId propertes in diaup.conf (sql.conf) in a SQL query

2013-03-23 Thread Phil Mayers
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 va

how to access CallingStationId and CalledStationId propertes in diaup.conf (sql.conf) in a SQL query

2013-03-23 Thread Mehdi Ravanbakhsh
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 r

Re: Question about the behavior of sql.conf

2012-12-27 Thread Phil Mayers
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 th

Re: Question about the behavior of sql.conf

2012-12-27 Thread Phil Mayers
On 12/27/2012 06:20 AM, Fajar A. Nugraha wrote: On Thu, Dec 27, 2012 at 1:00 PM, ichiro tanaka 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

Re: Question about the behavior of sql.conf

2012-12-26 Thread Fajar A. Nugraha
On Thu, Dec 27, 2012 at 1:00 PM, ichiro tanaka 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

Question about the behavior of sql.conf

2012-12-26 Thread ichiro tanaka
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 u

Re: Different versions of sql.conf

2012-04-24 Thread Carl Peterson
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 an

Re: Different versions of sql.conf

2012-04-23 Thread alan buxey
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

Different versions of sql.conf

2012-04-23 Thread Carl Peterson
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 the

Re: sql.conf vs. modules/sql

2010-10-26 Thread Josip Rodin
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 wouldn'

Re: sql.conf vs. modules/sql

2010-10-26 Thread Rhommel Lamas
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 in >> radiusd.conf. > > Yes... > >> I w

Re: sql.conf vs. modules/sql

2010-10-26 Thread Alan DeKok
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 - thes

sql.conf vs. modules/sql

2010-10-26 Thread Stefan Winter
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 in

Re: sql.conf failover readclients=yes

2009-04-21 Thread Alan DeKok
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 N

Re: sql.conf failover readclients=yes

2009-04-21 Thread leopold
e source code of the server. > > Alan DeKok. > - > List info/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 FreeRadiu

Re: sql.conf failover readclients=yes

2009-04-21 Thread Alan DeKok
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

Re: sql.conf failover readclients=yes

2009-04-21 Thread leopold
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

Re: sql.conf failover readclients=yes

2009-04-17 Thread leopold
: starting 11 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.con

sql.conf failover readclients=yes

2009-04-17 Thread leopold
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 sq

Re: Making each virtual server have their own sql.conf file

2008-09-10 Thread tnt
> >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. I

Making each virtual server have their own sql.conf file

2008-09-10 Thread Nataniel Klug
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

Re: sql.conf file

2007-08-14 Thread Peter Nixon
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

Re: sql.conf file

2007-08-14 Thread Fred Zinsli
ailing list 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 freeradius_mysql packa

Re: sql.conf file

2007-08-14 Thread zahra bahar
ROTECTED]> wrote: 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

Re: sql.conf file

2007-08-12 Thread Mordor Networks
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

sql.conf file

2007-08-12 Thread zahra bahar
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

Re: sql_log and sql.conf

2007-06-14 Thread Nicolas Baradakis
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

sql_log and sql.conf

2007-06-14 Thread Stefan Winter
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? Gree

Re: new query verification in sql.conf

2007-03-15 Thread Jean Carlos Oliveira Guandalini
','','','blackholed','10'); > > Jean Carlos Oliveira Guandalini wrote: > >> I use freeradius for authentication of pppoe wifi. >> >> I need to make new sql query in a table with a list of mac-address, if >> the CallingSt

Re: new query verification in sql.conf

2007-03-15 Thread Alexander Serkin
x27;','','blackholed','10'); Jean Carlos Oliveira Guandalini wrote: > I use freeradius 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-ad

Re: new query verification in sql.conf

2007-03-14 Thread tnt
>> >> >>> I use freeradius 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 con

Re: new query verification in sql.conf

2007-03-14 Thread Pierluigi Di Lorenzo
piše: >> >> >>> I use freeradius 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 w

Re: new query verification in sql.conf

2007-03-14 Thread Jean Carlos Oliveira Guandalini
ist 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

Re: new query verification in sql.conf

2007-03-14 Thread tnt
use freeradius 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 mak

new query verification in sql.conf

2007-03-14 Thread Jean Carlos Oliveira Guandalini
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

sql set up - Fall-Through agains read_gr oups in sql.conf

2007-02-28 Thread tzieleniewski
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/subs

Adding queries to sql.conf and/or radiusd.conf

2006-11-15 Thread Michelle Manning
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

Re: sql.conf problem

2006-10-25 Thread Alan DeKok
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 http://deploying

Re: sql.conf problem

2006-10-25 Thread Norbert Wegener
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

Re: sql.conf problem

2006-10-24 Thread Alan DeKok
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

sql.conf problem

2006-10-24 Thread Norbert Wegener
meout | = | 123 | NULL | NULL | NULL| ++--+--++---++--+-+ 1 row in set (0.00 sec) authorize_check_query from sql.conf is: authorize_check_query = "SELECT id, UserName, Attribute, Value, op \

Two querys for accounting_stop_query (sql.conf)

2006-10-23 Thread micobros
Hello,   I’m 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

Re: variable escaping ins sql.conf

2006-10-17 Thread Alan DeKok
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 http://d

variable escaping ins sql.conf

2006-10-13 Thread Norbert Wegener
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 W

Re: sql.conf

2006-08-07 Thread Chris Knipe
- Original Message - From: "Francois-Xavier GAILLARD" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" 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 s

Re: sql.conf

2006-08-07 Thread Francois-Xavier GAILLARD
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 t

Re: sql.conf

2006-08-07 Thread Duane Cox
- From: "Alan DeKok" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, August 07, 2006 10:14 AM Subject: Re: sql.conf fvt3 <[EMAIL PROTECTED]> wrote: > How do you convert the SQL-User-Name sent to upper > case? I have my mac address store in

Re: sql.conf

2006-08-07 Thread fvt3
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 conv

Re: sql.conf

2006-08-07 Thread Alan DeKok
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. -- http://deploying

sql.conf

2006-08-07 Thread fvt3
Question, 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. I'm trying to edit the sql.conf file but not successful. Username = '%{SQL-User-Name}' Th

Re: Having multiple authentication query in sql.conf

2006-03-29 Thread vignesh_b
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

Re: Having multiple authentication query in sql.conf

2006-03-28 Thread Peter Nixon
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 > an

Having multiple authentication query in sql.conf

2006-03-27 Thread vignesh
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

Doubt regarding sql.conf

2006-03-22 Thread vignesh
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

Re: sql.conf

2006-03-21 Thread Dennis Skinner
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 htt

Re: sql.conf

2006-03-21 Thread Guy Fraser
EMAIL PROTECTED]:radius > > 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 > >

Re: sql.conf

2006-03-20 Thread Joel Eddy
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" Sent: Monday, March 20, 2006 5:23 PM Subject: Re: sql.conf There is

Re: sql.conf

2006-03-20 Thread Laker Netman
gt; [EMAIL PROTECTED]:radius > > rlm_sql_mysql: Mysql error 'Access denied for user > 'radius'@'localhost' > (using password: YES)' > > rlm_sql (sql): Failed to connect DB handle #0 > > rlm_sql (sql): starting 1 > > rlm_sql (sql): starting 2

sql.conf

2006-03-20 Thread Atkins, Dwane P
ost' (using password: YES)' 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:   # Connec

Re: Possibility to set acct_table1 outside of sql.conf?

2006-02-16 Thread Alan DeKok
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 i

Possibility to set acct_table1 outside of sql.conf?

2006-02-16 Thread Andreas Engler
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 in

R: using scripts for sql.conf

2006-02-15 Thread Carlo Prestopino
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 http://www.freeradius.org/list/users.html

Re: using scripts for sql.conf

2006-02-10 Thread Alan DeKok
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

Re: using scripts for sql.conf

2006-02-10 Thread Maqbool Hashim
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

Re: using scripts for sql.conf

2006-02-09 Thread Alan DeKok
Maqbool Hashim <[EMAIL PROTECTED]> wrote: > 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? rlm_exec. List it b

using scripts for sql.conf

2006-02-09 Thread Maqbool Hashim
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

FR - Writing Own Queries in sql.conf - Help

2006-02-06 Thread Saeed Ahmed
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 somethi

FR - Writing own queries in sql.conf - help

2006-02-06 Thread Saeed Ahmed
        Hi Everyone, I am sending t

R: SQL.conf new query

2006-02-03 Thread Carlo Prestopino
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

Re: SQL.conf new query

2006-02-02 Thread Nicolas Baradakis
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

R: R: R: SQL.conf new query

2006-01-31 Thread Carlo Prestopino
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. 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? Co

Re: SQL.conf new query

2006-01-28 Thread Rich Marriner
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 seperat

Re: SQL.conf new query

2006-01-28 Thread Nicolas Baradakis
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 CL

R: R: R: SQL.conf new query

2006-01-28 Thread Carlo Prestopino
Thank you both Richard/Alan, I’ll 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

Re: R: R: SQL.conf new query

2006-01-27 Thread Rich Marriner
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 quer

Re: R: R: SQL.conf new query

2006-01-27 Thread Alan DeKok
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 earl

Re: R: R: SQL.conf new query

2006-01-27 Thread Rich Marriner
tion-Id', ':=', '%{Calling-Station-Id}')" It seems a lot easier than 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_que

Re: R: R: SQL.conf new query

2006-01-27 Thread Alan DeKok
"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

R: R: SQL.conf new query

2006-01-27 Thread Carlo Prestopino
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 = "INSERT into ${postauth_table} (id, user, pass, reply, date) v

R: R: SQL.conf new query

2006-01-27 Thread Paolo Pellicori
-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())" it does not appear and consequently it does not work: ( Solutions? Regards Inviato: giovedì 26 gennaio 2006 18.41 A: FreeRadius users mailing list Oggetto: Re: R: SQL.conf new query >

Re: R: SQL.conf new query

2006-01-26 Thread Alan DeKok
> 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

R: SQL.conf new query

2006-01-26 Thread Carlo Prestopino
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

SQL.conf new query

2006-01-26 Thread Paolo Pellicori
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}'

Re: sql.conf and case sensitive UserNames fr 1.0.5

2005-11-18 Thread Nicolas Baradakis
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 sensiti

Re: sql.conf and case sensitive UserNames fr 1.0.5

2005-11-18 Thread Mike Jenkins
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

sql.conf and case sensitive UserNames fr 1.0.5

2005-11-18 Thread Andreas Engler
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

sql.conf (update query)

2005-08-09 Thread Michel Bélanger
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 = '

Re: Question on sql.conf -> accounting_start_query <-> accounting_start_query_alt

2005-07-26 Thread Nicolas Baradakis
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 th

Re: Question on sql.conf -> accounting_start_query <-> accounting_start_query_alt

2005-07-26 Thread Andreas Engler
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

Re: Question on sql.conf -> accounting_start_query <-> accounting_start_query_alt

2005-07-25 Thread Alan DeKok
Andreas Engler <[EMAIL PROTECTED]> wrote: > 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 an entry that doesn't exist? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradiu

Question on sql.conf -> accounting_start_query <-> accounting_start_query_alt

2005-07-25 Thread Andreas Engler
Hello, to prevent duplicate entries in the radacct table, shouldn't the accounting_start_query be the "UPDATE" query and the accounting_start_query_alt be the "INSERT into" query as it is the case on stop and update. In which case would the accounting_start_query fail and the accounting_start_qu

how to configure radiusd.conf , clients.conf and sql.conf

2005-03-16 Thread shenwei
  my NAS and freeradius will run at one machine.   how to configure these .conf s ?   is there a guider?   thanx.           shenwei   

Re: sql.conf 'server' field

2004-12-13 Thread Thor Spruyt
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

sql.conf 'server' field

2004-12-12 Thread zack musa
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&#

Re: New sql queries in sql.conf

2004-11-27 Thread Alan DeKok
<[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.

New sql queries in sql.conf

2004-11-26 Thread andremail82-radius
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" postaut

Re: Does freeradius 0.9.1 not support 'readclients = yes' in sql.conf

2004-10-06 Thread Kevin Bonner
-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&#

Does freeradius 0.9.1 not support 'readclients = yes' in sql.conf

2004-10-06 Thread Amit Gupta
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

  1   2   >