codehexa

2019년 7월 5일 금요일

Install docker(CentOS7)

[root@mail ~]# yum install -y yum-utils
Loaded plugins: auto-update-debuginfo, fastestmirror, langpacks
Determining fastest mirrors
* base: ftp.kaist.ac.kr
* extras: ftp.kaist.ac.kr
* updates: ftp.kaist.ac.kr
base-debuginfo | 2.5 kB 00:00:00
base-debuginfo/x86_64/primary_db | 2.6 MB 00:00:04
Package yum-utils-1.1.31-50.el7.noarch already installed and latest version
Nothing to do

[root@mail ~]# yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
Loaded plugins: auto-update-debuginfo, fastestmirror, langpacks
adding repo from: https://download.docker.com/linux/centos/docker-ce.repo
grabbing file https://download.docker.com/linux/centos/docker-ce.repo to /etc/yum.repos.d/docker-ce.repo
repo saved to /etc/yum.repos.d/docker-ce.repo

[root@mail ~]# yum install -y docker-ce
Loaded plugins: auto-update-debuginfo, fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: ftp.kaist.ac.kr
* extras: ftp.kaist.ac.kr
* updates: ftp.kaist.ac.kr
docker-ce-stable | 3.5 kB 00:00:00
docker-ce-stable-debuginfo | 3.5 kB 00:00:00
(1/4): docker-ce-stable/x86_64/updateinfo | 55 B 00:00:00
(2/4): docker-ce-stable/x86_64/primary_db | 29 kB 00:00:00
(3/4): docker-ce-stable-debuginfo/x86_64/updateinfo | 55 B 00:00:00
(4/4): docker-ce-stable-debuginfo/x86_64/primary_db | 6.4 kB 00:00:00
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).
--> Running transaction check
---> Package docker-ce.x86_64 3:18.09.7-3.el7 will be installed
--> Processing Dependency: container-selinux >= 2.9 for package: 3:docker-ce-18.09.7-3.el7.x86_64
--> Processing Dependency: containerd.io >= 1.2.2-3 for package: 3:docker-ce-18.09.7-3.el7.x86_64
--> Processing Dependency: docker-ce-cli for package: 3:docker-ce-18.09.7-3.el7.x86_64
--> Running transaction check
---> Package container-selinux.noarch 2:2.99-1.el7_6 will be installed
---> Package containerd.io.x86_64 0:1.2.6-3.3.el7 will be installed
---> Package docker-ce-cli.x86_64 1:18.09.7-3.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

======================================================================================================================
Package Arch Version Repository Size
======================================================================================================================
Installing:
docker-ce x86_64 3:18.09.7-3.el7 docker-ce-stable 19 M
Installing for dependencies:
container-selinux noarch 2:2.99-1.el7_6 extras 39 k
containerd.io x86_64 1.2.6-3.3.el7 docker-ce-stable 26 M
docker-ce-cli x86_64 1:18.09.7-3.el7 docker-ce-stable 14 M

Transaction Summary
======================================================================================================================
Install 1 Package (+3 Dependent packages)

Total download size: 59 M
Installed size: 243 M
Downloading packages:
(1/4): container-selinux-2.99-1.el7_6.noarch.rpm | 39 kB 00:00:00
warning: /var/cache/yum/x86_64/7/docker-ce-stable/packages/docker-ce-18.09.7-3.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID 621e9f35: NOKEY
Public key for docker-ce-18.09.7-3.el7.x86_64.rpm is not installed
(2/4): docker-ce-18.09.7-3.el7.x86_64.rpm | 19 MB 00:00:01
(3/4): containerd.io-1.2.6-3.3.el7.x86_64.rpm | 26 MB 00:00:01
(4/4): docker-ce-cli-18.09.7-3.el7.x86_64.rpm | 14 MB 00:00:00
----------------------------------------------------------------------------------------------------------------------
Total 29 MB/s | 59 MB 00:00:02
Retrieving key from https://download.docker.com/linux/centos/gpg
Importing GPG key 0x621E9F35:
Userid : "Docker Release (CE rpm) "
Fingerprint: 060a 61c5 1b55 8a7f 742b 77aa c52f eb6b 621e 9f35
From : https://download.docker.com/linux/centos/gpg
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : 2:container-selinux-2.99-1.el7_6.noarch 1/4
setsebool: SELinux is disabled.
Installing : containerd.io-1.2.6-3.3.el7.x86_64 2/4
Installing : 1:docker-ce-cli-18.09.7-3.el7.x86_64 3/4
Installing : 3:docker-ce-18.09.7-3.el7.x86_64 4/4
Verifying : 3:docker-ce-18.09.7-3.el7.x86_64 1/4
Verifying : 1:docker-ce-cli-18.09.7-3.el7.x86_64 2/4
Verifying : containerd.io-1.2.6-3.3.el7.x86_64 3/4
Verifying : 2:container-selinux-2.99-1.el7_6.noarch 4/4

Installed:
docker-ce.x86_64 3:18.09.7-3.el7

Dependency Installed:
container-selinux.noarch 2:2.99-1.el7_6 containerd.io.x86_64 0:1.2.6-3.3.el7 docker-ce-cli.x86_64 1:18.09.7-3.el7

Complete!

[root@mail ~]# systemctl start docker

[root@mail ~]# ps -ef | grep docker

root 82984 1 0 07:09 ? 00:00:00 /usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock

root 83623 69874 0 07:09 pts/0 00:00:00 grep --color=auto docker

[root@mail ~]# docker info

Containers: 0

Running: 0

Paused: 0

Stopped: 0

Images: 0

Server Version: 18.09.7

Storage Driver: overlay2

Backing Filesystem: xfs

Supports d_type: true

Native Overlay Diff: true

Logging Driver: json-file

Cgroup Driver: cgroupfs

Plugins:

Volume: local

Network: bridge host macvlan null overlay

Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog

Swarm: inactive

Runtimes: runc

Default Runtime: runc

Init Binary: docker-init

containerd version: 894b81a4b802e4eb2a91d1ce216b8817763c29fb

runc version: 425e105d5a03fabd737a126ad93d62a9eeede87f

init version: fec3683

Security Options:

seccomp

Profile: default

Kernel Version: 3.10.0-957.1.3.el7.x86_64

Operating System: CentOS Linux 7 (Core)

OSType: linux

Architecture: x86_64

CPUs: 1

Total Memory: 1.777GiB

Name: mail.naver.com

ID: 7XS6:53U6:SGZI:WRQU:QQJ4:T2W5:CRAW:JJL4:4CH4:NX3J:OF34:653B

Docker Root Dir: /var/lib/docker

Debug Mode (client): false

Debug Mode (server): false

Registry: https://index.docker.io/v1/

Labels:

Experimental: false

Insecure Registries:

127.0.0.0/8

Live Restore Enabled: false

Product License: Community Engine

[root@mail ~]# docker -v
Docker version 18.09.7, build 2d0083d

2019년 6월 13일 목요일

Mysql 재설치 오류시 참고

https://forum.ubuntu-kr.org/viewtopic.php?t=26544

2019년 1월 19일 토요일

Install rewrap on Solaris 11

sqlplus를 이용하던 중 화살표 키를 이용하여 이전 명령을 수행시

SCOTT@orcl> ^[[A^[[A^[[A 처럼 나와서 예전에 리눅스에서 사용한 rlwrap가 생각이 나서

설치를 해본다.

# pkgadd -d http://get.opencsw.org/now

# /opt/csw/bin/pkgutil -U

# /opt/csw/bin/pkgutil -y -i rlwrap

# /opt/sbin/pkgchk -L CSWrlwrap # list files // 잘 설치 되었는지 확인

출처 - https://www.opencsw.org/packages/rlwrap/

설치가 잘 되었다면

사용자 계정의 PATH에 /opt/csw/bin 을 추가한 후 사용하면 된다.

$ rlwrap sqlplus

이제 부터는 화살표 키를 이용하여 history 확인이 가능하여 이전에 입력한 명령어를
쉽게 다시 수행할 수 있다.

2018년 12월 15일 토요일

Create a scott account and sample schema in Oracle 18c

아래 내용으로 demobld.sql 파일을 생성한다.

--
-- Copyright (c) Oracle Corporation 1988, 1999.  All Rights Reserved.
--
--  NAME
--    demobld.sql
--
-- DESCRIPTION
--   This script creates the SQL*Plus demonstration tables in the
--   current schema.  It should be STARTed by each user wishing to
--   access the tables.  To remove the tables use the demodrop.sql
--   script.
--
--  USAGE
--       SQL> START demobld.sql
--
--

SET TERMOUT ON
PROMPT Building demonstration tables.  Please wait.
SET TERMOUT OFF

DROP TABLE EMP;
DROP TABLE DEPT;
DROP TABLE BONUS;
DROP TABLE SALGRADE;
DROP TABLE DUMMY;

CREATE TABLE EMP
       (EMPNO NUMBER(4) NOT NULL,
        ENAME VARCHAR2(10),
        JOB VARCHAR2(9),
        MGR NUMBER(4),
        HIREDATE DATE,
        SAL NUMBER(7, 2),
        COMM NUMBER(7, 2),
        DEPTNO NUMBER(2));

INSERT INTO EMP VALUES
        (7369, 'SMITH',  'CLERK',     7902,
        TO_DATE('17-DEC-1980', 'DD-MON-YYYY'),  800, NULL, 20);
INSERT INTO EMP VALUES
        (7499, 'ALLEN',  'SALESMAN',  7698,
        TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600,  300, 30);
INSERT INTO EMP VALUES
        (7521, 'WARD',   'SALESMAN',  7698,
        TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250,  500, 30);
INSERT INTO EMP VALUES
        (7566, 'JONES',  'MANAGER',   7839,
        TO_DATE('2-APR-1981', 'DD-MON-YYYY'),  2975, NULL, 20);
INSERT INTO EMP VALUES
        (7654, 'MARTIN', 'SALESMAN',  7698,
        TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30);
INSERT INTO EMP VALUES
        (7698, 'BLAKE',  'MANAGER',   7839,
        TO_DATE('1-MAY-1981', 'DD-MON-YYYY'),  2850, NULL, 30);
INSERT INTO EMP VALUES
        (7782, 'CLARK',  'MANAGER',   7839,
        TO_DATE('9-JUN-1981', 'DD-MON-YYYY'),  2450, NULL, 10);
INSERT INTO EMP VALUES
        (7788, 'SCOTT',  'ANALYST',   7566,
        TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20);
INSERT INTO EMP VALUES
        (7839, 'KING',   'PRESIDENT', NULL,
        TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10);
INSERT INTO EMP VALUES
        (7844, 'TURNER', 'SALESMAN',  7698,
        TO_DATE('8-SEP-1981', 'DD-MON-YYYY'),  1500,    0, 30);
INSERT INTO EMP VALUES
        (7876, 'ADAMS',  'CLERK',     7788,
        TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20);
INSERT INTO EMP VALUES
        (7900, 'JAMES',  'CLERK',     7698,
        TO_DATE('3-DEC-1981', 'DD-MON-YYYY'),   950, NULL, 30);
INSERT INTO EMP VALUES
        (7902, 'FORD',   'ANALYST',   7566,
        TO_DATE('3-DEC-1981', 'DD-MON-YYYY'),  3000, NULL, 20);
INSERT INTO EMP VALUES
        (7934, 'MILLER', 'CLERK',     7782,
        TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10);

CREATE TABLE DEPT
       (DEPTNO NUMBER(2),
        DNAME VARCHAR2(14),
        LOC VARCHAR2(13) );

INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH',   'DALLAS');
INSERT INTO DEPT VALUES (30, 'SALES',      'CHICAGO');
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');

CREATE TABLE BONUS
        (ENAME VARCHAR2(10),
         JOB   VARCHAR2(9),
         SAL   NUMBER,
         COMM  NUMBER);

CREATE TABLE SALGRADE
        (GRADE NUMBER,
         LOSAL NUMBER,
         HISAL NUMBER);

INSERT INTO SALGRADE VALUES (1,  700, 1200);
INSERT INTO SALGRADE VALUES (2, 1201, 1400);
INSERT INTO SALGRADE VALUES (3, 1401, 2000);
INSERT INTO SALGRADE VALUES (4, 2001, 3000);
INSERT INTO SALGRADE VALUES (5, 3001, 9999);

CREATE TABLE DUMMY
        (DUMMY NUMBER);

INSERT INTO DUMMY VALUES (0);

COMMIT;

SET TERMOUT ON
PROMPT Demonstration table build is complete.

EXIT

위와 같은 오류가 발생 시에는
다음을 수행해 준다.

@demobld.sql이 정상 수행되면
아래 처럼 확인하면 끝!

Solaris time synchronization

간혹 time.bora.net 이 동작을 하지 않을 때가 있는데
이럴 경우에는 # nptdate kr.pool.ntp.org 를 사용해서 시간을 동기화 해준다.

참고로 리눅스에서의 시간 관리는 이전에 작성한 내용을 참조한다.
https://codehexa.blogspot.com/2016/11/linux-rdate-date-hwclock.html

2018년 12월 9일 일요일

Applying jellybean theme Vim on Mac OS X

https://www.vim.org/scripts/script.php?script_id=2555 에서

jellybeans.vim 링크를 선택하여 해당 파일을 다운로드 한뒤

$ sudo mv jellybeans.vim /usr/share/vim/vim80/colors

수행한 뒤

사용자 홈 디렉토리에서 .vimrc파일 생성 후 아래와 같이 작성해 주면 끝

if has("syntax")

    syntax on

endif

set autoindent

set cindent

set smartindent

set ts=4

set shiftwidth=4

colorschem jellybeans

Enable sudo on Mac OS X

Mac OS X 에서 sudo 명령어를 사용하여
시스템에서 사용되는 폴더에 접근하려면 다음과 같이 해줘야 한다.

Mac OS X 부팅전에 command + R 키를 누르고 있으면 복구모드로 들어가게 된다.
복구모드에서 Terminal을 수행 후

$ csrutil disable

재부팅 후에 사용중인 사용자로 로그인 한 후에
terminal에서

$ csrutil status
System Integrity Protection status: disabled.

위 처럼 메시지가 표시되면 성공!