Billing with SqlAcct

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

 



Hi, All!
 
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