Apache, PHP, MySQL

Marley · #1 16.01.2011, 12:20

Apache, PHP, MySQL

======================================
UPD. Рекомендую ставить эту связку из пакетов, а не заморачиваться с компиляцией из исходников.
======================================

======================================
Устанавливаю на Oracle Linux 5.8 (64bit)
======================================

На компьютере, с которого происходит инсталляция (а инсталляция происходит на виртуальную машину с ip адресом 192.168.1.10) в файле /etc/hosts явно задан ip адрес домена.

cat /etc/hosts

Код:

192.168.1.10     sysadm.ru

На машине, на которой инсталлирую окружение:

=======================================

# iptables -I INPUT 3 -p tcp -m tcp --dport 8080 -j ACCEPT
# iptables-save > /etc/sysconfig/iptables

=======================================

# hostname
webserv.marley.local

# vi /etc/hosts
192.168.1.10 webserv webserv.marley.local

========================================

Код:

# useradd \
-d /home/marley \
-m marley

# cd /etc/yum.repos.d

// Для 5 ветки дистрибутива Oracle Linux
# wget http://public-yum.oracle.com/public-yum-el5.repo

# yum install -y wget gcc gcc-c++ make
# yum install -y perl

Marley · #2 16.01.2011, 12:21

Apache httpd server в RedHat

# yum install -y zlib-devel openssl-devel

================================================
######## APR

# cd /tmp

# wget http://mirrors.axint.net/apache//apr/apr-1.4.6.tar.gz

# tar -xvzf apr-1.4.6.tar.gz
# cd apr-1.4.6

# ./configure && make && make install

================================================

######## APR Utils

# cd /tmp

# wget http://mirrors.axint.net/apache//apr...l-1.5.1.tar.gz

# tar -xvzf apr-util-1.5.1.tar.gz

# cd apr-util-1.5.1

# ./configure --with-apr=/usr/local/apr

# make && make install

Код:

Libraries have been installed in:
   /usr/local/apr/lib

====================================
######## PCRE

# cd /tmp

# wget ftp://ftp.csx.cam.ac.uk/pub/software...re-8.32.tar.gz

# tar -xvzf pcre-8.32.tar.gz

# cd /tmp/pcre-8.32

# ./configure --prefix=/usr/local/pcre

# make && make install

====================================
######## Apache

# mkdir -p /opt/httpd/2.4.3
# mkdir -p /u01/webProjects/sysadm.ru
# mkdir -p /u01/logs/sysadm.ru

# cd /tmp
# wget http://www.sai.msu.su/apache/httpd/httpd-2.4.3.tar.gz

# tar -xzvf httpd-2.4.3.tar.gz

# cd /tmp/httpd-2.4.3

Код:

./configure \
--enable-so \
--prefix=/opt/httpd/2.4.3 \
--with-port=8080 \
--enable-file-cache \
--enable-cache \
--enable-disk-cache \
--enable-mem-cache \
--enable-deflate \
--enable-expires \
--enable-headers \
--enable-usertrack \
--enable-ssl \
--enable-cgi \
--enable-vhost-alias \
--enable-rewrite \
--with-apr=/usr/local/apr \
--with-pcre=/usr/local/pcre

# make && make install

// Параметры configure
http://httpd.apache.org/docs/2.0/pro...configure.html

============================================

# chown -R marley /opt/httpd/2.4.3
# chown -R marley /u01/webProjects
# chown -R marley /u01/logs

============================================

# su - marley

# vi ~/.bash_profile

Код:

***
# User specific environment and startup programs

##################################################
### Apache
 export APACHE_HOME=/opt/httpd/2.4.3

PATH=${APACHE_HOME}/bin:$PATH

###################################################

***

PATH=$PATH:$HOME/bin

$ source ~/.bash_profile

========================================

$ vi /opt/httpd/2.4.3/conf/vhosts.conf

Код:

<VirtualHost *:8080>
    ServerName sysadm.ru
    ServerAlias www.sysadm.ru
    DocumentRoot /u01/webProjects/sysadm.ru
    ErrorLog /u01/logs/sysadm.ru/sysadm.ru-error.log
    CustomLog /u01/logs/sysadm.ru/sysadm.ru-access.log combined

    <Directory "/u01/webProjects/sysadm.ru">
        Options All
        AllowOverride All
        Require all granted
    </Directory>

</VirtualHost>

========================================

$ cp /opt/httpd/2.4.3/conf/httpd.conf /opt/httpd/2.4.3/conf/httpd.conf.bkp

$ vi /opt/httpd/2.4.3/conf/httpd.conf

Добавляем в конец документа строку:

Код:

###########################################################
######### VIRTUAL HOSTS #################################
###########################################################
include conf/vhosts.conf
###########################################################

========================================

$ vi /opt/httpd/2.4.3/conf/httpd.conf

Код:

#ServerName www.example.com:8080

Код:

#ServerName www.example.com:8080
ServerName webserv.marley.local

Код:

DocumentRoot "/opt/httpd/2.4.3/htdocs"

Меняем на:

Код:

# DocumentRoot "/opt/httpd/2.4.3/htdocs"
DocumentRoot "/u01/webProjects"

$ apachectl configtest
Syntax OK

$ apachectl start

===========================================

Код:

cat <<-END >> /u01/webProjects/sysadm.ru/index.html
<html>

<body>
<p>Hello World</p>
</body>

</html>
END

http://sysadm.ru:8080/

Hello World

----------------------------------------------------------

Включение server-status

$ vi /opt/httpd/2.4.3/conf/httpd.conf

Должен подгружаться модуль:

Код:

LoadModule status_module modules/mod_status.so

Добавляю в конец файла:

Код:

###########################################################
######### SERVER STATUS #################################
###########################################################
<Location /server-status>
   SetHandler server-status
   Order Deny,Allow
   Deny from all
   Allow from localhost
</Location>
###########################################################

$ apachectl restart

$ apachectl fullstatus

Если указать
Allow from 192.168.1.5

Можно будет проверить:
http://sysadm.ru:8080/server-status

Marley · #3 16.01.2011, 12:59

PHP -5.4.10

http://www.php.net/manual/en/install.unix.apache2.php

Код:

# yum install -y \
libxml2 \
libxml2-devel \
php-gd \
php-mbstring \
libpng-devel

=================================================

libmcrypt

# mkdir /opt/libmcrypt

# cd /tmp
# wget http://sourceforge.net/projects/mcry...ar.gz/download

# tar -xzvf libmcrypt-2.5.8.tar.gz
# cd libmcrypt-2.5.8

# ./configure \
--prefix=/opt/libmcrypt \
--disable-posix-threads

# make && make install

mhash

# mkdir /opt/mhash

# cd /tmp
# wget http://sourceforge.net/projects/mhas...d?source=files

# tar jxf mhash-0.9.9.9.tar.bz2
# cd mhash-0.9.9.9

# ./configure \
--prefix=/opt/mhash

# make && make install

mcrypt

# mkdir /opt/mcrypt

# cd /tmp
# wget http://sourceforge.net/projects/mcry...atest/download

# tar -xzvf mcrypt-2.6.8.tar.gz
# cd mcrypt-2.6.8

export LD_LIBRARY_PATH=/opt/libmcrypt/lib:/opt/mhash/lib
export LDFLAGS="-L/opt/mhash/lib/ -I/opt/mhash/include/"
export CFLAGS="-I/opt/mhash/include/"

# ./configure \
--prefix=/opt/mcrypt \
--with-libmcrypt-prefix=/opt/libmcrypt

# make && make install

================================================== ====
PHP

# mkdir -p /opt/php/5.4.10

# cd /tmp/
# wget http://php.net/get/php-5.4.10.tar.gz...php.net/mirror

# tar -xzvf php-5.4.10.tar.gz

# cd php-5.4.10

Код:

# ./configure \
--prefix=/opt/php/5.4.10 \
--with-apxs2=/opt/httpd/2.4.3/bin/apxs \
--with-mysql \
--with-mysqli \
--with-mcrypt=/opt/libmcrypt \
--enable-mbstring \
--enable-zip \
--with-zlib \
--with-gd

# make && make install

# chown -R marley /opt/php/

# su - marley

$ vi ~/.bash_profile

Код:

##################################################
### PHP
 export PHP_HOME=/opt/php/5.4.10

PATH=${PHP_HOME}/bin:$PATH

###################################################

$ source ~/.bash_profile

$ cp /tmp/php-5.4.10/php.ini-production /opt/php/5.4.10

$ mv /opt/php/5.4.10/php.ini-production /opt/php/5.4.10/lib/php.ini

$ cd /opt/php/5.4.10/lib/

$ vi php.ini

Разкомментирую

Код:

default_charset = "UTF-8"

Устанавливаю параметры:

Код:

upload_max_filesize = 24M
post_max_size = 24M

В файле /opt/httpd/2.4.3/conf/httpd.conf должна появиться строка

Код:

LoadModule php5_module modules/libphp5.so

$ vi /opt/httpd/2.4.3/conf/httpd.conf

Добавляем

Код:

###########################################################
### PHP ###################################################
###########################################################
<FilesMatch \.php$>
    SetHandler application/x-httpd-php
</FilesMatch>
###########################################################

$ apachectl restart

Код:

cat <<-END >> /u01/webProjects/sysadm.ru/.htaccess
AddDefaultCharset UTF-8
DirectoryIndex  index.php index.html
END

Код:

cat <<-END >> /u01/webProjects/sysadm.ru/index.php
<html>

<body>
<h1>PHP Test</h1>

	<h2>PHP Information</h2>
	<p>
		<?php phpinfo(); ?>
	</p>
</body>

</html>
END

http://sysadm.ru:8080

Marley · #4 16.01.2011, 14:40

MySQL

Installing MySQL from a Standard Source Distribution
http://dev.mysql.com/doc/refman/5.5/...tribution.html

// В Ubuntu
# apt-get install -y gcc make gmake
# apt-get install -y libncurses5-dev build-essential

// В RedHat
# yum install -y ncurses-devel

# mkdir -p /opt/mysql/5.5.29

################################################## #############
### CMAKE

# cd /tmp
# wget http://www.cmake.org/files/v2.8/cmake-2.8.10.2.tar.gz
# tar -xzvf cmake-2.8.10.2.tar.gz
# cd cmake-2.8.10.2
# ./configure && make && make install

################################################## #############

################################################## #############
### BISON

// В Ubuntu
# apt-get install -y m4

# mkdir -p /opt/bison/2.5

# cd /tmp
# wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
# tar -xzvf bison-2.5.tar.gz

# cd bison-2.5/

# ./configure --prefix=/opt/bison/2.5
# make && make check && make install

################################################## #############

################################################## #############
### MYSQL

# cd /tmp
# wget -O mysql-5.5.29.tar.gz http://dev.mysql.com/get/Downloads/M...cdn.mysql.com/

# tar -xzvf mysql-5.5.29.tar.gz
# cd /tmp/mysql-5.5.29

# export PATH=$PATH:/opt/bison/2.5/bin

# cmake . -DCMAKE_INSTALL_PREFIX=/opt/mysql/5.5.29
# make && make install

=================================================

# chown -R marley /opt/mysql/

# cd /opt/mysql/5.5.29
# cp support-files/my-small.cnf /etc/my.cnf
# chown -R marley /etc/my.cnf

# su - marley

// В Ubuntu
// Добавляю в конец файла.
$ vi ~/.bashrc

Код:

# 
. ~/.bash_profile

$ vi ~/.bash_profile

Код:

# User specific environment and startup programs

###############################################################
### BISON

export BISON_HOME=/opt/bison/2.5


###############################################################
### MySQL

export MYSQL_HOME=/opt/mysql/5.5.29

PATH=$PATH:${MYSQL_HOME}/bin:${BISON_HOME}/bin
###############################################################

$ source ~/.bash_profile

# vi /etc/my.cnf

В блок [mysqld] вставить

################################################## #############
### CHARACTER SET UTF8

character-set-server=utf8
init-connect='SET NAMES utf8;'
collation-server=utf8_general_ci
################################################## #############
### USER

user = marley
################################################## #############

В блок [mysql] вставить

################################################## #############
### CHARACTER SET UTF8

default-character-set=utf8
################################################## #############

$ cd /opt/mysql/5.5.29

$ ./scripts/mysql_install_db --user=marley

$ mysqld_safe --user=marley &

$ mysqladmin version

Код:

mysqladmin  Ver 8.42 Distrib 5.5.29, for Linux on x86_64
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version		5.5.29
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			1 min 15 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 35  Flush tables: 1  Open tables: 4  Queries per second avg: 0.013

// Подключаемся к базе данных
$ mysql -uroot -p

Пароль отсутствует, нажать [Enter]

// Неоходимо, чтобы не было кодировок latin
mysql> show variables like 'charac%';

Код:

+--------------------------+-----------------------------------+
| Variable_name            | Value                             |
+--------------------------+-----------------------------------+
| character_set_client     | utf8                              |
| character_set_connection | utf8                              |
| character_set_database   | utf8                              |
| character_set_filesystem | binary                            |
| character_set_results    | utf8                              |
| character_set_server     | utf8                              |
| character_set_system     | utf8                              |
| character_sets_dir       | /opt/mysql/5.5.29/share/charsets/ |
+--------------------------+-----------------------------------+
8 rows in set (0.00 sec)

DELETE FROM mysql.user WHERE User = '';
FLUSH PRIVILEGES;

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
SET PASSWORD FOR 'root'@'host_name' = PASSWORD('new_password');

mysql> SELECT Host, User FROM mysql.user;

Код:

+----------------------+------+
| Host                 | User |
+----------------------+------+
| 127.0.0.1            | root |
| ::1                  | root |
| localhost            | root |
| webserv.marley.local | root |
+----------------------+------+
4 rows in set (0.00 sec)

=================

Автозапуск сервера:

# cd /opt/mysql/5.5.29

# cp support-files/mysql.server /etc/init.d/mysql
# chmod 755 /etc/init.d/mysql
# chkconfig --add mysql
# chkconfig --level 35 mysql on

Дополнительно:
http://laffers.net/howtos/howto-install-mysql/

Marley · #5 16.01.2011, 15:57

PhpMyAdmin

# cd /tmp
# wget http://sourceforge.net/projects/phpm...nguages.tar.gz

# tar -xzvf phpMyAdmin-3.5.5-all-languages.tar.gz
# mv phpMyAdmin-3.5.5-all-languages phpmyadmin
# mv phpmyadmin /u01/webProjects/sysadm.ru

# chown -R marley /u01/webProjects/sysadm.ru

http://sysadm.ru:8080/phpmyadmin/

Marley · #6 16.01.2011, 15:58

Perl

rm -rf /usr/bin/perl

cd /tmp/
wget http://www.cpan.org/src/5.0/perl-5.14.1.tar.gz
tar xzf perl-5.14.1.tar.gz

mv perl-5.14.1/ /usr/local/src/perl-5.14.1
cd /usr/local/src/perl-5.14.1

./configure.gnu --prefix=/opt/perl-5.14.1
gmake && gmake install

ln -s /opt/perl-5.14.1 /opt/perl

// Добавить перед export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE HISTCONTROL
vi /etc/profile

Код:

# Perl

export PERL_HOME=/opt/perl
pathmunge ${PERL_HOME}/bin

Применяем новые параметры
. /etc/profile

perl

Marley · #7 02.07.2011, 17:30

Python 3.2

https://odba.ru/showpost.php?p=7571&postcount=1

Marley · #8 08.01.2013, 00:31

Ошибки:

================================================== ====

Sorry, I cannot run apxs. Possible reasons follow:

1. Perl is not installed
2. apxs was not found. Try to pass the path using --with-apxs2=/path/to/apxs
3. Apache was not built using --enable-so (the apxs usage page is displayed)

# yum install -y perl
# vi /opt/httpd/2.4.3/bin/apxs

перваой строкой указал
#!/usr/bin/perl

================================================== ====

Опции темы
Версия для печати Отправить по электронной почте
Опции просмотра
Линейный вид Комбинированный вид Древовидный вид