Hello,

maybe the table was not available when you installed first time siremis, being added in later versions of kamailio.

You can create the table in kamailio database using the script locate in source tree at:

- utils/kamctl/mysql/uac-create.sql

Or if you don't use uac module for remote registrations, then you can disable that option from menu, so nobody else ends up in such error.

Cheers, Daniel

On 16/11/16 23:51, Kevin Greene wrote:

Hi fellow Kamailio people:

I was using the Siremis (v2.0) to manage my Kamailio application. I received a message labeled "System Internal Error" It seems, assuming I understand it correctly, that a table called "kamailio.uacreg" does not exist in the database.

I receive this error when I click on the following:

Main System > SIP Admin Menu > Server Services > UACReg List function.

Any help in pointing me in the right direction would be great.

Thanks.

Kevin

2016-11-16 22:29:23 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.id, T0.l_uuid, T0.l_username, T0.l_domain, T0.r_username, T0.r_domain, T0.realm, T0.auth_username, T0.auth_password, T0.auth_proxy, T0.expires FROM uacreg T0 LIMIT 10. SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kamailio.uacreg' doesn't exist Script name and line number of error: /var/www/siremis/openbiz/bin/data/BizDataObj_Lite.php:447

*function:* _run_search ( Array(2) ) @ /var/www/siremis/openbiz/bin/data/BizDataObj_Lite.php 243 *function:* fetch ( ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 690 *function:* fetchDataSet ( ) @ /var/www/siremis/openbiz/bin/easy/FormRenderer.php 69 *function:* renderSmarty ( Object(EasyForm), "/var/www/siremis/siremis/modules/ser/template/grid.tpl" ) @ /var/www/siremis/openbiz/bin/easy/FormRenderer.php 45 *function:* render ( Object(EasyForm) ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 1648 *function:* renderHTML ( ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 1538 *function:* render ( ) @ /var/www/siremis/openbiz/bin/easy/ViewRenderer.php 83 *function:* renderSmarty ( Object(EasyView), "/var/www/siremis/siremis/modules/ser/template/view.tpl" ) @ /var/www/siremis/openbiz/bin/easy/ViewRenderer.php 40 *function:* render ( Object(EasyView) ) @ /var/www/siremis/openbiz/bin/easy/EasyView.php 274 *function:* _render ( ) @ /var/www/siremis/openbiz/bin/easy/EasyView.php 237 *function:* render ( ) @ /var/www/siremis/openbiz/bin/BizController.php 221 *function:* renderView ( "ser.view.UacregListView", "", "", Null, "" ) @ /var/www/siremis/openbiz/bin/BizController.php 107 *function:* dispatchRequest ( ) @ /var/www/siremis/openbiz/bin/BizController.php 32 *function:* include_once ( "/var/www/siremis/openbiz/bin/BizController.php" ) @

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users