Hi list people:
When using Siremis with Kamailio, I see this error:
First Fault
[2017-08-07 22:55:17 (GMT)] An exception occurred while executing this
script:
Error message: #256, Unable to location template file
system_internal_error.tpl.
Script name and line number of error:
/var/www/siremis-4.3.0/openbiz/bin/Resource.php:283
function: errorHandler ( 256, "Unable to location template file
system_internal_error.tpl.",
"/var/www/siremis-4.3.0/openbiz/bin/Resource.php", 283, Array(11) ) @
/var/www/siremis-4.3.0/openbiz/bin/sysheader.inc 117
function: userErrorHandler ( 256, "Unable to location template file
system_internal_error.tpl.",
"/var/www/siremis-4.3.0/openbiz/bin/Resource.php", 283, Array(11) ) @
function: trigger_error ( "Unable to location template file
system_internal_error.tpl.", 256 ) @
/var/www/siremis-4.3.0/openbiz/bin/Resource.php 283
function: getTplFileWithPath ( "system_internal_error.tpl", "email" )
@
/var/www/siremis-4.3.0/openbiz/bin/BizSystem.php 544
function: getTplFileWithPath ( "system_internal_error.tpl", "email" )
@
/var/www/siremis-4.3.0/siremis/modules/service/userEmailService.php 108
function: SystemInternalErrorEmail ( Array(2), Null ) @
/var/www/siremis-4.3.0/siremis/modules/common/form/ErrorForm.php 34
function: Report ( ) @
/var/www/siremis-4.3.0/openbiz/bin/BizController.php 310
function: invoke ( ) @
/var/www/siremis-4.3.0/openbiz/bin/BizController.php 110
function: dispatchRequest ( ) @
/var/www/siremis-4.3.0/openbiz/bin/BizController.php 32
function: include_once (
"/var/www/siremis-4.3.0/openbiz/bin/BizController.php" ) @
/var/www/siremis-4.3.0/siremis/bin/controller.php 6
It looks like I am missing a template file to send a copy of the error
message to the system administrator.
Also: during the installation, I, using the install script, added a
number of tables to the MySQL server. However, it seems I am missing a
few columns in a couple of the tables. Is there some sort of system
sanity script that will check the database for all the required tables
and required columns?
Example:
2017-08-07 23:12:14 (GMT)] An exception occurred while executing this
script:
Error message: #0, Error in query:: SELECT T0.id, T0.setid, T0.url,
T0.flags, T0.weight, T0.description FROM rtpproxy T0 LIMIT 10.
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'kamailio.rtpproxy' doesn't exist
Script name and line number of error:
/var/www/siremis-4.3.0/openbiz/bin/data/BizDataObj_Lite.php:447
or:
[2017-08-07 23:14:58 (GMT)] An exception occurred while executing this
script:
Error message: #0, Error in query:: SELECT T0.id, T0.name, T0.uri,
T0.mohdir, T0.mohfile, T0.debug FROM mohqueues T0 LIMIT 10.
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'kamailio.mohqueues' doesn't exist
or:
[2017-08-07 23:16:57 (GMT)] An exception occurred while executing this
script:
Error message: #42S22, SQLSTATE[42S22]: Column not found: 1054 Unknown
column 'src_user' in 'field list'
Script name and line number of error:
/var/www/siremis-4.3.0/openbiz/others/Zend/Db/Statement/Pdo.php:234
or:
2017-08-07 23:18:33 (GMT)] An exception occurred while executing this
script:
Error message: #0, Error in query:: SELECT T0.id, T0.method,
T0.from_tag, T0.to_tag, T0.callid, T0.sip_code, T0.sip_reason, T0.time,
T0.src_ip, T0.dst_user, T0.dst_domain, T0.dst_ouser, T0.src_user,
T0.src_domain, T0.cdr_id FROM acc T0 WHERE method='INVITE' AND
T0.src_user='admin' LIMIT 10. SQLSTATE[42S22]: Column not found: 1054
Unknown column 'T0.src_ip' in 'field list'
In the case of the above table, it does not say which table.
Anyway -- any help would be great.
Thanks.
Kevin