LAMP Knowledge

-
apache work with php:
1. cgi(too old)
2. fastcgi (socket)
3. module

php work with mysql: mysql driver / protocol through 3306 port

L: Linux
A: Apache
M: Mysql
P: Php

Program: command + data

Whole process: client --> index.php / http --> apache (httpd) --> fastcgi php web sever --> mysql client / drive --> mysql (script) --> mysql database

Website infrastructure:
2003 taobao lamp in one server -->after half year,  la in one server; p in one server; m in one server

module: lap + m / lamp
fastcgi: la + m + p / lam + p / lap +m / lamp

yum install lamp (module) + wordpress
php only can work in perfork mode
1. yum install httpd
2. yum install php
3. create php page
<html>
    <body>
        <?php
            phpinfo();
        ?>
    </body>
</html>
4. yum install mysql
5. yum install mysql-server
6. /usr/bin/mysql_secure_installation
7. yum install php-mysql
8. Upload wordpress to /var/www/html
9. unzip the file
10. login mysql create wordpress database
11. mv wp-config-sample.php wp-config.php
12. visit http://192.168.192.128/wordpress and input mysql information

binary install lamp + fastcgi 
httpd2.2: by default no fastcgi module; 
httpd2.4: by default has fastcgi module: mod_proxy_fcgi;

One server: httpd / mysql / php 
1. yum install gcc pcre-devel openssl-devel

2. tar xvf apr-1.5.0.tar.bz2
./configure --prefix=/usr/local/apr
make && make install

3. tar xvf apr-util-1.5.3.tar.bz2
./configure --prefix=/usr/local/apr-util --with-apr=/usr/local/apr
make && make install

4. tar xvf httpd-2.4.9.tar.bz2
./configure --prefix=/usr/local/httpd --sysconfdir=/etc/httpd --enable-so --enable-ssl --enable-cgi --enable-rewrite --with-zlib --with-pcre --with-apr=/usr/local/apr --with-apr-util=/usr/local/apr-util/ --enable-modules=most --enable-mpms-shared=all --with-mpm=event
make && make install

5. Install mysql
tar  xf  mariadb-5.5.36-linux-x86_64.tar.gz -C /usr/local
cd /usr/local
ln -s mariadb-5.5.36-linux-x86_64  mysql

bin  二进制程序
data  数据存放目录
scripts/mysql_install_db   mysql初始化脚本
support-file    样例文件
其中国有样例配置文件，但是提供了不同的版本
huge  海量内存
large  服务器硬件叫充分
small  较少的内存
mysql.server  服务脚本

groupadd  -r  mysql
useradd -g mysql -r mysql 
mkdir -p /mydatad/data
chown -R mysql:mysql  /mydata/data

cd /usr/local/mysql
scripts/mysql_install_db --datadir=/mydata/data  --user=mysql  
mkdir /etc/mysql
cp  support-file/my-large.cnf  /etc/mysql/my.cnf

vim /etc/mysql/my.cnf
add: datadir=/mydata/data

cp support-file/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --list mysqld
service mysqld start

vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
. /etc/profile.d/mysql.sh

6. Install PHP
yum install libxml2-devel  libmcrypt-devel(epel源中)  bzip2-devel
tar  xf php-5.4.26
./configure --prefix=/usr/local/php  --with-mysql=/usr/local/mysql  --with-openssl --with-mysqli=/usr/local/mysql/bin/mysql_config  --enable-mbstring  --with-freetype-dir --with-jpeg-dir --with-png-dir  --with-zlib  --with-libxml-dir=/usr  --enable-xml --enable-sockets --enable-fpm --with-mcrypt --with-bz2 --with-config-file-path=/etc/php/php.ini --with-config-file-scan-dir=/etc/php/php.d/
make && make  install

7. PHP Config：
php的配置文件：php.ini
php的守护进程配置文件：fpm.conf

mkdir -pv /etc/php/php.d
cd /tmp/php-5.4.25
cp php.ini-production /etc/php/php.ini
cp sapi/fpm/init.d.php-fpm   /etc/rc.d/init.d/php-fpm
cd /usr/local/php/etc
mv php-fpm.conf.default php-fpm.conf
cd /etc/rc.d/init.d
chmod +x php-fpm
chkconfig --add php-fpm

vim /usr/local/php/etc/php-fpm.conf
listen = 127.0.0.1:9000
listen.allowed_clients = 127.0.0.1

8. httpd Config:
vim  /etc/httpd/httpd.conf
LoadModule proxy_module  modeles/mod_proxy.so
LoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so 

AddType  application/x-httpd-php  .php
AddType  application/x-httpd-php-source  .phps

关闭正向代理
ProxyRequests Off 
ProxyPassMatch ^/(.*\.php)$  fcgi://127.0.0.1:9000/usr/local/httpd/htdocs/$1

9. Test php
index.php
<?php
    phpinfo();
?>

conn.php
<?php
        $conn = mysql_connect ('127.0.0.1','root','123456');
        if ($conn)
                echo "succ";
        else
                echo "faiure";

        mysql_close();
?>

10. install wordpress
unzip wordpress...
mv wordpress /usr/local/httpd/htdocs

create wordpress databsae in mysql

vim /etc/httpd/httpd.conf

Change from 
DirectoryIndex index.html
to 

DirectoryIndex index.html index.php


cd /usr/local/httpd/htdocs
mv wp-config-sample.php wp-config.php

Three server installation
Server 1(Apache): httpd + apr + apr_util
Server 2(php): php + php-mysql + fastcgi
Server 3(Mysql): mysql-server

Server 1
1. yum install gcc pcre-devel openssl-devel

2. tar xvf apr-1.5.0.tar.bz2
./configure --prefix=/usr/local/apr
make && make install

3. tar xvf apr-util-1.5.3.tar.bz2
./configure --prefix=/usr/local/apr-util --with-apr=/usr/local/apr
make && make install

4. tar xvf httpd-2.4.9.tar.bz2
./configure --prefix=/usr/local/httpd --sysconfdir=/etc/httpd --enable-so --enable-ssl --enable-cgi --enable-rewrite --with-zlib --with-pcre --with-apr=/usr/local/apr --with-apr-util=/usr/local/apr-util/ --enable-modules=most --enable-mpms-shared=all --with-mpm=event
make && make install

5. httpd Config:
vim  /etc/httpd/httpd.conf
LoadModule proxy_module  modeles/mod_proxy.so
LoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so 

AddType  application/x-httpd-php  .php
AddType  application/x-httpd-php-source  .phps

关闭正向代理
ProxyRequests Off 
ProxyPassMatch ^/(.*\.php)$  fcgi://12.11.0.102:9000/var/log/php/$1


6. Test php
index.php
<?php
    phpinfo();
?>

conn.php
<?php
        $conn = mysql_connect ('12.11.0.103','root','123456');
        if ($conn)
                echo "succ";
        else
                echo "faiure";

        mysql_close();
?>

7. install wordpress
unzip wordpress...
mv wordpress /usr/local/httpd/htdocs

vim /etc/httpd/httpd.conf

Change from 
DirectoryIndex index.html
to 
DirectoryIndex index.html index.php

Server 3
1. Install mysql
tar  xf  mariadb-5.5.36-linux-x86_64.tar.gz -C /usr/local
cd /usr/local
ln -s mariadb-5.5.36-linux-x86_64  mysql

bin  二进制程序
data  数据存放目录
scripts/mysql_install_db   mysql初始化脚本
support-file    样例文件
其中国有样例配置文件，但是提供了不同的版本
huge  海量内存
large  服务器硬件叫充分
small  较少的内存
mysql.server  服务脚本

groupadd  -r  mysql
useradd -g mysql -r mysql 
mkdir -p /mydatad/data
chown mysql:mysql  /mydata/data

cd /usr/local/mysql
scripts/mysql_install_db --datadir=/mydata/data  --user=mysql  
mkdir /etc/mysql
cp  support-file/my-large.cnf  /etc/mysql/my.cnf

vim /etc/mysql/my.cnf
add: datadir=/mydata/data

cp support-file/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --list mysqld
service mysqld start

vim /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
. /etc/profile.d/mysql.sh

create wordpress databsae in mysql

Server 2
1. Install mysql
tar  xf  mariadb-5.5.36-linux-x86_64.tar.gz -C /usr/local
cd /usr/local
ln -s mariadb-5.5.36-linux-x86_64  mysql

2. Install PHP
yum install libxml2-devel  libmcrypt-devel(epel源中)  bzip2-devel gcc openssl-devel 
tar  xf php-5.4.26
./configure --prefix=/usr/local/php  --with-mysql=/usr/local/mysql  --with-openssl --with-mysqli=/usr/local/mysql/bin/mysql_config  --enable-mbstring  --with-freetype-dir --with-jpeg-dir --with-png-dir  --with-zlib  --with-libxml-dir=/usr  --enable-xml --enable-sockets --enable-fpm --with-mcrypt --with-bz2 --with-config-file-path=/etc/php/php.ini --with-config-file-scan-dir=/etc/php/php.d/
make && make  install

3. PHP Config：
php的配置文件：php.ini
php的守护进程配置文件：fpm.conf

mkdir -pv /etc/php/php.d
cd /tmp/php-5.4.25
cp php.ini-production /etc/php/php.ini
cp sapi/fpm/init.d.php-fpm   /etc/rc.d/init.d/php-fpm
cd /usr/local/php/etc
mv php-fpm.conf.default php-fpm.conf
cd /etc/rc.d/init.d
chmod +x php-fpm
chkconfig --add php-fpm

vim /usr/local/php/etc/php-fpm.conf
listen = 12.11.0.102:9000
listen.allowed_clients = 12.11.0.101

4. install wordpress
unzip wordpress...
mv wordpress /var/log/php

cd /var/log/php
mv wp-config-sample.php wp-config.php

Comments

Post a Comment

Popular posts from this blog

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more

ORACLE Error

-
Image
oracle official error explanation  http://docs.oracle.com/cd/E11882_01/server.112/e17766/toc.htm 从服务器下载ALERT日志文件，传输方式需要选择"ASCII" ORA-01078: failure in processing system parameters 发生场景：新建数据库第一次启动时 SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’ 原因：oracle_sid没有配置正确 解决方案： 1. 修改oracle用户.bash_profile文件中ORACLE_SID后的内容； 2. 重新已oracle用户登录； ORA-01157: cannot identify/lock data file string - see DBWR trace file  Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file ...
Read more