さて、MySQLでphpMyAdminを使っていたので、できればPosgreSQLもphpPgAdminを使いたいなと思いインストール。
wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-4.1.3.tar.gz?download
以下のページを参考にしたんですが、
・floatingdays: CentOSにphpPgAdminをインストール
もっと新しいバージョン(確認した時は5.04)あったんですね。
・phpPgAdmin – download
とりあえずブラウザでアクセスできるフォルダに展開して、アクセスすると、
データベースをサポートするように PHP のコンパイル・インストールがされていません。configure の –with-pgsql オプションを用いて PHP を再コンパイルする必要があります。
ってでました。
で、PHPはyumでインストールしてるし、どうしたらいいんだ?って悩んだんですが、
たしか、ここらへんを参考にして、
・「phpPgAdmin」の導入
php-pgsql
を入れるといけるんじゃ?とおもい、実行!
yum install php-pgsql
したら、失敗。
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
base | 1.1 kB 00:00
extras | 2.1 kB 00:00
rpmforge | 1.1 kB 00:00
updates | 1.9 kB 00:00
updates/primary_db 47% [======= ] 0.0 B/s | 56 kB --:-- ETA updates/primary_db | 118 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-pgsql.i386 0:5.1.6-32.el5 set to be updated
--> Processing Dependency: php-common = 5.1.6-32.el5 for package: php-pgsql
--> Finished Dependency Resolution
php-pgsql-5.1.6-32.el5.i386 from base has depsolving problems
--> Missing Dependency: php-common = 5.1.6-32.el5 is needed by package php-pgsql-5.1.6-32.el5.i386 (base)
Error: Missing Dependency: php-common = 5.1.6-32.el5 is needed by package php-pgsql-5.1.6-32.el5.i386 (base)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.
さて、どうしたものか。。。
Processing Dependency: php-common = 5.1.6-32.el5 for package: php-pgsql
とあるから、
php-common = 5.1.6-32.el5
が必要何だろうなと思い、
yum install php-common
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
Setting up Install Process
Package matching php-common-5.1.6-32.el5.i386 already installed. Checking for update.
Nothing to do
あれ?インストールされてる?何もする必要がない?
ん~、よくわからん。バージョンがいけないのか。
別のリポジトリ使えばいいのかな?
で、何も考えずにやってしまったのがコレ。
すべてがココから始まった気が。。。
yum --enablerepo=utterramblings update php-common
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
utterramblings | 951 B 00:00
Setting up Update Process
Resolving Dependencies
--> Running transaction check
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php-gd
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php-ldap
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php-cli
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php-mbstring
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php-pdo
--> Processing Dependency: php-common = 5.2.16-jason.1 for package: php-mysql
---> Package php-common.i386 0:5.2.17-jason.2 set to be updated
--> Running transaction check
--> Processing Dependency: php = 5.2.16-jason.1 for package: php-devel
---> Package php.i386 0:5.2.17-jason.2 set to be updated
---> Package php-cli.i386 0:5.2.17-jason.2 set to be updated
---> Package php-gd.i386 0:5.2.17-jason.2 set to be updated
---> Package php-ldap.i386 0:5.2.17-jason.2 set to be updated
---> Package php-mbstring.i386 0:5.2.17-jason.2 set to be updated
---> Package php-mysql.i386 0:5.2.17-jason.2 set to be updated
---> Package php-pdo.i386 0:5.2.17-jason.2 set to be updated
--> Running transaction check
---> Package php-devel.i386 0:5.2.17-jason.2 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
php-common i386 5.2.17-jason.2 utterramblings 513 k
Updating for dependencies:
php i386 5.2.17-jason.2 utterramblings 3.6 M
php-cli i386 5.2.17-jason.2 utterramblings 2.6 M
php-devel i386 5.2.17-jason.2 utterramblings 558 k
php-gd i386 5.2.17-jason.2 utterramblings 331 k
php-ldap i386 5.2.17-jason.2 utterramblings 59 k
php-mbstring i386 5.2.17-jason.2 utterramblings 1.3 M
php-mysql i386 5.2.17-jason.2 utterramblings 267 k
php-pdo i386 5.2.17-jason.2 utterramblings 164 k
Transaction Summary
================================================================================
Install 0 Package(s)
Upgrade 9 Package(s)
Total download size: 9.4 M
Is this ok [y/N]: y
Downloading Packages:
(1/9): php-ldap-5.2.17
(2/9): php-pdo-5.2.17-
(3/9): php-mysql-5.2.1
(4/9): php-gd-5.2.17-j
(5/9): php-common-5.2.
(6/9): php-devel-5.2.1
(7/9): php-mbstring-5.
(8/9): php-cli-5.2.17-
(9/9): php-5.2.17-jaso
--------------------------------------------------------------------------------
Total 124 kB/s | 9.4 MB 01:17
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
省略
Updated:
php-common.i386 0:5.2.17-jason.2
Dependency Updated:
php.i386 0:5.2.17-jason.2 php-cli.i386 0:5.2.17-jason.2
php-devel.i386 0:5.2.17-jason.2 php-gd.i386 0:5.2.17-jason.2
php-ldap.i386 0:5.2.17-jason.2 php-mbstring.i386 0:5.2.17-jason.2
php-mysql.i386 0:5.2.17-jason.2 php-pdo.i386 0:5.2.17-jason.2
Complete!
あっ、なんかインストールされた。
じゃぁ、php-pgsqlもいけるんじゃない?とおもい、
yum install php-pgsql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-pgsql.i386 0:5.1.6-32.el5 set to be updated
--> Processing Dependency: php-common = 5.1.6-32.el5 for package: php-pgsql
--> Finished Dependency Resolution
php-pgsql-5.1.6-32.el5.i386 from base has depsolving problems
--> Missing Dependency: php-common = 5.1.6-32.el5 is needed by package php-pgsql-5.1.6-32.el5.i386 (base)
Error: Missing Dependency: php-common = 5.1.6-32.el5 is needed by package php-pgsql-5.1.6-32.el5.i386 (base)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.
ありゃ、ダメか。同じリポジトリでやるとどうかな?
yum install php-pgsql--enablerepo=utterramblings update php-pgsql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
Setting up Update Process
Package(s) php-pgsql available, but not installed.
No Packages marked for Update
あるけどインストールされてない?
package-cleanup –problems
ってのがあるみたいなので実行。
-bash: package-cleanup: command not found
あら。
どうやら、 yum-utils が必要みたいなので、
yum -y install yum-utils
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package yum-utils.noarch 0:1.1.16-21.el5.centos set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
yum-utils noarch 1.1.16-21.el5.centos base 74 k
Transaction Summary
================================================================================
Install 1 Package(s)
Upgrade 0 Package(s)
Total download size: 74 k
Downloading Packages:
yum-utils-1.1.16-21.el5.c 76% [=========== ] 0.0 B/s | 56 kB --:-- ETA yum-utils-1.1.16-21.el5.centos.noarch.rpm | 74 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : 省略
Installed:
yum-utils.noarch 0:1.1.16-21.el5.centos
Complete!
で、
package-cleanup --problems
Setting up yum
Reading local RPM database
Processing all local requires
No problems found
およっ、問題なし?
じゃぁ、もう一回。
yum install php-pgsql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-pgsql.i386 0:5.1.6-32.el5 set to be updated
--> Processing Dependency: php-common = 5.1.6-32.el5 for package: php-pgsql
--> Finished Dependency Resolution
php-pgsql-5.1.6-32.el5.i386 from base has depsolving problems
--> Missing Dependency: php-common = 5.1.6-32.el5 is needed by package php-pgsql-5.1.6-32.el5.i386 (base)
Error: Missing Dependency: php-common = 5.1.6-32.el5 is needed by package php-pgsql-5.1.6-32.el5.i386 (base)
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
ん~、何がダメなんじゃい?
因みに、今のphp関連のパッケージは、
rpm -qa | grep php
php-mbstring-5.2.17-jason.2
php-pear-1.4.9-6.el5
php-pdo-5.2.17-jason.2
php-cli-5.2.17-jason.2
php-mysql-5.2.17-jason.2
php-5.2.17-jason.2
php-ldap-5.2.17-jason.2
php-common-5.2.17-jason.2
php-devel-5.2.17-jason.2
php-gd-5.2.17-jason.2
じゃぁ、別のリポジトリで。
yum -y --enablerepo=remi install php-pgsql
Loaded plugins: fastestmirror
Error getting repository data for remi, repository not found
リポジトリ使う設定が必要だったね。
○remi レポジトリを追加 – KENCOM.BIZ
rpm -import http://rpms.famillecollet.com/RPM-GPG-KEY-remi
cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/remi-enterprise.repo
--2012-03-22 17:34:52-- http://rpms.famillecollet.com/remi-enterprise.repo
rpms.famillecollet.com をDNSに問いあわせています... 88.191.74.232
rpms.famillecollet.com|88.191.74.232|:80 に接続しています... 接続しました。
HTTP による接続要求を送信しました、応答を待っています... 200 OK
長さ: 645 [text/plain]
`remi-enterprise.repo' に保存中
100%[=======================================================================>] 645 --.-K/s 時間 0s
2012-03-22 17:34:53 (14.2 MB/s) - `remi-enterprise.repo' へ保存完了 [645/645]
それじゃ、あらためて
yum --enablerepo=utterramblings update php-pgsql
yum -y --enablerepo=remi install php-pgsql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* extras: ftp.iij.ad.jp
* remi: rpms.famillecollet.com
* rpmforge: ftp-stud.fht-esslingen.de
* updates: ftp.iij.ad.jp
remi | 2.5 kB 00:00
remi/primary_db | 274 kB 00:02
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-pgsql.i386 0:5.3.10-2.el5.remi set to be updated
--> Processing Dependency: php-pdo = 5.3.10-2.el5.remi for package: php-pgsql
--> Running transaction check
---> Package php-pdo.i386 0:5.3.10-2.el5.remi set to be updated
--> Processing Dependency: php-common = 5.3.10-2.el5.remi for package: php-pdo
--> Running transaction check
--> Processing Dependency: php-common = 5.2.17-jason.2 for package: php-mbstring
--> Processing Dependency: php-common = 5.2.17-jason.2 for package: php-gd
--> Processing Dependency: php-common = 5.2.17-jason.2 for package: php-mysql
--> Processing Dependency: php-common = 5.2.17-jason.2 for package: php
--> Processing Dependency: php-common = 5.2.17-jason.2 for package: php-ldap
--> Processing Dependency: php-common = 5.2.17-jason.2 for package: php-cli
---> Package php-common.i386 0:5.3.10-2.el5.remi set to be updated
--> Running transaction check
--> Processing Dependency: php = 5.2.17-jason.2 for package: php-devel
---> Package php.i386 0:5.3.10-2.el5.remi set to be updated
---> Package php-cli.i386 0:5.3.10-2.el5.remi set to be updated
--> Processing Dependency: libedit.so.0 for package: php-cli
---> Package php-gd.i386 0:5.3.10-2.el5.remi set to be updated
--> Processing Dependency: libt1.so.5 for package: php-gd
---> Package php-ldap.i386 0:5.3.10-2.el5.remi set to be updated
---> Package php-mbstring.i386 0:5.3.10-2.el5.remi set to be updated
---> Package php-mysql.i386 0:5.3.10-2.el5.remi set to be updated
--> Processing Dependency: libmysqlclient.so.18 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16) for package: php-mysql
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18) for package: php-mysql
--> Running transaction check
---> Package libedit.i386 0:20090923-3.0_1.el5.rf set to be updated
---> Package mysql-libs.i386 0:5.5.21-1.el5.remi set to be updated
--> Processing Dependency: mysql = 5.5.21-1.el5.remi for package: mysql-libs
---> Package php-devel.i386 0:5.3.10-2.el5.remi set to be updated
---> Package t1lib.i386 0:5.1.2-1.el5.rf set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.16 for package: mysql-server
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.16 for package: mysql-server
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql-server
--> Processing Dependency: mysql = 5.1.52-jason.1 for package: mysql-server
---> Package mysql.i386 0:5.5.21-1.el5.remi set to be updated
--> Running transaction check
---> Package mysql-server.i386 0:5.5.21-1.el5.remi set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================
Package Arch Version Repository Size
=================================================================================================================
Installing:
php-pgsql i386 5.3.10-2.el5.remi remi 130 k
Installing for dependencies:
libedit i386 20090923-3.0_1.el5.rf rpmforge 262 k
mysql-libs i386 5.5.21-1.el5.remi remi 1.1 M
t1lib i386 5.1.2-1.el5.rf rpmforge 362 k
Updating for dependencies:
mysql i386 5.5.21-1.el5.remi remi 7.5 M
mysql-server i386 5.5.21-1.el5.remi remi 13 M
php i386 5.3.10-2.el5.remi remi 2.7 M
php-cli i386 5.3.10-2.el5.remi remi 2.7 M
php-common i386 5.3.10-2.el5.remi remi 995 k
php-devel i386 5.3.10-2.el5.remi remi 2.6 M
php-gd i386 5.3.10-2.el5.remi remi 207 k
php-ldap i386 5.3.10-2.el5.remi remi 54 k
php-mbstring i386 5.3.10-2.el5.remi remi 2.3 M
php-mysql i386 5.3.10-2.el5.remi remi 160 k
php-pdo i386 5.3.10-2.el5.remi remi 116 k
Transaction Summary
=================================================================================================================
Install 4 Package(s)
Upgrade 11 Package(s)
Total download size: 34 M
Downloading Packages:
(1/15): php-ldap-5.3.10-2.el5.remi.i386.rpm | 54 kB 00:00
(2/15): php-pdo-5.3.10-2.el5.remi.i386.rpm | 116 kB 00:02
(3/15): php-pgsql-5.3.10-2.el5.remi.i386.rpm | 130 kB 00:01
(4/15): php-mysql-5.3.10-2.el5.remi.i386.rpm | 160 kB 00:02
(5/15): php-gd-5.3.10-2.el5.remi.i386.rpm | 207 kB 00:01
(6/15): libedit-20090923-3.0_1.el5.rf.i386.rpm | 262 kB 00:02
(7/15): t1lib-5.1.2-1.el5.rf.i386.rpm | 362 kB 00:03
(8/15): php-common-5.3.10-2.el5.remi.i386.rpm | 995 kB 00:06
(9/15): mysql-libs-5.5.21-1.el5.remi.i386.rpm | 1.1 MB 00:06
(10/15): php-mbstring-5.3.10-2.el5.remi.i386.rpm | 2.3 MB 00:11
(11/15): php-devel-5.3.10-2.el5.remi.i386.rpm | 2.6 MB 00:21
(12/15): php-cli-5.3.10-2.el5.remi.i386.rpm | 2.7 MB 00:16
(13/15): php-5.3.10-2.el5.remi.i386.rpm | 2.7 MB 00:13
(14/15): mysql-5.5.21-1.el5.remi.i386.rpm | 7.5 MB 00:54
(15/15): mysql-server-5.5.21-1.el5.remi.i386.rpm | 13 MB 01:32
-----------------------------------------------------------------------------------------------------------------
Total 140 kB/s | 34 MB 04:08
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
WARNING : These php-* RPM are not official Fedora/Redhat build and
overrides the official ones. Don't file bugs on Fedora Project nor Redhat.
Use dedicated forums http://forums.famillecollet.com/
Updating : php-common 1/26
warning: /etc/php.ini created as /etc/php.ini.rpmnew
Updating : php-pdo 2/26
Installing : libedit 3/26
Updating : php-cli 4/26
Updating : php 5/26
Installing : t1lib 6/26
Updating : php-gd 7/26
Updating : php-devel 8/26
Installing : php-pgsql 9/26
Updating : php-ldap 10/26
Updating : php-mbstring 11/26
WARNING : This MySQL RPM is not an official Fedora/Redhat build and it
overrides the official one. Don't file bugs on Fedora Project nor Redhat.
Use dedicated forums http://forums.famillecollet.com/
Installing : mysql-libs 12/26
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Updating : mysql 13/26
Updating : mysql-server 14/26
Updating : php-mysql 15/26
Cleanup : php-gd 16/26
Cleanup : php 17/26
Cleanup : mysql 18/26
Cleanup : php-cli 19/26
Cleanup : php-common 20/26
Cleanup : php-pdo 21/26
Cleanup : php-ldap 22/26
Cleanup : mysql-server 23/26
Cleanup : php-mysql 24/26
Cleanup : php-mbstring 25/26
Cleanup : php-devel 26/26
Installed:
php-pgsql.i386 0:5.3.10-2.el5.remi
Dependency Installed:
libedit.i386 0:20090923-3.0_1.el5.rf mysql-libs.i386 0:5.5.21-1.el5.remi t1lib.i386 0:5.1.2-1.el5.rf
Dependency Updated:
mysql.i386 0:5.5.21-1.el5.remi mysql-server.i386 0:5.5.21-1.el5.remi php.i386 0:5.3.10-2.el5.remi
php-cli.i386 0:5.3.10-2.el5.remi php-common.i386 0:5.3.10-2.el5.remi php-devel.i386 0:5.3.10-2.el5.remi
php-gd.i386 0:5.3.10-2.el5.remi php-ldap.i386 0:5.3.10-2.el5.remi php-mbstring.i386 0:5.3.10-2.el5.remi
php-mysql.i386 0:5.3.10-2.el5.remi php-pdo.i386 0:5.3.10-2.el5.remi
Complete!
うひょ~、なんか出来ちゃったみたい。
したら、MySQLが起動しなくなった・・・。