Re: (RADIATOR) SNMP Counter logging
Hi Leigh and Mike, Mike McCauley schrieb: Hi Leigh, ... 5. I have forwarded your message to a chap who I know has some _excellent_ SNMP monitoring-mysql software with a web interface. Its about 3000 times better than MRTG, highly configurable, with beautiful graphs, but I dont know if its on offer to anyone. You may hear from him. it would be nice to tell the list what you get as answer from this guy because I'm also loooking in the moment for such a program. Regards Charly -- Karl Gaissmaier Computing Center,University of Ulm,Germany Email:[EMAIL PROTECTED] Network Administration Tel/Fax: ++49 731 50 22499/22471 pgp-key available: http://www.uni-ulm.de/urz/Netzwerk/uuca/keylist.html === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) SNMP Counter logging
On Tue, Jul 06, 1999 at 09:38:10AM +0200, Karl Gaissmaier wrote: Hi Leigh and Mike, Mike McCauley schrieb: ... 5. I have forwarded your message to a chap who I know has some _excellent_ SNMP monitoring-mysql software with a web interface. Its about 3000 times better than MRTG, highly configurable, with beautiful graphs, but I dont know if its on offer to anyone. You may hear from him. it would be nice to tell the list what you get as answer from this guy because I'm also loooking in the moment for such a program. aolme too!/aol [EMAIL PROTECTED] === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) log start/stop time in ACCOUNTING table
Hello Authur, The Timestamp attribute is set in each accounting request, with the time of the session start or stop, so you could add a TIME_STAMP integer column, and add this to your config: AcctColumnDef TIME_STAMP,Timestamp,integer Hope that helps. Cheers. On Jul 6, 4:05pm, Authur Lin wrote: Subject: (RADIATOR) log start/stop time in ACCOUNTING table [ Attachment (text/plain): 594 bytes Character set: big5 plain text ] -- End of excerpt from Authur Lin Hello, I want to log the start/stop time for each session in ACCOUNTING table. Please tell me how to do it ? (I use MySQL as SQL server) AuthBy SQL ... AcctColumnDef NASIPADDRESS,NAS-IP-Address AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef NASPORTTYPE,NAS-Port-Type AcctColumnDef USERNAME,User-Name AcctColumnDef CALLEDSTATIONID,Called-Station-Id ... Authur -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) catch DBI/DBD result code
Hi, is there any way to catch the DBI/DBD result code from an AcctSQLStatement? We use Mysql for accounting and i'd like to have a table with traffic-values that are updated with every stop-record. It's no problem for Radiator to feed multiple tables when it receives one stop-record; i'm just using one AuthBy SQL containing two AcctSQLStatements in my radius.cfg: the first for inserting a normal accounting-record into my indexed detail-table, the second to update monthly traffic-values in my traffic-table. But, to get rid of duplicates, i'm searching for a way to execute the second AcctSQLStatement ONLY if the first statement succeeded. My detail-table has an index, so that duplicates can't be inserted. Whenever Radiator receives a duplicate, there's an error in the logfile saying that the record couldn't be inserted because of the index. Thus Radiator internally catches the result of the query and produces this errormessage. It would be very nice to have something like an IF-clause or Handler where i can define that an AcctSQLStatement depends on the result-code radiator got back from the DBI/DBD-interface. Maybe it's possible to do this with a PostAuthHook when i have a variable containing the result-code from the database. Any ideas? Thanks, Thomas Voss NetCologne GmbH === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) PreAuthHook: add_attr - can't call add_attr() on unblessed reference
I'm trying to add a
name-value pair to a request just before authentication occurs. The
documentation of radiator has an example:
Realm
PreAuthHook sub {
$_[0]-add_attr('test-attr', 'test-value'); }
AuthBy LDAP
...
AuthBy
/Realm
Without the PreAuthHook,
everything is working fine, but when I run a test with this statement, the
logfile says:
ERR: Error in PreAuthHook(): Can't call
method add_attr on unblessed reference at (eval 190) line
1.
I tried to put PreAuthHook on different
places, but no luck. I also tried code like
PreAuthHook sub
{ my($p); \
bless($p); \
$_[0]-add_attr('test-attr', 'test-value'); }
but then the logfile says it cannot reach
class through Handler.pm. I tried use Radius::AttrVal on
top of Handler.pm but that didn't work either.
Can anyone tell me what it is I'm missing
(besides this running) ?
-
Wilbert
Re: (RADIATOR) Radiator as a NT Service
Hello;
Well I made some minor adjustments following the reply below (one of the
things I did was copy the folder "Radius" from c:\radiator\ to c:\perl\lib
c:\perl\site\lib - after I did that executing the command line that's in
the register from the prompt "c:\" worked). The Service starts OK , but now
there's another problem. When I run the command line c:\
c:\perl\bin\perl.exe c:\radiator\radiusd -config_file c:\radiator\maxnt.cfg
and test Radiator with c:\radiator perl radpwtst -s localhost -user
username -password password - Radiator works perfect. But when I start
Radiator as a system service ( NET START RADIATOR ) and do the same test,
this is what happens:
C:\RadiatorPERL RADPWTST -s localhost -user username -password password
sending Access-Request...
Rejected
sending Accounting-Request Start...
OK
sending Accounting-Request Stop...
OK
#
Bellow is my config file:
Foreground
LogStdout
Trace 5
AuthPort 1645
AcctPort 1646
LogDirC:\radiator\malbanet\log
LogFile %D\%Y%m%d.log
DbDir C:\radiator
DictionaryFile %D\dictionary.nt
# You will probably want to change this to suit your site.
Client localhost
Secret mysecret
DupInterval 0
/Client
Client XXX.YYY.ZZZ.xxx
Secret mysecret
DupInterval 0
/Client
Client XXX.YYY.ZZZ.xxx
Secret mysecret
DupInterval 0
/Client
Client XXX.YYY.ZZZ.xxx
Secret mysecret
DupInterval 0
/Client
Realm DEFAULT
# Limit all users in this realm to max of 1 session
MaxSessions 1
AuthBy NT
Identifier NTSystem
# Domain MYDOMAIN.COM.BR
# DomainController HOSTNAME
# DefaultReply Service-Type=Framed-User,Framed-Protocol=PPP
/AuthBy
# Log all accounting into daily log files in LogDir
AcctLogFileName %L\%Y%m%d.act
# Accounting log file format - only the following items are logged
# AcctLogFileFormat %{User-Name}, %{Acct-Status-Type}, %{Acct-Session-Time},
%{Timestamp},
/Realm
#
#
Bellow is the log entrance where the error appears, looks like radiator
can't find the network path:
Tue Jul 6 15:07:20 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Tue Jul 6 15:07:20 1999: DEBUG: Handling with NT
Tue Jul 6 15:07:24 1999: INFO: Access rejected for mike: NT CheckPassword
failed: 53: The network path was not found.
#
Any help is thankful
Best Regards
Michael Gatti
Malbanet Servicos Online
Caxias do Sul - RS - Brazil
-Original Message-
From: Mike McCauley [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Monday, July 05, 1999 21:53
Subject: Re: (RADIATOR) Radiator as a NT Service
Hello Michael.
Before Radiator can be run as a service, you should test that the command
line
entered into the registry will run Radiator properly. You should test this
by
changing to, say the root directory, then issuing the complete command line
and
seeing if it works, eg:
c:
cd \
c:\perl\bin\perl.exe c:\radiator\radiusd -config_file whatever .
ONly if Radiator starts and runs properly like that, can you expect it to
run
as a service.
Looking at your config file, I suspect that these lines will cause you
problems:
DbDir
DictionaryFile dictionary.nt
Since an NT service has no concept of a current drive or current directory,
I
suspect that Radiator cannot find the dictionary file with that
configuration.
You should probably have something like:
DbDir c:\radiator
DictionaryFile %D\dictionary.nt
Hope that helps.
Cheers.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
=
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) Radiator as a NT Service
Hello;Well I made some minor adjustments following the reply below
(one of thethings I did was copy the folder Radius from
c:\radiator\ to c:\perl\lib c:\perl\site\lib - after I did that
executing the command line that's inthe register from the prompt
c:\ worked). The Service starts OK , but nowthere's another
problem. When I run the command line c:\c:\perl\bin\perl.exe
c:\radiator\radiusd -config_file c:\radiator\maxnt.cfgand test Radiator with
c:\radiator perl radpwtst -s localhost -userusername -password password
- Radiator works perfect. But when I startRadiator as a system service ( NET
START RADIATOR ) and do the same test,this is what
happens:C:\RadiatorPERL RADPWTST -s localhost -user username
-password passwordsending Access-Request...Rejectedsending
Accounting-Request Start...OKsending Accounting-Request
Stop...OK#Bellow is my
config
file:ForegroundLogStdoutTrace
5AuthPort
1645AcctPort
1646LogDir
C:\radiator\malbanet\logLogFile
%D\%Y%m%d.logDbDir
C:\radiatorDictionaryFile %D\dictionary.nt# You will probably
want to change this to suit your site.Client
localhostSecret mysecretDupInterval
0/ClientClient
XXX.YYY.ZZZ.xxxSecret mysecretDupInterval
0/ClientClient
XXX.YYY.ZZZ.xxxSecret mysecretDupInterval
0/ClientClient
XXX.YYY.ZZZ.xxxSecret mysecretDupInterval
0/ClientRealm DEFAULT# Limit all users
in this realm to max of 1 sessionMaxSessions
1AuthBy NTIdentifier NTSystem# Domain
MYDOMAIN.COM.BR# DomainController HOSTNAME# DefaultReply
Service-Type=Framed-User,Framed-Protocol=PPP/AuthBy# Log all
accounting into daily log files in LogDirAcctLogFileName
%L\%Y%m%d.act# Accounting log file format - only the following items
are logged# AcctLogFileFormat %{User-Name}, %{Acct-Status-Type},
%{Acct-Session-Time},%{Timestamp},/Realm##Bellow
is the log entrance where the error appears, looks like radiatorcan't find
the network path:Tue Jul 6 15:07:20 1999: DEBUG: Handling request
with Handler'Realm=DEFAULT'Tue Jul 6 15:07:20 1999: DEBUG:
Handling with NTTue Jul 6 15:07:24 1999: INFO: Access rejected for
mike: NT CheckPasswordfailed: 53: The network path was not
found.#Any help is
thankfulBest RegardsMichael GattiMalbanet Servicos
OnlineCaxias do Sul - RS - Brazil|-Original
Message-|From: Mike McCauley [EMAIL PROTECTED]|To: [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED]|[EMAIL PROTECTED]|Date:
Monday, July 05, 1999 21:53|Subject: Re: (RADIATOR) Radiator as a NT
Service|||Hello Michael.|||Before Radiator can be run as
a service, you should test that the commandl|ine|entered into the
registry will run Radiator properly. You should test this|by|changing
to, say the root directory, then issuing the complete command
line|and|seeing if it works, eg:||c:|cd
\|c:\perl\bin\perl.exe c:\radiator\radiusd -config_file whatever
.||ONly if Radiator starts and runs properly like that, can you
expect it to|run|as a service.||Looking at your config file, I
suspect that these lines will cause
you|problems:||DbDir|DictionaryFile
dictionary.nt||Since an NT service has no concept of a current drive or
current directory,|I|suspect that Radiator cannot find the dictionary
file with that|configuration.|You should probably have something
like:||DbDir
c:\radiator|DictionaryFile %D\dictionary.nt||Hope that
helps.||Cheers.||--|Mike
McCauley
[EMAIL PROTECTED]|Open System
Consultants Pty.
Ltd Unix,
Perl, Motif, C++, WWW|24 Bateman St Hampton, VIC 3188 Australia
http://www.open.com.au|Phone +61 3
9598-0985
Fax +61 3 9598-0955||Radiator: the most portable, flexible
and configurable RADIUS server|anywhere. SQL, proxy, DBM, files, LDAP, NIS+,
password, NT, Emerald,|Platypus, Freeside, TACACS+, PAM, external, etc etc
on Unix, Win95/8,|NT, Rhapsody|=|Archive at http://www.thesite.com.au/~radiator/|To
unsubscribe, email '[EMAIL PROTECTED]'
with|'unsubscribe radiator' in the body of the
message.
Re: (RADIATOR) PreAuthHook: add_attr - can't call add_attr() on unblessed reference
Hello Wilbert,
On Jul 6, 8:59pm, Wilbert de Graaf wrote:
Subject: (RADIATOR) PreAuthHook: add_attr - can't call add_attr() on unbl
I'm trying to add a name-value pair to a request just before authentication
occurs. The documentation of radiator has an example:
Realm
PreAuthHook sub { $_[0]-add_attr('test-attr', 'test-value'); }
AuthBy LDAP
...
AuthBy
/Realm
Without the PreAuthHook, everything is working fine, but when I run a test
with this statement, the logfile says:
ERR: Error in PreAuthHook(): Can't call method "add_attr" on unblessed
reference at (eval 190) line 1.
The problem is that contrary to the documentation, you need to access $_[0]
like this:
PreAuthHook sub { ${$_[0]}-add_attr('test-attr', 'test-value'); }
Apologies, the doc is fixed for the next release.
Cheers.
I tried to put PreAuthHook on different places, but no luck. I also tried
code like
PreAuthHook sub { my($p); \
bless($p); \
$_[0]-add_attr('test-attr', 'test-value'); }
but then the logfile says it cannot reach class through "Handler.pm". I tried
"use Radius::AttrVal" on top of "Handler.pm" but that didn't work either.
Can anyone tell me what it is I'm missing (besides this running) ?
- Wilbert
[ Attachment (text/x-html): 3147 bytes
Character set: iso-8859-1
Encoded with "quoted-printable" ]
-- End of excerpt from Wilbert de Graaf
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
