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:[email protected]
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/
