<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Erick,<br>
<br>
The global db.inc.php (the one you have in
/var/www/opensips-cp/config/) is used by all the modules as long as
they don't find something more specific defined into their config files
(like, for example, if you want a different db setup for module <b>domains</b>
you can edit <b><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/domains/db.inc.php</span></b>
- and this will override the global db setup ).<br>
<br>
Dialog takes the call information using a MI command. So you must have
OpenSIPS Control Panel and OpenSIPS configured properly (you must
choose between xmlrpc and fifo) - see the OpenSIPS config file (to
enable mi_xmlrpc module or the mi_fifo) and also check the
config/boxes.global.inc.php to have the correct MI connection
parameters set up.<br>
<br>
Regards,<br>
Alex<br>
On 4/27/2010 18:24, Erick Chinchilla Berrocal wrote:
<blockquote cite="mid:008601cae61d$c1a24e00$44e6ea00$@net" type="cite">
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:.5in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
span.EmailStyle19
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
/* List Definitions */
@list l0
        {mso-list-id:979068042;
        mso-list-type:hybrid;
        mso-list-template-ids:1923235720 1979580856 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
        {mso-level-start-at:0;
        mso-level-number-format:bullet;
        mso-level-text:-;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;
        font-family:"Calibri","sans-serif";
        mso-fareast-font-family:Calibri;
        mso-bidi-font-family:"Times New Roman";}
@list l0:level2
        {mso-level-number-format:bullet;
        mso-level-text:o;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;
        font-family:"Courier New";}
@list l0:level3
        {mso-level-number-format:bullet;
        mso-level-text:\F0A7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;
        font-family:Wingdings;}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">FYI<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">According
the manual<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"
lang="ES-CR"><a class="moz-txt-link-freetext" href="http://opensips-cp.sourceforge.net/">http://opensips-cp.sourceforge.net/</a>
Dialog Module (dialog)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">one
option is change the setup
in the file<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/opensips-cp/config/tools/system/dialog/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">in the
configuration I don't
have this file only those following. Please confirm if need the file
“db.inc.php”<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"
lang="ES-CR">/etc/opensips# ls -al
/var/www/opensips-cp/config/tools/system/dialog/<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"
lang="ES-CR">total 16<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"
lang="ES-CR">drwxr-xr-x 2
www-data www-data 4096 2010-04-26 13:46 .<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"
lang="ES-CR">drwxr-xr-x 16
www-data www-data 4096 2010-04-26 11:49 ..<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"
lang="ES-CR">-rw-r--r-- 1
www-data www-data 1243 2010-03-08 12:54 local.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">-rw-r--r--
1 www-data www-data
1094 2010-03-08 12:54 menu.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Look this
file in the other
modules and get. In the modules…/tools/… are in default setup<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/etc/opensips#
find / -name
db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/admin/add_admin/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/admin/list_admins/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/users/user_management/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/users/alias_management/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/smonitor/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/cdrviewer/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/permissions/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/domains/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/loadbalancer/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/drouting/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/siptrace/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/pdt/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/nathelper/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/dialplan/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/tools/system/dispatcher/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/db.inc.php<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph" style="text-indent: -0.25in;"><!--[if !supportLists]--><span
style="color: rgb(31, 73, 125);"><span style="">-<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">Now, I understand
that if only changed this file is ok for all modules, can you confirm
if is
correct<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: "Courier New"; color: rgb(31, 73, 125);"><span
style="">o<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">/var/www/opensips-cp/config/db.inc.php<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);">//database driver
mysql or pgsql<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> $config->db_driver
= "mysql";<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> //database host<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> $config->db_host
= "localhost";<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> //database port -
leave empty for default<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> $config->db_port
= "";<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> //database
connection user<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> $config->db_user
= "root";<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> //database
connection password<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> $config->db_pass
= "password for root";<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> //database name<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> $config->db_name
= "opensips";<o:p></o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoListParagraph"
style="margin-left: 1.5in; text-indent: -0.25in;"><!--[if !supportLists]--><span
style="font-family: Wingdings; color: rgb(31, 73, 125);"><span style="">§<span
style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none;">
</span></span></span><!--[endif]--><span
style="color: rgb(31, 73, 125);"> if
(!empty($config->db_port) ) $config->db_host =
$config->db_host .
":" . $config->db_port;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">I want to
test the
"Opensips-Control Panel" but for the modules "CDR Views"
and "Dialog" don't get any information, the same with the module
"SIPTrace"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Her you
can help me I appreciate
it<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Erick Ch.<o:p></o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
<a class="moz-txt-link-abbreviated" href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>
[<a class="moz-txt-link-freetext" href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>] <b>On
Behalf Of </b>Erick Chinchilla Berrocal<br>
<b>Sent:</b> Monday, April 26, 2010 11:35 AM<br>
<b>To:</b> 'OpenSIPS users mailling list'<br>
<b>Subject:</b> [OpenSIPS-Users] Opensips 1.6.2 w/ Control Panel 4.0
- Problem
w/ CDRViews and Dialog<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">FYI <o:p></o:p></p>
<p class="MsoNormal">I tried to get (look) the calls in the modules
CDRViewer and
Dialog and not is possible.<o:p></o:p></p>
<p class="MsoNormal">The following files have the default
configuration and the
MySQL tables is according the script.<o:p></o:p></p>
<p class="MsoNormal">/var/www/opensips-cp/config/tools/system/cdrviewer/local.inc.php<o:p></o:p></p>
<p class="MsoNormal">/var/www/opensips-cp/config/tools/system/dialog/local.inc.php<o:p></o:p></p>
<p class="MsoNormal">This is the configuration for the modules in the
file
opensips.cfg<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">#<o:p></o:p></p>
<p class="MsoNormal">loadmodule "db_mysql.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "signaling.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "sl.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "tm.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "rr.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "maxfwd.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "usrloc.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "registrar.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "textops.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "mi_fifo.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "uri.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "xlog.so"<o:p></o:p></p>
<p class="MsoNormal">loadmodule "acc.so"<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">#<o:p></o:p></p>
<p class="MsoNormal"># ----- usrloc params -----<o:p></o:p></p>
<p class="MsoNormal">/* uncomment the following lines if you want to
enable DB
persistency<o:p></o:p></p>
<p class="MsoNormal"> for location entries */<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc",
"db_mode", 2)<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "db_url",<o:p></o:p></p>
<p class="MsoNormal">
"mysql://opensips:opensipsrw@localhost/opensips")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "use_domain", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "nat_bflag", 3)<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "user_column",
"username")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "domain_column",
"domain")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "contact_column",
"contact")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "expires_column",
"expires")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "q_column",
"q")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "callid_column",
"callid")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "cseq_column",
"cseq")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "methods_column",
"methods")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "flags_column",
"flags")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "cflags_column",
"cflags")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "user_agent_column",
"user_agent")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "received_column",
"received")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "socket_column",
"socket")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "path_column",
"path")<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "use_domain", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "desc_time_order", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "timer_interval",
120)<o:p></o:p></p>
<p class="MsoNormal">modparam("usrloc", "matching_mode", 1)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">##<o:p></o:p></p>
<p class="MsoNormal"># ----- acc params -----<o:p></o:p></p>
<p class="MsoNormal">/* what sepcial events should be accounted ? */<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "early_media", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "report_ack", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "report_cancels", 1)<o:p></o:p></p>
<p class="MsoNormal">/* by default ww do not adjust the direct of the
sequential
requests.<o:p></o:p></p>
<p class="MsoNormal"> if you enable this parameter, be sure the
enable "append_fromtag"<o:p></o:p></p>
<p class="MsoNormal"> in "rr" module */<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "detect_direction", 0)<o:p></o:p></p>
<p class="MsoNormal">/* account triggers (flags) */<o:p></o:p></p>
<p class="MsoNormal">modparam("acc",
"failed_transaction_flag", 3)<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "log_flag", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "log_missed_flag", 2)<o:p></o:p></p>
<p class="MsoNormal">/* uncomment the following lines to enable DB
accounting
also */<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "db_flag", 1)<o:p></o:p></p>
<p class="MsoNormal">modparam("acc", "db_missed_flag", 2)<o:p></o:p></p>
<p class="MsoNormal">#modparam("acc", "db_extra",
"from_did=$avp(s:from_did);to_did=$avp(s:to_did)")<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks<o:p></o:p></p>
<p class="MsoNormal">Erick Ch.<o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><br>
<br>
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 3997 (20090409) __________<br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a moz-do-not-send="true" href="http://www.eset.com">http://www.eset.com</a><br>
<br>
<br>
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 3997 (20090409) __________<br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a moz-do-not-send="true" href="http://www.eset.com">http://www.eset.com</a><o:p></o:p></span></p>
</div>
<br>
<br>
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 3997 (20090409) __________<br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a moz-do-not-send="true" href="http://www.eset.com">http://www.eset.com</a><br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Alex Ionescu
<a class="moz-txt-link-abbreviated" href="http://www.voice-system.ro">www.voice-system.ro</a> </pre>
</body>
</html>