(RADIATOR) authby sql
Hugh Irvine
hugh at open.com.au
Sun Dec 23 21:51:32 CST 2001
Hello Rick -
Your configuration file has a Realm clause for "xxxxxx.com" and another Realm
clause for any other realm, however you don't have a clause to match just a
username by itself.
# define a Realm for username only
<Realm>
.....
</Realm>
regards
Hugh
>
> could someon tell me what I am missing here or doing wrong thanks
>
>
> Sun Dec 23 19:20:28 2001: DEBUG: Rewrote user name to test
> Sun Dec 23 19:20:28 2001: DEBUG: Check if Handler Realm=mynet.com should be
> used to handle this request
> Sun Dec 23 19:20:28 2001: WARNING: Could not find a handler for qwtest:
> request is ignored
> Sun Dec 23 19:20:30 2001: DEBUG: Packet dump:
> *** Received from 0.0.0.0 port 58682 ....
> Code: Access-Request
> Identifier: 52
> Authentic: ka<197><219><24>@\Os<23>'<184>bs<253>z
> Attributes:
> User-Name = "test"
> CHAP-Password = <1><130><199><195>P<13>(<209><130><223>zJ<242>zc<15><191>
> NAS-IP-Address = 0.0.0.0
> NAS-Port = 7190
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Cisco-NAS-Port = "Async4/43*Serial7/0:1:22"
> Acct-Session-Id = "00000A"
> NAS-Port-Type = Async
>
> Sun Dec 23 19:20:30 2001: DEBUG: Rewrote user name to test
> Sun Dec 23 19:20:30 2001: DEBUG: Check if Handler Realm=mynet.com should be
> used to handle this request
> Sun Dec 23 19:20:30 2001: WARNING: Could not find a handler for test:
> request is ignored
> Sun Dec 23 19:21:13 2001: DEBUG: Packet dump:
> *** Received from 0.0.0.0 port 58684 ....
> Code: Access-Request
> Identifier: 53
> Authentic: <194>7<127>dZ>its<23>'<184><137>[r<254>
> Attributes:
> User-Name = "test"
> CHAP-Password = <1><141>{<247><199><186>Q<130>#h#<31>a<228><150>IN
> NAS-IP-Address = 0.0.0.0
> NAS-Port = 7190
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Cisco-NAS-Port = "Async4/44*Serial7/0:1:22"
> Acct-Session-Id = "00000B"
> NAS-Port-Type = Async
>
> Sun Dec 23 19:21:13 2001: DEBUG: Rewrote user name to test
> Sun Dec 23 19:21:13 2001: DEBUG: Check if Handler Realm=mynet.com should be
> used to handle this request
> Sun Dec 23 19:21:13 2001: WARNING: Could not find a handler for test:
> request is ignored
> Sun Dec 23 19:21:15 2001: DEBUG: Packet dump:
> *** Received from 0.0.0.0 port 58684 ....
> Code: Access-Request
> Identifier: 53
> Authentic: <194>7<127>dZ>its<23>'<184><137>[r<254>
> Attributes:
> User-Name = "test"
> CHAP-Password = <1><141>{<247><199><186>Q<130>#h#<31>a<228><150>IN
> NAS-IP-Address = 0.0.0.0
> NAS-Port = 7190
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Cisco-NAS-Port = "Async4/44*Serial7/0:1:22"
> Acct-Session-Id = "00002B"
> NAS-Port-Type = Async
>
> Sun Dec 23 19:21:15 2001: DEBUG: Rewrote user name to test
> Sun Dec 23 19:21:15 2001: DEBUG: Check if Handler Realm=mynet.com should be
> used to handle this request
> Sun Dec 23 19:21:15 2001: WARNING: Could not find a handler for test:
> request is ignored
>
> # Radiator configuration file.
> # Produced by /cgi-bin/radconfig.cgi Sun Dec 23 16:57:37 2001
> #REMOTE_USER: , REMOTE_ADDR:
> AcctPort 1646
> AuthPort 1645
> DbDir /usr/local/etc/raddb
> DictionaryFile /usr/local/etc/raddb/dictionary
> Foreground
> LogDir /var/log/radius
> LogFile %L/logfile
> LogStdout
> PidFile /var/run/radiusd.pid
> Trace 4
>
> <AuthBy SQL>
> AccountingStartsOnly
> AccountingStopsOnly
> AccountingTable radius.ACCOUNTING
> AcctColumnDef USERNAME, '%{User-Name}'
> AcctColumnDef TIME_STAMP, %{Timestamp}, integer
> AcctColumnDef ACCTSTATUSTYPE, '%{Acct-Status-Type}'
> AcctColumnDef ACCTDELAYTIME, %{Acct-Delay-Time}
> 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}
> AcctColumnDef NASIDENTIFIER, '%{NAS-Identifier}'
> AcctColumnDef NASPORT, %{NAS-Port}, integer
> AcctColumnDef FRAMEDIPADDRESS, '%{Framed-IP-Address}'
> AuthSelect select PASSWORD from SUBSCRIBERS where USERNAME='%n'
> DBAuth xxxxxx
> DBSource dbi:mysql:radius
> DBUsername ssssssss
> DefaultSimultaneousUse 1
> Description global access
> Identifier auth_0
> </AuthBy>
>
> <Client xxxxxxxxxx>
> Description testing
> DupInterval 2
> IdenticalClients xxxxxxxxxxxx
> IgnoreAcctSignature
> NasType Livingston
> Secret xxxxxxxx
> </Client>
>
> <Realm xxxxxxxxxx.com>
> AccountingHandled
> AcctLogFileName /var/log/radius/accounting
> AuthBy auth_0
> AuthByPolicy ContinueUntilAccept
> Description Global Dial
> RejectHasReason
> RewriteUsername s/^([^@]+).*/$1/
> RewriteUsername tr/[A-Z]/[a-z]/
> SessionDatabase intdb
> </Realm>
>
>
> <Realm DEFAULT>
> AccountingHandled
> AcctLogFileName /var/log/radius/accounting
> AuthBy auth_0
> AuthByPolicy ContinueUntilAccept
> RejectHasReason
> RewriteUsername s/^([^@]+).*/$1/
> SessionDatabase intdb
> </Realm>
>
> <SessionDatabase INTERNAL>
> Description dont know
> Identifier intdb
> </SessionDatabase>
>
> -------------------------------------------------------
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list