Re: [SR-Users] siremis 2.0.0 CDRS link issues !

Hi all, I was wondering if Im the only one getting this error (in siremis 2.0.0 with kamailio 3.1). i.e. I have activated the accounting modules & all but still when I click the "CDR list" in "Accounting Services" it errors on me saying that CDRS table is missing, which ofcourse is missing from the "openser" mysql DB. Why is CDRS table missing ? Is it okay (advisable) to create a CDRS table mentioned in siremis 1.0 docs (http://siremis.asipto.com/install-accounting/)

Cheers --- X [2010-11-12 14:01:08 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.cdr_id, T0.src_username, T0.src_domain, T0.dst_username, T0.dst_domain, T0.call_start_time, T0.duration, T0.sip_call_id, T0.sip_from_tag, T0.sip_to_tag, T0.src_ip, T0.cost, T0.created FROM `cdrs` T0 LIMIT 10. SQLSTATE[42S02]: Base table or view not found: 1146 Table 'openser.cdrs' doesn't exist Script name and line number of error: /var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447 function: _run_search ( Array(2) ) @ /var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 69 function: renderSmarty ( Object(EasyForm), "/var/www/siremis-2.0.0/siremis/modules/ser/template/grid.tpl" ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 45 function: render ( Object(EasyForm) ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 83 function: renderSmarty ( Object(EasyView), "/var/www/siremis-2.0.0/siremis/modules/ser/template/view.tpl" ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 40 function: render ( Object(EasyView) ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php 221 function: renderView ( "ser.view.CdrsListView", "", "", Null, "" ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php 32 function: include_once ( "/var/www/siremis-2.0.0/openbiz/bin/BizController.php" ) @ /var/www/siremis-2.0.0/siremis/bin/controller.php 6 function: include ( "/var/www/siremis-2.0.0/siremis/bin/controller.php" ) @ /var/www/siremis-2.0.0/siremis/bin/_forward.php 90 function: include ( "/var/www/siremis-2.0.0/siremis/bin/_forward.php" ) @ /var/www/siremis-2.0.0/siremis/index.php 3 Please ask system administrator for help... _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users