Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
Systemd was Rate Limiting the console logs so that's the reason the capture above was incomplete. Piping it to disk revealed the full debug log, thanks for the tip. The problem is that mongo does not have the AUTO INCREMENT id field such as MySQL . The equivalent key is " _id" and is alphanumeric. MSILO uses the id key as the msgid and as such cannot do updates or deletes.Another side effect is that, the core variable** $mi is always zero**. Currently using the patch below ( provided as reference). When the offline message is stored, it adds the "id" field that the module is querying on the m_dump(). [msilo.txt](https://github.com/OpenSIPS/opensips/files/181750/msilo.txt) --- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/798#issuecomment-199150938___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
If you monitor traffic at network level, do you seen opensips sending the delete query to the DB server ? --- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/798#issuecomment-198931970___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
Bogdan, the debug did not really print anything from the MSILO module as posted below, Opensips 2.1.2. There is only a comment in the script during registration when the m_dump() is executed. The mongdb query you see is just housekeeping. Mar 18 10:20:15 : route[initial_requests] : REGISTER: 33.33.33.33 REGISTER message flags: NAT Mar 18 10:20:15 : DBG:core:comp_scriptvar: int 27 : 2 / 2 Mar 18 10:20:15 : route[initial_requests] : REGISTER: 33.33.33.33 REGISTER branch flags: uas_ip4 NAT_BFLAG Mar 18 10:20:15 : DBG:core:parse_headers: flags= Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Running raw mongo query on table db.location Mar 18 10:20:15 : DBG:core:db_new_result: allocate 48 bytes for result set at 0x7f1a4d005930 Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: We have 1 rows Mar 18 10:20:15 : DBG:core:db_allocate_columns: allocate 420 bytes for result columns at 0x7f1a4d0007b8 Mar 18 10:20:15 : DBG:core:db_allocate_rows: allocate 496 bytes for result rows and values at 0x7f1a4d0059f8 Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [contact]=[sip:11@33.33.33.33:5071] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found time [expires]=[1458296438] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found double [q]=[-1.00] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [callid]=[WHdaFfxJD~] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found int [cseq]=[85] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found int [flags]=[0] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [cflags]=[uas_ip4 NAT_BFLAG] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [user_agent]=[Linphone/3.9.1 (belle-sip/1.4.2)] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [received]=[sip:33.33.33.33:5071] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found empty [path] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [socket]=[udp:204.204.204.66:5060] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found empty [methods] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found time [last_modified]=[1458296198] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [sip_instance]=[] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Found string [attr]=[172.16.1] Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_query_trans: Successfully ran query Mar 18 10:20:15 : DBG:usrloc:dbrow2info: flag str: 'uas_ip4 NAT_BFLAG' Mar 18 10:20:15 : DBG:usrloc:dbrow2info: set flags: 1025 Mar 18 10:20:15 : DBG:core:grep_sock_info: checking if host==us: 14==14 && [204.204.204.66] == [204.204.204.66] Mar 18 10:20:15 : DBG:core:grep_sock_info: checking if port 5060 matches port 5060 Mar 18 10:20:15 : DBG:core:evi_param_set: adding string param Mar 18 10:20:15 : DBG:core:evi_param_set: adding string param Mar 18 10:20:15 : DBG:core:evi_param_set: adding string param Mar 18 10:20:15 : DBG:core:evi_param_set: adding string param Mar 18 10:20:15 : DBG:core:evi_param_set: adding int param Mar 18 10:20:15 : DBG:core:destroy_avp_list: destroying list (nil) Mar 18 10:20:15 : DBG:cachedb_mongodb:mongo_db_free_result_trans: freeing mongo query result **Mar 18 10:20:15 : MSILO: offline messages dumped - if any** Mar 18 10:20:15 osys2 /usr/sbin/opensips[20264]: REDIRECTMESSAGE method=MESSAGE r-uri=sip:111...@nstagge.net F=sip:223...@nstagge.net IP=204.204.204.66 [Offline message - Fri Mar 18 08:50:08 2016] Mar 18 10:20:15 osys2 /usr/sbin/opensips[20264]: CALL TO LOCAL method=MESSAGE rd=33.33.33.33 r-uri=sip:11@33.33.33.33:5071 F=sip:223...@nstagge.net IP=204.204.204.66 ID=5d5cf2c441e16243-20274@204.204.204.66 contact=;msilo=yes ft=9ae6a27177c2efc6893cae261e4a0588-6a45 ci=5d5cf2c441e16243-20274@204.204.204.66 Mar 18 10:20:15 osys2 /usr/sbin/opensips[20264]: RRINITIAL -1 10 du= method=MESSAGE r-uri=sip:11@33.33.33.33:5071 F=sip:223...@nstagge.net IP=204.204.204.66 ID=5d5cf2c441e16243-20274@204.204.204.66 Mar 18 10:20:15 osys2 /usr/sbin/opensips[20264]: BRANCH: 10: MESSAGE: rd=33.33.33.33 method=MESSAGE RURI=sip:11@33.33.33.33:5071 FROM=sip:223...@nstagge.net IP=204.204.204.66 sport=5060 reqport=5071 ci=5d5cf2c441e16243-20274@204.204.204.66 Mar 18 10:20:15 : onreply_route : 10: 200: 33.33.33.33 response method=MESSAGE From=sip:223...@nstagge.net ID=5d5cf2c441e16243-20274@204.204.204.66 Mar 18 10:20:15 : onreply_route : 10: 200: 33.33.33.33 message flags: Mar 18 10:20:15 : onreply_route : 10: 200: 33.33.33.33 branch flags: NAT_BFLAG Mar 18 10:20:17 osys2 /usr/sbin/opensips[20270]: route : 46: PUBLISH: 11 33.33.33.33 : PUBLISH uac behind NAT Mar 18 10:20:17 osys2 /usr/sbin/op
Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
@jalung , you printed/posted the debug for mdump() call, but the delete from DB is done on the reply of the sent MESSAGE...If the signaling is ok, opensips should receive a 200 OK reply for the MESSAGE request - the debugs for handling that 200 OK are important. --- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/798#issuecomment-198385521___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
I highlighted the comments on the reply from the UA in the reply-route. M_dump is not printing any de bug messages. Tell me what to change in the code for m_dump to print messages. Two points: It works ok when silo is in mariaDB . If there is a problem with signaling it should not continue to resend the messages indefinitely. --- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/798#issuecomment-198468776___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
BTW, what opensips version are you using ? --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/798#issuecomment-193743689___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] MSILO Module not deleting sent messages Opensips 2.1.2 (#798)
@jalung , do you see any errors (in opensips log) on handling the 200 OK from the end point ? Also, do you see any attempt to actually run the delete query? using debug level 4 will help in providing more output from opensips. --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/798#issuecomment-193743253___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
