[SR-Users] web homer not displaying data

[Christopher Holland]

I have  sipcapture and siptrace setup on the same server using kamailio 
3.4.0-dev4 and webhomer 3.3.0 setup to capture sip traffic from a 
mirriored port on the LAN. Interface ETH1 is to capture and ETH0 is for 
managment.

The sipcapture database is getting data put into it. I can log into 
webhomer, but see no data in the graphes nor can I search. I have double 
checked my database permissions and they seem to be set up correctly.

webserver is set up with:

Apache/2.2.16 (Debian)
PHP5
MYSQL
Json
phpmyadmin

Here is a copy of my kamailio.cfg and configuration.php

rev_dns=no
auto_aliases=no

debug=1
log_stderror=no

memdbg=5
memlog=5

log_facility=LOG_LOCAL0

fork=yes
children=5

/* uncomment the next line to disable TCP (default on) */
disable_tcp=yes

/* IP and port for HEP capturing) */
listen=udp:127.0.0.1:9060

mpath="/usr/local/lib/kamailio/modules_k/:/usr/local/lib/kamailio/modules/"

loadmodule "pv.so"
loadmodule "db_mysql.so"
loadmodule "sipcapture.so"
loadmodule "textops.so"
loadmodule "siptrace.so"

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

####### Routing Logic ########
modparam("sipcapture", "db_url", "mysql://openser:******@localhost/homerdb")
modparam("sipcapture", "capture_on", 1)
/* activate HEP capturing */
modparam("sipcapture", "hep_capture_on", 1)
/* IP to listen. Port/Portrange apply only on mirroring port capturing */
modparam("sipcapture", "raw_socket_listen", "10.0.0.0:5060-5080")
/* Name of interface to bind on raw socket */
modparam("sipcapture", "raw_interface", "eth1")
/* activate IPIP capturing */
#modparam("sipcapture", "raw_ipip_capture_on", 1)
/* My table name*/
modparam("sipcapture", "table_name", "sip_capture")
/* children for raw socket */
modparam("sipcapture", "raw_sock_children", 4)
/* insert delayed */
#modparam("sipcapture", "db_insert_mode", 1)
/* activate monitoring/mirroring port capturing. Linux only */
modparam("sipcapture", "raw_moni_capture_on", 1)
/* Promiscious mode RAW socket. Mirroring port. Linux only */
modparam("sipcapture", "promiscious_on", 1)
/* activate Linux Socket Filter (LSF/BPF) on mirroring interface. Linux 
only */
#modparam("sipcapture", "raw_moni_bpf_on", 1)
/* sipcapture node */
modparam("sipcapture", "capture_node", "homer01")

# check IP and port of your capture node
modparam("siptrace", "duplicate_uri","sip:127.0.0.1:9060")
modparam("siptrace", "hep_mode_on", 1)
modparam("siptrace", "trace_to_database", 0)
modparam("siptrace", "trace_flag",22)
modparam("siptrace", "trace_on", 1)

# Main SIP request routing logic
# - processing of any incoming SIP request starts with this route
route {
        sip_capture();
        drop;
}
onreply_route {
        sip_capture();
        drop;
}

##################################

configuration.php

<?php

/*********************************************************************************/
/* Access db of homer */
define('HOST', "localhost");
define('PORT', 3306);
define('USER', "webhomer");
define('PW', "******");
define('DB', "web_homer");

/* Homer connection
*  this user must have the same password for all Homer nodes
*  please define all your nodes in homer_nodes table
*/
define('HOMER_HOST', "localhost"); /* DEFAULT. Don't forget insert this 
host to your DB nodes table */
define('HOMER_PORT', 3306);
define('HOMER_USER', "openser");
define('HOMER_PW', "******");
define('HOMER_DB', "homerdb");
define('HOMER_TABLE', "sip_capture");

/*********************************************************************************/

/* webHomer Settings
*  Adjust to reflect your system preferences
*/

define('PCAPDIR',"/var/www/webhomer/tmp/");
define('WEBPCAPLOC',"/webhomer/tmp/");
define('APIURL',"http://localhost");
define('APILOC',"/webhomer/api/");

/* INCLUDE preferences */

include("preferences.php");

?>