Install Piwik Web Analytics in RHEL-5.5

                                          PIWIK Configuration

 Piwik for generating website analytics. The reports generated by Piwik are similar to the ones generated by Google Analytics. Piwik is an Open-Source (GPL) tool that you can download and host on your own servers which means you are in full control over your data. In addition to that, Piwik's functionality can be extended by plugins.

1.Install Packages :-

# yum install php-pdo php-gd php-xml php-devel php-pear mysql-devel httpd-devel 
      mysql* httpd*

2.Download piwik (laset.zip).
# uzip -x latest.zip
# mv piwik /var/www/html
3.Give to Premission :- 
# chown -R apache:apache /var/www/html/piwik
# cd /var/www/html
# chmod 777 ./piwik/tmp
#chmod 777 ./piwik/config
# pecl install pdo
# pecl install pdo_mysql
4.Add some line :-
#vim /etc/php.ini
; Dynamic Extensions

extension=pdo.so

extension=pdo_mysql.so
extension=pdo_mysql.so

; Resource Limits

memory_limit = 512M

5.Go to apache configuration :-

# cd /etc/httpd/conf/

# vim httpd.conf

<VirtualHost *:80>

ServerAdmin root@shashi.example.com

DocumentRoot /var/www/html/piwik

ServerName shashi.example.com

# ErrorLog logs/dummy-host.example.com-error_log

# CustomLog logs/dummy-host.example.com-access_log common

</VirtualHost>

# /etc/init.d/httpd restart

# chkconfig httpd on

6.Create a DataBase :-

# /etc/init.d/mysqld start

# chkconfig mysqld on

mysqladmin -u root password 'shashi'

mysql -u root -p shashi

mysql>create database piwik;

mysql>create user piwik@localhost identified by 'shashi';

mysql>grant all privileges on piwik.* to piwik;

mysql>flush privileges;

mysql>\q

# http://shashi.example.com