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.