Thank you for the information Jan, I will try tracing it to see where the problem is with the sqlite database. The database is already created, but am not sure about the schema, I am also a bit of a database newbie. I had a hard time with compiling so I relied on installing gnugk from a ready built repository on Ubuntu. Speaking of which, attached you will find the startup script for Ubuntu, slightly modified so that it does a -ttt on startup instead of no trace level. I noticed there wasn't one for Ubuntu in the etc directory of the sources folder. Thanks again! -----Original Message----- From: Jan Willamowius [mailto:jan@xxxxxxxxxxxxxx] Sent: Thursday, July 10, 2014 1:14 PM To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: Call accounting assistance Hi Josh, GnuGk 3.6 compiles fine on Ubuntu. http://www.gnugk.org/compiling-gnugk.html Your idea about how SQL accounting works is also correct. Just make sure you create the database and schema before you run GnuGk. I'd suggest you turn on level 5 tracing when you make a test call. If anything goes wrong with accounting, you'll see an error message in the trace. Best regards, Jan -- Jan Willamowius, Founder of the GNU Gatekeeper Project EMail : jan@xxxxxxxxxxxxxx Website: http://www.gnugk.org Support: http://www.willamowius.com/gnugk-support.html Relaxed Communications GmbH Frahmredder 91 22393 Hamburg Geschäftsführer: Jan Willamowius HRB 125261 (Amtsgericht Hamburg) USt-IdNr: DE286003584 Josh Rogalski wrote: > Hello, I am currently working with a development setup for GNU Gatekeeper to try and get call accounting working with an SQLite database. I have it running on an Ubuntu 14 system, and we are running the latest version Ubuntu's repositories allow which I think is 3.4, not sure if there is a way to update to 3.6, but that is another question. > > My question is, what am I doing wrong? When Ubuntu starts the gatekeeper, I assumed the way it works is it reads the config file, it takes my SQLite queries I have in the config file, and then runs them each time a call is made to put them into the database. Is this correct or do I have to do something additional? My config for the database queries is below. I am a bit of a newbie with gnugatekeeper, any help is greatly appreciated: > > > > [SQLAcct] > #This section and the one below are used to define some of the > database information for keeping a history of calls. Note - under > Database, enter the FULL path location of the sqlite database file > Driver=SQLite Host=localhost > Database=/var/www/html/sqlite_database/Delphi_Main.db > MinPoolSize=50 > #This attribute "MinPoolSize" refers to the number of active SQL connections. Adjust for performance. > > > > > StartQuery=insert into call VALUES('%g', '%s', %n, '%u', > '%{Calling-Station-Id}', '%{Called-Station-Id}', %d, %c) StartQueryAlt=UPDATE call SET username = '%u', calling = '%{Calling-Station-Id}', called = '%{Called-Station-Id}', duration = %d, disconnectcause = %c WHERE gkname = '%g' AND sessid = '%s' > UpdateQuery=UPDATE call SET duration = %d WHERE gkname = '%g' AND sessid = '%s' > StopQuery=UPDATE call SET username = '%u', calling = '%{Calling-Station-Id}', called = '%{Called-Station-Id}', duration = %d, disconnectcause = %c WHERE gkname = '%g' AND sessid = '%s' > StopQueryAlt=INSERT INTO call (gkname, sessid, callno, username, > calling, called, duration, disconnectcause) VALUES ('%g', '%s', %n, > '%u', '%{Calling-Station-Id}', '%{Called-Station-Id}', %d, %c) > TimestampFormat=MySQL > > [Josh Signature January 2012] > ------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft _______________________________________________________ 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/
Attachment:
gnugk
Description: gnugk
------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft
_______________________________________________________ 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/
