[SR-Users] dialplan question (was: ACC with MySqsl problem after installing Siremis)

Thu Aug 25 13:12:57 CEST 2011

Hi,
Below in red….
BR,
Uri
________________________________
From: Daniel-Constantin Mierla [mailto:daniel at asipto.com]
Sent: Thursday, August 25, 2011 1:56 PM
To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Cc: אורי שקד - חטיבת הנדסה ורשת - Uri Shacked
Subject: Re: dialplan question (was: [SR-Users] ACC with MySqsl problem after installing Siremis)

Hello,

if you want to discuss about another topic, it is better to start a new email thread with subject reflecting the new topic -- it will be noticed properly, since various components are more familiar to different people. – Thanks, I will next time.

On 8/22/11 1:34 PM, אורי שקד - חטיבת הנדסה ורשת - Uri Shacked wrote:
Thanks!

[...]
I am trying to use the Dialplan module in order to translate numbers. For example:
When a call arrives and designated to sip:999 at localhost (there is no such subscriber) the dialplan should find it (it does) and replace the 999 to 102.
My problem is that it does not translate the ruri and does not initiate the call to sip:102 at localhost (it is a subscriber).

Any ideas? The log is attached, see the line – “registrar [lookup.c:84]: '999' Not found in usrloc” Why is it looking for 999? It was supposed to replace it with 102 no?
Seems you don't call dp_translate() to update the r-uri user part, can you paste here the piece of config you use for doing the dialplan translation?
The cfg file is attached (line 474 is the dp_translate). I use database configuration, in the Kamailio.log I definitely see it recognize the “999” and var to change is “102” but as I mentioned, it doesn’t change the ruri and search for 999 in the location table…

Thanks a lot!

I have to say I have been working on Kamailio for 10 days now. It seems hard to understand..(maybe for me :)) But it has a feeling of a very powerful and flexible Sip server… which is very very good!

Indeed, it may take a bit to get into it, but once you are there, you will discover how easy is to implement amazing ideas or fix broken signaling sent by devices.

Cheers,
Daniel

BR,
Uri

________________________________
From: Elena-Ramona Modroiu [mailto:ramona at asipto.com]
Sent: Monday, August 22, 2011 11:57 AM
To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Cc: אורי שקד - חטיבת הנדסה ורשת - Uri Shacked
Subject: Re: [SR-Users] ACC with MySqsl problem after installing Siremis

Hi,

if you installed Siremis 2.0 via the wizard, the structures of acc and missed_calls tables were updated, so you have to change the parameters of acc module in kamailio.cfg, like:

http://kb.asipto.com/siremis:install20:accounting#config_file

If you want to see the sql used to create the new acc and missed_calls tables, see:

http://siremis.git.sourceforge.net/git/gitweb.cgi?p=siremis/siremis;a=blob;f=siremis/modules/ser/mod.install.siremis.sql;hb=HEAD

Regards,
Ramona

On 8/21/11 10:58 AM, אורי שקד - חטיבת הנדסה ורשת - Uri Shacked wrote:
Hi,

I managed to setup the ACC module with MySql.
Now, after installing Siremis, the ACC table and the Missed_calls table are empty and do not populae the data from the call I make.
Any ideas why?

BR,
Uri

[cid:image001.jpg at 01CC6330.9B975CF0]
 [cid:image002.jpg at 01CC6330.9B975CF0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5iZXplcS5jby5pbC9QYWdlcy9Ib21lLmFzcHg/V1QubWNfaWQ9YmV6ZXFtYWlsaHBpY29u&istmp=enrich@bezeq.co.il>   [cid:image003.jpg at 01CC6330.9B975CF0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5mYWNlYm9vay5jb20vQmV6ZXE=&istmp=enrich@bezeq.co.il>    [cid:image004.jpg at 01CC6330.9B975CF0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3R3aXR0ZXIuY29tLyMhL2JlemVx&istmp=enrich@bezeq.co.il>   [cid:image005.jpg at 01CC6330.9B975CF0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5iZXplcXN0b3JlLmNvLmlsLz91dG1fc291cmNlPWJlemVxX2FkbWFpbCZ1dG1fbWVkaXVtPWVtYWlsJTJCYmFubmVyJnV0bV9jb250ZW50PWdlbmVyYWwmdXRtX2NhbXBhaWduPWdlbmVyYWw=&istmp=enrich@bezeq.co.il>

________________________________

_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org<mailto:sr-users at lists.sip-router.org>

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org<mailto:sr-users at lists.sip-router.org>

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 2297 bytes
Desc: image005.jpg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 2053 bytes
Desc: image004.jpg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0006.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 2167 bytes
Desc: image003.jpg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0007.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 2407 bytes
Desc: image002.jpg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0008.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 31118 bytes
Desc: image001.jpg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0009.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Kamailio.ZIP
Type: application/x-zip-compressed
Size: 6734 bytes
Desc: Kamailio.ZIP
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110825/73a28988/attachment-0001.bin>