[SR-Users] web homer not displaying data

[Alexandr Dubovikov]

Hi Christopher,

at first please check your apache errors.log. Seems you have problem 
with PDO driver. If you want get support for Webhomer, please contact us 
by email: support at sipcapture.org

Wbr,
Alexandr


10/26/2012 7:17 PM, Christopher Holland wrote:
> 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");
>
> ?>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users