Hello Dave, 2011/2/17 Dave Singer <dave.sin...@wideideas.com>
> Toyima, > > On Wed, Feb 16, 2011 at 5:55 AM, Toyima Dias <toyim...@gmail.com> wrote: > > > > > > 2011/2/16 Dave Singer <dave.sin...@wideideas.com> > >> > >> Toyima, > >> This is the right list. You just have to take into account that no one > >> is getting paid to answer your questions in the list. And sometimes > >> that means waiting a couple days. > >> Best tactic I've seen to keep putting it in front of people is to > >> respond to your own thread with a little update of what you've tried > >> and the results. > >> > > > > Ok. > > > >> > >> Looks like it is looking for some tools: md5 and db ( I think berkley > >> db ) tools. > >> Do you have it configured to connect to your DB <opensips base path> > >> etc/opensips/osipsconsolerc? > > > > Do you mean the configuration of /etc/opensips/opensipsctlrc? if so, i've > > commented the following line: > Yes > > > > > # database path used by dbtext or db_berkeley > > #DB_PATH="/usr/local/etc/opensips/dbtext" > > > > Should i change something? > Did your results change at all after commenting it? > > It was commented by default...i've uncommented and the same result my friend > The db connection info in that file should be the same as in your > opensips.cfg script, just different format for specifying it. > > Dave. > > > >> > >> I'd say configure it if not already, try again and see what it still > >> wants. > >> Then install packages that seem like what it is complaining about not > >> finding. centos example search: yum whatprovides "*/db_dump" > >> > >> Dave > >> > >> On Tue, Feb 15, 2011 at 5:47 AM, Toyima Dias <toyim...@gmail.com> > wrote: > >> > Is there any help or mailing list with the use of osipsconsole? may > >> > be i'm > >> > not asking to the right mailing list :S > >> > > >> > 2011/2/15 Toyima Dias <toyim...@gmail.com> > >> >> > >> >> Hello, > >> >> I'm having problems with my opensipsconsole, first, every time i run > >> >> osipsconsole on the my shell i receive some weird messages, take a > >> >> look: > >> >> > >> >> OpenSIPS:~#osipsconsole > >> >> 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) > >> >> 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) > >> >> 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) > >> >> which: no db4.5_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) > >> >> which: no db4.6_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) > >> >> which: no db_load 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) > >> >> which: no db4.4_load 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) > >> >> which: no db4.5_load 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) > >> >> which: no db4.6_load 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) > >> >> Control engine FIFO loaded > >> >> OpenSIPS$: > >> >> As you can see, osipsconsole is "opened", but those messages are kind > >> >> of > >> >> wear, it shows the $PATH of root, why is this happening? > >> >> > >> >> And also, the biggest problem is that i can't add gateways, check the > >> >> following: > >> >> > >> >> OpenSIPS$:address add 0 192.168.1.192 255.255.255.255 5060 UDP > >> >> Used database is mysql > >> >> Warn fallback to local workdir ./mysql > >> >> Retrieving data from table failedYou have an error in your SQL > syntax; > >> >> check the manual that corresponds to your MySQL server version for > the > >> >> right > >> >> syntax to use near 'WHERE ip='192.168.1.192'' at line 1 > >> >> Introducing the address rule 0 192.168.1.192 255.255.255.255 5060 UDP > >> >> to > >> >> the database failed > >> >> You have an error in your SQL syntax; check the manual that > corresponds > >> >> to > >> >> your MySQL server version for the right syntax to use near '( grp, > ip, > >> >> mask, > >> >> port, proto , context_info ) VALUES ( 0, '192.168.1.192', '255.' at > >> >> line 1 > >> >> Execute 'address reload' to synchronize cache and database > >> >> > >> >> What should i check to sovle this situation? > >> >> > >> >> Best Regards! > >> > > >> > _______________________________________________ > >> > Users mailing list > >> > Users@lists.opensips.org > >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >> > > >> > > >> > >> _______________________________________________ > >> Users mailing list > >> Users@lists.opensips.org > >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > _______________________________________________ > > Users mailing list > > Users@lists.opensips.org > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
