[OpenSIPS-Users] Osipsconsole fail to add gateways

Dave Singer dave.singer at wideideas.com
Wed Feb 16 09:36:28 CET 2011


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.


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?
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
>
>



More information about the Users mailing list