[OpenSIPS-Users] osipsconsole doesn't seem to work for me
Since osipsconsole came out I have never really used it because I can't get it to work. Now I am starting to look into why I can't get it to work. I followed the install guide but I am not sure what's wrong Proxy01:/etc/opensips-mi-proxy# osipsconsole Control engine FIFO loaded OpenSIPS$:domain show Used database is mysql coolbeans.com irock.com OpenSIPS$:db show location Unknown command OpenSIPS$: OpenSIPS$:add 9013319...@irock.com password1234 Used database is mysql 9013319320 irock.com Entry could not be retrieved from tableYou 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 username = '9013319320' AND domain = 'irock.com'' at line 3 Query results: Here is the osicpsconsolerc file I configured (does it matter if the database was originally created with opensipsctl??) # $Id: osicpsconsolerc # # The OpenSIPS configuration file for the control tools. # # Here you can set variables used in the opensipsctl and opensipsdbctl setup # scripts. Per default all variables here are commented out, the control tools # will use their internal default values. ## your SIP domain SIP_DOMAIN=ae.com ## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT, by default none is loaded # If you want to setup a database with opensipsdbctl, you must at least specify # this parameter. DBENGINE=MYSQL ## database host DBHOST=173.XXX.XXX.219 ## database port (PostgreSQL=5433 mandatory; MYSQL=3306 optional) DBPORT=3306 #DBPORT=5000 ## database name (for ORACLE this is TNS name) DBNAME=opensips ## database path used by dbtext or db_berkeley # DB_PATH="/usr/local/etc/opensips/dbtext" ## database read/write user DBRWUSER=opensips ## password for database read/write user DBRWPW= ## database read only user # DBROUSER=opensipsro ## password for database read only user # DBROPW=opensipsro ## database super user (for ORACLE this is 'scheme-creator' user) DBROOTUSER=opensips # Program to calculate a message-digest fingerprint # MD5=md5sum # awk tool # AWK=awk # grep tool # GREP=egrep # sed tool # SED=sed # Describe what additional tables to install. Valid values for the variables # below are yes/no/ask. With ask (default) it will interactively ask the user # for an answer, while yes/no allow for automated, unassisted installs. # # Define what module tables should be installed. # If you use the postgres database and want to change the installed tables, then you # must also adjust the STANDARD_TABLES or EXTRA_TABLES variable accordingly in the # opensipsdbctl.base script. # opensips standard modules # STANDARD_MODULES="standard acc lcr domain group permissions registrar usrloc msilo # alias_db uri_db speeddial avpops auth_db pdt dialog dispatcher # dialplan drouting nathelper load_balancer" # opensips extra modules # EXTRA_MODULES="imc cpl siptrace domainpolicy carrierroute userblacklist" ## type of aliases used: DB - database aliases; UL - usrloc aliases ## - default: none # ALIASES_TYPE=DB ## MI_CONNECTOR control engine: FIFO, UNIXSOCK, UDP, XMLRPC MI_CONNECTOR=FIFO:/var/run/opensips/fifo #MI_CONNECTOR=UNIXSOCK:/var/run/opensips/socket # MI_CONNECTOR=UDP:192.168.2.133:8000 #MI_CONNECTOR=XMLRPC:173.XXX.XXX.134:8080 ## check ACL names; default on (1); off (0) # VERIFY_ACL=1 ## ACL names - if VERIFY_ACL is set, only the ACL names from below list ## are accepted # ACL_GROUPS="local ld int voicemail free-pstn" ## do (1) or don't (0) store plaintext passwords ## in the subscriber table - default '1' STORE_PLAINTEXT_PW=0 ## OPENSIPS START Options ## PID file path - default is: /var/run/opensips.pid PID_FILE=/var/run/opensips/opensips.pid ## OUTPUT control - default output is to SYSLOG ## 0=output to console, 1=output to syslog SYSLOG=0 ## Extra start options - default is: not set # example: start opensips with 64MB share memory: STARTOPTIONS="-m 64" # STARTOPTIONS= -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/osipsconsole-doesn-t-seem-to-work-for-me-tp5738903p5738903.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Simple ACC test with MySQL
Modified... and still no records in the ACC table nor errors in the syslog (although I have set the debug level to 9). On Wed, Nov 10, 2010 at 10:52 AM, David Santiago < david.santi...@almiralabs.com> wrote: > Hum... you're right, I'll modify it; although no errors appear in the > syslog... > > > On Fri, Nov 5, 2010 at 7:29 PM, Brett Nemeroff wrote: > >> David, >> If you bump up the debug on your server and make a call, it'll display a >> nice message that will indicate that it's missing fields. Have you tried >> that? >> -Brett >> >> >> On Fri, Nov 5, 2010 at 11:48 AM, David Santiago < >> david.santi...@almiralabs.com> wrote: >> >>> Hi, >>> >>> I'm trying to generate CDRs in an OpenSIPS test server. I have checked >>> the stored procedure that comes with opensips-cp to perform this task and >>> have noticed that queries the ACC table in order to populate the CDRS table. >>> >>> Well, first things first. I have used the basic opensips.cfg.sample >>> configuration (I will not copy it entirely here), adding the changes >>> required to use mysql with the acc module (after having compiled with mysql >>> support, of course): >>> >>> ... >>> loadmodule "db_mysql.so" >>> ... >>> /* uncomment the following lines to enable DB accounting also */ >>> modparam("acc", "db_flag", 1) >>> modparam("acc", "db_missed_flag", 2) >>> modparam("acc", "db_url", "mysql://opensips:opensip...@localhost/opensips") >>> #Pointer to the DB >>> modparam("acc", "db_extra", "from_uri=$fu; to_uri=$tu") #Extra data >>> ... >>> >>> I have also modified the ACC table in order to add those fields specified >>> in the last modparam instruction shown above: >>> >>> mysql -u root >>> USE OPENSIPS; >>> ALTER TABLE `acc` ADD `caller_id` CHAR( 64 ) NOT NULL ; >>> ALTER TABLE `acc` ADD `callee_id` CHAR( 64 ) NOT NULL ; >>> >>> After those changes, I'm calling from a voip provider that is linked to >>> the OpenSIPS test server, in order to send it an INVITE, which is being >>> received as I have been able to debug with tcpdump. >>> >>> BUT... no data is being inserted in the ACC table. I can successfully log >>> into the database with the credentials used in the "db_url" parameter. >>> >>> Am I wrong assuming that the ACC module is supposed to populate that >>> table with the setting of flags upon INVITE and BYE requests? >>> >>> >>> Regards, >>> David >>> >>> ___ >>> 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] Does OpenXCAP support IPv6 network?
Hi, Does OpenXCAP support IPv6 network? How to let OpenXCAP listen an IPv6 address? CheeWii ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Asterisk Integration - Manipulate Asterisk Contexts
Thanks for the suggestion Mike. -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Asterisk-Integration-Manipulate-Asterisk-Contexts-tp5711054p5738464.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Load balancer probing from incorrect interface
Hi Bill, is your opensips actually listening (configured as listener in .cfg) on a interface in the private network (where the probing needs to be done) ?? Regards, Bogdan Bill W wrote: Hey Bogdan, I enabled the mhomed=1 parameter, and now I'm getting a bunch of errors in the logs. ERROR:tm:t_uac: no socket found ERROR:load_balancer:lb_do_probing: probing failed ERROR:core:get_out_socket: no socket found ERROR:tm:uri2sock: no corresponding socket for af 2 Thoughts? Bill On 11/8/2010 6:05 AM, Bogdan-Andrei Iancu wrote: Hi Bill, as you have a multi interface system, have you tried to enable the "mhomed" global parameter? http://www.opensips.org/Resources/DocsCoreFcn16#toc60 Regards, Bogdan Bill W. wrote: As an update, the load balancer probe appears to use the ip address specified by the first listen= directive. If I list the public IP first, then the probe tries to talk to the internal IP from the external interface IP. On 11/7/10 6:18 PM, Bill W. wrote: Hello everyone, I've got an opensips-1.6.3-tls installation using multiple interfaces and load balancing. My internal interface is rfc1918 space and my external interface has public IPs. listen=udp:10.0.10.3:5060 listen=udp:66.180.205.3:5060 I have the following load_balancer configuration: id | group_id | dst_uri | probe_mode +--+---+ 1 |1 | sip:66.180.205.11 | 2 2 |1 | sip:66.180.205.12 | 2 3 |2 | sip:10.0.10.1 | 2 4 |2 | sip:10.0.10.2 | 2 What's happening is that the load balancer is trying to probe the public IPs from the private interface IP (and failing of course). tcpdump output on internal interface: 18:13:26.471734 IP 10.0.10.3.5060> 66.180.205.11.5060: SIP, length: 18:13:28.473802 IP 10.0.10.3.5060> 66.180.205.11.5060: SIP, length: Thoughts? Thanks, Bill ___ 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 -- Bogdan-Andrei Iancu OpenSIPS Bootcamp 15 - 19 November 2010, Edison, New Jersey, USA www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Simple ACC test with MySQL
Hum... you're right, I'll modify it; although no errors appear in the syslog... On Fri, Nov 5, 2010 at 7:29 PM, Brett Nemeroff wrote: > David, > If you bump up the debug on your server and make a call, it'll display a > nice message that will indicate that it's missing fields. Have you tried > that? > -Brett > > > On Fri, Nov 5, 2010 at 11:48 AM, David Santiago < > david.santi...@almiralabs.com> wrote: > >> Hi, >> >> I'm trying to generate CDRs in an OpenSIPS test server. I have checked the >> stored procedure that comes with opensips-cp to perform this task and have >> noticed that queries the ACC table in order to populate the CDRS table. >> >> Well, first things first. I have used the basic opensips.cfg.sample >> configuration (I will not copy it entirely here), adding the changes >> required to use mysql with the acc module (after having compiled with mysql >> support, of course): >> >> ... >> loadmodule "db_mysql.so" >> ... >> /* uncomment the following lines to enable DB accounting also */ >> modparam("acc", "db_flag", 1) >> modparam("acc", "db_missed_flag", 2) >> modparam("acc", "db_url", "mysql://opensips:opensip...@localhost/opensips") >> #Pointer to the DB >> modparam("acc", "db_extra", "from_uri=$fu; to_uri=$tu") #Extra data >> ... >> >> I have also modified the ACC table in order to add those fields specified >> in the last modparam instruction shown above: >> >> mysql -u root >> USE OPENSIPS; >> ALTER TABLE `acc` ADD `caller_id` CHAR( 64 ) NOT NULL ; >> ALTER TABLE `acc` ADD `callee_id` CHAR( 64 ) NOT NULL ; >> >> After those changes, I'm calling from a voip provider that is linked to >> the OpenSIPS test server, in order to send it an INVITE, which is being >> received as I have been able to debug with tcpdump. >> >> BUT... no data is being inserted in the ACC table. I can successfully log >> into the database with the credentials used in the "db_url" parameter. >> >> Am I wrong assuming that the ACC module is supposed to populate that table >> with the setting of flags upon INVITE and BYE requests? >> >> >> Regards, >> David >> >> ___ >> 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] Load balancer probe _mode=1 bug?
Hi Bill, Perfect! I backported the fix to 1.6 also. Thanks and regards, Bogdan Bill W wrote: Hey Bogdan, Looks like your patch is working. My probe interval was set to 15 seconds, but I increased it to 60 for testing. The disabling, probing, and re-enabling appear to be working correctly now. Thanks so much! Bill On 11/8/2010 7:24 AM, Bogdan-Andrei Iancu wrote: Hi Bill, What is the probing interval you configured ? http://www.opensips.org/html/docs/modules/1.6.x/load_balancer.html#id250040 Could you test the attached patch ? (same as revision 7356 on trunk). Regards, Bogdan Bill W. wrote: Hello Bogdan, This is how I mark the destination down: failure_route[1] { if (t_check_status("(408)|(5[0-9][0-9])")) { lb_disable(); if (load_balance("1","sip","1")) { t_on_failure("1"); t_relay(); } else { t_reply("503", "Service Unavailable"); } } } opensipsctl fifo lb_list shows: enabled=no auto-re=on I do not see any probes from opensips when probe_mode in the database is set to "1" which should probe the destination when it's marked down. When probe_mode is set to "2", and opensips probes continuously, it works fine. The docs say: "(1) - probing only when the destination is in disabled mode (disabling via MI command will competely stop the probing also). The destination will be automatically re-enabled when the probing will succeed next time;" So when I disable via lb_disable(), it is acting like I did it from the MI, and disabling the probing too. Thoughts? Thanks, Bill On 8/1/10 1:14 PM, Bogdan-Andrei Iancu wrote: Hi Bill, How do you mark down the destination (MI ?) and what state are you setting ? Also, after marking it down, do you see any new pings being sent to that destination? Something was changed during rev 6653: http://opensips.svn.sourceforge.net/opensips/?rev=6653&view=rev But the new code seams ok for me - the LB_DST_STAT_NOEN_FLAG flag is set when disabling the destination via MI and with this flag set, no more pings are sent. Regards, Bogdan Bill W wrote: Hello Bogdan, I'm experiencing the same problem as I did before, with the load balancer not re-enabling a device marked down. If I go into the database and set probe_mode = 2, it re-enables the device. I'm currently running opensips 1.6.2-tls (x86_64/linux) Did the patch get reverted? Thanks! Bill Bogdan-Andrei Iancu wrote: Super! I uploaded the fix on SVN. Thanks and regards, Bogdan Bill W wrote: Hey Bogdan, It looks like that fixed it. Thanks so much! Bill Bogdan-Andrei Iancu wrote: Hi Bill, Could you please try the attached patch? It seams that there was an issue with the the probing values in the code. Let me know if the patch does solves your problem and I will upload it on SVN. Regards, Bogdan ___ 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 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Bogdan-Andrei Iancu OpenSIPS Bootcamp 15 - 19 November 2010, Edison, New Jersey, USA www.voice-system.ro ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] modparam?
I'm trying to make HA cluster with balancing. I have 2 servers with openSIPS with load_balanicng and mysql with replication. While both servers are working second openSIPS connects to mysql-master at the first server. When the first server fails then second should uses itself mysql database. So I need to change db_url parameter through all modules. WBR, Anton Zagorskiy VoIP Developer, Oyster Telecom Phone.: +7 812 601-0666 Fax: +7 812 601-0593 a.zagors...@oyster-telecom.ru www.oyster-telecom.ru > -Original Message- > From: users-boun...@lists.opensips.org [mailto:users- > boun...@lists.opensips.org] On Behalf Of Bogdan-Andrei Iancu > Sent: Wednesday, November 10, 2010 1:16 PM > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] modparam? > > Hi Anton, > > no, you cannotwhat module are looking at ? > > Regards, > Bogdan > > Anton Zagorskiy wrote: > > Hello. > > > > Can I change module's parameter in the route block? I want to change > db_url > > parameter. > > > > > > > > > > > > > > WBR, Anton Zagorskiy > > VoIP Developer, Oyster Telecom > > Phone.: +7 812 601-0666 > > Fax: +7 812 601-0593 > > a.zagors...@oyster-telecom.ru > > www.oyster-telecom.ru > > > > > > > > > > ___ > > Users mailing list > > Users@lists.opensips.org > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > -- > Bogdan-Andrei Iancu > OpenSIPS Bootcamp > 15 - 19 November 2010, Edison, New Jersey, USA > www.voice-system.ro > > > ___ > 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