On 11/3/10 4:03 PM, Maw Zin Tun - Real Telekom wrote:
Hi List,
Any idea how to correct this error ?
 
Nov  3 15:01:18 s15391037 /usr/local/kamailio-3.0/sbin/kamailio[27812]: ERROR: <core> [pvapi.c:967]: no more space for text [84]
Nov  3 15:01:18 s15391037 /usr/local/kamailio-3.0/sbin/kamailio[27812]: ERROR: <core> [pvapi.c:995]: buffer overflow -- increase the buffer size...
Nov  3 15:01:18 s15391037 /usr/local/kamailio-3.0/sbin/kamailio[27812]: ERROR: sqlops [sql_api.c:204]: cannot print the sql query

you have a sql query in your config that exceeds 1024 bytes. You have to edit pvapi.c and increase the size of PV_PRINT_BUF_SIZE to a more appropriate value based on your estimation regarding the length of sql query. Then re-compile and re-install kamailio.

Daniel
-- 
Daniel-Constantin Mierla
http://www.asipto.com