<!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">
<tt>Hi Christian,<br>
<br>
It seems that the osipsconsole was not updated to reflect the
latest changes in the DB schema for the permission module.<br>
<br>
Thanks for reporting this - could you open a ticket on the SF bug
tracker ?<br>
<br>
Regards,</tt><br>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 11/27/2012 10:40 AM, Christian Cambier wrote:
<blockquote
cite="mid:CAAm-qAYv1wjs+zN2+6Fwg_=WSpe5dUSh+z8u8b-hMMyxN0vPdQ@mail.gmail.com"
type="cite">
<div>Hi.</div>
<div><br>
</div>
<div>I try to execute following command on the command-line from
the "OpenSIPS 1.6" manual" </div>
<div> osipsconsole address add 0 192.168.1.192 255.255.255.0
5060 UDP</div>
<div>
<br>
</div>
<div>but always get following error</div>
<div> "Retrieving data from table failed. You have an error in
your SQL syntax;</div>
<div>check the manual that corresponds to your MySQL server
version for the</div>
<div>right syntax to use near 'WHERE ip='192.168.1.192'' at line
1"</div>
<div><br>
<div>I have installed osipsconsole and the required
dependencies as well</div>
<div> apt-get install libdbi-perl libdbd-mysql-perl
libfrontier-rpc-perl libterm-readline-gnu-perl</div>
<br>
How to solve this?<br>
If it is really a version related error, how to make sure mySql
version is correct?<br>
<br>
help greatly appreciated<br>
<br>
Chris<br>
<br>
<br>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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>
</body>
</html>