[OpenSIPS-Users] Osipsconsole fail to add gateways

[Toyima Dias]

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:

# database path used by dbtext or db_berkeley
#DB_PATH="/usr/local/etc/opensips/dbtext"

Should i change something?


> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110216/daa05a7a/attachment.htm>