[OpenSIPS-Users] Osipsconsole fail to add gateways

[Dave Singer]

Toyima,

On Wed, Feb 16, 2011 at 5:55 AM, Toyima Dias <toyimads at gmail.com> wrote:
>
>
> 2011/2/16 Dave Singer <dave.singer at wideideas.com>
>>
>> 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.
>>
>
> Ok.
>
>>
>> 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?
>
> Do you mean the configuration of /etc/opensips/opensipsctlrc? if so, i've
> commented the following line:
Yes

>
> # database path used by dbtext or db_berkeley
> #DB_PATH="/usr/local/etc/opensips/dbtext"
>
> Should i change something?
Did your results change at all after commenting it?

The db connection info in that file should be the same as in your
opensips.cfg script, just different format for specifying it.

Dave.
>
>>
>> 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
>> >
>> >
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>