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/
