[OpenSIPS-Users] Osipsconsole fail to add gateways

[Toyima Dias]

Hello,
I'm having problems with my opensipsconsole, first, every time i run
osipsconsole on the my shell i receive some weird messages, take a look:

*OpenSIPS:~#osipsconsole
which: no md5 in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db_dump in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db4.4_dump in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db4.5_dump in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db4.6_dump in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db_load in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db4.4_load in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db4.5_load in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
which: no db4.6_load in
(/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin:/sbin/:/usr/bin)
Control engine FIFO loaded
*
*OpenSIPS$:
*
As you can see, osipsconsole is "opened", but those messages are kind of
wear, it shows the $PATH of root, why is this happening?

And also, the biggest problem is that i can't add gateways, check the
following:

*OpenSIPS$:address add 0 192.168.1.192 255.255.255.255 5060 UDP
Used database is mysql
Warn fallback to local workdir ./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.1.192'' at line 1
Introducing the address rule 0 192.168.1.192 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.1.192', '255.' at line 1*
*Execute 'address reload' to synchronize cache and database
*
What should i check to sovle this situation?

Best Regards!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110215/4e5a2ece/attachment.htm>