Re: Re: Re: Re: SQLBill problem. SQL query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Make sure the gatekeeper runs in signaling routed mode.
Also the queries do not match. The first one looks more
like StopQuery.

----- Original Message ----- From: "Farid Adigamov" <farid.adigamov@xxxxxxxxx>
Sent: Thursday, November 10, 2005 11:35 PM


This query was clear of time params.
LOG:  statement: UPDATE voipcall SET
acctstoptime = (now() - '0'::INTERVAL),
duration = '20',
terminatecause = '10',
acctstopdelay = '0',
setuptime = NULLIF('', '')::TIMESTAMP(0) WITH TIME ZONE,
connecttime = NULLIF('', '')::TIMESTAMP(0) WITH TIME ZONE,
disconnecttime = NULLIF('', '')::TIMESTAMP(0) WITH TIME ZONE
WHERE acctsessionid = '4373fdec00000002'
AND gkip = 'Y.Y.Y.Y'::INET AND acctstoptime IS NULL

It is set in config like:
UpdateQuery=UPDATE voipcall SET duration = '%d', connecttime =
NULLIF('%{connect-time}','')::TIMESTAMP(0) WITH TIME ZONE,
acctupdatetime = now() WHERE acctsessionid = '%s' AND gkid = '%g' AND
acctstoptime IS NULL

is it bug? =\

thx
/Farid



-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux