5 Apr
2012
5 Apr
'12
8:17 p.m.
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
*
*
9 Apr
9 Apr
1:31 p.m.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
Kamailio Advanced Training, April 23-26, 2012, Berlin, Germany
http://www.asipto.com/index.php/kamailio-advanced-training/
12 Apr
12 Apr
1:08 p.m.
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.
1:47 p.m.
2012/4/12 Victor Seva <linuxmaniac(a)torreviejawireless.org>rg>:
[...]
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
16 Apr
16 Apr
10:30 a.m.
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
10:28 p.m.
Hi,
add also this patch to the sourceforge tracker:
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=b…
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
17 Apr
17 Apr
8:18 a.m.
2012/4/16 Elena-Ramona Modroiu <ramona(a)asipto.com>om>:
Hi,
add also this patch to the sourceforge tracker:
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=b…
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-…
16 Apr
16 Apr
10:27 p.m.
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=b…
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` $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
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
17 Apr
17 Apr
8:23 a.m.
2012/4/16 Elena-Ramona Modroiu <ramona(a)asipto.com>om>:
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=b…
I already contacted with openbiz comunity to point the problem [0].
[0] https://groups.google.com/d/topic/openbiz-cubi/4KdlKRQ9-ng/discussion
3 May
3 May
10:18 p.m.
Hi,
On 4/17/12 8:23 AM, Victor Seva wrote:
2012/4/16 Elena-Ramona
Modroiu<ramona(a)asipto.com>om>:
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,
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=b…
I
already contacted with openbiz comunity to point the problem [0].
[0] https://groups.google.com/d/topic/openbiz-cubi/4KdlKRQ9-ng/discussion
4 May
4 May
8:21 a.m.
Hi,
2012/5/3 Elena-Ramona Modroiu <ramona(a)asipto.com>om>:
On 4/17/12 8:23 AM, Victor Seva wrote:
there you are [0]
[0]
http://sourceforge.net/tracker/?func=detail&aid=3523414&group_id=25…
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.
4382
days inactive
4411
days old
11 comments
4 participants
participants (4)
-
Daniel-Constantin Mierla -
Elena-Ramona Modroiu -
Jonny Klompas -
Victor Seva