[OpenSIPS-Users] Osipsconsole fail to add gateways

Dave Singer dave.singer at wideideas.com
Mon Feb 21 19:33:56 CET 2011 

Toyima,

Try:
yum whatprovides '*/md5' '*/md5sum' '*/db_dump'
the db_dump should be apparent from that.
I'm using Centos and it shows several packages that provide a md5
command but none put it in the path. You could try installing one and
linking it into the path to see if that helps.
 eg.: ln -s /var/lib/imap/md5 /usr/local/bin/
However I'm guessing two things.
  1. md5 is not critical as it kept going and stopped after another error.
  2. it is not actually wanting md5 but md5sum (provided by package
coreutils), the commonly installed program, and the reference needs to
be fixed in Osipsconsole. It looks like md5 is a library that some
applications include like mail apps and script languages. It also
might be that on different platforms, what is named md5sum on ours is
named md5 on others like maybe bsd or sun unix for example.

I don't know what you are trying to use the console for but for the
limited things I need to do with command line stuff I just use the
opensipsctl like .../opensipsctl fifo ps.
For db stuff I use opensips control pannel web project or just direct
sql commands.

Dave

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

More information about the Users mailing list