Toyima, It is looking for those executable files. It looks like it first tries db_dump then because that fails tries db4.4_dump. So you need to install the packages that supply md5 and either db_dump or db4.4_dump.
Dave On Fri, Feb 18, 2011 at 3:20 AM, Toyima Dias <[email protected]> wrote: > Hi Dave, > > 2011/2/17 Dave Singer <[email protected]> > >> Toyima, >> >> Have you configured it to connect to your database? >> > > 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 > > >> Have you installed packages that provide the commands it was >> complaining about missing? From what I have seen, db is almost always >> installed and it may just require it to be there even if it is not >> used. >> > > The messages it is complaining are the following: > > 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) > > Do i have to install md5, db_dump and db4.4_dump? > > >> >> Dave >> >> On Thu, Feb 17, 2011 at 1:50 AM, Toyima Dias <[email protected]> wrote: >> > >> > Hello Dave, >> > >> > 2011/2/17 Dave Singer <[email protected]> >> >> >> >> Toyima, >> >> >> >> On Wed, Feb 16, 2011 at 5:55 AM, Toyima Dias <[email protected]> >> wrote: >> >> > >> >> > >> >> > 2011/2/16 Dave Singer <[email protected]> >> >> >> >> >> >> 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 <[email protected]> >> 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 <[email protected]> >> >> >> >> >> >> >> >> 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 >> >> >> > [email protected] >> >> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> > >> >> >> > >> >> >> >> >> >> _______________________________________________ >> >> >> Users mailing list >> >> >> [email protected] >> >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > >> >> > >> >> > _______________________________________________ >> >> > Users mailing list >> >> > [email protected] >> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > >> >> > >> >> >> >> _______________________________________________ >> >> Users mailing list >> >> [email protected] >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > >> > >> > _______________________________________________ >> > Users mailing list >> > [email protected] >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
