rlm_sqlcounter problem
dear all, I got message from my radius (freeradius-0.9.1), RedHat 8.0, like this : rlm_sqlcounter: coult not find check item value pair. any suggest for this case ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_counter and rlm_sqlcounter
On Sun, 19 Oct 2003, apellido jr., wilfredo p wrote:
> Have a nice day Mr. Kalevras, I just question
> regarding counter attribute, is this possible to add
> this attribute in rlm_sqlcounter? or it is just for
> rlm_counter? Both rlm_counter and rlm_sqlcounter
> support user define reset, i tried to change the
> default reset of sql_monthlycounter and counter
> Monthly
> to 3 months and here's the LOG
>
> daywalker# radiusd -xx
> Starting - reading configuration files ...
> reread_config: reading radiusd.conf
> Config: including file: /etc/raddb/proxy.conf
> Config: including file: /etc/raddb/clients.conf
[...]
> Module: Loaded Counter
> counter: filename = "/etc/raddb/db.monthly"
> counter: key = "User-name"
> counter: reset = "3m"
> counter: count-attribute = "Acct-Session-Time"
> counter: counter-name = "Monthly-Session-Time"
> counter: check-name = "Max-Monthly-Session"
> counter: allowed-servicetype = "Framed-User"
> counter: cache-size = 5000
> rlm_counter: Counter attribute Monthly-Session-Time is
> number 1081
> rlm_counter: num=3, last=m
> rlm_counter: Current Time: 1066614025, Next reset
> 1072886400
You could try using the cvs version of rlm_counter, it will print the current
time and next reset time in human readable form. In any case for rlm_counter the
next is after 72 days which is probably at the first day of the third month
ahead.
[...]
> Module: Loaded SQL Counter
> sqlcounter: counter-name = "Monthly-Session-Time"
> sqlcounter: check-name = "Max-Monthly-Session"
> sqlcounter: key = "User-Name"
> sqlcounter: sqlmod-inst = "sqlcca3"
> sqlcounter: query = "SELECT SUM(AcctSessionTime) FROM
> radacct WHERE UserName='%{%k}' AND AcctStartTime >
> FROM_UNIXTIME('%b')"
> sqlcounter: reset = "3m"
> rlm_sqlcounter: Counter attribute Monthly-Session-Time
> is number 1081
> rlm_sqlcounter: Check attribute Max-Monthly-Session is
> number 1082
> rlm_sqlcounter: num=1, last=m
> rlm_sqlcounter: Current Time: 1066614026 [2003-10-20
> 09:40:26], Next reset 1067616000 [2003-11-01 00:00:00]
> rlm_sqlcounter: num=3, last=m
> rlm_sqlcounter: Current Time: 1066614026 [2003-10-20
> 09:40:26], Prev reset 1059667200 [2003-08-01 00:00:00]
> Module: Instantiated sqlcounter (monthlycounter)
>
> why isnt it the next reset STILL first day of the
> month?
As for rlm_sqlcounter i don't know.
>
>
>
> =
> [ apellido jr., wilfredo p. ]
> +63 034 4880-449
>
> If you can't hear me, it's because i'm in parentheses.
>
> __
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_counter and rlm_sqlcounter
Have a nice day Mr. Kalevras, I just question
regarding counter attribute, is this possible to add
this attribute in rlm_sqlcounter? or it is just for
rlm_counter? Both rlm_counter and rlm_sqlcounter
support user define reset, i tried to change the
default reset of sql_monthlycounter and counter
Monthly
to 3 months and here's the LOG
daywalker# radiusd -xx
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /etc/raddb/proxy.conf
Config: including file: /etc/raddb/clients.conf
Config: including file: /etc/raddb/snmp.conf
Config: including file: /etc/raddb/sqlcounter.conf
Config: including file: /etc/raddb/sql.conf
main: prefix = "/usr/local"
main: localstatedir = "/var"
main: logdir = "/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_file = "/var/log/radius/radius.log"
main: log_auth = yes
main: log_auth_badpass = yes
main: log_auth_goodpass = yes
main: pidfile = "/var/run/radiusd/radiusd.pid"
main: user = "(null)"
main: group = "(null)"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/local/sbin/checkrad"
main: proxy_requests = no
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = yes
proxy: wake_all_if_all_dead = no
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
Using deprecated naslist file. Support for this will
go away soon.
read_config_files: reading clients
Using deprecated clients file. Support for this will
go away soon.
read_config_files: reading realms
Using deprecated realms file. Support for this will
go away soon.
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded Counter
counter: filename = "/etc/raddb/db.monthly"
counter: key = "User-name"
counter: reset = "3m"
counter: count-attribute = "Acct-Session-Time"
counter: counter-name = "Monthly-Session-Time"
counter: check-name = "Max-Monthly-Session"
counter: allowed-servicetype = "Framed-User"
counter: cache-size = 5000
rlm_counter: Counter attribute Monthly-Session-Time is
number 1081
rlm_counter: num=3, last=m
rlm_counter: Current Time: 1066614025, Next reset
1072886400
Module: Instantiated counter (Monthly)
Module: Loaded PAP
pap: encryption_scheme = "clear"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
Module: Instantiated mschap (mschap)
Module: Loaded preprocess
preprocess: huntgroups = "/etc/raddb/huntgroups"
preprocess: hints = "/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "root"
sql: password = "mysql99%"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT
id,UserName,Attribute,Value,op FROM radcheck WHERE
STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER BY id"
sql: authorize_reply_query = "SELECT
id,UserName,Attribute,Value,op FROM radreply WHERE
STRCMP(Username, '%{SQL-User-Name}') = 0 ORDER BY id"
rlm_sqlcounter
Good day Mr. kalevras thanks for suggestion. As of now, the user login works correctly. I have a question regarding rlm_sqlcounter, do i need to create a special counter to do this task? I want to limit the monthly internet usage of the client. For example 10 hours per month then after 10 hours it is disconnected and dialup_admin show that the user is out of monthly quota. Monthly counter work in this but I thought because the user already consume 10 hours probably the user can't login anymore without administrator's update. But after testing whew ... the user can still login again and again and again, disconnecting every 10 hours. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter ( Monthly Limit)
On Thu, 9 Oct 2003, apellido jr., wilfredo p wrote: > hello guys why isnt it i got this error when im trying > to run radius -xx? > > rlm_sql (sql): Released sql socket id: 4 > modcall[authorize]: module "sql" returns ok > rlm_sqlcounter: Entering module authorize code > rlm_sqlcounter: Could not find Check item value pair ^^ You need to set the Check item you have configured in the counter module (the check-name configuration directive) somewhere (in the users file,in mysql/ldap etc) > modcall[authorize]: module "monthlycounter" returns > noop > > > i just added sqlcounter.conf in /etc/raddb and added > monthlycounter in radius.conf under authorization. The > user can authenticate but the Login-Time doesnt work. > They can still Login eventhough they are not in the > time span. What im missing here? thanks > > > = > [ apellido jr., wilfredo p. ] > +63 034 4880-449 > > If you can't hear me, it's because i'm in parentheses. > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter ( Monthly Limit)
hello guys why isnt it i got this error when im trying to run radius -xx? rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair modcall[authorize]: module "monthlycounter" returns noop i just added sqlcounter.conf in /etc/raddb and added monthlycounter in radius.conf under authorization. The user can authenticate but the Login-Time doesnt work. They can still Login eventhough they are not in the time span. What im missing here? thanks = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter : file not found
Hi I must appologise, by mistake I included some user list in my email to all my friends and our customers Regards Bogdan - Original Message - From: "Josephine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 1:26 PM Subject: RE: rlm_sqlcounter : file not found > Aaron Weiker wrote : > >>Before compile pass --with-experimental-modules to the configure script. > >>This should compile it in. You may get other modules that fail to > >>compile, what I had to do was just remove their directory and then run > >>configure again. > > > > Hi Aaron, > I can't get what you mean 'remove their directory and then run > configure'. Which directory you are referring ? > > Please advise. Thanks in advance. > > > Josephine. > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter
Well, i'm using freeradius 0.9.1 on redhat 9.0 and mysql and all is working well, but now i'm trying to use sql_counter module to limiting the connection time, for example if a user is allowed to for 600 sec: 1- in the first connection radius will send a session-timeout of 600 to the nat, and if the user disconnect after 300 sec, and here the user will have 300 sec left. 2- in the seconde connection the radius will send an updated session-timeout of 300 sec to the nat and the user will be disconnected after 300 sec. Thanks -- Yacine BOUKABA WEBMASTER AUCZONE.COM - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter compile error on FreeBSD
Did you try: pkg_add -r gmake Alex Jeon wrote: > Hi All, > The log is as below. > yeppi# ./configure > loading cache ./config.cache > checking for gcc... (cached) gcc > checking whether the C compiler (gcc ) works... yes > checking whether the C compiler (gcc ) is a cross-compiler... no > checking whether we are using GNU C... (cached) yes > checking whether gcc accepts -g... (cached) yes > checking how to run the C preprocessor... (cached) gcc -E > updating cache ./config.cache > creating ./config.status > creating Makefile > creating config.h > config.h is unchanged > yeppi# make > "../rules.mak", line 65: Missing dependency operator > "../rules.mak", line 82: Missing dependency operator > "../rules.mak", line 84: Need an operator > "../rules.mak", line 86: Need an operator > "../rules.mak", line 92: Missing dependency operator > "../rules.mak", line 94: Need an operator > "../rules.mak", line 121: Need an operator > "../rules.mak", line 127: Need an operator > make: fatal errors encountered -- cannot continue > > And then I was looking for the solution for this problem. > There is an article that I should use gmake not make on compiling on > FreeBSD. > So, I did a retry using gmake. > The log is as below. > yeppi# ./configure > loading cache ./config.cache > checking for gcc... (cached) gcc > checking whether the C compiler (gcc ) works... yes > checking whether the C compiler (gcc ) is a cross-compiler... no > checking whether we are using GNU C... (cached) yes > checking whether gcc accepts -g... (cached) yes > checking how to run the C preprocessor... (cached) gcc -E > updating cache ./config.cache > creating ./config.status > creating Makefile > creating config.h > config.h is unchanged > yeppi# gmake > gmake: CC@: Command not found > gmake: *** [rlm_sqlcounter.o] Error 127 > And I was looking for this error but in vain. > Could you tell me how I can solve this problem? > Thanks. -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter compile error on FreeBSD
Hi All, The log is as below. yeppi# ./configureloading cache ./config.cachechecking for gcc... (cached) gccchecking whether the C compiler (gcc ) works... yeschecking whether the C compiler (gcc ) is a cross-compiler... nochecking whether we are using GNU C... (cached) yeschecking whether gcc accepts -g... (cached) yeschecking how to run the C preprocessor... (cached) gcc -Eupdating cache ./config.cachecreating ./config.statuscreating Makefilecreating config.hconfig.h is unchanged yeppi# make"../rules.mak", line 65: Missing dependency operator"../rules.mak", line 82: Missing dependency operator"../rules.mak", line 84: Need an operator"../rules.mak", line 86: Need an operator"../rules.mak", line 92: Missing dependency operator"../rules.mak", line 94: Need an operator"../rules.mak", line 121: Need an operator"../rules.mak", line 127: Need an operatormake: fatal errors encountered -- cannot continueAnd then I was looking for the solution for this problem. There is an article that I should use gmake not make on compiling on FreeBSD. So, I did a retry using gmake. The log is as below. yeppi# ./configureloading cache ./config.cachechecking for gcc... (cached) gccchecking whether the C compiler (gcc ) works... yeschecking whether the C compiler (gcc ) is a cross-compiler... nochecking whether we are using GNU C... (cached) yeschecking whether gcc accepts -g... (cached) yeschecking how to run the C preprocessor... (cached) gcc -Eupdating cache ./config.cachecreating ./config.statuscreating Makefilecreating config.hconfig.h is unchanged yeppi# gmakegmake: CC@: Command not foundgmake: *** [rlm_sqlcounter.o] Error 127 And I was looking for this error but in vain. Could you tell me how I can solve this problem? Thanks.
Re: rlm_sqlcounter
John, You are the man. Thanks so much. I configured/compiled/installed it manually. Working now. Scott From: "john zurowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 26, 2003 2:10 PM Subject: Re: rlm_sqlcounter > >From: "Scott" > > >Reply-To: [EMAIL PROTECTED] > >To: > >Subject: rlm_sqlcounter > >Date: Tue, 26 Aug 2003 11:54:43 -0400 > > > >Redhat8, freeradius 0.9.0 > > > >I can't get rlm_sqlcounter to work. I've read the docs carefully and > >performed all the steps. > >./configure --with-experimental-modules > > > >During the configure process I see the following; > >configuring in src/modules/rlm_sqlcounter > > > >I've created the sqlcounter.conf file and added the proper lines into > >radiusd.conf > > > >I added some data into radcheck > > > >When I start up radiusd it dies with this output; > >radiusd.conf[2] Failed to link to module 'rlm_sqlcounter': file not found > > > > check that /usr/local/lib (or where ever you install the modules) > > contains rlm_sqlcounter.so > > If it isn't there it hasn't built correctly > > > > >I noticed that the configure file in the rlm_sqlcounter directory was not > >executable and changed that. If I comment the module and accounting > >startements from radiusd.conf radiusd starts up and authenticates/accounts > >with mysql perfectly. > > > >I've read everything I can find on this and I still can't get it working. > >Thanks for any help, > > > >Scott > > > > > >- > >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > -- -- > Get your hands on designer bargains for less - click here. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter
>From: "Scott" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: <[EMAIL PROTECTED]> >Subject: rlm_sqlcounter >Date: Tue, 26 Aug 2003 11:54:43 -0400 > >Redhat8, freeradius 0.9.0 > >I can't get rlm_sqlcounter to work. I've read the docs carefully and >performed all the steps. >./configure --with-experimental-modules > >During the configure process I see the following; >configuring in src/modules/rlm_sqlcounter > >I've created the sqlcounter.conf file and added the proper lines into >radiusd.conf > >I added some data into radcheck > >When I start up radiusd it dies with this output; >radiusd.conf[2] Failed to link to module 'rlm_sqlcounter': file not found check that /usr/local/lib (or where ever you install the modules) contains rlm_sqlcounter.so If it isn't there it hasn't built correctly > >I noticed that the configure file in the rlm_sqlcounter directory was not >executable and changed that. If I comment the module and accounting >startements from radiusd.conf radiusd starts up and authenticates/accounts >with mysql perfectly. > >I've read everything I can find on this and I still can't get it working. >Thanks for any help, > >Scott > > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Get your hands on designer bargains for less - click here. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter
Redhat8, freeradius 0.9.0 I can't get rlm_sqlcounter to work. I've read the docs carefully and performed all the steps. ./configure --with-experimental-modules During the configure process I see the following; configuring in src/modules/rlm_sqlcounter I've created the sqlcounter.conf file and added the proper lines into radiusd.conf I added some data into radcheck When I start up radiusd it dies with this output; radiusd.conf[2] Failed to link to module 'rlm_sqlcounter': file not found I noticed that the configure file in the rlm_sqlcounter directory was not executable and changed that. If I comment the module and accounting startements from radiusd.conf radiusd starts up and authenticates/accounts with mysql perfectly. I've read everything I can find on this and I still can't get it working. Thanks for any help, Scott - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter cannot compile in FreeBSD 4.8
En réponse à apellido jr., wilfredo p :
> Hello guys, after sucessfully installed freeradius
> without experimental module. Our company decided to
> launch an prepaid internet. Now, im tried to
> reconfigure my freeradius with experimental module and
> here's the error after compiling.
Exactly the same question was asked in this mailing list last week.
The answer was "{Free,Net}BSD users have to use gmake instead of make"
--
Nicolas Baradakis
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter cannot compile in FreeBSD 4.8
Hello guys, after sucessfully installed freeradius without experimental module. Our company decided to launch an prepaid internet. Now, im tried to reconfigure my freeradius with experimental module and here's the error after compiling. ### sh /usr/local/freeradius-snapshot-20030816/src/modules/rlm_sqlcounter/configure here's the Makefile # Generated automatically from Makefile.in by configure. TARGET = rlm_sqlcounter SRCS= rlm_sqlcounter.c HEADERS = RLM_CFLAGS = RLM_LIBS= RLM_INSTALL = include ../rules.mak $(STATIC_OBJS): $(HEADERS) $(DYNAMIC_OBJS): $(HEADERS) ## and here's the error after issuing make "../rules.mak", line 65: Missing dependency operator "../rules.mak", line 82: Missing dependency operator "../rules.mak", line 84: Need an operator "../rules.mak", line 86: Need an operator "../rules.mak", line 92: Missing dependency operator "../rules.mak", line 94: Need an operator "../rules.mak", line 123: Need an operator "../rules.mak", line 129: Need an operator make: fatal errors encountered -- cannot continue = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter freebsd compile error
thanx, it worked - Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 11:21 AM Subject: Re: rlm_sqlcounter freebsd compile error > Valentin M wrote: > > [...] > > > host# make > > "../rules.mak", line 65: Missing dependency operator > > "../rules.mak", line 82: Missing dependency operator > > "../rules.mak", line 84: Need an operator > > "../rules.mak", line 86: Need an operator > > "../rules.mak", line 92: Missing dependency operator > > "../rules.mak", line 94: Need an operator > > "../rules.mak", line 123: Need an operator > > "../rules.mak", line 129: Need an operator > > make: fatal errors encountered -- cannot continue > > Try using gmake instead of make. > > -- > Nicolas Baradakis > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter freebsd compile error
Valentin M wrote: [...] > host# make > "../rules.mak", line 65: Missing dependency operator > "../rules.mak", line 82: Missing dependency operator > "../rules.mak", line 84: Need an operator > "../rules.mak", line 86: Need an operator > "../rules.mak", line 92: Missing dependency operator > "../rules.mak", line 94: Need an operator > "../rules.mak", line 123: Need an operator > "../rules.mak", line 129: Need an operator > make: fatal errors encountered -- cannot continue Try using gmake instead of make. -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter freebsd compile error
versions tried 0.8.1 and 0.9.0 error desc: host#./configure creating cache ./config.cache checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking how to run the C preprocessor... gcc -E checking for gdbm.h... yes checking for gdbm_open in -lgdbm... yes checking to see GDBM_SYNC status... SYNCs by default. checking for gdbm_fdesc... yes updating cache ./config.cache creating ./config.status creating Makefile creating config.h host# make "../rules.mak", line 65: Missing dependency operator "../rules.mak", line 82: Missing dependency operator "../rules.mak", line 84: Need an operator "../rules.mak", line 86: Need an operator "../rules.mak", line 92: Missing dependency operator "../rules.mak", line 94: Need an operator "../rules.mak", line 123: Need an operator "../rules.mak", line 129: Need an operator make: fatal errors encountered -- cannot continue - Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 3:23 AM Subject: Re: rlm_sqlcounter freebsd compile error > En réponse à Valentin M : > > > i am having a hard time compiling rlm_sqlcounter on a freebsd machine > > any suggestions? > > If you want somebody to help, you should first say which version of > freeradius you are using (0.9.0 or the current CVS) and the error > messages from gcc. > > -- > Nicolas Baradakis > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter freebsd compile error
En réponse à Valentin M : > i am having a hard time compiling rlm_sqlcounter on a freebsd machine > any suggestions? If you want somebody to help, you should first say which version of freeradius you are using (0.9.0 or the current CVS) and the error messages from gcc. -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter freebsd compile error
hello, i am having a hard time compiling rlm_sqlcounter on a freebsd machine any suggestions? Val - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: REPOST: rlm_sqlcounter not working...
On Thu, 14 Aug 2003, Christos Kalantzis wrote:
> Hello,
>
> I have the same problem,
>
> have you find any solution to this ?
>
> Thank you in advance,
> Christos Kalantzis
>
>
> I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1
>
> and am have a bit of trouble. It appears that the module is not
> querying the sql database...
>
> When running radius -X, I get the following:
>
> rlm_sqlcounter: Entering module authorize code
> rlm_sqlcounter: Could not find Check item value pair
^^
So provide it with the corresponding check item.
> modcall[authorize]: module "allcounter" returns noop
> rlm_sqlcounter: Entering module authorize code
> rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "dailycounter" returns noop
> rlm_sqlcounter: Entering module authorize code
> rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "monthlycounter" returns noop
>
> The configuration directive for the modules are as follows:
>
> sqlcounter allcounter {
> counter-name = Max-All-Session-Time
> check-name = Max-All-Session
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
> UserName='%{%k}'"
> }
>
> sqlcounter dailycounter {
> counter-name = Daily-Session-Time
> check-name = Max-Daily-Session
> sqlmod-inst = sql
> key = User-Name
> reset = daily
> query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
> UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
> AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
> sqlcounter monthlycounter {
> counter-name = Monthly-Session-Time
> check-name = Max-Monthly-Session
> sqlmod-inst = sql
> key = User-Name
> reset = monthly
> query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
> UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
> AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>
> --Robert R. George
>
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
REPOST: rlm_sqlcounter not working...
Hello,
I have the same problem,
have you find any solution to this ?
Thank you in advance,
Christos Kalantzis
I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1
and am have a bit of trouble. It appears that the module is not
querying the sql database...
When running radius -X, I get the following:
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "allcounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "dailycounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "monthlycounter" returns noop
The configuration directive for the modules are as follows:
sqlcounter allcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'"
}
sqlcounter dailycounter {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = daily
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
sqlcounter monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
--Robert R. George
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
failed to link to module 'rlm_sqlcounter'
hi, Why i always get this error message , since i already install with --experimental modules ( i removed the rlm_smb becoz error ). but another modules are OK. -- Module: Instantiated sql (sql) Module: Loaded files files: usersfile = "/usr/local/etc/raddb/users" files: acctusersfile = "/usr/local/etc/raddb/acct_users" files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" files: compat = "no"Module: Instantiated files (files) radiusd.conf[1] Failed to link to module 'rlm_sqlcounter': file not found machine : freebsd-4.7-rel freeradius-0.8.1
RE: Failed to link to module 'rlm_sqlcounter': file not found
Have you compiled with --expeimental-modules ? See http://www.freeradius.org/radiusd/doc/rlm_sqlcounter Follow this doc and everythings gona be OK ... Nicolas > -Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de alantu > Envoyé : dimanche 6 juillet 2003 14:00 > À : [EMAIL PROTECTED] > Objet : Failed to link to module 'rlm_sqlcounter': file not found > > > freeradius-users > Hi all > According to /doc/rlm_sqlcounter ,i use sqlcounter to limit > use for using time.when i run radius under debug model(radiusd > -X) ,receive the line "Failed to link to module 'rlm_sqlcounter': > file not found" Can someone help me out ? >Best regards > > alantu > [EMAIL PROTECTED] > 2003-07-06 > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Failed to link to module 'rlm_sqlcounter': file not found
freeradius-users Hi all According to /doc/rlm_sqlcounter ,i use sqlcounter to limit use for using time.when i run radius under debug model(radiusd -X) ,receive the line "Failed to link to module 'rlm_sqlcounter': file not found" Can someone help me out ? Best regards alantu [EMAIL PROTECTED] 2003-07-06 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter
=?ISO-8859-1?Q?Liyu=E1n_Garc=EDa_Caballero?= <[EMAIL PROTECTED]> wrote: > I have made everything what the file says to rlm_sql_counter to use the > counter, but when I execute radiusd - X says to me: > > ERROR: Cannot find a configuration entry for module "sql". > > What is this Maybe you need to configure the SQL module, too? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter
Please, Help me. I have made everything what the file says to rlm_sql_counter to use the counter, but when I execute radiusd - X says to me: ERROR: Cannot find a configuration entry for module "sql". What is this -- _*Liyuán García Caballero*_ *Consultor Informático* *ESI, Ciego de Ávila* *Cuba*. _* Contáctame en*_ Telf: 53-033-28734 ext. 120 AIM: liyuang Yahoo,MSN: liyuangarcia. Linux para todos Con grandes prestaciones y altos rendimientos, ha, menos costos. :)
Using primary and secondary databse and rlm_sqlcounter
Hi all,
I'm trying to use 2 different MySQL databases so that in the case of
the primary failing there's a secondary database in order to do the
authentication.
This setup is working if i don't use rlm_sqlcounter to check if the
users already used their time.
I tried doing the same thing (group) for rlm_sqlcounter, but it seems
rlm_sqlcounter succeeds when it doesn't manage to connect to the
database. It seems to me that it considers the sql error as if it
returned that the user hasn't still used any time.
Wonder if any1 managed to get a similar setup to work or as any ideas,
bellow i send the radiusd.conf part and partial log.
Thanks in advance,
Manuel Sousa
>From : http://www.frontios.com/freeradius.html
group {
sql2 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
sql {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
}
Part of the Log:
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{User-Name}''
radius_xlat: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='z57''
sqlcounter_expand: '%{sql2:SELECT SUM(AcctSessionTime) FROM radacct
WHERE UserName='z57'}'
radius_xlat: Running registered xlat function of module sql2 for string
'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='z57''
rlm_sql (sql2): - sql_xlat
radius_xlat: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='z57''
rlm_sql (sql2): Ignoring unconnected handle
rlm_sql (sql2): There are no DB handles to use!
radius_xlat: ''
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user z57, check_item=600, counter=0
rlm_sqlcounter: Sent Reply-Item for user z57, Type=Session-Timeout,
value=600
modcall[authorize]: module "noresetcounter2" returns ok
modcall: group group returns ok
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ldap + rlm_sqlcounter(2)
> Hi All, > i'm using freradius 0.8.1.with accounting stored in sql backend and > user accounts stored in ldap. > is there any way to use user ldap attributes values in the definition > of the rlm_sqlcounter SQL statement? Hi all, let's add some explanations. In fact i need sqlcounter computes the SUM(AcctSessiontime) between to timestamps 'startTime' end 'endTime' stored in the ldap user-profile. thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ldap + rlm_sqlcounter
Hi All, i'm using freradius 0.8.1.with accounting stored in sql backend and user accounts stored in ldap. is there any way to use user ldap attributes values in the definition of the rlm_sqlcounter SQL statement? thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: REPOST: rlm_sqlcounter not working...
Thanks. That took care of it.
--Robert R. George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ed H
Sent: Monday, March 31, 2003 3:53 PM
To: [EMAIL PROTECTED]
Subject: Re: REPOST: rlm_sqlcounter not working...
Hello Robert,
Make sure you have a Max-Monthly-Session := 3600, for example (where
3600 is
the time in seconds allowed per month) in your radgroupcheck or radcheck
table. The same applies to the Max-All-Session and the Max-Daily-Session
variables. Give it a shot and see if it works.
Ed
>From: "Robert R. George" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: REPOST: rlm_sqlcounter not working...
>Date: Mon, 31 Mar 2003 00:05:06 -0800
>
>I am trying to get the rlm_sqlcounter module working in
>freeradius-0.8.1 and am have a bit of trouble. It appears that the
>module is not querying the sql database...
>
>When running radius -X, I get the following:
>
>rlm_sqlcounter: Entering module authorize code
>rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "allcounter" returns noop
>rlm_sqlcounter: Entering module authorize code
>rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "dailycounter" returns noop
>rlm_sqlcounter: Entering module authorize code
>rlm_sqlcounter: Could not find Check item value pair
> modcall[authorize]: module "monthlycounter" returns noop
>
>The configuration directive for the modules are as follows:
>
>sqlcounter allcounter {
> counter-name = Max-All-Session-Time
> check-name = Max-All-Session
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
>UserName='%{%k}'"
> }
>
>sqlcounter dailycounter {
> counter-name = Daily-Session-Time
> check-name = Max-Daily-Session
> sqlmod-inst = sql
> key = User-Name
> reset = daily
> query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
>UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
>AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>sqlcounter monthlycounter {
> counter-name = Monthly-Session-Time
> check-name = Max-Monthly-Session
> sqlmod-inst = sql
> key = User-Name
> reset = monthly
> query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
>UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
>AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
> }
>
>
> --Robert R. George
>
>
>
>-
>List info/subscribe/unsubscribe? See
>http://www.freeradius.org/list/users.html
_
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: REPOST: rlm_sqlcounter not working...
Hello Robert,
Make sure you have a Max-Monthly-Session := 3600, for example (where 3600 is
the time in seconds allowed per month) in your radgroupcheck or radcheck
table. The same applies to the Max-All-Session and the Max-Daily-Session
variables. Give it a shot and see if it works.
Ed
From: "Robert R. George" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: REPOST: rlm_sqlcounter not working...
Date: Mon, 31 Mar 2003 00:05:06 -0800
I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1
and am have a bit of trouble. It appears that the module is not
querying the sql database...
When running radius -X, I get the following:
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "allcounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "dailycounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "monthlycounter" returns noop
The configuration directive for the modules are as follows:
sqlcounter allcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'"
}
sqlcounter dailycounter {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = daily
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
sqlcounter monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
--Robert R. George
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
_
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: REPOST: rlm_sqlcounter not working...
"Robert R. George" <[EMAIL PROTECTED]> wrote: > I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1 > and am have a bit of trouble. It appears that the module is not > querying the sql database... > > When running radius -X, I get the following: > > rlm_sqlcounter: Entering module authorize code > rlm_sqlcounter: Could not find Check item value pair > modcall[authorize]: module "allcounter" returns noop It's not querying the database because you told it to 'check' for certain attributes, and those attributes aren't in the request. So there's nothing it can use to query the database, and it does nothing. What was unclear about the error message? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
REPOST: rlm_sqlcounter not working...
I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1
and am have a bit of trouble. It appears that the module is not
querying the sql database...
When running radius -X, I get the following:
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "allcounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "dailycounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "monthlycounter" returns noop
The configuration directive for the modules are as follows:
sqlcounter allcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'"
}
sqlcounter dailycounter {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = daily
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
sqlcounter monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
--Robert R. George
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Trouble getting rlm_sqlcounter module working...
I am trying to get the rlm_sqlcounter module working in freeradius-0.8.1
and am have a bit of trouble. It appears that the module is not
querying the sql database...
When running radius -X, I get the following:
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "allcounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "dailycounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "monthlycounter" returns noop
The configuration directive for the modules are as follows:
sqlcounter allcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='%{%k}'"
}
sqlcounter dailycounter {
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
sqlmod-inst = sql
key = User-Name
reset = daily
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
sqlcounter monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT SUM(AcctSessionTime - GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"
}
--Robert R. George
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter: unknown xlat function [WAS: rlm_sqlcounter Help-me]
I have the same problem below as this previous message posted below.
Did this ever get solved? I need help with:
WARNING: Attempt to use unknown xlat function or attribute in string
%{sqlcca3:
as in the original message below.
Ed
original message From Mon, 23 Dec 2002 03:33:47 -0800 =
i need help
table radgroupcheck:
mysql> select * from radgroupcheck where GroupName='35Horas';
++---+-+++
| id | GroupName | Attribute | op | Value |
++---+-+++
| 15 | 35horas | Max-Monthly-Session | := | 126000 |
++---+-+++
1 row in set (0.00 sec)
mysql> SELECT SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000';
+--+
| SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) |
+--+
|
232305 |
+--+
1 row in set (0.00 sec)
radius -X
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "noresetcounter" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "dailycounter" returns noop
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime
> '1038708000''
radius_xlat: 'SELECT SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000''
sqlcounter_expand: '%{sqlcca3:SELECT SUM(AcctSessionTime -
GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct
WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime
> '1038708000'}'
WARNING: Attempt to use unknown xlat function or attribute in string
%{sqlcca3:SELECT SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000'}
radius_xlat: ''
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user santos, check_item=126000, counter=0
rlm_sqlcounter: Sent Reply-Item for user santos, Type=Session-Timeout,
value=126000
modcall[authorize]: module "monthlycounter" returns ok
modcall: group authorize returns ok
Why not work ?
=end of original message From Mon, 23 Dec 2002 03:33:47 -0800 =
_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[slightly offtopic] Cisco IVR with rlm_sqlcounter
Hi, I am interested in a billing solution for telephony through the Cisco AS5350's IVR system. I have RTFM, both Cisco's docs, the FreeRADIUS docs (especially exec-program and sqlcounter), as well as the mailing list archives. There are several thread along the lines of, "Is this possible?", "Yes, it's easy, RTFM." It doesn't look too challenging on paper -- certainly not as hard as first grokking the whole RADIUS concept -- but has anyone actually managed to build something with an SQL database (e.g. MySQL or PostgreSQL), FreeRADIUS and software that they wrote themselves (i.e. in exec-program or rlm_python) that can support prepaid calling cards fairly completely? Did you encounter any little problems along the way? Did you successfully overcome them? (I realize that the logic on the otherside to calculate toll charges for different countries etc is a completely different thing.) The problem is that I don't have a Cisco AS5350 or anything resembling it's IVR system here. I am considering whether to purchase a commercial billing solution or to roll my own. Guan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter installation
I've been wading through everything I can find regarding the installation
and configuration of the rlm_sqlcounter module using 0.8.1. It seems to me
that some changes were made to the distribution and the docs haven't
caught up. What I'd like to do is two-fold:
1. sketch out the approach I intend to try and solicit comments (see
below),
2. prepare an updated replacement doc and annotated .conf file for
distribution.
Here's what I think will work, based on existing docs/files/etc, and
assuming the sql module is installed and in use:
a. configure/compile freeradius using --with-rlm_sqlcounter
b. create etc/raddb/sqlcounter.conf using info from doc/rlm_sqlcounter and
etc/raddb/experimental.conf, e.g.,
monthlycounter {
counter-name = Monthly-Session-Time
check-name = Max-Monthly-Session
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "blahblahblah"
}
c. add to etc/radiusd.conf in the modules section:
$INCLUDE ${confdir}/sqlcounter.conf
d. add to etc/radiusd.conf in the authorize section:
sqlcounter {
monthlycounter
}
e. add to the radcheck or radgroupcheck tables the appropriate check-name
a/v pairs
This seems to me that it *should* work, but I've been known to be a moron
at times, so I'd appreciate any feedback and any clue-by-4 whacking that
I need.
Jim
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter Help-me
i need help
table radgroupcheck:
mysql> select * from radgroupcheck where
GroupName='35Horas';++---+-+++|
id | GroupName |
Attribute | op |
Value |++---+-+++| 15
| 35horas | Max-Monthly-Session | := | 126000
|++---+-+++1 row in set
(0.00 sec)
mysql> SELECT SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1038708000';+--+|
SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0))
|+--+|
232305
|+--+1
row in set (0.00 sec)
radius -X
rlm_sqlcounter: Entering module authorize
coderlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "noresetcounter" returns nooprlm_sqlcounter:
Entering module authorize coderlm_sqlcounter: Could not find Check item
value pair modcall[authorize]: module "dailycounter" returns
nooprlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT
SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0))
FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1038708000''radius_xlat: 'SELECT
SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0))
FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1038708000''
sqlcounter_expand: '%{sqlcca3:SELECT
SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0))
FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1038708000'}'
WARNING: Attempt to use unknown xlat function or
attribute in string %{sqlcca3:SELECT SUM(AcctSessionTime - GREATEST((1038708000
- UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1038708000'}radius_xlat: ''
rlm_sqlcounter: (Check item - counter) is greater
than zero
rlm_sqlcounter: Authorized user santos, check_item=126000,
counter=0
rlm_sqlcounter: Sent Reply-Item for user santos, Type=Session-Timeout,
value=126000 modcall[authorize]: module "monthlycounter" returns
ok
modcall: group authorize returns ok
Why not work ?
Re: rlm_sqlcounter
./configure --with-rlm_sql_counter (./configure --help) Peter Santiago a écrit: how do I include rlm_sqlcounter in the compilation? Thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter
how do I include rlm_sqlcounter in the compilation? Thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Enabling rlm_sqlcounter
On Mon, 28 Oct 2002, David C. Troy wrote: > > All -- > > I have freeradius 0.71 working with the sql module for authentication and > accounting, but I'm having trouble getting the sqlcounter module going. > > I have read all the docs I can find. I have 'sqlcounter dailycounter' > and 'sqlcounter monthlycounter' sections defined in my radiusd.conf > 'modules' section, and they contain directives that are sensible. > > The problem I am having is at execution; radiusd dies because the > 'Max-Daily-Session' attribute referenced in the files module 'users' file > is not defined. I do define it, however, in the modules:sqlcounter > section. But I have no evidence that the sqlcounter module is being > called at runtime; radiusd -X makes no mention of it. > > The rlm_sqlcounter module is being compiled but I am not sure it's being > referenced at execution. (I did stuff like ./configure > --with-rlm_sqlcounter, without really knowing if it was a good idea, but > it seemed enthusiastic enough about compiling it.) Add dailycounter and monthlycounter in the instantiate section of your radiusd.conf > > Anyway, I'm real tired and this may all come to me in the morning, but any > advice would be appreciated. > > Regards, > Dave > > = > David C. Troy [[EMAIL PROTECTED]] 410-384-2500 Sales > ToadNet - Want to go fast?410-544-1329 FAX > 570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Enabling rlm_sqlcounter
All -- I have freeradius 0.71 working with the sql module for authentication and accounting, but I'm having trouble getting the sqlcounter module going. I have read all the docs I can find. I have 'sqlcounter dailycounter' and 'sqlcounter monthlycounter' sections defined in my radiusd.conf 'modules' section, and they contain directives that are sensible. The problem I am having is at execution; radiusd dies because the 'Max-Daily-Session' attribute referenced in the files module 'users' file is not defined. I do define it, however, in the modules:sqlcounter section. But I have no evidence that the sqlcounter module is being called at runtime; radiusd -X makes no mention of it. The rlm_sqlcounter module is being compiled but I am not sure it's being referenced at execution. (I did stuff like ./configure --with-rlm_sqlcounter, without really knowing if it was a good idea, but it seemed enthusiastic enough about compiling it.) Anyway, I'm real tired and this may all come to me in the morning, but any advice would be appreciated. Regards, Dave = David C. Troy [[EMAIL PROTECTED]] 410-384-2500 Sales ToadNet - Want to go fast?410-544-1329 FAX 570 Ritchie Highway, Severna Park, MD 21146-2925 www.toad.net - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter accessing an external database ...
Hi everybody,
I've been using sqlcounter with mysql for a while without a problem
(thanks to developers).
Now, I want to use it with an external database/table, I mean to check
the quota time from another personal table. As I undertand, it should
work by only specifying a new sql module, and pointing the sqlcounter's
sqlmod-inst into it.
However when try to do that, it does not work, the rlm_sqcounter steps
seem ok (cf. the part of log below in debug mod), but I do not find any
corresponding mysql query.
So, is it possible to do that ? If yes, what might be wrong in my config ?
Thanks in advance,
-- part of my config --
#
# Configuration for the SQL module.
#
sql sql_simrad {
# Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
rlm_sql_iodbc, rlm_sql_oracle
driver = "rlm_sql_mysql"
# Connect info
server = "ntp"
login = "myuser"
password = "mypassword"
# Database table configuration
radius_db = "simrad"
...
}
...
#
# sql counter configuration ...
sqlcounter sqlcounter_monthly_simrad {
counter-name = SQL-Monthly-Session-Time
check-name = SQL-Max-Monthly-Session-Time
sqlmod-inst = sql_simrad
key = User-Name
query = "SELECT SUM(SessionTime) FROM simacct WHERE
UserName='%{%k}'"
reset = monthly
}
-- here is the output of the radius server --
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(SessionTime) FROM simacct WHERE
UserName='%{User-Name}''
radius_xlat: 'SELECT SUM(SessionTime) FROM simacct WHERE
UserName='do-risika''
sqlcounter_expand: '%{sql_simrad:SELECT SUM(SessionTime) FROM simacct
WHERE UserName='do-risika'}'
radius_xlat: ''
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user do-risika, check_item=108000, counter=0
rlm_sqlcounter: Sent Reply-Item for user do-risika,
Type=Session-Timeout, value=108000
modcall[authorize]: module "sqlcounter_monthly_simrad" returns ok
@+
--
DouRiX \\\|///
___ \\ - - // ___ __
| _ oOOo_@ @_oOOo| _ \(_) \/ /
| | | |/ _(_) | | | |_| ) |\ /
| |_| | (_) | |_| | _ <| |/ \
|/ \___/ \_O| \_\_/_/\_\
f u cn rd ths u r usng unx
O ) /
( )(_/
\ (
\_)
[Stupid questions are better than
stupid mistakes. --Japanese proverb]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter and authentication
Hi Folks,
I'm trying to get rlm_sqlcounter working. I copied the the contents of the
rlm_sqlcounter readme file into my radiusd.conf in the modules section.
I also added in the dictionary file:
ATTRIBUTE Max-Daily-Session 504 date
One note, when I change date to integer it breaks the rlm_sql module for
authentication.
But when I try to authenticate I get the following output when trying when
radiusd is started with the -xx
rlm_counter: Entering module authorize code
rlm_counter: Could not find Check item pair
modcall{authorize]: module "dailycounter" returns noop
I have a Max-Daily-Session attribute in my radcheck table.
I'm not sure what I'm doing wrong. Can anybody point me in the right
direction?
I can post further information if required.
Thanks,
Sheldon
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter problem
"Atanu Das" <[EMAIL PROTECTED]> wrote: > radiusd.conf[926] Failed to link to module 'rlm_sqlcounter': file not > found It's a shared library issue. See the FAQ, and the top of 'radiusd.conf'. You've put the SSL libraries in a place where the dynamic linker can't find them. The ONLY fix is to follow the directions in the FAQ. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: rlm_sqlcounter : file not found
I have the same errors with the bad interpreter errors. It was because of the file locations in the configure file being wrong. The confiure process went fine. When I tried to do the make it failed. The error I recieved was: make: /usr/src/redhat/BUILD/freeradius-0.6/libtool: Command not found So I moved the entire freeradius-0.6 directory to /usr/src/redhat/BUILD Once I did that it worked fine. Hope this helps. Incidentally, I'm not able to get the rlm_sqlcounter module to work right. I think I am missing something in my database (using MySQL). For some reason when I try to use it my authentication doesn't work. When radiusd is started with the -xx option I get a Pair not matched error on the screen. Anyone know what I am missing? Thanks, Sheldon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Josephine Sent: Monday, August 12, 2002 6:48 AM To: [EMAIL PROTECTED] Subject: Re: rlm_sqlcounter : file not found Hi Atanu, This is Josephine. I get my rlm_sqlcounter installed. Let me tell you how to do it. Run "./configure --with-experimental-modules" in where the freeradius's folder had been unzip, then "make", finally "make install". Done. Josephine. - Original Message - Dear All I am also getting the same message as Josephine. I followed Sheldon Fougere's process but i could not compile it. I even tried to reinstall freeraius and went through the whole steps. But i could not make rlm_sqlcounter to work. Atanu Das - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter : file not found
Hi Atanu, This is Josephine. I get my rlm_sqlcounter installed. Let me tell you how to do it. Run "./configure --with-experimental-modules" in where the freeradius's folder had been unzip, then "make", finally "make install". Done. Josephine. - Original Message - Dear All I am also getting the same message as Josephine. I followed Sheldon Fougere's process but i could not compile it. I even tried to reinstall freeraius and went through the whole steps. But i could not make rlm_sqlcounter to work. Atanu Das - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter problem
Hello Everybody,
I am trying to use rlm_sqlcounter instead of the db counter
in my free radius configuration. But whenever I try to run the "radiusd" in
debug mode i get the following error message:
radiusd.conf[926] Failed to link to module 'rlm_sqlcounter':
file not found
The complete debugging information is included below with
the radiusd.conf file and the users file.
THE DEBUGGING INFORMATION
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /etc/raddb/proxy.conf
Config: including file: /etc/raddb/clients.conf
Config: including file: /etc/raddb/snmp.conf
Config: including file: /etc/raddb/sql.conf
main: prefix = "/usr/local"
main: localstatedir = "/var"
main: logdir = "/var/log"
main: libdir = "/usr/local/lib"
main: radacctdir = "/var/log/radacct"
main: hostname_lookups = no
read_config_files: reading dictionary
read_config_files: reading clients
read_config_files: reading realms
read_config_files: reading naslist
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/var/run/radiusd/radiusd.pid"
main: user = "(null)"
main: group = "(null)"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
security: max_attributes = 200
security: reject_delay = 1
main: debug_level = 0
read_config_files: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded preprocess
preprocess: huntgroups = "/etc/raddb/huntgroups"
preprocess: hints = "/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
realm: format = "suffix"
realm: delimiter = "@"
Module: Instantiated realm (suffix)
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "bishimail.acusign.com"
sql: port = ""
sql: login = "root"
sql: password = ""
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = no
sql: sqltracefile = "/var/log/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM
radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM
radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id"
sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id"
sql: authorize_group_reply_query = "SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id"
sql: authenticate_query = "SELECT Value,Attribute FROM radcheck WHERE
UserName = '%{User-Name}' AND ( Attribute = 'User-Password' OR Attribute =
'Password' OR Attribute = 'Crypt-Password' ) ORDER BY Attribute DESC"
sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S',
AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime),
AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = %{Acct-Delay-Time}
WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}'
AND AcctStartTime <= '%S'"
sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress =
'%{Framed-IP-Address}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND
Re: rlm_sqlcounter : file not found
Aaron Weiker wrote : >Josephine, >If you get errors during make, first identify where the error ocurred. >If you were able to compile without any problems before doing "configure >--with-experimental-modules" but afterwards you cannot run "make" >without it quitting in an error it may be due to a module. So what you >will need to do is look at the output from "make" to identify where the >error occured. If the error occured in the ./src/modules/ directory then >it is a module that couldn't compile. If you feel that this is a module >that you do not need there is no harm in deleting the module directory >and then re-running "configure --with-experimental-modules" then try >running "make" again to see if it got all of the way. >Aaron Weiker Hi Aaron, Thank you very much. I get my rlm_sqlcounter installed. Josephine. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter : file not found
Dear All I am also getting the same message as Josephine. I followed Sheldon Fougere's process but i could not compile it. I even tried to reinstall freeraius and went through the whole steps. But i could not make rlm_sqlcounter to work. Atanu Das System Development SS NetCom Pvt Ltd. Dhankheti Shillong-793003 Visit us at: www.neline.com - Original Message - From: "Josephine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 12, 2002 8:12 AM Subject: RE: rlm_sqlcounter : file not found > > Hi Sheldon, > > Thank you for your reply. I have tried to do ./configure in the source > directory, but failed. The error message was > 'bash : ./configure: bad interpreter: Permission denied'. Do you know what's > went wrong? Is it because of no configure executable file in the folder. > Please advise. > Thank you. > > Josephine. > > > -Original Message- > Sheldon Fougere wrote : > Hi, > > I installed 0.6 using an RPM that I built using the spec file that came with > 0.6. I tried using the rlm_sqlcounter module. It said it couldn't find > rlm_sqlcounter. I looked in the /user/lib directory but it wasn't there. I > then went to the rlm_sqlcounter source directory and did the ./configure, > make, make install. > > When I tried to start radiusd, it was then able to find it. > > Hope this helps. > Sheldon > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: rlm_sqlcounter : file not found
Hi Sheldon, Thank you for your reply. I have tried to do ./configure in the source directory, but failed. The error message was 'bash : ./configure: bad interpreter: Permission denied'. Do you know what's went wrong? Is it because of no configure executable file in the folder. Please advise. Thank you. Josephine. -Original Message- Sheldon Fougere wrote : Hi, I installed 0.6 using an RPM that I built using the spec file that came with 0.6. I tried using the rlm_sqlcounter module. It said it couldn't find rlm_sqlcounter. I looked in the /user/lib directory but it wasn't there. I then went to the rlm_sqlcounter source directory and did the ./configure, make, make install. When I tried to start radiusd, it was then able to find it. Hope this helps. Sheldon - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: rlm_sqlcounter : file not found
Hi, I installed 0.6 using an RPM that I built using the spec file that came with 0.6. I tried using the rlm_sqlcounter module. It said it couldn't find rlm_sqlcounter. I looked in the /user/lib directory but it wasn't there. I then went to the rlm_sqlcounter source directory and did the ./configure, make, make install. When I tried to start radiusd, it was then able to find it. Hope this helps. Sheldon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Aaron Weiker Sent: Friday, August 09, 2002 9:27 AM To: [EMAIL PROTECTED] Subject: Re: rlm_sqlcounter : file not found Josephine wrote: >Aaron Weiker wrote : > > >>>Before compile pass --with-experimental-modules to the configure script. >>>This should compile it in. You may get other modules that fail to >>>compile, what I had to do was just remove their directory and then run >>>configure again. >>> >>> > > > >Hi Aaron, >I can't get what you mean 'remove their directory and then run >configure'. Which directory you are referring ? > > >Josephine. > Josephine, If you get errors during make, first identify where the error ocurred. If you were able to compile without any problems before doing "configure --with-experimental-modules" but afterwards you cannot run "make" without it quitting in an error it may be due to a module. So what you will need to do is look at the output from "make" to identify where the error occured. If the error occured in the ./src/modules/ directory then it is a module that couldn't compile. If you feel that this is a module that you do not need there is no harm in deleting the module directory and then re-running "configure --with-experimental-modules" then try running "make" again to see if it got all of the way. Aaron Weiker > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter : file not found
Josephine wrote: >Aaron Weiker wrote : > > >>>Before compile pass --with-experimental-modules to the configure script. >>>This should compile it in. You may get other modules that fail to >>>compile, what I had to do was just remove their directory and then run >>>configure again. >>> >>> > > > >Hi Aaron, >I can't get what you mean 'remove their directory and then run >configure'. Which directory you are referring ? > > >Josephine. > Josephine, If you get errors during make, first identify where the error ocurred. If you were able to compile without any problems before doing "configure --with-experimental-modules" but afterwards you cannot run "make" without it quitting in an error it may be due to a module. So what you will need to do is look at the output from "make" to identify where the error occured. If the error occured in the ./src/modules/ directory then it is a module that couldn't compile. If you feel that this is a module that you do not need there is no harm in deleting the module directory and then re-running "configure --with-experimental-modules" then try running "make" again to see if it got all of the way. Aaron Weiker > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: rlm_sqlcounter : file not found
Aaron Weiker wrote : >>Before compile pass --with-experimental-modules to the configure script. >>This should compile it in. You may get other modules that fail to >>compile, what I had to do was just remove their directory and then run >>configure again. Hi Aaron, I can't get what you mean 'remove their directory and then run configure'. Which directory you are referring ? Please advise. Thanks in advance. Josephine. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter
[EMAIL PROTECTED] wrote: > It doesn't work without it either. I think it will be some kind of Oracle > specific bug. Especially as the Simultaneous-Use check does not work with > Oracle in 0.7 either. Upgrade to the latest CVS snapshot. There were a few bug fixes in the Oracle module. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter
Hello,
It doesn't work without it either. I think it will be some kind of Oracle
specific bug. Especially as the Simultaneous-Use check does not work with
Oracle in 0.7 either.
Felician
- Original Message -
From: "Randy Moore" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 17:14
Subject: Re: rlm_sqlcounter
> At 03:18 PM 7/29/2002 +0200, you wrote:
> >Hello,
> >
> >I'd like to use rlm_sqlcounter with freeradius 0.7 (using oracle
backend),
> >but it does not work. I have the following config:
> >
> > sqlcounter totalcounter {
> > counter-name = Total-Session-Time
> > check-name = Total-Time-Limit
> > sqlmod-inst = sql
> > key = User-Name
> > reset = never
> > query = "SELECT SUM(AcctSessionTime) a FROM
acct_internet
> >WHERE UserName='%{%k}'"
> > }
>
> Hi, I'd guess you need to remove the extra 'a' in your query just before
> "FROM acct_internet".
>
> Randy Moore
> Axion Information Technologies, Inc.
>
> email [EMAIL PROTECTED]
> phone 301-408-1200
> fax301-445-3947
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter
At 03:18 PM 7/29/2002 +0200, you wrote:
>Hello,
>
>I'd like to use rlm_sqlcounter with freeradius 0.7 (using oracle backend),
>but it does not work. I have the following config:
>
> sqlcounter totalcounter {
> counter-name = Total-Session-Time
> check-name = Total-Time-Limit
> sqlmod-inst = sql
> key = User-Name
> reset = never
> query = "SELECT SUM(AcctSessionTime) a FROM acct_internet
>WHERE UserName='%{%k}'"
> }
Hi, I'd guess you need to remove the extra 'a' in your query just before
"FROM acct_internet".
Randy Moore
Axion Information Technologies, Inc.
email [EMAIL PROTECTED]
phone 301-408-1200
fax301-445-3947
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter
Hello,
I'd like to use rlm_sqlcounter with freeradius 0.7 (using oracle backend),
but it does not work. I have the following config:
sqlcounter totalcounter {
counter-name = Total-Session-Time
check-name = Total-Time-Limit
sqlmod-inst = sql
key = User-Name
reset = never
query = "SELECT SUM(AcctSessionTime) a FROM acct_internet
WHERE UserName='%{%k}'"
}
When i try to authenticate the user with Total-Time-Limit check attribute:
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='%{User-Name}''
radius_xlat: 'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]''
sqlcounter_expand: '%{sql:SELECT SUM(AcctSessionTime) a FROM acct_internet
WHERE UserName='[EMAIL PROTECTED]'}'
radius_xlat: Runing registered xlat function of module sql for string
'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]''
rlm_sql: - sql_xlat
radius_xlat: 'SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]''
rlm_sql: Reserving sql socket id: 4
rlm_sql: - sql_xlat finished
rlm_sql: Released sql socket id: 4
radius_xlat:
'h???ÀÙÑ*p???p???ÐÙÑ*ÐÙÑ*ØÙÑ*ØÙÑ*àÙÑ*àÙÑ*èÙÑ*èÙÑ*ðÙÑ*ðÙÑ*øÙÑ*øÙÑ*'
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user [EMAIL PROTECTED], check_item=216000,
counter=0
rlm_sqlcounter: Sent Reply-Item for user [EMAIL PROTECTED],
Type=Session-Timeout, value=216000
modcall[authorize]: module "totalcounter" returns ok
I think variable "counter" should be equal to the result of sql query. But
counter = 0, and FreeRADIUS does not apply the correct Session-Timeout to
the user.
SQL> SELECT SUM(AcctSessionTime) a FROM acct_internet WHERE
UserName='[EMAIL PROTECTED]';
A
--
44318
Thank You,
Felician Hoppal
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_counter crash was: rlm_sqlcounter monthly time limits for groups
"al" <[EMAIL PROTECTED]> wrote: > this happened after a couple hours of operation, > I am not willing to try and duplicate the problem, unless you can guide me > through setting up a second server and 'duplicating' > the requests to it. ... > first errors at > Mon May 6 11:13:33 2002 : Error: WARNING: Unresponsive child (id 4101) for > request 988 I'd guess you're using Exec-Program-Wait, on a platform other than Linux. I'm currently trying to fix a problem where Exec-Program-Wait locks a thread, when run on platforms other than Linux. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter monthly time limits for groups
> I'm not sure if you can define your check item in the users file because
> there is an initialization order problem. Your new check item attribute
> will not be defined before your users file is parsed resulting in an
> error. If anyone knows a work around here, please let me know.
My workaround for this, as silly as it sounds, looks like this:
authorize {
preprocess
realmat
monthlycounter
files
monthlycounter
}
And an appropriate "users" file entry would be:
DEFAULTGroup == "limited", Max-Monthly-Session := 216000
Fall-Through = 1
Which is more than a little different from the docs included with the
sqlcounter module. Although this works exactly the way I'd expect it to, am
_I_ the one doing this wrong?
Chris Kalin
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter monthly time limits for groups
Hi Al,
There is a README.txt file in the src/modules/rlm_sqlcounter that contains
a more complete example of what to put in your radiusd.conf file.
You don't need to put anything in the authenticate block. To activate it,
just add an instance of the rlm_sqlcounter module to your authorize block
*after* the section that sets up the appropriate check item (like
Max-Daily-Session).
I'm not sure if you can define your check item in the users file because
there is an initialization order problem. Your new check item attribute
will not be defined before your users file is parsed resulting in an
error. If anyone knows a work around here, please let me know.
I store my check items in the SQL servers 'radgroupcheck' table.
INSERT INTO radgroupcheck VALUES (6, 'xcqw', 'Max-Monthly-Session',
'648000', ':=');
This, of course, requires that each account be linked to a group ('xcqw' in
this case) using the usergroup table.
I hope this helps.
At 08:48 PM 5/6/2002 -0500, you wrote:
>setup:
>freeradius post .5 (cvs from May 6 2002)
>using sql in accounting (and loving it)
>
>rlm_sqlcounter
>I have gotten the latest cvs in hopes to use rlm_sqlcounter, (as rlm_counter
>crashes on me, something about threads)
>
>
>I am not seeing any 'clear' instructions on usage.
>
>i have put the config from experimental.conf in my radius.conf. so module
>should be loaded,
>how do you 'activate' the features of the module.
>
>not sure what to put under auth
>
>and how to use it in users file, (specifially for groups)
>
>any help would be appreciated. example would be greatly appreciated
>
>Al
>
>
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Randy Moore
Axion Information Technologies, Inc.
email [EMAIL PROTECTED]
phone 301-408-1200
fax301-445-3947
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sqlcounter monthly time limits for groups
On Mon, 6 May 2002, al wrote: > > > setup: > freeradius post .5 (cvs from May 6 2002) > using sql in accounting (and loving it) > > rlm_sqlcounter > I have gotten the latest cvs in hopes to use rlm_sqlcounter, (as rlm_counter > crashes on me, something about threads) Could you provide more info on the crashes? Does it core dump? If yes could you do a backtrace on it? -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 10 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sqlcounter monthly time limits for groups
setup: freeradius post .5 (cvs from May 6 2002) using sql in accounting (and loving it) rlm_sqlcounter I have gotten the latest cvs in hopes to use rlm_sqlcounter, (as rlm_counter crashes on me, something about threads) I am not seeing any 'clear' instructions on usage. i have put the config from experimental.conf in my radius.conf. so module should be loaded, how do you 'activate' the features of the module. not sure what to put under auth and how to use it in users file, (specifially for groups) any help would be appreciated. example would be greatly appreciated Al - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
New module: rlm_sqlcounter - SQL based Counters
Hi, I've been working on a SQL based version of the Counter module. This makes use of the excellent new sql_xlat function added by Kostas Kalevras (thank you, thank you!). I think this may address some of the questions I've seen on the list about using SQL and Counters together. I would really appreciate it if those of you who know the code base well could take a look and see if I've done anything unsafe. The majority of the code comes from the original counter module. I also pulled in some code from the xlat.c file. Very little is actually new (look for the sqlcounter_expand function and the places where it is called). The module uses the accounting data maintained by the SQL module in the 'radacct' table to track total session time, rather than maintaining a separate database for each Counter instance. This module does NOT do any processing of Accounting packets. That is left completely to the SQL module. This should be considered alpha code, but it seems to work in my development environment. I haven't tried it in production yet. You can download a patch file that adds the new module here: http://www.axion-it.net/download/rlm_sqlcounter.patch This patch was built on the 20020415 snapshot. There is a README.txt file in the new src/modules/rlm_sqlcounter directory with some notes on using the module. I don't know if I setup the structure of the module completely right. There were a couple of files in the rlm_counter directory that I don't know if I really need in 'rlm_sqlcounter' (esp. acconfig.h and config.h.in). But it does compile happily on my RedHat 7.1 system. I wrote and tested this using a MySql server. To convert from a unix time integer to the database datetime values, I used the FROM_UNIXTIME() function. I'm not sure if this is portable or if other SQL servers have equivalent functions. If not, I may need to rework the way the SQL query gets translated. One thing I don't really understand is the 'counter_cmp' function. I made what I think is the equivalent 'sqlcounter_cmp' function, but I can't see how this function would ever get called, so I haven't been able to test it. Is this function really necessary? How is it used? Please let me know if you have any comments or concerns. Thanks. Randy Moore Axion Information Technologies, Inc. email [EMAIL PROTECTED] phone 301-408-1200 fax301-445-3947 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
