<font face="verdana,sans-serif"><br></font><br><div class="gmail_quote">2011/2/16 Dave Singer <span dir="ltr"><<a href="mailto:dave.singer@wideideas.com">dave.singer@wideideas.com</a>></span><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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></blockquote><div><br>Ok.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<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></blockquote><div><br>Do you mean the configuration of /etc/opensips/opensipsctlrc? if so, i've commented the following line:<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><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I'd say configure it if not already, try again and see what it still 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>
<div><div></div><div class="h5"><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 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 look:<br>
>><br>
>> OpenSIPS:~#osipsconsole<br>
>> which: no md5 in<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>
>> (/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>
>> (/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>
>> (/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>
>> (/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>
>> (/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>
>> (/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>
>> (/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>
>> (/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 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 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 to<br>
>> the database failed<br>
>> You have an error in your SQL syntax; check the manual that corresponds to<br>
>> your MySQL server version for the right syntax to use near '( grp, ip, mask,<br>
>> port, proto , context_info ) VALUES ( 0, '192.168.1.192', '255.' at 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>
</div></div>> _______________________________________________<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>
</blockquote></div><br>