[OpenSIPS-Devel] [ opensips-Bugs-3591427 ] 'osipsconsole add 'command fails

[SourceForge.net]

Bugs item #3591427, was opened at 2012-11-30 10:41
Message generated for change (Comment added) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3591427&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: tools
>Group: 1.8.x
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Bogdan-Andrei Iancu (bogdan_iancu)
>Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: 'osipsconsole add 'command fails

Initial Comment:
I try to execute following command on the command-line from the "OpenSIPS 1.6" manual" 
   osipsconsole address add 0 192.168.1.192 255.255.255.0 5060 UDP

but always get following error
  "Retrieving data from table failed. You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'WHERE ip='192.168.1.192'' at line 1"

I have installed  osipsconsole and the required dependencies as well
  apt-get install libdbi-perl libdbd-mysql-perl libfrontier-rpc-perl  libterm-readline-gnu-perl

----------------------------------------------------------------------

>Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2012-12-10 06:48

Message:
Fixed in trunk and 1.8 and trunk.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3591427&group_id=232389