I set up Gnugk 2.3.1 and set the gk.ini to write to a Mysql database on registration/unregistration of endpoints. I already used SQLAcct to store endpoint calls (mostly copying hte module form the manual tho), so i thought it would be easy to set up. But for some reasons it seem like it's not that easy.
In gk.ini I entered the following lines (as you can see on SQLAccount i added the register and unregister events as well as I added the queries in the SQLAcct:
---------------gatekeeper.ini---------------------
[Gatekeeper::Acct]
SQLAcct=optional;start,stop,update,register,unregister
FileAcct=sufficient;stop
SQLAcct=optional;start,stop,update,register,unregister
FileAcct=sufficient;stop
[FileAcct]
DetailFile=c:\gk\calls.log
StandardCDRFormat=0
CDRString=%g|%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}
Rotate=daily
RotateTime=23:59
DetailFile=c:\gk\calls.log
StandardCDRFormat=0
CDRString=%g|%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}
Rotate=daily
RotateTime=23:59
[SQLAcct]
Driver=MySQL
Host=xx.xx.xx.xx:xxxx
Driver=MySQL
Host=xx.xx.xx.xx:xxxx
Database=db
Username=user
Password=password
StartQuery= insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%n', %d, %c, '%s', '%u', '%{gkip}', '%{CallId}', '%{ConfId}', '%{setup-time}', NULL, NULL, '%{caller-ip}', '%{caller-port}', '%{callee-ip}', '%{callee-port}', '%{src-info}', '%{dest-info}', '%{Calling-Station-Id}', '%{Called-Station-Id}', '%{Dialed-Number}')
StartQueryAlt= insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%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}')
UpdateQuery= update cdr set call_duration=%d, connect_time='%{connect-time}' where gatekeeper_name='%g' and acct_session_id='%s'
StopQuery= update cdr set call_duration=%d, connect_time='%{connect-time}', 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, 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) values ('%g STOP Alt', '%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}')
RegisterQuery= insert into registrazioni(H323ID, registrato, giorno, ora) VALUES ('%u', 'y', NOW(), NOW())
UnregisterQuery= insert into registrazioni(H323ID, registrato, giorno, ora) VALUES ('%u', 'n', NOW(), NOW())
TimestampFormat=MySQL
Password=password
StartQuery= insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%n', %d, %c, '%s', '%u', '%{gkip}', '%{CallId}', '%{ConfId}', '%{setup-time}', NULL, NULL, '%{caller-ip}', '%{caller-port}', '%{callee-ip}', '%{callee-port}', '%{src-info}', '%{dest-info}', '%{Calling-Station-Id}', '%{Called-Station-Id}', '%{Dialed-Number}')
StartQueryAlt= insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%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}')
UpdateQuery= update cdr set call_duration=%d, connect_time='%{connect-time}' where gatekeeper_name='%g' and acct_session_id='%s'
StopQuery= update cdr set call_duration=%d, connect_time='%{connect-time}', 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, 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) values ('%g STOP Alt', '%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}')
RegisterQuery= insert into registrazioni(H323ID, registrato, giorno, ora) VALUES ('%u', 'y', NOW(), NOW())
UnregisterQuery= insert into registrazioni(H323ID, registrato, giorno, ora) VALUES ('%u', 'n', NOW(), NOW())
TimestampFormat=MySQL
--------------------[end gatekeeper.ini]--------------------
BUT when Gnugk starts the -ttttt output reads like follows and it seems to skip the Register and Unregister query lines
----------------------
2010/04/02 14:51:00.171 1 gkacct.cxx(202) GKACCT Created module SQLAcct with event mask 7
2010/04/02 14:51:00.171 4 sqlacct.cxx(144) GKACCT SQLAcct start query: insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%n', %d, %c, '%s', '%u', '%{gkip}', '%{CallId}', '%{ConfId}', '%{setup-time}', NULL, NULL, '%{caller-ip}', '%{caller-port}', '%{callee-ip}', '%{callee-port}', '%{src-info}', '%{dest-info}', '%{Calling-Station-Id}', '%{Called-Station-Id}', '%{Dialed-Number}')
2010/04/02 14:51:00.171 4 sqlacct.cxx(148) GKACCT SQLAcct alternative start query: insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%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}')
2010/04/02 14:51:00.187 4 sqlacct.cxx(160) GKACCT SQLAcct update query: update cdr set call_duration=%d, connect_time='%{connect-time}' where gatekeeper_name='%g' and acct_session_id='%s'
2010/04/02 14:51:00.187 4 sqlacct.cxx(172) GKACCT SQLAcct stop query: update cdr set call_duration=%d, connect_time='%{connect-time}', disconnect_cause=%c, disconnect_time='%{disconnect-time}' where gatekeeper_name='%g' and acct_session_id='%s'
2010/04/02 14:51:00.187 4 sqlacct.cxx(177) GKACCT SQLAcct alternative stop query: insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g STOP Alt', '%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}')
2010/04/02 14:51:00.203 5 gksql_mysql.cxx(373) SQLAcct MySQL connection to user@xxxxxxxxxxxxxxx[db] established successfully
2010/04/02 14:51:00.203 3 gksql.cxx(169) SQLAcct Database connection pool created: user@xxxxxxxxxxxxxxx[db]
2010/04/02 14:51:00.171 4 sqlacct.cxx(144) GKACCT SQLAcct start query: insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%n', %d, %c, '%s', '%u', '%{gkip}', '%{CallId}', '%{ConfId}', '%{setup-time}', NULL, NULL, '%{caller-ip}', '%{caller-port}', '%{callee-ip}', '%{callee-port}', '%{src-info}', '%{dest-info}', '%{Calling-Station-Id}', '%{Called-Station-Id}', '%{Dialed-Number}')
2010/04/02 14:51:00.171 4 sqlacct.cxx(148) GKACCT SQLAcct alternative start query: insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g', '%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}')
2010/04/02 14:51:00.187 4 sqlacct.cxx(160) GKACCT SQLAcct update query: update cdr set call_duration=%d, connect_time='%{connect-time}' where gatekeeper_name='%g' and acct_session_id='%s'
2010/04/02 14:51:00.187 4 sqlacct.cxx(172) GKACCT SQLAcct stop query: update cdr set call_duration=%d, connect_time='%{connect-time}', disconnect_cause=%c, disconnect_time='%{disconnect-time}' where gatekeeper_name='%g' and acct_session_id='%s'
2010/04/02 14:51:00.187 4 sqlacct.cxx(177) GKACCT SQLAcct alternative stop query: insert into cdr (gatekeeper_name, call_number, call_duration, disconnect_cause, acct_session_id, h323_id, 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) values ('%g STOP Alt', '%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}')
2010/04/02 14:51:00.203 5 gksql_mysql.cxx(373) SQLAcct MySQL connection to user@xxxxxxxxxxxxxxx[db] established successfully
2010/04/02 14:51:00.203 3 gksql.cxx(169) SQLAcct Database connection pool created: user@xxxxxxxxxxxxxxx[db]
2010/04/02 14:51:00.203 5 gksql.cxx(173) SQLAcct Connection pool: 1 SQL connections created, 0 failed
2010/04/02 14:51:00.203 1 gkacct.cxx(202) GKACCT Created module FileAcct with event mask 2
2010/04/02 14:51:00.218 2 gkacct.cxx(626) GKACCT FileAcct CDR file: c:\gk\calls.log
2010/04/02 14:51:00.218 5 gkacct.cxx(667) GKACCT FileAcct daily rotation enabled (first rotation sheduled at Fri, 02 Apr 2010 23:59:00 +0200
2010/04/02 14:51:00.218 2 Routing.cxx(751) VQueue (CTI) Virtual queues disabled - no virtual queues configured
2010/04/02 14:51:00.218 2 singleton.cxx(25) Create instance: Routing::Analyzer(8)
2010/04/02 14:51:00.218 2 gkacct.cxx(1047) GKACCT Successfully logged event 8
2010/04/02 14:51:00.218 5 job.cxx(364) JOB Worker threads: 9 total - 9 busy, 0 idle
2010/04/02 14:51:00.218 5 job.cxx(170) JOB Worker 248 started
2010/04/02 14:51:00.218 5 job.cxx(190) JOB Starting Job HouseKeeping at Worker thread 248
2010/04/02 14:51:00.203 1 gkacct.cxx(202) GKACCT Created module FileAcct with event mask 2
2010/04/02 14:51:00.218 2 gkacct.cxx(626) GKACCT FileAcct CDR file: c:\gk\calls.log
2010/04/02 14:51:00.218 5 gkacct.cxx(667) GKACCT FileAcct daily rotation enabled (first rotation sheduled at Fri, 02 Apr 2010 23:59:00 +0200
2010/04/02 14:51:00.218 2 Routing.cxx(751) VQueue (CTI) Virtual queues disabled - no virtual queues configured
2010/04/02 14:51:00.218 2 singleton.cxx(25) Create instance: Routing::Analyzer(8)
2010/04/02 14:51:00.218 2 gkacct.cxx(1047) GKACCT Successfully logged event 8
2010/04/02 14:51:00.218 5 job.cxx(364) JOB Worker threads: 9 total - 9 busy, 0 idle
2010/04/02 14:51:00.218 5 job.cxx(170) JOB Worker 248 started
2010/04/02 14:51:00.218 5 job.cxx(190) JOB Starting Job HouseKeeping at Worker thread 248
--------------------------------
When i start Gnugk I start it like this on a Windows 2003 machine
C:\gk>gnugk -ttttt -o c:\gklog.txt -c c:\gk\gatekeeper.ini
GNU Gatekeeper with ID 'GNUgk2' started
Gatekeeper(GNU) Version(2.3.1) Ext(pthreads=0,radius=1,mysql=1,pgsql=0,firebird=0,odbc=1,sqlite=0,large_fdset=0,crypto/ssl=1,h46018=1,h46023=1) Build(Nov 26 2009, 14:05:00) Sys(Server 2003 i586 (Model=3 Stepping=4) v5.2.3790)
GNU Gatekeeper with ID 'GNUgk2' started
Gatekeeper(GNU) Version(2.3.1) Ext(pthreads=0,radius=1,mysql=1,pgsql=0,firebird=0,odbc=1,sqlite=0,large_fdset=0,crypto/ssl=1,h46018=1,h46023=1) Build(Nov 26 2009, 14:05:00) Sys(Server 2003 i586 (Model=3 Stepping=4) v5.2.3790)
What's wrong with my configuration?
thanks for any help,
pierlu
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________________ 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/
