<font face="verdana,sans-serif">Hello Dave, <br></font><br>
<div class="gmail_quote">2011/2/17 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>
<div class="im"><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></div>Yes<br>
<div class="im"><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></div>Did your results change at all after commenting it?<br>
<br></blockquote>
<div> </div>
<div>It was commented by default...i've uncommented and the same result my friend</div>
<div> </div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">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>
<font color="#888888"><br>Dave.<br></font>
<div>
<div></div>
<div class="h5">><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>
</div></div></blockquote></div><br>