Hi Michal, I was using 1 for my prefix, and dstid of 1 is in the voiptariff. I am also check why aside from that error below, the account is also not getting charged for the call -----Original Message----- From: openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx [mailto:openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Zygmuntowicz Michal Sent: Wednesday, August 04, 2004 5:00 AM To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: Help 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/ ------------------------------------------------------- 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/
