nginx和PHP连接,Nginx和php连接DM8

1.准备工作

配置本地yum源

vi /etc/yum.repos.d/cd.repo

[cd]

name=cd

baseurl=file:///mnt

gpgcheck=0

enable=1

https://www.cndba.cn/panxiang/article/4203

安装编译器

yum install gcc

yum install gcc-c++

安装依赖包

yum install libxml2-devel

2.编译安装 php7.2.31

tar -zxvf php-7.2.31.tar.gz

cd php-7.2.31

./configure —prefix=/usr/local/php —enable-fpm

make

make install

3.设置环境变量

vi /etc/profile

export LD_LIBRARY_PATH=/home/dmdba/dmdbms/bin

export PATH=$PATH:/home/dmdba/dmdbms/bin:/usr/local/php/binhttps://www.cndba.cn/panxiang/article/4203

4. 配置 php.ini

查看加载的配置文件：

php -i | grep php.ini

从源码包复制配置文件模板

cp php.ini-development /usr/local/php/lib/php.ini

vi /usr/local/php/lib/php.ini

extension_dir=”/usr/local/php/ext”

extension=php72_pdo_dm.so

extension=libphp72_dm.so

5.拷贝驱动

mkdir /usr/local/php/ext

cd /home/dmdba/dmdbms/drivers/php_pdo/

cp php72_pdo_dm.so /usr/local/php/ext/

cp libphp72_dm.so /usr/local/php/ext/

6.查看驱动是否加载成功

https://www.cndba.cn/panxiang/article/4203

php -m

7.安装nginx

https://nginx.org/packages/rhel/6/x86_64/RPMS/

查看openssl版本

rpm -qa |grep openssl

nginx依赖openssl-1.0.1及以上版本，低于1.0.1需要先升级

升级openssl

rpm -U openssl-1.0.1e-57.el6.x86_64.rpm

安装

rpm -ivh nginx-1.16.1-1.el6.ngx.x86_64.rpm

8.配置php-fpm.conf和www.conf

cd /usr/local/php/etc/

cp php-fpm.conf.default php-fpm.conf

vim php-fpm.conf

pid = run/php-fpm.pid

cd /usr/local/php/etc/php-fpm.d

cp www.conf.default www.conf

vi www.conf

验证php-fpm配置是否正确

/usr/local/php/sbin/php-fpm -t

https://www.cndba.cn/panxiang/article/4203https://www.cndba.cn/panxiang/article/4203

启动 php-fpm

/usr/local/php/sbin/php-fpm

php-fpm使用9000端口

设置php-fpm开机自启动

vi /etc/rc.local

/usr/local/php/sbin/php-fpm

9.配置nginx.confhttps://www.cndba.cn/panxiang/article/4203

vi /etc/nginx/nginx.conf

server {

listen 80 default_server;

listen [::]:80 default_server;

server_name 192.168.100.143;

root /var/www/;

include /etc/nginx/default.d/*.conf;

location / {

index index.php index.html index.htm;

}

error_page 404 /404.html;

location = /40x.html {

}

error_page 500 502 503 504 /50x.html;

location = /50x.html {

}

location ~ /.php$ {

fastcgi_pass 127.0.0.1:9000;

fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

include fastcgi_params;

}

}

启动Nginx服务

mkdir /var/www

cp /usr/share/nginx/html/* /var/www/

service nginx start

10.测试php

phpinfo();

?>

注意：

命令行加载的php配置文件与web服务器加载的php配置文件可能不一致。

php -i | grep php.ini

https://www.cndba.cn/panxiang/article/4203

11.测试php连接数据库

$link = dm_connect("192.168.100.143", "SYSDBA", "dameng123") or die("Could not connect : " . dm_error());

print "Connected successfully";

$query = " select * from sys.dba_tables;";

$result = dm_exec($link, $query) or die("Query failed : " . dm_error());

print "

while ($line = dm_fetch_array($result)) {

print "/t

/n";

foreach ($line as $col_value) {

print "/t/t

$col_value/n";

}

print "/t

/n";

}

print "

/n";

dm_close($link);

?>

版权声明：本文为博主原创文章，未经博主允许不得转载。

php