[OpenSIPS-Users] Osipsconsole fail to add gateways

[Toyima Dias]

Is there any help or mailing list with the use of osipsconsole? may be i'm
not asking to the right mailing list :S

2011/2/15 Toyima Dias <toyimads at gmail.com>

> 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/b01cc224/attachment-0001.htm>