Hi,
I'm using the following radius.cfg.
When a user request an authentication, the radiator make this
authentication properly and write the accounting information on a SQL
Server located in another machine. If SQL Server is down, the radiator
try to authenticate the user by SQL and do nothing. But I'm use auth by
sql only for accounting and auth by file for authentication.
I think radiator would try with sql and if the server is down, try the
file.
After the radius.cfg i send the log file to show my problem.
Regards, Guilherme.
# radius.cfg
#
# Configuration file for radius server
#
# Author: Mike McCauley ([EMAIL PROTECTED])
# Copyright (C) 1997 Open System Consultants
# $Id: radius2.cfg,v 1.4 1998/03/06 04:43:37 mikem Exp $
#
#Foreground
#LogStdout
Trace 9
AuthPort 1645
AcctPort 1646
LogDir /var/log/radius
DbDir /etc/radiator
LogFile %L/logfile
DictionaryFile %D/dictionary
<Client muda.rio.com.br>
Secret **OMITTED**
DefaultRealm rio.com.br
IdenticalClients ilha.rio.com.br
IdenticalClients alto.rio.com.br
</Client>
<Realm mlppp>
RewriteUsername s/^([^@]+).*/$1/
AuthByPolicy ContinueWhileAccept
<AuthBy FILE>
Filename %D/users
</AuthBy>
MaxSessions 2
</Realm>
<Realm DEFAULT>
RewriteUsername s/^([^@]+).*/$1/
AuthByPolicy ContinueWhileReject
<AuthBy SQL>
DBSource dbi:ODBC:SQL_RECREIO
DBUsername radiator
DBAuth radiator
AuthSelect
AccountingTable accounting
AcctColumnDef
stoptime,Timestamp,formatted-date,'%m/%e/%Y %H:%M:%S'
AcctColumnDef username,User-Name
AcctColumnDef acctsessionid,Acct-Session-Id
AcctColumnDef
acctstatustype,Acct-Status-Type,integer
AcctColumnDef nasipaddress,NAS-IP-Address
AcctColumnDef nasport,NAS-Port,integer
AcctColumnDef servicetype,Service-Type,integer
AcctColumnDef nasporttype,NAS-Port-Type,integer
AcctColumnDef
framedprotocol,Framed-Protocol,integer
AcctColumnDef framedipaddress,Framed-IP-Address
AcctColumnDef timestamp,Timestamp,integer
AcctColumnDef
acctsessiontime,Acct-Session-Time,integer
AcctColumnDef
callingstationid,Calling-Station-Id
AcctColumnDef
acctterminatcause,Acct-Terminat-Cause,integer
AcctColumnDef
usrmodulationtype,USR-Modulation-Type,integer
AcctColumnDef
usrconnectspeed,USR-Connect-Speed,integer
AcctColumnDef
usrsimplifiedmnplevels,USR-Simplified-MNP-Levels,integer
AcctColumnDef
acctinputoctets,Acct-Input-Octets,integer
AcctColumnDef
acctoutputoctets,Acct-Output-Octets,integer
AcctColumnDef
acctinputpackets,Acct-Input-Packets,integer
AcctColumnDef
acctoutputpackets,Acct-Output-Packets,integer
Timeout 10
</AuthBy>
<AuthBy FILE>
Filename %D/users
</AuthBy>
MaxSessions 1
AcctLogFileName %L/%Y%m/detail-%d
</Realm>
<Realm SoparatratarUNIXPW>
<AuthBy UNIX>
Identifier System
Filename %D/www.passwd
GroupFilename /etc/group
</AuthBy>
</Realm>
#
# Log File
#
Mon Nov 22 17:07:01 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 06 00 4c 5b e8 ca 0a 7e ff 64 b2 69 f2 36 79
a0 e9 a1 23 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
a7 d7 29 b1 d7 4f 3a e5 41 fa cd 2f ef 95 50 51
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 6
Authentic: [<232><202><10>~<255>d<178>i<242>6y<160><233><161>#
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password =
"<167><215>)<177><215>O:<229>A<250><205>/<239><149>PQ"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:01 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:01 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:01 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:01 1999: DEBUG: Handling with Radius::AuthSQL
Mon Nov 22 17:07:06 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 06 00 4c 5b e8 ca 0a 7e ff 64 b2 69 f2 36 79
a0 e9 a1 23 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
a7 d7 29 b1 d7 4f 3a e5 41 fa cd 2f ef 95 50 51
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 6
Authentic: [<232><202><10>~<255>d<178>i<242>6y<160><233><161>#
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password =
"<167><215>)<177><215>O:<229>A<250><205>/<239><149>PQ"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:06 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:06 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:06 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:06 1999: DEBUG: Handling with Radius::AuthSQL
Mon Nov 22 17:07:11 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 06 00 4c 5b e8 ca 0a 7e ff 64 b2 69 f2 36 79
a0 e9 a1 23 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
a7 d7 29 b1 d7 4f 3a e5 41 fa cd 2f ef 95 50 51
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 6
Authentic: [<232><202><10>~<255>d<178>i<242>6y<160><233><161>#
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password =
"<167><215>)<177><215>O:<229>A<250><205>/<239><149>PQ"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:11 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:11 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:11 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:11 1999: DEBUG: Handling with Radius::AuthSQL
Mon Nov 22 17:07:16 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 07 00 4c ae d0 fc 1c 04 96 fb 60 25 67 8c c4
4e 57 3d 17 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
20 9c 31 5a 04 ec 3e 07 84 6c 6c 8f e3 00 80 d1
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 7
Authentic: <174><208><252><28><4><150><251>`%g<140><196>NW=<23>
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password = "
<156>1Z<4><236>><7><132>ll<143><227><0><128><209>"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:16 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:16 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:16 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:16 1999: DEBUG: Handling with Radius::AuthSQL
Mon Nov 22 17:07:21 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 07 00 4c ae d0 fc 1c 04 96 fb 60 25 67 8c c4
4e 57 3d 17 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
20 9c 31 5a 04 ec 3e 07 84 6c 6c 8f e3 00 80 d1
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 7
Authentic: <174><208><252><28><4><150><251>`%g<140><196>NW=<23>
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password = "
<156>1Z<4><236>><7><132>ll<143><227><0><128><209>"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:21 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:21 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:21 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:21 1999: DEBUG: Handling with Radius::AuthSQL
Mon Nov 22 17:07:26 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 07 00 4c ae d0 fc 1c 04 96 fb 60 25 67 8c c4
4e 57 3d 17 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
20 9c 31 5a 04 ec 3e 07 84 6c 6c 8f e3 00 80 d1
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 7
Authentic: <174><208><252><28><4><150><251>`%g<140><196>NW=<23>
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password = "
<156>1Z<4><236>><7><132>ll<143><227><0><128><209>"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:26 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:26 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:26 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:26 1999: DEBUG: Handling with Radius::AuthSQL
Mon Nov 22 17:07:31 1999: DEBUG: Packet dump:
*** Received from 200.240.25.3 port 1645 ....
Packet length = 76
01 07 00 4c ae d0 fc 1c 04 96 fb 60 25 67 8c c4
4e 57 3d 17 04 06 c8 f0 19 03 05 06 00 00 00 08
3d 06 00 00 00 00 01 08 64 61 76 69 64 6b 02 12
20 9c 31 5a 04 ec 3e 07 84 6c 6c 8f e3 00 80 d1
06 06 00 00 00 02 07 06 00 00 00 01
Code: Access-Request
Identifier: 7
Authentic: <174><208><252><28><4><150><251>`%g<140><196>NW=<23>
Attributes:
NAS-IP-Address = 200.240.25.3
NAS-Port = 8
NAS-Port-Type = Async
User-Name = "davidk"
User-Password = "
<156>1Z<4><236>><7><132>ll<143><227><0><128><209>"
Service-Type = Framed-User
Framed-Protocol = PPP
Mon Nov 22 17:07:31 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Nov 22 17:07:31 1999: DEBUG: Rewrote user name to davidk
Mon Nov 22 17:07:31 1999: DEBUG: Deleting session for davidk,
200.240.25.3, 8
Mon Nov 22 17:07:31 1999: DEBUG: Handling with Radius::AuthSQL
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
