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