Re: usergroup and radgroupcheck problem!

2009-11-15 Thread Hamid Reza Hasani
Hi,(salaam) Thanks for your help, But I solved the problem and I changed the radgroupcheck query so it get groupname from usergroup table and then compare it! I think I have a better solution, isn't it? BTW thank for your help, please inform me if you know why this problem exist? is it a bug? Ya

Re: usergroup and radgroupcheck problem!

2009-11-14 Thread tnt
It looks like you have edited sql queries and mixed user and group queries. Post the part of the startup debug with sql initializing. Ivan Kalik Kalik Informatika ISP Thanks for your response, I attached full log. authorize_check_query = SELECT id, groupname, attribute, Value, op

Re: usergroup and radgroupcheck problem!

2009-11-13 Thread Hamid Reza Hasani
It looks like you have edited sql queries and mixed user and group queries. Post the part of the startup debug with sql initializing. Ivan Kalik Kalik Informatika ISP Thanks for your response, I attached full log. Ya Ali Hamid Reza Hasani radius.log Description: Binary data - List

usergroup and radgroupcheck problem!

2009-11-12 Thread Hamid Reza Hasani
Hi, (Salam) I'm using last version of freeradius. when my users are going to connect, I see this message: [sql] expand: %{User-Name} - myuser [sql] sql_set_user escaped user -- 'myuser' rlm_sql (sql): Reserving sql socket id: 2 [sql] expand: SELECT id, groupname, attribute, Value,

Re: usergroup and radgroupcheck problem!

2009-11-12 Thread tnt
if you look at them carefully, you can see there is a bit problem! my freeradius is read radgroupcheck before usergroup table, so it can't recognize user's group name for radgroupcheck query! so it can't read radgroupcheck attributes! where is my fault? can I change it priority? It looks