Re: [Openh323gk-users] Accounting problem: can't log start event

[Jan W. <ja...@wi...>]

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  : ja...@wi...
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