[OpenSIPS-Users] Opensips 1.6.2 w/ Control Panel 4.0 - Problem w/ CDRViews and Dialog

Erick Chinchilla Berrocal erick at netcrc.net
Wed Apr 28 19:08:16 CEST 2010


Alex this is my current setup 

-          /var/www/opensips-cp/config/db.inc.php

//database driver mysql or pgsql

                $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 = "passwd root";

 

                //database name

                $config->db_name = "opensips";

 

 if (!empty($config->db_port) ) $config->db_host = $config->db_host . ":" .
$config->db_port;

 

?>

 

-          /var/www/opensips-cp/config/boxes.global.inc.php

/*==================== DEFINITION OF BOXES (servers)
========================*/

// each server is a box

 

$box_id=0;

 

// mi host:port pair || fifo_file

$boxes[$box_id]['mi']['conn']="/tmp/opensips_fifo";

 

// monit host:port

$boxes[$box_id]['monit']['conn']="127.0.0.1:2812";

$boxes[$box_id]['monit']['user']="admin";

$boxes[$box_id]['monit']['pass']="monit";

$boxes[$box_id]['monit']['has_ssl']=0;

 

 

// description (appears in mi , monit )

$boxes[$box_id]['desc']="Primary 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;

 

-          Opensips.cfg

-          # ----- mi_fifo params -----

-          modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")

-          modparam("mi_fifo", "fifo_mode", 0666)

 

Thanks

Erick Ch.

 

From: users-bounces at lists.opensips.org
[mailto:users-bounces at lists.opensips.org] On Behalf Of Alex Ionescu
Sent: Wednesday, April 28, 2010 3:07 AM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] Opensips 1.6.2 w/ Control Panel 4.0 - Problem
w/ CDRViews and Dialog

 

Hi Erick,

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 domains you can edit
/var/www/opensips-cp/config/tools/system/domains/db.inc.php - and this will
override the global db setup ).

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.

Regards,
Alex
On 4/27/2010 18:24, Erick Chinchilla Berrocal wrote: 

FYI

According the manual

http://opensips-cp.sourceforge.net/ Dialog Module (dialog)

one option is change the setup in the file

/opensips-cp/config/tools/system/dialog/db.inc.php

in the configuration I don't have this file only those following. Please
confirm if need the file "db.inc.php"

/etc/opensips# ls -al /var/www/opensips-cp/config/tools/system/dialog/

total 16

drwxr-xr-x  2 www-data www-data 4096 2010-04-26 13:46 .

drwxr-xr-x 16 www-data www-data 4096 2010-04-26 11:49 ..

-rw-r--r--  1 www-data www-data 1243 2010-03-08 12:54 local.inc.php

-rw-r--r--  1 www-data www-data 1094 2010-03-08 12:54 menu.inc.php

 

Look this file in the other modules and get. In the modules./tools/.  are in
default setup

/etc/opensips# find / -name db.inc.php

/var/www/opensips-cp/config/tools/admin/add_admin/db.inc.php

/var/www/opensips-cp/config/tools/admin/list_admins/db.inc.php

/var/www/opensips-cp/config/tools/users/user_management/db.inc.php

/var/www/opensips-cp/config/tools/users/alias_management/db.inc.php

/var/www/opensips-cp/config/tools/system/smonitor/db.inc.php

/var/www/opensips-cp/config/tools/system/cdrviewer/db.inc.php

/var/www/opensips-cp/config/tools/system/permissions/db.inc.php

/var/www/opensips-cp/config/tools/system/domains/db.inc.php

/var/www/opensips-cp/config/tools/system/loadbalancer/db.inc.php

/var/www/opensips-cp/config/tools/system/drouting/db.inc.php

/var/www/opensips-cp/config/tools/system/siptrace/db.inc.php

/var/www/opensips-cp/config/tools/system/pdt/db.inc.php

/var/www/opensips-cp/config/tools/system/nathelper/db.inc.php

/var/www/opensips-cp/config/tools/system/dialplan/db.inc.php

/var/www/opensips-cp/config/tools/system/dispatcher/db.inc.php

/var/www/opensips-cp/config/db.inc.php

 

Now, I understand that if only changed this file is ok for all modules, can
you confirm if is correct

/var/www/opensips-cp/config/db.inc.php

//database driver mysql or pgsql

 $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 = "password for root";

 

 //database name

 $config->db_name = "opensips";

 

 if (!empty($config->db_port) ) $config->db_host = $config->db_host . ":" .
$config->db_port;

 

 

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"

Her you can help me I appreciate it

 

Thanks

Erick Ch.

From: users-bounces at lists.opensips.org
[mailto:users-bounces at lists.opensips.org] On Behalf Of Erick Chinchilla
Berrocal
Sent: Monday, April 26, 2010 11:35 AM
To: 'OpenSIPS users mailling list'
Subject: [OpenSIPS-Users] Opensips 1.6.2 w/ Control Panel 4.0 - Problem w/
CDRViews and Dialog

 

FYI 

I tried to get (look) the calls in the modules CDRViewer and Dialog and not
is possible.

The following files have the default configuration and the MySQL tables is
according the script.

/var/www/opensips-cp/config/tools/system/cdrviewer/local.inc.php

/var/www/opensips-cp/config/tools/system/dialog/local.inc.php

This is the configuration for the modules in the file opensips.cfg

 

#

loadmodule "db_mysql.so"

loadmodule "signaling.so"

loadmodule "sl.so"

loadmodule "tm.so"

loadmodule "rr.so"

loadmodule "maxfwd.so"

loadmodule "usrloc.so"

loadmodule "registrar.so"

loadmodule "textops.so"

loadmodule "mi_fifo.so"

loadmodule "uri.so"

loadmodule "xlog.so"

loadmodule "acc.so"

 

#

# ----- usrloc params -----

/* uncomment the following lines if you want to enable DB persistency

   for location entries */

modparam("usrloc", "db_mode",   2)

modparam("usrloc", "db_url",

        "mysql://opensips:opensipsrw@localhost/opensips")

modparam("usrloc", "use_domain", 1)

modparam("usrloc", "nat_bflag", 3)

modparam("usrloc", "user_column", "username")

modparam("usrloc", "domain_column", "domain")

modparam("usrloc", "contact_column", "contact")

modparam("usrloc", "expires_column", "expires")

modparam("usrloc", "q_column", "q")

modparam("usrloc", "callid_column", "callid")

modparam("usrloc", "cseq_column", "cseq")

modparam("usrloc", "methods_column", "methods")

modparam("usrloc", "flags_column", "flags")

modparam("usrloc", "cflags_column", "cflags")

modparam("usrloc", "user_agent_column", "user_agent")

modparam("usrloc", "received_column", "received")

modparam("usrloc", "socket_column", "socket")

modparam("usrloc", "path_column", "path")

modparam("usrloc", "use_domain", 1)

modparam("usrloc", "desc_time_order", 1)

modparam("usrloc", "timer_interval", 120)

modparam("usrloc", "matching_mode", 1)

 

##

# ----- acc params -----

/* what sepcial events should be accounted ? */

modparam("acc", "early_media", 1)

modparam("acc", "report_ack", 1)

modparam("acc", "report_cancels", 1)

/* by default ww do not adjust the direct of the sequential requests.

   if you enable this parameter, be sure the enable "append_fromtag"

   in "rr" module */

modparam("acc", "detect_direction", 0)

/* account triggers (flags) */

modparam("acc", "failed_transaction_flag", 3)

modparam("acc", "log_flag", 1)

modparam("acc", "log_missed_flag", 2)

/* uncomment the following lines to enable DB accounting also */

modparam("acc", "db_flag", 1)

modparam("acc", "db_missed_flag", 2)

#modparam("acc", "db_extra",
"from_did=$avp(s:from_did);to_did=$avp(s:to_did)")

 

 

Thanks

Erick Ch.



__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3997 (20090409) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3997 (20090409) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3997 (20090409) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



 
 
_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
  






-- 
Alex Ionescu
www.voice-system.ro 



__________ Information from ESET NOD32 Antivirus, version of virus signature
database 3997 (20090409) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100428/cf362f00/attachment-0001.htm 


More information about the Users mailing list