And here's some more output, this is my buffer after trying to login to my
NAS using the 'jefft' account I created in mysql database 'radius'
rad_recv: Access-Request packet from host 204.57.72.47:1026, id=19,
length=57
User-Name = "jefft"
User-Password = "\207C\017J\366\353\253\221\231Z8\370)M\377\336"
NAS-IP-Address = 204.57.72.47
NAS-Port = 99
rlm_chap: Could not find proper Chap-Password attribute in request
rlm_sql: Reserving sql socket id: 2
query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'jefft' ORDER BY id
query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'jefft' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id
query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'jefft' ORDER BY id
query: SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'jefft' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id
query:
MYSQL check_error: 1065 received
rlm_sql_authorize: database query error
rlm_sql: Released sql socket id: 2
rad_recv: Access-Request packet from host 204.57.72.47:1026, id=19,
length=57
Sending Access-Reject of id 19 to 204.57.72.47:1026
rad_recv: Access-Request packet from host 204.57.72.47:1026, id=20,
length=57
User-Name = "jefft"
User-Password =
"\345\253q\320\006\243\271\222)\314\246\326x\250\357\242"
NAS-IP-Address = 204.57.72.47
NAS-Port = 99
rlm_chap: Could not find proper Chap-Password attribute in request
rlm_sql: Reserving sql socket id: 1
query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'jefft' ORDER BY id
query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'jefft' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id
query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'jefft' ORDER BY id
query: SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'jefft' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id
query:
MYSQL check_error: 1065 received
rlm_sql_authorize: database query error
rlm_sql: Released sql socket id: 1
rad_recv: Access-Request packet from host 204.57.72.47:1026, id=20,
length=57
Sending Access-Reject of id 20 to 204.57.72.47:1026
----- Original Message -----
From: "Frank Cusack" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 10:35 PM
Subject: Re: MySQL database error
> On Tue, Jun 17, 2003 at 10:16:55PM -0500, Jeff Thompson - World Net
Technical Support wrote:
> > This was covered all yesterday, but here is the output of radiusd -x
when
>
> See below
>
> > > On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net
> > > Technical Support wrote:
> > >> Can someone give me some ideas here? 0.7 is the only version I can
get
> > >> to work on FreeBSD, but would like to use .8.1 if it would load the
> > >> mysql modules. Anyone?
> > >
> > > It'd be good if you could post the radiusd -X intermingled with strace
> > > output. (Whatever the strace equiv is on FreeBSD.)
>
> You missed that last part. Actually, just the 'strace -e open'
equivalent.
> Just plain strace would be too noisy.
>
> /fc
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
