[OpenSIPS-Users] Osipsconsole fail to add gateways

[Toyima Dias]

Hi Dave,

This is what i did:

root at OpenSIPS home# yum search md5
Loaded plugins: rhnplugin, security
========================================================================================
Matched: md5
=========================================================================================
cyrus-sasl-md5.i386 : CRAM-MD5 and DIGEST-MD5 support for Cyrus SASL.
perl-Digest-HMAC.noarch : Digest-HMAC Perl module
Then:

root at OpenSIPS home# yum install perl-Digest-HMAC.noarch
And still not working...i'm working on Red Hat; have found the same problem
on google (
http://lists.opensips.org/pipermail/users/2010-November/015448.html) to
another person and seems that he never solve the situation. Any help will be
appreciated.


2011/2/18 Dave Singer <dave.singer at wideideas.com>

> Toyima,
>
> It is looking for those executable files. It looks like it first tries
> db_dump then because that fails tries db4.4_dump.
> So you need to install the packages that supply md5 and either db_dump
> or db4.4_dump.
>
> Dave
>
>
> On Fri, Feb 18, 2011 at 3:20 AM, Toyima Dias <toyimads at gmail.com> wrote:
>
>> Hi Dave,
>>
>>  2011/2/17 Dave Singer <dave.singer at wideideas.com>
>>
>>> Toyima,
>>>
>>> Have you configured it to connect to your database?
>>>
>>
>> the file opensipsctlrc is already configured to connect to my database
>> where i'm storing domains, locations, subscribers, etc etc...the DB_PATH
>> parameter commented and i don't now how to configure this parameter :S
>>
>>
>>> 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.
>>>
>>
>> The messages it is complaining are the following:
>>
>> 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)
>>
>> Do i have to install md5, db_dump and db4.4_dump?
>>
>>
>>>
>>> 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
>>> >
>>>
>>> _______________________________________________
>>> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110221/53c9eca2/attachment.htm>