Re: Snapshot error
Alexey Chetroi wrote: On Thu, Feb 06, 2003 at 01:10:20AM -0500, Gene Parks wrote: Subject: Snapshot error From: "Gene Parks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 6 Feb 2003 01:10:20 -0500 Thought you guys should know that the new snapshot is producing this error after install. 2003-02-06 00:41:52.418187500 Starting - reading configuration files ... 2003-02-06 00:41:52.437049500 ?[0]: Unknown variable "datadir" 2003-02-06 00:41:53.526664500 Starting - reading configuration files ... 2003-02-06 00:41:53.543306500 ?[0]: Unknown variable "datadir" 2003-02-06 00:41:54.638002500 Starting - reading configuration files ... 2003-02-06 00:41:54.655309500 ?[0]: Unknown variable "datadir" 2003-02-06 00:41:55.748170500 Starting - reading configuration files ... 2003-02-06 00:41:55.764256500 ?[0]: Unknown variable "datadir" 2003-02-06 00:41:56.857507500 Starting - reading configuration files ... 2003-02-06 00:41:56.873177500 ?[0]: Unknown variable "datadir" radiusd.conf from the snapshots is a bit different from those 0.8.1. I've compiled a snapshot from cvs yesterday and it complains about the same error and after that dumps core, so I had modify radiusd.conf from CVS tree. you should add something like : datadir = ${prefix}/share 'hope this help, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: /usr/bin/ld: cannot find -lperl ...
B J wrote: On _ 2003-02-04 at 17:10, Do-Risika RAFIEFERANTSIARONJY wrote: Though, libperl seems to be present : indri:/etc/raddb# locate libperl /usr/doc/libperl5.6 /usr/lib/libperl.so.5.6 /usr/lib/libperl.so.5.6.1 Do you know what's wrong in my config ? Try adding a link with name libperl.so wich points to libperl.so.5.6.1 in /usr/lib/ now it works, thanks much, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
/usr/bin/ld: cannot find -lperl ...
Hi all, When compiling freeradius with rlm_perl, i have this error message "/usr/bin/ld: cannot find -lperl", Though, libperl seems to be present : indri:/etc/raddb# locate libperl /usr/doc/libperl5.6 /usr/lib/libperl.so.5.6 /usr/lib/libperl.so.5.6.1 Do you know what's wrong in my config ? ... /usr/lib/perl/5.6.1/CORE/proto.h:89: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:510: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:514: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:525: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:624: warning: declaration of `exp' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:812: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:812: warning: declaration of `version' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:932: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:933: warning: declaration of `floor' shadows global declaration /usr/lib/perl/5.6.1/CORE/proto.h:934: warning: declaration of `floor' shadows global declaration rlm_perl.c: In function `xs_init': rlm_perl.c:156: warning: passing arg 1 of `Perl_newXS' discards qualifiers from pointer target type rlm_perl.c:156: warning: passing arg 3 of `Perl_newXS' discards qualifiers from pointer target type rlm_perl.c: In function `XS_radiusd_radlog': rlm_perl.c:168: warning: unused variable `items' rlm_perl.c: In function `perl_instantiate': rlm_perl.c:299: warning: passing arg 1 of `Perl_newXS' discards qualifiers from pointer target type rlm_perl.c:299: warning: passing arg 3 of `Perl_newXS' discards qualifiers from pointer target type rlm_perl.c: At top level: rlm_perl.c:477: warning: `perl_checksimul' defined but not used gcc -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE -g -Wshadow -Wpointer-arith -Wcast-qual -Wcast-align -Wwrite-strings -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wnested-externs -I../../include -DDEBIAN -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/lib/perl/5.6.1/CORE -c rlm_perl.c -o rlm_perl.o >/dev/null 2>&1 mv -f .libs/rlm_perl.lo rlm_perl.lo /usr/bin/libtool --mode=link gcc -release 0.9-pre \ -module -export-dynamic -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE -g -Wshadow -Wpointer-arith -Wcast-qual -Wcast-align -Wwrite-strings -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wnested-externs -I../../include `perl -MExtUtils::Embed -e ccopts` \ -o rlm_perl.la -rpath /usr/lib/freeradius rlm_perl.lo `perl -MExtUtils::Embed -e ldopts` -lnsl -lresolv -lpthread *** Warning: Linking the shared library rlm_perl.la against the *** static library /usr/lib/perl/5.6.1/auto/DynaLoader/DynaLoader.a is not portable! rm -fr .libs/rlm_perl.la .libs/rlm_perl.* .libs/rlm_perl-0.9-pre.* gcc -shared rlm_perl.lo -L/usr/local/lib /usr/lib/perl/5.6.1/auto/DynaLoader/DynaLoader.a -L/usr/lib/perl/5.6.1/CORE -lperl -ldl -lm -lc -lcrypt -lnsl -lresolv -lpthread -Wl,-soname -Wl,rlm_perl-0.9-pre.so -o .libs/rlm_perl-0.9-pre.so /usr/bin/ld: cannot find -lperl collect2: ld returned 1 exit status make[7]: *** [rlm_perl.la] Error 1 make[7]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203/src/modules/rlm_perl' make[6]: *** [common] Error 1 make[6]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203/src/modules' make[5]: *** [all] Error 2 make[5]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203/src/modules' make[4]: *** [common] Error 1 make[4]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203/src' make[3]: *** [all] Error 2 make[3]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203/src' make[2]: *** [common] Error 1 make[2]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203' make[1]: *** [all] Error 2 make[1]: Leaving directory `/home/dourix/buildpackages/freeradius/freeradius-snapshot-20030203' make: *** [build] Error 2 dourix@indri:~/buildpackages/freeradius/freeradius-snapshot-20030203$ Thanks, -- DouRiX ["Some of us are becoming the men we wanted to marry." -- Gloria Steinem] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Run external script after disconnect.
Vitaliy Karlov wrote: Andrew E. Guly wrote: I use FreeRadius-0.8.1 with Postgres on Linux RH 8.0 for authenticate and accounting dial-in users. My radiusd execute the external script with "Exec-Program-Wait = /some/script" when user is autenticated. No problems, it's worked fine... Q: How I can execute the external script *after* user disconnecting? May be you look at file acct_users ? When your radius server recieve Acct-Stop... some like this: acct_user: == acct_users == DEFAULT Acct-Status-Type == Stop Exec-Program = "/path/to/some/script.pl" == thanks, i've never noticed this *useful feature* before, so i think i'd have to add acct_users in the radius.conf accounting section ? best regards, -- Do-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Trying to do accounting on freeradius+mysql
Iq wrote: I will appreciate any help on how can I get accounting done on the data in mysql (even an sql query will do), for the moment I am using plain text files and getting accounting done by "Optigold ISP" log parser. I want customers to check their usgae using a web base interface. why don't you just take the example in sql.conf ? AcctSessionTime is the duration, AcctInputOctetd and OutputOctets are the transfered data. 'hope this help, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
running a script on acct stop ...
Hi everybody, I'm using freeradius/mysql with a daily & nightly hours based billing, i mean users on off-peak hours are billed partially. To do that, I have a radacct mysql table holding my accounting data, and another customized acct table that i use for billing, then a script periodically imports and calculates the billed duration from new freeradius accounting records. The system is far from being perfect because online data for users are not exactly in real time, as the importation is asynchronyous. So, what I want is to *add a BilledSessionTime column* in the radacct table, and to *set this column when receiving the accounting stop* packet. Unfortunately, I could not formulate it into the sql accounting_stop_query as the calculation is quite complicated. Then I'd like to ask if it would be possible for me to have an *executed external program on each acct stop* (similar as exec-program and exec-program-wait) ? in sql.conf ? or value like '`script %{Acct-Start-Time} %{Acct-Stop-Time} %{Acct-Session-Time}`' in the accounting_stop_query ? Else will I need to pull the code ? another idea ? Any help would be appreciated, Thanks in advance, -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: about accounting_stop_query ...
Chris Parker wrote: At 05:04 PM 10/17/2002 +0400, Do-Risika RAFIEFERANTSIARONJY wrote: Hi everybody, It is just an optimization question, for those who use rlm_sql. I has the query below in my sql.conf : accounting_stop_query = "UPDATE ${acct_table1} SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}', AcctMultiSessionId = '%{Acct-Multi-Session-Id}', AscendDataRate = '%{X-Ascend-Data-Rate}', AscendXmitRate = '%{X-Ascend-Xmit-Rate}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" With our nas (patton boxes), the SessionId values are reinitialized when the box reboot, so I think there is a risk of having the same SessionId, Username and NASIPAddress after each reboot, which would alter the accounting data. This is done by most NAS. This is why the 'acct_unique' module exists. Please read 'radiusd/doc/rlm_acct_unique'. Ok, thanks, So I think it would be better for me to add "AND AcctUniquId = '%{Acct-Unique-Id}'" in the accounting_stop_query sql where clause ? @+ -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) [A day without sun shine is like, you know, night.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
about accounting_stop_query ...
Hi everybody, It is just an optimization question, for those who use rlm_sql. I has the query below in my sql.conf : accounting_stop_query = "UPDATE ${acct_table1} SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}', AcctMultiSessionId = '%{Acct-Multi-Session-Id}', AscendDataRate = '%{X-Ascend-Data-Rate}', AscendXmitRate = '%{X-Ascend-Xmit-Rate}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" With our nas (patton boxes), the SessionId values are reinitialized when the box reboot, so I think there is a risk of having the same SessionId, Username and NASIPAddress after each reboot, which would alter the accounting data. So my questions are : * Don't you think that it's good (especially in my case) to add some conditions in the WHERE clause, for example : FramedIPAddress = '%{Framed-IP-Address}'" AND NASPortId = '%{NAS-Port-Id}'" ? * Does someone have a config like this ? * If I add these conditions, is there a risk of dysfunction or lower performance ? * Is it possible to detect if the accounting_stop_query updates *more than one records*, I think that it is important to detect these problems ... Waiting for your comments, Regards, -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
sql_iodbc.c:214: conflicting types for `sql_fetch_row' ...
Hi all, When building freeradius-0.7.1, I have this error with sql_iodbc, how to resolve this ? Here belows are my configure options : prefix = / exec_prefix = /usr mandir = $(exec_prefix)/share/man libdir = $(exec_prefix)/lib/freeradius logdir = /var/log/radiusd-freeradius pkgdocdir = $(exec_prefix)/share/doc/radiusd-freeradius raddbdir= $(prefix)/etc/raddb ./configure --prefix=$(prefix) --exec-prefix=$(exec_prefix) --libdir=$(libdir) --mandir=$(mandir) --with-logdir=$(logdir) --with-thread-pool --enable-strict-dependencies \ --enable-ltdl-install=yes \ --with-rlm_sqlcounter --without-rlm_python \ --without-rlm_perl \ --without-rlm_eap ... Making static in rlm_sql_iodbc... make[11]: Entering directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules/rlm_sql/drivers/rlm_sql_iodbc' gcc -g -O2 -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -Wall -D_GNU_SOURCE -g -Wshadow -Wpointer-arith -Wcast-qual -Wcast-align -Wwrite-strings -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wnested-externs -I../.. -I../../../../include -I/home/dourix/build-freeradius/freeradius-0.7.1/libltdl -c sql_iodbc.c -o sql_iodbc.o sql_iodbc.c:214: conflicting types for `sql_fetch_row' sql_iodbc.h:31: previous declaration of `sql_fetch_row' make[11]: *** [sql_iodbc.o] Error 1 make[11]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules/rlm_sql/drivers/rlm_sql_iodbc' make[10]: *** [common] Error 1 make[10]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules/rlm_sql/drivers' make[9]: *** [static] Error 2 make[9]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules/rlm_sql/drivers' make[8]: *** [common] Error 1 make[8]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules/rlm_sql' make[7]: *** [static] Error 2 make[7]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules/rlm_sql' make[6]: *** [common] Error 1 make[6]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules' make[5]: *** [all] Error 2 make[5]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src/modules' make[4]: *** [common] Error 1 make[4]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src' make[3]: *** [all] Error 2 make[3]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1/src' make[2]: *** [common] Error 1 make[2]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1' make[1]: *** [all] Error 2 make[1]: Leaving directory `/home/dourix/build-freeradius/freeradius-0.7.1' make: *** [build] Error 2 dourix@indri:~/build-freeradius/freeradius-0.7.1$ Regards, @+ -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) ["But that's what being an artist _is_ -- feeling crummy before everyone else feels crummy." -- The New Yorker] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql: All sockets are being used! Assertion failed in radiusd.c,line 2463 ...
Kostas Kalevras wrote: > On Fri, 4 Oct 2002, Do-Risika RAFIEFERANTSIARONJY wrote: > > >>Hi everybody, >> >>I had my freeradius crashed many times after a libc6 upgrade in the >>server (debian), >> >>Should I actually increase the num_sql_sockets value ? or it is another >>problem ? >> >>Or should I upgrade freeradius because I have a little old version (0.5 >>snapshot 20020514) ? > > > You should really upgrade to the latest snapshot. Ok, Thanks much, Nevertheless, Could someone tell me if it is a prooved bug in the old version or not ? the error message is : "Assertion failed in radiusd.c, line 2463" Regards, -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) ["There is no such thing as justice in the abstract; it is merely a compact between men." -- Epicurus] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sql: All sockets are being used! Assertion failed in radiusd.c,line 2463 ...
Hi everybody, I had my freeradius crashed many times after a libc6 upgrade in the server (debian), Should I actually increase the num_sql_sockets value ? or it is another problem ? Or should I upgrade freeradius because I have a little old version (0.5 snapshot 20020514) ? I had these in radius.log : Fri Oct 4 08:11:57 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:11:57 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:11:58 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:11:59 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:01 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:12:01 2002 : Error: Assertion failed in radiusd.c, line 2463 Fri Oct 4 08:12:01 2002 : Error: MASTER: exit on signal (6) Fri Oct 4 08:12:01 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:13:56 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:13:57 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:13:59 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:13:59 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:13:59 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:00 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:01 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:02 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:02 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:03 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:04 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Fri Oct 4 08:14:05 2002 : Error: Assertion failed in radiusd.c, line 2463 Fri Oct 4 08:14:05 2002 : Error: MASTER: exit on signal (6) Thanks in advance, @+ -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) ["As empty vessels make the loudest sound, so they that have the least wit are the greatest blabbers." -- Plato] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: counter_monthly: Failed to open file ... Resource temporarilyunavailable ...
Kostas Kalevras wrote: > On Mon, 9 Sep 2002, Do-Risika RAFIEFERANTSIARONJY wrote: > > >>hi everybody, >> >>do you know what may produce these errors ? it happened after the log >>rotation, and the server did not start anymore. > > > What version of the server are you using? Early versions of the counter module > performed locking on the gdbm file and that might be the cause of your problem. 0.5, i'll try to upgrade then, > Did you stop/start your server or did you just do a kill -HUP? killall radiusd + start, shouldn't it cancel all the file locks ? @+ -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) [Linux means productivity and fun. NT means 'Not Today'.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
counter_monthly: Failed to open file ... Resource temporarily unavailable...
hi everybody, do you know what may produce these errors ? it happened after the log rotation, and the server did not start anymore. Mon Sep 9 07:16:26 2002 : Error: rlm_counter: Failed to open file /var/log/radiusd-freeradius/counters/counter.monthly: Resource temporarily unavailable Mon Sep 9 07:16:26 2002 : Error: radiusd.conf[247]: counter_monthly: Module instantiation failed. Mon Sep 9 07:17:26 2002 : Error: rlm_counter: Failed to open file /var/log/radiusd-freeradius/counters/counter.monthly: Resource temporarily unavailable Mon Sep 9 07:17:26 2002 : Error: radiusd.conf[247]: counter_monthly: Module instantiation failed. Mon Sep 9 07:18:26 2002 : Error: rlm_counter: Failed to open file /var/log/radiusd-freeradius/counters/counter.monthly: Resource temporarily unavailable Mon Sep 9 07:18:26 2002 : Error: radiusd.conf[247]: counter_monthly: Module instantiation failed. Mon Sep 9 07:19:26 2002 : Error: rlm_counter: Failed to open file /var/log/radiusd-freeradius/counters/counter.monthly: Resource temporarily unavailable Mon Sep 9 07:19:26 2002 : Error: radiusd.conf[247]: counter_monthly: Module instantiation failed. Mon Sep 9 07:20:27 2002 : Error: rlm_counter: Failed to open file /var/log/radiusd-freeradius/counters/counter.monthly: Resource temporarily unavailable Mon Sep 9 07:20:27 2002 : Error: radiusd.conf[247]: counter_monthly: Module instantiation failed. nevertheless, the counter db file is actually there, and is with the right permission, tanalahy:/var/log/radiusd-freeradius# ls -l counters/ total 292 -rw-rw1 freerad freerad 49184 Jun 17 10:03 counter.daily -rw-rw1 freerad freerad 90531 Sep 9 07:31 counter.monthly -rw-rw1 freerad freerad159845 Sep 9 07:31 counter.never tanalahy:/var/log/radiusd-freeradius# regards, @+ -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) [Women who seek to be equal to men lack ambition.] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: sqlcounter question
alienoid wrote: > Hello freeradius-users, hi, > RH7.2 + freeradius-0.6 + Oracle > > I've compiled freeradius with --with-experimantal-modules and set up > it with sql auth/acct. > > In radiusd.conf wrote: > > sqlcounter hourlycounter { >counter-name = SQL_Max_Hour_Session_Timeout >check-name = SQL_Max_Hour >sqlmod_inst = sql >key = User-Name >query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE > username='%{%k}'" >reset = none > } may be 'reset = never', if not, didn't you forget to put hourlycounter in the authorization section ? > I did so (tried to convert) with table radcheck: > test User-Password := > test SQL_Max_Hour 36000 > > test Auth-Type Reject := i think the operator should be ':=' instead of '>' ... cheers, @+ -- DouRiX \\\|/// ___ \\ - - // ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |/ \___/ \_O| \_\_/_/\_\ f u cn rd ths u r usng unx O ) / ( )(_/ \ ( \_) [Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic.] - 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
sqlcounter problem ...
Hi everybody, The sqlcounter module does not work properly when i put the sqlmod-inst in a remote sql, and the authorize sql at the localhost. Indeed, when i have this config, the radius_xlat from rlm_sqlcounter is always returning a null, and i do not see any trace of sql queries in the remote mysql ... However, all the other combinaisons work : sqlmod-inst -> local && authorize sql -> remote, or all in the remote sql. Have someone already known this problem ? or have someone an explanation ? -- a trace of the log on debug (rlm_sqlcounter) -- sqlcounter_expand: 'SELECT SUM(AcctSessionTime - GREATEST((1020200400 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1020200400'' radius_xlat: 'SELECT SUM(AcctSessionTime - GREATEST((1020200400 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='test' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1020200400'' sqlcounter_expand: '%{sql_remote:SELECT SUM(AcctSessionTime - GREATEST((1020200400 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='test' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1020200400'}' radius_xlat: '' rlm_sqlcounter: (Check item - counter) is greater than zero rlm_sqlcounter: Authorized user do-risika, check_item=7200, counter=0 rlm_sqlcounter: Sent Reply-Item for user do-risika, Type=Session-Timeout, value=7200 -- part of my radiusdconf -- ... sqlcounter sqlcounter_monthly { counter-name = SQL-Monthly-Session-Time check-name = SQL-Max-Monthly-Session-Time sqlmod-inst = sql_remote key = User-Name query = "SELECT SUM(AcctSessionTime - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" reset = monthly } } authorize { sql files sqlcounter_monthly } Thanx, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: problem encounter when configure auto-failover for mysql
CheongMeng wrote: > > Hi, > > I am using freeradius-0.5 and mysql 3.23.49. > I tried to setup 2 accounting server for a radius server, ie: > radius server A will always write accounting to mysql server B. > when mysql server B down, radius server A should send accounting to its > local mysql server. i didn't know that failover is possible for accounting ... @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Error: rlm_sql_getvpdata: database query error ...
Hi all, freeradius failed after the log rotation. But when i restarted it manually after, there was any problem. What could have caused it ? Here below the errors : Sat May 4 06:30:51 2002 : Info: Reloading configuration files. Sat May 4 06:30:51 2002 : Info: rlm_sql: Driver rlm_sql_mysql loaded and linked Sat May 4 06:30:51 2002 : Info: rlm_sql: Attempting to connect to radiusd@localhost:/radius Sat May 4 06:30:52 2002 : Info: Ready to process requests. Sat May 4 06:30:52 2002 : Info: Reloading configuration files. Sat May 4 06:30:52 2002 : Info: rlm_sql: Driver rlm_sql_mysql loaded and linked Sat May 4 06:30:52 2002 : Info: rlm_sql: Attempting to connect to radiusd@localhost:/radius Sat May 4 06:30:52 2002 : Info: Ready to process requests. Sat May 4 06:30:52 2002 : Info: Reloading configuration files. Sat May 4 06:30:52 2002 : Error: MYSQL Error: Cannot get result Sat May 4 06:30:52 2002 : Error: MYSQL Error: Lost connection to MySQL server during query Sat May 4 06:30:52 2002 : Error: rlm_sql_getvpdata: database query error Sat May 4 06:30:52 2002 : Error: MYSQL Error: Cannot get result Sat May 4 06:30:52 2002 : Error: MYSQL Error: MySQL server has gone away Sat May 4 06:30:52 2002 : Error: rlm_sql_getvpdata: database query error Sat May 4 06:30:52 2002 : Error: CHILD: exit on signal (11) (END) Thanx in advance, -- Do-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
tables replication ...
Hi all, For those using mysql, how do you replicate your authentication (and eventually your accounting) tables to a backup server ? I'm looking for the best method. Thanks in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Failed to link to module 'rlm_pap': file not foun ...
Hi all, I built the snapshot-20020428 into a debian package with dpkg-buildpackage -rfakeroot, it is ok but when i start radius, it results : Error: radiusd.conf[387] Failed to link to module 'rlm_pap': file not found It seems that rlm_pap is not build in the package, however it did not do that beforehand. Can someone help me ? Regards, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Error: Error receiving packet: Connection refused ...
Hi all, Does anyone have explanations for these errors. They appeared after the system was rebooted after crashing, but they disappear 1 or 2 minutes after ?!? Sat Apr 20 16:44:08 2002 : Auth: Login OK: [so.co.im] (from nas nas3 port 15 cli 202238259) Sat Apr 20 16:44:08 2002 : Error: Error receiving packet: Connection refused Sat Apr 20 16:44:20 2002 : Auth: Login OK: [salama] (from nas nas3 port 14 cli 202242612) Sat Apr 20 16:44:20 2002 : Error: Error receiving packet: Connection refused Thanx, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_counter && mysql ...
Hi all, I remember to have seen an rlm_counter patch, with mysql support, a few months ago. Is someone thinking to include it in the next release one day ? It would be very interesting for me. My purpose is to have a centered counter data, with 2 radius servers (a primary and a backup one). Any idea ? Thanx in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
multiple same records ...
I have some multiple same records in my radacct table, with the same username, sessionid, uniqueid, ... so i has to run a script to check these multiple records. To avoid this, I want to modify the UniqueId column into 'unique index', so freeradius wouldn't be able to add existing record anymore. Would it change the freeradius normal function ? (because it should produce error in mysql) Has anybody already experienced this ? I use freeradius 0.4 with mysql, Thanx in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: compatibility with icradius
Bensalah Mustapha wrote: > > hi > > i'm working in an ISP and we use icradius 0.18 and mysql 3.23.36 under linux > redhat 7.2 for customers authentication, i think that now freeradius is of a > much better use if we carry on using open source, i have installed > freeradius 4.0 this week and configure it to use the mysql DB, but the > "Max-Hours", "total-time-limit" and "Activation" attributes which are used > by icradius are not recognized by freeradius automatically. see the rlm_counter_module with freeradius, @+ -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeradius restart ...
Sometimes, when I restart the server with /etc/init.d/freeradius restart (in a debian box), it stops but does not restart. In the log file, there is anything but "Info: MASTER: exit". Have anybody already had this experience ? I use 0.4-snapshot20020215 with rlm_mysql_module. -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radius.log and counter files owners when created ...
Alan DeKok wrote: > > Do-Risika RAFIEFERANTSIARONJY <[EMAIL PROTECTED]> wrote: > > I reinitialized my freeradius (by deleting all log and counter files), > > and when i started, the radius.log file was created but was owned by > > root, so i had to chown freerad.freerad. Is it normal or not ? > > Hmmm... the server SHOULD open it's files AFTER changing uid/gid. > If it doesn't, it's a bug. i think that it is for radius.log and for counter files. radutmp and detail files are ok ... @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
radius.log and counter files owners when created ...
I run freeradius with : user = freerad group = freerad I reinitialized my freeradius (by deleting all log and counter files), and when i started, the radius.log file was created but was owned by root, so i had to chown freerad.freerad. Is it normal or not ? The same questions for counter files. Thanx, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
multiple Exec-Program ...
Hi all, is it possible to put multiple 'Exec-Program' for one user ? Thanx, -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Simultaneous-Use ...
My checkrad seems to work but not the simultaneous use, i do not find any line concerning it on logs even in debug mode, what may happens to me ? -- my nasslist file-- nas2.simicro.netnas2usrhiper indri:/etc/raddb# /usr/sbin/checkrad usrhiper 208.153.83.3 10338 nathalie 0a020a02 indri:/etc/raddb# -- in users file, for test only, the reply message is to ensure that the check arrives here -- # test ... DEFAULT Simultaneous-Use := 1 Reply-Message += "CouCou ...", Fall-Through = 1 -- a test with radtest, this user was connected at that time (on radwho) -- indri:/etc/raddb# /usr/bin/radtest stephanie xx 192.168.10.98 0 testing123 Sending Access-Request of id 125 to 192.168.10.98:1812 User-Name = "stephanie" User-Password = "\372z\262\025\364\301\216\257\313i\230y\276\227\270" NAS-IP-Address = indri NAS-Port-Id = "0" Sending Access-Request of id 125 to 192.168.10.98 User-Name = "stephanie" User-Password = "\372z\262\025\364\301\216\257\313i\230y\276\227\270" NAS-IP-Address = indri NAS-Port-Id = "0" rad_recv: Access-Accept packet from host 192.168.10.98:1812, id=125, length=65 Service-Type = Framed-User Framed-Protocol = PPP Reply-Message = "Hello stephanie !!!" Reply-Message = "CouCou ..." indri:/etc/raddb# -- logs seen in the debug mode -- rad_recv: Access-Request packet from host 192.168.10.98:1072, id=125, length=58 User-Name = "stephanie" User-Password = "\372z\262\025\364\301\216\257\313i\230y\276\227\270" NAS-IP-Address = 255.255.255.255 NAS-Port-Id = "0" rlm_sql: Reserving sql socket id: 4 rlm_sql: Released sql socket id: 4 rlm_sql: Reserving sql socket id: 4 rlm_sql: Stop packet with zero session length. (user 'stephanie', nas '208.153.83.3') rlm_sql: Released sql socket id: 4 Login OK: [stephanie] (from nas indri port 0) Sending Access-Accept of id 125 to 192.168.10.98:1072 Service-Type = Framed-User Framed-Protocol = PPP Reply-Message = "Hello stephanie !!!" Reply-Message = "CouCou ..." rad_recv: Access-Request packet from host 192.168.10.98:1072, id=125, length=58 Sending duplicate authentication reply to client indri:1072 - ID: 125 Sending Access-Accept of id 125 to 192.168.10.98 snmpget alredy installed ... Did i miss a step ? Thanx, -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Can't connect to SNMP agent with SMUX: Connection refused...
Chris Parker wrote: > > At 01:32 PM 2/14/2002 +0300, Do-Risika RAFIEFERANTSIARONJY wrote: > > >Hi everybody, > > > >Can someone tell me what this error means ? and what should i do to > >avoid this ? > > Reconfigure and compile without SNMP enabled: > > ./configure --without-snmp > make > make install but does it mind if i leave like this ? (because it was installed from a debian package :-) > >Can it cause that my Simultaneous-Use feature does'not work ? > > What does your testing show? First, i don't find any line containing Simultaneous-Use when i run radiusd -sx, as it is adviced in the faq, indri:/etc/raddb# radiusd -sx Starting - reading configuration files ... Module: Loaded SQL rlm_sql: Driver rlm_sql_mysql loaded and linked rlm_sql: Attempting to connect to root@localhost:/radius rlm_sql: Connected new DB handle, #0 rlm_sql: Connected new DB handle, #1 rlm_sql: Connected new DB handle, #2 rlm_sql: Connected new DB handle, #3 rlm_sql: Connected new DB handle, #4 Module: Instantiated sql (sql) Module: Loaded Counter Module: Instantiated counter (daily_counter) Module: Instantiated counter (monthly_counter) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Can't connect to SNMP agent with SMUX: Connection refused Listening on IP address *, ports 1812/udp and 1813/udp. Ready to process requests. After that, when i run manually the checkrad script, with a patton nas (which is supposed to be supported), i have the following error : 'SNMP Error: no response received'. The problem is that i know that there is a password in the nas a password asociated with this snmp community 'monitor', but i don't know where should i do it in the freeradius config. I tried to put it in the naspasswd but it doesn't work, and in the docs, it seems that snmp doesn't need password. indri:/etc/raddb# /usr/sbin/checkrad patton 208.153.83.226 10338 jayme 0a020a02 SNMP Error: no response received SNMPv1_Session (remote host: "208.153.83.226" [208.153.83.226].161) community: "monitor" request ID: -545558884 PDU bufsize: 8000 bytes timeout: 2s retries: 5 backoff: 1) at /usr/sbin/checkrad line 176 checkrad: indri:/etc/raddb# I have another nas which is an usr hiperarc, there was the same problem with this one (no snmp server), but when i put the user/pass in the naspasswd file, the wasn't errors nor returned values, so i ask myself if is it normal or not ? indri:/etc/raddb# /usr/sbin/checkrad usrhiper 208.153.83.3 10338 jayme 0a020a02 indri:/etc/raddb# indri:/etc/raddb# /usr/sbin/checkrad patton 208.153.83.226 10338 jayme 0a020a02 SNMP Error: no response received SNMPv1_Session (remote host: "208.153.83.226" [208.153.83.226].161) community: "monitor" request ID: -545558884 PDU bufsize: 8000 bytes timeout: 2s retries: 5 backoff: 1) at /usr/sbin/checkrad line 176 checkrad: indri:/etc/raddb# That was my testing, what would you advice for me because i really need this feature ? I use mysql on authentication and on accounting ... Any help would be appreciated, @+ -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Can't connect to SNMP agent with SMUX: Connection refused ...
Hi everybody, Can someone tell me what this error means ? and what should i do to avoid this ? Can it cause that my Simultaneous-Use feature does'not work ? Thanx, -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Is their a way to check for a suspended account?
Michael Letchworth wrote: > > I'm trying to figure if their is a field for checking a suspended account? if you try the Expiration attribute ? you just pull it out when you reactivate the account ... @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: counter's value ...
[EMAIL PROTECTED] wrote: > > Do-Risika RAFIEFERANTSIARONJY <[EMAIL PROTECTED]> wrote: > > With rlm_counter, can i have the counter's value on a given moment ? if > > yes, how ? > > Yes. Read the comments for the module in 'radiusd.conf'. OK, What i want to ask is if i have a daily counter time with 'Acct-Session-Time' as count-attribute, 'Daily-Session-Time' as counter-name, how can i check from the counter file (for example ${raddbdir}/daily.counter) the state of the counter for one user (for example a user had xxx seconds connexions during the day), because i noticed that the counter file is not a simple text file, i.e what i need is : 'how much times have been consumed by/remain to a user on a given moment ?' I put below the rlm_counter's comments in the radiusd.conf but i did not find the answer, and here after my example of config : ... # This module takes an attribute (count-attribute), which MUST # be an 'integer' or 'time' attribute. It also takes a key, # and creates a counter for each unique key. The count is # incremented when accounting packets are received by the # server. The value of the increment is the value of the # count-attribute. # # The 'reset' parameter defines when the counters are all reset to # zero. It can be hourly, daily, weekly, or monthly. # # The counter-name is the name of the attribute in the 'users' # file used to access that counter. e.g. # # DEFAULT Daily-Session-Time > 3600, Auth-Type = Reject # Reply-Message = "You've used up more than one hour today" counter daily_counter { filename = ${raddbdir}/daily.counter key = User-Name count-attribute = Acct-Session-Time reset = daily counter-name = Daily-Session-Time check-name = Max-Daily-Session-Time allowed-servicetype = Framed-User cache-size = 5000 } ... I use mysql for authentication/accounting. Thanx in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
counter's value ...
Hi all, With rlm_counter, can i have the counter's value on a given moment ? if yes, how ? Thanx, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Error: rlm_counter: Unknown reset timer "never" ...
Kostas Kalevras wrote: > > On Thu, 24 Jan 2002, Do-Risika RAFIEFERANTSIARONJY wrote: > > > > > Hi all, > > > > I had an answer about two weeks ago that 'reset = never' is posible in a > > counter config, but i'm now testing it and i get this error 'Error: > > rlm_counter: Unknown reset timer "never"'. Can someone tell me what's > > wrong ? > > > > -- error in my radiusd.log -- > > Thu Jan 24 10:25:35 2002 : Error: rlm_counter: Unknown reset timer > > "never" > > Thu Jan 24 10:25:35 2002 : Error: radiusd.conf[598]: endless_counter: > > Module instantiation failed. > > > > I have freeradius 0.4 on a debian box. > Try the latest CVS snapshot. freeradius 0.4 does not know about 'reset=never' Ok, thank you very much for your answer. But my problem is that i have a freeradius (0.4-1) installed from a debian package, so i don't know exactly what should i do to apply these cvs snapshots ... Is somebody here having the same problem as me ? or does anyone have any idea ? Any help would be appreciated, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Error: rlm_counter: Unknown reset timer "never" ...
Hi all, I had an answer about two weeks ago that 'reset = never' is posible in a counter config, but i'm now testing it and i get this error 'Error: rlm_counter: Unknown reset timer "never"'. Can someone tell me what's wrong ? -- error in my radiusd.log -- Thu Jan 24 10:25:35 2002 : Error: rlm_counter: Unknown reset timer "never" Thu Jan 24 10:25:35 2002 : Error: radiusd.conf[598]: endless_counter: Module instantiation failed. I have freeradius 0.4 on a debian box. @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup_admin - fatal error resolved ...
I have finally find the source of my problem, it was my fault. I added a link lib/sql/defaults.php3 -> lib/defaults.php3 so it looped ... Now I just put a void file in lib/sql/defaults.php3. I see that it is interesting but I have some questions or notes if possible : * in tre accounting report, isn't there navigations buttons ? (to see the next or previous records), * is not there something to manage radgroupcheck, radgroupreply and usergroup ? * i noticed that it does not support yet operator in radcheck and radreply tables ? is it planed or not ? Thanx @+ -- DouRiX Do-Risika RAFIEFERANTSIARONJY wrote: > > Kostas Kalevras wrote: > > > > On Mon, 21 Jan 2002, Do-Risika RAFIEFERANTSIARONJY wrote: > > > > > > > > Hi all, > > > > > > As it is referenced as a an interface php for freeradius > > > (http://sourceforge.net/projects/dialup-admin/), I think somebody here > > > use it. > > > > > > I have the fatal error below when I try to edit or create user, so I > > > want to ask if it is a bug or if there is something wrong in my config ? > > > (i'm using mysql in accounting) > > > > > > Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to > > > allocate 11520 bytes) in > > > /usr/local/dialup_admin/lib/defaults.php3 on line 10 > > > > > Are you runing anything else on the machine? From the error message it seems > > that defaults.php3 tried to allocate just 11KB which is quite reasonable. > > I am not sure if the php memory_limit directive applies to a single page or to > > the whole php process. > > I have just freeradius, mysql, apache on a debian box ... > > @+ > -- > DouRiX > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Do-Risika RAFIEFERANTSIARONJY mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup_admin - fatal error ...
Nicola Orru' wrote: > > > > Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to > > > allocate 11520 bytes) in > > > /usr/local/dialup_admin/lib/defaults.php3 on line 10 > > There must be an infinite loop somewhere... Yes, may be because on line 10, it seems that the file defaults.php3 is including itself. So if that is the problem, I think it is a bug, or should I change something in my configuration files ? -- default.php3, line 10 -- if (is_file("../lib/$config[general_lib_type]/defaults.php3")) include("../lib/$config[general_lib_type]/defaults.php3"); (END) Does someone have any idea ? @+ -- ;-DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup_admin - fatal error ...
Kostas Kalevras wrote: > > On Mon, 21 Jan 2002, Do-Risika RAFIEFERANTSIARONJY wrote: > > > > > Hi all, > > > > As it is referenced as a an interface php for freeradius > > (http://sourceforge.net/projects/dialup-admin/), I think somebody here > > use it. > > > > I have the fatal error below when I try to edit or create user, so I > > want to ask if it is a bug or if there is something wrong in my config ? > > (i'm using mysql in accounting) > > > > Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to > > allocate 11520 bytes) in > > /usr/local/dialup_admin/lib/defaults.php3 on line 10 > > > Are you runing anything else on the machine? From the error message it seems > that defaults.php3 tried to allocate just 11KB which is quite reasonable. > I am not sure if the php memory_limit directive applies to a single page or to > the whole php process. I have just freeradius, mysql, apache on a debian box ... @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup_admin - fatal error ...
Hi all, As it is referenced as a an interface php for freeradius (http://sourceforge.net/projects/dialup-admin/), I think somebody here use it. I have the fatal error below when I try to edit or create user, so I want to ask if it is a bug or if there is something wrong in my config ? (i'm using mysql in accounting) Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 11520 bytes) in /usr/local/dialup_admin/lib/defaults.php3 on line 10 Here attached a copy of my admin.conf ... Thanx in advance, @+ -- DouRiX # # it can be el (greek) or default # general_prefered_lang: el general_prefered_lang_name: Greek # general_base_dir: /usr/local/dialup_admin general_radiusd_base_dir: /usr general_domain: tana.simicro.net # general_ldap_attrmap: %{general_radiusd_base_dir}/etc/raddb/ldap.attrmap general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap # # it can be either ldap or sql # general_lib_type: sql general_user_edit_attrs_file: %{general_base_dir}/conf/user_edit.attrs general_sql_attrs_file: %{general_base_dir}/conf/sql.attrs general_default_file: %{general_base_dir}/conf/default.vals general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient # # this information is used from the server check page # #general_test_account_login: test #general_test_account_password: testpass general_test_account_login: test general_test_account_password: xx # # These are used as default values for the user test page # general_radius_server: localhost general_radius_server_port: 1812 # # sorry, single valued for now. Should become something like # password[server-name]: x # general_radius_server_secret: testing123 general_auth_request_file: %{general_base_dir}/conf/auth.request # # can be one of crypt,md5,clear # general_encryption_method: crypt nas1_name: nas1.%{general_domain} nas1_model: Cisco 2511 access server nas1_ip: 147.122.122.121 nas1_port_num: 16 nas1_community: public nas2_name: nas2.%{general_domain} nas2_model: Cisco 2511 access server nas2_ip: 147.122.122.123 nas2_port_num: 16 nas2_community: public nas3_name: nas3.%{general_domain} nas3_model: Cisco 5300 access server nas3_ip: 147.122.122.124 nas3_port_num: 210 nas3_community: public ldap_server: ldap.%{general_domain} ldap_base: dc=company,dc=com ldap_binddn: cn=Directory Manager ldap_bindpw: XXX ldap_default_new_entry_suffix: ou=dialup,ou=guests,%{ldap_base} ldap_default_dn: uid=default-dialup,%{ldap_base} ldap_regular_profile_attr: dialupregularprofile # # can be one of mysql,pg where: # mysq: MySQL database (port 3306) # pg: PostgreSQL database (port 5432) # sql_type: mysql sql_server: localhost sql_port: 3306 sql_username: radiusadmin sql_password: xx sql_database: radius sql_accounting_table: radacct sql_badusers_table: badusers sql_check_table: radcheck sql_reply_table: radreply sql_user_info_table: userinfo # # true or false # sql_use_user_info_table: false sql_password_attribute: Crypt-Password sql_date_format: Y-m-d sql_full_date_format: Y-m-d H:i:s # # Used in the accounting report generator so that we # don't return too many results # sql_row_limit: 40 counter_default_daily: 14400 counter_default_weekly: 72000 counter_default_monthly: none
Re: mysql/op ...
[EMAIL PROTECTED] wrote: > > Do-Risika RAFIEFERANTSIARONJY <[EMAIL PROTECTED]> wrote: > > It's really what I need, but what should happen if some of these > > attributes are not provided by the nas ? (because some of our nas > > provides Ascend-Data-Rate, but the others no ...) > > Then their values will be zero. > > Alan DeKok. Ah, ok, that is well for me ! @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql/op ...
Aleksandr Kuzminsky wrote: > > On Wed, 16 Jan 2002, Do-Risika RAFIEFERANTSIARONJY wrote: > > > * can I add some attributes (already in the dictionary such as DataRate > > or XMitRate) into the radacct table ? I think of modifying the table and > > the accounting queries in the radiusd.conf but I'm not sure it would > > work ... > Yes. I did so. I had a look to the detail files, and added some attributes > to radacct table. Ok, so I added three attributes in my radacct table : AcctMultiSessionId, AscendDataRate and XmitDataRate, and i modified the accounting_stop_query and accounting_stop_query_alt in my sql.conf as that. It's really what I need, but what should happen if some of these attributes are not provided by the nas ? (because some of our nas provides Ascend-Data-Rate, but the others no ...) -- here are my accounting_stop_queries -- accounting_stop_query = "UPDATE ${acct_table1} SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}', AcctMultiSessionId = '%{Acct-Multi-Session-Id}', AscendDataRate = '%{Ascend-Data-Rate}', AscendXmitRate = '%{Ascend-Xmit-Rate}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" accounting_stop_query_alt = "INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay, AcctMultiSessionId, AscendDataRate, AscendXmitRate) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}', '0', '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}', '%{Acct-Multi-Session-Id}', '%{Asce\ nd-Data-Rate}', '%{Ascend-Xmit-Rate}')" @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql/op ...
Hi all, Another questions please : * where would I find the operations to follow to add the 'op' in the mysql tables ? I mean what should I do after mofdifying the tables structures ? * about operators, can someone explain me the difference betwen an '=' and an ':=' ? an ':=' i think is for affectation and '==' for comparison, but '=' ? * can I add some attributes (already in the dictionary such as DataRate or XMitRate) into the radacct table ? I think of modifying the table and the accounting queries in the radiusd.conf but I'm not sure it would work ... Thanx in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AcctUniqueId ...
Hi all, Can someone tell me where does freeradius get the AcctUniqueId in the rlm_mysql/radacct table ? Thanx in advance, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
icradius/freeradius/TotalTimeLimit/counter ...
Hi all, I am about choosing to use icradius or freeradius/mysql on a debian linux box. I want to ask some questions : * is somebody planning to debianize icradius ? or is there already an icradius debian package ? * I saw in the freeradius mailing list archive that Total-Time-Limit and Monthly-Time-Limit of icradius should be implemented in freeradius, is it already done or not ? * If not, with freeradius again, about the counter module, - is it posible to have more than 1 counters in a config file ? - isn't it possible to 'never' reset a counter ('reset = never') ? I think of a mean to have a Totat-Time-Limit, to implement a prepaid system, I hope i did not ask too stupid questions :-) Thanx in advance for your answers, @+ -- DouRiX - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html