bluemix에 faro oracle 이미지 올리기

PS C:\Users\myung> cf ic namespace get

paul001

PS C:\Users\myung> cf ic cpi human537/faro-oracle-xe-11g registry.ng.bluemix.net/paul001/farodb

pool is not available on Windows"

Sending build context to Docker daemon 2.048 kB

Step 1 : FROM human537/faro-oracle-xe-11g

latest: Pulling from human537/faro-oracle-xe-11g

8aec416115fd: Pull complete

695f074e24e3: Pull complete

946d6c48c2a7: Pull complete

bc7277e579f0: Pull complete

2508cbcde94b: Pull complete

0f39b2269587: Pull complete

72a6f16c5b79: Pull complete

c99f725b2c54: Pull complete

Digest: sha256:359591dc5e272652f844d3e45bb1057db0d2b37983acab6b6a4c1db2083d0677

Status: Downloaded newer image for human537/faro-oracle-xe-11g:latest

 ---> 65990f33eee1

Successfully built 65990f33eee1

The push refers to a repository [registry.ng.bluemix.net/paul001/farodb]

e6953f5a85ec: Pushed

6736e6f4038d: Pushed

000db08ae46d: Pushed

5eb5bd4c5014: Pushed

d195a7a18c70: Pushed

af605e724c5a: Pushed

59f161c3069d: Pushed

4f03495a4d7d: Pushed

latest: digest: sha256:b8ebc1817ce370e18697809f43d45b0a9565cbf923a31fe4d7936aada967846f size: 1996

SECURITY WARNING: You are building a Docker image from Windows against a non-Windows Docker host. All files and directories added to build context will have '-rwxr-xr-x' permissions. It is recommended to double check and reset permissions for sensitive files and

directories.

PS C:\Users\myung> cf ic run -d -p 49160:22 -p 49161:1521 -e ORACLE_ALLOW_REMOTE=true --name farodb registry.ng.bluemix.net/paul001/farodb

time="2017-04-06T01:04:03+09:00" level=info msg="Unable to use system certificate pool: crypto/x509: system root pool is not available on Windows"

6d56bcfa-8f7e-4de3-84ee-4792e406dc39

$ cf ic ip request

OK

The IP address "169.46.29.61" was obtained.

SDS@SDS-PC C:\Users\SDS

$ cf ic ip bind 169.46.29.61 farodb

OK

The IP address was bound successfully.

[SSH접속]

root / admin

Connecting to 169.46.28.116:22...

Connection established.

To escape to local shell, press 'Ctrl+Alt+]'.

Welcome to Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-45-generic x86_64)

 * Documentation:  https://help.ubuntu.com

 * Management:     https://landscape.canonical.com

 * Support:        https://ubuntu.com/advantage

Last login: Sun Apr  2 15:17:05 2017 from 172.17.0.1

root@instance-0055fecc:~# ll

total 40

drwx------  5 root root 4096 Apr  2 14:44 ./

drwxr-xr-x 22 root root 4096 Apr  5 16:08 ../

-rw-------  1 root root 2075 Apr  2 16:14 .bash_history

-rw-r--r--  1 root root 3106 Oct 22  2015 .bashrc

drwx------  2 root root 4096 Apr  1 16:48 .cache/

-rw-r--r--  1 root root  148 Aug 17  2015 .profile

-rw-------  1 root root 3338 Apr  2 14:16 .viminfo

-rw-r--r--  1 root root   26 Apr  2 09:24 afiedt.buf

drwxr-xr-x  4 root root 4096 Apr  2 13:15 faro_sql/

drwxr-xr-x  3 root root 4096 Apr  1 16:18 oradiag_root/

[Oracle DB 접속]

sds / sds

[이클립스에 Faro 올리기]

1. Import > Exsiting projects into workspace 

2. ISDP-master.zip 선택

3. applicationContext-datasource.xml 을 아래로 갈아끼기

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:jdbc="http://www.springframework.org/schema/jdbc"

xmlns:util="http://www.springframework.org/schema/util"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/jdbc

http://www.springframework.org/schema/jdbc/spring-jdbc.xsd

http://www.springframework.org/schema/util

http://www.springframework.org/schema/util/spring-util-4.0.xsd">

<bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">

<property name="driverClass" value="#{comProps['datasource.driverClass']}" />

<property name="jdbcUrl" value="#{comProps['datasource.jdbcUrl']}" />

<property name="username" value="#{comProps['datasource.username']}" />

<property name="password" value="#{comProps['datasource.password']}" />

<property name="logStatementsEnabled" value="true" />

</bean>

<util:list id="databaseScriptsList" value-type="org.springframework.core.io.Resource">

</util:list>

<bean id="dataSourceInitializer" class="org.springframework.jdbc.datasource.init.DataSourceInitializer">

<property name="dataSource" ref="dataSource" />

<property name="databasePopulator">

<bean class="org.springframework.jdbc.datasource.init.ResourceDatabasePopulator">

<property name="scripts" ref="databaseScriptsList" />

<property name="sqlScriptEncoding" value="UTF-8" />

<property name="ignoreFailedDrops" value="true" />

</bean>

</property>

</bean>

<bean id="messageSource" class="com.sds.faro.common.context.support.DatabaseDrivenMessageSource" depends-on="dataSourceInitializer">

<constructor-arg index="0" ref="com.sds.faro.admin.messagemgn.service.MessageService" />

<constructor-arg index="1" ref="com.sds.faro.admin.language.service.LanguageMgnService" />

<constructor-arg index="2" value="#{comProps['defaultLang']}" />

</bean>

</beans>

4. pom.xml을 아래로 주석처리

<!-- <repository>

<id>anyframe-ui</id>

<url>http://70.121.224.52:8081/nexus/content/repositories/anyframe-java-commercial/</url>

<releases>

<enabled>true</enabled>

</releases>

<snapshots>

<enabled>true</enabled>

<updatePolicy>always</updatePolicy>

</snapshots>

</repository> -->

<!-- <dependency>

<groupId>aui-fileuploader</groupId>

<artifactId>aui-fileuploader</artifactId>

<version>1.0.0</version>

</dependency> -->

5. comm.properties

아래로 대체

#****** H2 sample **************************************************************

#datasource.driverClass=org.h2.Driver

#datasource.jdbcUrl=jdbc:h2:~/.adminPortal/h2

#datasource.username=ADMIN_PORTAL

#datasource.password=ENC(LSW+1di4okO990/POg+HYQ==)

#datasource.sql.path.ddl=classpath:/sql/ddl/oracle

#datasource.sql.path.initdata=classpath:/sql/initdata/oracle

#datasource.sql.path.mybatis=classpath:/sql/mybatis/oracle/**/*-mybatis.xml

#****** Oracle sample **********************************************************

datasource.driverClass=oracle.jdbc.driver.OracleDriver

datasource.jdbcUrl=jdbc:oracle:thin:@169.46.29.61:1521:XE

datasource.username=sds

datasource.password=sds

datasource.sql.path.ddl=classpath:/sql/ddl/oracle

datasource.sql.path.initdata=classpath:/sql/initdata/oracle

datasource.sql.path.mybatis=classpath:/sql/mybatis/oracle/**/*-mybatis.xml