klando / pgpiwik Goto Github PK
View Code? Open in Web Editor NEWPiwik port to PostgreSQL
Home Page: http://dev.piwik.org/trac
License: Other
Piwik port to PostgreSQL
Home Page: http://dev.piwik.org/trac
License: Other
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]
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
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]
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]
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.
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.