[OpenSIPS-Users] Osipsconsole fail to add gateways

[Dave Singer]

Toyima,

Have you configured it to connect to your database?
Have you installed packages that provide the commands it was
complaining about missing? From what I have seen, db is almost always
installed and it may just require it to be there even if it is not
used.

Dave

On Thu, Feb 17, 2011 at 1:50 AM, Toyima Dias <toyimads at gmail.com> wrote:
>
> Hello Dave,
>
> 2011/2/17 Dave Singer <dave.singer at wideideas.com>
>>
>> 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?
>>
>
> It was commented by default...i've uncommented and the same result my friend
>
>>
>> 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
>> >
>> >
>>
>> _______________________________________________
>> 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
>