Hello
I found in the mailing-list that there are escaped characters. It is not
clear for me why is this needed.... could you non-escape characters
: (colon), (space)?
Thanks in advance,
Thomas
On Fri, 7 Jun 2002, Thomas Jalsovsky wrote:
>
> Hello,
>
> I use today's CVS (2002 June 7). I found a problem with
> accounting. When the value contains space char '.' or ':' the ascii
> (probably) value is used. It is bad for me, because the system uses values
> what are received and stored into SQL as is. The detail file looks well,
> but my SQL (MySQL) records are wrong
> e.g.
> in place of: 95BB3EF3 78CF11D6 A817D89C D849DCD6
> i have in the DB:
> 95BB3EF3=2078CF11D6=20A817D89C=20D849DCD6
>
> Where can I turn this off or solve this problem?
>
> Regards,
> Thomas
>
> p.s.: I use Cisco NAS-es and in production I have cisco_vsa_hack turned
> on, but now I tried without this feature and without the preprocess
> module, but the problem still exists.
>
>
> rad_recv: Accounting-Request packet from host 127.0.0.1:34338, id=14,
> length=263
> Cisco-NAS-Port = "ISDN 0:D:1"
> NAS-Port-Type = Async
> User-Name = "0908181984"
> Acct-Status-Type = Start
> Service-Type = Login-User
> h323-gw-id = "PosTel-5300.postel.sk"
> h323-incoming-conf-id = "95BB3EF3 78CF11D6 A817D89C D849DCD6"
> h323-call-origin = "answer"
> h323-call-type = "Telephony"
> h323-setup-time = "00:00:01.964 SKS Fri Jun 7 2002"
> h323-conf-id = "95BB3EF3 78CF11D6 A817D89C D849DCD6"
> Acct-Session-Id = "0003F00A"
> modcall: entering group preacct
> rlm_realm: Looking up realm NULL for User-Name = "0908181984"
> rlm_realm: No such realm NULL
> modcall[preacct]: module "suffix" returns noop
> modcall[preacct]: module "files" returns noop
> modcall[preacct]: module "preprocess" returns noop
> modcall: group preacct returns noop
> modcall: entering group accounting
> rlm_acct_unique: Hashing 'h323-conf-id = "95BB3EF3 78CF11D6 A817D89C
> D849DCD6",,Client-IP-Address = 127.0.0.1,NAS-IP-Address =
> 127.0.0.1,Acct-Session-Id = "0003F00A",h323-setup-time = "00:00:01.964 SKS
> Fri Jun 7 2002"'
> rlm_acct_unique: Acct-Unique-Session-ID = "c8619f14262d90ed".
> modcall[accounting]: module "acct_unique" returns ok
> radius_xlat: '/gis/radius2/var/log/127.0.0.1/20020607'
> rlm_detail: /gis/radius2/var/log/%{NAS-IP-Address}/%D expands to
> /gis/radius2/var/log/127.0.0.1/20020607
> modcall[accounting]: module "detail_arch" returns ok modcall: entering
> group group radius_xlat: 'INSERT IGNORE into radacct_test
>
>(SessionId,InConfId,UserName,NASIPAddress,NASPortId,CallingStationId,CalledStationId,CallOrigin,CallType,SetupTime)
> values
>
>('c8619f14262d90ed','95BB3EF3=2078CF11D6=20A817D89C=20D849DCD6','0908181984','127.0.0.1','ISDN=200=3AD=3A1','','','answer','Telephony','00=3A00=3A01.964=20SKS=20Fri=20Jun=207=202002')'
> rlm_sql: Reserving sql socket id: 19 rlm_sql: Released sql socket id: 19
> modcall[accounting]: module "sql_primary" returns ok
> modcall: group group returns ok
> modcall: group accounting returns ok
> Sending Accounting-Response of id 14 to 127.0.0.1:34338
> Finished request 10
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
