[OpenSIPS-Users] Osipsconsole fail to add gateways

[Dave Singer]

Toyima,
This is the right list. You just have to take into account that no one
is getting paid to answer your questions in the list. And sometimes
that means waiting a couple days.
Best tactic I've seen to keep putting it in front of people is to
respond to your own thread with a little update of what you've tried
and the results.


Looks like it is looking for some tools: md5 and db ( I think berkley
db ) tools.
Do you have it configured to connect to your DB <opensips base path>
etc/opensips/osipsconsolerc?
I'd say configure it if not already, try again and see what it still wants.
Then install packages that seem like what it is complaining about not
finding. centos example search: yum whatprovides "*/db_dump"

Dave

On Tue, Feb 15, 2011 at 5:47 AM, Toyima Dias <toyimads at gmail.com> wrote:
> 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!
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>