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

16 02 2021

Centos 7 mysql8 install

Haeng Ho Kang | DataBase, MySQL(MariaDB)

1)yum localinstall 명령어로 MySQL rpm 패키지 설치 [root@hae ~]# yum repolist enabled | grep “mysql.*-community.*” [root@hae ~]# sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Loaded plugins: fastestmirror mysql80-community-release-el7-3.noarch.rpm | 25 kB 00:00:00 Examining /var/tmp/yum-root-tl7kMk/mysql80-community-release-el7-3.noarch.rpm: mysql80-community-release-el7-3.noarch Marking /var/tmp/yum-root-tl7kMk/mysql80-community-release-el7-3.noarch.rpm to be installed Resolving Dependencies –> Running transaction check —> Package mysql80-community-release.noarch 0:el7-3 will be installed –> Finished Dependency Resolution Dependencies […]

15 02 2021

MS-SQL 축소

Haeng Ho Kang | DataBase, MS-SQL

ALTER DATABASE emudb SET RECOVERY SIMPLE DBCC SHRINKFILE(emudb_log) ALTER DATABASE emudb SET RECOVERY FULL ALTER DATABASE emudb SET RECOVERY SIMPLE DBCC SHRINKFILE(emudb) ALTER DATABASE emudb SET RECOVERY FULL

10 02 2021

Linux Centos 6 에 MySQL8 설치

Haeng Ho Kang | OS, DataBase, Linux/Unix, MySQL(MariaDB)

1) mysql 8.0 다운도르 rpm -Uvh https://repo.mysql.com/mysql80-community-release-el6-3.noarch.rpm 2)기존 받은 파일은 사용하지 않게 처리 sed -i ‘s/enabled=1/enabled=0/’ /etc/yum.repos.d/mysql-community.repo sed -i ‘s/enabled=1/enabled=0/’ /etc/yum.repos.d/mysql-community-source.repo 3)install yum –enablerepo=mysql80-community install mysql-community-server 4)Error Requires: libsasl2.so.3()(64bit) => yum whatprovides */libsasl2.so.3 Requires: libmysqlclient.so.16()(64bit) =>yum whatprovides */libmysqlclient.so.16 Requires: libstdc++.so.6(GLIBCXX_3.4.14)(64bit) =>yum whatprovides */libstdc++.so.6

10 02 2021

Linux mysql 삭제

Haeng Ho Kang | OS, DataBase, Linux/Unix, MySQL(MariaDB)

1.서비스 삭제 #chkconfig –list mysqld 2.등록한 서비스 파일 삭제 #cd /etc/init.d #rm -rf mysqld 3.설정정보삭제 # rm -rf /var/lib/mysql 4.yum 으로 설치 하지 않았다면 프로그램과 데이타파일을 직접 삭제한다.

10 02 2021

Linux Service 등록/삭제

Haeng Ho Kang | OS, Linux/Unix

서비스에 등록되어 있는 shell들은 #cd /etc/init.d 하면 확인 가능하다. chkconfig –list 를 하면 서비스에 등록한 프로그램들을 볼수 있습니다. #chkconfig –del tomcat 하면 서비스에서 삭제

3 02 2021

Apache Streaming Server Install

Haeng Ho Kang | Server, Media Server

아파치 mod_auth_token Module 설치 /app/httpd-2.2.27/bin

[root@hae install]#cd /app/install/
[root@hae install]# wget https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/mod-auth-token/mod_auth_token-1.0.5.tar.gz
[root@hae install]# tar -xvfz mod_auth_token-1.0.5.tar.gz 
[root@hae install]# cd mod_auth_token-1.0.5
[root@hae mod_auth_token-1.0.5]# rm -rf configure
[root@hae mod_auth_token-1.0.5]# autoreconf -fi
[root@hae mod_auth_token-1.0.5]#./configure --with-apxs=/app/httpd-2.2.27/bin/apxs
[root@hae mod_auth_token-1.0.5]# make
[root@hae mod_auth_token-1.0.5]# make install
[root@hae mod_auth_token-1.0.5]#cd /app/httpd-2.2.27/modules
[root@hae mod_auth_token-1.0.5]#ls
-rwxr-xr-x  1 root root   29782 Feb  3 16:35 mod_auth_token.so

[root@hae install]#cd /app/install/

[root@hae install]# wget https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/mod-auth-token/mod_auth_token-1.0.5.tar.gz

[root@hae install]# tar -xvfz mod_auth_token-1.0.5.tar.gz

[root@hae install]# cd mod_auth_token-1.0.5

[root@hae mod_auth_token-1.0.5]# rm -rf configure

[root@hae mod_auth_token-1.0.5]# autoreconf -fi

[root@hae mod_auth_token-1.0.5]#./configure --with-apxs=/app/httpd-2.2.27/bin/apxs

[root@hae mod_auth_token-1.0.5]# make

[root@hae mod_auth_token-1.0.5]# make install

[root@hae mod_auth_token-1.0.5]#cd /app/httpd-2.2.27/modules

[root@hae mod_auth_token-1.0.5]#ls

-rwxr-xr-x 1 root root 29782 Feb 3 16:35 mod_auth_token.so

위처럼 mod_auth_token.so 파일이 생성됩니다. httpd.conf에서도 mod_auth_token.so등록되어 있습니다. 아파치 H264 Module 설치 yum install gcc yum install httpd-devel

[root@hae conf]# cd /app/install/
[root@hae install]# wget http://h264.code-shop.com/download/apache_mod_h264_streaming-2.2.7.tar.gz
[root@hae install]# tar -zxvf apache_mod_h264_streaming-2.2.7.tar.gz
[root@hae install]# cd mod_h264_streaming-2.2.7/
[root@hae mod_h264_streaming-2.2.7]# ./configure --with-apxs=/app/httpd-2.2.27/bin/apxs
[root@hae mod_h264_streaming-2.2.7]# make
[root@hae mod_h264_streaming-2.2.7]# make install
[root@hae httpd-2.2.27]# cd /app/httpd-2.2.27/modules
[root@hae modules]# ls -al
-rwxr-xr-x  1 root root  277786 Feb  3 17:16 mod_h264_streaming.so

[root@hae conf]# cd /app/httpd-2.2.27/conf
[root@hae conf]# vi httpd.conf
   #Apache mod_h264 Streaming Server
    AddHandler h264-streaming.extensions .mp4

[root@hae conf]# cd /app/install/

[root@hae install]# wget http://h264.code-shop.com/download/apache_mod_h264_streaming-2.2.7.tar.gz

[root@hae install]# tar -zxvf apache_mod_h264_streaming-2.2.7.tar.gz

[root@hae install]# cd mod_h264_streaming-2.2.7/

[root@hae mod_h264_streaming-2.2.7]# ./configure --with-apxs=/app/httpd-2.2.27/bin/apxs

[root@hae mod_h264_streaming-2.2.7]# make

[root@hae mod_h264_streaming-2.2.7]# make install

[root@hae httpd-2.2.27]# cd /app/httpd-2.2.27/modules

[root@hae modules]# ls -al

-rwxr-xr-x 1 root root 277786 Feb 3 17:16 mod_h264_streaming.so

[root@hae conf]# cd /app/httpd-2.2.27/conf

[root@hae conf]# vi httpd.conf

#Apache mod_h264 Streaming Server

AddHandler h264-streaming.extensions .mp4

httpd.conf or extra/httpd-vhost.conf 편집한다.

<Location /downloads/>
# Secret key, can be anything random
 AuthTokenSecret "randomstring"
# directory to protect
 AuthTokenPrefix /downloads/
# Timeout length, this is in seconds
 AuthTokenTimeout 300
# limit requsts by IP
 AuthTokenLimitByIp off
</Location>

# Secret key, can be anything random

AuthTokenSecret "randomstring"

# directory to protect

AuthTokenPrefix /downloads/

# Timeout length, this is in seconds

AuthTokenTimeout 300

# limit requsts by IP

AuthTokenLimitByIp off

</Location>

Java 프로그램 구현 소스

String secret="randomstring";                    // Same as AuthTokenSecret 
String protectedPath="/downloads/";                   // Same as AuthTokenPrefix 
//boolean ipLimitation=false;                     // Same as AuthTokenLimitByIp 
long time= (new Date()).getTime();                // Time in decimal 
time=time/1000;                                   // timestamp of java is longer than PHP  
String hexTime =Long.toHexString(time);            // hexTime  in Hexadecimal   
String token =getMD5( (secret+ filePathName + hexTime).getBytes()); 
return protectedPath +token+"/"+hexTime+ filePathName; 
 
 
public String getMD5(byte[] source) { 
        String s = null; 
        char hexDigits[] = {  
        '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',   'e', 'f' }; 
        try { 
                java.security.MessageDigest md = java.security.MessageDigest 
                                .getInstance("MD5"); 
                md.update(source); 
                byte tmp[] = md.digest(); 
                char str[] = new char[16 * 2]; 
                int k = 0;  
                for (int i = 0; i < 16; i++) {  
                        byte byte0 = tmp[i];  
                        str[k++] = hexDigits[byte0 >>> 4 & 0xf];  
                        str[k++] = hexDigits[byte0 & 0xf]; 
                } 
                s = new String(str);  
        } catch (Exception e) { 
                e.printStackTrace(); 
        } 
        return s; 
}

String secret="randomstring"; // Same as AuthTokenSecret

String protectedPath="/downloads/"; // Same as AuthTokenPrefix

//boolean ipLimitation=false; // Same as AuthTokenLimitByIp

long time= (new Date()).getTime(); // Time in decimal

time=time/1000; // timestamp of java is longer than PHP

String hexTime =Long.toHexString(time); // hexTime in Hexadecimal

String token =getMD5( (secret+ filePathName + hexTime).getBytes());

return protectedPath +token+"/"+hexTime+ filePathName;

public String getMD5(byte[] source) {

String s = null;

char hexDigits[] = {

'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f' };

try {

java.security.MessageDigest md = java.security.MessageDigest

.getInstance("MD5");

md.update(source);

byte tmp[] = md.digest();

char str[] = new char[16 * 2];

int k = 0;

for (int i = 0; i < 16; i++) {

byte byte0 = tmp[i];

str[k++] = hexDigits[byte0 >>> 4 & 0xf];

str[k++] = hexDigits[byte0 & 0xf];

}

s = new String(str);

} catch (Exception e) {

e.printStackTrace();

}

return s;

}

2 11 2020

FLAC -> m4a 일괄변경

Haeng Ho Kang | Mac OS

음악을 iphone 으로 옮길때 아주 유용한 팁입니다. homebrew 를 통해 명령 행 도구 ffmpeg를 설치하십시오 . 다음을 사용하여 M4A (iTunes에서 지원)의 단일 파일을 Apple Lossless Audio Codec (ALAC)로 변환 할 수 있습니다.

ffmpeg -i input.flac -c:a alac output.m4a

1 2	ffmpeg -i input.flac -c:a alac output.m4a

다음을 사용하여 디렉토리의 모든 파일을 수행 할 수 있습니다.

for f in ./*; do ffmpeg -i "$f" -c:a alac "${f%.*}.m4a"; done

1 2	for f in ./; do ffmpeg -i "$f" -c:a alac "${f%.}.m4a"; done

다음을 사용하여 모든 파일을 재귀 적으로 ( *.flac현재 디렉토리 및 모든 하위 디렉토리에서) 수행 […]

12 09 2020

AWS 설정시 도움을 주는 Youtube

Haeng Ho Kang | AWS

AWS Route 53 https://www.youtube.com/playlist?list=PLuHgQVnccGMCas8a4f0uIg5X4uERoG6gb AWS Elastic Beanstalk + Route 53 https://www.youtube.com/watch?v=BeOKTpFsuvk AWS CloudFront 클라우드 프런트생성

10 04 2020

MariaDB MySQL datatype

Haeng Ho Kang | DataBase, MySQL(MariaDB)

[숫자형 데이터 타입] 데이터 타입 의미 크기 설명 TINYINT 매우 작은 정수 1 byte -128 ~ 127 (부호없이 0 ~ 255) SMALLINT 작은 정수 2 byte -32768 ~ 32767 MEDIUMINT 중간 크기의 정수 3 byte –(-8388608) ~ -1(8388607) INT 표준 정수 4 byte – 범위 : -2147483648 에서 2147483647 (UNSIGNED 일 경우 0 에 4294967295) – 주의 […]

16 03 2020

Oracle Lock 제거 및 Connection Pool 관련

Haeng Ho Kang | DataBase, Oracle

1.DB Conneciton Pool 관련 Pool조회 select * from v$resource_limit where resource_name in (‘processes’, ‘sessions’); Sessions 접속 정보 쿼리 SELECT username, program FROM v$session; 접속 사용자 제거

--alter system kill session 'session_id,serial#';
alter system kill session '32,11234';

1 2	--alter system kill session 'session_id,serial#'; alter system kill session '32,11234';

현재 Connection Pool 사용현황

SELECT  * 
  FROM  V$resource_limit 
 WHERE   resource_name IN ('processes','sessions');

SELECT *

FROM V$resource_limit

WHERE resource_name IN ('processes','sessions');

접속이 안되는 경우 INACTIVE 갯수가 많을 경우 삭제 하면 됨

SELECT  'alter system kill session ''' || sid || ',' || serial# || ''' immediate;'
  FROM  v$session
 WHERE  username = 'NURIWARE'
   AND  status = 'INACTIVE'

SELECT 'alter system kill session ''' || sid || ',' || serial# || ''' immediate;'

FROM v$session

WHERE username = 'NURIWARE'

AND status = 'INACTIVE'

나오는 결과를 아래처럼 실행

alter system kill session '13,46763';
alter system kill session '29,30175';
alter system kill session '39,21235';
alter system kill session '43,53103';
alter system kill session '45,40359';
alter system kill session '46,50781';
alter system kill session '62,65397';
alter system kill session '71,15497';
alter system kill session '256,13051';
alter system kill session '262,14689';

alter system kill session '13,46763';

alter system kill session '29,30175';

alter system kill session '39,21235';

alter system kill session '43,53103';

alter system kill session '45,40359';

alter system kill session '46,50781';

alter system kill session '62,65397';

alter system kill session '71,15497';

alter system kill session '256,13051';

alter system kill session '262,14689';

2.DB Lock 관련 lock 조회

SELECT  DO.OBJECT_NAME, DO.OWNER, DO.OBJECT_TYPE, DO.OWNER,

        VO.XIDUSN, VO.SESSION_ID, VO.LOCKED_MODE

FROM    V$LOCKED_OBJECT VO, DBA_OBJECTS DO

WHERE   VO.OBJECT_ID = DO.OBJECT_ID;

SELECT DO.OBJECT_NAME, DO.OWNER, DO.OBJECT_TYPE, DO.OWNER,

VO.XIDUSN, VO.SESSION_ID, VO.LOCKED_MODE

FROM V$LOCKED_OBJECT VO, DBA_OBJECTS DO

WHERE VO.OBJECT_ID = DO.OBJECT_ID;

[…]

Previous Posts Next posts