replication

MySQL, MariaDB 2018. 6. 26. 10:06

1. A의 모든 DB를 B로 복제



A : 

mysqldump -u root -p --all-databases > all.sql


B : 


mysql -u root -p < all.sql




2. 마스터와 슬레이브 설정



A. 마스터 설정


설정파일  : /etc/my.cnf.d/server.cnf


서버아이디는 1로 설정


로그파일은 mysql-bin.000001 과 같은 형태로 생성됨




[mysqld]


server_id = 1


log-bin=mysql-bin

expire_logs_days=7





replication 사용자 등록


마스터 호스트 : 192.168.0.1

사용자 : repl

비밀번호 : 12345



MariaDB [mysql]> grant select, reload, lock tables, replication slave, replication client on *.* to 'repl@'192.168.0.1' identified by '12345';ant select, reload, lock tables, replication slave, replication client on *.* to 'id'@'slave ip address' identified by 'password';

MariaDB [mysql]> flush privileges;







B. 슬레이브 설정



설정파일 : /etc/my.cnf.d/server.cnf


서버아이디 : 2 로 설정


로그파일은  mysql-relay-bin.000001 과 같은 형식으로 생성됨


[mysqld]



server_id = 2

relay_log = mysql-relay-bin







3. replication


마스터 정보 확인


A : 


MariaDB [mysql]> show master status \G;

*************************** 1. row ***************************

            File: mysql-bin.000001

        Position: 104060378

    Binlog_Do_DB: 

Binlog_Ignore_DB: 

1 row in set (0.00 sec)


ERROR: No query specified






마스터의 로그파일 : mysql-bin.000001

로그 포지션 : 104060378




B : 설정



MariaDB [mysql]> stop slave;


MariaDB [mysql]> change master to 

master_host = '192.168.0.1',

master_user = 'repl',

master_password = '12345',

master_log_file = 'mysql-bin.000001',

master_log_pos = 104060378

;


MariaDB [mysql]> start slave;





슬레이브 상태 확인


MariaDB [mysql]> show slave status \G;

*************************** 1. row ***************************

               Slave_IO_State: Waiting for master to send event

                  Master_Host: 192.168.0.1

                  Master_User: repl

                  Master_Port: 3306

                Connect_Retry: 60

              Master_Log_File: mysql-bin.000001

          Read_Master_Log_Pos: 662570599

               Relay_Log_File: mysql-relay-bin.000001

                Relay_Log_Pos: 42800785

        Relay_Master_Log_File: mysql-bin.000001

             Slave_IO_Running: Yes

            Slave_SQL_Running: Yes

              Replicate_Do_DB: 

          Replicate_Ignore_DB: 

           Replicate_Do_Table: 

       Replicate_Ignore_Table: 

      Replicate_Wild_Do_Table: 

  Replicate_Wild_Ignore_Table: 

                   Last_Errno: 0

                   Last_Error: 

                 Skip_Counter: 0

          Exec_Master_Log_Pos: 43002550

              Relay_Log_Space: 662370967

              Until_Condition: None

               Until_Log_File: 

                Until_Log_Pos: 0

           Master_SSL_Allowed: No

           Master_SSL_CA_File: 

           Master_SSL_CA_Path: 

              Master_SSL_Cert: 

            Master_SSL_Cipher: 

               Master_SSL_Key: 

        Seconds_Behind_Master: 416430

Master_SSL_Verify_Server_Cert: No

                Last_IO_Errno: 0

                Last_IO_Error: 

               Last_SQL_Errno: 0

               Last_SQL_Error: 

  Replicate_Ignore_Server_Ids: 

             Master_Server_Id: 1

               Master_SSL_Crl: 

           Master_SSL_Crlpath: 

                   Using_Gtid: No

                  Gtid_IO_Pos: 

      Replicate_Do_Domain_Ids: 

  Replicate_Ignore_Domain_Ids: 

                Parallel_Mode: conservative

                    SQL_Delay: 0

          SQL_Remaining_Delay: NULL

      Slave_SQL_Running_State: updating

1 row in set (0.00 sec)


ERROR: No query specified


MariaDB [mysql]> 






mysql 디비 디렉토리에 가 보면,

아래와 같이 로그파일이 생성되어 있다.



-rw-rw----. 1 mysql mysql  47888824  6월 26 10:03 mysql-bin.000001

-rw-rw----. 1 mysql mysql        19  6월  7 11:22 mysql-bin.index

-rw-rw----. 1 mysql mysql       309  6월 21 09:02 mysql-relay-bin.000001

-rw-rw----. 1 mysql mysql       150  6월 26 10:03 mysql-relay-bin.index






끝.















블로그 이미지

엘로드넷

,

1. oracle.com 에서 ojdbc.jar를 다운 받는다.


http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html



Thank you for accepting the OTN License Agreement; you may now download this software.

Oracle Database 12c Release 1 (12.1.0.2) JDBC Drivers & UCP Downloads

 
 Zipped JDBC Driver and Companion JARs 
 Download  ojdbc-full.tar.gz (9,348,239 bytes) - (SHA1 Checksum: 62ab3746ae6d6d5787fa2773ccc2c58f040f00a2) 
The TAR archive contains the latest 12.1.0.2 JDBC Thin driver (ojdbc7.jar and ojdbc6.jar), Universal Connection Pool (ucp.jar), other companion jars, and README that has more information about the contents of the tar file.
                                    OR
 Unzipped JDBC Driver and Companion JARs
 The JARs included in the ojdbc-full.tar.gz are also available as individual downloads in this section. 
 
 Download ojdbc7.jar (3,698,857 bytes) - (SHA1 Checksum: 7c9b5984b2c1e32e7c8cf3331df77f31e89e24c2) Certified with JDK7 and JDK8;
 Download ojdbc6.jar (3,692,096 bytes) - (SHA1 Checksum: 76f2f84c383ef45832b3eea6b5fb3a6edb873b93) For use with JDK6; 
 Download ucp.jar (733,729 bytes) - (SHA1 Checksum:384b4a763188849bfd68f313701ac11dafd1899b)
(Refer MOS note DOC ID 2074693.1) - For use with JDK6 & JDK7
 Download ojdbc.policy (10,542 bytes) - Sample security policy file for Oracle Database JDBC drivers
 Download orai18n.jar (1,659,574 bytes) - (SHA1 Checksum: 11969072d3de96bfd5b246071976e274d78598a7) - Classes for NLS support
 Download xdb6.jar (253,006 bytes) - (SHA1 Checksum: 6fbdaebf59cb33282548f4df14436cc179c64bee)
Classes to support standard JDBC 4.x java.sql.SQLXML interface (Java SE 6 & Java SE 7).
 Download ons.jar (106,496 bytes) - (SHA1 Checksum: 1aee60b3f7aa581d90f2f18d5e334a1913da52c9)
For use by the pure Java client-side Oracle Notification Services (ONS) daemon
 Download simplefan.jar (21,189 bytes) - (SHA1 Checksum: 80ca1246d5c9cad79985e9fff0acc9fb09ba1b2b)
Java APIs for subscribing to RAC events via ONS; simplefan policy and javadoc




ojdbc7.jar 파일을 다운 받는다.




2. 이클립스 환경설정에서 메이븐 설치 경로를 확인한다.





User Settings 에서 보듯


메이븐 설치 경로는 


/usr/local/Cellar/maven/3.5.3/bin 이 된다.



local repository 경로는 


/Users/ellord/.m2/repository 


이다.






3. 메이븐이 설치된 경로로 가서 실행한다.


mvn install:install-file -Dfile="다운받은파일경로" -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1 -Dpackaging=jar




ELLORDNET-MPR:bin ellord$ mvn install:install-file -Dfile="/Users/ellord/Downloads/ojdbc7.jar" -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1 -Dpackaging=jar

[INFO] Scanning for projects...

[INFO

[INFO] ------------------< org.apache.maven:standalone-pom >-------------------

[INFO] Building Maven Stub Project (No POM) 1

[INFO] --------------------------------[ pom ]---------------------------------

[INFO

[INFO] --- maven-install-plugin:2.4:install-file (default-cli) @ standalone-pom ---

[INFO] Installing /Users/ellord/Downloads/ojdbc7.jar to /Users/ellord/.m2/repository/com/oracle/ojdbc7/12.1/ojdbc7-12.1.jar

[INFO] Installing /var/folders/88/j2rmm2sx259_1nlkgr_8q_l40000gn/T/mvninstall7407903127386008808.pom to /Users/ellord/.m2/repository/com/oracle/ojdbc7/12.1/ojdbc7-12.1.pom

[INFO] ------------------------------------------------------------------------

[INFO] BUILD SUCCESS

[INFO] ------------------------------------------------------------------------

[INFO] Total time: 0.471 s

[INFO] Finished at: 2018-06-11T15:23:07+09:00

[INFO] ------------------------------------------------------------------------

ELLORDNET-MPR:bin ellord$ 







4. 설치확인


ELLORDNET-MPR:oracle ellord$ cd /Users/ellord/.m2/repository/com/oracle/

ELLORDNET-MPR:oracle ellord$ ls -l

total 0

drwxr-xr-x  3 ellord  staff   96 Jun 11 14:59 ojdbc6

drwxr-xr-x  4 ellord  staff  128 Jun 11 15:23 ojdbc7

ELLORDNET-MPR:oracle ellord$ 



ojdbc7 이 설치되어 있다.





5. 프로젝트의 pom.xml 에 추가


<dependency>

    <groupId>com.oracle</groupId>

    <artifactId>ojdbc7</artifactId>

    <version>12.1</version>

</dependency>




6. 아래 그림처럼 추가되어 있다.









7. 끝.





블로그 이미지

엘로드넷

,

1. 터미널로 이클립스가 설치된 경로로 이동한다.


ELLORDNET-MPR:Eclipse ellord$ pwd

/Applications/Eclipse.app/Contents/Eclipse




ELLORDNET-MPR:Eclipse ellord$ ls -la

total 584

drwxr-xr-x@  11 ellord  staff     352 Jun  7 20:05 .

drwxr-xr-x@   7 ellord  staff     224 Mar 15  2017 ..

-rw-r--r--@   1 ellord  staff      60 Mar 15  2017 .eclipseproduct

-rw-r--r--@   1 ellord  staff  287350 Mar 15  2017 artifacts.xml

drwxr-xr-x@  12 ellord  staff     384 Jun  7 20:06 configuration

drwxr-xr-x@   2 ellord  staff      64 Mar 15  2017 dropins

-rw-r--r--@   1 ellord  staff     689 Jun  7 20:05 eclipse.ini

drwxr-xr-x@ 180 ellord  staff    5760 Mar 15  2017 features

drwxr-xr-x@   6 ellord  staff     192 Jun  7 20:05 p2

drwxr-xr-x@ 965 ellord  staff   30880 Mar 15  2017 plugins

drwxr-xr-x@   3 ellord  staff      96 Mar 15  2017 readme

ELLORDNET-MPR:Eclipse ellord$ 




2. eclipse.ini 를 열고 아래 내용을 추가한다.(빨간색 부분)



-startup

../Eclipse/plugins/org.eclipse.equinox.launcher_1.3.201.v20161025-1711.jar

--launcher.library

../Eclipse/plugins/org.eclipse.equinox.launcher.cocoa.macosx.x86_64_1.1.401.v20161122-1740

-product

org.eclipse.epp.package.jee.product

--launcher.defaultAction

openFile

-showsplash

org.eclipse.platform

--launcher.defaultAction

openFile

--launcher.appendVmargs

-vmargs

--add-modules=java.se.ee

-Dosgi.requiredJavaVersion=1.8

-XX:+UseG1GC

-XX:+UseStringDeduplication

-XstartOnFirstThread

-Dorg.eclipse.swt.internal.carbon.smallFonts

-Dosgi.requiredJavaVersion=1.8

-Xms256m

-Xmx1024m

-Xdock:icon=../Resources/Eclipse.icns

-XstartOnFirstThread

-Dorg.eclipse.swt.internal.carbon.smallFonts



3. 저장하고 이클립스를 재시작한다. 끝.



'Mac' 카테고리의 다른 글

oracle instantclient 12.2, oci8 설치  (0) 2019.01.08
show hidden files in OSX eclipse  (0) 2019.01.08
PECL/PEAR 설치  (0) 2018.06.01
oracle instantclient 12.2, oci8 설치  (0) 2018.06.01
디스크유틸리티에서 파티션 비활성화 될 때.  (0) 2018.03.17
블로그 이미지

엘로드넷

,

0. 버전확인

1. repl-release 설치

2. yum repo 7.2 추가

3. yum-utils 설치

4. php7.2 설치

5. 관련모듈 설치

6. 심볼릭링크

7. 버전확인

8. 끝.





0. 버전확인. (아직 설치되어 있지 않음)

[root@localhost mysql]# php -v

-bash: php: command not found



1. epel-release 설치 (EPEL; Extra Packages for Enterprise Linux)

[root@localhost mysql]# yum install epel-release

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

 * base: ftp.kaist.ac.kr

 * extras: ftp.kaist.ac.kr

 * updates: ftp.kaist.ac.kr

Resolving Dependencies

--> Running transaction check

---> Package epel-release.noarch 0:7-11 will be installed

--> Finished Dependency Resolution


Dependencies Resolved


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

 Package                   Arch                Version             Repository           Size

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

Installing:

 epel-release              noarch              7-11                extras               15 k


Transaction Summary

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

Install  1 Package


Total download size: 15 k

Installed size: 24 k

Is this ok [y/d/N]: y

Downloading packages:

epel-release-7-11.noarch.rpm                                          |  15 kB  00:00:00     

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : epel-release-7-11.noarch                                                  1/1 

  Verifying  : epel-release-7-11.noarch                                                  1/1 


Installed:

  epel-release.noarch 0:7-11                                                                 


Complete!



2. 7.2설치를 위한 repository 추가(CentOS7에서는 5.4버전이 설치되므로)

[root@localhost mysql]# yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

Loaded plugins: fastestmirror

remi-release-7.rpm                                                    |  15 kB  00:00:00     

Examining /var/tmp/yum-root-1e8WPG/remi-release-7.rpm: remi-release-7.5-1.el7.remi.noarch

Marking /var/tmp/yum-root-1e8WPG/remi-release-7.rpm to be installed

Resolving Dependencies

--> Running transaction check

---> Package remi-release.noarch 0:7.5-1.el7.remi will be installed

--> Finished Dependency Resolution


Dependencies Resolved


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

 Package              Arch           Version                   Repository               Size

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

Installing:

 remi-release         noarch         7.5-1.el7.remi            /remi-release-7          16 k


Transaction Summary

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

Install  1 Package


Total size: 16 k

Installed size: 16 k

Is this ok [y/d/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : remi-release-7.5-1.el7.remi.noarch                                        1/1 

  Verifying  : remi-release-7.5-1.el7.remi.noarch                                        1/1 


Installed:

  remi-release.noarch 0:7.5-1.el7.remi                                                       


Complete!



3. yum-utils설치

[root@localhost mysql]# yum install yum-utils

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

epel/x86_64/metalink                                                  | 7.0 kB  00:00:00     

 * base: ftp.kaist.ac.kr

 * epel: mirror.premi.st

 * extras: ftp.kaist.ac.kr

 * remi-safe: mirrors.thzhost.com

 * updates: ftp.kaist.ac.kr

epel                                                                  | 3.2 kB  00:00:00     

remi-safe                                                             | 2.9 kB  00:00:00     

(1/4): epel/x86_64/group_gz                                           |  88 kB  00:00:00     

(2/4): epel/x86_64/updateinfo                                         | 933 kB  00:00:00     

(3/4): epel/x86_64/primary                                            | 3.5 MB  00:00:00     

(4/4): remi-safe/primary_db                                           | 1.2 MB  00:00:01     

epel                                                                             12586/12586

Resolving Dependencies

--> Running transaction check

---> Package yum-utils.noarch 0:1.1.31-45.el7 will be installed

--> Processing Dependency: python-kitchen for package: yum-utils-1.1.31-45.el7.noarch

--> Processing Dependency: libxml2-python for package: yum-utils-1.1.31-45.el7.noarch

--> Running transaction check

---> Package libxml2-python.x86_64 0:2.9.1-6.el7_2.3 will be installed

---> Package python-kitchen.noarch 0:1.1.1-5.el7 will be installed

--> Processing Dependency: python-chardet for package: python-kitchen-1.1.1-5.el7.noarch

--> Running transaction check

---> Package python-chardet.noarch 0:2.2.1-1.el7_1 will be installed

--> Finished Dependency Resolution


Dependencies Resolved


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

 Package                  Arch             Version                      Repository      Size

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

Installing:

 yum-utils                noarch           1.1.31-45.el7                base           119 k

Installing for dependencies:

 libxml2-python           x86_64           2.9.1-6.el7_2.3              base           247 k

 python-chardet           noarch           2.2.1-1.el7_1                base           227 k

 python-kitchen           noarch           1.1.1-5.el7                  base           267 k


Transaction Summary

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

Install  1 Package (+3 Dependent packages)


Total download size: 859 k

Installed size: 4.3 M

Is this ok [y/d/N]: y

Downloading packages:

(1/4): yum-utils-1.1.31-45.el7.noarch.rpm                             | 119 kB  00:00:00     

(2/4): python-chardet-2.2.1-1.el7_1.noarch.rpm                        | 227 kB  00:00:00     

(3/4): python-kitchen-1.1.1-5.el7.noarch.rpm                          | 267 kB  00:00:00     

(4/4): libxml2-python-2.9.1-6.el7_2.3.x86_64.rpm                      | 247 kB  00:00:00     

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

Total                                                        3.1 MB/s | 859 kB  00:00:00     

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : python-chardet-2.2.1-1.el7_1.noarch                                       1/4 

  Installing : python-kitchen-1.1.1-5.el7.noarch                                         2/4 

  Installing : libxml2-python-2.9.1-6.el7_2.3.x86_64                                     3/4 

  Installing : yum-utils-1.1.31-45.el7.noarch                                            4/4 

  Verifying  : yum-utils-1.1.31-45.el7.noarch                                            1/4 

  Verifying  : libxml2-python-2.9.1-6.el7_2.3.x86_64                                     2/4 

  Verifying  : python-kitchen-1.1.1-5.el7.noarch                                         3/4 

  Verifying  : python-chardet-2.2.1-1.el7_1.noarch                                       4/4 


Installed:

  yum-utils.noarch 0:1.1.31-45.el7                                                           


Dependency Installed:

  libxml2-python.x86_64 0:2.9.1-6.el7_2.3        python-chardet.noarch 0:2.2.1-1.el7_1       

  python-kitchen.noarch 0:1.1.1-5.el7           


Complete!



4. php7.2 설치

[root@localhost mysql]# yum-config-manager --enable remi-php72

Loaded plugins: fastestmirror

===================================== repo: remi-php72 ======================================

[remi-php72]

async = True

bandwidth = 0

base_persistdir = /var/lib/yum/repos/x86_64/7

baseurl = 

cache = 0

cachedir = /var/cache/yum/x86_64/7/remi-php72

check_config_file_age = True

compare_providers_priority = 80

cost = 1000

deltarpm_metadata_percentage = 100

deltarpm_percentage = 

enabled = 1

enablegroups = True

exclude = 

failovermethod = priority

ftp_disable_epsv = False

gpgcadir = /var/lib/yum/repos/x86_64/7/remi-php72/gpgcadir

gpgcakey = 

gpgcheck = True

gpgdir = /var/lib/yum/repos/x86_64/7/remi-php72/gpgdir

gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi

hdrdir = /var/cache/yum/x86_64/7/remi-php72/headers

http_caching = all

includepkgs = 

ip_resolve = 

keepalive = True

keepcache = False

mddownloadpolicy = sqlite

mdpolicy = group:small

mediaid = 

metadata_expire = 21600

metadata_expire_filter = read-only:present

metalink = 

minrate = 0

mirrorlist = http://cdn.remirepo.net/enterprise/7/php72/mirror

mirrorlist_expire = 86400

name = Remi's PHP 7.2 RPM repository for Enterprise Linux 7 - x86_64

old_base_cache_dir = 

password = 

persistdir = /var/lib/yum/repos/x86_64/7/remi-php72

pkgdir = /var/cache/yum/x86_64/7/remi-php72/packages

proxy = False

proxy_dict = 

proxy_password = 

proxy_username = 

repo_gpgcheck = False

retries = 10

skip_if_unavailable = False

ssl_check_cert_permissions = True

sslcacert = 

sslclientcert = 

sslclientkey = 

sslverify = True

throttle = 0

timeout = 30.0

ui_id = remi-php72

ui_repoid_vars = releasever,

   basearch

username = 




[root@localhost mysql]# yum update

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

 * base: ftp.kaist.ac.kr

 * epel: mirror.premi.st

 * extras: ftp.kaist.ac.kr

 * remi-php72: repo1.ash.innoscale.net

 * remi-safe: repo1.ash.innoscale.net

 * updates: ftp.kaist.ac.kr

remi-php72                                                            | 2.9 kB  00:00:00     

remi-php72/primary_db                                                 | 189 kB  00:00:01     

No packages marked for update




[root@localhost mysql]# yum install php72

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

 * base: ftp.kaist.ac.kr

 * epel: mirror.premi.st

 * extras: ftp.kaist.ac.kr

 * remi-php72: mirrors.mediatemple.net

 * remi-safe: mirrors.mediatemple.net

 * updates: ftp.kaist.ac.kr

Resolving Dependencies

--> Running transaction check

---> Package php72.x86_64 0:1.0-1.el7.remi will be installed

--> Processing Dependency: php72-runtime(x86-64) = 1.0-1.el7.remi for package: php72-1.0-1.el7.remi.x86_64

--> Processing Dependency: php72-runtime for package: php72-1.0-1.el7.remi.x86_64

--> Processing Dependency: php72-php-common(x86-64) for package: php72-1.0-1.el7.remi.x86_64

--> Processing Dependency: php72-php-cli(x86-64) for package: php72-1.0-1.el7.remi.x86_64

--> Running transaction check

---> Package php72-php-cli.x86_64 0:7.2.6-1.el7.remi will be installed

--> Processing Dependency: libargon2.so.0()(64bit) for package: php72-php-cli-7.2.6-1.el7.remi.x86_64

---> Package php72-php-common.x86_64 0:7.2.6-1.el7.remi will be installed

--> Processing Dependency: php72-php-json(x86-64) = 7.2.6-1.el7.remi for package: php72-php-common-7.2.6-1.el7.remi.x86_64

---> Package php72-runtime.x86_64 0:1.0-1.el7.remi will be installed

--> Processing Dependency: scl-utils for package: php72-runtime-1.0-1.el7.remi.x86_64

--> Processing Dependency: environment-modules for package: php72-runtime-1.0-1.el7.remi.x86_64

--> Running transaction check

---> Package environment-modules.x86_64 0:3.2.10-10.el7 will be installed

--> Processing Dependency: libtcl8.5.so()(64bit) for package: environment-modules-3.2.10-10.el7.x86_64

--> Processing Dependency: libX11.so.6()(64bit) for package: environment-modules-3.2.10-10.el7.x86_64

---> Package libargon2.x86_64 0:20161029-2.el7 will be installed

---> Package php72-php-json.x86_64 0:7.2.6-1.el7.remi will be installed

---> Package scl-utils.x86_64 0:20130529-18.el7_4 will be installed

--> Running transaction check

---> Package libX11.x86_64 0:1.6.5-1.el7 will be installed

--> Processing Dependency: libX11-common >= 1.6.5-1.el7 for package: libX11-1.6.5-1.el7.x86_64

--> Processing Dependency: libxcb.so.1()(64bit) for package: libX11-1.6.5-1.el7.x86_64

---> Package tcl.x86_64 1:8.5.13-8.el7 will be installed

--> Running transaction check

---> Package libX11-common.noarch 0:1.6.5-1.el7 will be installed

---> Package libxcb.x86_64 0:1.12-1.el7 will be installed

--> Processing Dependency: libXau.so.6()(64bit) for package: libxcb-1.12-1.el7.x86_64

--> Running transaction check

---> Package libXau.x86_64 0:1.0.8-2.1.el7 will be installed

--> Finished Dependency Resolution


Dependencies Resolved


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

 Package                    Arch          Version                     Repository        Size

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

Installing:

 php72                      x86_64        1.0-1.el7.remi              remi-safe        2.2 k

Installing for dependencies:

 environment-modules        x86_64        3.2.10-10.el7               base             107 k

 libX11                     x86_64        1.6.5-1.el7                 base             606 k

 libX11-common              noarch        1.6.5-1.el7                 base             164 k

 libXau                     x86_64        1.0.8-2.1.el7               base              29 k

 libargon2                  x86_64        20161029-2.el7              epel              23 k

 libxcb                     x86_64        1.12-1.el7                  base             211 k

 php72-php-cli              x86_64        7.2.6-1.el7.remi            remi-safe        3.2 M

 php72-php-common           x86_64        7.2.6-1.el7.remi            remi-safe        625 k

 php72-php-json             x86_64        7.2.6-1.el7.remi            remi-safe         64 k

 php72-runtime              x86_64        1.0-1.el7.remi              remi-safe        1.1 M

 scl-utils                  x86_64        20130529-18.el7_4           base              24 k

 tcl                        x86_64        1:8.5.13-8.el7              base             1.9 M


Transaction Summary

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

Install  1 Package (+12 Dependent packages)


Total download size: 8.1 M

Installed size: 24 M

Is this ok [y/d/N]: y

Downloading packages:

(1/13): libXau-1.0.8-2.1.el7.x86_64.rpm                               |  29 kB  00:00:00     

(2/13): libX11-1.6.5-1.el7.x86_64.rpm                                 | 606 kB  00:00:00     

(3/13): environment-modules-3.2.10-10.el7.x86_64.rpm                  | 107 kB  00:00:00     

(4/13): libX11-common-1.6.5-1.el7.noarch.rpm                          | 164 kB  00:00:00     

(5/13): libxcb-1.12-1.el7.x86_64.rpm                                  | 211 kB  00:00:00     

warning: /var/cache/yum/x86_64/7/remi-safe/packages/php72-1.0-1.el7.remi.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 00f97f56: NOKEY

Public key for php72-1.0-1.el7.remi.x86_64.rpm is not installed

(6/13): php72-1.0-1.el7.remi.x86_64.rpm                               | 2.2 kB  00:00:00     

warning: /var/cache/yum/x86_64/7/epel/packages/libargon2-20161029-2.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID 352c64e5: NOKEY

Public key for libargon2-20161029-2.el7.x86_64.rpm is not installed

(7/13): libargon2-20161029-2.el7.x86_64.rpm                           |  23 kB  00:00:00     

(8/13): scl-utils-20130529-18.el7_4.x86_64.rpm                        |  24 kB  00:00:00     

(9/13): tcl-8.5.13-8.el7.x86_64.rpm                                   | 1.9 MB  00:00:00     

(10/13): php72-php-json-7.2.6-1.el7.remi.x86_64.rpm                   |  64 kB  00:00:02     

(11/13): php72-runtime-1.0-1.el7.remi.x86_64.rpm                      | 1.1 MB  00:00:02     

(12/13): php72-php-cli-7.2.6-1.el7.remi.x86_64.rpm                    | 3.2 MB  00:00:03     

(13/13): php72-php-common-7.2.6-1.el7.remi.x86_64.rpm                 | 625 kB  00:00:03     

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

Total                                                        2.3 MB/s | 8.1 MB  00:00:03     

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi

Importing GPG key 0x00F97F56:

 Userid     : "Remi Collet <RPMS@FamilleCollet.com>"

 Fingerprint: 1ee0 4cce 88a4 ae4a a29a 5df5 004e 6f47 00f9 7f56

 Package    : remi-release-7.5-1.el7.remi.noarch (installed)

 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-remi

Is this ok [y/N]: y

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7

Importing GPG key 0x352C64E5:

 Userid     : "Fedora EPEL (7) <epel@fedoraproject.org>"

 Fingerprint: 91e9 7d7c 4a5e 96f1 7f3e 888f 6a2f aea2 352c 64e5

 Package    : epel-release-7-11.noarch (@extras)

 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7

Is this ok [y/N]: y

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : libX11-common-1.6.5-1.el7.noarch                                         1/13 

  Installing : libargon2-20161029-2.el7.x86_64                                          2/13 

  Installing : libXau-1.0.8-2.1.el7.x86_64                                              3/13 

  Installing : libxcb-1.12-1.el7.x86_64                                                 4/13 

  Installing : libX11-1.6.5-1.el7.x86_64                                                5/13 

  Installing : 1:tcl-8.5.13-8.el7.x86_64                                                6/13 

  Installing : environment-modules-3.2.10-10.el7.x86_64                                 7/13 

  Installing : scl-utils-20130529-18.el7_4.x86_64                                       8/13 

  Installing : php72-runtime-1.0-1.el7.remi.x86_64                                      9/13 

  Installing : php72-php-json-7.2.6-1.el7.remi.x86_64                                  10/13 

  Installing : php72-php-common-7.2.6-1.el7.remi.x86_64                                11/13 

  Installing : php72-php-cli-7.2.6-1.el7.remi.x86_64                                   12/13 

  Installing : php72-1.0-1.el7.remi.x86_64                                             13/13 

  Verifying  : scl-utils-20130529-18.el7_4.x86_64                                       1/13 

  Verifying  : libX11-1.6.5-1.el7.x86_64                                                2/13 

  Verifying  : 1:tcl-8.5.13-8.el7.x86_64                                                3/13 

  Verifying  : libxcb-1.12-1.el7.x86_64                                                 4/13 

  Verifying  : libXau-1.0.8-2.1.el7.x86_64                                              5/13 

  Verifying  : php72-1.0-1.el7.remi.x86_64                                              6/13 

  Verifying  : php72-php-common-7.2.6-1.el7.remi.x86_64                                 7/13 

  Verifying  : php72-php-json-7.2.6-1.el7.remi.x86_64                                   8/13 

  Verifying  : environment-modules-3.2.10-10.el7.x86_64                                 9/13 

  Verifying  : libargon2-20161029-2.el7.x86_64                                         10/13 

  Verifying  : php72-runtime-1.0-1.el7.remi.x86_64                                     11/13 

  Verifying  : php72-php-cli-7.2.6-1.el7.remi.x86_64                                   12/13 

  Verifying  : libX11-common-1.6.5-1.el7.noarch                                        13/13 


Installed:

  php72.x86_64 0:1.0-1.el7.remi                                                              


Dependency Installed:

  environment-modules.x86_64 0:3.2.10-10.el7    libX11.x86_64 0:1.6.5-1.el7                  

  libX11-common.noarch 0:1.6.5-1.el7            libXau.x86_64 0:1.0.8-2.1.el7                

  libargon2.x86_64 0:20161029-2.el7             libxcb.x86_64 0:1.12-1.el7                   

  php72-php-cli.x86_64 0:7.2.6-1.el7.remi       php72-php-common.x86_64 0:7.2.6-1.el7.remi   

  php72-php-json.x86_64 0:7.2.6-1.el7.remi      php72-runtime.x86_64 0:1.0-1.el7.remi        

  scl-utils.x86_64 0:20130529-18.el7_4          tcl.x86_64 1:8.5.13-8.el7                    


Complete!



5. 추가모듈 설치

[root@localhost mysql]# yum install php72-php-fpm php72-php-gd php72-php-json php72-php-mbstring php72-php-mysqlnd php72-php-xml php72-php-xmlrpc php72-php-opcache

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

 * base: ftp.kaist.ac.kr

 * epel: mirror.premi.st

 * extras: ftp.kaist.ac.kr

 * remi-php72: repo1.sea.innoscale.net

 * remi-safe: repo1.sea.innoscale.net

 * updates: ftp.kaist.ac.kr

Package php72-php-json-7.2.6-1.el7.remi.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package php72-php-fpm.x86_64 0:7.2.6-1.el7.remi will be installed

---> Package php72-php-gd.x86_64 0:7.2.6-1.el7.remi will be installed

--> Processing Dependency: gd-last(x86-64) >= 2.1.1 for package: php72-php-gd-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libpng15.so.15()(64bit) for package: php72-php-gd-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libjpeg.so.62()(64bit) for package: php72-php-gd-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libgd.so.3()(64bit) for package: php72-php-gd-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libXpm.so.4()(64bit) for package: php72-php-gd-7.2.6-1.el7.remi.x86_64

---> Package php72-php-mbstring.x86_64 0:7.2.6-1.el7.remi will be installed

---> Package php72-php-mysqlnd.x86_64 0:7.2.6-1.el7.remi will be installed

--> Processing Dependency: php72-php-pdo(x86-64) = 7.2.6-1.el7.remi for package: php72-php-mysqlnd-7.2.6-1.el7.remi.x86_64

---> Package php72-php-opcache.x86_64 0:7.2.6-1.el7.remi will be installed

---> Package php72-php-xml.x86_64 0:7.2.6-1.el7.remi will be installed

--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.24)(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.13)(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libxslt.so.1()(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

--> Processing Dependency: libexslt.so.0()(64bit) for package: php72-php-xml-7.2.6-1.el7.remi.x86_64

---> Package php72-php-xmlrpc.x86_64 0:7.2.6-1.el7.remi will be installed

--> Running transaction check

---> Package gd-last.x86_64 0:2.2.5-2.el7.remi will be installed

--> Processing Dependency: libtiff.so.5(LIBTIFF_4.0)(64bit) for package: gd-last-2.2.5-2.el7.remi.x86_64

--> Processing Dependency: libwebp.so.4()(64bit) for package: gd-last-2.2.5-2.el7.remi.x86_64

--> Processing Dependency: libtiff.so.5()(64bit) for package: gd-last-2.2.5-2.el7.remi.x86_64

--> Processing Dependency: libfontconfig.so.1()(64bit) for package: gd-last-2.2.5-2.el7.remi.x86_64

---> Package libXpm.x86_64 0:3.5.12-1.el7 will be installed

---> Package libjpeg-turbo.x86_64 0:1.2.90-5.el7 will be installed

---> Package libpng.x86_64 2:1.5.13-7.el7_2 will be installed

---> Package libxslt.x86_64 0:1.1.28-5.el7 will be installed

---> Package php72-php-pdo.x86_64 0:7.2.6-1.el7.remi will be installed

--> Running transaction check

---> Package fontconfig.x86_64 0:2.10.95-11.el7 will be installed

--> Processing Dependency: fontpackages-filesystem for package: fontconfig-2.10.95-11.el7.x86_64

--> Processing Dependency: font(:lang=en) for package: fontconfig-2.10.95-11.el7.x86_64

---> Package libtiff.x86_64 0:4.0.3-27.el7_3 will be installed

--> Processing Dependency: libjbig.so.2.0()(64bit) for package: libtiff-4.0.3-27.el7_3.x86_64

---> Package libwebp.x86_64 0:0.3.0-7.el7 will be installed

--> Running transaction check

---> Package fontpackages-filesystem.noarch 0:1.44-8.el7 will be installed

---> Package jbigkit-libs.x86_64 0:2.0-11.el7 will be installed

---> Package lyx-fonts.noarch 0:2.2.3-1.el7 will be installed

--> Finished Dependency Resolution


Dependencies Resolved


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

 Package                        Arch          Version                 Repository        Size

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

Installing:

 php72-php-fpm                  x86_64        7.2.6-1.el7.remi        remi-safe        1.7 M

 php72-php-gd                   x86_64        7.2.6-1.el7.remi        remi-safe         74 k

 php72-php-mbstring             x86_64        7.2.6-1.el7.remi        remi-safe        564 k

 php72-php-mysqlnd              x86_64        7.2.6-1.el7.remi        remi-safe        176 k

 php72-php-opcache              x86_64        7.2.6-1.el7.remi        remi-safe        216 k

 php72-php-xml                  x86_64        7.2.6-1.el7.remi        remi-safe        169 k

 php72-php-xmlrpc               x86_64        7.2.6-1.el7.remi        remi-safe         79 k

Installing for dependencies:

 fontconfig                     x86_64        2.10.95-11.el7          base             229 k

 fontpackages-filesystem        noarch        1.44-8.el7              base             9.9 k

 gd-last                        x86_64        2.2.5-2.el7.remi        remi-safe        133 k

 jbigkit-libs                   x86_64        2.0-11.el7              base              46 k

 libXpm                         x86_64        3.5.12-1.el7            base              55 k

 libjpeg-turbo                  x86_64        1.2.90-5.el7            base             134 k

 libpng                         x86_64        2:1.5.13-7.el7_2        base             213 k

 libtiff                        x86_64        4.0.3-27.el7_3          base             170 k

 libwebp                        x86_64        0.3.0-7.el7             base             170 k

 libxslt                        x86_64        1.1.28-5.el7            base             242 k

 lyx-fonts                      noarch        2.2.3-1.el7             epel             159 k

 php72-php-pdo                  x86_64        7.2.6-1.el7.remi        remi-safe        110 k


Transaction Summary

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

Install  7 Packages (+12 Dependent packages)


Total download size: 4.5 M

Installed size: 12 M

Is this ok [y/d/N]: y

Downloading packages:

(1/19): fontpackages-filesystem-1.44-8.el7.noarch.rpm                 | 9.9 kB  00:00:00     

(2/19): libjpeg-turbo-1.2.90-5.el7.x86_64.rpm                         | 134 kB  00:00:00     

(3/19): fontconfig-2.10.95-11.el7.x86_64.rpm                          | 229 kB  00:00:00     

(4/19): jbigkit-libs-2.0-11.el7.x86_64.rpm                            |  46 kB  00:00:00     

(5/19): libXpm-3.5.12-1.el7.x86_64.rpm                                |  55 kB  00:00:00     

(6/19): libpng-1.5.13-7.el7_2.x86_64.rpm                              | 213 kB  00:00:00     

(7/19): libxslt-1.1.28-5.el7.x86_64.rpm                               | 242 kB  00:00:00     

(8/19): libtiff-4.0.3-27.el7_3.x86_64.rpm                             | 170 kB  00:00:00     

(9/19): libwebp-0.3.0-7.el7.x86_64.rpm                                | 170 kB  00:00:00     

(10/19): lyx-fonts-2.2.3-1.el7.noarch.rpm                             | 159 kB  00:00:00     

(11/19): gd-last-2.2.5-2.el7.remi.x86_64.rpm                          | 133 kB  00:00:01     

(12/19): php72-php-opcache-7.2.6-1.el7.remi.x86_64.rpm                | 216 kB  00:00:00     

(13/19): php72-php-pdo-7.2.6-1.el7.remi.x86_64.rpm                    | 110 kB  00:00:00     

(14/19): php72-php-fpm-7.2.6-1.el7.remi.x86_64.rpm                    | 1.7 MB  00:00:01     

(15/19): php72-php-gd-7.2.6-1.el7.remi.x86_64.rpm                     |  74 kB  00:00:01     

(16/19): php72-php-xml-7.2.6-1.el7.remi.x86_64.rpm                    | 169 kB  00:00:00     

(17/19): php72-php-xmlrpc-7.2.6-1.el7.remi.x86_64.rpm                 |  79 kB  00:00:00     

(18/19): php72-php-mysqlnd-7.2.6-1.el7.remi.x86_64.rpm                | 176 kB  00:00:02     

(19/19): php72-php-mbstring-7.2.6-1.el7.remi.x86_64.rpm               | 564 kB  00:00:03     

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

Total                                                        1.2 MB/s | 4.5 MB  00:00:03     

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : libjpeg-turbo-1.2.90-5.el7.x86_64                                        1/19 

  Installing : 2:libpng-1.5.13-7.el7_2.x86_64                                           2/19 

  Installing : fontpackages-filesystem-1.44-8.el7.noarch                                3/19 

  Installing : libXpm-3.5.12-1.el7.x86_64                                               4/19 

  Installing : lyx-fonts-2.2.3-1.el7.noarch                                             5/19 

  Installing : fontconfig-2.10.95-11.el7.x86_64                                         6/19 

  Installing : jbigkit-libs-2.0-11.el7.x86_64                                           7/19 

  Installing : libtiff-4.0.3-27.el7_3.x86_64                                            8/19 

  Installing : libxslt-1.1.28-5.el7.x86_64                                              9/19 

  Installing : php72-php-xml-7.2.6-1.el7.remi.x86_64                                   10/19 

  Installing : php72-php-pdo-7.2.6-1.el7.remi.x86_64                                   11/19 

  Installing : libwebp-0.3.0-7.el7.x86_64                                              12/19 

  Installing : gd-last-2.2.5-2.el7.remi.x86_64                                         13/19 

  Installing : php72-php-gd-7.2.6-1.el7.remi.x86_64                                    14/19 

  Installing : php72-php-mysqlnd-7.2.6-1.el7.remi.x86_64                               15/19 

  Installing : php72-php-xmlrpc-7.2.6-1.el7.remi.x86_64                                16/19 

  Installing : php72-php-fpm-7.2.6-1.el7.remi.x86_64                                   17/19 

  Installing : php72-php-mbstring-7.2.6-1.el7.remi.x86_64                              18/19 

  Installing : php72-php-opcache-7.2.6-1.el7.remi.x86_64                               19/19 

  Verifying  : libXpm-3.5.12-1.el7.x86_64                                               1/19 

  Verifying  : libwebp-0.3.0-7.el7.x86_64                                               2/19 

  Verifying  : lyx-fonts-2.2.3-1.el7.noarch                                             3/19 

  Verifying  : libtiff-4.0.3-27.el7_3.x86_64                                            4/19 

  Verifying  : php72-php-pdo-7.2.6-1.el7.remi.x86_64                                    5/19 

  Verifying  : php72-php-opcache-7.2.6-1.el7.remi.x86_64                                6/19 

  Verifying  : php72-php-mysqlnd-7.2.6-1.el7.remi.x86_64                                7/19 

  Verifying  : libjpeg-turbo-1.2.90-5.el7.x86_64                                        8/19 

  Verifying  : fontconfig-2.10.95-11.el7.x86_64                                         9/19 

  Verifying  : gd-last-2.2.5-2.el7.remi.x86_64                                         10/19 

  Verifying  : libxslt-1.1.28-5.el7.x86_64                                             11/19 

  Verifying  : php72-php-xmlrpc-7.2.6-1.el7.remi.x86_64                                12/19 

  Verifying  : fontpackages-filesystem-1.44-8.el7.noarch                               13/19 

  Verifying  : php72-php-xml-7.2.6-1.el7.remi.x86_64                                   14/19 

  Verifying  : 2:libpng-1.5.13-7.el7_2.x86_64                                          15/19 

  Verifying  : php72-php-mbstring-7.2.6-1.el7.remi.x86_64                              16/19 

  Verifying  : jbigkit-libs-2.0-11.el7.x86_64                                          17/19 

  Verifying  : php72-php-fpm-7.2.6-1.el7.remi.x86_64                                   18/19 

  Verifying  : php72-php-gd-7.2.6-1.el7.remi.x86_64                                    19/19 


Installed:

  php72-php-fpm.x86_64 0:7.2.6-1.el7.remi       php72-php-gd.x86_64 0:7.2.6-1.el7.remi      

  php72-php-mbstring.x86_64 0:7.2.6-1.el7.remi  php72-php-mysqlnd.x86_64 0:7.2.6-1.el7.remi 

  php72-php-opcache.x86_64 0:7.2.6-1.el7.remi   php72-php-xml.x86_64 0:7.2.6-1.el7.remi     

  php72-php-xmlrpc.x86_64 0:7.2.6-1.el7.remi   


Dependency Installed:

  fontconfig.x86_64 0:2.10.95-11.el7       fontpackages-filesystem.noarch 0:1.44-8.el7      

  gd-last.x86_64 0:2.2.5-2.el7.remi        jbigkit-libs.x86_64 0:2.0-11.el7                 

  libXpm.x86_64 0:3.5.12-1.el7             libjpeg-turbo.x86_64 0:1.2.90-5.el7              

  libpng.x86_64 2:1.5.13-7.el7_2           libtiff.x86_64 0:4.0.3-27.el7_3                  

  libwebp.x86_64 0:0.3.0-7.el7             libxslt.x86_64 0:1.1.28-5.el7                    

  lyx-fonts.noarch 0:2.2.3-1.el7           php72-php-pdo.x86_64 0:7.2.6-1.el7.remi          


Complete!



6. 심볼릭링크

[root@localhost bin]# ln -s /opt/remi/php72/root/usr/bin/php php

[root@localhost bin]# ln -s /opt/remi/php72/root/usr/bin/php-cgi php-cgi

[root@localhost bin]# ln -s /opt/remi/php72/root/usr/bin/phar.phar phar.phar




7. 버전확인

[root@localhost bin]# php -v

PHP 7.2.6 (cli) (built: May 23 2018 08:56:04) ( NTS )

Copyright (c) 1997-2018 The PHP Group

Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies

    with Zend OPcache v7.2.6, Copyright (c) 1999-2018, by Zend Technologies

[root@localhost bin]# 





8. 끝.











'PHP' 카테고리의 다른 글

IIS PHP 헤더설정  (0) 2019.01.08
단방향 암호화 문자열 crypt sha512 암호화  (0) 2019.01.08
CentOS7 PHP7 oci8.so 설치  (0) 2017.11.07
php-mcrypt 설치가 안될 때  (0) 2017.11.05
페이징 및 함수이용  (0) 2016.03.01
블로그 이미지

엘로드넷

,

PECL/PEAR 설치

Mac 2018. 6. 1. 19:44

curl -O http://pear.php.net/go-pear.phar


sudo php -d detect_unicode=0 go-pear.phar



1. 1번을 누르고 엔터


2. /usr/local/pear 입력


3. 4번을 누르고 엔터


4. /usr/local/bin 입력


5. 엔터


블로그 이미지

엘로드넷

,

OSX High Sierra 에 오라클 인스턴트 클라이언트 및 oci8 설치



1. 오라클 사이트에서 아래 3개 파일 다운로드


instantclient-basic-maxos.x64-12.2.0.1.zip

instantclient-sqlplus-maxos.x64-12.2.0.1.zip

instantclient-sdk-maxos.x64-12.2.0.1.zip


2. 압축을 푼다.


/usr/local/instantclient/12.2.0.1 폴더에 모든 압축을 풀어 놓는다.


폴더 구조는 아래와 같다.


-rw-rw-rw-@ 1 ellord  staff        400 Jan  9 23:52 BASIC_README

-rw-rw-rw-@ 1 ellord  staff        404 Jan  9 23:53 SQLPLUS_README

-rwxrwxrwx@ 1 ellord  staff      10036 Jan  9 23:52 adrci

-rwxrwxrwx@ 1 ellord  staff      40360 Jan  9 23:52 genezi

-r-xr-xr-x@ 1 ellord  staff        342 Apr 24  2015 glogin.sql

lrwxr-xr-x@ 1 ellord  staff         20 May 31 23:28 libclntsh.dylib -> libclntsh.dylib.12.1

-rwxrwxrwx@ 1 ellord  staff   85621532 Jan  9 23:51 libclntsh.dylib.12.1

-rwxrwxrwx@ 1 ellord  staff    4685408 Jan  9 23:51 libclntshcore.dylib.12.1

-r-xr-xr-x@ 1 ellord  staff    8179072 Jun 28  2017 libnnz12.dylib

lrwxr-xr-x@ 1 ellord  staff         18 May 31 23:28 libocci.dylib -> libocci.dylib.12.1

-rwxrwxrwx@ 1 ellord  staff    1465312 Jan  9 23:44 libocci.dylib.12.1

-rwxrwxrwx@ 1 ellord  staff  124769196 Jan  9 23:52 libociei.dylib

-r-xr-xr-x@ 1 ellord  staff     151748 Aug  8  2017 libocijdbc12.dylib

-r-xr-xr-x@ 1 ellord  staff     237780 Jan  8 05:33 libons.dylib

-rwxrwxrwx@ 1 ellord  staff      84988 Jan  9 23:40 liboramysql12.dylib

-rwxrwxrwx@ 1 ellord  staff    1267088 Jan  9 23:13 libsqlplus.dylib

-r-xr-xr-x@ 1 ellord  staff    1639388 Jul 12  2017 libsqlplusic.dylib

-r--r--r--@ 1 ellord  staff    4036257 Dec 13  2016 ojdbc8.jar

drwxrwxrwx@ 8 ellord  staff        256 Jan  9 23:53 sdk

-rwxr-xr-x@ 1 ellord  staff       8480 Jan  9 23:53 sqlplus

-rwxrwxrwx@ 1 ellord  staff     146084 Jan  9 23:52 uidrvci

-r--r--r--@ 1 ellord  staff      74230 Jan 26  2017 xstreams.jar



3. 링크를 걸어준다.


sudo ln -sF /usr/local/instantclient/12.2.0.1/sdk/include/*.h /usr/local/include/

sudo ln -sF /usr/local/instantclient/12.2.0.1/sqlplus /usr/local/bin/

sudo ln -sF /usr/local/instantclient/12.2.0.1/*.dylib /usr/local/lib/

sudo ln -sf /usr/local/instantclient/12.2.0.1/*.dylib.12.1 /usr/local/lib/

sudo ln -sF /usr/local/lib/libclntsh.dylib.12.1 /usr/local/lib/libclntsh.dylib





4. sqlplus로 오라클 서버에 접속해 본다.


sudo /usr/local/bin/sqlplus 유저명/비밀번호@서버IP:port/SID




5. pecl로 oci8 설치



sudo pecl install oci8-2.0.10    #php 5.x


sudo pecl install oci8                #php 7


입력창에서 아래와 같이 입력하고 엔터


instantclient,/usr/local/lib




sh-3.2# pecl install oci8


Warning: Declaration of PEAR_Installer::download($packages, $options, &$config, &$installpackages, &$errors, $installed = false, $willinstall = false, $state = false) should be compatible with & PEAR_Downloader::download($params) in Installer.php on line 43


Warning: Declaration of PEAR_Installer::download($packages, $options, &$config, &$installpackages, &$errors, $installed = false, $willinstall = false, $state = false) should be compatible with & PEAR_Downloader::download($params) in /usr/local/pear/share/pear/PEAR/Installer.php on line 43

WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update

downloading oci8-2.1.8.tgz ...

Starting to download oci8-2.1.8.tgz (194,154 bytes)

.....done: 194,154 bytes


Warning: Declaration of & PEAR_PackageFile_Parser_v2::parse($data, $file, $archive = false, $class = 'PEAR_Packa...') should be compatible with PEAR_XMLParser::parse($data) in v2.php on line 113


Warning: Declaration of & PEAR_PackageFile_Parser_v2::parse($data, $file, $archive = false, $class = 'PEAR_Packa...') should be compatible with PEAR_XMLParser::parse($data) in /usr/local/pear/share/pear/PEAR/PackageFile/Parser/v2.php on line 113


Warning: Declaration of PEAR_Builder::log($level, $msg) should be compatible with PEAR_Common::log($level, $msg, $append_crlf = true) in Builder.php on line 489


Warning: Declaration of PEAR_Builder::log($level, $msg) should be compatible with PEAR_Common::log($level, $msg, $append_crlf = true) in /usr/local/pear/share/pear/PEAR/Builder.php on line 489

11 source files, building

running: phpize

Configuring for:

PHP Api Version:         20160303

Zend Module Api No:      20160303

Zend Extension Api No:   320160303

Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client [autodetect] : instantclient,/usr/local/lib

building in /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8

running: /private/tmp/pear/install/oci8/configure --with-oci8=instantclient,/usr/local/lib

checking for grep that handles long lines and -e... /usr/bin/grep

checking for egrep... /usr/bin/grep -E

checking for a sed that does not truncate output... /usr/bin/sed

checking for cc... cc

checking whether the C compiler works... yes

checking for C compiler default output file name... a.out

checking for suffix of executables...

checking whether we are cross compiling... no

checking for suffix of object files... o

checking whether we are using the GNU C compiler... yes

checking whether cc accepts -g... yes

checking for cc option to accept ISO C89... none needed

checking how to run the C preprocessor... cc -E

checking for icc... no

checking for suncc... no

checking whether cc understands -c and -o together... yes

checking for system library directory... lib

checking if compiler supports -R... no

checking if compiler supports -Wl,-rpath,... yes

checking build system type... x86_64-apple-darwin17.5.0

checking host system type... x86_64-apple-darwin17.5.0

checking target system type... x86_64-apple-darwin17.5.0

checking for PHP prefix... /usr

checking for PHP includes... -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib

checking for PHP extension directory... /usr/lib/php/extensions/no-debug-non-zts-20160303

checking for PHP installed headers prefix... /usr/include/php

checking if debug is enabled... no

checking if zts is enabled... no

checking for re2c... no

configure: WARNING: You will need re2c 0.13.4 or later if you want to regenerate PHP parsers.

checking for gawk... no

checking for nawk... no

checking for awk... awk

checking if awk is broken... no

checking for Oracle Database OCI8 support... yes, shared

checking PHP version... 7.1.14, ok

checking OCI8 DTrace support... no

checking size of long int... 8

checking checking if we're on a 64-bit platform... yes

checking Oracle Instant Client directory... /usr/local/lib

checking Oracle Instant Client SDK header directory... /usr/local/include

checking Oracle Instant Client library version compatibility... 12.1

checking for ld used by cc... /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld

checking if the linker (/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld) is GNU ld... no

checking for /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld option to reload object files... -r

checking for BSD-compatible nm... /usr/bin/nm -B

checking whether ln -s works... yes

checking how to recognize dependent libraries... pass_all

checking dlfcn.h usability... yes

checking dlfcn.h presence... yes

checking for dlfcn.h... yes

checking the maximum length of command line arguments... 196608

checking command to parse /usr/bin/nm -B output from cc object... ok

checking for objdir... .libs

checking for ar... ar

checking for ranlib... ranlib

checking for strip... strip

checking for dsymutil... dsymutil

checking for nmedit... nmedit

checking for -single_module linker flag... yes

checking for -exported_symbols_list linker flag... yes

checking if cc supports -fno-rtti -fno-exceptions... yes

checking for cc option to produce PIC... -fno-common

checking if cc PIC flag -fno-common works... yes

checking if cc static flag -static works... no

checking if cc supports -c -o file.o... yes

checking whether the cc linker (/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/ld) supports shared libraries... yes

checking dynamic linker characteristics... darwin17.5.0 dyld

checking how to hardcode library paths into programs... immediate

checking whether stripping libraries is possible... yes

checking if libtool supports shared libraries... yes

checking whether to build shared libraries... yes

checking whether to build static libraries... no


creating libtool

appending configuration tag "CXX" to libtool

configure: creating ./config.status

config.status: creating config.h

running: make

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=compile cc  -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -c /private/tmp/pear/install/oci8/oci8.c -o oci8.lo

mkdir .libs

 cc -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include -DHAVE_CONFIG_H -g -O2 -c /private/tmp/pear/install/oci8/oci8.c  -fno-common -DPIC -o .libs/oci8.o

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=compile cc  -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -c /private/tmp/pear/install/oci8/oci8_lob.c -o oci8_lob.lo

 cc -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include -DHAVE_CONFIG_H -g -O2 -c /private/tmp/pear/install/oci8/oci8_lob.c  -fno-common -DPIC -o .libs/oci8_lob.o

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=compile cc  -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -c /private/tmp/pear/install/oci8/oci8_statement.c -o oci8_statement.lo

 cc -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include -DHAVE_CONFIG_H -g -O2 -c /private/tmp/pear/install/oci8/oci8_statement.c  -fno-common -DPIC -o .libs/oci8_statement.o

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=compile cc  -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -c /private/tmp/pear/install/oci8/oci8_collection.c -o oci8_collection.lo

 cc -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include -DHAVE_CONFIG_H -g -O2 -c /private/tmp/pear/install/oci8/oci8_collection.c  -fno-common -DPIC -o .libs/oci8_collection.o

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=compile cc  -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -c /private/tmp/pear/install/oci8/oci8_interface.c -o oci8_interface.lo

 cc -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include -DHAVE_CONFIG_H -g -O2 -c /private/tmp/pear/install/oci8/oci8_interface.c  -fno-common -DPIC -o .libs/oci8_interface.o

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=compile cc  -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -c /private/tmp/pear/install/oci8/oci8_failover.c -o oci8_failover.lo

 cc -I. -I/private/tmp/pear/install/oci8 -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include -DHAVE_CONFIG_H -g -O2 -c /private/tmp/pear/install/oci8/oci8_failover.c  -fno-common -DPIC -o .libs/oci8_failover.o

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=link cc -DPHP_ATOM_INC -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/include -I/private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/main -I/private/tmp/pear/install/oci8 -I/usr/include/php -I/usr/include/php/main -I/usr/include/php/TSRM -I/usr/include/php/Zend -I/usr/include/php/ext -I/usr/include/php/ext/date/lib -I/usr/local/include  -DHAVE_CONFIG_H  -g -O2   -o oci8.la -export-dynamic -avoid-version -prefer-pic -module -rpath /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/modules  oci8.lo oci8_lob.lo oci8_statement.lo oci8_collection.lo oci8_interface.lo oci8_failover.lo -Wl,-rpath,/usr/local/lib -L/usr/local/lib -lclntsh

cc ${wl}-flat_namespace ${wl}-undefined ${wl}suppress -o .libs/oci8.so -bundle  .libs/oci8.o .libs/oci8_lob.o .libs/oci8_statement.o .libs/oci8_collection.o .libs/oci8_interface.o .libs/oci8_failover.o  -L/usr/local/lib -lclntsh  -Wl,-rpath -Wl,/usr/local/lib

dsymutil .libs/oci8.so || :

creating oci8.la

(cd .libs && rm -f oci8.la && ln -s ../oci8.la oci8.la)

/bin/sh /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/libtool --mode=install cp ./oci8.la /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/modules

cp ./.libs/oci8.so /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/modules/oci8.so

cp ./.libs/oci8.lai /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/modules/oci8.la

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

Libraries have been installed in:

   /private/tmp/pear/install/pear-build-root4n2lSS/oci8-2.1.8/modules


If you ever happen to want to link against installed libraries

in a given directory, LIBDIR, you must either use libtool, and

specify the full pathname of the library, or use the `-LLIBDIR'

flag during linking and do at least one of the following:

   - add LIBDIR to the `DYLD_LIBRARY_PATH' environment variable

     during execution


See any operating system documentation about shared libraries for

more information, such as the ld(1) and ld.so(8) manual pages.

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


Build complete.

Don't forget to run 'make test'.


running: make INSTALL_ROOT="/private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8" install

Installing shared extensions:     /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr/lib/php/extensions/no-debug-non-zts-20160303/

running: find "/private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8" | xargs ls -dils

14107085   0 drwxr-xr-x  3 root  wheel      96 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8

14107435   0 drwxr-xr-x  3 root  wheel      96 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr

14107436   0 drwxr-xr-x  3 root  wheel      96 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr/lib

14107437   0 drwxr-xr-x  3 root  wheel      96 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr/lib/php

14107438   0 drwxr-xr-x  3 root  wheel      96 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr/lib/php/extensions

14107439   0 drwxr-xr-x  3 root  wheel      96 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr/lib/php/extensions/no-debug-non-zts-20160303

14107440 352 -rwxr-xr-x  1 root  wheel  176164 Jun  1 00:24 /private/tmp/pear/install/pear-build-root4n2lSS/install-oci8-2.1.8/usr/lib/php/extensions/no-debug-non-zts-20160303/oci8.so


Build process completed successfully

Installing '/usr/lib/php/extensions/no-debug-non-zts-20160303/oci8.so'




6. /usr/lib/php/extensions/no-debug-non-zts-20160303/ 위치에 oci8.so 가 만들어졌다.




7. MAMP php extensions에 oci8.so 추가


/Applications/MAMP/bin/php/php7.1.8/lib/php/extensions/oci8.so





8. MAMP를 재시작하고 phpinfo를 찍어본다.






9. 끝.



 





블로그 이미지

엘로드넷

,