[OpenSIPS-Users] cdr and Dialog on opensips-cp

Engineer voip forvoip4 at gmail.com
Fri Aug 24 14:47:17 CEST 2012 

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 <bogdan at 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<binanalhalabi at yahoo.com>:
>>> Hi,
>>>
>>> have you configured files  "db.inc.php" and
>>> "boxes.global.inc.php" ?
>>>
>>> --- On Thu, 8/23/12, Engineer voip<forvoip4 at gmail.com>  wrote:
>>>
>>> From: Engineer voip<forvoip4 at gmail.com>
>>> Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp
>>> To: "OpenSIPS users mailling list"<users at lists.opensips.org>
>>> Date: Thursday, August 23, 2012, 3:00 PM
>>>
>>> Hi,
>>> someone can help me please !!
>>>
>>> 2012/8/23, Engineer voip<forvoip4 at 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<binanalhalabi at 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<forvoip4 at gmail.com>  wrote:
>>>>>
>>>>> From: Engineer voip<forvoip4 at gmail.com>
>>>>> Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp
>>>>> To: "OpenSIPS users mailling list"<users at 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<binanalhalabi at yahoo.com>:
>>>>>> Hi,
>>>>>> what you get when you click "dialog" under "system" list on
>>>>>> opensips-cp
>>>>>> ?
>>>>>>
>>>>>> //Binan
>>>>>>
>>>>>> --- On Thu, 8/23/12, Engineer voip<forvoip4 at gmail.com>  wrote:
>>>>>>
>>>>>> From: Engineer voip<forvoip4 at gmail.com>
>>>>>> Subject: [OpenSIPS-Users] cdr and Dialog on opensips-cp
>>>>>> To: "OpenSIPS users mailling list"<users at 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 at lists.opensips.org
>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>

More information about the Users mailing list