RE: sql autentification problem
Hmm, my fault. You are using dialup_admin right? Grab version 1.16. It should work better. I am using ldap for authentication/authorization so the mysql code has not been tested. Well for that part it worked now I have a different problem: Mon Nov 12 17:53:03 2001 : Error: rlm_sql: unknown attribute Max-Weekly-Session Mon Nov 12 17:53:03 2001 : Error: rlm_sql: Error getting data from database Mon Nov 12 17:53:03 2001 : Error: rlm_sql: SQL query error; rejecting user Mon Nov 12 17:53:03 2001 : Auth: Invalid user: [test123/test] (from nas spiller port 0) Looks like it's the same type of error If this email looks weird I appologise I sent it using outlok :)) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: sql autentification problem
On Mon, Nov 12, 2001 at 06:04:33PM +0100, Galileo wrote: Hmm, my fault. You are using dialup_admin right? Grab version 1.16. It should work better. I am using ldap for authentication/authorization so the mysql code has not been tested. Well for that part it worked now I have a different problem: Mon Nov 12 17:53:03 2001 : Error: rlm_sql: unknown attribute Max-Weekly-Session Mon Nov 12 17:53:03 2001 : Error: rlm_sql: Error getting data from database Mon Nov 12 17:53:03 2001 : Error: rlm_sql: SQL query error; rejecting user Mon Nov 12 17:53:03 2001 : Auth: Invalid user: [test123/test] (from nas spiller port 0) Looks like it's the same type of error If this email looks weird I appologise I sent it using outlok :)) and again grep Max-Weekly-Session /usr/local/etc/raddb/dictionary* doesn't show a result ... find out where you defined Max-Weekly-Session and throw it away .. delete that attribute, and do so for every other Attrib FR complains about ... This is the easiest way ... cheers Andreas Faust - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: sql autentification problem
On Mon, 12 Nov 2001, Galileo wrote: Hmm, my fault. You are using dialup_admin right? Grab version 1.16. It should work better. I am using ldap for authentication/authorization so the mysql code has not been tested. Well for that part it worked now I have a different problem: Mon Nov 12 17:53:03 2001 : Error: rlm_sql: unknown attribute Max-Weekly-Session Mon Nov 12 17:53:03 2001 : Error: rlm_sql: Error getting data from database Mon Nov 12 17:53:03 2001 : Error: rlm_sql: SQL query error; rejecting user Mon Nov 12 17:53:03 2001 : Auth: Invalid user: [test123/test] (from nas spiller port 0) Looks like it's the same type of error If this email looks weird I appologise I sent it using outlok :)) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Grr, funny I thought I fixed that. Anyway, here goes 1.16.5 attached. I would prefer that we don't bomb the list with my stupid mistakes. If you find any problems please send them in a personal mail. Thnaks -- kkalev dialup_admin-1.16.5.tar.gz Description: Binary data
Re: sql autentification problem
On Mon, Nov 12, 2001 at 04:07:37AM +0100, Galileo wrote: please run radiusd with -xx for debugging Here is the output, I used ntradping to try to autentificate if that has any significance. Crypt-Password = AOEaujPvYmy/c Crypt-Password = AOEaujPvYmy/c Simultaneous-Use = 1 rlm_sql: unknown attribute Dialup-Access rlm_sql: Error getting data from database rlm_sql: SQL query error; rejecting user rlm_sql: Released sql socket id: 4 modcall[authorize]: module sql returns invalid modcall: group authorize returns invalid Invalid user: [test2/test] (from nas spiller port 0) Sending Access-Reject of id 2 to 194.247.208.202:1261 Finished request 0 Going to the next request Thread 1 waiting to be assigned a request --- Walking the entire request list --- Threads: total/active/spare threads = 5/0/5 Cleaning up request 0 ID 2 with timestamp 3bef3bbd Nothing to do. Sleeping until we see a request. Doing a grep over the dictionary files, I couldn't find any Attribute named Dialup-Access. Have you defined something like that in one of your files, or your Database ? If so, please keep in mind, that you are only allowed to use Attributes which are defined in the Dictionaries. cheers Andreas Faust - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html