(주)누리웨어 | 화상연동/Web,APP 구축및서비스/LMS/평생교육/학점은행/기업교육/연수관리/설문구축/

3 08 2019

Centos 7 Maven Install

Haeng Ho Kang | OS, Linux/Unix

CentOS 7 maven 설치 1. 다운로드 $ cd 다운로드 위치 $ wget http://www.gtlib.gatech.edu/pub/apache/maven/maven-3/3.6.1/binaries/apache-maven-3.6.1-bin.tar.gz $ sudo tar xzf apache-maven-3.6.1-bin.tar.gz 2. 전역 환경 설정 $ sudo vi /etc/profile.d/maven.sh export M2_HOME=/xxxx/apache-maven-3.6.1 export PATH=${M2_HOME}/bin:${PATH} $ source /etc/profile.d/maven.sh 3. 버젼 확인 $ mvn -version Apache Maven 3.6.1 (d66c9c0b3152b2e69ee9bac180bb8fcc8e6af555; 2019-04-05T04:00:29+09:00) Maven home: /xxxx/apache-maven-3.6.1 Java version: 1.8.0_212, vendor: Oracle Corporation, runtime: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.212.b04-0.el7_6.x86_64/jre Default […]

11 06 2019

IOS, Android 앱스토어 업로드 필수 파일 및 정보

Haeng Ho Kang | Programming, Swift, Android | 0

앱스토어에 올리때 필요한 내용을 정리를 하지 않으니 올릴때 마다 실수를 하게 됩니다. 다음과 같이 필수 사항들을 정리합니다. IOS가 까다롭습니다. Android는 왠만큼 다 됩니다. 앱의 미리보기 10개: 6.5형, 5.5형 12.9형만 필수입니다, 그외(4.7, 4, 3.5형, 11형)는 선택입니다. 반드시 이것들(4.7,3.5,11형)등도 미리보기를 올리셔야 할경우는 해당하는 사이즈 가 있어야 함 IOS 미리보기 사이즈 확인 경로- https://help.apple.com/app-store-connect/#/devd274dd925 앱의 미리보기화면을 가공 : 순수한 […]

27 05 2019

SmartEditor 한페이지에서 여러개 사용할 경우

Haeng Ho Kang | Programming | 0

https://blog.naver.com/qfwh/220731562463 http://www.ministory.net/xe/?mid=it_story&page=1&category=6555&document_srl=47293 사진 업로드 https://decameron.tistory.com/82

10 05 2019

Microsoft SQL Server . id 열의 명시적 값은 열 목록이 사용되고 identity_insert가 on일 때만 지정할 수 있습니다.

Haeng Ho Kang | DataBase, MS-SQL | 0

1. indentity에 insert를 하겠다는 명령어 실행

SET IDENTITY_INSERT tb_sys_log_login ON

1	SET IDENTITY_INSERT tb_sys_log_login ON

2.명령어 실행(주의할점 칼럼을 반드시 써주어야 한다: 아마 identity의 칼럼때문인것 같다).

insert into tb_aaa(
SN
,CONECT_IP
,CONECT_DT)
select

SN
,CONECT_IP
,CONECT_DT from TB_aaa_2018

insert into tb_aaa(

,CONECT_IP

,CONECT_DT)

select

,CONECT_IP

,CONECT_DT from TB_aaa_2018

3.Identity에 insert를 이제 안하겠다 실행

SET IDENTITY_INSERT tb_sys_log_login OFF

1	SET IDENTITY_INSERT tb_sys_log_login OFF

3 05 2019

eclipse javadoc

Haeng Ho Kang | Programming, Java | 0

1)javadoc 메뉴에서 project>Generate Javadoc 또는 프로젝트를 선택후 export를 클릭하고 javadoc 선택합니다. 여기서는 project>Generate Javadoc를 이용해서 처리하면 순서로 처리하면 java document를 얻을수 있다.

11 02 2019

Jenkins / Nexus Setting

Haeng Ho Kang | Server | 0

Jenkins Install – https://nesoy.github.io/articles/2017-02/Jenkins Nexus Install – https://blog.kingbbode.com/posts/nexus-3xx-maven-npm Nexus 3.xx실행 1) run run으로 실행 시에는 현재 shell 상에서 구동되므로 shell을 종료 하거나 CTOL-C를 클릭하여 종료 할 수 있다. 윈도우: 명령 프롬프트 상에서 실행 c:/nexus/nexus-3.11.0-01/bin/nexus.exe /run 리눅스: ./nexus run 2) start/stop 백그라운드로 실행 시에는 다음과 깉이 start 명령을 사용하고 종료 시에는 stop 명령을 사용한다. 윈도우: […]

28 01 2019

FCM – Setting

Haeng Ho Kang | Programming, Swift | 0

1.developer.apple.com 에서 Keys에서 생성한 Keys 는 FCM에서 인증으로 사용한다. 하나의 ApnKey 를 만들어서 *. p8 를 다운로드 받아 놓는다 파일을 가지고 있다가 FCM> Cloud Messaging에서 APN 인증 키를 넣는데 사용

APN  인증키와  키 ID /   팀 ID(Account> Members 에 있음)

1	APN 인증키와 키 ID / 팀 ID(Account> Members 에 있음)

로 인증해야 PUSH를 사용할수 있다.

30 10 2018

Oracle impdp

Haeng Ho Kang | DataBase, Oracle | 0

일부 테이블만 의 경우 먼저 Directory Dump를 만든다.

SQL> CREATE DIRECTORY KWCYBERDUMP AS '/./../kwcyber';

Directory created.

SQL> GRANT read,write on directory KWCYBERDUMP to 오라클계정;

Grant succeeded.

SQL> CREATE DIRECTORY KWCYBERDUMP AS '/./../kwcyber';

Directory created.

SQL> GRANT read,write on directory KWCYBERDUMP to 오라클계정;

Grant succeeded.

oracle$]impdp 오라클계정/패스워드@SID directory=KWCYBERDUMP dumpfile=file.dmp tables=tu_progress_log table_exists_action=append;

1	oracle$]impdp 오라클계정/패스워드@SID directory=KWCYBERDUMP dumpfile=file.dmp tables=tu_progress_log table_exists_action=append;

Import: Release 11.2.0.1.0 - Production on Tue Oct 30 17:57:25 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "계정"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "계정"."SYS_IMPORT_TABLE_01": 계정/********@SID  directory=KWCYBERDUMP dumpfile=file.dmp tables=tu_progress_log table_exists_action=append
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39152: Table "계정"."TU_PROGRESS_LOG" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "계정"."TU_PROGRESS_LOG" 541.8 MB 5260803 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "계정"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 17:59:32

Import: Release 11.2.0.1.0 - Production on Tue Oct 30 17:57:25 2018

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "계정"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded

Starting "계정"."SYS_IMPORT_TABLE_01": 계정/********@SID directory=KWCYBERDUMP dumpfile=file.dmp tables=tu_progress_log table_exists_action=append

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39152: Table "계정"."TU_PROGRESS_LOG" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "계정"."TU_PROGRESS_LOG" 541.8 MB 5260803 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "계정"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 17:59:32

11 09 2018

Mac host 변경

Haeng Ho Kang | OS, Mac OS | 0

1. 터미널을 엽니다. 2. 호스트 파일을 엽니다. 명령어는 “sudo vi /private/etc/hosts” 이며, 비밀번호를 입력합니다. 3. #으로 시작하는 부분에 입력을 하면 됩니다. 기존에 있던 127.0.0.1 – localhost 아래에 입력하시면 됩니다. 방향키를 이용해 이동이 가능합니다.

##
# Host Database
#
# localhost is used to configure the loopback interface
# when the system is booting. Do not change this entry.
##
127.0.0.1 localhost
255.255.255.255 broadcasthost
::1 localhost
fe80::1%lo0 localhost
127.0.0.1 dev.vgk-smartcampus.com
127.0.0.1 dev.ekicte.or.kr
127.0.0.1 dev.new.cylearn.co.kr

# Host Database

# localhost is used to configure the loopback interface

# when the system is booting. Do not change this entry.

127.0.0.1 localhost

255.255.255.255 broadcasthost

::1 localhost

fe80::1%lo0 localhost

127.0.0.1 dev.vgk-smartcampus.com

127.0.0.1 dev.ekicte.or.kr

127.0.0.1 dev.new.cylearn.co.kr

4. :wq로 저장한다. 5. 재부팅을 하셔도 되지만, “dscacheutil -flushcache”명령어를 이용해 바로 적용이 가능합니다.

3 08 2018

CentOS – How to set SWAP Memory

Haeng Ho Kang | OS, Linux/Unix | 0

[root@nuriware bin]# dd if=/dev/zero of=/root/swapfile bs=1024 count=5000000

5000000+0 records in

5000000+0 records out

5120000000 bytes (5.1 GB) copied, 25.8677 s, 198 MB/s

[root@nuriware bin]# dd if=/dev/zero of=/root/swapfile bs=1024 count=5000000

5000000+0 records in

5000000+0 records out

5120000000 bytes (5.1 GB) copied, 25.8677 s, 198 MB/s

[root@nuriware bin]# chmod 600 /root/swapfile

1	[root@nuriware bin]# chmod 600 /root/swapfile

[root@nuriware bin]# mkswap /root/swapfile

mkswap: /root/swapfile: warning: don't erase bootbits sectors

        on whole disk. Use -f to force.

Setting up swapspace version 1, size = 4999996 KiB

no label, UUID=ad13ad1b-8f68-42f9-affe-0556f9541342

[root@nuriware bin]# mkswap /root/swapfile

mkswap: /root/swapfile: warning: don't erase bootbits sectors

on whole disk. Use -f to force.

Setting up swapspace version 1, size = 4999996 KiB

no label, UUID=ad13ad1b-8f68-42f9-affe-0556f9541342

[root@nuriware bin]# swapon /root/swapfile

1	[root@nuriware bin]# swapon /root/swapfile

[root@nuriware bin]# swapon /root/swapfile

[root@nuriware bin]# free -m

             total       used       free     shared    buffers     cached

Mem:         32080      31722        357       8371        329      12158

-/+ buffers/cache:      19234      12845

Swap:         4882          0       4882

[root@nuriware bin]# swapoff /root/swapfile

[root@nuriware bin]# free -m

             total       used       free     shared    buffers     cached

Mem:         32080      31729        350       8371        330      12158

-/+ buffers/cache:      19241      12838

Swap:            0          0          0

[root@nuriware bin]# swapon /root/swapfile

[root@nuriware bin]# free -m

total used free shared buffers cached

Mem: 32080 31722 357 8371 329 12158

-/+ buffers/cache: 19234 12845

Swap: 4882 0 4882

[root@nuriware bin]# swapoff /root/swapfile

[root@nuriware bin]# free -m

total used free shared buffers cached

Mem: 32080 31729 350 8371 330 12158

-/+ buffers/cache: 19241 12838

Swap: 0 0 0

swap delete

[root@nuriware bin]# swapoff /root/swapfile

[root@nuriware bin]# free -m

             total       used       free     shared    buffers     cached

Mem:         32080      31729        350       8371        330      12158

-/+ buffers/cache:      19241      12838

Swap:            0          0          0

[root@nuriware bin]# rm /root/swapfile

rm: remove 일반 파일 `/root/swapfile'? y

[root@nuriware bin]#

[root@nuriware bin]# swapoff /root/swapfile

[root@nuriware bin]# free -m

total used free shared buffers cached

Mem: 32080 31729 350 8371 330 12158

-/+ buffers/cache: 19241 12838

Swap: 0 0 0

[root@nuriware bin]# rm /root/swapfile

rm: remove 일반 파일 `/root/swapfile'? y

[root@nuriware bin]#

reboot : setting

[root@nuriware bin]# vi /etc/rc.local

1	[root@nuriware bin]# vi /etc/rc.local

#!/bin/sh

#

# This script will be executed *after* all the other init scripts.

# You can put your own initialization stuff in here if you don't

# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

swapon /root/swapfile

#!/bin/sh

# This script will be executed *after* all the other init scripts.

# You can put your own initialization stuff in here if you don't

# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

swapon /root/swapfile

Previous Posts Next posts