Hello Balgaa, > [RasSrv::RewriteE164] > 0888=090 Will not be the best solution as it will rewrite 0888 to 090 no matter where it comes from. It will only solve your immetiate problem. But not the right way to be used in your long term expansion. Try using this method. I am using it. [RewriteCLI] in:c.c.c.c=any=railcom ## this will make sure gnugk knows railcom [RasSrv::GWRewriteE164] railcom=in=0888=090;out=09086=56204686;out=090=0673 Best regards Manjula Hettiarachchi --- Balgansuren Batsukh <balgaa@xxxxxxxx> wrote: > Hello Zygmuntowicz, > > Right now it is working. > > I added followings: > ============= > [RasSrv::RewriteE164] > 0888=090 > > [RasSrv::GWPrefixes] > sigaco=09086 > sigaco1=09086 > voipexchange=0907 > starlink=090 > > [RasSrv::ARQFeatures] > RoundRobinGateways=1 > ;CallUnregisteredEndpoints=1 > > [RasSrv::GWRewriteE164] > sigaco=out=09086=56204686 > sigaco1=out=09086=56204686 > voipexchange=out=0907=7 > starlink=out=090=8383 > > Regards, > Balgaa > > > ----- Original Message ----- > From: "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx> > To: "Balgansuren Batsukh" <balgaa@xxxxxxxx>; "GNU > Gatekeeper Users" > <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> > Sent: Wednesday, December 13, 2006 3:03 PM > Subject: Re: > RasSrv::GWRewriteE164 > > > > This is because this section works only for > registered endpoints > > (not the permanent or unregistered ones, unless > Setup contains > > a correct H.323 ID). > > > > ----- Original Message ----- > > From: "Balgansuren Batsukh" <balgaa@xxxxxxxx> > > Sent: Wednesday, December 13, 2006 2:49 AM > > > > > > I am trying to use RasSrv::GWRewriteE164 on GnuGK > and i follow instruction > > on manual. > > > > Connection diagram: > > =============== > > c.c.c.c---0888 prefix---->GnuGK---0673, 562046 or > direct country > > code--->a/x/y/z carrier > > > > We are using sqlbill for prepaid > origination/termination. That's why we > > need > > to translate 0888--->090 to do make billing > calculation on GnuGK? > > > > We configured GnuGK for full-proxy. > > > > Please find below configuration: > > ======================= > > [Gatekeeper::Auth] > > SQLAuth=required;Setup,SetupUnreg > > FileIPAuth=required;RRQ,LRQ,Setup > > > > [RasSrv::GWPrefixes] > > > > [RasSrv::ARQFeatures] > > RoundRobinGateways=1 > > ;CallUnregisteredEndpoints=1 > > > > [RasSrv::GWRewriteE164] > > > railcom=in=0888=090;out=09086=56204686;out=090=0673 > > > > [RasSrv::RewriteE164] > > > > [RasSrv::PermanentEndpoints] > > x.x.x.250=sigaco;4976 > > y.y.y.172=sigaco1;4976 > > z.z.z.101=starlink;0673,001 > > a.a.a.34=voipexchange;7,81,976,001 > > c.c.c.c=railcom; > > > > ###### our new case using PostgreSQL > > [SQLAuth] > > Driver=PostgreSQL > > Host=localhost > > Database=voipdb > > Username=gkradius > > Password=gkradius > > CallQuery=SELECT 1, > credit_time('%u','%{callerip}','%{Called-Station-Id}') > > as credittime > > > > [SQLAcct] > > Driver=PostgreSQL > > Host=localhost > > Database=voipdb > > Username=gkradius > > Password=gkradius > > StartQuery=INSERT INTO voipcall (id, h323id, > acctsessionid, h323confid, > > gkip, gkid, callingstationip, callingstationid, > called > > stationip, calledstationid, setuptime, > acctstarttime, acctstartdelay, > > acctupdatetime) VALUES (DEFAULT, '%u', '%s', > '%{ConfId}' > > , '%{gkip}', '%g', NULLIF('%{caller-ip}', > '')::INET, > > '%{Calling-Station-Id}', NULLIF('%{callee-ip}', > '')::INET, '%{Called-Stat > > ion-Id}', NULLIF('%{setup-time}', > '')::TIMESTAMP(0) WITH TIME ZONE, now(), > > 0, now()) > > UpdateQuery=UPDATE voipcall SET duration = '%d', > connecttime = > > NULLIF('%{connect-time}','')::TIMESTAMP(0) WITH > TIME ZONE, acct > > updatetime = now() WHERE acctsessionid = '%s' AND > gkid = '%g' AND > > acctstoptime IS NULL > > > > StopQuery=UPDATE voipcall SET acctstoptime = > now(), duration = '%d', > > terminatecause = '%c', acctstopdelay = 0, > setuptime = NUL > > LIF('%{setup-time}', '')::TIMESTAMP(0) WITH TIME > ZONE, connecttime = > > NULLIF('%{connect-time}', '')::TIMESTAMP(0) WITH > TIME ZON > > E, disconnecttime = NULLIF('%{disconnect-time}', > '')::TIMESTAMP(0) WITH > > TIME > > ZONE WHERE acctsessionid = '%s' AND gkid = '%g' A > > ND acctstoptime IS NULL > > StopQueryAlt=INSERT INTO voipcall (id, h323id, > acctsessionid, h323confid, > > gkip, gkid, callingstationip, callingstationid, > call > > edstationip, calledstationid, setuptime, > connecttime, disconnecttime, > > terminatecause, duration, acctstarttime, > acctstartdelay, > > acctupdatetime, acctstoptime, acctstopdelay) > VALUES (DEFAULT,'%u', '%s', > > '%{ConfId}', '%{gkip}', '%g', > NULLIF('%{caller-ip}', > > '')::INET, '%{Calling-Station-Id}', > NULLIF('%{callee-ip}', '')::INET, > > '%{Called-Station-Id}', > NULLIF('%{setup-time}','')::TIM > > ESTAMP(0) WITH TIME ZONE, > NULLIF('%{connect-time}','')::TIMESTAMP(0) WITH > > TIME ZONE, > NULLIF('%{disconnect-time}','')::TIMESTAM > > P(0) WITH TIME ZONE, '%c', '%d', (now() - > '%d'::INTERVAL), 0, now(), > > now(), > > 0) > > > > > > > > Above RasSrv::GWRewriteE164 section doesn't work > at all. Is there any > > additional configuration required? > > > > > > Regards, > > Balgaa > > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of > IT > > Join SourceForge.net's Techsay panel and you'll > get the chance to share > > your > > opinions on IT & business topics through brief > surveys - and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > _______________________________________________________ > > > > Posting: > mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > > Archive: > http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > > Unsubscribe: > http://lists.sourceforge.net/lists/listinfo/openh323gk-users > === message truncated === ____________________________________________________________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/