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
*[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
*[SQLAcct]*
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
--------------------[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
[email protected][db] *established successfully*
2010/04/02 14:51:00.203 3 gksql.cxx(169) SQLAcct Database connection
pool created: [email protected][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
--------------------------------
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)
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:[email protected]
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/
