<!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">
Hello, <br>
<blockquote cite="mid:621481.87547.qm@web34204.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top">In <span class="ul-threaded"
style="margin: 0.5em 0pt 0pt -20px;"><span class="text-cell"><span>Installation
went fine but when i edit an entry in
load balancer module it gives an error "" Failed to issue query, error
message: MDB2 error: syntax error
</span></span></span><br>
<br>
In the OpenSIPs.cfg file <br>
xmlrpc module is loaded as <br>
""<br>
loadmodule "mi_xmlrpc.so" <span class="ul-threaded"
style="margin: 0.5em 0pt 0pt -20px;"><span class="text-cell"><span></span><br>
modparam("mi_xmlrpc", "log_file", "/var/log/abyss.log")<br>
modparam("mi_xmlrpc", "reply_option", 0)<br>
modparam("mi_xmlrpc", "buffer_size", 8192)<br>
</span></span></td>
</tr>
</tbody>
</table>
</blockquote>
Also add:<br>
<br>
<span class="ul-threaded" style="margin: 0.5em 0pt 0pt -20px;"><span
class="text-cell">m<i>modparam("mi_xmlrpc", "port", 8000)</i></span></span>
<blockquote cite="mid:621481.87547.qm@web34204.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top"><span class="ul-threaded"
style="margin: 0.5em 0pt 0pt -20px;"><span class="text-cell"><br>
""<br>
and i have checked the syslog file and there is some info about
mi_xmlrpc module as<br>
<br>
""" Nov 20 18:17:58 ali-ub-910-1-e-desktop ./sbin/opensips[2703]:
INFO:mi_xmlrpc:xmlrpc_process: starting xmlrpc server """<br>
<br>
but when i run the command</span></span><br>
<pre><i><i>netstat -tal
</i></i><span><span style="font-family: arial;">
there is nothing running on port 8080
</span></span></pre>
</td>
</tr>
</tbody>
</table>
</blockquote>
In OpenSIPS-CP you also need to configure the parameters for xmlrpc. <br>
Check in this file: <i>/var/www/opensips-cp/config/boxes.global.inc.php</i><br>
for the following parameter:<br>
<i> $boxes[$box_id]['mi']['conn']<br>
</i>and set it to the IP where the OpenSIPS proxy resides and the port
the same as the one defined in modparam for xmlrpc in opensips.cfg<br>
<i> $boxes[$box_id]['mi']['conn']="127.0.0.1:8000";</i><br>
<blockquote cite="mid:621481.87547.qm@web34204.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top">
<pre><span><span style="font-family: arial;">
</span>Additionally when i access the Domain Link the error then is
</span>
</pre>
<span class="ul-threaded" style="margin: 0.5em 0pt 0pt -20px;"><span
class="text-cell"><span>"" Fatal error: Call to undefined method
MDB2_Error::setFetchMode() in /var/www/<b class="highlight">opensips</b>-<b
class="highlight">cp</b>/web/tools/domains/lib/db_connect.php on line
16 ""
</span><br>
<br>
<span>and the lin 16 in the file is ""
$link->setFetchMode(MDB2_FETCHMODE_ASSOC); ""
</span><br>
</span></span></td>
</tr>
</tbody>
</table>
</blockquote>
Have you installed the php packages for xmlrpc and mysql?<br>
If u are using debian try installing <i>php5-mysql, php5-xmlrpc</i>
and see if the problems persist.<br>
Below I have given you then link with OpenSIPS-CP documentation:<br>
<i><a class="moz-txt-link-freetext" href="http://opensips-cp.sourceforge.net/">http://opensips-cp.sourceforge.net/</a></i><br>
<blockquote cite="mid:621481.87547.qm@web34204.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top"><span class="ul-threaded"
style="margin: 0.5em 0pt 0pt -20px;"><span class="text-cell"><br>
<span>when i try to access statistics monitor the error
then is "" Failed to issue query, error message : MDB2 Error: no such
table ""
</span><br>
<br>
<span>please guide me to resolve the problem
</span><br>
</span></span></td>
</tr>
</tbody>
</table>
</blockquote>
For solving this error you need to install 2 tables needed for
statistics monitor modules. You can find their structure definition in:
<br>
<i>/var/www/opensips-cp/config/tools/smonitor/tables.mysql<br>
<br>
</i>Best regards,<br>
Iulia Bublea<br>
<blockquote cite="mid:621481.87547.qm@web34204.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top"><span class="ul-threaded"
style="margin: 0.5em 0pt 0pt -20px;"><span class="text-cell"><br>
<span></span><span></span></span></span> <br>
<br>
Sajjad Ali Mushtaq<br>
email: <a class="moz-txt-link-abbreviated" href="mailto:alisajjad_mushtaq@yahoo.com">alisajjad_mushtaq@yahoo.com</a><br>
Mobile: 0033667961001</td>
</tr>
</tbody>
</table>
<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<quote>Iulia Bublea
<br>
Web: <a class="moz-txt-link-abbreviated" href="http://www.voice-system.ro">www.voice-system.ro</a>
<br>
Email: <a class="moz-txt-link-abbreviated" href="mailto:iulia@opensips.org">iulia@opensips.org</a>
<br>
</quote>
</div>
</body>
</html>