(RADIATOR) Report
Hi , Are there any tool which can cooperate with Radmin and Radiator to generate user report (e.g. Top Ten user by duration, Top Ten user by traffic). Regards, Chairath
(RADIATOR) Question about Rodopi?
There is any problem if we will use Radmin, Radiator and Rodopi billing at the same time. Regards, Chairath
Re: (RADIATOR) accept all auth-req
Hi Jules Thanks for your advice. Regards, Chairath [EMAIL PROTECTED] wrote: Hi, you can include a group in your Realm like this: Realm xxx> AuthBy GROUP_Identifier . . /Realm> and your group could be compose of two AuthBy authenticators: AuthBy GROUP> AuthByPolicy ContinueUntilAccept Identifier GROUP_Identifier AuthBy RADMIN_Identifier AuthBy TEST_Identifier /AuthBy GROUP> So in that way I think you first will authenticate via RADMIN, and in case of failure, AuthBy TEST will always accept your authentication requests. Test it and tell me if it works. regards, jules -Mensaje original- De: chairarth [mailto:[EMAIL PROTECTED]] Enviado el: lunes 9 de julio de 2001 10:38 Para: radiator Asunto: (RADIATOR) accept all auth-req Hi, In case of Authen by Radmin , how can I config Radiator to accept all authen-requests whenever the SQL Host down. Regards, Chairath ** Noticia legal Este mensaje electrnico contiene informacin de BT Telecomunicaciones S.A. que es privada y confidencial, siendo para el uso exclusivo de la persona(s) o entidades arriba mencionadas. Si usted no es el destinatario sealado, le informamos que cualquier divulgacin, copia, distribucin o uso de los contenidos est prohibida. Si usted ha recibido este mensaje por error, por favor borre su contenido y comunquenoslo en la direccin [EMAIL PROTECTED] Gracias
(RADIATOR) accept all auth-req
Hi, In case of Authen by Radmin , how can I config Radiator to accept all authen-requests whenever the SQL Host down. Regards, Chairath
(RADIATOR) No such user ?
Hi ,
Today I wonder why I cann't
logon any user on Radmin Database . In log file always show
"No such user"
. I'm very sure
that Radiator and Radmin host can connect to Database host .
Can someone tell me what
's wrong ?
Thanks,
Chairath
-
Log File ---
Mon Jun 25 10:55:48 2001:
DEBUG: Packet dump:
*** Received from 10.2.0.1
port 49152
Code:
Access-Request
Identifier: 20
Authentic: 0>0>e161>0>0>7/0>0>`20>0>0>u178>
Attributes:
User-Name = "david"
User-Password = "186>e128>206>L30>n223>183>174>G209>r13>166>216>"
Acct-Session-Id =
"56000e27"
NAS-IP-Address = 10.10.0.2
Shasta-SGROUP = "Shasta
5000: iSOS (tm), 2.1(17)"
Service-Type = Framed-User
Framed-Protocol =
PPP
Calling-Station-Id
= "ldc_1220069"
NAS-Port = 1644167237
Mon Jun 25 10:55:48 2001:
DEBUG: Handling request with Handler 'Realm=DEFAULT'
Mon Jun 25 10:55:48 2001:
DEBUG: Deleting session for david, 10.10.0.2, 1644167237
Mon Jun 25 10:55:48 2001:
DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='10.10.0.2'
and NASPORT=01644167237
Mon Jun 25 10:55:48 2001:
DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE,
MESSAGE) values (993441348,
4, 'Handling with Radius::AuthRADMIN')
Mon Jun 25 10:55:48 2001:
DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE,
MESSAGE) values (993441348,
4, 'Handling with Radius::AuthRADMIN')
Mon Jun 25 10:55:48 2001:
DEBUG: Query is: select PASS_WORD, STATICADDRESS, TIMELEFT,
MAXLOGINS from RADUSERS
where USERNAME='david' and BADLOGINS 5 and VALIDFROM
993441348 and VALIDTO >
993441348
Mon Jun 25 10:55:48 2001:
DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE,
MESSAGE) values (993441348,
4, 'Radius::AuthRADMIN looks for match with david')
Mon Jun 25 10:55:48 2001:
DEBUG: Query is: select PASS_WORD, STATICADDRESS, TIMELEFT,
MAXLOGINS from RADUSERS
where USERNAME='DEFAULT' and BADLOGINS 5 and VALIDFROM
993441348 and VALIDTO >
993441348
Mon Jun 25 10:55:48 2001:
INFO: Access rejected for david: No such user
Mon Jun 25 10:55:48 2001:
DEBUG: Packet dump:
*** Sending to 10.2.0.1
port 49152
Code:
Access-Reject
Identifier: 20
Authentic: 0>0>e161>0>0>7/0>0>`20>0>0>u178>
Attributes:
Reply-Message = "Request
Denied"
---
Configuration File ---
Foreground
LogStdout
LogDir d:/Radiator-Demo-2.18/log
DbDir d:/Radiator-Demo-2.18
LogFile %L/logfile-%d-%m-%Y
# Dont turn this up too high,
since all log messages are logged
# to the RADMESSAGES table
in the database. 3 will give you everything
# except debugging messages
Trace 4
# You will probably want
to change this to suit your site.
# You should list all the
clients you have, and their secrets
# If you are using the Radmin
Clients table, you wil probably
# want to disable this.
#Client DEFAULT>
# Secret mysecret
# DupInterval 0
#/Client>
# You can put additonal (or
all) client details in your Radmin
# database table
# and get their details
from there with something like this:
# You can then use the Radmin
'Add Radius Client' to add new clients.
ClientListSQL>
DBSource dbi:ODBC:xxx
DBUsername xxx
DBAuth xxx
/ClientListSQL>
#AuthBy RADIUS>
# Identifier ProxyTofunk
# Host xxx
# Secret test
#/AuthBy>
#Realm funk>
# strip Realm
# RewriteUsername s/^([^@]+).*/$1/
# AuthBy ProxyTofunk
#/Realm>
# Handle everyone with RADMIN
Realm DEFAULT>
AuthBy RADMIN>
# Change DBSource,
DBUsername, DBAuth for your database
# See the reference
manual. You will also have to
# change the one
in SessionDatabse SQL> below
# so its the same
DBSource dbi:ODBC:xxx
DBUsername xxx
DBAuth xxx
DateFormat %e %m
%Y %T
# You can add to
or change these if you want, but you
# will probably want
to change the database schema first
AccountingTable RADUSAGE
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type,integer
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef DNIS,Called-Station-Id
AcctColumnDef DATE,Timestamp,integer-date
# This updates the
time and octets left
# for this user
AcctSQLStatement
update RADUSERS set TIMELEFT=TIMELEFT-0%{Acct-Session-Time},
OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets}
where USERNAME='%n'
# These are the classic
things to add to each users
# reply to allow
a PPP dialup session. It may be
# different for your
NAS. This will add some
# reply items to
everyone's
Re: (RADIATOR) No such user ?
Hi Hugh, It's ok when I run query via Query Analyzer. So, I suspect that maybe our Radmin host is expired ( I installed Radmin on 25/5/2001 ). And that's why I cannot login . Am I right? Regards, Chairath Hugh Irvine wrote: Hello Chairarth - What happens when you issue the same query on the Database host? And have you verified the contents of the RADUSERS table? regards Hugh At 1:27 PM +0700 6/25/01, chairarth wrote: Hi , Today I wonder why I cann't logon any user on Radmin Database . In log file always show "No such user" . I'm very sure that Radiator and Radmin host can connect to Database host . Can someone tell me what 's wrong ? Thanks, Chairath - Log File --- Mon Jun 25 10:55:48 2001: DEBUG: Packet dump: *** Received from 10.2.0.1 port 49152 Code: Access-Request Identifier: 20 Authentic: 0>0>e161>0>0>7/0>0>`20>0>0>u178> Attributes: User-Name = "david" User-Password = "186>e128>206>L30>n223>183>174>G209>r13>166>216>" Acct-Session-Id = "56000e27" NAS-IP-Address = 10.10.0.2 Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(17)" Service-Type = Framed-User Framed-Protocol = PPP Calling-Station-Id = "ldc_1220069" NAS-Port = 1644167237 Mon Jun 25 10:55:48 2001: DEBUG: Handling request with Handler 'Realm=DEFAULT' Mon Jun 25 10:55:48 2001: DEBUG: Deleting session for david, 10.10.0.2, 1644167237 Mon Jun 25 10:55:48 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='10.10.0.2' and NASPORT=01644167237 Mon Jun 25 10:55:48 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (993441348, 4, 'Handling with Radius::AuthRADMIN') Mon Jun 25 10:55:48 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (993441348, 4, 'Handling with Radius::AuthRADMIN') Mon Jun 25 10:55:48 2001: DEBUG: Query is: select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS from RADUSERS where USERNAME='david' and BADLOGINS 5 and VALIDFROM 993441348 and VALIDTO > 993441348 Mon Jun 25 10:55:48 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (993441348, 4, 'Radius::AuthRADMIN looks for match with david') Mon Jun 25 10:55:48 2001: DEBUG: Query is: select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS from RADUSERS where USERNAME='DEFAULT' and BADLOGINS 5 and VALIDFROM 993441348 and VALIDTO > 993441348 Mon Jun 25 10:55:48 2001: INFO: Access rejected for david: No such user Mon Jun 25 10:55:48 2001: DEBUG: Packet dump: *** Sending to 10.2.0.1 port 49152 Code: Access-Reject Identifier: 20 Authentic: 0>0>e161>0>0>7/0>0>`20>0>0>u178> Attributes: Reply-Message = "Request Denied" --- Configuration File --- Foreground LogStdout LogDir d:/Radiator-Demo-2.18/log DbDir d:/Radiator-Demo-2.18 LogFile %L/logfile-%d-%m-%Y # Dont turn this up too high, since all log messages are logged # to the RADMESSAGES table in the database. 3 will give you everything # except debugging messages Trace 4 # You will probably want to change this to suit your site. # You should list all the clients you have, and their secrets # If you are using the Radmin Clients table, you wil probably # want to disable this. #Client DEFAULT> # Secret mysecret # DupInterval 0 #/Client> # You can put additonal (or all) client details in your Radmin # database table # and get their details from there with something like this: # You can then use the Radmin 'Add Radius Client' to add new clients. ClientListSQL> DBSource dbi:ODBC:xxx DBUsername xxx DBAuth xxx /ClientListSQL> #AuthBy RADIUS> # Identifier ProxyTofunk # Host xxx # Secret test #/AuthBy> #Realm funk> # strip Realm # RewriteUsername s/^([^@]+).*/$1/ # AuthBy ProxyTofunk #/Realm> # Handle everyone with RADMIN Realm DEFAULT> AuthBy RADMIN> # Change DBSource, DBUsername, DBAuth for your database # See the reference manual. You will also have to # change the one in SessionDatabse SQL> below # so its the same DBSource dbi:ODBC:xxx DBUsername xxx DBAuth xxx DateFormat %e %m %Y %T # You can add to or change these if you want, but you # will probably want to change the database schema first AccountingTable RADUSAGE AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type,integer AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer AcctColumnDef ACCTSESSIONID,Acct-Session-Id AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Add
(RADIATOR) Re: Problem about Time check item
Hi Hugh, I have done following your suggestion and I found that I can control Times of Day which user is allowed to log on. But I 've got a problem about RADUSERS and RADUSAGE Table. In log file you can see that after user test2@qnetadsl log out , Radiator then din't do query update RADUSERS Table ( e.g. TIMELEFT ) and didn't do query insert into RADUSAGE Table also. How can I fix it? Thanks, Chairath Hugh Irvine wrote: Hello Chairarth - You cannot configure Radiator as you have shown below - you will need to use cascaded AuthBy clauses, something like this: # define AuthBy FILE AuthBy FILE>Identifier CheckUsersFilename %D/adsl.users/AuthBy> # define Realms Realm qnetadsl>AuthBy CheckUsers/Realm> Then in the file "adsl.users", something like this: # define DEFAULT users DEFAULT Prefix = S, Time = "SaSu-2359", Auth-Type RADMINAUTH DEFAULT Prefix = P, Time = "Wk2200-", Auth-Type RADMINAUTH hth Hugh At 5:16 PM +0700 6/21/01, chairarth wrote: Hi Hugh, Our concept is customer who login with username Sxxx@qnetadsl will be allowed to log on only on Saturday-Sunday , and only on Monday - Friday from 22:00 - 00:00 for username Pxxx@qnetadsl So I try to use Time and Prefix check item but it show error like these ERR : Unknow keyword 'DEFAULT' ERR : Unknow keyword 'Time' How can I fix it ? Thanks in advance, Chairath P.S. Now I'm implement RADIATOR version 2.18.2 and RADMIN version 1.4 based on Windows NT attach.zip
(RADIATOR) RADONLINE Table ?
Hi, I'm facing problem about RADONLINE Table. First ,I make a connection with username test2@qnetadsl. After 11 seconds , I diconnect it but the Current Sessions Widnows at RADMIN still show this session. So I try to look at logfile to see what happen ,and I find something wrong. In log file you can see that after user test2@qnetadsl login , Radiator then do query insert RADONLINE Table with NASPORT = 01644167268 . But after test2@qnetadsl logout , Radiator do query delete RADONLINE Table where NASPORT = 0 . Can somone help me to fix this problem. Thanks in advance! Chairath P.S. Now I'm implement RADIATOR version 2.18.2 and RADMIN version 1.4 based on Windows NT attach.zip
(RADIATOR) Problem about Time check item
Hi Hugh,
Our concept is customer
who login with username Sxxx@qnetadsl will be allowed to log on only on
Saturday-Sunday , and only on Monday - Friday from 22:00 - 00:00 for username
Pxxx@qnetadsl
So I try to use Time and
Prefix check item but it show error like these
ERR
: Unknow keyword 'DEFAULT'
ERR
: Unknow keyword 'Time'
How can I fix it ?
Thanks in advance,
Chairath
P.S. Now I'm implement RADIATOR
version 2.18.2 and RADMIN version 1.4 based on Windows NT
Foreground
LogStdout
LogDir d:/Radiator-Demo-2.18/log
DbDir d:/Radiator-Demo-2.18
LogFile %L/logfile-%d-%m-%Y
# Dont turn this up too high,
since all log messages are logged
# to the RADMESSAGES table
in the database. 3 will give you everything
# except debugging messages
Trace 4
# You will probably want
to change this to suit your site.
# You should list all the
clients you have, and their secrets
# If you are using the Radmin
Clients table, you wil probably
# want to disable this.
#Client DEFAULT>
# Secret mysecret
# DupInterval 0
#/Client>
# You can put additonal (or
all) client details in your Radmin
# database table
# and get their details
from there with something like this:
# You can then use the Radmin
'Add Radius Client' to add new clients.
ClientListSQL>
DBSource dbi:ODBC:Radmin
DBUsername xxx
DBAuth xxx
/ClientListSQL>
#AuthBy RADIUS>
# Identifier ProxyTofunk
# Host xxx
# Secret xxx
#/AuthBy>
#Realm funk>
# strip Realm
# RewriteUsername s/^([^@]+).*/$1/
# AuthBy ProxyTofunk
#/Realm>
AuthBy RADMIN>
Identifier RADMINAUTH
# Change DBSource,
DBUsername, DBAuth for your database
# See the reference
manual. You will also have to
# change the one in
SessionDatabse SQL> below
# so its the same
DBSource dbi:ODBC:Radmin
DBUsername xxx
DBAuth xxx
DateFormat %e %m
%Y %T
# You can add to or
change these if you want, but you
# will probably want
to change the database schema first
AccountingTable RADUSAGE
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type,integer
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef DNIS,Called-Station-Id
AcctColumnDef DATE,Timestamp,integer-date
# This updates the
time and octets left
# for this user
AcctSQLStatement update
RADUSERS set TIMELEFT=TIMELEFT-0%{Acct-Session-Time}, OCTETSINLEFT=OCTETSINLEFT-0%{Acct-Input-Octets},
OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets} where USERNAME='%n'
# These are the classic
things to add to each users
# reply to allow a
PPP dialup session. It may be
# different for your
NAS. This will add some
# reply items to everyone's
reply
AddToReply Framed-Protocol
= PPP,\
Service-Type = Framed-User,\
Framed-IP-Netmask = 255.255.255.255,\
Framed-Routing = None,\
Framed-MTU = 1500,\
Framed-Compression
= Van-Jacobson-TCP-IP,\
Idle-Timeout = 600
/AuthBy>
Realm qnetadsl>
DEFAULT Prefix = S
Time = "SaSu-2359"
AuthBy RADMINAUTH
DEFAULT Prefix = P
Time = "Wk2200-"
AuthBy RADMINAUTH
/Realm>
# Handle everyone with RADMIN
Realm DEFAULT>
AuthBy RADMINAUTH
/Realm>
SessionDatabase SQL>
# This database spec
usually should be exactly the same
# as in AuthBy
RADMIN> above
DBSource dbi:ODBC:Radmin
DBUsername xxx
DBAuth xxx
ClearNasQuery
/SessionDatabase>
(RADIATOR) Time of Day Access
Hi all, By now we implement Radiator and Radmin on Windows NT . So is it possible to set time of day access for some users (e.g. user A can login only on Saterday and Sunday , user B can login only on Monday - Friday from 7:00 AM to 6:00 PM) Furthermore , can you please make a suggestion how can I implement Radmin and Radiator with Mail server in order to send email to our customer automaticallly when their own timeleft are less than 5 hrs. Thanks Chairath
(RADIATOR) Time of Day Access
Hi all, By now we implement Radiator and Radmin on Windows NT . So is it possible to set time of day access for some users (e.g. user A can login only on Saterday and Sunday , user B can login only on Monday - Friday from 7:00 AM to 6:00 PM) Furthermore , can you please make a suggestion how can I implement Radmin and Radiator with Mail server in order to send email to our customer automaticallly when their own timeleft are less than 5 hrs. Thanks Chairath
(RADIATOR) Upgrade Radiator
Hi all, By now , I'm running Radiator 2.18 base on Windows NT 4.0 . So please suggest me how can I upgrade Radiator from 2.18 to 2.18.2 . Thanks Chairath
(RADIATOR) Valid to
Hi all, In case of created user via RAdmin , what should I specifies in "Valid to" field to let new user will be able to login forever. Thanks, Chairath
