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/
