[SR-Users] web homer not displaying data

[Christopher Holland]

I've checked my apache errors.log There are no errors. also I've checked 
phpinfo.php and it shows pdo drivers mysql enabled. So I'll email 
support at sipcature.org

Thanks all for the help


On 10/26/12 14:06, Alexandr Dubovikov wrote:
> 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
>
>
> _______________________________________________
> 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
>