Re: 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]

 



It should work as you expect. Maybe there is some PWLib problem
with getting Calling-Station-Id - as it a bit unusual (0x21 0x83 first bytes).
I will check this issue.


----- Original Message ----- From: "david winter" <dwinter@xxxxxxxxxxxxxxxxxx>
Sent: Tuesday, November 16, 2004 5:32 AM



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-tel
ecom.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.



------------------------------------------------------- This SF.Net email is sponsored by: InterSystems CACHE FREE OODBMS DOWNLOAD - A multidimensional database that combines robust object and relational technologies, making it a perfect match for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8

_______________________________________________________

List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/

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

  Powered by Linux