I've setup a siremis installation using Mysql for the siremis tables. Kamailio is installed with postgresql on another machine. I selected Postgresql in seremis setup under SIP DB and correctly inserted the right username/password/host. Connection was successful.
I can login to Siremis (ver 3.2.0) and access the Admin menu successfully. However when I access the Ser Menu, all the options give errors:
For example, trying to to select Server Services, Domain List gives the following errors:
[2012-04-05 18:11:36 (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: /usr/local/siremis-3.2.0/openbiz/bin/Resource.php:283
*function:* 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 *function:* userErrorHandler ( 256, "Unable to location template file system_internal_error.tpl.", "/usr/local/siremis-3.2.0/openbiz/bin/Resource.php", 283, Array(11) ) @ *function:* trigger_error ( "Unable to location template file system_internal_error.tpl.", 256 ) @ /usr/local/siremis-3.2.0/openbiz/bin/Resource.php 283 *function:* getTplFileWithPath ( "system_internal_error.tpl", "email" ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizSystem.php 544 *function:* getTplFileWithPath ( "system_internal_error.tpl", "email" ) @ /usr/local/siremis-3.2.0/siremis/modules/service/userEmailService.php 108 *function:* SystemInternalErrorEmail ( Array(2), Null ) @ /usr/local/siremis-3.2.0/siremis/modules/common/form/ErrorForm.php 34 *function:* Report ( ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizController.php 310 *function:* invoke ( ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizController.php 110 *function:* dispatchRequest ( ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizController.php 32 *function:* include_once ( "/usr/local/siremis-3.2.0/openbiz/bin/BizController.php" ) @ /usr/local/siremis-3.2.0/siremis/bin/controller.php 6 ------------------------------ * * Similarly. the all the other optiones under the Ser Menu give errors.
My Config.xml (passwords and IPs modified) follows:
<?xml version="1.0" standalone="no"?> <Config> <DataSource> <Database Name="Default" Driver="Pdo_Mysql" Server="localhost" Port="3306" DB Name="siremis" User="siremis" Password="siremisrw" Charset="utf8"/> <Database Name="Serdb" Driver="Pdo_Pgsql" Server="x.x.x.x" Port="5432" DBName="dbname" User="dbuser" Password="123456" Charset="utf8"/> </DataSource> </Config>
Please advise.
Many thanks
Jonny
* *
Hello,
the errors sent seem to be related to a template file not found. Do you get errors related to postgres connection?
If you try to set a temporary kamailio database in the mysql, does this error go away?
Cheers, Daniel
On 4/5/12 8:17 PM, Jonny Klompas wrote:
I've setup a siremis installation using Mysql for the siremis tables. Kamailio is installed with postgresql on another machine. I selected Postgresql in seremis setup under SIP DB and correctly inserted the right username/password/host. Connection was successful.
I can login to Siremis (ver 3.2.0) and access the Admin menu successfully. However when I access the Ser Menu, all the options give errors:
For example, trying to to select Server Services, Domain List gives the following errors:
[2012-04-05 18:11:36 (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: /usr/local/siremis-3.2.0/openbiz/bin/Resource.php:283
*function:* 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 *function:* userErrorHandler ( 256, "Unable to location template file system_internal_error.tpl.", "/usr/local/siremis-3.2.0/openbiz/bin/Resource.php", 283, Array(11) ) @ *function:* trigger_error ( "Unable to location template file system_internal_error.tpl.", 256 ) @ /usr/local/siremis-3.2.0/openbiz/bin/Resource.php 283 *function:* getTplFileWithPath ( "system_internal_error.tpl", "email" ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizSystem.php 544 *function:* getTplFileWithPath ( "system_internal_error.tpl", "email" ) @ /usr/local/siremis-3.2.0/siremis/modules/service/userEmailService.php 108 *function:* SystemInternalErrorEmail ( Array(2), Null ) @ /usr/local/siremis-3.2.0/siremis/modules/common/form/ErrorForm.php 34 *function:* Report ( ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizController.php 310 *function:* invoke ( ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizController.php 110 *function:* dispatchRequest ( ) @ /usr/local/siremis-3.2.0/openbiz/bin/BizController.php 32 *function:* include_once ( "/usr/local/siremis-3.2.0/openbiz/bin/BizController.php" ) @ /usr/local/siremis-3.2.0/siremis/bin/controller.php 6
Similarly. the all the other optiones under the Ser Menu give errors.
My Config.xml (passwords and IPs modified) follows:
<?xml version="1.0" standalone="no"?>
<Config> <DataSource> <Database Name="Default" Driver="Pdo_Mysql" Server="localhost" Port="3306" DB Name="siremis" User="siremis" Password="siremisrw" Charset="utf8"/> <Database Name="Serdb" Driver="Pdo_Pgsql" Server="x.x.x.x" Port="5432" DBName="dbname" User="dbuser" Password="123456" Charset="utf8"/> </DataSource> </Config>
Please advise.
Many thanks
Jonny
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
Hi there,
I've just installed Siremis (3.2.0) with the same combination, mysql for siremis and postgresql for an already working kamailio server. I will like to point out that it was impossible for me to install Siremis on postgresql, all the sql statements are for mysql server.
And the problem is that the ser module is not working. It seems that OpenBiz is creating this querys:
"SELECT T0.id, T0.domain, T0.last_modified FROM `domain` T0 LIMIT 10" "SELECT T0.id, T0.setid, T0.destination, T0.flags, T0.priority, T0.attrs, T0.description FROM `dispatcher` T0 LIMIT 10" "SELECT T0.id, T0.lcr_id, T0.rule_id, T0.gw_id, T0.priority, T0.weight FROM `lcr_rule_target` T0 LIMIT 10"
These querys wont work with postgresql because the `table_name`.
"SELECT T0.id, T0.domain, T0.last_modified FROM domain T0 LIMIT 10" "SELECT T0.id, T0.setid, T0.destination, T0.flags, T0.priority, T0.attrs, T0.description FROM dispatcher` T0 LIMIT 10" "SELECT T0.id, T0.lcr_id, T0.rule_id, T0.gw_id, T0.priority, T0.weight FROM `lcr_rule_target` T0 LIMIT 10"
Works fine.
2012/4/12 Victor Seva linuxmaniac@torreviejawireless.org: [...]
These querys wont work with postgresql because the `table_name`.
[...]
As I said It seems to me that the problem is in openbiz:
root@zs2:/var/www# grep -n ` siremis-3.2.0/openbiz/bin/data/BizDataSql.php 49: $this->_tableJoins = " `$mainTable` T0 "; 77: $this->_tableJoins .= " $joinType `$table` $alias ON $alias.$column = $aliasRef.$columnRef "; 248: $this->_tableJoins .= " INNER JOIN `$xtable` $xalias ON $xalias.$column2 = $mytable_col ";
Has anyone a working installation of siremis with kamailio on postgresql ? Greetings
This patch seems to do the trick.
root@zs2:/var/www/siremis-3.2.0# diff -ruN openbiz/bin/data/BizDataSql.php~ openbiz/bin/data/BizDataSql.php --- openbiz/bin/data/BizDataSql.php~ 2010-09-15 15:09:29.000000000 +0200 +++ openbiz/bin/data/BizDataSql.php 2012-04-16 10:23:38.000000000 +0200 @@ -46,7 +46,7 @@ public function addMainTable($mainTable) { $this->_mainTable = "$mainTable"; - $this->_tableJoins = " `$mainTable` T0 "; + $this->_tableJoins = " $mainTable T0 "; }
/** @@ -74,7 +74,7 @@ $this->_joinAliasList[$tableJoin->m_Name] = $alias; $this->_tableAliasList[$table] = $alias; $aliasRef = $this->getJoinAlias($joinRef); - $this->_tableJoins .= " $joinType `$table` $alias ON $alias.$column = $aliasRef.$columnRef "; + $this->_tableJoins .= " $joinType $table $alias ON $alias.$column = $aliasRef.$columnRef "; }
/** @@ -245,7 +245,7 @@ //if (strpos($this->m_TableJoins, "JOIN $xtable") === false) if (!isset($this->_tableAliasList[$xtable])) { - $this->_tableJoins .= " INNER JOIN `$xtable` $xalias ON $xalias.$column2 = $mytable_col "; + $this->_tableJoins .= " INNER JOIN $xtable $xalias ON $xalias.$column2 = $mytable_col "; $this->_tableAliasList[$xtable] = $xalias; } // add a new where condition
Hi,
add also this patch to the sourceforge tracker:
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=br...
It will be applied to git -- few questions:
- have you tested and still works with MySQL?
- the last chunk in patch is related to xml config files - does not seem necessary:
--- siremis-3.2.0.orig/siremis/modules/ser/service/siremisCharts.xml 2011-12-14 19:52:59.000000000 +0100 +++ siremis-3.2.0/siremis/modules/ser/service/siremisCharts.xml 2012-04-16 13:23:15.000000000 +0200 @@ -16,7 +16,7 @@ <Item name="time_stamp" data="time_stamp" title="timestamp" type="timestamp"/> </XAxis> <YAxis> - <Item name="2xx_trans_diff" data="2xx_trans_diff" title="2xx trans" type="dataset" color="#FBB917" /> + <Item name="2xx_trans_diff" data="_2xx_trans_diff" title="2xx trans" type="dataset" color="#FBB917" /> </YAxis> </Chart> </ChartGroup>
Regards, Ramona
On 4/16/12 4:09 PM, Victor Seva wrote:
But there are querys on siremis using mysql format.
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
2012/4/16 Elena-Ramona Modroiu ramona@asipto.com:
Hi,
add also this patch to the sourceforge tracker:
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=br...
It will be applied to git -- few questions:
- have you tested and still works with MySQL?
The siremis part is still using Mysql and seems to keep working.
- the last chunk in patch is related to xml config files - does not seem
necessary:
2xx_trans_diff -> _2xx_trans_diff
From postgresql documentation[0]: "SQL identifiers and key words must
begin with a letter (a-z, but also letters with diacritical marks and non-Latin letters) or an underscore (_). "
[0] http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.html#SQL-S...
Hi,
the patch is to phpopenbiz framework, which is not included in siremis git repository. But we can include the patch itself and document it, can you add it as attachment to sourceforge tracker?
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=br...
Regards, Ramona
On 4/16/12 10:30 AM, Victor Seva wrote:
This patch seems to do the trick.
root@zs2:/var/www/siremis-3.2.0# diff -ruN openbiz/bin/data/BizDataSql.php~ openbiz/bin/data/BizDataSql.php --- openbiz/bin/data/BizDataSql.php~ 2010-09-15 15:09:29.000000000 +0200 +++ openbiz/bin/data/BizDataSql.php 2012-04-16 10:23:38.000000000 +0200 @@ -46,7 +46,7 @@ public function addMainTable($mainTable) { $this->_mainTable = "$mainTable";
$this->_tableJoins = " `$mainTable` T0 ";
$this->_tableJoins = " $mainTable T0 "; } /**@@ -74,7 +74,7 @@ $this->_joinAliasList[$tableJoin->m_Name] = $alias; $this->_tableAliasList[$table] = $alias; $aliasRef = $this->getJoinAlias($joinRef);
$this->_tableJoins .= " $joinType `$table` $alias ON$alias.$column = $aliasRef.$columnRef ";
$this->_tableJoins .= " $joinType $table $alias ON$alias.$column = $aliasRef.$columnRef "; }
/**@@ -245,7 +245,7 @@ //if (strpos($this->m_TableJoins, "JOIN $xtable") === false) if (!isset($this->_tableAliasList[$xtable])) {
$this->_tableJoins .= " INNER JOIN `$xtable` $xaliasON $xalias.$column2 = $mytable_col ";
$this->_tableJoins .= " INNER JOIN $xtable $xalias ON$xalias.$column2 = $mytable_col "; $this->_tableAliasList[$xtable] = $xalias; } // add a new where condition
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
2012/4/16 Elena-Ramona Modroiu ramona@asipto.com:
Hi,
the patch is to phpopenbiz framework, which is not included in siremis git repository. But we can include the patch itself and document it, can you add it as attachment to sourceforge tracker?
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=br...
I already contacted with openbiz comunity to point the problem [0].
[0] https://groups.google.com/d/topic/openbiz-cubi/4KdlKRQ9-ng/discussion
Hi,
On 4/17/12 8:23 AM, Victor Seva wrote:
2012/4/16 Elena-Ramona Modroiuramona@asipto.com:
Hi,
the patch is to phpopenbiz framework, which is not included in siremis git repository. But we can include the patch itself and document it, can you add it as attachment to sourceforge tracker?
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=br...
I already contacted with openbiz comunity to point the problem [0].
[0] https://groups.google.com/d/topic/openbiz-cubi/4KdlKRQ9-ng/discussion
great! Still it would be good to have it in siremis tracker on sourceforge, for references in the future and to be easy to find it.
Regards, Ramona
Hi,
2012/5/3 Elena-Ramona Modroiu ramona@asipto.com:
On 4/17/12 8:23 AM, Victor Seva wrote:
I already contacted with openbiz comunity to point the problem [0].
[0] https://groups.google.com/d/topic/openbiz-cubi/4KdlKRQ9-ng/discussion
great! Still it would be good to have it in siremis tracker on sourceforge, for references in the future and to be easy to find it.
there you are [0]
[0] http://sourceforge.net/tracker/?func=detail&aid=3523414&group_id=250...
-
Daniel-Constantin Mierla -
Elena-Ramona Modroiu -
Jonny Klompas -
Victor Seva