Sending Access Accept when Request comes from a particular IP

2009-07-01 Thread Mauro Iorio - Smart Soft s.r.l.
Is it possible to send an Access Accept Packet every time an Access Request is sent from a specified source ip only??? Is there an example configuration I can read? Thanks, Mauro Iorio Smart Soft s.r.l. BEGIN:VCARD VERSION:2.1 N:Iorio;Mauro;;Ing. FN:Ing. Mauro Iorio (m.io

freeradius and mobile number portability (MNP)

2009-06-26 Thread Mauro Iorio - Smart Soft s.r.l.
ight way. I will really appreciate any help, ideas, doc, sample code, whatever. Thanks, Mauro Iorio Smart Soft s.r.l. BEGIN:VCARD VERSION:2.1 N:Iorio;Mauro;;Ing. FN:Ing. Mauro Iorio (m.io...@smartsoft.it) TEL;WORK;VOICE:+39 (081) 5196606 TEL;CELL;VOICE:+39 3336334993 TEL;WORK;FAX:+3

R: Sql Counter reads only the first 4 digits

2009-05-21 Thread Mauro Iorio - Smart Soft s.r.l.
> > Uh... no. > > If it works for Ivan, then the problem is most likely in the unixodbc > drivers. > > Alan DeKok. > > But when I run the same query in both isql and tsql the result is correct. So I think that unixodbc and freetds are ok. I'll try to recompile them anyway... Other idea

Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
> > > > Don't bother with all that. Hardcode just: > > > > SELECT 123456 > > > > Ivan Kalik > > Kalik Informatika ISP > > > > > > Done. Same result: 1234. > > Mauro Iorio. > > Any configuration parameter hidden somewhere which limits result lenght to 4 digits??? Mauro Iorio. - List info/sub

R: R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
> > Don't bother with all that. Hardcode just: > > SELECT 123456 > > Ivan Kalik > Kalik Informatika ISP > > Done. Same result: 1234. Mauro Iorio. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

R: Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
> > What happens when you replace that SELECT statement with a hard-coded > number, like 123456? Does it still truncate the result? > > Alan DeKok. > Yes, it does. Check the following output: - rlm_sqlcounter: Entering module authorize code sqlcoun

Sql Counter reads only the first 4 digits

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
Hi all, I've a strange problem with sql counter on freeradius both 1.1.7 and 2.1.5 versions. Actually executing SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='mauro' from SQL Server Management Studio gives me 294841 (Yes, that's a lot of seconds, is a test user) while the

[no subject]

2009-05-20 Thread Mauro Iorio - Smart Soft s.r.l.
Hi all, I've a strange problem with sql counter on freeradius both 1.1.7 and 2.1.5 versions. Actually executing SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='mauro' from SQL Server Management Studio gives me 294841 (Yes, that's a lot of seconds, is a test user) while the

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

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

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 tabl

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 fi

Newbie & EAP/TLS

2008-04-28 Thread Mauro Iorio - Smart Soft s.r.l.
Hi all, sorry for this newbie question, but I was wondering if there's a way to implement EAP/TLS in freeradius. Does freeradius support TLS? Is there any documentation about it? Any information would be very appreciated. Thank You, Mauro Iorio - List info/subscribe/unsubscribe? See h