스프링필드 에버그린테라스 742

유니코드값을 구글에 조회하면 hex값은 쉽게얻을수있음.

U+200B의 HEX값은 'e2808b' 이다.

SELECT mail_user_seq, common_stat_seq, common_stat_content 

FROM wcf_common_stat 

WHERE mail_user_seq='166' AND common_stat_content like concat("%", UNHEX('e2808b'), "%");

SELECT mail_user_seq, common_stat_seq, REPLACE(common_stat_content, UNHEX('e2808b'), '[[[200B]]]') 

FROM wcf_common_stat 

WHERE mail_user_seq='166' AND common_stat_content like concat("%", UNHEX('e2808b'), "%");

UPDATE wcf_common_stat 

SET common_stat_content=REPLACE(common_stat_content, UNHEX('e2808b'), '') 

WHERE mail_user_seq='166' AND common_stat_content like concat("%", UNHEX('e2808b'), "%");

SQL> select tablespace_name from dba_tablespaces;

SQL> create tablespace luuaz_tabspace

  2  datafile 'luuaz_tabspace.dat'

  3  size 10M autoextend on;

SQL> create user luuaz

  2  identified by 1234

  3  default tablespace luuaz_tabspace

SQL> GRANT connect, resource TO luuaz;

SQL> GRANT unlimited tablespace TO luuaz;

# sqlplus luuaz/1234@XE

# rpm -qa | grep oracle

# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm

# rpm -e oracle-xe-11.2.0-1.0.x86_64

의존성문제가 있을경우 

# rpm -e oracle-xe-11.2.0-1.0.x86_64 --nodeps

여러개의 패키지 문제는

# rpm -e oracle-xe-11.2.0-1.0.x86_64 --nodeps --allmatches

LoadModule rewrite_module modules/mod_rewrite.so

<IfModule mod_rewrite.c>

Options +MultiViews

RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-d

RewriteCond %{REQUEST_FILENAME} !-f

RewriteRule ^([^\.]+)$ $1.php [NC,L]

</IfModule>

<tr class="dept-data-row">

$("#searchDeptText").keyup(function() {

var data = this.value.split(" ");

if(this.value=="") {

$(".dept-data-row").show();

return;

}

$(".dept-data-row").hide();

$(".dept-data-row").filter(function (i, v) {

var $t = $(this);

 for (var d = 0; d < data.length; ++d) {

if ($t.is(":contains('" + data[d] + "')")) {

 return true;

}

}

return false;

}).show();

});

private static final Logger logger = Logger.getLogger(MongoInsertTest.class.getName());

private FileHandler fileHandler;

try {

fileHandler = new FileHandler(System.currentTimeMillis()+MongoInsertTest.class.getName()+".log");

// 모든레벨의 로그를 출력한다.

LogRecord logRecord = new LogRecord(Level.ALL, "");

// 내용만 출력하도록 포맷을 재설정한다.

Formatter formatter = new Formatter() {

@Override

public String format(LogRecord record) {

String message = formatMessage(record);

message += "\n";

return message;

}

};

formatter.formatMessage(logRecord);

// 핸들러에 Formatter를 설정한다.

fileHandler.setFormatter(formatter);

} catch (SecurityException e) {

logger.log(Level.SEVERE, null, e);

} catch (IOException e) {

logger.log(Level.SEVERE, null, e);

}

logger.addHandler(fileHandler);

logger.info( 내용 );

function changeSerialize(values,k,v) {

var found = false;

for (i = 0; i < values.length && !found; i++) {

if (values[i].name == k) { 

values[i].name = v;

found = true;

}

}

if(!found) {

values.push(

{

name: k,

value: v

}

);

}

return values;

}

var formData = $("#form아이디").serializeArray();

formData=changeSerialize(formData,"변경대상KEY","변경대상VALUE");

* 방법1: 소프트웨어센터에서 libsvn-java 검색후 설치방법

* 방법2: apt-get을 이용해 설치

~$ sudo apt-get install libsvn-java

~$ sudo find / -name "libsvnjavahl*"

/usr/lib/x86_64-linux-gnu/jni/libsvnjavahl-1.so.0.0.0

/usr/lib/x86_64-linux-gnu/jni/libsvnjavahl-1.so.0

/usr/lib/x86_64-linux-gnu/jni/libsvnjavahl-1.so

위치는 /usr/lib/x86_64-linux-gnu/jni

-Djava.library.path=라이브러리경로(여기서는 /usr/lib/x86_64-linux-gnu/jni )

예시

~$ vi eclipse.ini

.....

....

....

-vmargs

-Djava.library.path=/usr/lib/x86_64-linux-gnu/jni

-Dosgi.requiredJavaVersion=1.6

-XX:MaxPermSize=256m

-Xms40m

-Xmx512m

* Help > Install new software 

* subclipse - http://subclipse.tigris.org/update_1.10.x  추가 및 설치

   (최신주소는 http://subclipse.tigris.org 요기서 확인!!)

* 이클립스 재시작

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | latin1                     |

| character_set_connection | latin1                     |

| character_set_database   | utf8                       |

| character_set_filesystem | binary                     |

| character_set_results    | latin1                     |

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

| collation_connection     | latin1_swedish_ci          |

| collation_database       | utf8_general_ci            |

| collation_server         | utf8_general_ci            |

| completion_type          | 0                          |

| concurrent_insert        | 1                          |

| connect_timeout          | 10                         |

+--------------------------+----------------------------+

[client]

..

..

default-character-set = utf8

[mysqld]

..

..

init_connect = SET collation_connection = utf8_general_ci

init_connect = SET NAMES utf8

character-set-server = utf8

collation-server = utf8_general_ci

[mysqldump]

..

..

default-character-set = utf8

[mysql]

..

..

default-character-set = utf8

mysql> show variables like 'c%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | utf8                       |

| character_set_connection | utf8                       |

| character_set_database   | utf8                       |

| character_set_filesystem | binary                     |

| character_set_results    | utf8                       |

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

| collation_connection     | utf8_general_ci            |

| collation_database       | utf8_general_ci            |

| collation_server         | utf8_general_ci            |

| completion_type          | 0                          |

| concurrent_insert        | 1                          |

| connect_timeout          | 10                         |

+--------------------------+----------------------------+

Duplicate id @+id/image, already defined earlier in this layout

Issue: Checks for duplicate ids within a single layout

Id: DuplicateIds

Within a layout, id's should be unique since otherwise findViewById() can return an unexpected view.

[]

# sudo mkdir /etc/vsftpd

# sudo vi vusers.txt

# db_load -T -t hash -f vusers.txt virtual-user.db

# chmod 600 virtual-user.db

# 포트변경

listen_port=2121

# 패시브설정

pasv_enable=YES

pasv_min_port=5001

pasv_max_port=5050

anonymous_enable=NO

local_enable=YES

# Virtual users will use the same privileges as local users.

# It will grant write access to virtual users. Virtual users will use the

# same privileges as anonymous users, which tends to be more restrictive

# (especially in terms of write access).

virtual_use_local_privs=YES

write_enable=YES

# Set the name of the PAM service vsftpd will use

pam_service_name=vsftpd.virtual

# Activates virtual users

guest_enable=YES

# Automatically generate a home directory for each virtual user, based on a template.

# For example, if the home directory of the real user specified via guest_username is

# /home/virtual/$USER, and user_sub_token is set to $USER, then when virtual user vivek

# logs in, he will end up (usually chroot()'ed) in the directory /home/virtual/vivek.

# This option also takes affect if local_root contains user_sub_token.

user_sub_token=$USER

# Usually this is mapped to Apache virtual hosting docroot, so that

# Users can upload files

local_root=/home/vftp/$USER

# Chroot user and lock down to their home dirs

chroot_local_user=YES

chroot_list_enable=NO

# Hide ids from user

hide_ids=YES

# sudo vi /etc/pam.d/vsftpd.virtual

~$ sudo apt-cache search PACKAGE_NAME

~$ sudo apt-cache show PACKAGE_NAME

~$ sudo apt-get install PACKAGE_NAME

※ 재설치는

~$ sudo apt-get --reinstall install PACKAGE_NAME

~$ sudo apt-get remove PACKAGE_NAME

※ 설정파일까지 모두 제거할때는

~$ sudo apt-get purge PACKAGE_NAME

(1) 패키지 인덱스정보를 먼저 업데이트해야함.(오류시 저장소변경은 알아서~)

~$ sudo apt-get update

~$ sudo dpkg -l PACKAGE_NAME

※ 패키지명 정규표현식에 따른 검색은

~$ sudo dpkg -l | grep -i "PACKAGE_NA*"

~$ sudo dpkg -i PACKAGE_FILE_NAME(ex: oracle.deb)

~$ sudo dpkg -r PACKAGE_NAME

$ mysqladmin -u root -p 

$ mysql -u root 

mysql> use mysql;

mysql> update user set password=password('새로운패스워드') where user='root';

mysql> flush privileges;

mysql> quit;

* 계정 생성

mysql> create user 생성아이디@localhost identified by '새비밀번호';

mysql> create user 생성아이디@'%' identified by '새비밀번호';

* 계정 삭제

drop user 삭제할아이디@localhost;

drop user 삭제할아이디@'%';

* DB생성

mysql> create database 새로운데이터베이스명;

mysql> create schema 디비명 default character set utf8;

* DB삭제

mysql> drop database DB이름;

mysql> GRANT ALL PRIVILEGES ON 데이터베이스이름.* TO 계정아이디@localhost identified by '계정비밀번호';

mysql> GRANT ALL PRIVILEGES ON 데이터베이스이름.* TO 계정아이디@'%' identified by '계정비밀번호';

모든권한부여

GRANT ALL PRIVILEGES ON *.* TO 계정아이디@'%' WITH GRANT OPTION; (IP예: '192.168.1.%')

LoadModule auth_digest_module modules/mod_auth_digest.so

LoadModule dav_module modules/mod_dav.so

LoadModule dav_fs_module modules/mod_dav_fs.so

LoadModule dav_lock_module modules/mod_dav_lock.so

.....

Include conf/extra/httpd-dav.conf

.....

커맨드(cmd)명령창 C:\apache2.2 디렉토리 위치에서..

apache2.2> bin\htdigest -c 파일명 AuthName 아이디

사용예)  bin\htdigest.exe -c WEBDAV_USER WEBDAV_LUUAZ luuaz

- AuthName은 httpd-dav.conf설정할때 필요하며, 로그인시 표시됨.(이름표붙인다고 생각하면됨)

-  -c옵션은 최초생성할때옵션이다. 두번째아이디생성부터 -c옵션을 붙이면안되며, 

   붙일시 기존에 생성했던 아이디는 다 없어집니다.

- 암호변경: -c옵션을 제거하고 동일한 명령을 내리면 암호를 변경함.

* 그룹은 메모장이나 에디터로 수동으로 생성하면 된다.

  (ex: WEBDAV_GROUP으로 생성)

admins: luuaz

users: simpsons tvg test

- admins와 users의 그룹을 만들고 각사용자를 그룹으로 추가함.(구분자는 공백)

* 이 예제는 H드라이브를 /home으로 지정합니다.

* admins그룹은 읽기/쓰기/수정권한을 모두주며 그외는 읽기권한만 줍니다.

# Alias를 설정합니다. H드라이브를  /home으로 연결합니다.

Alias /home "H:/"  

<Directory "F:/">

Dav On

Order Allow,Deny

# 내부네트워크에서만 공유할시

# Allow from 192.168.0.0/16 127.0.0.1  형식으로!

Allow from all

# AuthType은 Digest인증으로 변경하고 AuthName으로 webdav이름을 설정합니다.

AuthType Digest

AuthName WEBDAV_LUUAZ

# 이전단계에서 생성한 user와 group파일경로를 설정합니다.

AuthUserFile "C:/Apache2.2/WEBDAV_USER"

AuthGroupFile "C:/Apache2.2/WEBDAV_GROUP"

AuthDigestProvider file

# FollowSymLinks는 리눅스에 심볼릭링크용으로 사용하며 (윈도우는 뭔짓을해도 사용불가, 사용할수 있는 방법이 있으면 알려주세요)

Options FollowSymLinks Indexes

# !!읽기 권한설정!! 읽기권한을 설정합니다.

<Limit HEAD GET OPTIONS PROPFIND>

# Require valid-user로 하면 사용가능한 유저에게 모두 부여합니다.

Require user luuaz

</Limit>

# 쓰기권한설정!! admins그룹만 허용합니다.

# 아래 Limit부분은 예제용이며

# <LimitExcept HEAD GET OPTIONS PROPFIND>과 동일합니다.

<Limit POST MKCOL PUT DELETE LOCK UNLOCK COPY MOVE PROPPATCH>

Require group admins

</Limit>

</Directory>

* httpd.conf에서...

Listen 8822

...

ServerName 127.0.0.1:8822

...

* 보안을 위해 최상위경로(/)의 파일인덱스권한을 없앤다.

* httpd.conf -> <Directory /> 에서...

Options에있는 Indexes 제거

* httpd.conf에서 주석해제

Include conf/extra/httpd-autoindex.conf

bin> openssl req -config ../conf/openssl.cnf -new -out test.csr -keyout test.pem

Loading 'screen' into random state - done

Generating a 1024 bit RSA private key

.....................................................++++++

...........................................++++++

writing new private key to 'foo.pem'

Enter PEM pass phrase: PASSWORD입력

Verifying - Enter PEM pass phrase: PASSWORD다시입력

-----

You are about to be asked to enter information that will be incorporated

into your certificate request.

What you are about to enter is what is called a Distinguished Name or a DN.

There are quite a few fields but you can leave some blank

For some fields there will be a default value,

If you enter '.', the field will be left blank.

-----

Country Name (2 letter code) [AU]:KO

State or Province Name (full name) [Some-State]:SEOUL

Locality Name (eg, city) []:SEOUL

Organization Name (eg, company) [Internet Widgits Pty Ltd]:Luuaz

Organizational Unit Name (eg, section) []: 

Common Name (e.g. server FQDN or YOUR name) []:서버도메인(일치하지않으면 경고)

Email Address []:관리자이메일

Please enter the following 'extra' attributes

to be sent with your certificate request

A challenge password []: 공백으로남겨둠

An optional company name []:공백으로남겨둠

bin> openssl rsa -in test.pem -out test.key

   ~~~~~~ 암호입력

bin> openssl x509 -in test.csr -out test.crt -req -signkey test.key -days 3650(유효기간은 마음대로~)

LoadModule ssl_module modules/mod_ssl.so

.....

Include conf/extra/httpd-ssl.conf

.....

# 포트변경

Listen 8823

.....

# 인증서경로 설정

SSLCertificateFile "C:/Apache2.2/conf/luuaz.crt"

SSLCertificateKeyFile "C:/Apache2.2/conf/luuaz.key"

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteCond %{HTTPS} !on

RewriteRule .* https://%{SERVER_NAME}:8823%{REQUEST_URI} [R,L]

</IfModule>

# sudo apt-get install --no-install-recommends xubuntu-desktop

sudo apt-get install --no-install-recommends \

       xubuntu-desktop \

       xfce4-terminal \

       xfce4-power-manager \

       xfce4-volumed \

       xfce4-indicator-plugin \

       xfce4-datetime-plugin \

       xfce4-cpugraph-plugin \

       xfce4-netload-plugin \

       xfce4-screenshooter \

       xfce4-xkb-plugin \

       xubuntu-icon-theme \

       xfwm4-themes \

       alacarte \

       pavucontrol \

       file-roller \

       plymouth-theme-xubuntu-logo \

       mousepad \

       gvfs-fuse \

       thunar-archive-plugin \

       catfish \

       indicator-sound-gtk2

sudo apt-get install --no-install-recommends \

       davfs2 encfs rar libnotify-bin iw gparted vim \

       ntp htop cifs-utils ethtool

# indicator-keylock

sudo add-apt-repository ppa:tsbarnes/indicator-keylock && sudo apt-get update

sudo apt-get install indicator-keylock

sudo apt-get install --no-install-recommends \

       network-manager-gnome iptables iproute \

       mobile-broadband-provider-info usb-modeswitch modemmanager ppp comgt

~$ cat /etc/network/interfaces

# This file describes the network interfaces available on your system

# and how to activate them. For more information, see interfaces(5).

# The loopback network interface

auto lo

iface lo inet loopback

# The primary network interface

#auto wlan0

#iface wlan0 inet dhcp

# wpa-ssid AAAAAAAAAAAAAAAAAAAAAA

# wpa-psk  12341234

~$ sudo apt-get install blueman

~$ ibus-setup

~$ ibus restart

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/i8042prt/Parameters

<body id="if_notice" style="background:transparent" >

<iframe ...........................  allowTransparency="true">

<button type="button" class="my_value" name="domainbtn" id="domainbtn"><span id="domainBtnName">JAEWOONG</span>

</button>

<ul>

<li><a href="javascript:changeDomain('<%=vDomain%>')"><%=vDomain %></a></li>      

</ul>

<button type="button" class="my_value" name="domainbtn" id="domainbtn" onclick="javascript:openDomain()"><span id="domainBtnName">JAEWOONG</span>

</button>

<ul  id="domain_ul" >

<li> ......

function openDomain() {

var ul_obj = document.getElementById("domain_ul");

if (ul_obj.className == "open" ) {

ul_obj.className="";

} else {

ul_obj.className="open";

}

}

hadoop dfsadmin -safemode leave

# tar cvfzp 압축파일명 --exclude=제외할디렉토리경로 압축대상경로

sub db_connect($$$$)

{

    my ($DB_SID, $DB_USER, $DB_PASSWD, $DB_SYSTEM) = @_;

    my $dbh = "";

    my $dsn = "";

    eval {

        $SIG{ALRM} = sub { die "$!"; };

        alarm(2);

        if ($DB_SYSTEM eq "oracle") {

            $dsn = "DBI:Oracle:$DB_SID";

        }

        elsif ($DB_SYSTEM eq "mysql") {

            $dsn = "DBI:mysql:database=$DB_SID";

        }

        else {

            $dsn = "DBI:Pg:dbname=$DB_SID;host=localhost";

        }

        $dbh = DBI->connect($dsn,

                            $DB_USER,

                            $DB_PASSWD,

                            {RaiseError => 1,AutoCommit => 0,PrintError => 1});

        alarm(0);

    };

    if ($@) {

        warn "DBI->connect() timeout";

        warn $@;

        $dbh = undef;

    }

    if (! $dbh) {

        warn "DBI->connect() failed: $!";

        return undef;

    }

    return $dbh;

}

sub trim($)

{

    my ($str) = @_;

    $str =~ s/^\s+//g;

    $str =~ s/\s+$//g;

    return $str;

}