[SR-Users] siremis doesn't works with postgresql

[Daniel-Constantin Mierla]

Hello,

On 14/03/14 03:39, Rene Montilva wrote:
> Hi List
>
>
> i want to config siremis with postgresql and really to much things 
> fail for the install, at the end y left the siremis db with mysql and 
> kamailio with postgresql but the problems continue, when i want to 
> show subscriber list from siremis interface, i get an error and check 
> the postgresql log and found this
>
> LOG:  sentencia: SET NAMES 'utf8'
> ERROR:  error de sintaxis en o cerca de «`» en carácter 101
> SENTENCIA:  SELECT T0.id, T0.username, T0.domain, T0.password, 
> T0.email_address, T0.ha1, T0.ha1b, T0.rpid FROM  `subscriber` T0   
> LIMIT 10
>
> what could be the right config?

postgres doesn't seem to like backticks which are used in cubi/openbiz. 
See next links for some discussion and eventual patch to fix it:

- 
https://groups.google.com/forum/#!topic/openbiz-cubi/4KdlKRQ9-ng/discussion
- http://code.google.com/p/openbiz-cubi/issues/detail?id=25

Cheers,
Daniel

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
http://www.kamailioworld.com