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