[SR-Users] Siremis on Mysql and Kamailio on Postgresql

[Victor Seva]

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.