[SR-Users] web homer not displaying data

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"); ?>