[OpenSIPS-Users] osipsconsole address failed

Mimi Cafe mimicafe at gmail.com
Sat Dec 8 22:00:31 CET 2012


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



More information about the Users mailing list