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/
