[OpenSIPS-Users] Dispatcher/dbtext load order incorrect
My apologies if this one has been covered before, my google fu is failing me, but we're running a pretty large load out of OpenSIPS v1.8.5 (LTS) and have struck an oddity that I don't appear to have noticed before. We're using the dispatcher module with a dbtext database source and the order that the entries are being loaded are not in row order. I do see the dbtext documentation is clear that ORDER BY is not possible, so perhaps this is a unfixable situation with this DB back-end, but I kind of assumed that the order would always match the order in the dbtext data file itself (based on the id auto column). There are only two entries in the dispatcher table: id(int,auto) setid(int) destination(string) socket(string,null) flags(int) weight(int) attrs(string) description(string) 0:1:sip\:192.168.55.9\:5060::0:1:'':'handler01' 1:1:sip\:192.168.55.8\:5060::0:1:'':'handler02' When I run a 'ds_list' (calls through the system prove it's using the order below, also): SET_NO:: 1 SET:: 1 URI:: sip:192.168.55.8 URI:: sip:192.168.55.9 Clearly the dbtext module is sorting, or possibly unsorting in a hash, on the destination. If I was just doing a round-robin, which normally I am, it's completely moot - but today's problem is I'm trying to implement a failover (ds_select_domain(1, 8)) scenario which means I need the data to remain in order. Suggestions? Hopefully other than move to a real DB as we're trying to keep this as lean as possible. My thanks for your time! - Jock ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips-cp dispatcher issue
I found issue, you have to add destination with port otherwise it won't give you status sip:10.10.10.10:5060 One more issue, in opensips-cp it is showing status Active and Inactive but it is not showing Probing status On Tue, Apr 21, 2015 at 6:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: status can be either Enabled, Disabled, Probing so what you see in the web interface is I guess that it is not disabled. Correct me if I'm wrong. On Tue, Apr 21, 2015 at 6:44 PM, Satish Patel satish@gmail.com wrote: In command line it is showing root@dispatcher1:/var/www# opensipsctl dispatcher dump SET:: 1 URI:: sip:173.XXX.XXX.181 state=Probing But on Opensips-cp web interface it is showing DB state: Active Look like it is not syncing with opensips properly. what would be the issue? ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Aron Podrigal - //Be happy :-) ___ 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] issues creating present table on trunk
Hi Tito, A quick read on the topic shows that the sql_mode (SHOW VARIABLES LIKE 'sql_mode';) has been changed from the default of , to include this option: STRICT_TRANS_TABLES. If STRICT_TRANS_TABLES is enabled, BLOB/TEXT cols can't have default values :( So either change the sql_mode or edit /usr/local/share/opensips/mysql/presence-create.sql Best regards, Liviu Chircu OpenSIPS Developer http://www.opensips-solutions.com On 22.04.2015 17:14, Tito Cumpen wrote: Hello group, I am having issues creating the presence tables via opensipsdbctl create using the trunk version of opensips. Here is the error : opensipsdbctl create MySQL password for root: INFO: test server charset Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. INFO: creating database opensips ... Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. Warning: Using a password on the command line interface can be insecure. INFO: Core OpenSIPS tables succesfully created. INFO: creating presence tables into opensips ... Warning: Using a password on the command line interface can be insecure. ERROR 1101 (42000) at line 2: BLOB/TEXT column 'extra_hdrs' can't have a default value ERROR: Failed to create presence tables! I am using mysql Ver 14.14 Distrib 5.6.24, for Linux (x86_64) using EditLine wrapper ___ 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] OpenSIPS 2.1 Release Candidate 2
Hello, All! We've just released the second Release Candidate for OpenSIPS 2.1[1]. This release contains all the fixes you guys have found during the last month, since the RC1. Thank you all for your efforts in deploying and testing the new version of OpenSIPS 2.1. There are two more weeks until the Final OpenSIPS 2.1 will be released, so please don't hesitate to test and report any issues you find. Don't forget, the ugliest bugs reported will be awarded[2]! [1] http://www.opensips.org/About/Version-2-1-x [2] http://www.opensips.org/Community/BugHuntContest Happy hacking! -- Răzvan Crainea OpenSIPS Solutions www.opensips-solutions.com ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
Hey Liviu, I have fixed script here is the pull request https://github.com/OpenSIPS/opensips/pull/476 On Wed, Apr 22, 2015 at 8:27 AM, Liviu Chircu li...@opensips.org wrote: Hi Aron/Satish, If you can put together a working Pull Request, I will gladly review it. If bash is not your strong suite, then could you please open a Bug Report [1]? Sooner or later, it will get solved :) [1] https://github.com/OpenSIPS/opensips/issues?q=is%3Aopen+is%3Aissue+label%3Abug Best regards, Liviu Chircu OpenSIPS Developerhttp://www.opensips-solutions.com On 21.04.2015 23:30, Podrigal, Aron wrote: MySQL has a option --password to provide the password on command line. postgres however does not. but here is some refs how you can accomplish what you would like. http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel satish@gmail.com wrote: can't we make password less? just like MySQL? On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id -- Aron Podrigal - //Be happy :-) ___ 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 -- Aron Podrigal - //Be happy :-) ___ Users mailing listUsers@lists.opensips.orghttp://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
Re: [OpenSIPS-Users] opensips 1.11 postgress DB BUG
I just did for 1.11 branch, if you want i can do same for 2.1 latest branch On Wed, Apr 22, 2015 at 2:32 PM, Satish Patel satish@gmail.com wrote: Hey Liviu, I have fixed script here is the pull request https://github.com/OpenSIPS/opensips/pull/476 On Wed, Apr 22, 2015 at 8:27 AM, Liviu Chircu li...@opensips.org wrote: Hi Aron/Satish, If you can put together a working Pull Request, I will gladly review it. If bash is not your strong suite, then could you please open a Bug Report [1]? Sooner or later, it will get solved :) [1] https://github.com/OpenSIPS/opensips/issues?q=is%3Aopen+is%3Aissue+label%3Abug Best regards, Liviu Chircu OpenSIPS Developerhttp://www.opensips-solutions.com On 21.04.2015 23:30, Podrigal, Aron wrote: MySQL has a option --password to provide the password on command line. postgres however does not. but here is some refs how you can accomplish what you would like. http://www.postgresql.org/docs/9.4/static/libpq-pgpass.html On Tue, Apr 21, 2015 at 4:26 PM, Satish Patel satish@gmail.com wrote: can't we make password less? just like MySQL? On Tue, Apr 21, 2015 at 1:56 PM, Podrigal, Aron ar...@guaranteedplus.com wrote: It executes a series of sql files ( I don't remember the dir location where its stored I think somewhere in the share dir) for each file it asks for the password. On Tue, Apr 21, 2015 at 1:44 PM, Satish Patel satish@gmail.com wrote: I am installing opensips 1.11.3 with postgress DB but i don't know what is going on here root@dopensips:/etc/opensips# opensipsdbctl create INFO: creating database opensips ... Password for user postgres: Password for user postgres: Password for user postgres: NOTICE: CREATE TABLE / UNIQUE will create implicit index version_t_name_idx for table version Password for user postgres: NOTICE: CREATE TABLE will create implicit sequence acc_id_seq for serial column acc.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index acc_pkey for table acc NOTICE: CREATE TABLE will create implicit sequence missed_calls_id_seq for serial column missed_calls.id -- Aron Podrigal - //Be happy :-) ___ 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 -- Aron Podrigal - //Be happy :-) ___ Users mailing listUsers@lists.opensips.orghttp://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] Simple example to start based on openSIPS
Hello all, I am an instructor in a university. I tried to search for some lab exercises from universities that use openSIPS, but I did not find any. If you know about some, please send me the links. I am looking for a simple example configuration to start, where openSIPS will be user as a Proxy SIP Server. Something like the figure at the bottom. So from SoftPhone1, I can call SoftPhone2 by dialing 1020. openSIPS Proxy SIP SoftPhone1 - 10.0.0.1 --- SoftPhone2 Extension: 1010 Extension: 1020 IP Address=10.0.0.10 IP Address=10.0.0.20 Proxy SIP=10.0.0.1Proxy SIP=10.0.0.1 Maybe, a Registrar Server will be necessary for this lab. If it is the case, I will be interested in using a fourth PC with openSIPS and IP address 10.0.0.2 for the registrar server. Thank you very much for helping with the configuration of this lab. Eric. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users