we have a few web servers and am planning to create a dashboard to show the real time stats ip address,geo-location and other custom data based on database lookups. Splunk sort of fits perfectly but wondering if there are any open source alternative . i have looked at logstash and graylog2, but to my knowledge they are more of a log analysis tools. Piwik is sort of interesting except that i cannot put any javascript on the webpages. All i have access to is apache web log. Any recommendations please..
I'm running a website where the checkout flow is SSL certified using a Comodo EV certificate.
We also have Piwik web analytics tracking across the site, which is served off a stats subdomain. To prevent mixed domain errors, the Piwik is accessible via HTTPS as well as HTTP - for HTTPS, our Piwik subdomain is certified using a (much cheaper) Comodo PositiveSSL certificate.
Here's the weird part - when an HTTPS page on the main site is accessed through wget and some versions of Internet Explorer, the stats.psychicbazaar.com certificate seems to somehow get loaded by mistake, leading to "Mismatched Address" warnings in IE, and in wget:
ERROR: certificate common name `stats.psychicbazaar.com' doesn't match requested host name `www.psychicbazaar.com'.
This problem does not occur with curl, Chrome or Firefox. For example, with curl:
$ curl -Iv https://www.psychicbazaar.com/shop/checkout
* <snip>
* Connected to www.psychicbazaar.com (178.79.183.162) port 443 (#0)
* successfully set certificate verify locations:
* CAfile: none
CApath: /etc/ssl/certs
* SSLv3, TLS handshake, Client hello (1):
* SSLv3, TLS handshake, Server hello (2):
* SSLv3, TLS handshake, CERT (11):
* SSLv3, TLS handshake, Server key exchange (12):
* SSLv3, TLS handshake, Server finished (14):
* SSLv3, TLS handshake, Client key exchange (16):
* SSLv3, TLS change cipher, Client hello (1):
* SSLv3, TLS handshake, Finished (20):
* SSLv3, TLS change cipher, Client hello (1):
* SSLv3, TLS handshake, Finished (20):
* SSL connection using DHE-RSA-AES256-SHA
* Server certificate:
* subject: serialNumber=07440589; 1.3.6.1.4.1.311.60.2.1.3=GB; 1.3.6.1.4.1.311.60.2.1.
2=Greater London; businessCategory=Private Organization; C=GB; postalCode=EC24 4RQ; ST=Greater
London; L=London; street=The Roma Building 32-38; O=Psychic Bazaar Ltd; OU=COMODO EV
* start date: 2012-02-16 00:00:00 GMT
* expire date: 2013-02-15 23:59:59 GMT
* subjectAltName: www.psychicbazaar.com matched
* issuer: C=GB; ST=Greater Manchester; L=Salford; O=COMODO CA Limited; CN=COMODO Extended Validation Secure Server CA
* SSL certificate verify ok.
> HEAD /shop/checkout HTTP/1.1
> User-Agent: curl/7.21.6 (x86_64-pc-linux-gnu) libcurl/7.21.6 OpenSSL/1.0.0e zlib/1.2.3.4 libidn/1.22 librtmp/2.3
> Host: www.psychicbazaar.com
> Accept: */*
>
< <snip>
What could be going on here - why would a browser be reading and erroring on a subdomain's SSL certificate when it's loading a page on the main domain? Any help much appreciated!
I've tried using XAMPP to install this app, locally on my computer, and it works. But when I get to the server, XAMPP is not what I need to use PIWIK (it's like a google analytics clone). It's based on PHP and MySQL. But I require to install it in a Windows 2003 R2 SP2 Server using IIS. I've tried several things to add an extension that servers PHP in Windows IIS. But nothing makes it work. It's always the ERROR 400 and everything seems fine. All the tutorials talk about a ISAPI PHP but I don't see that in the version I downloadedhttp://meta.stackexchange.com/questions/5029/are-taglines-signatures-disallowed and Edit powers activate! Removing Hi/Thanks today.
Can someone help me with really good clear instructions? I'm lost and I really need to get this moving as soon as possible, any volunteers?
I have always been somewhat reluctant to "outsource" site statistics to Google.
We have an Apache server running on a Windows server. I am pretty sure all the foundation to collect the needed visitor data are there.
I would like to stop using GA, and use some form of application where the data does not travel to a third party but remains at the host, or at least travels to the remote administrator, if it is a log analyzer in a browser.
What are my options?
I am looking a modern, PHP based visitor statistics tracker. As mentioned in the title it must be open source. The other features it must contain are referrer tracking, no of unique hit by daily, monthly etc, with reports.
Does anyone have any suggestions?
Thanks