I'm using pre-compiled gnugk ver2.0.8 running on win2k3...
These are queryes from gatekeeper.ini:
StartQuery=INSERT INTO cdr (gkID, sessionID, duration, h323ID, cause,
callerID, callerIP, calledID, calledIP) VALUES ('%g', '%S', %d, '%u', %c,
'%{Calling-Station-Id}', '%{caller-ip}','%{Called-Station-Id}',
'%{callee-ip}');
UpdateQuery=UPDATE cdr SET duration = %d where gkID =
'%g' and sessionID = '%s';
StopQuery=UPDATE cdr SET duration = %d, h323ID
= '%u', cause = %c, callerID = '%{Calling-Station-Id}', calledID =
'%{Called-Station-Id}', WHERE gkID = '%g' AND sessionID = '%s';
sessionID is generated:
callIdentifier =
{
guid = 16
octets
{
fd
0e fc 3d a8 f0 18 10 94 48 00 01 02 15 d4 cf
but gnugk doesn't send it to mysql in startquery...
From: Michal Zygmuntowicz <m@on...>
Re: GnuGK + MySQL
2004-07-28 03:58
I"d recommend checking the INSERT query - does it contain
"%s"?
Maybe you mistyped something. I just checked the latest 2.0
cvs
and it works fine. What gatekeeper version are you
using?
On Wed, 2004-07-28 at 12:10, Borisov
wrote:
> I want gnuGK write CDR into Mysql database, but i"ve
got such a
> problem:
>
> SQLAcct
Executing query: INSERT INTO cdr (gkID, sessionID, duration,
>
h323ID, cause, callerID, callerIP, calledID, calledIP) VALUES
>
("OpenH323GK", "", 0, "h323", 0, "100",
"192.168.68.223","100",
> "192.168.68.223");
>
> Gnugk doesn"t send sessionID, it send it only when trying to
update
> the call:
>
> SQLAcct
Executing query: UPDATE cdr SET duration = 0, h323ID = "h323",
>
cause = 17, callerID = "100", calledID = "100", WHERE gkID =
>
"OpenH323GK" AND sessionID = "4106577e00000001";
>
> of cource it can"t do this because mysql can"t find
"sessionID =
> "4106577e00000001"" and the call isn"t
updates...
>
> Could anyone point on my
mistake?
>
> Thanks.
________________________________________________
Отправлено с почтового сервиса 74mail.ru
------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
