|
Hello List,
I have problem with Sql accounting. Log
error:
----------------------------
sqlacct.cxx(261) GKACCT SQLAcct
failed to store accounting data (event: 2, call: 1): SQL connection not
active
------------------------------
Gnugk: Gatekeeper(GNU) Version(2.0.8)
Ext(pthreads=1,acct=1,radius=1,mysql=1,pgsql=1,ldap=0,large_fdset=0)
Build(Jun 1 2004, 00:47:39) Sys(Linux i686 2.4.20-8)
gnugk.ini:
--------------------
[Gatekeeper::Acct]
##acctmod=SQLAcct SQLAcct=required;start,stop #FileAcct=required [SQLAcct]
Driver=PostgreSQL Host=localhost Database=asterisk Username=postgres Password=1234567 MinPoolSize=5 StartQuery=INSERT INTO cdr323 (gkname, sessid, username, calling, called) VALUES........... StopQuery=UPDATE cdr323 SET duration = %d WHERE gkname = '%g' AND sessid = '%s'.............. ---------------------------
I can connect to PostgreSQL via pgAdmin III from
remote computer.
Thanks for your Help,
Serge.
|
