Re: Billing with SqlAcct

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

 



Currently you cannot without modifying the source code. You would need
to pass additional options during MySQL client library initialization.

----- Original Message ----- 
From: "Pavel Eremin" <firestation@xxxxxxx>
Sent: Tuesday, November 21, 2006 7:54 AM


> My trouble is:
>
> When gnugk make request like "start", "stop" or "update" to MySQL, MySQL 
> may delay response up to 60 seconds. So, gnugk doesn't know that request 
> is fail and continue waitng for response from MySQL.
>
> How can i tell to gnuGK something like this: Don't wait so long time, just 
> do next step (for Exapmle: next step is [FileAcct])?
> This is pie of my gnugk.conf:
>
> [Gatekeeper::Acct]
> SQLAcct=alternative;start,update,stop
> FileAcct=sufficient;stop
> default=accept
>
> [SQLAcct]
> Driver=MySQL
> Host=#HOST
> Database=insys
> Username=voip_acct
> Password=#passwprd
> MinPoolSize=10
> StartQuery=INSERT INTO stat__voip_call (gkname, session, callno, start, 
> stop, user_alias, caller_number, called_number, caller_ ...
> StartQueryAlt=UPDATE stat__voip_call SET user_alias = '%u', caller_number 
> = '%{Calling-Station-Id}', called_number = '%{Called-...
> UpdateQuery=UPDATE stat__voip_call SET duration = %d WHERE gkname = '%g' 
> AND session = '%s'...
> StopQuery=UPDATE stat__voip_call SET stop = NOW(), user_alias = '%u', 
> caller_number = '%{Calling-Station-Id}', called_number =...
> StopQueryAlt=INSERT INTO stat__voip_call (gkname, session, callno, start, 
> stop, user_alias, caller_number, called_number, calle ...


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________________

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