(RADIATOR) AUTHby sql problem

Rick Ross rickross at nishna.net
Sun Dec 23 22:06:50 CST 2001


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>




===
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