CF에 phpMyAdmin 올리기

✔️ devpack, phpmyadmin-cf에서 테스트하였습니다.

1 개요[ | ]

CF에 phpmyadmin 올리기

별도의 MySQL 클라이언트 없이 간단히 올려서 웹상에 사용가능
VCAP_SERVICES 중 MySQL이 있으면 그 정보를 활용하도록 되어 있음

→ cf cs로 등록한 서비스는 알아서 인식됨 (tags에 mysql이 있음)

→ cf cups로 등록한 서비스는 서비스 이름에 mysql이 포함되어야 인식됨^[1]

2 사전 작업[ | ]

CF 및 DB 서비스 상품 신청
cf cli 설치
cf login

3 확인[ | ]

root@test1:~# cf services
Getting services in org cloudpack / space testuser03 as testuser03...
OK

name           service      plan   bound apps   last operation
testuser03db   devpack-db   1gb                 create succeeded

→ 1GB DB서비스가 있고, 바인딩된 앱은 없음

4 phpmyadmin 받기, 압축해제[ | ]

root@test1:~# wget https://github.com/cloudfoundry-community/phpmyadmin-cf/archive/cf-ready.zip
... (생략)
Length: 16224956 (15M) [application/zip]
Saving to: ‘cf-ready.zip’

100%[=================================================>] 16,224,956  3.04MB/s   in 6.3s   

2016-06-21 10:56:51 (2.45 MB/s) - ‘cf-ready.zip’ saved [16224956/16224956]

root@test1:~# unzip cf-ready.zip 
... (생략)
  inflating: phpmyadmin-cf-cf-ready/version_check.php  
  inflating: phpmyadmin-cf-cf-ready/view_create.php  
  inflating: phpmyadmin-cf-cf-ready/view_operations.php  
  inflating: phpmyadmin-cf-cf-ready/webapp.php

5 manifest.yml 수정[ | ]

manifest.yml에 사용할 서브도메인, 연결할 서비스명을 추가 기재하자.

root@test1:~# cd phpmyadmin-cf-cf-ready/
root@test1:~/phpmyadmin-cf-cf-ready# vi manifest.yml

---
name: phpmyadmin-cfready
memory: 1G
instances: 1
services:
- testuser03db

→ testuser03db 서비스가 앱에 연결됨

→ 그렇다고 phpMyAdmin 로그인 절차가 생략되는 것은 아님

→ VCAP_SERVICES에서 MySQL의 주소정보(hostname, port)만 활용함

6 cf push[ | ]

root@test1:~/phpmyadmin-cf-cf-ready# cf push
Using manifest file /root/phpmyadmin-cf-cf-ready/manifest.yml

Updating app phpmyadmin-cfready in org cloudpack / space testuser03 as testuser03...
OK

Using route phpmyadmin-jmnote.devpack.co.kr
Uploading phpmyadmin-cfready...
Uploading app files from: /root/phpmyadmin-cf-cf-ready
Uploading 12.9M, 3096 files
Done uploading               
OK
Binding service testuser03db to app phpmyadmin-cfready in org cloudpack / space testuser03 as testuser03...
OK
... (생략)
requested state: started
instances: 1/1
usage: 1G x 1 instances
urls: phpmyadmin-jmnote.devpack.co.kr
last uploaded: Thu Jul 21 07:21:42 UTC 2016
stack: unknown
buildpack: php 4.3.7

     state     since                    cpu    memory        disk           details
#0   running   2016-07-21 04:22:30 PM   0.3%   76.9M of 1G   193.9M of 1G

7 웹 로그인 확인[ | ]

DB의 username, password 확인

root@test1:~/phpmyadmin-cf-cf-ready# cf env phpmyadmin-cfready | egrep 'username|password"' | sort -r
     "username": "mYLcba39fcyTM9Nn"
     "password": "0gAWTjGdllb62lMY",

http://phpmyadmin-jmnote.devpack.co.kr 접속하여 로그인

8 같이 보기[ | ]

9 참고[ | ]

↑ service provider가 cleardb 또는 p-mysql이거나, tags에 mysql이 있거나, name에 mysql이 포함된 경우 MySQL로 인식함
https://github.com/dmikusa-pivotal/cf-ex-phpmyadmin/blob/master/htdocs/config.inc.php 참고

[1] service provider가 cleardb 또는 p-mysql이거나, tags에 mysql이 있거나, name에 mysql이 포함된 경우 MySQL로 인식함
https://github.com/dmikusa-pivotal/cf-ex-phpmyadmin/blob/master/htdocs/config.inc.php 참고

[1]