[OpenSIPS-Users] Osipsconsole fail to add gateways

Toyima Dias toyimads at gmail.com
Tue Feb 22 10:26:39 CET 2011 

Hi Dave,

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

> 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/
>

None of the options provided help me out :S


> 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.
>
Yes, finally i will use opensipsctl  and cp and no osipsconsole.


> 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
> >
>
> _______________________________________________
> 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/20110222/b3874405/attachment-0001.htm>

More information about the Users mailing list