Centos 6.5 Install Piwik 3.0.1，centospiwik

Centos 6.5 Install Piwik 3.0.1，centospiwik

依赖包
yum install numactl libaio perl-Time-HiRes per-devel httpd -y
====================================================================================================================================================================
解压mysql
tar -xvf mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar

查看原来安装的Mysql  
rpm -qa | grep mysql

卸载原来mysql
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

安装Mysql安装顺序安装
rpm -ivh mysql-community-common-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.11-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.11-1.el6.x86_64.rpm

添加mysql参数
vi /etc/my.cnf
character_set_server=utf8
lower_case_table_names=1
max_connections=1000

启动Mysql服务  
service mysqld start

查看MySQL服务器的状态
service mysqld status

设置开机启动   
chkconfig mysqld on

生成随机密码
grep 'temporary password' /var/log/mysqld.log

重新登陆
mysql -uroot -p  
b/xE8hdZoEwJ

配置Mysql 密码以及权限
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Report@123';

允许root用户在任何地方进行远程登录，并具有所有库任何操作权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Report@123' WITH GRANT OPTION;
FLUSH PRIVILEGES;

创建数据库piwik
create database piwik;

grant all privileges on piwik.* to piwik@'localhost' identified by 'Report@123';

====================================================================================================================================================================
在线php5.6安装
Centos 6
rpm -Uvh http://ftp.iij.ad.jp/pub/linux/fedora/epel/6/x86_64/epel-release-6-8.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

Centos 7
yum install epel-release
rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm


安装php
yum install --enablerepo=remi --enablerepo=remi-php56 php php-opcache php-devel php-mbstring php-mcrypt php-mysqlnd php-phpunit-PHPUnit php-pecl-xdebug php-pecl-xhprof php-mysql php-pdo php-gd php-mbstring php-dom php-xml

配置php
vim /etc/php.ini
mbstring.func_overload = 0
extension=mysqli.so
extension=pdo.so
extension=pdo_mysql.so

#396
memory_limit = 512M

#705
always_populate_raw_post_data = -1

查看php版本
php --version

====================================================================================================================================================================
下载piwik3.0.1
wget https://builds.piwik.org/piwik.zip

解压piwik
cd /var/www/html/
unzip  piwik.zip

赋予权限
chown -R apache:apache /var/www/html/piwik
chmod -R 0755 /var/www/html/piwik/tmp

启动httpd
service httpd start

测试页面访问
http://192.168.31.64/piwik/