R: R: R: Common error on sql_counter on Ver 2.1.5

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
No, group *membership* query (when I write membership, I do mean membership). Have you just copied queries from the old version without looking if anything has changed? If you are upgrading from old version to a new one, which documentation should you follow - old or new? You opted for

R: R: Common error on sql_counter on Ver 2.1.5

2009-05-19 Thread Mauro Iorio - Smart Soft s.r.l.
PS. You have either disabled group checking or removed group membership query. Ivan Kalik Kalik Informatika ISP None of them. Group checking is enabled (read_groups = yes) and the query (authorize_group_check_query = SELECT ... ) is defined in sql module. But simply the query isn't

Re: R: R: Common error on sql_counter on Ver 2.1.5

2009-05-19 Thread Ivan Kalik
PS. You have either disabled group checking or removed group membership query. Ivan Kalik Kalik Informatika ISP None of them. Group checking is enabled (read_groups = yes) and the query (authorize_group_check_query = SELECT ... ) is defined in sql module. But simply the query isn't

Common error on sql_counter on Ver 2.1.5

2009-05-18 Thread Mauro Iorio - Smart Soft s.r.l.
Hi all, I recently installed freeradius Ver. 2.1.5 and I'm trying to configure it to work as a previous installation of Ver. 1.1.x. I'm stuck at sql counter module. On 1.1.x I use the common sessioncounter counter with sql module, but with 2.1.5 I got the message rlm_sqlcounter: Could not

Re: Common error on sql_counter on Ver 2.1.5

2009-05-18 Thread Ivan Kalik
I recently installed freeradius Ver. 2.1.5 and I'm trying to configure it to work as a previous installation of Ver. 1.1.x. I'm stuck at sql counter module. On 1.1.x I use the common sessioncounter counter with sql module, but with 2.1.5 I got the message rlm_sqlcounter: Could not find

R: Common error on sql_counter on Ver 2.1.5

2009-05-18 Thread Mauro Iorio - Smart Soft s.r.l.
User entry didn't match. Post the debug (radiusd -X) and the user entry. You wouldn't be using User-Password as the password attribute? From radcheck table Id UsernameAttribute Value op 7216mauro Passwordflower == From usergroup table Id

Re: R: Common error on sql_counter on Ver 2.1.5

2009-05-18 Thread Ivan Kalik
User entry didn't match. Post the debug (radiusd -X) and the user entry. You wouldn't be using User-Password as the password attribute? From radcheck table IdUsernameAttribute Value op 7216 mauro Passwordflower == Even worse. Password has

Re: R: Common error on sql_counter on Ver 2.1.5

2009-05-18 Thread Nicolas Goutte
Am 18.05.2009 um 18:15 schrieb Mauro Iorio - Smart Soft s.r.l.: User entry didn't match. Post the debug (radiusd -X) and the user entry. You wouldn't be using User-Password as the password attribute? From radcheck table Id UsernameAttribute Value op 7216

Re: R: Common error on sql_counter on Ver 2.1.5

2009-05-18 Thread Ivan Kalik
[sql] expand: %{User-Name} - mauro [sql] sql_set_user escaped user -- 'mauro' rlm_sql (sql): Reserving sql socket id: 0 [sql] expand: SELECT id, UserName, Attribute, Value, op FROM UtentiAutorizzati WHERE UserName = '%{SQL-User-Name}' AND MACADDWAN = '%{Called-Station-Id}' AND