Question on SQLite

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

 



In a little bit, we'll be updating to the MacOSX binary for 2.2.8, with SQLite. I'd like to get some call accounting going (we use gnugk for H323 videoconferencing) so we can have some stats.

I was looking around for a sample schema for SQLite, but didn't find one. I figure I can crack that together, tho.

How does this look for a SQLite accounting config, assuming a database of gnugkstats with table "call"? In particular, I'm concerned about the Database directive... I've never worked with SQLite, but I assume you have to provide a patch (or separate conf file) to say where the gnugkstatsdb is located, since there is no server process.

Here goes nothing:

[Gatekeeper::Acct]
SQLAcct=optional;start,stop,update

[SQLAcct]
Driver=SQLite
Database=/var/sqlite/gkstatsdb
Usersname=gnugk
Password=Secret
Startquery=INSERT INTO call (gkname, sessid, username, calling, called)
        VALUES ('%g', '%s', '%u', '%{Calling-Station-Id}', '%{Called-Station-Id}')'
UpdateQuery=UPDATE call SET duration = %d WHERE gkname = '%g' AND sessid = '%s'
StopQuery=PDATE call SET duration = %d, dtime = '%{disconnect-time}' WHERE gkname = '%g' AND sessid = '%s'


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________________

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/

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

  Powered by Linux