Hi Karoly, you are running your gatekeeper in direct mode, where all call signalling is bypassing GnuGk. In that case Gnugk is only able to log the end of the call. I would suggest you put your gatekeeper in routed mode, so GnuGk gets control over the full call. Then it will be able to log all event types. [RoutedMode] GKRouted=1 Regards, Jan -- Jan Willamowius, Founder of the GNU Gatekeeper Project EMail : jan@xxxxxxxxxxxxxx Website: https://www.gnugk.org Support: https://www.willamowius.com/gnugk-support.html Relaxed Communications GmbH Frahmredder 91 22393 Hamburg Geschäftsführer: Jan Willamowius HRB 125261 (Amtsgericht Hamburg) USt-IdNr: DE286003584 Karoly Albert Szabo wrote: > Hi all, > > I'm currently trying to store and manage CDR informations, but I can't log > the start (or other events except for the stop event) event neither in > the StatusAcct, nor in the SQLAcct section. > I tried to fall back to the example found in the manual, but it seems that > only the close event is logged. > > My Gateway at the moment is a VidyoGateway, and the testing call is made > through a Polycom and a Vidyo Room with some other partecipants. > > This is the current configuration: > [Gatekeeper::Main] > TraceLevel=5 > Name=GnuGk > > [LogFile] > Filename=/var/log/gnugk/trace.log > Rotate=weekly > RotateDay=Sun > RotateTime=4:00 > > [GkStatus::Auth] > rule=allow > > [Gatekeeper::Acct] > StatusAcct=optional;start,stop,update,alert,connect,register,unregister > SQLAcct=required;start,stop,update > FileAcct=sufficient;stop > default=accept > > [StatusAcct] > TimestampFormat=ISO8601 > > [FileAcct] > DetailFile=/var/log/gnugk/cdr.log > StandardCDRFormat=0 > TimestampFormat=ISO8601 > CDRString=CDR|%n|%{CallId}|%d|%{connect-time}|%{disconnect-time}|%{caller-ip}:%{caller-port}|%{caller-epid}|%{callee-ip}:%{callee-port}|%{callee-epid}|%{dest-info}|%{src-info}|%g; > Rotate=daily > RotateTime=23:59 > > [SQLAcct] > Driver=PostgreSQL > Host=localhost:5432 > Database=gnugk > Username=gnugk > Password=gnugk > > MinPoolSize=5 > TimestampFormat=ISO8601 > StartQuery=insert into cdr (gatekeeper_name, call_number, call_duration, > disconnect_cause, acct_session_id, h323_id, gkip, call_id, conf_id, > setup_time, connect_time, disconnect_time, caller_ip, caller_port, > callee_ip, callee_port, src_info, dest_info, calling_station_id, > called_station_id, dialed_number) values ('%g', '%n', %d, %c, '%s', '%u', > '%{gkip}', '%{CallId}', '%{ConfId}', '%{setup-time}', '%{connect-time}', > null, '%{caller-ip}', '%{caller-port}', '%{callee-ip}', '%{callee-port}', > '%{src-info}', '%{dest-info}', '%{Calling-Station-Id}', > '%{Called-Station-Id}', '%{Dialed-Number}') > UpdateQuery=update cdr set call_duration=%d where gatekeeper_name='%g' and > acct_session_id='%s' > StopQuery=update cdr set call_duration=%d, disconnect_cause=%c, > disconnect_time='%{disconnect-time}' where gatekeeper_name='%g' and > acct_session_id='%s' > StopQueryAlt=insert into cdr (gatekeeper_name, call_number, call_duration, > disconnect_cause, acct_session_id, h323_id, gkip, call_id, conf_id, > setup_time, connect_time, disconnect_time, caller_ip, caller_port, > callee_ip, callee_port, src_info, dest_info, calling_station_id, > called_station_id, dialed_number) values ('%g STOP', '%n', %d, %c, '%s', > '%u', '%{gkip}', '%{CallId}', '%{ConfId}', '%{setup-time}', > '%{connect-time}', '%{disconnect-time}', '%{caller-ip}', '%{caller-port}', > '%{callee-ip}', '%{callee-port}', '%{src-info}', '%{dest-info}', > '%{Calling-Station-Id}', '%{Called-Station-Id}', '%{Dialed-Number}') > > > And this is the SQL schema (only the StopQueryAlt seems to be executed > succesfully. In the logs, I found that the update too try to run but of > course, without the inital row it can't update) > CREATE TABLE cdr > ( > gatekeeper_name VARCHAR(255) DEFAULT NULL::character varying, > call_number INTEGER, > call_duration INTEGER, > disconnect_cause SMALLINT, > acct_session_id VARCHAR(255) DEFAULT NULL::character varying, > h323_id VARCHAR(255) DEFAULT NULL::character varying, > gkip VARCHAR(15) DEFAULT NULL::character varying, > call_id VARCHAR(255), > conf_id VARCHAR(255) DEFAULT NULL::character varying, > setup_time VARCHAR(255) DEFAULT NULL::character varying, > connect_time VARCHAR(255) DEFAULT NULL::character varying, > disconnect_time VARCHAR(255) DEFAULT NULL::character varying, > caller_ip VARCHAR(15) DEFAULT NULL::character varying, > caller_port SMALLINT, > callee_ip VARCHAR(15) DEFAULT NULL::character varying, > callee_port SMALLINT, > src_info VARCHAR(255) DEFAULT NULL::character varying, > dest_info VARCHAR(255) DEFAULT NULL::character varying, > calling_station_id VARCHAR(255) DEFAULT NULL::character varying, > called_station_id VARCHAR(255) DEFAULT NULL::character varying, > dialed_number VARCHAR(255) DEFAULT NULL::character varying > ); > > > I try to be as complete as possible, from the status channel I get the > following: > RCF|192.168.5.168:1720 > |3650:dialedDigits=polycomlab:h323_ID|terminal|3693921710_endp > ; > UCF|192.168.5.168|3693921710_endp; > RCF|192.168.5.168:1720 > |3650:dialedDigits=polycomlab:h323_ID|terminal|3693921710_endp > ; > ACF|192.168.13.56:1720 > |347342409_endp|6357|polycomlab:h323_ID|101103:h323_ID|false|38-d1-e6-8f-f6-af-e6-11-9a-45-00-50-56-9d-6a-8d|ToBeDecided; > ACF|192.168.5.168:1720|3693921710_endp|22222|polycomlab:h323_ID||true|38-d1-e6-8f-f6-af-e6-11-9a-45-00-50-56-9d-6a-8d| > ; > CDR|17|38 d1 e6 8f f6 af e6 11 9a 45 00 50 56 9d 6a 8d|31|Wed, 23 Nov 2016 > 15:26:56 +01:00|Wed, 23 Nov 2016 15:27:27 +01:00|192.168.13.56:1720 > |347342409_endp|192.168.5.168:1720 > |3693921710_endp|polycomlab:h323_ID|101103:h323_ID|GnuGk; > CALL|Stop|192.168.13.56:1720|192.168.5.168:1720 > |38-d1-e6-8f-f6-af-e6-11-9a-45-00-50-56-9d-6a-8d > DCF|192.168.13.56|347342409_endp|6357|normalDrop|38-d1-e6-8f-f6-af-e6-11-9a-45-00-50-56-9d-6a-8d; > DCF|192.168.5.168|3693921710_endp|22222|normalDrop|38-d1-e6-8f-f6-af-e6-11-9a-45-00-50-56-9d-6a-8d; > > > Any help will be really appreciated, > > Best regards, > Karoly ------------------------------------------------------------------------------ _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
