Re: Accounting problem: can't log start event

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=3D1

Regards,
Jan

-- =

Jan Willamowius, Founder of the GNU Gatekeeper Project
EMail  : [email protected]
Website: https://www.gnugk.org
Support: https://www.willamowius.com/gnugk-support.html

Relaxed Communications GmbH
Frahmredder 91
22393 Hamburg
Gesch=E4ftsf=FChrer: 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=3D5
> Name=3DGnuGk
> =

> [LogFile]
> Filename=3D/var/log/gnugk/trace.log
> Rotate=3Dweekly
> RotateDay=3DSun
> RotateTime=3D4:00
> =

> [GkStatus::Auth]
> rule=3Dallow
> =

> [Gatekeeper::Acct]
> StatusAcct=3Doptional;start,stop,update,alert,connect,register,unregister
> SQLAcct=3Drequired;start,stop,update
> FileAcct=3Dsufficient;stop
> default=3Daccept
> =

> [StatusAcct]
> TimestampFormat=3DISO8601
> =

> [FileAcct]
> DetailFile=3D/var/log/gnugk/cdr.log
> StandardCDRFormat=3D0
> TimestampFormat=3DISO8601
> CDRString=3DCDR|%n|%{CallId}|%d|%{connect-time}|%{disconnect-time}|%{call=
er-ip}:%{caller-port}|%{caller-epid}|%{callee-ip}:%{callee-port}|%{callee-e=
pid}|%{dest-info}|%{src-info}|%g;
> Rotate=3Ddaily
> RotateTime=3D23:59
> =

> [SQLAcct]
> Driver=3DPostgreSQL
> Host=3Dlocalhost:5432
> Database=3Dgnugk
> Username=3Dgnugk
> Password=3Dgnugk
> =

> MinPoolSize=3D5
> TimestampFormat=3DISO8601
> StartQuery=3Dinsert 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=3Dupdate cdr set call_duration=3D%d where gatekeeper_name=3D'=
%g' and
> acct_session_id=3D'%s'
> StopQuery=3Dupdate cdr set call_duration=3D%d, disconnect_cause=3D%c,
> disconnect_time=3D'%{disconnect-time}' where gatekeeper_name=3D'%g' and
> acct_session_id=3D'%s'
> StopQueryAlt=3Dinsert into cdr (gatekeeper_name, call_number, call_durati=
on,
> 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=3Dpolycomlab:h323_ID|terminal|3693921710_endp
> ;
> UCF|192.168.5.168|3693921710_endp;
> RCF|192.168.5.168:1720
> |3650:dialedDigits=3Dpolycomlab: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-1=
1-9a-45-00-50-56-9d-6a-8d;
> =

> =

> Any help will be really appreciated,
> =

> Best regards,
> Karoly


---------------------------------------------------------------------------=
---
_______________________________________________________

Posting: mailto:[email protected]
Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=3Dopenh323=
gk-users
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/