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

2012-04-05 Thread Jonny Klompas
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)

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

2012-04-09 Thread Daniel-Constantin Mierla
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 ins

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

2012-04-12 Thread 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 i

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

2012-04-12 Thread Victor Seva
2012/4/12 Victor Seva : [...] > 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:

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

2012-04-16 Thread Victor Seva
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.0 +0200 +++ openbiz/bin/data/BizDataSql.php 2012-04-16 10:23:38.0 +0200 @@ -

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

2012-04-16 Thread Victor Seva
But there are querys on siremis using mysql format. pg.patch Description: Binary data ___ 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

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

2012-04-16 Thread Elena-Ramona Modroiu
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=browse Regards, Ramona On 4

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

2012-04-16 Thread Elena-Ramona Modroiu
Hi, add also this patch to the sourceforge tracker: http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=browse 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 nece

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

2012-04-16 Thread Victor Seva
2012/4/16 Elena-Ramona Modroiu : > Hi, > > add also this patch to the sourceforge tracker: > > http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=browse > > It will be applied to git -- few questions: > > - have you tested and still works with MySQL? The siremis part is still using

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

2012-04-16 Thread Victor Seva
2012/4/16 Elena-Ramona Modroiu : > 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=2

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

2012-05-03 Thread Elena-Ramona Modroiu
Hi, On 4/17/12 8:23 AM, Victor Seva wrote: 2012/4/16 Elena-Ramona Modroiu: 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.ne

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

2012-05-03 Thread Victor Seva
Hi, 2012/5/3 Elena-Ramona Modroiu : > 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 sou