Hi Kim,
SQLite will create a file for the database when you create the schema
and you just point to it from the GnuGk config:
Driver=SQLite
Database=/var/sqlite/gkstatsdb.db
Username and Password are ignored for SQLite.
Regards,
Jan
Kim Cary wrote:
> 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'
--
Jan Willamowius, jan@xxxxxxxxxxxxxx, http://www.gnugk.org/
------------------------------------------------------------------------------
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/
