<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
the errors sent seem to be related to a template file not found. Do
you get errors related to postgres connection?<br>
<br>
If you try to set a temporary kamailio database in the mysql, does
this error go away?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
On 4/5/12 8:17 PM, Jonny Klompas wrote:
<blockquote
cite="mid:CAMxjZg-2i5Uey_prFK4vwwos07aPdoDSZ1Z4nsT4sR14apPWtA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_quote">
<div dir="ltr">
<div><br>
</div>
<div>I've setup a siremis installation using Mysql for the
siremis tables. </div>
<div>Kamailio is installed with postgresql on another
machine.</div>
<div>I selected Postgresql in seremis setup under SIP DB and
correctly inserted the right username/password/host.
Connection was successful.<br>
<br>
</div>
<div>I can login to Siremis (ver 3.2.0) and access the Admin
menu successfully.</div>
<div>However when I access the Ser Menu, all the options
give errors:</div>
<div><br>
</div>
<div>For example, trying to to select Server Services,
Domain List gives the following errors:</div>
<div><br>
</div>
<div><span
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)">[2012-04-05
18:11:36 (GMT)] An exception occurred while executing
this script:</span><br
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)">
<span
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)">Error
message: </span><font
style="font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)"
color="maroon">#256, Unable to location template file
system_internal_error.tpl.</font><br
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)">
<span
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)">Script
name and line number of error: </span><font
style="font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)"
color="maroon">/usr/local/siremis-3.2.0/openbiz/bin/Resource.php:283</font><br
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)">
<div
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;background-color:rgb(217,217,217)"><br>
<b>function:</b> errorHandler ( 256, "Unable to location
template file system_internal_error.tpl.",
"/usr/local/siremis-3.2.0/openbiz/bin/Resource.php",
283, Array(11) ) @
/usr/local/siremis-3.2.0/openbiz/bin/sysheader.inc 117 <br>
<b>function:</b> userErrorHandler ( 256, "Unable to
location template file system_internal_error.tpl.",
"/usr/local/siremis-3.2.0/openbiz/bin/Resource.php",
283, Array(11) ) @ <br>
<b>function:</b> trigger_error ( "Unable to location
template file system_internal_error.tpl.", 256 ) @
/usr/local/siremis-3.2.0/openbiz/bin/Resource.php 283 <br>
<b>function:</b> getTplFileWithPath (
"system_internal_error.tpl", "email" ) @
/usr/local/siremis-3.2.0/openbiz/bin/BizSystem.php 544 <br>
<b>function:</b> getTplFileWithPath (
"system_internal_error.tpl", "email" ) @
/usr/local/siremis-3.2.0/siremis/modules/service/userEmailService.php
108 <br>
<b>function:</b> SystemInternalErrorEmail ( Array(2),
Null ) @
/usr/local/siremis-3.2.0/siremis/modules/common/form/ErrorForm.php
34 <br>
<b>function:</b> Report ( ) @
/usr/local/siremis-3.2.0/openbiz/bin/BizController.php
310 <br>
<b>function:</b> invoke ( ) @
/usr/local/siremis-3.2.0/openbiz/bin/BizController.php
110 <br>
<b>function:</b> dispatchRequest ( ) @
/usr/local/siremis-3.2.0/openbiz/bin/BizController.php
32 <br>
<b>function:</b> include_once (
"/usr/local/siremis-3.2.0/openbiz/bin/BizController.php"
) @ /usr/local/siremis-3.2.0/siremis/bin/controller.php
6</div>
<hr
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)"><font
color="#0000ff" face="Arial"><span
style="font-size:12px"><b><br>
</b></span></font></div>
<div>Similarly. the all the other optiones under the Ser
Menu give errors.</div>
<div><br>
</div>
<div>My Config.xml (passwords and IPs modified) follows:</div>
<div><br>
</div>
<div>
<div><?xml version="1.0" standalone="no"?></div>
<div><Config></div>
<div> <DataSource></div>
<div> <Database Name="Default" Driver="Pdo_Mysql"
Server="localhost" Port="3306" DB</div>
<div>Name="siremis" User="siremis" Password="siremisrw"
Charset="utf8"/></div>
<div> <Database Name="Serdb" Driver="Pdo_Pgsql"
Server="x.x.x.x" Port="5432"</div>
<div> DBName="dbname" User="dbuser" Password="123456"
Charset="utf8"/></div>
<div> </DataSource></div>
<div></Config></div>
</div>
<div><br>
</div>
<div>Please advise.</div>
<div><br>
</div>
<div>Many thanks</div>
<div><br>
</div>
<div>Jonny</div>
<div><span
style="color:rgb(0,0,255);font-family:Arial;font-size:12px;font-weight:bold;background-color:rgb(217,217,217)"><br>
</span></div>
<div><font color="#0000ff" face="Arial"><span
style="font-size:12px"><b><br>
</b></span></font></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
<a class="moz-txt-link-freetext" href="http://www.asipto.com/index.php/kamailio-advanced-training/">http://www.asipto.com/index.php/kamailio-advanced-training/</a></pre>
</body>
</html>