操作系統(tǒng)：CentOS

安裝包：httpd(首選yum)， php(包括php以及php-pgsql,php-mbstring，首選yum)， phppgadmin ， postgresql 。

一、配置php項(xiàng)目部署環(huán)境

1.關(guān)閉Centos默認(rèn)的selinux：

vi?/etc/selinux/config

SELINUX=disabled

重啟計(jì)算機(jī)：

/sbin/init?6

2.安裝apache(手動(dòng)安裝文件，如：httpd-2.4.4.tar.gz或yum安裝均可)

[root@localhost?conf]#yum?install?httpd

默認(rèn)會(huì)安裝到/etc/httd/下面

[root@localhost?conf]#?which?httpd

/usr/sbin/httpd

安裝完畢后，可以先啟動(dòng)服務(wù)service httpd start，

然后到瀏覽器輸入地址：http://host:80，正常會(huì)出現(xiàn)apache test page的網(wǎng)頁(yè)。

3.安裝php(手動(dòng)或者yum安裝)

[root@localhost?conf]#yum?install?php

[root@localhost?conf]#?which?php

/usr/bin/php

[root@localhost?conf]#yum?install?php-pgsql

[root@localhost?conf]#yum?install?php-mbstring

二、安裝并配置postgresql數(shù)據(jù)庫(kù)

1.正常安裝postgresql，可以通過(guò)安裝包安裝或者源碼編譯安裝。

2.修改pg_hba.conf配置文件，使得數(shù)據(jù)庫(kù)可以允許外部訪問(wèn)。

具體可以配置為：

#?TYPE??DATABASE????????USER????????????ADDRESS?????????????????METHOD

#?"local"?is?for?Unix?domain?socket?connections?only

local???all?????????????all?????????????????????????????????????md5

#?IPv4?local?connections:

host????all?????????????all?????????????127.0.0.1/32????????????md5

host????all?????????????all?????????????0.0.0.0/0???????????????md5

#?IPv6?local?connections:

host????all?????????????all?????????????::1/128?????????????????trust

host????all?????????????all?????????????0.0.0.0/0???????????????trust

三、部署并配置phPgAdmin

1.下載：phpPgAdmin-5.1.tar.gz ，并解壓到到/var/www/ phpPgAdmin-5.1目錄下；

2.配置所管理的數(shù)據(jù)庫(kù)的參數(shù)：

[root@web-dev-machine?phppgadmin]#?vi?/var/www/phppgadmin/conf/config.inc.php

其中必須修改的是：

$conf['extra_login_security']?=?false;

其他的可以根據(jù)所管理的PostgreSQL數(shù)據(jù)庫(kù)的安裝情況類(lèi)配置，如：

//?Display?name?for?the?server?on?the?login?screen

$conf['servers'][0]['desc']?=?'PostgreSQL';

//?Hostname?or?IP?address?for?server.??Use?''?for?UNIX?domain?socket.

//?use?'localhost'?for?TCP/IP?connection?on?this?computer

$conf['servers'][0]['host']?=?'192.168.100.101';

//?Database?port?on?server?(5432?is?the?PostgreSQL?default)

$conf['servers'][0]['port']?=?5432;

//?Database?SSL?mode

//?Possible?options:?disable,?allow,?prefer,?require

//?To?require?SSL?on?older?servers?use?option:?legacy

//?To?ignore?the?SSL?mode,?use?option:?unspecified

$conf['servers'][0]['sslmode']?=?'allow';

//?Change?the?default?database?only?if?you?cannot?connect?to?template1.

//?For?a?PostgreSQL?8.1+?server,?you?can?set?this?to?'postgres'.

$conf['servers'][0]['defaultdb']?=?'template1';

//?Specify?the?path?to?the?database?dump?utilities?for?this?server.

//?You?can?set?these?to?''?if?no?dumper?is?available.

$conf['servers'][0]['pg_dump_path']?=?'/opt/pg932/bin/pg_dump';

$conf['servers'][0]['pg_dumpall_path']?=?'/opt/pg932/bin/pg_dumpall';

注意：以上pg_dump_path和pg_dumpall_path在phpPgAdmin中執(zhí)行導(dǎo)出數(shù)據(jù)庫(kù)時(shí)才調(diào)用，所以一開(kāi)始配置錯(cuò)誤可能不會(huì)看到報(bào)錯(cuò)，執(zhí)行導(dǎo)出時(shí)就會(huì)報(bào)錯(cuò)。

四、配置php 項(xiàng)目源文件目錄以及監(jiān)聽(tīng)端口

vi?/etc/httpd/conf/httpd.conf

首先找到端口(默認(rèn)為80,根據(jù)實(shí)際情況，可改可不改)

#?Listen:?Allows?you?to?bind?Apache?to?specific?IP?addresses?and/or

#?ports,?in?addition?to?the?default.?See?also?the?

#?directive.

#

#?Change?this?to?Listen?on?specific?IP?addresses?as?shown?below?to

#?prevent?Apache?from?glomming?onto?all?bound?IP?addresses?(0.0.0.0)

#

#Listen?12.34.56.78:80

Listen?80

然后是php的文件目錄(必須添加自己的項(xiàng)目的目錄,可以直接添加到配置文件最后邊)

#?"/var/www/cgi-bin"?should?be?changed?to?whatever?your?ScriptAliased

#?CGI?directory?exists,?if?you?have?that?configured.

#

AllowOverride?None

Options?None

Order?allow,deny

Allow?from?all

#liuyy

#phpPgAdmin

Alias?/phppgadmin?"/var/www/phpPgAdmin"

Options?Indexes?Multiviews

AllowOverride?None

Order?allow,deny

Allow?from?all

注意：/phppgadmin才是在瀏覽器中要輸入的地址，而不是文件名(phpPgAdmin)本身。

五、以上配置完畢后，在terminal中重啟apache服務(wù)：service httpd restart

到瀏覽器中輸入地址：http://ip:port/phppgadmin?? (默認(rèn)端口80 可以省略)

正常會(huì)出現(xiàn)phppgadmin的管理界面。

總結(jié)

以上是生活随笔為你收集整理的linux安装php pgsql,Linux下apache php+phppgadmin+postgresql安装配置的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。