Hi, again... :( Indeed it loaded without errors, but didn't work the way that it should. So let me explain the scenario: calls comes from GK1 and CLI must follow: 1) CLI=61.. should be changed to 999222261..; 2) CLI=any should prefix with 999, 'cose it's already a PSTN number. For this, in text rules I would make: [RewriteCLI] %r1% in:X.X.X.X=cli:61=999222261 %r2% in:X.X.X.X=cli:*=999 But how to program this using SQLConfig? How to declare/populate the configuration table? I already try Michal's sugestion, just ignoring the %% trick. This is the query return: RewriteCLI | in:X.X.X.X|cli:6*=99922226 RewriteCLI | in:X.X.X.X|cli:any*=999 But even not giving errors on load, it didn't work. It seams that the first line is completly ignored. Any call from GK1, phone 6105 is presented with CLI 9996105 on the destination. It should be 99922226105 Any ideas? Edson >-----Original Message----- >From: Edson [mailto:4lists@xxxxxxxxx] >Sent: quinta-feira, 1 de novembro de 2007 11:35 >To: 'GNU Gatekeeper Users' >Subject: RE: SQL Query for [RasSrv::GWRewriteE164] > >Hi... > >Just finished the tests, and loaded without. Thanks again. > >Edson > >>-----Original Message----- >>From: Edson [mailto:4lists@xxxxxxxxx] >>Sent: quinta-feira, 1 de novembro de 2007 09:47 >>To: 'GNU Gatekeeper Users' >>Subject: RE: SQL Query for [RasSrv::GWRewriteE164] >> >>Thanks for the response, Michal... >> >>I can't try it just now, but will return ASAP, after testing it... ;) >> >>Edson >> >>>-----Original Message----- >>>From: openh323gk-users-bounces@xxxxxxxxxxxxxxxxxxxxx [mailto:openh323gk- >>>users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Zygmuntowicz Michal >>>Sent: quinta-feira, 1 de novembro de 2007 08:38 >>>To: GNU Gatekeeper Users >>>Subject: Re: SQL Query for [RasSrv::GWRewriteE164] >>> >>>Try: >>>RewriteCLI | in:200.X.X.X|dno:0=12345 >>>RewriteCLI | in:200.X.X.X|cli:any*=11111 >>>RewriteCLI | in:200.Y.Y.Y|cli:777=88888 >>> >>>You don't need %% trick for SQL. >>> >>>----- Original Message ----- >>>From: "Edson" <4lists@xxxxxxxxx> >>>Sent: Wednesday, October 31, 2007 10:27 PM >>> >>> >>>> Hi, Michal >>>> >>>> Thanks for Your response, after some tests it's working fine... >>>> >>>> But now I come to another section: RewriteCLI. >>>> >>>> I make use os repeated rules, like in: >>>> ; GK1 >>>> %r1% in:200.X.X.X=dno:0=12345 >>>> %r2% in:200.X.X.X=cli:any*=11111 >>>> ; GK2 >>>> in:200.Y.Y.Y=cli:777=88888 >>>> >>>> So, my doubt is what is the key? Shouldn't the query return: >>>> >>>> RewriteCLI | %r1% in | 200.X.X.X=dno:0=12345 >>>> RewriteCLI | %r2% in | 200.X.X.X=cli:any*=11111 >>>> RewriteCLI | in | 200.Y.Y.Y=cli:777=88888 >>>> >>>> If I try this approach, it logs errors like: >>>> >>>> CLIRW Uknown CLI rewrite rule: in=200.X.X.X=cli:any*=11111 >>>> CLIRW Uknown CLI rewrite rule: in=200.Y.Y.Y=cli:777=88888 >>>> >>>> What's wrong? >>>> >>>> Edson >>> >>> >>>------------------------------------------------------------------------- >>>This SF.net email is sponsored by: Splunk Inc. >>>Still grepping through log files to find problems? Stop. >>>Now Search log events and configuration files using AJAX and a browser. >>>Download your FREE copy of Splunk now >> http://get.splunk.com/ >>>_______________________________________________________ >>> >>>Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx >>>Archive: >>>http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users >>>Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users >>>Homepage: http://www.gnugk.org/ ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
