Was it for some undefined destination prefix? I found a similar problem and I think we can remove the NOT NULL constraint from the table. ----- Original Message ----- From: "Abano, Fernando A. (ePerformax)" <fabano@xxxxxxxxxxxxxx> Sent: Tuesday, August 03, 2004 4:36 PM > I have found the problem, and it was not related to gnugk but to sqlbill > (I am using the latest CVS). Here's that part of the radius log. > > I modified c_voipcall.sql from: > > tariffdesc TEXT NOT NULL DEFAULT '', > > To: > > tariffdesc TEXT NULL DEFAULT '', > > And the update went in successfully, and the call was placed. I do not > know if I missed anything during my setup of the billing, or if there is > indeed a bug in the postgresql.conf (which does not provide for the > tariffdesc value during the insert of the start/stop) > > > > Fri Jul 30 02:39:39 2004 : Error: rlm_sql (sql): Couldn't update SQL > accounting for START packet - ERROR: null value in column "tariffdesc" > violates not-null constraint > Fri Jul 30 02:39:39 2004 : Error: rlm_sql (sql): failed after re-connect > Fri Jul 30 02:39:39 2004 : Error: rlm_sql (sql): Couldn't update > SQLaccounting START record - ERROR: function throwex() does not exist > Fri Jul 30 02:39:41 2004 : Error: Dropping packet from client > ECPI-GK-INTERNAL:54961 - ID: 26 due to dead request 1 > Fri Jul 30 02:39:43 2004 : Error: rlm_sql: Stop packet with zero session > length. (user '00026b01086f', nas '203.104.94.205') > Fri Jul 30 02:39:43 2004 : Error: rlm_sql (sql): failed after re-connect > Fri Jul 30 02:39:43 2004 : Error: rlm_sql: Couldn't insert SQL > accounting STOP record - ERROR: null value in column "tariffdesc" > violates not-null constraint > F ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
