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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda -
http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 -
http://www.asipto.com