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 -----Original Message----- From: openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx [mailto:openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Stewart Nelson Sent: Sunday, August 01, 2004 3:06 PM To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: Help Hi Fernando, > I was set ProxyForNAT=1 since the start but it does not help. Sorry, I don't know what might be wrong. We have sites where ProxyForNAT works quite well, and other sites with Cisco ATA186 EPs behind various NATs, including Linksys BEFSR41 (ProxyForNAT not needed). See if it works when your EP behind the Linksys is in DMZ (try with ProxyForNAT on, and also with it off). If not, you will have to troubleshoot what is going wrong. First, is the problem related to NAT? Can you test the EP that is behind the Linksys on a public IP? If that works, it should not be hard to use a tool such as Ethereal (on both sides of the NAT if necessary) to track what packets are present, if they have correct addresses and port numbers, etc. The trace functions built into gnugk, and those that your EPs might have, may also be useful. > Would you > know if there is some kind of development that handles encapsulation > of these packets so that they reach their destination EPs whether the > EP is NATed or not? Am very new to this, but wouldn't it be nice if > there is some kind of functionality that has an ability to preserve > the packets even if they are inside a firewall. This is a complex issue, because H.323 has IP addresses and port numbers in both H.225 and H.245 . With simple networks, it usually works fine to put an endpoint in the DMZ of a NAT, or to configure the NAT so that the call signaling, H.245, and media packets are forwarded to the EP. There are also NATs that have an application gateway for H.323 . For more complex systems, e.g. multiple EPs behind the same NAT, you can put another GK behind the NAT, around the NAT, or have it function as the NAT. I don't know what to recommend in your case, because it appears to me that it should work as you have it set up. Maybe someone else on the list will recognize your problem; otherwise you'll have to debug it. If all else fails, use SIP ;) --Stewart ------------------------------------------------------- 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/
