radreply - I need help
I realy apologize for posting this dummy question again to the list, but I can't find solutions What kind of info do I need to set in radreply table of MySql to avoid any error in log file when I do not need to send any reply to the NAS. I act only as remote proxed server with only user/password auth. Leaving the table radreply empty I got this error: Fri Nov 22 18:45:00 2002 : Error: rlm_sql_authorize: no rows returned from query (no such user) ... each rows: Fri Nov 22 18:45:00 2002 : Error: rlm_sql_authorize: no rows returned from query (no such user) Fri Nov 22 18:45:00 2002 : Auth: Login OK: [giancarlo] (from nas easy@1 port 2070 cli 54942324) Fri Nov 22 18:48:00 2002 : Error: rlm_sql_authorize: no rows returned from query (no such user) Fri Nov 22 18:48:00 2002 : Auth: Login OK: [giancarlo] (from nas easy@1 port 2070 cli 54942324) many thanks my config --- mysql select * from radcheck; ++---+---+--+--+ | id | UserName | Attribute | Value| op | ++---+---+--+--+ | 1 | giancarlo | User-Password | hp3ehp3 | == | ++---+---+--+--+ mysql select * from radgroupcheck; ++---+---++--+ | id | GroupName | Attribute | Value | op | ++---+---++--+ | 1 | stop | Auth-Type | reject | := | ++---+---++--+ mysql select * from radgroupreply; ++---+---+---+--+--+ | id | GroupName | Attribute | Value | op | prio | ++---+---+---+--+--+ | 1 | dialin| Auth-Type | PAP | =: |0 | ++---+---+---+--+--+ 1 row in set (0.00 sec) mysql select * from radreply; Empty set (0.00 sec) mysql select * from usergroup; ++---+---+ | id | UserName | GroupName | ++---+---+ | 1 | giancarlo | dialin| ++---+---+ 2 rows in set (0.00 sec) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radreply - I need help
Glomanet Informa - [EMAIL PROTECTED] wrote: What kind of info do I need to set in radreply table of MySql to avoid any error in log file when I do not need to send any reply to the NAS. I act only as remote proxed server with only user/password auth. You can add a dummy non-protocol attribute. e.g. Menu = 1 Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
R: radreply - I need help
Sorry, same as usually Thu Dec 5 18:20:17 2002 : Error: rlm_sql_authorize: no rows returned from query (no such user) Thu Dec 5 18:29:19 2002 : Auth: Login OK: [pippo] (from nas easy@3 port 18434 cli 12942324) in radack mysql select * from radcheck where username=comsoften; ++---+---+--+--+ | id | UserName | Attribute | Value| op | ++---+---+--+--+ | 1 | pippo | User-Password | pluto| == | ++---+---+--+--+ in radreply: mysql select * from radreply; ++---+---+---+--+ | id | UserName | Attribute | Value | op | ++---+---+---+--+ | 1 | pippo | Menu | 1 | =| ++---+---+---+--+ -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Per conto di Alan DeKok Inviato: giovedì 5 dicembre 2002 18.03 A: [EMAIL PROTECTED] Oggetto: Re: radreply - I need help Glomanet Informa - [EMAIL PROTECTED] wrote: What kind of info do I need to set in radreply table of MySql to avoid any error in log file when I do not need to send any reply to the NAS. I act only as remote proxed server with only user/password auth. You can add a dummy non-protocol attribute. e.g. Menu = 1 Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
