What was the problem? How did you fix it? It's good to mention your problems and solutions for people that might experience the same problem in the future.
Regards, Ali Pey On Fri, Aug 24, 2012 at 7:10 PM, Engineer voip <[email protected]> wrote: > 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 <[email protected]>: > > Hi, > > > > restart DB > > restart opensips > > reload apache (service httpd reload) > > > > //Binan > > > > --- On Fri, 8/24/12, Ali Pey <[email protected]> wrote: > > > > From: Ali Pey <[email protected]> > > Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp > > To: "Engineer voip" <[email protected]> > > Cc: "OpenSIPS users mailling list" <[email protected]> > > 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 <[email protected]> > 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 <[email protected]>: > > > >> 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 <[email protected]> > >> 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 <[email protected]>: > > > >>> > 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<[email protected]>: > > > >>> >>> Hi, > > > >>> >>> > > > >>> >>> have you configured files "db.inc.php" and > > > >>> >>> "boxes.global.inc.php" ? > > > >>> >>> > > > >>> >>> --- On Thu, 8/23/12, Engineer voip<[email protected]> wrote: > > > >>> >>> > > > >>> >>> From: Engineer voip<[email protected]> > > > >>> >>> Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp > > > >>> >>> To: "OpenSIPS users mailling list"<[email protected]> > > > >>> >>> Date: Thursday, August 23, 2012, 3:00 PM > > > >>> >>> > > > >>> >>> Hi, > > > >>> >>> someone can help me please !! > > > >>> >>> > > > >>> >>> 2012/8/23, Engineer voip<[email protected]>: > > > >>> >>>> 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<[email protected]>: > > > >>> >>>>> 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<[email protected]> wrote: > > > >>> >>>>> > > > >>> >>>>> From: Engineer voip<[email protected]> > > > >>> >>>>> Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp > > > >>> >>>>> To: "OpenSIPS users mailling list"<[email protected]> > > > >>> >>>>> 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<[email protected]>: > > > >>> >>>>>> Hi, > > > >>> >>>>>> what you get when you click "dialog" under "system" list on > > > >>> >>>>>> opensips-cp > > > >>> >>>>>> ? > > > >>> >>>>>> > > > >>> >>>>>> //Binan > > > >>> >>>>>> > > > >>> >>>>>> --- On Thu, 8/23/12, Engineer voip<[email protected]> wrote: > > > >>> >>>>>> > > > >>> >>>>>> From: Engineer voip<[email protected]> > > > >>> >>>>>> Subject: [OpenSIPS-Users] cdr and Dialog on opensips-cp > > > >>> >>>>>> To: "OpenSIPS users mailling list"<[email protected]> > > > >>> >>>>>> 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 > > > >>> >>>>>> [email protected] > > > >>> >>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > >>> >>>>>> > > > >>> >>>>> _______________________________________________ > > > >>> >>>>> Users mailing list > > > >>> >>>>> [email protected] > > > >>> >>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > >>> >>>>> > > > >>> >>> _______________________________________________ > > > >>> >>> Users mailing list > > > >>> >>> [email protected] > > > >>> >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > >>> >>> > > > >>> >> _______________________________________________ > > > >>> >> Users mailing list > > > >>> >> [email protected] > > > >>> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > >>> >> > > > >>> > > > > >>> > > > >>> _______________________________________________ > > > >>> Users mailing list > > > >>> [email protected] > > > >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > >>> > > > >> > > > > > > > > > > -----Inline Attachment Follows----- > > > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
