<font face="verdana,sans-serif">Hi 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><br>Have you configured it to connect to your database?<br></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>
<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>The messages it is complaining are the following:</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>Do i have to install md5, db_dump and db4.4_dump?<br></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 class="h5"><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>
</div></div></blockquote></div><br>