Changes between Version 16 and Version 17 of PiwikServer

Timestamp:

06/29/11 12:30:16 (5 years ago)

Author:

chris

Comment:

--

PiwikServer

@@ -94 +94 @@
 }}}
 
-=== GA Import  and Python ===
+=== Python ===
 
-For the Google Analytics data import we need Python 2.6 and we are running with Python 2.5.2, so [http://evan.borgstrom.ca/post/845359613/python-2-6-on-debian-lenny-5-0 following this]:
+For the Google Analytics data import we need Python 2.6 and we are running with Python 2.5.2, so [http://evan.borgstrom.ca/post/845359613/python-2-6-on-debian-lenny-5-0 following this] a source compile was done on the dev server, however for the live server it would make more sense to follow [http://www.fps-gamer.net/installing-python-2-6-on-debian-lenny/ these instructions and use the debs from testing perhaps]:
 
 {{{
@@ -107 +107 @@
 make
 make install 
+ln -s /usr/local/lib/libpython2.6.so* /usr/lib/
+cd /usr/local/src
+wget 'http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz#md5=7df2a529a074f613b509fb44feefe74e'
+tar zxvf setuptools-0.6c11.tar.gz
+cd setuptools-0.6c11
+python setup.py install
+cd /usr/local/src
+wget "https://gdata-python-client.googlecode.com/files/gdata-2.0.14.tar.gz" --no-check-certificate
+tar -zxvf gdata-2.0.14.tar.gz
+cd gdata-2.0.14
+python setup.py install
+purge python-mysqldb
+wget "http://downloads.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz"
+tar -zxvf MySQL-python-1.2.3.tar.gz 
+cd MySQL-python-1.2.3
+vim site.cfg
+ mysql_config = /usr/bin/mysql_config
+aptitude install libmysqlclient-dev
+python setup.py build
+python setup.py install
 }}}
+
+=== GA Import ===
+
+See python notes above and [http://clearcode.cc/offer/open-source-projects/google2piwik/ Google2Piwik].
+
+{{{
+cd /web/piwik.transitionnetwork.org/
+wget http://clearcode.cc/google2piwik-1.2.5.tgz
+tar -zxvf google2piwik-1.2.5.tgz
+cd google2piwik-1.2.5
+cp google2piwik.conf.sample google2piwik.conf
+}}}
+
+Edit {{{google2piwik.conf}}}:
+
+{{{
+## Google Account Credentials
+# If you don't know your site table_id type:
+#                       ./google2piwik.py -p
+[google]
+user_login = XXX@gmail.com
+user_pass  = XXX
+table_id   = ga:XXX
+
+# MySQL Piwik Database configuration
+[mysql]
+db = piwik
+host = localhost
+port = 3306
+user = piwik
+passwd = XXX
+table_prefix = 
+
+# Set export date range
+[export]
+start = 2011-05-01
+end   = 2011-06-29
+
+## Piwik configuration of site.
+# For default Piwik installation with one website, site_id should be set to 1
+[piwik]
+site_id  = 1
+site_url = http://www.transitionnetwork.org
+}}}
+
 
 == Requirements ==