<font face="verdana,sans-serif">Hi Dave, <br></font><br>
<div class="gmail_quote">2011/2/21 Dave Singer <span dir="ltr"><<a href="mailto:dave.singer@wideideas.com">dave.singer@wideideas.com</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Toyima,<br><br>Try:<br>yum whatprovides '*/md5' '*/md5sum' '*/db_dump'<br>the db_dump should be apparent from that. </blockquote>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">I'm using Centos and it shows several packages that provide a md5<br>command but none put it in the path. You could try installing one and<br>
linking it into the path to see if that helps.<br> eg.: ln -s /var/lib/imap/md5 /usr/local/bin/<br></blockquote>
<div> </div>
<div>None of the options provided help me out :S</div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">However I'm guessing two things.<br> 1. md5 is not critical as it kept going and stopped after another error.<br>
2. it is not actually wanting md5 but md5sum (provided by package<br>coreutils), the commonly installed program, and the reference needs to<br>be fixed in Osipsconsole. It looks like md5 is a library that some<br>applications include like mail apps and script languages. It also<br>
might be that on different platforms, what is named md5sum on ours is<br>named md5 on others like maybe bsd or sun unix for example.<br><br>I don't know what you are trying to use the console for but for the<br>limited things I need to do with command line stuff I just use the<br>
opensipsctl like .../opensipsctl fifo ps.<br>For db stuff I use opensips control pannel web project or just direct<br>sql commands.<br></blockquote>
<div>Yes, finally i will use opensipsctl and cp and no osipsconsole.</div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><font color="#888888">Dave<br></font>
<div>
<div></div>
<div class="h5"><br>On Mon, Feb 21, 2011 at 1:17 AM, Toyima Dias <<a href="mailto:toyimads@gmail.com">toyimads@gmail.com</a>> wrote:<br>><br>> Hi Dave,<br>><br>> This is what i did:<br>><br>> root@OpenSIPS home# yum search md5<br>
> Loaded plugins: rhnplugin, security<br>> ======================================================================================== Matched: md5 =========================================================================================<br>
> cyrus-sasl-md5.i386 : CRAM-MD5 and DIGEST-MD5 support for Cyrus SASL.<br>> perl-Digest-HMAC.noarch : Digest-HMAC Perl module<br>> Then:<br>><br>> root@OpenSIPS home# yum install perl-Digest-HMAC.noarch<br>
> And still not working...i'm working on Red Hat; have found the same problem on google (<a href="http://lists.opensips.org/pipermail/users/2010-November/015448.html" target="_blank">http://lists.opensips.org/pipermail/users/2010-November/015448.html</a>) to another person and seems that he never solve the situation. Any help will be appreciated.<br>
><br>> 2011/2/18 Dave Singer <<a href="mailto:dave.singer@wideideas.com">dave.singer@wideideas.com</a>><br>>><br>>> Toyima,<br>>> It is looking for those executable files. It looks like it first tries db_dump then because that fails tries db4.4_dump.<br>
>> So you need to install the packages that supply md5 and either db_dump or db4.4_dump.<br>>> Dave<br>>><br>>> On Fri, Feb 18, 2011 at 3:20 AM, Toyima Dias <<a href="mailto:toyimads@gmail.com">toyimads@gmail.com</a>> wrote:<br>
>>><br>>>> Hi Dave,<br>>>><br>>>> 2011/2/17 Dave Singer <<a href="mailto:dave.singer@wideideas.com">dave.singer@wideideas.com</a>><br>>>>><br>>>>> Toyima,<br>
>>>><br>>>>> Have you configured it to connect to your database?<br>>>><br>>>><br>>>> 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<br>
>>><br>>>>><br>>>>> Have you installed packages that provide the commands it was<br>>>>> complaining about missing? From what I have seen, db is almost always<br>>>>> installed and it may just require it to be there even if it is not<br>
>>>> used.<br>>>><br>>>><br>>>> The messages it is complaining are the following:<br>>>><br>>>> 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)<br>
>>> 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)<br>>>> 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)<br>
>>><br>>>> Do i have to install md5, db_dump and db4.4_dump?<br>>>><br>>>>><br>>>>> Dave<br>>>>><br>>>>> On Thu, Feb 17, 2011 at 1:50 AM, Toyima Dias <<a href="mailto:toyimads@gmail.com">toyimads@gmail.com</a>> wrote:<br>
>>>> ><br>>>>> > Hello Dave,<br>>>>> ><br>>>>> > 2011/2/17 Dave Singer <<a href="mailto:dave.singer@wideideas.com">dave.singer@wideideas.com</a>><br>>>>> >><br>
>>>> >> Toyima,<br>>>>> >><br>>>>> >> On Wed, Feb 16, 2011 at 5:55 AM, Toyima Dias <<a href="mailto:toyimads@gmail.com">toyimads@gmail.com</a>> wrote:<br>>>>> >> ><br>
>>>> >> ><br>>>>> >> > 2011/2/16 Dave Singer <<a href="mailto:dave.singer@wideideas.com">dave.singer@wideideas.com</a>><br>>>>> >> >><br>>>>> >> >> Toyima,<br>
>>>> >> >> This is the right list. You just have to take into account that no one<br>>>>> >> >> is getting paid to answer your questions in the list. And sometimes<br>>>>> >> >> that means waiting a couple days.<br>
>>>> >> >> Best tactic I've seen to keep putting it in front of people is to<br>>>>> >> >> respond to your own thread with a little update of what you've tried<br>>>>> >> >> and the results.<br>
>>>> >> >><br>>>>> >> ><br>>>>> >> > Ok.<br>>>>> >> ><br>>>>> >> >><br>>>>> >> >> Looks like it is looking for some tools: md5 and db ( I think berkley<br>
>>>> >> >> db ) tools.<br>>>>> >> >> Do you have it configured to connect to your DB <opensips base path><br>>>>> >> >> etc/opensips/osipsconsolerc?<br>
>>>> >> ><br>>>>> >> > Do you mean the configuration of /etc/opensips/opensipsctlrc? if so, i've<br>>>>> >> > commented the following line:<br>>>>> >> Yes<br>
>>>> >><br>>>>> >> ><br>>>>> >> > # database path used by dbtext or db_berkeley<br>>>>> >> > #DB_PATH="/usr/local/etc/opensips/dbtext"<br>
>>>> >> ><br>>>>> >> > Should i change something?<br>>>>> >> Did your results change at all after commenting it?<br>>>>> >><br>>>>> ><br>
>>>> > It was commented by default...i've uncommented and the same result my friend<br>>>>> ><br>>>>> >><br>>>>> >> The db connection info in that file should be the same as in your<br>
>>>> >> opensips.cfg script, just different format for specifying it.<br>>>>> >><br>>>>> >> Dave.<br>>>>> >> ><br>>>>> >> >><br>
>>>> >> >> I'd say configure it if not already, try again and see what it still<br>>>>> >> >> wants.<br>>>>> >> >> Then install packages that seem like what it is complaining about not<br>
>>>> >> >> finding. centos example search: yum whatprovides "*/db_dump"<br>>>>> >> >><br>>>>> >> >> Dave<br>>>>> >> >><br>
>>>> >> >> On Tue, Feb 15, 2011 at 5:47 AM, Toyima Dias <<a href="mailto:toyimads@gmail.com">toyimads@gmail.com</a>> wrote:<br>>>>> >> >> > Is there any help or mailing list with the use of osipsconsole? may<br>
>>>> >> >> > be i'm<br>>>>> >> >> > not asking to the right mailing list :S<br>>>>> >> >> ><br>>>>> >> >> > 2011/2/15 Toyima Dias <<a href="mailto:toyimads@gmail.com">toyimads@gmail.com</a>><br>
>>>> >> >> >><br>>>>> >> >> >> Hello,<br>>>>> >> >> >> I'm having problems with my opensipsconsole, first, every time i run<br>
>>>> >> >> >> osipsconsole on the my shell i receive some weird messages, take a<br>>>>> >> >> >> look:<br>>>>> >> >> >><br>>>>> >> >> >> OpenSIPS:~#osipsconsole<br>
>>>> >> >> >> which: no md5 in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db_dump in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db4.4_dump in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db4.5_dump in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db4.6_dump in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db_load in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db4.4_load in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db4.5_load in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> which: no db4.6_load in<br>>>>> >> >> >><br>>>>> >> >> >> (/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)<br>
>>>> >> >> >> Control engine FIFO loaded<br>>>>> >> >> >> OpenSIPS$:<br>>>>> >> >> >> As you can see, osipsconsole is "opened", but those messages are kind<br>
>>>> >> >> >> of<br>>>>> >> >> >> wear, it shows the $PATH of root, why is this happening?<br>>>>> >> >> >><br>>>>> >> >> >> And also, the biggest problem is that i can't add gateways, check the<br>
>>>> >> >> >> following:<br>>>>> >> >> >><br>>>>> >> >> >> OpenSIPS$:address add 0 192.168.1.192 255.255.255.255 5060 UDP<br>>>>> >> >> >> Used database is mysql<br>
>>>> >> >> >> Warn fallback to local workdir ./mysql<br>>>>> >> >> >> Retrieving data from table failedYou have an error in your SQL syntax;<br>>>>> >> >> >> check the manual that corresponds to your MySQL server version for the<br>
>>>> >> >> >> right<br>>>>> >> >> >> syntax to use near 'WHERE ip='192.168.1.192'' at line 1<br>>>>> >> >> >> Introducing the address rule 0 192.168.1.192 255.255.255.255 5060 UDP<br>
>>>> >> >> >> to<br>>>>> >> >> >> the database failed<br>>>>> >> >> >> You have an error in your SQL syntax; check the manual that corresponds<br>
>>>> >> >> >> to<br>>>>> >> >> >> your MySQL server version for the right syntax to use near '( grp, ip,<br>>>>> >> >> >> mask,<br>
>>>> >> >> >> port, proto , context_info ) VALUES ( 0, '192.168.1.192', '255.' at<br>>>>> >> >> >> line 1<br>>>>> >> >> >> Execute 'address reload' to synchronize cache and database<br>
>>>> >> >> >><br>>>>> >> >> >> What should i check to sovle this situation?<br>>>>> >> >> >><br>>>>> >> >> >> Best Regards!<br>
>>>> >> >> ><br>>>>> >> >> > _______________________________________________<br>>>>> >> >> > Users mailing list<br>>>>> >> >> > <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>>>> >> >> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>>>> >> >> ><br>
>>>> >> >> ><br>>>>> >> >><br>>>>> >> >> _______________________________________________<br>>>>> >> >> Users mailing list<br>
>>>> >> >> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>>>>> >> >> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>>>> >> ><br>>>>> >> ><br>>>>> >> > _______________________________________________<br>>>>> >> > Users mailing list<br>>>>> >> > <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>>>> >> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>>>> >> ><br>>>>> >> ><br>
>>>> >><br>>>>> >> _______________________________________________<br>>>>> >> Users mailing list<br>>>>> >> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>>>> >> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>>>> ><br>>>>> ><br>
>>>> > _______________________________________________<br>>>>> > Users mailing list<br>>>>> > <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>>>>> > <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>>>> ><br>>>>><br>>>>> _______________________________________________<br>>>>> Users mailing list<br>>>>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>>>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>>>><br>>>><br>>>> _______________________________________________<br>
>>> Users mailing list<br>>>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>>>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>>><br>>><br>>><br>>> _______________________________________________<br>>> Users mailing list<br>>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>><br>><br>><br>> _______________________________________________<br>> Users mailing list<br>> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br>