Attribute names are case sensitive, so '%S' is not the same
as '%s'. You should use '%s'.
On Wed, 2004-07-28 at 13:56, Borisov wrote:
> 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@xxxxx>
> 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.
-------------------------------------------------------
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/
