klando / pgpiwik Goto Github PK
View Code? Open in Web Editor NEWPiwik port to PostgreSQL
Home Page: http://dev.piwik.org/trac
License: Other
pgpiwik's Introduction
PgPiwik - piwik.org Description =========== Piwik is an open source web analytics software. It gives interesting reports on your website visitors, your popular pages, the search engines keywords they used, the language they speak… and so much more. Piwik aims to be an open source alternative to Google Analytics. Mission statement ================= « To create, as a community, the leading international open source web analytics application, providing access to all functionality through open components and open APIs. » License ======= Piwik is released under the GPL v3 license, see misc/license.txt Requirements ============ - php 5.1.3 minimum - postgresql 8.3 - php PDO module enabled - OS / server independant Install ======= - Upload piwik in your webserver - Become postgres user. (sudo su - postgres) - Create postgresql user: piwik_user (example provided in the misc/PDO_PGSQL.sql file) (createuser piwik_user -S -D -R -P) - Execute the misc/PDO_PGSQL.sql file (change the piwik_user in the sql file if needed) (psql < misc/PDO_PGSQL.sql) - Point your browser to the directory - Follow the steps - Add the given javascript code to your pages Changelog ========= see http://piwik.org/changelog/ API === All the data is available via APIs for example to get todays keywords in XML ?module=API&method=Referers.getKeywords&idSite=1&period=month&date=today&format=xml or yesterday visits information in JSON ?module=API&method=VisitsSummary.get&idSite=1&period=month&date=yesterday&format=json Check the full documentation on http://dev.piwik.org/trac/wiki/API/Reference Generate fake data ================== To generate thousands of fake visits to get some data to play with, you can see the script /misc/generateVisits.php you can edit the number of visits to generate, the number of actions per visit, and the days Contact ======= http://piwik.org [email protected]
pgpiwik's People
Contributors
Stargazers
Watchers
pgpiwik's Issues
Super User not added
When you create the super user during setup it is not adding that user to the database. May be because login and password are reserved words in pgsql and need quotes.
Function ereg() is deprecated
Function ereg() is deprecated
in '/mnt/perso/www/pgpiwik/core/Piwik.php' at the line 88
#0 Piwik_ErrorHandler(8192, Function ereg() is deprecated, /mnt/perso/www/pgpiwik/core/Piwik.php, 88, Array ([directoriesToCheck] => Array ([0] => /tmp,[1] => /tmp/templates_c,[2] => /tmp/cache),[resultCheck] => Array (),[directoryToCheck] => /tmp))
#1 ereg() called at [/mnt/perso/www/pgpiwik/core/Piwik.php:88]
#2 Piwik::checkDirectoriesWritable(Array ([0] => /tmp,[1] => /tmp/templates_c,[2] => /tmp/cache)) called at [/mnt/perso/www/pgpiwik/core/Piwik.php:43]
#3 Piwik::checkDirectoriesWritableOrDie(Array ([0] => /tmp,[1] => /tmp/templates_c,[2] => /tmp/cache)) called at [/mnt/perso/www/pgpiwik/core/FrontController.php:186]
#4 Piwik_FrontController->init() called at [/mnt/perso/www/pgpiwik/index.php:54]
is pgpiwik work fine in php 5.4.9
below is my environment:
PHP 5.4.9-4ubuntu2.3 (cli) (built: Sep 4 2013 19:32:25)
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies
with Xdebug v2.2.3, Copyright (c) 2002-2013, by Derick Rethans
when i visit my pgpiwik site,i got this:
Function ereg() is deprecated
in '/home/workspace/pgpiwik/core/Piwik.php' at the line 88
#0 Piwik_ErrorHandler(8192, Function ereg() is deprecated, /home/workspace/pgpiwik/core/Piwik.php, 88, Array ([directoriesToCheck] => Array ([0] => /tmp,[1] => /tmp/templates_c,[2] => /tmp/cache),[resultCheck] => Array (),[directoryToCheck] => /tmp))
#1 ereg() called at [/home/workspace/pgpiwik/core/Piwik.php:88]
#2 Piwik::checkDirectoriesWritable(Array ([0] => /tmp,[1] => /tmp/templates_c,[2] => /tmp/cache)) called at [/home/workspace/pgpiwik/core/Piwik.php:43]
#3 Piwik::checkDirectoriesWritableOrDie(Array ([0] => /tmp,[1] => /tmp/templates_c,[2] => /tmp/cache)) called at [/home/workspace/pgpiwik/core/FrontController.php:186]
#4 Piwik_FrontController->init() called at [/home/workspace/pgpiwik/index.php:54]
Mysql import
Hello,
Thanks for this project, I'm moving to a new server and would have to install mysql only for piwik.
One thing I wonder, though, and can't find any answer to on this repos : is there a mean to import mysql data ?
Maybe it would be worthing it to mention that on repos' readme.
Updates in core
the updates that are in core will require the database to be updated. But that code is trying to execute commands for mysql and not pgsql. I just removed the updates to get the site to appear. But this should be fixed.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.