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

[אורי שקד - חטיבת הנדסה ורשת - Uri Shacked]

Hi,

I checked and redo the changes…
It doesn’t work.
My config file is attached.

I checked the DB tables and columns to see it is OK and it is…..

Any Idea what else?

Thanks,
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 01CC60E3.341054F0]
 [cid:image002.jpg at 01CC60E3.341054F0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5iZXplcS5jby5pbC9QYWdlcy9Ib21lLmFzcHg/V1QubWNfaWQ9YmV6ZXFtYWlsaHBpY29u&istmp=enrich@bezeq.co.il>   [cid:image003.jpg at 01CC60E3.341054F0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3d3dy5mYWNlYm9vay5jb20vQmV6ZXE=&istmp=enrich@bezeq.co.il>    [cid:image004.jpg at 01CC60E3.341054F0] <http://robustus.impactia.com/AnalyticServer/redirect?cid=50f7cf7d3be2418b&mid=6241890&eurl=aHR0cDovL3R3aXR0ZXIuY29tLyMhL2JlemVx&istmp=enrich@bezeq.co.il>   [cid:image005.jpg at 01CC60E3.341054F0] <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/dc579ee8/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/dc579ee8/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/dc579ee8/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/dc579ee8/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/dc579ee8/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/dc579ee8/attachment-0009.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kamailio.ZIP
Type: application/x-zip-compressed
Size: 6556 bytes
Desc: kamailio.ZIP
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110822/dc579ee8/attachment-0001.bin>