Calling-Station-id not being used in SQLAcct, but is in q.931

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am using SQLAcct, and tryuing to store the ${calling-station-id), but I always get the IP:port instead. When looking at the call trace in level 4 debug mode, I see the correct calling-station-id in the q931 messages. I thought the ip:port was only to be inserted if the calling-station-id was unavailable?

 

From gnugk.ini

StopQuery=INSERT INTO cdr (gkname, sessid, callno, username, calling, called, setup, connect,disconnect,duration, disconnectcause,dest_ip,orig_ip) VALUES ('%g', '%s', %n, '%u', '%{Calling-Station-Id}', '%{Called-Station-Id}', '%{setup-time}','%{connect-time}','%{disconnect-time}',%d, %c,'%{callee-ip}','%{caller-ip}')

 

From debug

2004/11/16 04:21:39.032 5       ProxyChannel.cxx(472)   Q931s   Reading from 216.13.46.xxx:11654

2004/11/16 04:21:39.032 3       ProxyChannel.cxx(681)   Q931s   Received: Setup CRV=15055 from 216.13.46.xxx:11654

2004/11/16 04:21:39.038 4       ProxyChannel.cxx(634)   Q931    Received: {

  q931pdu = {

    protocolDiscriminator = 8

    callReference = 15055

    from = originator

    messageType = Setup

    IE: Bearer-Capability = {

      80 90 a3                                           ...

    }

    IE: Calling-Party-Number = {

      21 83 38 31 33 38 31 37  34 32 30 34               !.813817xxxx

    }

    IE: Called-Party-Number = {

      a1 31 35 31 34 39 30 35  33 35 33 33               .1514905xxxx

    }

 

2004/11/16 04:21:45.844 1             RasTbl.cxx(1940)  CDR|79804|d8 16 7b 02 36 bd 11 d9 b6 af c8 61 b8 84 29 e9|6|Tue, 16 Nov 2004 04:21:39 GMT|Tue, 16 Nov 2004 04:21:45 GMT|216.13.46.110:11654| |160.79.23.xxx:1720|4538_endp|1514905xxxx:dialedDigits||compassgk.planet-telecom.com;^M

 

2004/11/16 04:21:45.845 5              gksql.cxx(347)   SQLAcct Executing query: INSERT INTO cdr (gkname, sessid, callno, username, calling, called, setup, connect,disconnect,duration, disconnectcause,dest_ip,orig_ip) VALUES ('compassgk.xxx.com', '4141240b000137bc', 79804, '216.13.46.xxx', '216.13.46.xxx:11654', '1514905xxxx', '04:21:39.000 GMT Tue Nov 16 2004','04:21:39.000 GMT Tue Nov 16 2004','04:21:45.000 GMT Tue Nov 16 2004',6, 10,'160.79.23.xxx','216.13.46.xxx')

 

I searched the list archive but couldn’t find related problems. Am running latest CVS on linux.


[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux