The first place you should look at is your log file
- it usually contains some lines that will help to identify
the problem.
You should also notice, that there is not such parameter
as 'User' - you should use 'Username'. Read examples
and the manual carefully to avoid such bugs:)
Marian Rychtecky <marian@xxxxxxx> wrote:
>Hi,
>oh, sorry it\'s here:
>
>[Gatekeeper::Acct]
>SQLAcct=optional;start,stop,update
>FileAcct=optional;start,stop,update
>
>[FileAcct]
>DetailFile=/var/log/gk/cdr.log
>Rotate=0
>
>[SQLAcct]
>Driver=MySQL
>Host=ns.clnet.cz
>Database=gnugk
>User=gnugk
>Password=<pass>
>
>StartQuery=INSERT INTO billing (gkname, sessid, username, calling,
>called) VALUES (\'%g\', \'%s\', \'%u\', \'%{Calling-Station-Id}\',
>\'%{Called-Station-Id}\')
>
>UpdateQuery=UPDATE billing SET duration = %d WHERE gkname = \'%g\' AND
>sessid = \'%s\'
>
>StopQuery=UPDATE billing SET duration = %d, dtime = \'%{disconnect-time}\'
>WHERE gkname = \'%g\' AND sessid = \'%s\'
>
>StopQueryAlt=INSERT INTO billing (gkname, sessid, username, calling,
>called, duration) VALUES (\'%g\', \'%s\', \'%u\', \'%{Calling-Station-Id}\',
>\'%{Called-Station-Id}\', %d)
>
>but SQL still not work... work only storing into file...
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
