Hello Hugh,
I changed the check in reply and it still doesn't work.
Thu Feb 1 23:38:22 2001: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1033 ....
Code: Access-Request
Identifier: 247
Authentic: 1234567890123456
Attributes:
User-Name = "dirk"
Service-Type = Framed-User
NAS-IP-Address = 1.2.3.4
NAS-Port = 1234
NAS-Port-Type = Async
User-Password =
"<137><234>,<222><216>3v<146><188>8<9><160><216>}x<153>"
Thu Feb 1 23:38:22 2001: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Thu Feb 1 23:38:22 2001: DEBUG: Deleting session for dirk, 1.2.3.4,
1234
Thu Feb 1 23:38:22 2001: DEBUG: Handling with Radius::AuthSQL
Thu Feb 1 23:38:22 2001: DEBUG: Handling with Radius::AuthSQL
Thu Feb 1 23:38:22 2001: DEBUG: Query is: select PASSWORD, CHECKATTR,
REPLYATTR
, GROUPID, STATICIPADDRESS from SUBSCRIBERS where USERNAME = 'dirk'
Thu Feb 1 23:38:22 2001: DEBUG: Radius::AuthSQL looks for match with
dirk
Thu Feb 1 23:38:22 2001: DEBUG: Radius::AuthSQL ACCEPT:
Thu Feb 1 23:38:22 2001: DEBUG: Handling with Radius::AuthDYNADDRESS
Thu Feb 1 23:38:22 2001: DEBUG: Access accepted for dirk
Code: Access-Request
Identifier: 247
Authentic: 1234567890123456
Attributes:
User-Name = "dirk"
Service-Type = Framed-User
NAS-IP-Address = 1.2.3.4
NAS-Port = 1234
NAS-Port-Type = Async
User-Password =
"<137><234>,<222><216>3v<146><188>8<9><160><216>}x<153>"
sending Access-Request...
No reply
Code: Accounting-Request
Identifier: 248
Authentic: <0><0><0><0><0><0><0><0><0><0><0><0><0><0><0><0>
Attributes:
User-Name = "dirk"
Service-Type = Framed-User
NAS-IP-Address = 1.2.3.4
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
sending Accounting-Request Start...
No reply
Code: Accounting-Request
Identifier: 249
Authentic: <0><0><0><0><0><0><0><0><0><0><0><0><0><0><0><0>
Attributes:
User-Name = "dirk"
Service-Type = Framed-User
NAS-IP-Address = 1.2.3.4
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
sending Accounting-Request Stop...
No reply
Regards,
Dirk
Hugh Irvine schreef:
> Hello Dirk -
>
> On Friday 02 February 2001 07:22, Dirk Laan wrote:
> >
> > How can I fix the following:
> >
> > This user has a static ip address.
> >
> .....
> > # This will authenticate users from
> > <Realm DEFAULT>
> > AuthByPolicy ContinueWhileAccept
> > <AuthBy SQL>
> > # Adjust DBSource, DBUsername, DBAuth to suit your DB
> >
> > DBSource dbi:mysql:radius
> > DBUsername radius
> > DBAuth radius
> >
> > AuthSelect select PASSWORD, CHECKATTR, REPLYATTR, GROUPID,
> > STATICIPADDRESS from SUBSCRIBERS where USERNAME = '%n'
> >
> > AuthColumnDef 0, User-Password, check
> > AuthColumnDef 1, GENERIC, check
> > AuthColumnDef 2, GENERIC, reply
> > AuthColumnDef 3, Group-ID, reply
> > AuthColumnDef 4, Framed-IP-Address, check
> >
>
> The above should be a reply item, not a check item:
>
> AuthColumnDef 4, Framed-IP-Address, reply
>
> hth
>
> Hugh
>
> --
> 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.
begin:vcard
n:Laan;Dirk
tel;work:020-5497967
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Dirk Laan
end:vcard
