[OpenSIPS-Users] 'osipsconsole add 'command fails

[Christian Cambier]

Hi.

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

How to solve this?
If it is really a version related error, how to make sure mySql version is
correct?

help greatly appreciated

Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121127/704d97ca/attachment.htm>