RE: Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux