Hi Dave, 2011/2/21 Dave Singer <dave.sin...@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 <toyim...@gmail.com> wrote: > > > > Hi Dave, > > > > This is what i did: > > > > root@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@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.sin...@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 <toyim...@gmail.com> > wrote: > >>> > >>> Hi Dave, > >>> > >>> 2011/2/17 Dave Singer <dave.sin...@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 <toyim...@gmail.com> > wrote: > >>>> > > >>>> > Hello Dave, > >>>> > > >>>> > 2011/2/17 Dave Singer <dave.sin...@wideideas.com> > >>>> >> > >>>> >> Toyima, > >>>> >> > >>>> >> On Wed, Feb 16, 2011 at 5:55 AM, Toyima Dias <toyim...@gmail.com> > wrote: > >>>> >> > > >>>> >> > > >>>> >> > 2011/2/16 Dave Singer <dave.sin...@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 < > toyim...@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 <toyim...@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@lists.opensips.org > >>>> >> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>>> >> >> > > >>>> >> >> > > >>>> >> >> > >>>> >> >> _______________________________________________ > >>>> >> >> Users mailing list > >>>> >> >> Users@lists.opensips.org > >>>> >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>>> >> > > >>>> >> > > >>>> >> > _______________________________________________ > >>>> >> > Users mailing list > >>>> >> > Users@lists.opensips.org > >>>> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>>> >> > > >>>> >> > > >>>> >> > >>>> >> _______________________________________________ > >>>> >> Users mailing list > >>>> >> Users@lists.opensips.org > >>>> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>>> > > >>>> > > >>>> > _______________________________________________ > >>>> > Users mailing list > >>>> > Users@lists.opensips.org > >>>> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>>> > > >>>> > >>>> _______________________________________________ > >>>> Users mailing list > >>>> Users@lists.opensips.org > >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>> > >>> > >>> _______________________________________________ > >>> Users mailing list > >>> Users@lists.opensips.org > >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >>> > >> > >> > >> _______________________________________________ > >> Users mailing list > >> Users@lists.opensips.org > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >> > > > > > > _______________________________________________ > > Users mailing list > > Users@lists.opensips.org > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users