<div><font face="verdana,sans-serif">Hi Dave, </font></div>
<div><font face="verdana,sans-serif"></font> </div>
<div><font face="verdana,sans-serif">This is what i did:</font></div>
<div><font face="Verdana"></font> </div>
<div><font face="verdana,sans-serif"><a href="mailto:root@OpenSIPS">root@OpenSIPS</a> 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></font></div>
<div><font face="verdana,sans-serif">Then:</font></div>
<div><font face="verdana,sans-serif"></font> </div>
<div><font face="verdana,sans-serif"><a href="mailto:root@OpenSIPS">root@OpenSIPS</a> home# yum install perl-Digest-HMAC.noarch<br></font></div>
<div><font face="verdana,sans-serif">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">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.</font></div>
<div><br><br></div>
<div class="gmail_quote">2011/2/18 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">
<div>Toyima,</div>
<div><br></div>It is looking for those executable files. It looks like it first tries db_dump then because that fails tries db4.4_dump.
<div>So you need to install the packages that supply md5 and either db_dump or db4.4_dump.</div>
<div><br></div>
<div><font color="#888888">Dave</font>
<div>
<div></div>
<div class="h5"><br><br>
<div class="gmail_quote">On Fri, Feb 18, 2011 at 3:20 AM, Toyima Dias <span dir="ltr"><<a href="mailto:toyimads@gmail.com" target="_blank">toyimads@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><font face="verdana,sans-serif">Hi Dave,<br></font><br>
<div class="gmail_quote">
<div>2011/2/17 Dave Singer <span dir="ltr"><<a href="mailto:dave.singer@wideideas.com" target="_blank">dave.singer@wideideas.com</a>></span><br></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Toyima,<br><br>
<div>Have you configured it to connect to your database?<br></div></blockquote>
<div> </div>
<div>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</div>
<div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">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></blockquote>
<div> </div></div>
<div>The messages it is complaining are the following:</div>
<div>
<div> </div>
<div>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)</div>
<div> </div></div>
<div>Do i have to install md5, db_dump and db4.4_dump?<br></div>
<div>
<div></div>
<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"><br>Dave<br></font>
<div>
<div></div>
<div><br>On Thu, Feb 17, 2011 at 1:50 AM, Toyima Dias <<a href="mailto:toyimads@gmail.com" target="_blank">toyimads@gmail.com</a>> wrote:<br>><br>> Hello Dave,<br>><br>> 2011/2/17 Dave Singer <<a href="mailto:dave.singer@wideideas.com" target="_blank">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" target="_blank">toyimads@gmail.com</a>> wrote:<br>>> ><br>>> ><br>
>> > 2011/2/16 Dave Singer <<a href="mailto:dave.singer@wideideas.com" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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></div></div><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">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></blockquote></div><br></div></div></div><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></blockquote></div><br>