<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi,<br><br>restart DB<br>restart opensips<br>reload apache (service httpd reload)<br><br>//Binan<br><br>--- On <b>Fri, 8/24/12, Ali Pey <i><alipey@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Ali Pey <alipey@gmail.com><br>Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp<br>To: "Engineer voip" <forvoip4@gmail.com><br>Cc: "OpenSIPS users mailling list" <users@lists.opensips.org><br>Date: Friday, August 24, 2012, 8:37 AM<br><br><div id="yiv1817640649"><div>Did you get an error for the dlg_list command? Did you try to make some calls and try the dialog list command?</div><div><br></div><div>Basically this means your fifo is working but you don't either have dialog module loaded or your opensips-cp is not working. Look at your opensipsctl
config file in your config directory and see where it's pointing for the fifo file. Make sure it matches your opensips-cp configuration.</div>
<div><br></div><div>Regards,</div><div>Ali Pey</div><br><div class="yiv1817640649gmail_quote">On Fri, Aug 24, 2012 at 9:45 AM, Engineer voip <span dir="ltr"><<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>></span> wrote:<br>
<blockquote class="yiv1817640649gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hello,<br>
<br>
** The result of opensipsctl fifo arg is:<br>
<br>
root@Poste-810:/usr/local/sbin# opensipsctl fifo arg<br>
/usr/local/sbin/opensips<br>
-P<br>
/var/run/opensips/opensips.pid<br>
-m<br>
64<br>
-M<br>
4<br>
-u<br>
opensips<br>
-g<br>
opensips<br>
<br>
** But no resultat for opensipsctl fifo dlg_list<br>
2012/8/24, Ali Pey <<a rel="nofollow" ymailto="mailto:alipey@gmail.com" target="_blank" href="/mc/compose?to=alipey@gmail.com">alipey@gmail.com</a>>:<br>
<div class="yiv1817640649HOEnZb"><div class="yiv1817640649h5">> Try these commands:<br>
><br>
> opensipsctl fifo arg<br>
> opensipsctl fifo dlg_list<br>
><br>
> and post the results here. This should give you a pretty good clue.<br>
><br>
> Regards,<br>
> Ali Pey<br>
><br>
> On Fri, Aug 24, 2012 at 8:47 AM, Engineer voip <<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>> wrote:<br>
><br>
>> Hello,<br>
>><br>
>> ** how can i verify that MI connector points to the server?<br>
>><br>
>> ** I have loadid the dialog module in my opensips.cfg like that:<br>
>><br>
>> loadmodule "dialog.so"<br>
>> modparam("dialog", "dlg_match_mode", 1)<br>
>> modparam("dialog", "default_timeout", 21600) # 6 hours timeout<br>
>> modparam("dialog", "db_mode", 1)<br>
>> modparam("dialog", "db_update_period", 30)<br>
>> modparam("dialog", "table_name", "dialog")<br>
>> modparam("dialog",<br>
>> "db_url","mysql://opensips:opensipsrw@localhost/opensips") # CUSTOMIZE<br>
>> ME<br>
>> modparam("dialog", "call_id_column", "callid")<br>
>> modparam("dialog", "from_uri_column", "from_uri")<br>
>> modparam("dialog", "from_tag_column", "from_tag")<br>
>> modparam("dialog", "to_uri_column", "to_uri")<br>
>> modparam("dialog", "to_tag_column", "to_tag")<br>
>> modparam("dialog", "from_cseq_column", "caller_cseq")<br>
>> modparam("dialog", "to_cseq_column", "callee_cseq")<br>
>> modparam("dialog", "state_column", "state")<br>
>> modparam("dialog", "start_time_column", "start_time")<br>
>><br>
>> ** For information in my acc table the cdr_id value is empty and i<br>
>> don't know how i do to have it, any idea please??<br>
>><br>
>><br>
>> Regards<br>
>><br>
>> 2012/8/24, Bogdan-Andrei Iancu <<a rel="nofollow" ymailto="mailto:bogdan@opensips.org" target="_blank" href="/mc/compose?to=bogdan@opensips.org">bogdan@opensips.org</a>>:<br>
>> > Hi,<br>
>> ><br>
>> > Are you 100% sure that the MI connector you put in CP<br>
>> > ("/tmp/opensips_fifo") points to the server you actually want to<br>
>> > interrogate for dialogs ?<br>
>> ><br>
>> > As I see the MI communication works (as you get the "command dlg_list<br>
>> > is<br>
>> > not available" reply), but it seems you talk from CP with an opensips<br>
>> > which does not have dialog module loaded.<br>
>> ><br>
>> > I leads to 2 options: either you talk to wrong opensips instance,<br>
>> > either<br>
>> > your opensips (if only one) loads a different cfg file than you think<br>
>> > (maybe uses the default one instead the one you listed here).<br>
>> ><br>
>> > Regards,<br>
>> ><br>
>> > Bogdan-Andrei Iancu<br>
>> > OpenSIPS Founder and Developer<br>
>> > <a rel="nofollow" target="_blank" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><br>
>> ><br>
>> ><br>
>> > On 08/24/2012 01:30 PM, Engineer voip wrote:<br>
>> >> Hello,<br>
>> >><br>
>> >> yes i have configured them like:<br>
>> >><br>
>> >> db.inc.php configuration is:<br>
>> >><br>
>> >> $config->db_driver = "mysql";<br>
>> >><br>
>> >> //database host<br>
>> >> $config->db_host = "localhost";<br>
>> >><br>
>> >> //database port - leave empty for default<br>
>> >> $config->db_port = "";<br>
>> >><br>
>> >> //database connection user<br>
>> >> $config->db_user = "root";<br>
>> >><br>
>> >> //database connection password<br>
>> >> $config->db_pass = "1234";<br>
>> >><br>
>> >> //database name<br>
>> >> $config->db_name = "opensips";<br>
>> >><br>
>> >> if (!empty($config->db_port) ) $config->db_host = $config->db_host .<br>
>> >> ":" . $config->db_port;<br>
>> >><br>
>> >><br>
>> --------------------------------------------------------------------------------------------------------------------------------------<br>
>> >> boxes.global.inc.php configuration:<br>
>> >><br>
>> >> $box_id=0;<br>
>> >><br>
>> >> // mi host:port pair || fifo_file<br>
>> >> //$boxes[$box_id]['mi']['conn']="<a rel="nofollow" target="_blank" href="http://127.0.0.1:8000">127.0.0.1:8000</a>";<br>
>> >> $boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";<br>
>> >><br>
>> >> // monit host:port<br>
>> >> //$boxes[$box_id]['monit']['conn']="<a rel="nofollow" target="_blank" href="http://192.168.1.7:2812">192.168.1.7:2812</a>";<br>
>> >> //$boxes[$box_id]['monit']['conn']="<a rel="nofollow" target="_blank" href="http://127.0.0.1:2812">127.0.0.1:2812</a>";<br>
>> >> $boxes[$box_id]['monit']['user']="admin";<br>
>> >> $boxes[$box_id]['monit']['pass']="admin";<br>
>> >> $boxes[$box_id]['monit']['has_ssl']=0;<br>
>> >><br>
>> >><br>
>> >> // description (appears in mi , monit )<br>
>> >> $boxes[$box_id]['desc']="SIP server";<br>
>> >><br>
>> >><br>
>> >> $boxes[$box_id]['assoc_id']=1;<br>
>> >><br>
>> >> // enable local smonitor charts on this box : 0=disabled 1=enabled<br>
>> >> // (cron)<br>
>> >> $boxes[$box_id]['smonitor']['charts']=1;<br>
>> >><br>
>> >><br>
>> >><br>
>> >> Thanks<br>
>> >><br>
>> >><br>
>> >><br>
>> >> 2012/8/24, Binan AL Halabi<<a rel="nofollow" ymailto="mailto:binanalhalabi@yahoo.com" target="_blank" href="/mc/compose?to=binanalhalabi@yahoo.com">binanalhalabi@yahoo.com</a>>:<br>
>> >>> Hi,<br>
>> >>><br>
>> >>> have you configured files "db.inc.php" and<br>
>> >>> "boxes.global.inc.php" ?<br>
>> >>><br>
>> >>> --- On Thu, 8/23/12, Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>> wrote:<br>
>> >>><br>
>> >>> From: Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>><br>
>> >>> Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp<br>
>> >>> To: "OpenSIPS users mailling list"<<a rel="nofollow" ymailto="mailto:users@lists.opensips.org" target="_blank" href="/mc/compose?to=users@lists.opensips.org">users@lists.opensips.org</a>><br>
>> >>> Date: Thursday, August 23, 2012, 3:00 PM<br>
>> >>><br>
>> >>> Hi,<br>
>> >>> someone can help me please !!<br>
>> >>><br>
>> >>> 2012/8/23, Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>>:<br>
>> >>>> Hello,<br>
>> >>>> I did all this procedures but don't work<br>
>> >>>><br>
>> >>>> my dialog configuration is:<br>
>> >>>><br>
>> >>>> ### dialog module ####<br>
>> >>>> loadmodule "dialog.so"<br>
>> >>>> modparam("dialog", "dlg_match_mode", 1)<br>
>> >>>> modparam("dialog", "default_timeout", 21600) # 6 hours timeout<br>
>> >>>> modparam("dialog", "db_mode", 1)<br>
>> >>>> modparam("dialog", "db_update_period", 30)<br>
>> >>>> modparam("dialog", "table_name", "dialog")<br>
>> >>>> modparam("dialog",<br>
>> >>>> "db_url","mysql://opensips:opensipsrw@localhost/opensips")<br>
>> >>>> modparam("dialog", "call_id_column", "callid")<br>
>> >>>> modparam("dialog", "from_uri_column", "from_uri")<br>
>> >>>> modparam("dialog", "from_tag_column", "from_tag")<br>
>> >>>> modparam("dialog", "to_uri_column", "to_uri")<br>
>> >>>> modparam("dialog", "to_tag_column", "to_tag")<br>
>> >>>> modparam("dialog", "from_cseq_column", "caller_cseq")<br>
>> >>>> modparam("dialog", "to_cseq_column", "callee_cseq")<br>
>> >>>> modparam("dialog", "state_column", "state")<br>
>> >>>> modparam("dialog", "start_time_column", "start_time")<br>
>> >>>><br>
>> >>>><br>
>> >>>> Thank you for your help.<br>
>> >>>><br>
>> >>>> Regards<br>
>> >>>><br>
>> >>>> 2012/8/23, Binan AL Halabi<<a rel="nofollow" ymailto="mailto:binanalhalabi@yahoo.com" target="_blank" href="/mc/compose?to=binanalhalabi@yahoo.com">binanalhalabi@yahoo.com</a>>:<br>
>> >>>>> Hi ,<br>
>> >>>>> 1- for Dialog : you have to load& configure the<br>
>> >>>>> module "dialog" in OpenSIPS script.<br>
>> >>>>><br>
>> >>>>> 2- for CDR viewer :<br>
>> >>>>> - add table *cdrs.mysql* and stored procedure<br>
>> *opensips_cdrs.mysql*<br>
>> >>>>> to OPENSIPS database<br>
>> >>>>> - edit the cron_job/generate-cdrs_mysql.sh file and change the<br>
>> >>>>> mysql<br>
>> >>>>> connection data (hostname,username,password and database)<br>
>> >>>>> - call the script from the cron<br>
>> >>>>><br>
>> >>>>> check the opensips-cp INSTALL file for this.<br>
>> >>>>><br>
>> >>>>> //Binan<br>
>> >>>>><br>
>> >>>>> --- On Thu, 8/23/12, Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>> wrote:<br>
>> >>>>><br>
>> >>>>> From: Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>><br>
>> >>>>> Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp<br>
>> >>>>> To: "OpenSIPS users mailling list"<<a rel="nofollow" ymailto="mailto:users@lists.opensips.org" target="_blank" href="/mc/compose?to=users@lists.opensips.org">users@lists.opensips.org</a>><br>
>> >>>>> Date: Thursday, August 23, 2012, 6:15 AM<br>
>> >>>>><br>
>> >>>>> hello,<br>
>> >>>>><br>
>> >>>>> when i click "dialog" i get the message "<br>
>> >>>>> ERROR:mi_fifo:mi_fifo_server: command dlg_list is not available "<br>
>> >>>>><br>
>> >>>>> thank you for help<br>
>> >>>>><br>
>> >>>>> 2012/8/23, Binan AL Halabi<<a rel="nofollow" ymailto="mailto:binanalhalabi@yahoo.com" target="_blank" href="/mc/compose?to=binanalhalabi@yahoo.com">binanalhalabi@yahoo.com</a>>:<br>
>> >>>>>> Hi,<br>
>> >>>>>> what you get when you click "dialog" under "system" list on<br>
>> >>>>>> opensips-cp<br>
>> >>>>>> ?<br>
>> >>>>>><br>
>> >>>>>> //Binan<br>
>> >>>>>><br>
>> >>>>>> --- On Thu, 8/23/12, Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>> wrote:<br>
>> >>>>>><br>
>> >>>>>> From: Engineer voip<<a rel="nofollow" ymailto="mailto:forvoip4@gmail.com" target="_blank" href="/mc/compose?to=forvoip4@gmail.com">forvoip4@gmail.com</a>><br>
>> >>>>>> Subject: [OpenSIPS-Users] cdr and Dialog on opensips-cp<br>
>> >>>>>> To: "OpenSIPS users mailling list"<<a rel="nofollow" ymailto="mailto:users@lists.opensips.org" target="_blank" href="/mc/compose?to=users@lists.opensips.org">users@lists.opensips.org</a>><br>
>> >>>>>> Date: Thursday, August 23, 2012, 3:06 AM<br>
>> >>>>>><br>
>> >>>>>> Hello All,<br>
>> >>>>>><br>
>> >>>>>> I'm using opensips-cp with opensips 1.8, and i can do the call<br>
>> >>>>>> between<br>
>> >>>>>> two<br>
>> >>>>>> users but i can't get the CDRs and Dialog informations by using<br>
>> >>>>>> opensips-cp.<br>
>> >>>>>><br>
>> >>>>>><br>
>> >>>>>> someone can help me, please?<br>
>> >>>>>><br>
>> >>>>>><br>
>> >>>>>> thanks<br>
>> >>>>>><br>
>> >>>>>><br>
>> >>>>>> -----Inline Attachment Follows-----<br>
>> >>>>>><br>
>> >>>>>> _______________________________________________<br>
>> >>>>>> Users mailing list<br>
>> >>>>>> <a rel="nofollow" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>> >>>>>> <a rel="nofollow" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>> >>>>>><br>
>> >>>>> _______________________________________________<br>
>> >>>>> Users mailing list<br>
>> >>>>> <a rel="nofollow" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>> >>>>> <a rel="nofollow" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>> >>>>><br>
>> >>> _______________________________________________<br>
>> >>> Users mailing list<br>
>> >>> <a rel="nofollow" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>> >>> <a rel="nofollow" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>> >>><br>
>> >> _______________________________________________<br>
>> >> Users mailing list<br>
>> >> <a rel="nofollow" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>> >> <a rel="nofollow" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>> >><br>
>> ><br>
>><br>
>> _______________________________________________<br>
>> Users mailing list<br>
>> <a rel="nofollow" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br>
>> <a rel="nofollow" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
>><br>
><br>
</div></div></blockquote></div><br>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Users mailing list<br><a ymailto="mailto:Users@lists.opensips.org" href="/mc/compose?to=Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></blockquote></td></tr></table>