[SR-Users] ACC with MySqsl problem after installing Siremis

Mon Aug 22 13:34:48 CEST 2011

Thanks!

I think I tried it already. I will try again and let you know.
Anyway, before meeting in October…. If it is possible to ask..
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?

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!

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 01CC60D8.A347B5D0]
 [cid:image002.jpg at 01CC60D8.A347B5D0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5iZXplcS5jby5pbC9QYWdlcy9Ib21lLmFzcHg/V1QubWNfaWQ9YmV6ZXFtYWlsaHBpY29u&istmp=enrich@bezeq.co.il>   [cid:image003.jpg at 01CC60D8.A347B5D0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5mYWNlYm9vay5jb20vQmV6ZXE=&istmp=enrich@bezeq.co.il>    [cid:image004.jpg at 01CC60D8.A347B5D0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3R3aXR0ZXIuY29tLyMhL2JlemVx&istmp=enrich@bezeq.co.il>   [cid:image005.jpg at 01CC60D8.A347B5D0] <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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110822/c5dc0c15/attachment-0001.htm>
-------------- 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/20110822/c5dc0c15/attachment-0005.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/20110822/c5dc0c15/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/20110822/c5dc0c15/attachment-0007.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/20110822/c5dc0c15/attachment-0008.jpg>
-------------- 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/20110822/c5dc0c15/attachment-0009.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kamailio log dp module.ZIP
Type: application/x-zip-compressed
Size: 3085 bytes
Desc: kamailio log dp module.ZIP
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110822/c5dc0c15/attachment-0001.bin>