Re: Basic freeradius set up problem [SOLVED]

2012-07-13 Thread Mik J
Hello Alan, Thank you for your answer. I may have not understood what you wrote. I replaced in /etc/raddb/sql/mysql/dialup.conf sql_user_name = '%{Stripped-User-Name}' by sql_user_name = '%{User-Name}' Hello lsclrstd, I have created a second user testuser2 with the

Re: Basic freeradius set up problem [SOLVED]

2012-07-13 Thread Alan DeKok
Mik J wrote: I finally solved my problem. My dialup.conf was empty with the exception of the statement I added. And dialup.conf is supposed to have some sql queries inside. For the test to work, the password should be 'Password' and not 'Cleartext-Password' NO. ABSOLUTELY NOT.

Basic freeradius set up problem

2012-07-11 Thread Mik J
Platform: OpenBSD 5.1 Version: 2.1.12 Hello, I have a problem setting up freeradius and I think it's related to the domain stripping Here's what I did for my configuration 1) Imported the scripts schema.sql, admin.sql, ippool.sql, nas.sql in my MySQL radiusdb database 2) Inserted a user:

Re: Basic freeradius set up problem

2012-07-11 Thread alan buxey
Hi, [sql]   expand: %{Stripped-User-Name} - [sql] sql_set_user escaped user -- '' rlm_sql (sql): Reserving sql socket id: 3 [sql]   expand:  - [sql] Error generating query; rejecting user rlm_sql (sql): Released sql socket id: 3 ++[sql] returns fail Stripped-User-Name not populated - so a

RES: Basic freeradius set up problem

2012-07-11 Thread lscrlstld
2) Inserted a user: INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('testuser', 'Password', 'passsecret'); Use 'Cleartext-Password' instead of 'Password' and try again. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Basic freeradius set up problem

2012-07-11 Thread Mik J
[sql]   expand: %{Stripped-User-Name} - [sql] sql_set_user escaped user -- '' rlm_sql (sql): Reserving sql socket id: 3 [sql]   expand:  - [sql] Error generating query; rejecting user rlm_sql (sql): Released sql socket id: 3 ++[sql] returns fail Stripped-User-Name not populated -

Re: Basic freeradius set up problem

2012-07-11 Thread Mik J
  [sql]   expand: %{Stripped-User-Name} -   [sql] sql_set_user escaped user -- ''   rlm_sql (sql): Reserving sql socket id: 3   [sql]   expand:  -   [sql] Error generating query; rejecting user   rlm_sql (sql): Released sql socket id: 3   ++[sql] returns fail Stripped-User-Name not

Re: Basic freeradius set up problem

2012-07-11 Thread alan buxey
Hi, [sql]   expand: %{User-Name} - testuser [sql] sql_set_user escaped user -- 'testuser' rlm_sql (sql): Reserving sql socket id: 4 [sql]   expand:  - [sql] Error generating query; rejecting user seems fair enough - there is no expansion for the query - so I would now check your

Re: RES: Basic freeradius set up problem

2012-07-11 Thread Alan DeKok
lscrlstld wrote: 2) Inserted a user: INSERT INTO radcheck (UserName, Attribute, Value) VALUES ('testuser', 'Password', 'passsecret'); Use 'Cleartext-Password' instead of 'Password' and try again. The Password attribute will be removed in 3.0. I'm thinking of deleting it in 2.2.0, too.