Re: Have a prob, not quite sure what... Help!!?!?

2002-09-20 Thread Artur Hecker 

> rlm_sql: Reserving sql socket id: 4
> MYSQL check_error: 1146 received
> rlm_sql_getvpdata: database query error
> rlm_sql:  SQL query error; rejecting user
> rlm_sql: Released sql socket id: 4
>   modcall[authorize]: module "sql" returns fail
> modcall: group authorize returns fail
> There was no response configured: rejecting request 0
> Server rejecting request 0.

user is rejected because something is wrong with your mysql
configuration or setup. try verifying that.

ciao
artur


-- 
Artur Hecker
artur[at]hecker.info

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

Re: Have a prob, not quite sure what... Help!!?!?

2002-09-20 Thread Kevin Bonner 

On Friday 20 September 2002 15:00, [EMAIL PROTECTED] wrote:
> radius_xlat:  'SELECT users.ID,username,networks.name as net FROM
> users,network WHERE users.network=networks.ID && Username = 'test''

Unless something new has been released, I don't think you can use ampersands 
in mysql queries.  Try using 'AND' instead.

Kevin

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