--- Forwarded mail from [EMAIL PROTECTED]
Date: Fri, 28 Apr 2000 22:40:16 +1000
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from [Okan ARISU
<[EMAIL PROTECTED]>]
>From owner-radiator Fri Apr 28 22:40:11 2000
Received: (from uucp@localhost) by oscar.open.com.au (8.6.12/8.6.12) id
WAA23543 for [EMAIL PROTECTED]; Fri, 28 Apr 2000 22:40:11 +1000
>Received: from web208.mail.yahoo.com (web208.mail.yahoo.com [128.11.68.108])
by perki.connect.com.au with SMTP id WAA29364
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Fri, 28 Apr 2000 22:21:00 +1000
(EST)
Received: from web208.mail.yahoo.com (web208.mail.yahoo.com [128.11.68.108]) by
perki.connect.com.au with SMTP id WAA29364
(8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Fri, 28 Apr 2000 22:21:00 +1000
(EST)
Received: (qmail 24130 invoked by uid 60001); 28 Apr 2000 12:20:58 -0000
Received: from [213.248.128.130] by web208.mail.yahoo.com; Fri, 28 Apr 2000
05:20:58 PDT
Message-ID: <[EMAIL PROTECTED]>
Date: Fri, 28 Apr 2000 05:20:58 -0700 (PDT)
From: Okan ARISU <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: RADONLINE accounting problem
To: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Length: 14022
Hello,
We are using Radiator 2.14.1 and Cisco 5300 RAS
servers in two different location.
The first RAS 5300 is in the same network with
Radiator, the other is not.
When i try to dialin using first RAS, and look into
debug logs, "the insert into radonline table comment"
is seen and connected clients can be seen in radonline
table.
However, when i try to dialin using second RAS, the
client logs into network(radiator checks the account).
But in debug logs
"the insert into radonline table comment" is not seen
and connected people are not inserted in to the
radonline table.
The .cfg file is below. Is there a mistake or require
some code to add to solve this problem.
Any suggestions? Thanks a lot.
********** .cfg **********
Foreground
LogStdout
Trace 4
LogDir /software/Radiator-2.14.1/Logfiles/
LogFile %L/%d-%m-%Y-logfile
DbDir .
<Client 127.0.0.1>
Secretgizli
# Her bir RAS client icin baska bir havuz
yapilabilir
FramedGroupBaseAddress 10.10.1.5
FramedGroupBaseAddress 10.10.254.1
#RAS ile konusurken kullanacagi protokolu secmesi
icin
NasType Cisco
DupInterval 2
</Client>
<Client 10.10.0.2>
Secretgizli
# Her bir RAS client icin baska bir havuz
yapilabilir
#FramedGroupBaseAddress 10.10.1.5
FramedGroupBaseAddress xxx.xxx.xxx.xxx
FramedGroupBaseAddress 10.10.254.1
#RAS ile konusurken kullanacagi protokolu secmesi
icin
NasType Cisco
DupInterval 2
</Client>
<Client 10.10.0.4>
Secret mysecret
# Her bir RAS client icin baska bir havuz
yapilabilir
#FramedGroupBaseAddress 10.10.46.5
FramedGroupBaseAddress xxx.xxx.xxx.xxx
FramedGroupBaseAddress 10.10.250.1
#RAS ile konusurken kullanacagi protokolu secmesi
icin
NasType NortelCVX1800
#DupInterval 2
</Client>
<Client xxx.xxx.xxx.xxx>
Secretgizli
# Her bir RAS client icin baska bir havuz
yapilabilir
FramedGroupBaseAddress xxx.xxx.xxx.xxx
FramedGroupBaseAddress 10.10.254.1
#RAS ile konusurken kullanacagi protokolu secmesi
icin
NasType Cisco
DupInterval 2
</Client>
<Client xxx.xxx.xxx.xxx>
Secret mysecret
# Her bir RAS client icin baska bir havuz
yapilabilir
FramedGroupBaseAddress xxx.xxx.xxx.xxx
FramedGroupBaseAddress 10.10.254.1
#RAS ile konusurken kullanacagi protokolu secmesi
icin
NasType NortelCVX1800
#DupInterval 2
</Client>
<Client 10.10.0.8>
Secretgizli # Her bir RAS client icin baska
bir havuz yapilabilir
FramedGroupBaseAddress 10.10.1.5
FramedGroupBaseAddress 10.10.254.1
#RAS ile konusurken kullanacagi protokolu secmesi
icin
NasType Cisco
DupInterval 2
</Client>
<Client DEFAULT>
Secret gizli2
#RAS ile konusurken kullanacagi protokolu secmesi
icin
#NasType Ascend
DupInterval 2
</Client>
# kullanici gruplama parametreleri
# You can put client details in a database table
# and get their details from there with something like
this:
<ClientListSQL>
DBSource xxx
DBUsername xxx
DBAuth xxx
</ClientListSQL>
<SessionDatabase SQL>
DBSource xxx
DBUsername xxxx
DBAuth xxxx
</SessionDatabase>
# This will authenticate users from SUBSCRIBERS
#<Handler Realm=rasbasar.basari.net.tr>
#<Realm /.*\.basari.net.tr/i>
<Realm KAYIT>
<AuthBy FILE>
FramedGroup 1
Filename ./userregister
#SessionLimit 1
DefaultSimultaneousUse 10
</AuthBy>
</Realm>
<Realm basari>
#Yanlis girilen parolalari gormek icin
PasswordLogFileName %L/%d-%m-%Y-password.log
# exactly why in the Reply-Message
#RejectHasReason
<AuthBy GROUP>
AuthByPolicy ContinueWhileReject
RewriteUsername s/^([^@]+).*/$1/
<AuthBy SQL>
AddToReply Service-Type = Framed-User,
#Framed-IP-Netmask =255.255.0.0,Framed-Protocol =
PPP,Framed-Routing = None,Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP,
# Client larin ip adreslerini alacagi ip
havuzu
FramedGroup 0
DefaultSimultaneousUse 1
#formatted-date,to_date('%d %m %Y %H: %M: %S:',
'DD MM YYYY HH24:MI:SS')
# Adjust DBSource, DBUsername, DBAuth to suit
your DB
DBSource xxx
DBUsername xxx
DBAuth xxx
# You may want to tailor these for your ACCOUNTING
table
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
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 NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy >
<AuthBy FILE>
FramedGroup 1
# Kosullarin yazildigi txt dosyanin ismi
#Filename ./userlist1
Filename ./userlistbasar
#SessionLimit 1
DefaultSimultaneousUse 10
</AuthBy>
#MaxSessions 1
</AuthBy>
</Realm>
# sadece kullanici ismini yazanlar.
<Realm>
PasswordLogFileName %L/%d-%m-%Y-password.log
# exactly why in the Reply-Message
#RejectHasReason
AuthByPolicy ContinueWhileReject
<AuthBy SQL>
AddToReply Service-Type = Framed-User,
#Framed-IP-Netmask =255.255.0.0,Framed-Protocol =
PPP,Framed-Routing = None,Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP,
DefaultSimultaneousUse 1
FramedGroup 0
# Adjust DBSource, DBUsername, DBAuth to suit
your DB
DBSource xxx
DBUsername xxx
DBAuth xxx
# You may want to tailor these for your ACCOUNTING
table
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
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 NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy >
<AuthBy FILE>
FramedGroup 1
# Kosullarin yazildigi txt dosyanin ismi
#Filename ./userlist1
Filename ./userlistbasar
#SessionLimit 1
DefaultSimultaneousUse 10
</AuthBy>
<AuthBy FILE>
# Client larin ip adreslerini alacagi ip
havuzu123
FramedGroup 0
# Kosullarin yazildigi txt dosyanin ismi
Filename ./userlistwap_internet
#SessionLimit 1
DefaultSimultaneousUse 10
</AuthBy>
</Realm>
************************************************ log
file**************
*** Received from SECOND RAS IP ADDRESS port 1645 ....
Code: Access-Request
Identifier: 93
Authentic: <139>'k;g<155>`0<191>$z<254>]<144>u<11>
Attributes:
NAS-IP-Address = 10.10.0.2
NAS-Port = 77
NAS-Port-Type = Async
User-Name = "okanarisu"
Called-Station-Id = ""
User-Password =
"<169><235><1><143>&2<133>y<212><196><198><18><17><134><206>p"
Service-Type = Framed-User
Framed-Protocol = PPP
Fri Apr 28 04:08:02 2000: DEBUG: Handling request with
Handler 'Realm='
Fri Apr 28 04:08:02 2000: DEBUG: Deleting session for
okanarisu, 10.10.0.2, 77
Fri Apr 28 04:08:02 2000: DEBUG: do query is: delete
from RADONLINE where NASIDENTIFIER='10.10.0.2' and
NASPORT=77
Fri Apr 28 04:08:02 2000: DEBUG: Handling with
Radius::AuthSQL
Fri Apr 28 04:08:02 2000: DEBUG: Handling with
Radius::AuthSQL
Fri Apr 28 04:08:02 2000: DEBUG: Query is: select
PASSWORD from SUBSCRIBERS where USERNAME='okanarisu'
Fri Apr 28 04:08:02 2000: DEBUG: Radius::AuthSQL looks
for match with okanarisu
Fri Apr 28 04:08:02 2000: DEBUG: Query is: select
NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE
where USERNAME='okanarisu'
Fri Apr 28 04:08:02 2000: DEBUG: Radius::AuthSQL
ACCEPT:
Fri Apr 28 04:08:02 2000: DEBUG: FramedGroup 0 address
is being assigned
Fri Apr 28 04:08:02 2000: DEBUG: Access accepted for
okanarisu
Fri Apr 28 04:08:02 2000: DEBUG: Packet dump:
*** Sending to 213.248.138.2 port 1645 ....
Code: Access-Accept
Identifier: 93
Authentic: <139>'k;g<155>`0<191>$z<254>]<144>u<11>
Attributes:
Framed-IP-Address = 213.248.138.82
Service-Type = Framed-User
Fri Apr 28 04:46:24 2000: DEBUG: Packet dump:
*** Sending to FIRST IP ADDRESS port 1646 ....
Code: Accounting-Response
Identifier: 67
Authentic:
r<<240>FIe<235><175>Q<153>R<5><4><24><201><31>
Attributes:
Fri Apr 28 06:34:02 2000: DEBUG: Packet dump:
*** Received from 10.10.0.2 port 1645 ....
Code: Access-Request
Identifier: 68
Authentic:
<234>sd<156>Jj<16><147><225><220><219><222><134><146>7<215>
Attributes:
NAS-IP-Address = 10.10.0.2
NAS-Port = 75
NAS-Port-Type = Async
User-Name = "buraksendag"
Called-Station-Id = "1060"
Calling-Station-Id = "3123842247"
User-Password = "<188>O<206><127>-<187>
9<191><166>-D<153><200>t<212>"
Service-Type = Framed-User
Framed-Protocol = PPP
Fri Apr 28 06:34:02 2000: DEBUG: Handling request with
Handler 'Realm='
Fri Apr 28 06:34:02 2000: DEBUG: Deleting session for
buraksendag, 10.10.0.2, 75
Fri Apr 28 06:34:02 2000: DEBUG: do query is: delete
from RADONLINE where NASIDENTIFIER='10.10.0.2' and
NASPORT=75
Fri Apr 28 06:34:02 2000: DEBUG: Handling with
Radius::AuthSQL
Fri Apr 28 06:34:02 2000: DEBUG: Handling with
Radius::AuthSQL
Fri Apr 28 06:34:02 2000: DEBUG: Query is: select
PASSWORD from SUBSCRIBERS where USERNAME='buraksendag'
Fri Apr 28 06:34:02 2000: DEBUG: Radius::AuthSQL looks
for match with buraksendag
Fri Apr 28 06:34:02 2000: DEBUG: Query is: select
NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE
where USERNAME='buraksendag'
Fri Apr 28 06:34:02 2000: DEBUG: Radius::AuthSQL
ACCEPT:
Fri Apr 28 06:34:02 2000: DEBUG: FramedGroup 0 address
is being assigned
Fri Apr 28 06:34:02 2000: DEBUG: Access accepted for
buraksendag
Fri Apr 28 06:34:02 2000: DEBUG: Packet dump:
*** Sending to 10.10.0.2 port 1645 ....
Code: Access-Accept
Identifier: 68
Authentic:
<234>sd<156>Jj<16><147><225><220><219><222><134><146>7<215>
Attributes:
Framed-IP-Address = xxx.xxx.xxx.xxx
Service-Type = Framed-User
Fri Apr 28 06:34:02 2000: DEBUG: Packet dump:
*** Received from 10.10.0.2 port 1646 ....
Code: Accounting-Request
Identifier: 69
Authentic:
<249><136>?#<128>/j<246><144><8><177>0<137>L<127><241>
Attributes:
NAS-IP-Address = 10.10.0.2
NAS-Port = 75
NAS-Port-Type = Async
User-Name = "buraksendag"
Called-Station-Id = "1060"
Calling-Station-Id = "3636363666"
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "00000A79"
Framed-Protocol = PPP
Acct-Delay-Time = 0
Fri Apr 28 06:34:02 2000: DEBUG: Handling request with
Handler 'Realm='
Fri Apr 28 06:34:02 2000: DEBUG: Adding session for
buraksendag, 10.10.0.2, 75
Fri Apr 28 06:34:02 2000: DEBUG: do query is: delete
from RADONLINE where NASIDENTIFIER='10.10.0.2' and
NASPORT=75
Fri Apr 28 06:34:02 2000: DEBUG: do query is: insert
into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
NASPORTTYPE, SERVICETYPE) values ('buraksendag',
'10.10.0.2', 75, '00000A79', 956892842, '', 'Async',
'Framed-User')
Fri Apr 28 06:34:02 2000: DEBUG: Handling with
Radius::AuthSQL
Fri Apr 28 06:34:02 2000: DEBUG: Handling accounting
with Radius::AuthSQL
Fri Apr 28 06:34:02 2000: DEBUG: do query is: insert
into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE,
ACCTDELAYTIME, ACCTSESSIONID, NASPORT)
values
('buraksendag', 956892842, 'Start', 0, '00000A79',
75)
Fri Apr 28 06:34:02 2000: DEBUG: Accounting accepted
Fri Apr 28 06:34:02 2000: DEBUG: Packet dump:
*** Sending to 10.10.0.2 port 1646 ....
Code: Accounting-Response
Identifier: 69
Authentic:
<249><136>?#<128>/j<246><144><8><177>0<137>L<127><241>
Attributes:
Fri Apr 28 06:34:06 2000: DEBUG: Packet dump:
*** Received from 10.10.0.2 port 1646 ....
Code: Accounting-Request
Identifier: 70
Authentic:
<200><245><142><187><148><135><134><171><190>KPOr<3><131>&
Attributes:
NAS-IP-Address = 10.10.0.2
NAS-Port = 75
NAS-Port-Type = Async
User-Name = "buraksendag"
Called-Station-Id = "1060"
Calling-Station-Id = "3123842247"
Acct-Status-Type = Alive
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "00000A79"
Framed-Protocol = PPP
Framed-IP-Address = 213.248.130.80
Acct-Delay-Time = 0
Fri Apr 28 06:34:06 2000: DEBUG: Handling request with
Handler 'Realm='
Fri Apr 28 06:34:06 2000: DEBUG: Adding session for
buraksendag, 10.10.0.2, 75
Fri Apr 28 06:34:06 2000: DEBUG: do query is: delete
from RADONLINE where NASIDENTIFIER='10.10.0.2' and
NASPORT=75
Fri Apr 28 06:34:06 2000: DEBUG: do query is: insert
into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
NASPORTTYPE, SERVICETYPE) values ('buraksendag',
'10.10.0.2', 75, '00000A79', 956892846,
'213.248.130.80', 'Async', 'Framed-User')
Fri Apr 28 06:34:06 2000: DEBUG: Handling with
Radius::AuthSQL
Fri Apr 28 06:34:06 2000: DEBUG: Handling accounting
with Radius::AuthSQL
Fri Apr 28 06:34:06 2000: DEBUG: do query is: insert
into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE,
ACCTDELAYTIME, ACCTSESSIONID, NASPORT,
FRAMEDIPADDRESS)
values
('buraksendag', 956892846, 'Alive', 0, '00000A79',
75, '213.248.130.80')
Fri Apr 28 06:34:06 2000: DEBUG: Accounting accepted
Fri Apr 28 06:34:06 2000: DEBUG: Packet dump:
*** Sending to 10.10.0.2 port 1646 ....
Code: Accounting-Response
Identifier: 70
Authentic:
<200><245><142><187><148><135><134><171><190>KPOr<3><131>&
Attributes:
Fri Apr 28 06:47:50 2000: DEBUG: Packet dump:
__________________________________________________
Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
---End of forwarded mail from [EMAIL PROTECTED]
--
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,
2000, NT, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
