icradius/freeradius/TotalTimeLimit/counter ...

2002-01-11 Thread Do-Risika RAFIEFERANTSIARONJY
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

mysql/op ...

2002-01-16 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: mysql/op ...

2002-01-17 Thread Do-Risika RAFIEFERANTSIARONJY
[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

dialup_admin - fatal error ...

2002-01-21 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: dialup_admin - fatal error ...

2002-01-21 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: dialup_admin - fatal error ...

2002-01-21 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: dialup_admin - fatal error resolved ...

2002-01-21 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: counter's value ...

2002-02-03 Thread Do-Risika RAFIEFERANTSIARONJY
[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

Re: Is their a way to check for a suspended account?

2002-02-12 Thread Do-Risika RAFIEFERANTSIARONJY
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

Can't connect to SNMP agent with SMUX: Connection refused ...

2002-02-14 Thread Do-Risika RAFIEFERANTSIARONJY
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

multiple Exec-Program ...

2002-03-11 Thread Do-Risika RAFIEFERANTSIARONJY
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

radius.log and counter files owners when created ...

2002-03-14 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: radius.log and counter files owners when created ...

2002-03-14 Thread Do-Risika RAFIEFERANTSIARONJY
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

freeradius restart ...

2002-03-18 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: compatibility with icradius

2002-03-19 Thread Do-Risika RAFIEFERANTSIARONJY
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

multiple same records ...

2002-03-28 Thread Do-Risika RAFIEFERANTSIARONJY
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

rlm_counter mysql ...

2002-04-04 Thread Do-Risika RAFIEFERANTSIARONJY
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).

Error: Error receiving packet: Connection refused ...

2002-04-20 Thread Do-Risika RAFIEFERANTSIARONJY
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

Failed to link to module 'rlm_pap': file not foun ...

2002-04-29 Thread Do-Risika RAFIEFERANTSIARONJY
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

tables replication ...

2002-04-29 Thread Do-Risika RAFIEFERANTSIARONJY
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

Error: rlm_sql_getvpdata: database query error ...

2002-05-07 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: problem encounter when configure auto-failover for mysql

2002-05-16 Thread Do-Risika RAFIEFERANTSIARONJY
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

sqlcounter problem ...

2002-05-30 Thread Do-Risika RAFIEFERANTSIARONJY
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

rlm_sqlcounter accessing an external database ...

2002-09-04 Thread Do-Risika RAFIEFERANTSIARONJY
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,

Re: sqlcounter question

2002-09-04 Thread Do-Risika RAFIEFERANTSIARONJY
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

counter_monthly: Failed to open file ... Resource temporarily unavailable...

2002-09-09 Thread Do-Risika RAFIEFERANTSIARONJY
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

rlm_sql: All sockets are being used! Assertion failed in radiusd.c,line 2463 ...

2002-10-04 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: rlm_sql: All sockets are being used! Assertion failed in radiusd.c,line 2463 ...

2002-10-07 Thread Do-Risika RAFIEFERANTSIARONJY
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

sql_iodbc.c:214: conflicting types for `sql_fetch_row' ...

2002-10-08 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: about accounting_stop_query ...

2002-10-18 Thread Do-Risika RAFIEFERANTSIARONJY
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

about accounting_stop_query ...

2002-10-17 Thread Do-Risika RAFIEFERANTSIARONJY
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 =

running a script on acct stop ...

2003-01-21 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: Trying to do accounting on freeradius+mysql

2003-01-21 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: Run external script after disconnect.

2003-01-29 Thread Do-Risika RAFIEFERANTSIARONJY
== 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

/usr/bin/ld: cannot find -lperl ...

2003-02-04 Thread Do-Risika RAFIEFERANTSIARONJY
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 ?

Re: /usr/bin/ld: cannot find -lperl ...

2003-02-05 Thread Do-Risika RAFIEFERANTSIARONJY
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

Re: Snapshot error

2003-02-06 Thread Do-Risika RAFIEFERANTSIARONJY
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