[OpenSIPS-Users] osipsconsole address failed

Bogdan-Andrei Iancu bogdan at opensips.org
Mon Dec 10 15:38:28 CET 2012


Hi Mimi,

I made some fixes in osipsconsole on SVN (trunk and 1.8 branch) - please 
update and let me know if now works for you.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 12/08/2012 11:00 PM, Mimi Cafe wrote:
> I attempted using osipsconsole to add a gateway address, but it failed 
> because there is no data in the dbaliases table. How is this linked to 
> the dbaliases tables? What is the prerequisite to adding a gateway 
> address in addresses table?
>
> osipsconsole address add 0 192.168.18.89 255.255.255.255 5060 UDP
>
> Control engine FIFO loaded
> Used database is mysql
> Retrieving data from table failedYou 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.18.89'' at line 1
> Introducing the address rule 0 192.168.18.89 255.255.255.255 5060 UDP 
> to the database 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 '( grp, ip, mask, port, proto , context_info ) VALUES ( 0, 
> '192.168.18.89', '255.' at line 1
>
>
> Mimi
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



More information about the Users mailing list