Re: Acct-Session-Id special characters changed to hex
Thanks alot. Apologies, should have read the documentation more carefully. Regards, Sajeewa Warnakulasuriya Systems Development Manager ispONE is a wholesale ISP built to help internet access resellers and independent ISPs to compete in the Australian marketplace through ONE Brand, ONE Provider, ONE Solution. Level 14 520 Collins Street Melbourne 3000 VIC Phone: 1300 663 400 Fax: 1300 665 400 E-Mail: sajee...@ispone.com.au Web:http://www.ispone.com.au/ On Wed, 27 May 2009, Alan DeKok wrote: Sajeewa Warnakulasuriya wrote: I'm having some issues with the acct-session-id, where special characters for instance [] being converted to it's hex equivalent. See the safe-characters configuration in the SQL module. For example below, the Acct-Session-Id = 301[]426932183 when inserted into the accounting table it is inserted as 301=5B=5D426932183. Hmm... not many NASes send [] in Acct-Session-Id, for precisely this reason. What NAS is it? Why is it sending those attributes? I have noticed the same happens with the sql-group. Please advise how I could insert the data as received without conversion. Read the SQL configuration. This *is* documented. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Acct-Session-Id special characters changed to hex
Sajeewa Warnakulasuriya wrote: I'm having some issues with the acct-session-id, where special characters for instance [] being converted to it's hex equivalent. See the safe-characters configuration in the SQL module. For example below, the Acct-Session-Id = 301[]426932183 when inserted into the accounting table it is inserted as 301=5B=5D426932183. Hmm... not many NASes send [] in Acct-Session-Id, for precisely this reason. What NAS is it? Why is it sending those attributes? I have noticed the same happens with the sql-group. Please advise how I could insert the data as received without conversion. Read the SQL configuration. This *is* documented. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Acct-Session-Id special characters changed to hex
Hi All,
I'm having some issues with the acct-session-id, where special characters
for instance [] being converted to it's hex equivalent.
For example below, the Acct-Session-Id = 301[]426932183 when inserted
into the accounting table it is inserted as 301=5B=5D426932183.
I have noticed the same happens with the sql-group.
Please advise how I could insert the data as received without conversion.
Thanks
Sajeewa @ ispONE
==
Wed May 27 09:19:48 2009 : Info: FreeRADIUS Version 2.0.4, for host
i486-pc-linux-gnu, built on Sep 7 2008 at 23:35:34
Wed May 27 09:19:48 2009 : Info: Copyright (C) 1999-2008 The FreeRADIUS
server project and contributors.
Wed May 27 09:19:48 2009 : Info: There is NO warranty; not even for
MERCHANTABILITY or FITNESS FOR A
Wed May 27 09:19:48 2009 : Info: PARTICULAR PURPOSE.
Wed May 27 09:19:48 2009 : Info: You may redistribute copies of FreeRADIUS
under the terms of the
Wed May 27 09:19:48 2009 : Info: GNU General Public License.
Wed May 27 09:19:48 2009 : Info: Starting - reading configuration files
...
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/radiusd_dial.conf
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/proxy_dial.conf
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/clients_dial.conf
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/sql_dial.conf
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/sql_prepaid_counter.conf
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/policy.conf
Wed May 27 09:19:48 2009 : Debug: including files in directory
/etc/freeradius/sites-enabled/
Wed May 27 09:19:48 2009 : Debug: including configuration file
/etc/freeradius/sites-enabled/default_dial
Wed May 27 09:19:48 2009 : Debug: including dictionary file
/etc/freeradius/dictionary
Wed May 27 09:19:48 2009 : Debug: main {
Wed May 27 09:19:48 2009 : Debug: prefix = /usr
Wed May 27 09:19:48 2009 : Debug: localstatedir = /var
Wed May 27 09:19:48 2009 : Debug: logdir = /var/log/freeradius
Wed May 27 09:19:48 2009 : Debug: libdir = /usr/lib/freeradius
Wed May 27 09:19:48 2009 : Debug: radacctdir =
/var/log/freeradius/radacct
Wed May 27 09:19:48 2009 : Debug: hostname_lookups = no
Wed May 27 09:19:48 2009 : Debug: max_request_time = 30
Wed May 27 09:19:48 2009 : Debug: cleanup_delay = 5
Wed May 27 09:19:48 2009 : Debug: max_requests = 1024
Wed May 27 09:19:48 2009 : Debug: allow_core_dumps = no
Wed May 27 09:19:48 2009 : Debug: pidfile =
/var/run/freeradius/freeradius_dial.pid
Wed May 27 09:19:48 2009 : Debug: user = freerad
Wed May 27 09:19:48 2009 : Debug: group = freerad
Wed May 27 09:19:48 2009 : Debug: checkrad = /usr/sbin/checkrad
Wed May 27 09:19:48 2009 : Debug: debug_level = 0
Wed May 27 09:19:48 2009 : Debug: proxy_requests = yes
Wed May 27 09:19:48 2009 : Debug: security {
Wed May 27 09:19:48 2009 : Debug: max_attributes = 200
Wed May 27 09:19:48 2009 : Debug: reject_delay = 0
Wed May 27 09:19:48 2009 : Debug: status_server = yes
Wed May 27 09:19:48 2009 : Debug: }
Wed May 27 09:19:48 2009 : Debug: }
Wed May 27 09:19:48 2009 : Debug: client 144.130.4.5 {
Wed May 27 09:19:48 2009 : Debug: ipaddr = 144.130.4.5
Wed May 27 09:19:48 2009 : Debug: require_message_authenticator = no
Wed May 27 09:19:48 2009 : Debug: secret = 11oneONEV6
Wed May 27 09:19:48 2009 : Debug: shortname = telstra-1
Wed May 27 09:19:48 2009 : Debug: nastype = other
Wed May 27 09:19:48 2009 : Debug: }
Wed May 27 09:19:48 2009 : Debug: client 144.130.7.5 {
Wed May 27 09:19:48 2009 : Debug: ipaddr = 144.130.7.5
Wed May 27 09:19:48 2009 : Debug: require_message_authenticator = no
Wed May 27 09:19:48 2009 : Debug: secret = 11oneONEV6
Wed May 27 09:19:48 2009 : Debug: shortname = telstra-2
Wed May 27 09:19:48 2009 : Debug: nastype = other
Wed May 27 09:19:48 2009 : Debug: }
Wed May 27 09:19:48 2009 : Debug: client 192.168.0.19 {
Wed May 27 09:19:48 2009 : Debug: ipaddr = 192.168.0.19
Wed May 27 09:19:48 2009 : Debug: require_message_authenticator = no
Wed May 27 09:19:48 2009 : Debug: secret = 11oneONEV6
Wed May 27 09:19:48 2009 : Debug: shortname = test-1
Wed May 27 09:19:48 2009 : Debug: nastype = other
Wed May 27 09:19:48 2009 : Debug: }
Wed May 27 09:19:48 2009 : Debug: client 192.168.0.212 {
Wed May 27 09:19:48 2009 : Debug: ipaddr = 192.168.0.212
Wed May 27 09:19:48 2009 : Debug: require_message_authenticator = no
Wed May 27 09:19:48 2009 : Debug: secret = secret
Wed May 27 09:19:48 2009 : Debug: shortname = test-2
Wed May 27 09:19:48 2009 : Debug: nastype = other
Wed May 27 09:19:48 2009 : Debug: }
Wed May
