Andy De Petter wrote:
Hey Hugh,
After doing some more debugging, it seems that all db operations exit
successfully. I don't have any clue whatsoever, on why Radiator gives
me a no reply, even though he did his db operations properly.. ;-/
-Andy
It goes like this:
Accounting-
to do with the DBI/DBD-Oracle versions
and/or installation?
You might want to try turning on some debug in DBI/DBD-Oracle and also
try executing the queries by hand to see if there are any problems.
regards
Hugh
On Monday, Oct 13, 2003, at 22:00 Australia/Melbourne, Andy De Petter
wrote:
'%{Acct-Session-Id}', \
%{Timestamp}, \
'%{Framed-IP-Address}', \
'%{NAS-Port-Type}', \
'%{Service-Type}', \
'%{Calling-St
the default table "SUBSCRIBERS" to
other table in my config file? Thank you very much for your help.
Best Regards,
Angus Yiu
You can use 2 AuthBy clauses, in combination with an AuthPolicy
ContinueWhileAccept, if I'm not mistaking.
-Andy
--
Andy De Petter - Expert IT Analyst
er, or
will it immediately send an Access-Reject?
Thanks!
-Andy
--
Andy De Petter - Expert IT Analyst - [EMAIL PROTECTED]
Belgacom ANS/EIS/ISA - Carlistraat 2 - 1140 Brussels (Belgium)
Head office: Koning Albert II Laan 27 - 1030 Brussels (Belgium)
Tel +32 (0)2 7061170 - Fax +32 (0)2 7061150 -
Andy De Petter - Expert IT Analyst - [EMAIL PROTECTED]
Belgacom ANS/EIS/ISA - Carlistraat 2 - 1140 Brussels (Belgium)
Head office: Koning Albert II Laan 27 - 1030 Brussels (Belgium)
Tel +32 (0)2 7061170 - Fax +32 (0)2 7061150 - ICQ #1548957
*** DISCLAIMER ***
This e-mail and any attach
om
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Andy De Petter - http://www.techos.be/andy - [EMAIL
>>===
>>Archive at http://www.open.com.au/archives/radiator/
>>Announcements on [EMAIL PROTECTED]
>>To unsubscribe, email '[EMAIL PROTECTED]' with
>>'unsubscribe radiator' in the body of the message.
>
>
>
> ===
> Archive at http://ww
>
>On Wed, 3 Jul 2002 14:51, Andy De Petter wrote:
>
>
>>Does anyone know, whether it's possible in any way, to add your own
>>column definitions *and* values, like a AcctColumnDef, for accounting
>>tickets? You can define a column, and its corresponding rad
Does anyone know, whether it's possible in any way, to add your own
column definitions *and* values, like a AcctColumnDef, for accounting
tickets? You can define a column, and its corresponding radius
attribute to add, but I would like the value to be fixed.
Something like:
AcctColumnD
Hi Philip,
Wouldn't it be a better idea, to check the maximum session time, and
make a crontab on your server, that cleans (read: removes) all
connections in your online table, that have been there for longer than
your max session time? That way, you don't have to clear your entire
online i
AFAIK, Radiator isn't capable of creating those tables by itself. If
you don't prefer running cronjobs for that, you could create a small
script, that creates the tables, for a specific timeframe upfront (like
for a year or so)?
a
wilco heinneman wrote:
> Hi Hugh,
>
> How could I create th
It's only copy/paste, and restarting your radiusd. ;-)
-a
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Rami Yaseen
> Sent: woensdag 12 juni 2002 14:03
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: (RADIATOR) Redback SMS and N
Hi Barry,
Obviously, you could also use:
RewriteFunction sub { my ($a) = shift; $a =~ tr/A-Z/a-z/; $a =~
s/^([^@]+).*/$1/; $a; }
Cheers,
-Andy
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Barry Andersson
> Sent: donderdag 18 april 2002 3:4
TECTED]]
> Sent: dinsdag 16 april 2002 20:00
> To: Andy De Petter
> Cc: [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) Mysql table format for accounting
>
>
> Doesn't MyIsam table format locking all table during the insert? For
> accounting this is reccomandable?
>
&g
Yes. :P
-a
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri
> Sent: dinsdag 16 april 2002 18:32
> To: Andy De Petter
> Cc: [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) Mysql table format for accounting
>
>
MyISAM works fine for us (~700 accounting records/sec during peak)
-Andy
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri
> Sent: dinsdag 16 april 2002 14:50
> To: [EMAIL PROTECTED]
> Subject: (RADIATOR) Mysql table format for accounti
. I
must say, that the IP address for NAS is not in my Clients file, so I'm
actually wondering where that IP address comes from, and why I'm getting
these errors for a NAS that shouldn't even be replied to.
Thanks,
-Andy
--
Andy De Petter - http://www.techos.be/andy - [EMAIL PR
Hello guys,
Anyone heard of an issue with RedBack sending back malformed vendor
specific attributes with length 6? I've been having this problem for
months now, and still no solution found for it. It's not bothering
functionality of Radiator itself, but it's just filling up log files,
with war
ushed into,
even though they didn't provide a realm themselves?
that's probably why the realm is empty in my log, because it will only the
realm that the user provided?
cheers,
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of
=~ s/[\000]//g;
$a =~ s/^([^@]+).*/$1/; $a =~ s/[^A-Za-z0-9\.\-_\@]//g; $a; }
Any ideas?
-Andy
> -Original Message-
> From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
> Sent: vrijdag 13 juli 2001 9:23
> To: Andy De Petter; Radiator Mailing
> Subject: Re: (RADIATOR) variable
Hello guys,
Is there a variable that can be used, to log the realm, that the user went
through, in an AuthLog SuccessFormat ?
Thanks,
-Andy
--
*** DISCLAIMER ***
This e-mail and any attachments thereto may contain information, which
is confidential and/or protected by intellectual property ri
Jesús M Díaz wrote:
> Hi all,
>
> I know that subject has been already discussed, but i have not clear
> ideas about it, yet.
>
> I run two Radiator Servers over two hosts. They both use a sql db
> (MySql), and I have a backup of that database, but ... if Radiator is
> up but MySql is down, how
/2000, NT, MacOS X.
>>-
>>Nets: internetwork inventory and management - graphical, extensible,
>>flexible with hardware, software, platform and database independence.
>>===
>>Archive at http://www.open.com.au/archives/radiator/
>>Announcements on [EMAIL PROTEC
Hello,
I don't know if anyone has ever tried this before, but I'm testing out a
hardware monitoring tool, that can check ICMP/TCP/UDP protocols.
Now, the problem I'm having here, is that I can't add this device in the
client list of Radiator, because it doesn't support any "secret" (it
just
Hi,
I have a question, concerning the BindAddress to multiple interfaces, on
the same machine. When I don't bind Radiator to a specific interface,
it listens (by default) on -all- interfaces.
Now, when I have RADIUS requests coming in from NAS, on a virtual
interface, Radiator will always r
How can I find out, which attribute is giving this error? Even in trace 5
debug output, I don't get the name (or ID) of the attribute that is
generating this error..
-Andy
*** DISCLAIMER ***
This e-mail and any attachments thereto may contain information, which
is confidential and/or protecte
Hello,
As I have a verity of access servers, I was wondering how it would be
possible to link 2 attributes to eachother.
For example, from some access servers, I get the attribute "Framed-IP", and
from other ones, I get "Framed-IP-Address", to get the client's IP address.
Now, I know that it's
removing UNIQUE indeces,
from the accounting table.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Andy De Petter
> Sent: vrijdag 4 mei 2001 18:30
> To: Radiator Mailing
> Subject: (RADIATOR) Radiator 2.18.x
>
>
>
> Hello,
>
Hello,
After upgrading to Radiator 2.18.1, I noticed that on my radius server, I
have more than 2500 TIME_WAIT connections to my MySQL back-end database. I
didn't have this problem before (2.17.x), so I was wondering whether
something changed, with socket management, or anything else, starting
> > Vendor 1397446990 (attribute 69)
> Here you have a clear error of some sort, since, as of yesterday (May 2,
> 2001), te highest vendor number assigned was 9427... as Hugh says, a
> Trace 4 will probably help to find out what's going on, if that doesn't
> do, I guess Mike will ask you for a Tra
Hello,
Is there someone, who has managed to get a grab on following attribute
numbers, as an addition to the existing dictionaries provided with Radiator?
I'm looking for the following ones:
Vendor 429 (attribute 39051)
Vendor 1397446990 (attribute 69)
I'ld also like to know, whether there is
Hello,
I have "AcctFailedLogFileName" configured, in my radius accounting daemon,
but whenever there is a SQL Timeout detected between the SQL server, and the
radius server, radiusd doesn't seem to be saving the failed query in the
AcctFailedLogFileName file...
When there are errors, like dupli
Is there a variable, that contains the plaintext (decrypted) CHAP-Password,
for authentication packets? I want to log the username and cleartext
password, for all users that are authenticating.. also the ones, with
CHAP-Password..
thx,
-a
--
"For nothing can seem foul to those that win."
Hello,
I have something like:
SuccessFormat %l:%n:%P:%a:PASS:%N:%c
as my logformat ...
Now, in this case, I'm only logging cleartext passwords, for users, who are
not connecting via CHAP (User-Password). Is there a way to do some kind of
"if" statement, in the log format tool, so I
works okay on
2.17.1).
-Andy
--
Andy De Petter _,'|_.-''``-...___..--';
Skynet Operations /, \'. _..-' , ,--...--'''
< \ .`--''' ` /|
Tel +
e authentication one..
-Andy
> -Original Message-
> From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 18 april 2001 1:45
> To: Andy De Petter; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) performance issue
>
>
>
> Hello Andy -
&g
>
> Your problem sounds familiar to us because at the beginning, we launched
> tests of 1000 authentication requests and the 40% were dropped.
>
Were those 40% authentication or accounting?
I'm running accounting & authentication on different daemons.. and the
session db is configured on the ac
Hello,
I'm having a bit of a problem with the session database, on Radiator 2.17.1.
I have 2 radius servers running, sharing a remote SQL database for all
active sessions. The authentication of clients, also happens through remote
SQL databases, on different machines than the session db.
Now,
Hello,
It seems that the BindAddress attribute, for SNMPAgent isn't working
properly on my site. I'm running Radiator 2.17.1, and I have this in my
configuration file, for my authentication radiator server:
Community public
BindAddress 192.168.1.97
Port
Hello,
I was wondering whether it's possible to do some kind of conditional
logging, with the AcctLogFileName. For example, would it be possible to
say, that radiator should only log the accounting line (defined in
AcctLogFileFormat), if Acct-Status-Type (or any other attribute) has a
specific
My bad..
thx :)
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Hugh Irvine
> Sent: woensdag 28 maart 2001 8:17
> To: Andy De Petter; Radiator Mailing
> Subject: RE: IMPORTANT - Re: (RADIATOR) dictionary question
>
>
y all of
them..
Thanks anyway for the information Hugh,
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Hugh Irvine
> Sent: vrijdag 1 januari 1904 10:02
> To: Andy De Petter; Radiator Mailing
> Subject: IMPORTANT - Re: (RADIAT
Hi guys,
I was just wondering, whether someone knows, whether you can have some kinds
of "aliases", in your dictionary? For example, if you'ld want to support:
ATTRIBUTE attname1999 ipaddr
BUT you'ld also want another attribute, to point to the same one:
ATTRIBUTE
art 2001 17:20
> To: 'Andy De Petter'; Brian Morris
> Cc: Radiator Mailing
> Subject: RE: (RADIATOR) PPPOE Authentication / Accounting
>
>
> Redback
>
> Matthew C. Karl
> Florida State University
> Office of Telecommunications, MIS
>
> -Original Mes
DANA, from Alcatel (http://www.alcatel.com), or REDBACK 1
(http://www.redback.com)?
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Brian Morris
> Sent: woensdag 21 maart 2001 11:58
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re:
Use your own salt? (see crypt() documentation, in a perl manual)
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mike McCauley
> Sent: woensdag 21 maart 2001 13:30
> To: [EMAIL PROTECTED]
> Subject: (RADIATOR) Changing Password by users while A
Owh, and are your database server, and radius server, on the same
LAN/switch?
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Andy De Petter
> Sent: dinsdag 20 maart 2001 15:23
> To: [EMAIL PROTECTED]
> Cc: Radiator Mai
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of [EMAIL PROTECTED]
> Sent: dinsdag 20 maart 2001 13:43
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: (RADIATOR) Performance with RADIATOR
>
>
> We try to do some MySQL tunning with next vari
to search on, raise the amount of maximum
concurrent connections, increase the table cache, increase the wait timeout,
increase the max connect errors, increase the key buffers, skip name
resolving, etc
Please refer to the MySQL documentation, to fine-tune your server.
-Andy
--
Andy De Pet
I'm using Diablo 2.5-REL as my newsreader
(http://www.openusenet.org/diablo), and authentication through an existing
radius server, is trivial there (don't know how to do it with inn 2.3
though). You just need to create a radius.conf file, put the IP of your
radius server, and the secret in it,
I use this:
RewriteUsername s/^([A-Za-z0-9\.\-_&]+).*/$1/
have phun :)
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Hugh Irvine
> Sent: donderdag 1 februari 2001 21:44
> To: Paul Black; [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) The Death
heavily decrease radius
performance..
Don't know what you think of the issue?
-a
> -Original Message-
> From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
> Sent: maandag 29 januari 2001 9:11
> To: Andy De Petter; Radiator Mailing
> Cc: [EMAIL PROTECTED]
> Subject: Re:
AFAIK, by restarting radiator processes..
-a
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Janet N del Mundo
> Sent: maandag 29 januari 2001 7:00
> To: Hugh Irvine
> Cc: [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) high availabilty accounting
>
nd of
attributes?
TIA,
-Andy
--
..
::
: Andy De Petter <[EMAIL PROTECTED]> :
:Skynet NV/SA
-Andy
--
..
::
: Andy De Petter <[EMAIL PROTECTED]> :
:Skynet NV/SASystem Engineer :
::
: Kol. Bour
Hello,
I'm using "AcctFailedLogFileName %L/failed.accounting" as an alternative, if
the accounting db isn't up, but I'ld like to see a cleaner solution too,
like having an alternate database, for accounting..
Is there a way of doing this?
Regards,
-Andy
> -Original Message-
> From: [
Hmm.. what about this:
Identifier SQLAcct
DBSource dbi:mysql::machine1
DBUsername
DBAuth
DBSource dbi:mysql::machine2
DBUsername
DBAuth
...
I think that should work..
-a
one...
-Andy
--
..
::
: Andy De Petter <[EMAIL PROTECTED]> :
:Skynet NV/SASystem Engineer :
::
:
Hello,
I'm performing a RewriteUsername in my Realm, just before doing the AuthBy:
RewriteUsername s/^([A-Za-z0-9\.\-_&]+).*/$1/
This will cause Radiator to rewrite a username like this:
When it finds a character it doesn't expect in the username, it will stop
there, and not process any chara
gt; Sent: Friday, November 24, 2000 1:07 PM
> To: Andy De Petter; Radiator Mailing
> Subject: RE: (RADIATOR) SessionDatabase SQL problem
>
>
> minimum one of the field is marked unique on the table RADONLINE.
> check the table indexes!!!
>
> I do not use unique index on my RA
ke accounting records with no access request
> prior to them
> arriving.
>
Any way of preventing this to happen??
-Andy
--
......
::
:
n your AddQuery, and not by
changing it in the source of the package...
Just my 0.02 cents ,-)
-Andy
> -Original Message-
> From: Hugh Irvine [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 24, 2000 12:25 AM
> To: Andy De Petter; Carlos Canau
> Cc: Radiator Ma
I've been around that problem, by changing the source of the Radiator
package:
REPLACE INTO instead of INSERT INTO, concerning the sessiondatabase ...
Don't know how you could get around that problem on a more "decent" way...
changing the "AddQuery" in the config, doesn't change much .. the ins
2.17.1 should fix it .. I reported the problem yesterday, and there is
already a patch/updated version today ...
Pretty good service :)
-Andy
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Deepak Shrestha
> Sent: Wednesday, November 22, 2000 6:3
s a patch available for this problem?
Thanks a million,
-Andy
--
..
: :
: Andy De Petter <[EMAIL PROTECTED]> :
:Skynet NV/SASystem Engineer :
:
66 matches
Mail list logo