> SQLAcct=start,stop,update
This is incorrect syntax. Try to add 'required' or other keyword.
Also having INSERT two times seems to be inapprotiate, unless
you are inserting into two distinct tables.
Another this is that you are using analog line. If this line does not have
answer supervision, you will never get a proper call duration (the line
answers immediatelly, billing you for the ring too).
----- Original Message -----
From: "Santosh" <santosh_tripathi@xxxxxxxxxxxxxx>
Sent: Tuesday, May 19, 2009 12:10 PM
>I must appreciate for your quick responce..Thank you buddy.
> I have both (Start and Stop) queries configured.Can you please look at the
> content and tell me what's wrong in the file.
>
> [Gatekeeper::Main]
> Fourtytwo=42
> Name=OpenH323GK
>
> [GkStatus::Auth]
> rule=allow
>
> [RoutedMode]
> GKRouted=1
> H245Routed=1
> AcceptUnregisteredCalls=1
>
> [RasSrv::GWPrefixes]
> TESTSV=0
> Gesprek1=0,1,2,3,4,5,6,7,8,9
>
> [RasSrv::PermanentEndpoints]
> 192.168.5.57=Gesprek1;1010, 84
> 192.168.5.142:1720=101
> 192.168.5.193:1720=102
> 192.168.5.84:1720=103
> 192.168.5.77:1720=104
> 192.168.5.1:1720=105
>
> [Gatekeeper::Acct]
> SQLAcct=start,stop,update
> FileAcct=required;start,update,stop,on,off
>
> [SQLAcct]
> Driver=MySQL
> Host=localhost
> Database=Billing
> Username=root
> Password=1234
> StartQuery=INSERT INTO ...
> StopQuery=INSERT INTO ...
> UpdateQuery=UPDATE ...
> TimestampFormat=MySQL
>
> [FileAcct]
> DetailFile=C:\GNUGK.LOG
> CDRString=%{caller-ip}|%s|%{callee-ip}|%t|%d|%p|%{setup-time}|%{alerting-time}|%{connect-time}|%{disconnect-time}|%{ring-time}|%{dest-info}
> TimestampFormat=MySQL
>
> The problem can be simulated like
>
> Time Events
> (Sec)
> 1 End point1 calls End Point 2 which is a PSTN(analog Line)
> 5 After 4 secs(at 5th sec) the End Point2 which is a analog
> line starts ringing.
> 10 End point 2 picks up the receiver and starts talking
> 20 End point E1 disconnects the call
>
> So in my case my billing duration(call duration) should be 10sec( From 10th
> second to 20th Second).But in my case my callduration is showing as 18 sec
> which is wrong.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx>
> To: "GNU Gatekeeper Users" <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx>
> Sent: Tuesday, May 19, 2009 2:37 PM
> Subject: Re: how to get the actual call duration
>
>
>> GKRouted=1 should be enough. If you don't get a proper call duration in
>> %d,
>> your problem is elsewhere. You need to provide more details on what you
>> are
>> receiving in SQLAcct query. Maybe you have configured StartQuery instead
>> of StopQuery.
>>
>> ----- Original Message -----
>> From: "Santosh" <santosh_tripathi@xxxxxxxxxxxxxx>
>> Sent: Tuesday, May 19, 2009 10:39 AM
>>
>>
>>>I have already used routed mode.Still the problem is same.
>>> my config file is like below:
>>>
>>> [RoutedMode]
>>> GKRouted=1
>>> H245Routed=1
>>> Do I need to add something else?
>>> Regards,
>>> Santosh
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________________
Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
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/
