March 2010 - Freeradius-Users - lists.freeradius.org

patch for dictionary.redback
by Alexander Kubatkin 22 Mar '10

22 Mar '10

dictionary_redback.gz - dictionary for radiator "dictionary_redback Updated Feb 17, 2009 (jbacker) " dictionary.redback.patch.gz - patch for dictionary.redback from freeradius, based on dictionary_redback. -- __________________________________________________ Alexander Kubatkin

1 1

Max Query Length Exceeded and Field Truncated
by Robert Gabriel 21 Mar '10

21 Mar '10

Hello all, Our network had some change somewhere and now all MySQL insert queries are failing with the last field been truncated and the character count is always 4097 from the CDRs been sent by our NAS (Acme Packet SBC). Having looked at the source we see: src/modules/rlm_sql/conf.h src/modules/rlm_sql/rlm_sql.c /* SQL defines */ #define MAX_QUERY_LEN 4096 #define SQL_LOCK_LEN MAX_QUERY_LEN I'm not sure here, can we just increase to 8192 etc. or is this being stupid? Can I edit the above and recompile? Unfortunately we are running FreeRADIUS 1.1.7 and yes, everyone must be screaming upgrade! Linux klio 2.6.24-21-server #1 SMP Wed Oct 22 00:18:13 UTC 2008 i686 GNU/Linux. MySQL 5.0.51a-3ubuntu5.4-log. I've looked at the above files in 2.1.8 and the values are the same. Does this mean an upgrade will not fix this? The RADIUS RFC says a maximum length of 4096, is this what we are breaking or something else? Please advise as to the best solution. FreeRADIUS log: Wed Mar 17 16:10:50 2010 : Error: rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to y our MySQL server version for the right syntax to use near ''sip:0827355754@hugetipjhb01' at line 1' MySQL log (shortened for brevity's sake): INSERT into accounting (AcctStatusType, AcctTerminateCause, CalledStationId, NASIdentifier, h323setuptime, h323connecttime, h323disconnecttime, h323disconnectcause) values ('0', '0', '0', '0', '0', '0', '0', 'sip:0738063114@h >From the FreeRADIUS SQL trace (shortened for brevity's sake): INSERT into accounting (AcctStatusType, AcctTerminateCause, CalledStationId, NASIdentifier, h323setuptime, h323connecttime, h323disconnecttime, h323disconnectcause, CallingRTCPMaxLatency_FS1, CallingRTPPacketsLost_FS1, CallingRTPAvgJitter_FS1, CallingRTPMaxJitter_FS1, SessionIngressRealm, SessionEgressRealm, SessionProtocolType) values ('196.31.63.118', '15830', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'sip:0823246912@;

5 10

fouzet azzaoui
by Benjamin Marvin 21 Mar '10

21 Mar '10

http://jeswinjames24.com/Emilie.html _________________________________________________________________ Hotmail: posta elettronica con funzioni avanzate e gratuita, con la protezione Microsoft. https://signup.live.com/signup.aspx?id=60969

1 0

Limit Bandwith
by sugiarto tjahyono 20 Mar '10

20 Mar '10

Sorry if this topic already posted or on wrong forum How can we set speed if the user already over quota ie first day of month they get 1Mbps bandwith after spent 1Gig the speed will decrease to 512Kbps until end of month without turning off modem and re-authenticate. is that possible? Lebih Bersih, Lebih Baik, Lebih Cepat - Rasakan Yahoo! Mail baru yang Lebih Cepat hari ini! http://id.mail.yahoo.com

4 4

Traffic Accounting Update
by Teguh Kurniawan 20 Mar '10

20 Mar '10

Hi, My traffic accounting was running well. The problem is, accounting only update once when client is disconnected. Is possible, accounting update in a given time, eg every 5 minutes. I use FR 2.1.8 with mysql 5.5. Thank's Teguh Kurniawan

3 4

serge bothorel
by Benjamin Marvin 20 Mar '10

20 Mar '10

http://acasianverbe.com/Rachel.html _________________________________________________________________ Hotmail: posta elettronica attendibile grazie alla protezione avanzata Microsoft dalla posta indesiderata. https://signup.live.com/signup.aspx?id=60969

1 0

(no subject)
by Richie Lee 20 Mar '10

20 Mar '10

http://www.advanza.com.br/aR7N4ClASY.html _________________________________________________________________ Take your contacts everywhere http://go.microsoft.com/?linkid=9712959

1 0

Re: log_badlogins include SRC IP Address
by Gary Gatten 19 Mar '10

19 Mar '10

First, you need to make sure the "client" (switch, not host) is providing that info. ________________________________ From: freeradius-users-bounces+ggatten=waddell.com(a)lists.freeradius.org <freeradius-users-bounces+ggatten=waddell.com(a)lists.freeradius.org> To: freeradius-users(a)lists.freeradius.org <freeradius-users(a)lists.freeradius.org> Sent: Fri Mar 19 18:05:35 2010 Subject: log_badlogins include SRC IP Address Hi, I am trying to configure the log_badlogins to include the src IP address of the client host. I am noticing that in the radius.log does not include the src IP. Example. Fri Mar 19 15:11:39 2010 : Auth: Login incorrect: [jack] (from client testswitch port 0) Does anyone know how to change either radius or syslog-ng to include the src ip of the host that is attempting to break in? -Eric <font size="1"> <div style='border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in'> </div> "This email is intended to be reviewed by only the intended recipient and may contain information that is privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any review, use, dissemination, disclosure or copying of this email and its attachments, if any, is strictly prohibited. If you have received this email in error, please immediately notify the sender by return email and delete this email from your system." </font>

1 0

log_badlogins include SRC IP Address
by Eric.Hernandez＠allegiantair.com 19 Mar '10

19 Mar '10

1 0

Re: NAS type when NAS is stored in SQL?
by John Doppke 19 Mar '10

19 Mar '10

-- -John >>> On 3/19/2010 at 4:21 PM, <freeradius-users-request(a)lists.freeradius.org> wrote: > t does if the info is there: > > SELECT id, nasname, shortname, type, secret FROM ${nas_table} > > (in fact, it can also populate the 'server' too - add that as last > option in the SELECT - latest version of FreeRADIUS only!) > > what does the server say when you start - ie radiusd -X > > alan > I think this is the relevent part: radius_db = "radius" read_groups = yes sqltrace = yes sqltracefile = "/var/log/radius/sqltrace.sql" readclients = yes deletestalesessions = yes num_sql_socks = 5 lifetime = 0 max_queries = 0 sql_user_name = "%{User-Name}" default_user_profile = "sqldefault" nas_query = "SELECT id, nasname, shortname, type, secret FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op Also: rlm_sql (sql): Processing generate_sql_clients rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret FROM nas rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: query: SELECT id, nasname, shortname, type, secret FROM nas rlm_sql (sql): Read entry nasname=192.168.41.233,shortname= LAFAYETTE-IN-WAP10,secret=xxx rlm_sql (sql): Adding client 192.168.41.233 ( LAFAYETTE-IN-WAP10, server=<none>) to clients list rlm_sql (sql): Read entry nasname=140.171.181.215,shortname= WAP16,secret=xxx rlm_sql (sql): Adding client 192.168.181.215 ( WAP16, server=<none>) to clients list ...

1 0