<div dir="ltr">Hi Sasmita,<br><br>First of all try to make sure that the needed module is loaded indeed, what opensips.log says after starting the application?<br>There should be something like:<br>"opensips[25960]: NOTICE:event_jsonrpc:mod_init: initializing module ..."<br><br>Also, as I can see, your output seems to be truncated, could you upload a full python traceback?<br>A brief attempt to reproduce your problem led me to the following.<br><br>Sometimes the output error description can be a bit non-descriptive.<br>So that module "event_jsonrpc.so" is loaded indeed, but something else appears to be a real obstacle.<br><br>In my case, I basically tried to reproduce the issue by begetting a contradiction of port numbers used on the system.<br>As you run the command "sudo opensips-cli -x diagnose sql", this by default tries to engage a TCP socket and bind it to 8888.<br>You can easily check this with: sudo watch -n0.5 "netstat -tulpn | grep 8888"<br>after running diagnose sub-tool of opensips-cli.<br><br>And the reason for that is this code "./opensipscli/modules/diagnose.py" where it's defined that:<br>"JSONRPC_RCV_PORT = 8888"<br><br>So it seems to be that the default way to communicate over MI interface is http based (I might be mistaken here).<br>A quotation taken from: <a href="https://github.com/OpenSIPS/opensips-cli">https://github.com/OpenSIPS/opensips-cli</a><br> "url: The default URL used when http communication_type is used (Default: <a href="http://127.0.0.1:8888/mi">http://127.0.0.1:8888/mi</a>)"<br><br>Getting back to the original question.<br>We have at least this module - "httpd.so", who could try to engage the same port on your system.<br>Sometimes "httpd.so" works in common with "mi_http.so" though.<br>Eventually after loading at least "httpd.so" on my system, "sudo opensips-cli -x diagnose sql" stopped working.<br><br>And my traceback was as following (is that similar to what you have?) :<br><br>"<br>sudo opensips-cli -x diagnose sql<br>Exception in thread Thread-1:<br>Traceback (most recent call last):<br> File "/usr/lib/python3.6/threading.py", line 916, in _bootstrap_inner<br> self.run()<br> File "/usr/lib/python3.6/threading.py", line 864, in run<br> self._target(*self._args, **self._kwargs)<br> File "/usr/local/lib/python3.6/dist-packages/opensipscli-0.1.0-py3.6.egg/opensipscli/modules/diagnose.py", line 114, in collect_events<br> s.bind((JSONRPC_RCV_HOST, JSONRPC_RCV_PORT))<br>OSError: [Errno 98] Address already in use<br><br>ERROR: Failed to subscribe for JSON-RPC events<br>ERROR: Is the event_jsonrpc.so OpenSIPS module loaded?<br>"<br><br>I hope you will find this useful. Otherwise, please provide a full traceback.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Nov 26, 2020 at 8:01 AM Sasmita Panda <<a href="mailto:spanda@3clogic.com">spanda@3clogic.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi ,<div><br></div><div>opensips-cli -x diagnose sql<br>ERROR: Failed to subscribe for JSON-RPC events<br>ERROR: Is the event_stream.so OpenSIPS module loaded?</div><div><br></div><div>event_stream.so module is loaded by default . What else I should do to get this output . Nothing I am getting from opensips-cli document . <br><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><b><i><br></i></b></div><div><br></div><div dir="ltr"><b><i><br></i></b></div><div dir="ltr"><b><i>Thanks & Regards</i></b><div><i>Sasmita Panda</i></div><div><i>Senior Network Testing and Software Engineer</i></div><div><i>3CLogic , ph:07827611765</i></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Nov 20, 2020 at 5:42 PM Sasmita Panda <<a href="mailto:spanda@3clogic.com" target="_blank">spanda@3clogic.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Thanks a lot . <div><br></div><div>That works . </div><div><br></div><div><br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><b><i>Thanks & Regards</i></b><div><i>Sasmita Panda</i></div><div><i>Senior Network Testing and Software Engineer</i></div><div><i>3CLogic , ph:07827611765</i></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Nov 20, 2020 at 4:55 PM Liviu Chircu <<a href="mailto:liviu@opensips.org" target="_blank">liviu@opensips.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>On 20.11.2020 13:15, Sasmita Panda
wrote:<br>
</div>
<blockquote type="cite">
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line
204, in __init__<br>
super(Connection, self).__init__(*args, **kwargs2)<br>
_mysql_exceptions.OperationalError: (1049, "Unknown database
'opensips'")</blockquote>
<p><tt>I think the problem may be related to this setting:</tt><br>
</p>
<p><i> database_admin_url:
mysql://root:cccl0g1c@localhost/opensips</i></p>
<p><tt>Try to remove the trailing "/opensips" part of the URL,
because the database name is given by the "database_name"
setting.</tt></p>
<p><tt>If it fixes the issue, we should push a commit which does
this automatically.</tt><br>
</p>
<pre cols="72">--
Liviu Chircu
<a href="http://www.twitter.com/liviuchircu" target="_blank">www.twitter.com/liviuchircu</a> | <a href="http://www.opensips-solutions.com" target="_blank">www.opensips-solutions.com</a></pre>
</div>
</blockquote></div>
</blockquote></div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><br></div><div dir="ltr"><div dir="ltr"><font style="background-color:rgb(255,255,255)" color="#0b5394">Best regards,<br></font></div><div dir="ltr"><font style="background-color:rgb(255,255,255)" color="#0b5394">Donat Zenichev<br><br></font></div></div></div></div></div></div></div></div>