Re: [OpenSIPS-Users] Osipsconsole fail to add gateways
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 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
Re: [OpenSIPS-Users] OpenSIPS monthly comunity meeting
Hi people, I think it's good to do a monthly meeting to make the community bigger and stronger. Kind regards, Erik Dekkers (wvds-nl) -Oorspronkelijk bericht- Van: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] Namens Bogdan-Andrei Iancu Verzonden: dinsdag 15 februari 2011 16:06 Aan: users@lists.opensips.org; de...@lists.opensips.org; n...@lists.opensips.org; busin...@lists.opensips.org Onderwerp: [OpenSIPS-Users] OpenSIPS monthly comunity meeting Hi all, As part of the effort of making OpenSIPS project as open and as interactive (to the users) as possible, we plan to start a program of public online meetings with the community - the basic idea is to try to involve as much people as possible in the process of running and guiding the OpenSIPS project -via a open and public discussion :) Purpose --- Identify issues that needs to be addressed - issues may be technical (like tech work, features, improvements, contributions, etc) or management (lists, SVN/GIT, etc). NOTE: the meetings will identify the issues, we DO NOT plan to resolve the issues during these meetings (who, how and when to solve will be decided in the meeting) When - The meetings will be monthly, in the second Wednesday of each month. Where - IRC #opensips channel - anyone is welcomed to formulate ideas or to contribute with solutions for the discussed items. What with one week before the meeting, we will publish the list of topics (issues that need to be addressed) As a first meeting we want to start with 22th of February, 17:00 CET (even if does not match the when rule) - to be just a kick-off meeting with the following topic: 1) Meetings - how and where : is chat ok (audio conf) ? is IRC ok ? what about SIP chat ? What is the best time for everybody ? Best regards, Bogdan -- Bogdan-Andrei Iancu OpenSIPS eBootcamp - 28th February 2011 OpenSIPS solutions and know-how ___ 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
[OpenSIPS-Users] Interproxy Authentication
Hi All, I want this scenario: UA - Opensips1 - Opensip2 - PSTN Opensips2 has a set of subscribers and verifies authentication against a mysql db, keeps cdrs etc. Opensips1 has a different set of subscribers with db authentication and cdrs. The UA makes a call and is routed from Opensips1 to Opensips2 and then onto the PSTN gateway. My question is how do I impersonate the call made by UA as coming from a valid subscriber known to Opensips2? Currently I use asterisk to perform this role, but would ideally like to remove it from the chain: UA - Opensips1 - Asterisk - Opensips2 - PSTN Regards http://www.greydotelecom.net/bcard/jnysschen.htm Juri Nysschen ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Osipsconsole fail to add gateways
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: # 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 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
[OpenSIPS-Users] Presence for routing logic
Dear all, I'm thinking about a design of an unified communication system based on presence status. I would like to know if the presence status of a subscriber could be used to define the routing logic. An example is routing the call to voicemail when Alice's status is meeting or to a cell phone when she is on holiday. Thanks, Carlo ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Presence for routing logic
Hi Carlo, Here are my ideas about this. One solution would be to insert into usr_preferences table a record with the URI where the call must be forwarded for the user (you can put the username in RURI) when the presence status is meeting, holiday, etc. And delete it when changes into something else. Now the question is where to do this. In the OpenSIPS script is very hard - you have to make regexps to extract the status from the Publish body, select from database the previous stored state and apply the regexp again, very inefficient. The other solutions are an external application or an opensips module. The external application could query the presentity table periodically or maybe be called by a trigger at insert ( not sure this is possible). The module can export a function to be called before handle_publish to analyze the previous and the current state. Then when handling Invites - do avp_db_load for the caller and if a record is found forward it to that URI. Regards, -- Anca Vamanu OpenSIPS Developer On 02/16/2011 06:20 PM, Carlo Dimaggio wrote: Dear all, I'm thinking about a design of an unified communication system based on presence status. I would like to know if the presence status of a subscriber could be used to define the routing logic. An example is routing the call to voicemail when Alice's status is meeting or to a cell phone when she is on holiday. Thanks, Carlo ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Presence for routing logic
Hi Carlo, Such powerful feature would deserve some module of its own. Routing based on end-user provided preferences using presence is something fresh and cool nobody has tried it before. Make something that uses published presence and xcap policy in a meaningful way for the end-user! We will help you if want to implement such feature if something is missing on the server side. Regards, Adrian On Feb 16, 2011, at 5:20 PM, Carlo Dimaggio wrote: Dear all, I'm thinking about a design of an unified communication system based on presence status. I would like to know if the presence status of a subscriber could be used to define the routing logic. An example is routing the call to voicemail when Alice's status is meeting or to a cell phone when she is on holiday. Thanks, Carlo ___ 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
Re: [OpenSIPS-Users] Interproxy Authentication
Juri, If you are looking to get opensips1 itself to respond to a proxy_challange of opensips2 your looking at a headache. Any way you go you'll have to change the way things work to make a special case for opensips1 on opensips2. My suggestion would be to, where you are about to do the proxy_authorize, check if is from opensips1 and if it is skip the proxy_authorize. Example: if ( ! ( $si == IP of opensips1 || proxy_authorize(, subscriber) ) ) { proxy_challenge(, 0); exit; } The source IP, $si, will be checked first and if it is a match, it will short cut and proxy_authorize will not be called. But if both tests fail a proxy_challenge is sent back. If opensips1 is not at a static IP then you would probably want to have opensips1 register, using uac module, with opensips2. On opensips2 you would then do a db lookup to see if the source IP is the same as what opensips registered from. That lookup could be cached so you don't have to do a db call for every call. If this is your case, search recent threads for cache_fetch for some ideas of a similar use. Dave On Wed, Feb 16, 2011 at 1:36 AM, Juri Nysschen j...@greydotelecom.com wrote: Hi All, I want this scenario: UA - Opensips1 - Opensip2 - PSTN Opensips2 has a set of subscribers and verifies authentication against a mysql db, keeps cdrs etc. Opensips1 has a different set of subscribers with db authentication and cdrs. The UA makes a call and is routed from Opensips1 to Opensips2 and then onto the PSTN gateway. My question is how do I impersonate the call made by UA as coming from a valid subscriber known to Opensips2? Currently I use asterisk to perform this role, but would ideally like to remove it from the chain: UA - Opensips1 - Asterisk - Opensips2 - PSTN Regards Juri Nysschen ___ 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
Re: [OpenSIPS-Users] Osipsconsole fail to add gateways
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? 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