14 Mar
2014
14 Mar
'14
12:18 p.m.
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