[OpenSIPS-Users] Osipsconsole fail to add gateways

[Toyima Dias]

Hi Dave,

2011/2/17 Dave Singer <dave.singer at wideideas.com>

> 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 <toyimads at gmail.com> wrote:
> >
> > Hello Dave,
> >
> > 2011/2/17 Dave Singer <dave.singer at wideideas.com>
> >>
> >> Toyima,
> >>
> >> On Wed, Feb 16, 2011 at 5:55 AM, Toyima Dias <toyimads at gmail.com>
> wrote:
> >> >
> >> >
> >> > 2011/2/16 Dave Singer <dave.singer at 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 <toyimads at 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 <toyimads at 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 at lists.opensips.org
> >> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >> >> >
> >> >> >
> >> >>
> >> >> _______________________________________________
> >> >> Users mailing list
> >> >> Users at lists.opensips.org
> >> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >> >
> >> >
> >> > _______________________________________________
> >> > Users mailing list
> >> > Users at lists.opensips.org
> >> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >> >
> >> >
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110218/a423dbe5/attachment.htm>