Re: Problems with freeradius set up

2006-10-25 Thread Mike Pearson
Thanks Stefan that worked! Now I have one more problem.  We give our user a time limit on how much time they can be online for and that seems to be a sticking point.  I didn't get an error when I was testing because I had unlimited time and did not have that field in the database, but when I

Problems with freeradius set up

2006-10-24 Thread Mike Pearson
I'm new to the list and I'm having problems getting freeradius to authenticate users. I migrated from an old server running gnu-radius to a new server running freeradius both servers are using mysql. I made sure the tables in mysql match what freeradius required, I also made sure that the

Re: Problems with freeradius set up

2006-10-24 Thread Stefan Winter
Hi, nicely done problem report! My guess is that your tables contain a check item that is not satisfied by the incoming requests. Could you do a SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'mpearson' ORDER BY id (this is one of the SQL statements in the debug output.

Re: Problems with freeradius set up

2006-10-24 Thread Alan DeKok
Mike Pearson [EMAIL PROTECTED] wrote: My problems is I can't get the users to authenticate, I pasted the output from radtest and radiusd -X. I can provide any more information that my be needed. Ok... radius_xlat: 'SELECT

Re: Problems with freeradius set up

2006-10-24 Thread Mike Pearson
Thanks for the reply Stefan, Here is the output from mysql for the statement below: mysql SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username - = 'mpearson' ORDER BY id - - ; +--+--+--+++ | id | UserName | Attribute | Value | op |

Re: Problems with freeradius set up

2006-10-24 Thread Mike Pearson
There is an entry for mpearson in my database but not that select statement. What should be in the radgroupreply and the radreply tables? I don't have any data in either of those tables. Thank Mike Alan DeKok wrote: Mike Pearson [EMAIL PROTECTED] wrote: My problems is I can't

Re: Problems with freeradius set up

2006-10-24 Thread Stefan Winter
+--+--+--+++ | 1118 | mpearson | Password | | == | | 1119 | mpearson | Simultaneous-Use | 1 | == | +--+--+--+++ 2 rows in set (0.29 sec) You want to force the user to only have one login