10.1.41-MariaDB-0+deb9u1 Debian 9.9
kamailio 4.4.4 (x86_64/linux)
Apache/2.4.25 (Debian)
PHP 7.0.33

This error crops up any time I attempt to edit a user, either the admin user I signed in as or another user.

[2019-10-29 02:21:09 (GMT)] An exception occurred while executing this script:
Error message: #2, Declaration of UserForm::validateForm() should be compatible with EasyForm::validateForm($cleanError = true)
Script name and line number of error: /var/www/siremis-4.4.0/siremis/modules/system/form/UserForm.php:27

function: errorHandler ( 2, "Declaration of UserForm::validateForm() should be compatible wit...", "/var/www/siremis-4.4.0/siremis/modules/system/form/UserForm.php", 27, Array(12) ) @ /var/www/siremis-4.4.0/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "Declaration of UserForm::validateForm() should be compatible wit...", "/var/www/siremis-4.4.0/siremis/modules/system/form/UserForm.php", 27, Array(12) ) @ /var/www/siremis-4.4.0/siremis/modules/system/form/UserForm.php 27
function: include_once ( "/var/www/siremis-4.4.0/siremis/modules/system/form/UserForm.php" ) @ /var/www/siremis-4.4.0/openbiz/bin/ObjectFactory.php 162
function: constructObject ( "system.form.UserEditForm" ) @ /var/www/siremis-4.4.0/openbiz/bin/ObjectFactory.php 56
function: getObject ( "system.form.UserEditForm", 0 ) @ /var/www/siremis-4.4.0/openbiz/bin/BizSystem.php 252
function: getObject ( "system.form.UserEditForm" ) @ /var/www/siremis-4.4.0/openbiz/bin/BizController.php 297
function: invoke ( ) @ /var/www/siremis-4.4.0/openbiz/bin/BizController.php 110
function: dispatchRequest ( ) @ /var/www/siremis-4.4.0/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/siremis-4.4.0/openbiz/bin/BizController.php" ) @ /var/www/siremis-4.4.0/siremis/bin/controller.php 6

[2019-05-31 09:18:50 (GMT)] An exception occurred while executing this script:
Error message: #2, A non-numeric value encountered
Script name and line number of error: /var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d code:1

function: errorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d code 1
function: eval ( ) @ /var/www/html/siremis/openbiz/bin/Expression.php 336
function: evaluateExpression ( "menu.form.MenuListForm.UpdateFieldValue({@:Elem[fld_Id].Value},f...", Object(MenuForm) ) @ /var/www/html/siremis/openbiz/bin/easy/element/Element.php 637
function: getFormedFunction ( ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnSorting.php 90
function: getBtnFunction ( "fld_sortorder_up" ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnSorting.php 7
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 54
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 94
function: renderTable ( Array(3) ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 70
function: renderSmarty ( Object(MenuForm), "/var/www/html/siremis/siremis/themes/default/template/system_rig..." ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(MenuForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/siremis/modules/menu/form/MenuForm.php 48
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/menu/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "menu.view.MenuListView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3

Hi,

I set $cfg_siremis_public_registrations in common.Main.php to true as describe here: http://kb.asipto.com/siremis:install40x:public-registration
But unfortunately it's not working. If I try to open http://ydomain/siremis/user/register the normal login-window appears and if I log in and open the url of the registration form again, it shows up, but if I try to register a new user only the message: Public registration is not enabled! shows up.

Any suggestion?

Hi

I have set my system date to UCT but I am getting this error while trying to login for the first time with user admn and password admin:

[{"target":"ERROR","content":"
\n[2017-04-02 22:10:13 (GMT)] An exception occurred while executing this script:
\nError message: #2, date(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.</font>
\nScript name and line number of error: /var/www/siremis/openbiz/bin/service/logService.php:160</font>
\n

function:</b> errorHandler ( 2, "date(): It is not safe to rely on the system's timezone settings...", "/var/www/siremis/openbiz/bin/service/logService.php", 160, Array(8) ) @ /var/www/siremis/openbiz/bin/sysheader.inc 117\n
function:</b> userErrorHandler ( 2, "date(): It is not safe to rely on the system's timezone settings...", "/var/www/siremis/openbiz/bin/service/logService.php", 160, Array(8) ) @ \n
function:</b> date ( "m/d/Y" ) @ /var/www/siremis/openbiz/bin/service/logService.php 160\n
function:</b> log ( 7, "DATAOBJ", "Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, ..." ) @ /var/www/siremis/openbiz/bin/BizSystem.php 508\n
function:</b> log ( 7, "DATAOBJ", "Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, ..." ) @ /var/www/siremis/openbiz/bin/data/BizDataObj_Lite.php 438\n
function:</b> _run_search ( Array(2) ) @ /var/www/siremis/openbiz/bin/data/BizDataObj_Lite.php 345\n
function:</b> fetchRecords ( "[username]='admin' and status='1'", Array(0), 1 ) @ /var/www/siremis/siremis/modules/service/authService.php 98\n
function:</b> authDBUser ( "admin", "admin" ) @ /var/www/siremis/siremis/modules/service/authService.php 66\n
function:</b> authenticateUser ( "admin", "admin" ) @ /var/www/siremis/siremis/modules/user/form/LoginForm.php 92\n
function:</b> Login ( ) @ /var/www/siremis/openbiz/bin/BizController.php 310\n
function:</b> invoke ( ) @ /var/www/siremis/openbiz/bin/BizController.php 110\n
function:</b> dispatchRequest ( ) @ /var/www/siremis/openbiz/bin/BizController.php 32\n
function:</b> include_once ( "/var/www/siremis/openbiz/bin/BizController.php" ) @ /var/www/siremis/siremis/bin/controller.php 6</div>\nPlease ask system administrator for help...</div>\n"}]

[2019-05-30 09:07:02 (GMT)] An exception occurred while executing this script:
Error message: #256, Cannot find the class with name as sipadmin.rtg.dr_gateways.do.DrGatewaysDO
Script name and line number of error: /var/www/html/siremis/openbiz/bin/ObjectFactory.php:157

function: errorHandler ( 256, "Cannot find the class with name as sipadmin.rtg.dr_gateways.do.D...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 256, "Cannot find the class with name as sipadmin.rtg.dr_gateways.do.D...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @
function: trigger_error ( "Cannot find the class with name as sipadmin.rtg.dr_gateways.do.D...", 256 ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 157
function: constructObject ( "sipadmin.rtg.dr_gateways.do.DrGatewaysDO" ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 56
function: getObject ( "sipadmin.rtg.dr_gateways.do.DrGatewaysDO" ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 329
function: getDataObj ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 663
function: fetchDataSet ( ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/siremis/modules/sipadmin/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/sipadmin/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipadmin.view.DrGatewaysListView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3

[2019-05-30 09:18:06 (GMT)] An exception occurred while executing this script:
Error message: #256, Cannot find the class with name as sipadmin.srv.topos_d.do.ToposDDO
Script name and line number of error: /var/www/html/siremis/openbiz/bin/ObjectFactory.php:157

function: errorHandler ( 256, "Cannot find the class with name as sipadmin.srv.topos_d.do.Topos...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 256, "Cannot find the class with name as sipadmin.srv.topos_d.do.Topos...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @
function: trigger_error ( "Cannot find the class with name as sipadmin.srv.topos_d.do.Topos...", 256 ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 157
function: constructObject ( "sipadmin.srv.topos_d.do.ToposDDO" ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 56
function: getObject ( "sipadmin.srv.topos_d.do.ToposDDO" ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 329
function: getDataObj ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 663
function: fetchDataSet ( ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/siremis/modules/sipadmin/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/sipadmin/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipadmin.view.ToposDListView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3
Please ask system administrator for help...

seems siremis use only apache2 and that are very unresponsible due today apache2 are not a good choice to production services due poor performance and resource hungry...

this problem comes due the hard coded rewrite rules seems siremis does not work without rewrite rules (that hidden the index.php) and in any case if the siremis system are not used exposed to web so then why hidden the index.php that its stupid in that case!

Hi, I'm getting the following error on the master branch when trying to access SIP User Menu/Location Records (or any of the other items).

[2018-10-31 05:42:05 (GMT)] An exception occurred while executing this script:
Error message: #2, Use of undefined constant admin - assumed 'admin' (this will throw an Error in a future version of PHP)
Script name and line number of error: /var/www/html/siremis/openbiz/bin/Expression.php(329) : eval()'d code:1

function: errorHandler ( 2, "Use of undefined constant admin - assumed 'admin' (this will thr...", "/var/www/html/siremis/openbiz/bin/Expression.php(329) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "Use of undefined constant admin - assumed 'admin' (this will thr...", "/var/www/html/siremis/openbiz/bin/Expression.php(329) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/Expression.php(329) : eval()'d code 1
function: eval ( ) @ /var/www/html/siremis/openbiz/bin/Expression.php 329
function: evaluateExpression ( "'[username]'=='{@Profile:username}'", Object(SubscriberDO) ) @ /var/www/html/siremis/openbiz/bin/data/private/BizDataObj_SQLHelper.php 318
function: _ruleToSql ( Object(SubscriberDO), "'[username]'=='{@Profile:username}'" ) @ /var/www/html/siremis/openbiz/bin/data/private/BizDataObj_SQLHelper.php 124
function: buildQuerySQL ( Object(SubscriberDO) ) @ /var/www/html/siremis/openbiz/bin/data/BizDataObj_Lite.php 403
function: _run_search ( Array(2) ) @ /var/www/html/siremis/openbiz/bin/data/BizDataObj_Lite.php 243
function: fetch ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 690
function: fetchDataSet ( ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/siremis/modules/sipuser/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/sipuser/template/view_tabs..." ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipuser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3

Setup

• Docker images
• mysql:latest
  • Mysql 8.0.19
• siremis-git
• based off Dockerfile.debian10-gitdev
• installed php-pgsql
• Steps to reproduce
• Follow webui setup (check all 4 boxes)
• Connecting to remote Postgres kamailio DB
• log into webui as admin admin
• select SIP Admin Menu
• click any link in SIP Admin Menu

Error

Error message: #0, Error in query:: SELECT T0.id, T0.setid, T0.destination, T0.flags, T0.priority, T0.attrs, T0.description FROM `dispatcher` T0 LIMIT 10. SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "`" LINE 1: ...lags, T0.priority, T0.attrs, T0.description FROM `dispatche... ^
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(EasySiremisForm), "/var/www/siremis/siremis/modules/sipadmin/template/grid.tpl" ) @ /var/www/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasySiremisForm) ) @ /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/sipadmin/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 ( "sipadmin.view.DispatcherListView", "", "", 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" ) @ /var/www/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/siremis/siremis/bin/controller.php" ) @ /var/www/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/siremis/siremis/bin/_forward.php" ) @ /var/www/siremis/siremis/index.php 3

Solution

• This could very well cause issues elsewhere. I have not run into issues with the limited testing I have done, which was just verifying I can add a dialplan to the db
• /openbiz/bin/BizSystem.php getDBTableQuoted
• replace return "`".$value."`"; with return $value;

2019-05-31 14:25:25 (GMT)] An exception occurred while executing this script:
Error message: #2, require_once(XML/RPC.php): failed to open stream: No such file or directory
Script name and line number of error: /var/www/html/siremis/siremis/modules/sipadmin/service/asipto/libs/cmds/serxr.php:2

function: errorHandler ( 2, "require_once(XML/RPC.php): failed to open stream: No such file o...", "/var/www/html/siremis/siremis/modules/sipadmin/service/asipto/li...", 2, Array(12) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "require_once(XML/RPC.php): failed to open stream: No such file o...", "/var/www/html/siremis/siremis/modules/sipadmin/service/asipto/li...", 2, Array(12) ) @ /var/www/html/siremis/siremis/modules/sipadmin/service/asipto/libs/cmds/serxr.php 2
function: require_once ( ) @ /var/www/html/siremis/siremis/modules/sipadmin/service/asipto/libs/cmds/serxr.php 2
function: include_once ( "/var/www/html/siremis/siremis/modules/sipadmin/service/asipto/li..." ) @ /var/www/html/siremis/siremis/modules/sipadmin/cms/form/XrcmdsForm.php 2
function: include_once ( "/var/www/html/siremis/siremis/modules/sipadmin/cms/form/XrcmdsFo..." ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 162
function: constructObject ( "sipadmin.cms.form.XrcmdsForm" ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 56
function: getObject ( "sipadmin.cms.form.XrcmdsForm" ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 348
function: initAllForms ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 232
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipadmin.view.XrcmdsView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3

in makefile there that line:

BASEDIR=pwd

must be changed to

BASEDIR ?= pwd

to property able to use the makefile for customized instalations, same for VERSION to hable to make sub-releases per distributions.. so we support this are not installable in windo like poor OS's

It would be nice if there was a way to add hundreds/thousands of users.

For now I am creating a bash script that does this directly on MySQL.

fresh installation on:
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 18.04.3 LTS
Release: 18.04
Codename: bionic
apache: 2.4.29-1ubuntu4.11
php Version: 1: 7.2+60ubuntu1

and siremis with git clone from this place.

Hello I can't open the subscriber list in siremis 4.4.0 on linux mint 17

error code:

Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.contact, T0.received, T0.path, T0.expires, T0.q, T0.callid, T0.cseq, T0.last_modified, T0.flags, T0.cflags, T0.user_agent, T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id, T0.server_id, T0.connection_id, T0.keepalive, T0.partition FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.server_id' in 'field list'
Script name and line number of error: /var/www/siremis-4.4.0/openbiz/bin/data/BizDataObj_Lite.php:447

function: _run_search ( Array(2) ) @ /var/www/siremis-4.4.0/openbiz/bin/data/BizDataObj_Lite.php 243 
function: fetch ( ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/EasyForm.php 690 
function: fetchDataSet ( ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/FormRenderer.php 69 
function: renderSmarty ( Object(EasyForm), "/var/www/siremis-4.4.0/siremis/modules/ser/template/grid.tpl" ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/FormRenderer.php 45 
function: render ( Object(EasyForm) ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/EasyForm.php 1648 
function: renderHTML ( ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/EasyForm.php 1538 
function: render ( ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/ViewRenderer.php 83 
function: renderSmarty ( Object(EasyView), "/var/www/siremis-4.4.0/siremis/modules/ser/template/view_tabs.tp..." ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/ViewRenderer.php 40 
function: render ( Object(EasyView) ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/EasyView.php 274 
function: _render ( ) @ /var/www/siremis-4.4.0/openbiz/bin/easy/EasyView.php 237 
function: render ( ) @ /var/www/siremis-4.4.0/openbiz/bin/BizController.php 221 
function: renderView ( "ser.view.SubscriberListView", "", "", Null, "" ) @ /var/www/siremis-4.4.0/openbiz/bin/BizController.php 107 
function: dispatchRequest ( ) @ /var/www/siremis-4.4.0/openbiz/bin/BizController.php 32 
function: include_once ( "/var/www/siremis-4.4.0/openbiz/bin/BizController.php" ) @ /var/www/siremis-4.4.0/siremis/bin/controller.php 6 
function: include ( "/var/www/siremis-4.4.0/siremis/bin/controller.php" ) @ /var/www/siremis-4.4.0/siremis/bin/_forward.php 102 
function: include ( "/var/www/siremis-4.4.0/siremis/bin/_forward.php" ) @ /var/www/siremis-4.4.0/siremis/index.php 3
Please ask system administrator for help...

• Auth Ha1 field should be calculated without forcing user input or allow empty value
• Flags should contain some explanation or select dropdown
• When loading uacreg row - Flags should display 0 in case the value is 0
• L Uuid change should update, not create a new user.

Fresh Install
Kamailio v5.1
Siremis from master branch https://github.com/asipto/siremis.git
Debian v9 with PHP v7.0
php-mysql php-gd php-curl php-xml php-xmlrpc php-json libapache2-mod-php php-pear

Installed XML_RPC

wget http://pear.php.net/get/XML_RPC-1.5.5.tgz
pear upgrade XML_RPC-1.5.5.tgz 

In kamailio.cfg I have

loadmodule "xmlrpc.so"
modparam("xmlrpc", "route", "XMLRPC");
modparam("xmlrpc", "url_match", "^/RPC")

route[XMLRPC] {
	# allow XMLRPC from localhost
	if ((method=="POST" || method=="GET")
			&& (src_ip==127.0.0.1)) {
		# close connection only for xmlrpclib user agents (there is a bug in
		# xmlrpclib: it waits for EOF before interpreting the response).
		if ($hdr(User-Agent) =~ "xmlrpclib")
			set_reply_close();
		set_reply_no_connect();
		dispatch_rpc();
		exit;
	}
	send_reply("403", "Forbidden");
	exit;
}

It doesn't appear to be working.
In GUI > SIP ADMIN MENU > Command Services > XMLRPC Commands it just returns NO RESULT for any command I try.

There are no errors in kamailio or apache2 logs.

Newly Installed on Ubuntu 15.04 and PHP 5.6.4-4. After running the install wizard and trying to log in as admin I get an error popup. I have seen this posted by others to various forums as well.

[{"target":"ERROR","content":"
\n[2015-09-17 23:42:07 (GMT)] An exception occurred while executing this script:
\nError message: #8192, Non-static method BizSystem::getConfiguration() should not be called statically, assuming $this from incompatible context<\/font>
\nScript name and line number of error: \/var\/www\/siremis-4.2.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php:268<\/font>
\n

function:<\/b> errorHandler ( 8192, \"Non-static method BizSystem::getConfiguration() should not be ca...\", \"\/var\/www\/siremis-4.2.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php\", 268, Array(0) ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/sysheader.inc 117\n
function:<\/b> userErrorHandler ( 8192, \"Non-static method BizSystem::getConfiguration() should not be ca...\", \"\/var\/www\/siremis-4.2.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php\", 268, Array(0) ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php 268\n
function:<\/b> setQuoteIdentifiers ( ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/data\/BizDataObj_Abstract.php 177\n
function:<\/b> __construct ( Array(1) ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/data\/BizDataObj.php 37\n
function:<\/b> __construct ( Array(1) ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/ObjectFactory.php 166\n
function:<\/b> constructObject ( \"system.do.UserDO\" ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/ObjectFactory.php 56\n
function:<\/b> getObject ( \"system.do.UserDO\", 0 ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/BizSystem.php 252\n
function:<\/b> getObject ( \"system.do.UserDO\" ) @ \/var\/www\/siremis-4.2.0\/siremis\/modules\/service\/authService.php 92\n
function:<\/b> authDBUser ( \"admin\", \"admin\" ) @ \/var\/www\/siremis-4.2.0\/siremis\/modules\/service\/authService.php 66\n
function:<\/b> authenticateUser ( \"admin\", \"admin\" ) @ \/var\/www\/siremis-4.2.0\/siremis\/modules\/user\/form\/LoginForm.php 92\n
function:<\/b> Login ( ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/BizController.php 310\n
function:<\/b> invoke ( ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/BizController.php 110\n
function:<\/b> dispatchRequest ( ) @ \/var\/www\/siremis-4.2.0\/openbiz\/bin\/BizController.php 32\n
function:<\/b> include_once ( \"\/var\/www\/siremis-4.2.0\/openbiz\/bin\/BizController.php\" ) @ \/var\/www\/siremis-4.2.0\/siremis\/bin\/controller.php 6<\/div>\n
Please ask system administrator for help...<\/div>\n"}]

Administration > User Management >
Click on any existing username. The browser goes blank.

Error in apache logs is:
PHP Fatal error: Call to a member function getQuoted() on a non-object in /var/www/html/openbiz/bin/data/BizDataSql.php on line 237
This is on the latest Siremis v4.2.0 downloaded today

PHP Fatal error: require_once(): Failed opening required 'SMARTY_CORE_DIRcore.assemble_plugin_filepath.php' (include_path='.:/usr/share/pear:/usr/share/php:/var/www/html/siremis/openbiz/others/') in /var/www/html/siremis/openbiz/others/Smarty/libs/Smarty.class.php on line 1368

Can you help me?

Thanks

After adding a new user through Siremis User Management, this user isn't able to log in.
The log in interface just stays at "Processing Login".
Also clicking on a Serims username gives a blank page.

Fresh install Kamailio 5.1.4, Debian Stretch, Apache 2.4.25, php 7.0.27

I am testing your past version and in IE, Firefox and Safari I have obtained the following output from Server - Uptime command:

<methodResponse>
<params>
<param>
<value><struct>
<member><name>now</name>
<value><string>Fri Jul 6 22:24:47 2018</string></value>
</member>
<member><name>up_since</name>
<value><string>Fri Jul 6 21:52:24 2018</string></value>
</member>
<member><name>uptime</name>
<value><int>1943</int></value>
</member>
</struct>
</param>
</params>
</methodResponse>

Another commands have a similar output.

hello...
i am using acc and cdr for accounting..
but getting duplicate issue so cdr is skip and due to that accounting is miss.

Below error when execute PROCEDURE kamailio_cdrs.

ERROR 1062 (23000) at line 1: Duplicate entry '2-rNf2C1Tc-ejTp~gJOf-U1g5rrSDD696r' for key 'uk_cft'

Thanks.

kamailio 5.X are not property supported;

only in git master, so when will be released the 5.X siremis?

[2019-05-30 09:25:29 (GMT)] An exception occurred while executing this script:
Error message: #256, Cannot find the class with name as sipadmin.rtg.dr_gw_lists.do.DrGwListsDO
Script name and line number of error: /var/www/html/siremis/openbiz/bin/ObjectFactory.php:157

function: errorHandler ( 256, "Cannot find the class with name as sipadmin.rtg.dr_gw_lists.do.D...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 256, "Cannot find the class with name as sipadmin.rtg.dr_gw_lists.do.D...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @
function: trigger_error ( "Cannot find the class with name as sipadmin.rtg.dr_gw_lists.do.D...", 256 ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 157
function: constructObject ( "sipadmin.rtg.dr_gw_lists.do.DrGwListsDO" ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 56
function: getObject ( "sipadmin.rtg.dr_gw_lists.do.DrGwListsDO" ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 329
function: getDataObj ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 663
function: fetchDataSet ( ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/siremis/modules/sipadmin/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/sipadmin/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipadmin.view.DrGwListsListView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3
Please ask system administrator for help...

After a clean install of 5.1 seems to be some access issues of the cmp file. During the web config I used to get this error, but after giving the www-data user access to siremis file the installation went down with no problem. However I cant get to the login screen right after the install, "can't open cmp file to write". Where is this file and what user is accessing this?

I have followed the execution, i see that login is OK , then it call

BizSystem::clientProxy()->ReDirectPage($redirectPage);

where redirectPage=/siremis/system/general_default

but the login page is displayed again and again

All JSONRPC Commands end is System Internal Error and infinite page loading with the following lines in apache error.log:

PHP Warning: strstr() expects parameter 1 to be string, resource given in /var/www/siremis-5.1.0/openbiz/bin/ErrorHandler.php on line 154, referer: http://192.168.1.150/siremis/sipadmin/jrcmds

socket bind failed: No such file or directory, referer: http://192.168.1.150/siremis/sipadmin/jrcmds

When trying to login the first time after clean install
`[{"target":"ERROR","content":"
\n[2020-05-04 07:16:18 (GMT)] An exception occurred while executing this script:
\nError message: #8192, Function get_magic_quotes_gpc() is deprecated</font>
\nScript name and line number of error: /var/www/siremis/openbiz/bin/ClientProxy.php:190</font>
\n

function:</b> errorHandler ( 8192, "Function get_magic_quotes_gpc() is deprecated", "/var/www/siremis/openbiz/bin/ClientProxy.php", 190, Array(3) ) @ /var/www/siremis/openbiz/bin/sysheader.inc 117\n
function:</b> userErrorHandler ( 8192, "Function get_magic_quotes_gpc() is deprecated", "/var/www/siremis/openbiz/bin/ClientProxy.php", 190, Array(3) ) @ /var/www/siremis/openbiz/bin/ClientProxy.php 190\n
function:</b> getFormInputs ( "username" ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 1401\n
function:</b> readInputRecord ( ) @ /var/www/siremis/siremis/modules/user/form/LoginForm.php 73\n
function:</b> Login ( ) @ /var/www/siremis/openbiz/bin/BizController.php 310\n
function:</b> invoke ( ) @ /var/www/siremis/openbiz/bin/BizController.php 110\n
function:</b> dispatchRequest ( ) @ /var/www/siremis/openbiz/bin/BizController.php 32\n
function:</b> include_once ( "/var/www/siremis/openbiz/bin/BizController.php" ) @ /var/www/siremis/siremis/bin/controller.php 6</div>\n`

After fresh installation of Kamalio on Ubuntu 18.04.2 LTS, it is impossible to access the SIP admin page. The link redirects to /siremis/ser/ser_default with a Page not found error.

Fresh Install
Kamailio v5.1
Siremis from master branch https://github.com/asipto/siremis.git
Debian v9 with PHP v7.0 (Also tried Debian v8 and PHP v5.6)
php-mysql php-gd php-curl php-xml php-xmlrpc php-json libapache2-mod-php php-pear

In kamailio.cfg I have

loadmodule "jsonrpcs.so"
modparam("jsonrpcs", "transport", 0)
modparam("jsonrpcs", "dgram_socket", "/tmp/kamailio_rpc.sock")

It doesn't appear to be working.
In GUI > SIP ADMIN MENU > Command Services > JSONRPC Commands if I run any command it gives a generic system error webpage.

These are the only errors I see in the apache logs. Nothing in Kamailio logs

[Wed Jun 13 10:00:18.387204 2018] [:error] [pid 6031] [client x.x.x.52:52130] PHP Warning: strstr() expects parameter 1 to be string, resource given in /var/www/siremis/openbiz/bin/ErrorHandler.php on line 154, referer: http://x.x.x.166/siremis/sipadmin/jrcmds

[Wed Jun 13 10:00:18.391287 2018] [:error] [pid 6031] [client x.x.x.52:52130] socket bind failed: No such file or directory, referer: http://x.x.x.166/siremis/sipadmin/jrcmds

• The connection to the postgres db is not possible. It tries to connect with the user www-data, however an other user is specified.
• To create the db it uses an sql script in mysql syntax (with backticks, sql keywords as table and column names, auto incement fields, ...) which is not compatible with postgres.

[2019-05-30 09:22:39 (GMT)] An exception occurred while executing this script:
Error message: #256, Cannot find the class with name as sipadmin.srv.topos_t.do.ToposTDO
Script name and line number of error: /var/www/html/siremis/openbiz/bin/ObjectFactory.php:157

function: errorHandler ( 256, "Cannot find the class with name as sipadmin.srv.topos_t.do.Topos...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 256, "Cannot find the class with name as sipadmin.srv.topos_t.do.Topos...", "/var/www/html/siremis/openbiz/bin/ObjectFactory.php", 157, Array(7) ) @
function: trigger_error ( "Cannot find the class with name as sipadmin.srv.topos_t.do.Topos...", 256 ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 157
function: constructObject ( "sipadmin.srv.topos_t.do.ToposTDO" ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 56
function: getObject ( "sipadmin.srv.topos_t.do.ToposTDO" ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 329
function: getDataObj ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 663
function: fetchDataSet ( ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm), "/var/www/html/siremis/siremis/modules/sipadmin/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/sipadmin/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "sipadmin.view.ToposTListView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3
Please ask system administrator for help...

Report to admin
Show Error

Hi, I see that there have been some issues around php 7.2 and I am unable to login.

I am using the Git Master branch on Ubuntu server 18.04 with php 7.2.7 from the standard apt repository.

Please could someone help with this? Here's what I get when I try to login using the default admin account.

[{"target":"ERROR","content":"
\n[2018-08-22 12:45:01 (GMT)] An exception occurred while executing this script:
\nError message: #2, Use of undefined constant META_PATH - assumed 'META_PATH' (this will throw an Error in a future version of PHP)<\/font>
\nScript name and line number of error: \/usr\/local\/src\/siremis\/openbiz\/bin\/Resource.php:242<\/font>
\n

function:<\/b> errorHandler ( 2, \"Use of undefined constant META_PATH - assumed 'META_PATH' (this ...\", \"\/usr\/local\/src\/siremis\/openbiz\/bin\/Resource.php\", 242, Array(2) ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/sysheader.inc 117\n
function:<\/b> userErrorHandler ( 2, \"Use of undefined constant META_PATH - assumed 'META_PATH' (this ...\", \"\/usr\/local\/src\/siremis\/openbiz\/bin\/Resource.php\", 242, Array(2) ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/Resource.php 242\n
function:<\/b> getXmlFileWithPath ( \"service.logService\" ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizSystem.php 549\n
function:<\/b> getXmlFileWithPath ( \"service.logService\" ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/ObjectFactory.php 104\n
function:<\/b> constructObject ( \"service.logService\" ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/ObjectFactory.php 56\n
function:<\/b> getObject ( \"service.logService\", 0 ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizSystem.php 252\n
function:<\/b> getObject ( \"service.logService\", 0 ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizSystem.php 241\n
function:<\/b> getService ( \"service.logService\" ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizSystem.php 507\n
function:<\/b> log ( 7, \"DATAOBJ\", \"Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, ...\" ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/data\/BizDataObj_Lite.php 438\n
function:<\/b> _run_search ( Array(2) ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/data\/BizDataObj_Lite.php 345\n
function:<\/b> fetchRecords ( \"[username]='admin' and status='1'\", Array(0), 1 ) @ \/usr\/local\/src\/siremis\/siremis\/modules\/service\/authService.php 98\n
function:<\/b> authDBUser ( \"admin\", \"admin\" ) @ \/usr\/local\/src\/siremis\/siremis\/modules\/service\/authService.php 66\n
function:<\/b> authenticateUser ( \"admin\", \"admin\" ) @ \/usr\/local\/src\/siremis\/siremis\/modules\/user\/form\/LoginForm.php 93\n
function:<\/b> Login ( ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizController.php 310\n
function:<\/b> invoke ( ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizController.php 110\n
function:<\/b> dispatchRequest ( ) @ \/usr\/local\/src\/siremis\/openbiz\/bin\/BizController.php 32\n
function:<\/b> include_once ( \"\/usr\/local\/src\/siremis\/openbiz\/bin\/BizController.php\" ) @ \/usr\/local\/src\/siremis\/siremis\/bin\/controller.php 6<\/div>\nPlease ask system administrator for help...<\/div>\n"}]

[2019-05-31 09:21:23 (GMT)] An exception occurred while executing this script:
Error message: #2, A non-numeric value encountered
Script name and line number of error: /var/www/html/siremis/openbiz/bin/easy/element/ColumnBar.php:35

function: errorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/easy/element/ColumnBar.php", 35, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/easy/element/ColumnBar.php", 35, Array(7) ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnBar.php 35
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 54
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 94
function: renderTable ( Null ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 70
function: renderSmarty ( Object(CacheForm), "/var/www/html/siremis/siremis/modules/cache/template/grouping.tp..." ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(CacheForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/cache/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "cache.view.ManageView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3
Please ask system administrator for help...

Report to admin
Show Error

Hello:

I added a graphic to Siremis of my
active

dialogs. But, it only shows unix time (From 1969-12-31 19:33:37 To1969-12-31 19:33:37) as Xaxis (19:33). I had version 4.2 and never saw it correctly, I just updated to version 4.4 and I see the same problem.Please see the attachment file with the graph, and my configuration files and table bellow

Thanks in advance.

My /var/www/siremis-4.4.0/siremis/modules/ser/view/xxxx.xml file

    ?xml version="1.0"
          standalone="no"?>

        <EasyView
        Name="ChartsSumdialogsView" Description="Charts"
            class="EasyView" Tab="" TemplateEngine="Smarty"
              Access="SERAdmin.Administer_Modules"
         TemplateFile="view.tpl">

             <FormReferences>

   
       <Reference Name="ser.cms.form.ChartsForm"/>

             </FormReferences>

            </EasyView>

My siremisCharts.xml

<Chart name="sumdialogs" table="active_dialogs"
title="Active_Failed_Dialogs" type="area" order="reverse"

orderby="ORDER BY id DESC" limit="LIMIT 10080">

  <XAxis>

          <Item

name="date_created" data="date_created" title="date_created"
type="timestamp"/>

  </XAxis>
     
  <YAxis>
     
          <Item

name="active_dialogs" data="active_dialogs"
title="active_dialogs" type="dataset" color="#D02020"/>

    <Item

name="failed_dialogs" data="failed_dialogs"
title="failed_dialogs" type="dataset" color="#DFC329"/>

 </YAxis>
</Chart>

See bellow, the portion of the table used to build the graphic, the column
"date_created" is the problem, and the format is
"TIMESTAMP"

---

id, date_created, active_dialogs,

early_dialogs, expired_dialogs, failed_dialogs,
processed_dialogs,
'1', '2017-04-11 14:40:40', '220', '0',
'1219', '37', '6879491'
'2', '2017-04-11 14:42:02', '206', '0',
'1219', '37', '6879604'
'3', '2017-04-11 14:43:01', '215', '0',
'1219', '37', '6879685'
'4', '2017-04-11 14:44:01', '191', '0',
'1220', '37', '6879744'
'5', '2017-04-11 14:45:02', '203', '0',
'1220', '37', '6879837'
'9', '2017-04-11 14:46:01', '211', '0',
'1220', '37', '6879929'
'11', '2017-04-11 14:47:01', '234',
'0', '1220', '37', '6880019'
'12', '2017-04-11 14:48:01', '222',
'0', '1220', '37', '6880087'

Graph

Installed Siremis successfully but getting error ~/siremis/system/general_default - page not found.
a2enmod rewrite, prepare24 commands does not generate ~/siremis/system folder. How this folder is created? Could not find anything in Makefile when this folder is created. Any pointers to debug are highly appreciated.

Siremis seems to calculate times based on a wrong timezone.
In "ACC charts" I can see "Timezone: America/Los_Angeles".
Kamailio on the other hand uses the right timezone.

Is there a way to change the timezone in Siremis?

PHP Fatal error: Call to a member function getQuoted() on array in /var/www/siremis-4.2.0/openbiz/bin/data/BizDataSql.php on line 237, referer: http://yourdomain.com/siremis/system/user_detail/1

[2019-05-31 09:19:57 (GMT)] An exception occurred while executing this script:
Error message: #2, A non-numeric value encountered
Script name and line number of error: /var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d code:1

function: errorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d code 1
function: eval ( ) @ /var/www/html/siremis/openbiz/bin/Expression.php 336
function: evaluateExpression ( "menu.form.MenuTreeForm.UpdateFieldValue({@:Elem[fld_Id].Value},f...", Object(EasyFormTree) ) @ /var/www/html/siremis/openbiz/bin/easy/element/Element.php 637
function: getFormedFunction ( ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnSorting.php 90
function: getBtnFunction ( "fld_sortorder_up" ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnSorting.php 7
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 54
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 94
function: renderTable ( Array(132) ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 70
function: renderSmarty ( Object(EasyFormTree), "/var/www/html/siremis/siremis/modules/menu/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyFormTree) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/menu/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "menu.view.MenuTreeView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3
Please ask system administrator for help...

Hello,

I've just installed siremis, all went well, no errors. Until i tried to login with the default admin/admin.

I got:

[{"target":"ERROR","content":"
\n[2017-05-17 09:41:28 (GMT)] An exception occurred while executing this script:
\nError message: #8192, Non-static method BizSystem::getConfiguration() should not be called statically, assuming $this from incompatible context</font>
\nScript name and line number of error: /home/www/siremis/openbiz/bin/data/BizDataObj_Abstract.php:268</font>
\n

function:</b> errorHandler ( 8192, "Non-static method BizSystem::getConfiguration() should not be ca...", "/home/www/siremis/openbiz/bin/data/BizDataObj_Abstract.php", 268, Array(0) ) @ /home/www/siremis/openbiz/bin/sysheader.inc 117\n
function:</b> userErrorHandler ( 8192, "Non-static method BizSystem::getConfiguration() should not be ca...", "/home/www/siremis/openbiz/bin/data/BizDataObj_Abstract.php", 268, Array(0) ) @ /home/www/siremis/openbiz/bin/data/BizDataObj_Abstract.php 268\n
function:</b> setQuoteIdentifiers ( ) @ /home/www/siremis/openbiz/bin/data/BizDataObj_Abstract.php 177\n
function:</b> __construct ( Array(1) ) @ /home/www/siremis/openbiz/bin/data/BizDataObj.php 37\n
function:</b> __construct ( Array(1) ) @ /home/www/siremis/openbiz/bin/ObjectFactory.php 166\n
function:</b> constructObject ( "system.do.UserDO" ) @ /home/www/siremis/openbiz/bin/ObjectFactory.php 56\n
function:</b> getObject ( "system.do.UserDO", 0 ) @ /home/www/siremis/openbiz/bin/BizSystem.php 252\n
function:</b> getObject ( "system.do.UserDO" ) @ /home/www/siremis/siremis/modules/service/authService.php 92\n
function:</b> authDBUser ( "admin", "admin" ) @ /home/www/siremis/siremis/modules/service/authService.php 66\n
function:</b> authenticateUser ( "admin", "admin" ) @ /home/www/siremis/siremis/modules/user/form/LoginForm.php 92\n
function:</b> Login ( ) @ /home/www/siremis/openbiz/bin/BizController.php 310\n
function:</b> invoke ( ) @ /home/www/siremis/openbiz/bin/BizController.php 110\n
function:</b> dispatchRequest ( ) @ /home/www/siremis/openbiz/bin/BizController.php 32\n
function:</b> include_once ( "/home/www/siremis/openbiz/bin/BizController.php" ) @ /home/www/siremis/siremis/bin/controller.php 6</div>\n
Please ask system administrator for help...</div>\n"}]

[2019-05-31 09:16:55 (GMT)] An exception occurred while executing this script:
Error message: #2, Declaration of RegionListbox::getFromList(&$list) should be compatible with OptionElement::getFromList(&$list, $selectFrom = NULL)
Script name and line number of error: /var/www/html/siremis/siremis/modules/translation/form/RegionListbox.php:3

function: errorHandler ( 2, "Declaration of RegionListbox::getFromList(&$list) should be comp...", "/var/www/html/siremis/siremis/modules/translation/form/RegionLis...", 3, Array(6) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "Declaration of RegionListbox::getFromList(&$list) should be comp...", "/var/www/html/siremis/siremis/modules/translation/form/RegionLis...", 3, Array(6) ) @ /var/www/html/siremis/siremis/modules/translation/form/RegionListbox.php 3
function: require_once ( "/var/www/html/siremis/siremis/modules/translation/form/RegionLis..." ) @ /var/www/html/siremis/openbiz/bin/sysclass.inc 220
function: __construct ( Array(10), "", Object(LanguageForm) ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 32
function: __construct ( Array(10), "", Object(LanguageForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 154
function: readMetadata ( Array(1) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 120
function: __construct ( Array(1) ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 166
function: constructObject ( "translation.form.LanguageNewForm" ) @ /var/www/html/siremis/openbiz/bin/ObjectFactory.php 56
function: getObject ( "translation.form.LanguageNewForm" ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 938
function: _showForm ( "translation.form.LanguageNewForm", Null, Array(0) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1747
function: switchForm ( "translation.form.LanguageNewForm" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 311
function: invoke ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 110
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6

Hi,

I just installed latest 4.2 on a Debian Wheezy machine running PHP 5.5.17.

It seems that siremis isn't compatible with 5.5.17 since whenever I click on a menu item (like clear cache or try to edit a user profile) I get the following error.
[2015-08-05 15:08:32 (GMT)] An exception occurred while executing this script:
Error message: #8192, preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead
Script name and line number of error: /var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty_Compiler.class.php:270

function: errorHandler ( 8192, "preg_replace(): The /e modifier is deprecated, use preg_replace_...", "/var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty_Compile...", 270, Array(8) ) @ /var/www/siremis-4.2.0/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 8192, "preg_replace(): The /e modifier is deprecated, use preg_replace_...", "/var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty_Compile...", 270, Array(8) ) @
function: preg_replace ( "~{*(.?)_}|{\s_literal\s}(.?){\s/literal\s_}|{\s_php...", "'{php' . str_repeat(" ", substr_count('\0', " ")) .'}'", "{php} $this->assign('template_file', 'system_right_listform_grou..." ) @ /var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty_Compiler.class.php 270
function: _compile_file ( "/var/www/siremis-4.2.0/siremis/modules/cache/template/grouping.t...", "{php} $this->assign('template_file', 'system_right_listform_grou...", Null ) @ /var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty.class.php 1484
function: _compile_source ( "/var/www/siremis-4.2.0/siremis/modules/cache/template/grouping.t...", "{php} $this->assign('template_file', 'system_right_listform_grou...", Null, "/var/www/siremis-4.2.0/siremis/themes/default/template/cpl/%%5F^..." ) @ /var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty.class.php 1417
function: _compile_resource ( "/var/www/siremis-4.2.0/siremis/modules/cache/template/grouping.t...", "/var/www/siremis-4.2.0/siremis/themes/default/template/cpl/%%5F^..." ) @ /var/www/siremis-4.2.0/openbiz/others/Smarty/libs/Smarty.class.php 1256
function: fetch ( "/var/www/siremis-4.2.0/siremis/modules/cache/template/grouping.t..." ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/FormRenderer.php 95
function: renderSmarty ( Object(CacheForm), "/var/www/siremis-4.2.0/siremis/modules/cache/template/grouping.t..." ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(CacheForm) ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/EasyForm.php 1610
function: rerender ( ) @ /var/www/siremis-4.2.0/openbiz/bin/easy/EasyForm.php 1289
function: updateForm ( ) @ /var/www/siremis-4.2.0/siremis/modules/cache/form/CacheForm.php 43
function: ClearAll ( ) @ /var/www/siremis-4.2.0/openbiz/bin/BizController.php 310
function: invoke ( ) @ /var/www/siremis-4.2.0/openbiz/bin/BizController.php 110
function: dispatchRequest ( ) @ /var/www/siremis-4.2.0/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/siremis-4.2.0/openbiz/bin/BizController.php" ) @ /var/www/siremis-4.2.0/siremis/bin/controller.php 6
Please ask system administrator for help...

Is there a workaround available beyond downgrading PHP to 5.4?

Cheers,
Peter

I'm unable to login to Siremis when using IPv6. The error is:

Error in query:: INSERT INTO event_log (user_id, ipaddr, event, message, comment, timestamp) VALUES (:_v1, :_v2, :_v3, :_v4, :_v5, :_v6). SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'ipaddr' at row 1

The column ipaddr isn't long enough for IPv6 addresses and needs to be extended. I'm using the latest master.

Fresh Install
Kamailio v5.1
Siremis from master branch https://github.com/asipto/siremis.git
PHP v7.2
php-mysql php-gd php-curl php-xml php-xmlrpc php-json libapache2-mod-php php-pear

No errors in Kamailio log but

Error message web popup says -

'

[{"target":"ERROR","content":"
\n[2018-07-17 16:35:34 (GMT)] An exception occurred while executing this script:
\nError message: #2, Use of undefined constant META_PATH - assumed 'META_PATH' (this will throw an Error in a future version of PHP)<\/font>
\nScript name and line number of error: \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/Resource.php:242<\/font>
\n

function:<\/b> errorHandler ( 2, \"Use of undefined constant META_PATH - assumed 'META_PATH' (this ...\", \"\/var\/www\/kamailio-5.1.0\/openbiz\/bin\/Resource.php\", 242, Array(2) ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/sysheader.inc 117\n
function:<\/b> userErrorHandler ( 2, \"Use of undefined constant META_PATH - assumed 'META_PATH' (this ...\", \"\/var\/www\/kamailio-5.1.0\/openbiz\/bin\/Resource.php\", 242, Array(2) ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/Resource.php 242\n
function:<\/b> getXmlFileWithPath ( \"service.logService\" ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizSystem.php 549\n
function:<\/b> getXmlFileWithPath ( \"service.logService\" ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/ObjectFactory.php 104\n
function:<\/b> constructObject ( \"service.logService\" ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/ObjectFactory.php 56\n
function:<\/b> getObject ( \"service.logService\", 0 ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizSystem.php 252\n
function:<\/b> getObject ( \"service.logService\", 0 ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizSystem.php 241\n
function:<\/b> getService ( \"service.logService\" ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizSystem.php 507\n
function:<\/b> log ( 7, \"DATAOBJ\", \"Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, ...\" ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/data\/BizDataObj_Lite.php 438\n
function:<\/b> _run_search ( Array(2) ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/data\/BizDataObj_Lite.php 345\n
function:<\/b> fetchRecords ( \"[username]='admin' and status='1'\", Array(0), 1 ) @ \/var\/www\/kamailio-5.1.0\/siremis\/modules\/service\/authService.php 98\n
function:<\/b> authDBUser ( \"admin\", \"admin\" ) @ \/var\/www\/kamailio-5.1.0\/siremis\/modules\/service\/authService.php 66\n
function:<\/b> authenticateUser ( \"admin\", \"admin\" ) @ \/var\/www\/kamailio-5.1.0\/siremis\/modules\/user\/form\/LoginForm.php 93\n
function:<\/b> Login ( ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizController.php 310\n
function:<\/b> invoke ( ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizController.php 110\n
function:<\/b> dispatchRequest ( ) @ \/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizController.php 32\n
function:<\/b> include_once ( \"\/var\/www\/kamailio-5.1.0\/openbiz\/bin\/BizController.php\" ) @ \/var\/www\/kamailio-5.1.0\/siremis\/bin\/controller.php 6<\/div>\n
Please ask system administrator for help...<\/div>\n"}]

'

I struggled to get to this point, I am on Ubuntu 16.10 and I am getting the following error after selecting all options on the "Database Configuration page"

ERROR: SQLSTATE[HY000] [1045] Access denied for user 'siremis'@'localhost' (using password: YES)

If there is a solution, please include step by step instructions as I am a novice at command line computing.

hello, I think that last modified date should correspond at the time when the change occurs and not somewhere in the 1900......

Hello,

Just installed SIREMIS (4.3.0) on a kamailio 5, everything works with the admin user, but when creating a SIP USER, after clicking on "Save" the page goes to http://1.2.3.4/siremis/system/user_detail/5 which just shows a blank page.

Nevertheless, the user IS created and shows up on the "user management", but when the user tried to login, after clicking on "login", it shows a "processing login" and a pop-up comes up (http://1.2.3.4/siremis/index.php/user/login) which just show a "1"

here's the log:

{code} 
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin, T0.lastlogout, T0.create_by, T0.create_time, T0.update_by, T0.update_time FROM  user T0  WHERE T0.username='nocadmin' and status='1'  LIMIT 1 BIND: ','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin, T0.lastlogout, T0.create_by, T0.create_time, T0.update_by, T0.update_time FROM  user T0  WHERE T0.username='nocadmin'  LIMIT 1 BIND: ','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Query Sql = SELECT T0.id, T0.first_name, T0.last_name, T0.display_name, T0.company, T0.department, T0.position, T0.fast_index, T0.photo, T0.phone, T0.mobile, T0.fax, T0.zipcode, T0.province, T0.city, T0.street, T0.country, T0.email, T0.webpage, T0.qq, T0.icq, T0.skype, T0.yahoo, T0.misc, T0.type_id, T1.name, T0.sortorder, T0.user_id, T0.published, T0.default, T0.access, T0.params, T0.create_by, T0.create_time, T0.update_by, T0.update_time FROM  contact T0  LEFT JOIN contact_type T1 ON T1.id = T0.type_id  WHERE (T0.published=1 or T0.user_id='4') AND T0.user_id='4' ORDER BY T0.sortorder ASC, T0.id ASC  LIMIT 1 BIND: ','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Query Sql = SELECT T0.id, T0.user_id, T0.role_id, T1.name, T1.startpage FROM  user_role T0  INNER JOIN role T1 ON T1.id = T0.role_id  WHERE T0.user_id='4'  BIND: ','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Insert Sql = INSERT INTO  event_log (user_id, ipaddr, event, message, comment, timestamp) VALUES (:_v1, :_v2, :_v3, :_v4, :_v5, :_v6); BIND: 4,6.7.8.9,LOGIN,MSG_LOGIN_SUCCESSFUL,a:2:{i:0;s:8:"nocadmin";i:1;s:13:"6.7.8.9";},2017-04-27 20:25:22','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','New record Id is 14','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Query Sql = SELECT T0.id, T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin, T0.lastlogout, T0.create_by, T0.create_time, T0.update_by, T0.update_time FROM  user T0  WHERE T0.username='nocadmin'  LIMIT 1 BIND: ','n/a'
'04/27/2017','20:25:22','DEBUG','DATAOBJ','Update Sql = UPDATE user SET lastlogin = :_v1, update_by = :_v2, update_time = :_v3 WHERE id='4'; BIND: 2017-04-27 20:25:22,4,2017-04-27 20:25:22','n/a'
{code}

nothing else is shown, nothing happens...

Thanks for your help!

[2019-05-31 09:22:13 (GMT)] An exception occurred while executing this script:
Error message: #2, A non-numeric value encountered
Script name and line number of error: /var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d code:1

function: errorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 2, "A non-numeric value encountered", "/var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d...", 1, Array(7) ) @ /var/www/html/siremis/openbiz/bin/Expression.php(336) : eval()'d code 1
function: eval ( ) @ /var/www/html/siremis/openbiz/bin/Expression.php 336
function: evaluateExpression ( "help.form.HelpCategoryListForm.UpdateFieldValue({@:Elem[fld_Id]....", Object(HelpCategoryForm) ) @ /var/www/html/siremis/openbiz/bin/easy/element/Element.php 637
function: getFormedFunction ( ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnSorting.php 90
function: getBtnFunction ( "fld_sortorder_up" ) @ /var/www/html/siremis/openbiz/bin/easy/element/ColumnSorting.php 7
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 54
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/Panel.php 94
function: renderTable ( Array(7) ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 70
function: renderSmarty ( Object(HelpCategoryForm), "/var/www/html/siremis/siremis/modules/help/template/grid.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(HelpCategoryForm) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView), "/var/www/html/siremis/siremis/modules/help/template/view.tpl" ) @ /var/www/html/siremis/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/html/siremis/openbiz/bin/easy/EasyView.php 237
function: render ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 221
function: renderView ( "help.view.HelpCategoryView", "", "", Null, "" ) @ /var/www/html/siremis/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @ /var/www/html/siremis/openbiz/bin/BizController.php 32
function: include_once ( "/var/www/html/siremis/openbiz/bin/BizController.php" ) @ /var/www/html/siremis/siremis/bin/controller.php 6
function: include ( "/var/www/html/siremis/siremis/bin/controller.php" ) @ /var/www/html/siremis/siremis/bin/_forward.php 102
function: include ( "/var/www/html/siremis/siremis/bin/_forward.php" ) @ /var/www/html/siremis/siremis/index.php 3
Please ask system administrator for help...

Report to admin
Show Error
System Internal Error

Sorry, our system is encountered an unexpected internal errors .
Please REPORT the problem to our system administrator by clicking the below button,
Our support team will try to solve the problem as soon as possible.

We are sorry for any inconvenience.

Report to admin
Show Error

Sorry, it wouldn't let me open the previous issue.

Thanks, for quick fix...now new error:

[2018-07-17 18:13:53 (GMT)] An exception occurred while executing this script:
Error message: #8192, The each() function is deprecated. This message will be suppressed on further calls
Script name and line number of error: /var/www/kamailio-5.1.0/openbiz/others/Zend/Cache/Backend.php:66

function: errorHandler ( 8192, "The each() function is deprecated. This message will be suppress...", "/var/www/kamailio-5.1.0/openbiz/others/Zend/Cache/Backend.php", 66, Array(1) ) @ /var/www/kamailio-5.1.0/openbiz/bin/sysheader.inc 117 
function: userErrorHandler ( 8192, "The each() function is deprecated. This message will be suppress...", "/var/www/kamailio-5.1.0/openbiz/others/Zend/Cache/Backend.php", 66, Array(1) ) @ 
function: each ( Array(7) ) @ /var/www/kamailio-5.1.0/openbiz/others/Zend/Cache/Backend.php 66 
function: __construct ( Array(7) ) @ /var/www/kamailio-5.1.0/openbiz/others/Zend/Cache/Backend/File.php 119 
function: __construct ( Array(7) ) @ /var/www/kamailio-5.1.0/openbiz/others/Zend/Cache.php 152 
function: _makeBackend ( "File", Array(7), False, False ) @ /var/www/kamailio-5.1.0/openbiz/others/Zend/Cache.php 93 
function: factory ( "Core", "File", Array(4), Array(7) ) @ /var/www/kamailio-5.1.0/openbiz/bin/service/cacheService.php 166 
function: init ( "menu.do.MenuTreeDO", "7200" ) @ /var/www/kamailio-5.1.0/openbiz/bin/data/BizDataObj_Lite.php 422 
function: _run_search ( Null ) @ /var/www/kamailio-5.1.0/openbiz/bin/data/BizDataObj_Lite.php 281 
function: directFetch ( "[PId]='System' AND [published] = 1" ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/do/MenuTreeDO.php 59 
function: fetchTreeBySearchRule ( "[PId]='System'", "2", "[published] = 1" ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/widget/MenuWidget.php 79 
function: fetchMenuTree ( ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/widget/MenuWidget.php 93 
function: outputAttrs ( ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/widget/MenuRenderer.php 54 
function: renderSmarty ( Object(MenuWidget), "/var/www/kamailio-5.1.0/siremis/modules/menu/template/sitemap_me..." ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/widget/MenuRenderer.php 39 
function: render ( Object(MenuWidget) ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/widget/MenuWidget.php 72 
function: renderHTML ( ) @ /var/www/kamailio-5.1.0/siremis/modules/menu/widget/MenuWidget.php 65 
function: render ( ) @ /var/www/kamailio-5.1.0/openbiz/bin/easy/ViewRenderer.php 83 
function: renderSmarty ( Object(EasyView), "/var/www/kamailio-5.1.0/siremis/themes/default/template/system_v..." ) @ /var/www/kamailio-5.1.0/openbiz/bin/easy/ViewRenderer.php 40 
function: render ( Object(EasyView) ) @ /var/www/kamailio-5.1.0/openbiz/bin/easy/EasyView.php 274 
function: _render ( ) @ /var/www/kamailio-5.1.0/openbiz/bin/easy/EasyView.php 237 
function: render ( ) @ /var/www/kamailio-5.1.0/openbiz/bin/BizController.php 221 
function: renderView ( "system.view.GeneralDefaultView", "", "", Null, "" ) @ /var/www/kamailio-5.1.0/openbiz/bin/BizController.php 107 
function: dispatchRequest ( ) @ /var/www/kamailio-5.1.0/openbiz/bin/BizController.php 32 
function: include_once ( "/var/www/kamailio-5.1.0/openbiz/bin/BizController.php" ) @ /var/www/kamailio-5.1.0/siremis/bin/controller.php 6 
function: include ( "/var/www/kamailio-5.1.0/siremis/bin/controller.php" ) @ /var/www/kamailio-5.1.0/siremis/bin/_forward.php 102 
function: include ( "/var/www/kamailio-5.1.0/siremis/bin/_forward.php" ) @ /var/www/kamailio-5.1.0/siremis/index.php 3

but the fix for that is

//        while (list($name, $value) = each($options))
    foreach( $options as $name => $value
    {
        $this->setOption($name, $value);
    }

Then there is a new error that I am not sure how to fix...

[2018-07-17 18:37:09 (GMT)] An exception occurred while executing this script:
Error message: #2, count(): Parameter must be an array or an object that implements Countable
Script name and line number of error: /var/www/kamailio-5.1.0/openbiz/bin/ErrorHandler.php:132

function: errorHandler ( 2, "count(): Parameter must be an array or an object that implements...", "/var/www/kamailio-5.1.0/openbiz/bin/ErrorHandler.php", 132, Array(4) ) @ /var/www/kamailio-5.1.0/openbiz/bin/sysheader.inc 117 
function: userErrorHandler ( 2, "count(): Parameter must be an array or an object that implements...", "/var/www/kamailio-5.1.0/openbiz/bin/ErrorHandler.php", 132, Array(4) ) @ /var/www/kamailio-5.1.0/openbiz/bin/ErrorHandler.php 132 
function: _errorBacktrace ( Array(22) ) @ /var/www/kamailio-5.1.0/openbiz/bin/ErrorHandler.php 75 
function: exceptionHandler ( Object(ParseError) ) @ /var/www/kamailio-5.1.0/openbiz/bin/sysheader.inc 128 
function: userExceptionHandler ( Object(ParseError) ) @
Please ask system administrator for help...

Thank you for your assistance

Entering a password that ends in a non-alphanumeric character such as +%$! etc results in the following error:

[2017-06-09 15:34:09 (GMT)] An exception occurred while executing this script:
Error message: #256, EVAL: $ret = password!, 4, 20; 
Script name and line number of error: /var/www/siremis/openbiz/bin/Expression.php:384

function: errorHandler ( 256, "EVAL: $ret = password!, 4, 20; ", "/var/www/siremis/openbiz/bin/Expression.php", 384, Array(6) ) @ /var/www/siremis/openbiz/bin/sysheader.inc 117 
function: userErrorHandler ( 256, "EVAL: $ret = password!, 4, 20; ", "/var/www/siremis/openbiz/bin/Expression.php", 384, Array(6) ) @ 
function: trigger_error ( "EVAL: $ret = password!, 4, 20; ", 256 ) @ /var/www/siremis/openbiz/bin/Expression.php 384 
function: eval_syntax ( "$ret = password!, 4, 20;" ) @ /var/www/siremis/openbiz/bin/Expression.php 327 
function: evaluateExpression ( "{[fld_password], 4, 20}", Object(UserForm) ) @ /var/www/siremis/openbiz/bin/Expression.php 190 
function: replaceVarExpr ( "@validate:betweenLength([fld_password], 4, 20)", Object(UserForm) ) @ /var/www/siremis/openbiz/bin/Expression.php 311 
function: evaluateExpression ( "{@validate:betweenLength([fld_password], 4, 20)}", Object(UserForm) ) @ /var/www/siremis/openbiz/bin/easy/element/Element.php 472 
function: validate ( ) @ /var/www/siremis/openbiz/bin/easy/EasyForm.php 1370 
function: validateForm ( ) @ /var/www/siremis/siremis/modules/system/form/UserForm.php 146 
function: validateForm ( ) @ /var/www/siremis/siremis/modules/system/form/UserForm.php 106 
function: UpdateUser ( ) @ /var/www/siremis/openbiz/bin/BizController.php 310 
function: invoke ( ) @ /var/www/siremis/openbiz/bin/BizController.php 110 
function: dispatchRequest ( ) @ /var/www/siremis/openbiz/bin/BizController.php 32 
function: include_once ( "/var/www/siremis/openbiz/bin/BizController.php" ) @ /var/www/siremis/siremis/bin/controller.php 6

Steps to reproduce:
1. Go to Users ---> User Management
2. Click Add to add a new user or click on an existing user and then select edit.
3. In the password field enter a password that ends in a non-alphanumeric character such as password! and then click save.
4. A popup window is displayed indicating an exception occured