The problem is that gatekeeper IP is not correctly set in the query. Maybe you did a typo in your config? If you look at the log, you will see that instead of gatekeeper IP, '' is passed.
----- Original Message ----- From: "viva leong" <vivapc@xxxxxxxxx>
Sent: Friday, December 03, 2004 10:10 PM
is that possible using sqlbill in gnugk 2.0.8 or 2.0.9 i got some problem, can anyone tell me what is this problem mean? thank.
2004/12/04 05:01:36.937 5 gksql.cxx(338) SQLAcct Executing query: INSERT INTO voipcall (id, h323id, acctsessionid, h323confid, gkip, gkid, callingstationip, callingstationid, calledstationip, calledstationid, setuptime, acctstarttime, acctstartdelay, acctupdatetime) VALUES (DEFAULT, '2AFXS', '41b0d2fb00000001', '02 b2 22 4c 73 4a 1c 2f 3d 8f 00 01 a8 01 07 de', '', 'GK', NULLIF('192.168.1.115', '')::INET, '983999', NULLIF('10.10.111.222', '')::INET, '9820938', NULLIF('05:01:36.000 MYT Sat Dec 04 2004', '')::TIMESTAMP(0) WITH TIME ZONE, now(), 0, now()) 2004/12/04 05:01:37.165 2 sqlacct.cxx(305) GKACCT SQLAcct failed to store accounting data (event: 1, call: 1): (7) ERROR: invalid input syntax for type inet: ""
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
