Re: MYSQL check_error: 1065 received

2002-12-09 Thread Genoud Richard
}', 
'%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')
 sql: connect_failure_retry_delay = 60
 sql: simul_count_query = 
 sql: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName, 
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, 
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND 
AcctStopTime = 0
 sql: simul_zap_query = 
rlm_sql: Driver rlm_sql_mysql loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/radiusdb
rlm_sql: starting 0
rlm_sql:  Attempting to connect #0
rlm_sql: Starting connect to MySQL server for #0
rlm_sql:  Connected new DB handle, #0
rlm_sql: starting 1
rlm_sql:  Attempting to connect #1
rlm_sql: Starting connect to MySQL server for #1
rlm_sql:  Connected new DB handle, #1
rlm_sql: starting 2
rlm_sql:  Attempting to connect #2
rlm_sql: Starting connect to MySQL server for #2
rlm_sql:  Connected new DB handle, #2
rlm_sql: starting 3
rlm_sql:  Attempting to connect #3
rlm_sql: Starting connect to MySQL server for #3
rlm_sql:  Connected new DB handle, #3
rlm_sql: starting 4
rlm_sql:  Attempting to connect #4
rlm_sql: Starting connect to MySQL server for #4
rlm_sql:  Connected new DB handle, #4
Module: Instantiated sql (sql)
[...]
rad_recv: Access-Request packet from host 127.0.0.1:32781, id=68, length=45
Thread 1 assigned request 0
--- Walking the entire request list ---
Threads: total/active/spare threads = 5/1/4
Waking up in 5 seconds...
Thread 1 handling request 0, (1 handled so far)
User-Name = user
User-Password = \305.\264 E\364{\0247\001\002\315\022\310\351\300
modcall: entering group authorize
  modcall[authorize]: module preprocess returns ok
rlm_realm: Looking up realm NULL for User-Name = user
rlm_realm: No such realm NULL
  modcall[authorize]: module suffix returns noop
users: Matched DEFAULT at 155
  modcall[authorize]: module files returns ok
radius_xlat:  'user'
sql_set_user:  escaped user -- 'user'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'user' ORDER BY id'
rlm_sql: Reserving sql socket id: 4
query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'user' ORDER BY id
radius_xlat:  'SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op 
 FROM radgroupcheck,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
query:  SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op 
 FROM radgroupcheck,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE 
Username = 'user' ORDER BY id'
query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE 
Username = 'user' ORDER BY id
radius_xlat:  'SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op 
 FROM radgroupreply,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
query:  SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op 
 FROM radgroupreply,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
radius_xlat:  ''
query:
MYSQL check_error: 1065 received
rlm_sql_authorize: database query error
rlm_sql: Released sql socket id: 4
  modcall[authorize]: module sql returns fail
modcall: group authorize returns fail
Finished request 0
...


- List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html



--
---
CYBERDECK
Solutions de bornes interactives
---
Richard Genoud
Ingenieur RD
---
300 route nationale 6 - 69760 Limonest - France
Tel. : 0820 820 107 - International +33 4 78 66 74 00
Fax : +33 4 78 66 74 69
[EMAIL PROTECTED] - www.cyberdeck.com
---


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



MYSQL check_error: 1065 received

2002-12-06 Thread Genoud Richard
: connect_failure_retry_delay = 60
 sql: simul_count_query = 
 sql: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName, 
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, 
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND 
AcctStopTime = 0
 sql: simul_zap_query = 
rlm_sql: Driver rlm_sql_mysql loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/radiusdb
rlm_sql: starting 0
rlm_sql:  Attempting to connect #0
rlm_sql: Starting connect to MySQL server for #0
rlm_sql:  Connected new DB handle, #0
rlm_sql: starting 1
rlm_sql:  Attempting to connect #1
rlm_sql: Starting connect to MySQL server for #1
rlm_sql:  Connected new DB handle, #1
rlm_sql: starting 2
rlm_sql:  Attempting to connect #2
rlm_sql: Starting connect to MySQL server for #2
rlm_sql:  Connected new DB handle, #2
rlm_sql: starting 3
rlm_sql:  Attempting to connect #3
rlm_sql: Starting connect to MySQL server for #3
rlm_sql:  Connected new DB handle, #3
rlm_sql: starting 4
rlm_sql:  Attempting to connect #4
rlm_sql: Starting connect to MySQL server for #4
rlm_sql:  Connected new DB handle, #4
Module: Instantiated sql (sql)
[...]
rad_recv: Access-Request packet from host 127.0.0.1:32781, id=68, length=45
Thread 1 assigned request 0
--- Walking the entire request list ---
Threads: total/active/spare threads = 5/1/4
Waking up in 5 seconds...
Thread 1 handling request 0, (1 handled so far)
User-Name = user
User-Password = \305.\264 E\364{\0247\001\002\315\022\310\351\300
modcall: entering group authorize
  modcall[authorize]: module preprocess returns ok
rlm_realm: Looking up realm NULL for User-Name = user
rlm_realm: No such realm NULL
  modcall[authorize]: module suffix returns noop
users: Matched DEFAULT at 155
  modcall[authorize]: module files returns ok
radius_xlat:  'user'
sql_set_user:  escaped user -- 'user'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'user' ORDER BY id'
rlm_sql: Reserving sql socket id: 4
query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'user' ORDER BY id
radius_xlat:  'SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op 
 FROM radgroupcheck,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
query:  SELECT 
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op 
 FROM radgroupcheck,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE 
Username = 'user' ORDER BY id'
query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE 
Username = 'user' ORDER BY id
radius_xlat:  'SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op 
 FROM radgroupreply,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
query:  SELECT 
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op 
 FROM radgroupreply,usergroup WHERE usergroup.Username = 'user' AND 
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
radius_xlat:  ''
query:
MYSQL check_error: 1065 received
rlm_sql_authorize: database query error
rlm_sql: Released sql socket id: 4
  modcall[authorize]: module sql returns fail
modcall: group authorize returns fail
Finished request 0
...


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html