<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
On 11/3/10 4:03 PM, Maw Zin Tun - Real Telekom wrote:
<blockquote
cite="mid:0MEaNR-1PJvCn2kEj-00FjDC@mrelayeu.kundenserver.de"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.18975">
<div><span class="972340215-03112010"><font face="Georgia"
size="2">Hi List,</font></span></div>
<div><span class="972340215-03112010"><font face="Georgia"
size="2">Any idea how to correct this error ?</font></span></div>
<div><span class="972340215-03112010"></span> </div>
<div><span class="972340215-03112010"><font face="Georgia"
size="2">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]<br>
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...<br>
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<br>
</font></span></div>
<br>
</blockquote>
<font size="2"><font face="Georgia">you have a sql query in your
config that exceeds </font></font>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.<br>
<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>