자바 이야기

mi remote 호환

2022-07-02T11:03:00.004+09:00

시네아이 C55ACS mi remote: lg tv 2번째 위니아 RA-068MH 2008년 모델 mi remote: carrier 18번째

Java Web Start 이용해서 excel 실행

2022-01-27T19:48:00.002+09:00

참고사이트 https://www.baeldung.com/java-web-start https://github.com/eugenp/tutorials/tree/master/jws https://docs.oracle.com/javase/7/docs/technotes/guides/javaws/developersguide/development.html#security * 이클립스에서 dynamic web app 프로젝트 생성 * Hello 클래스 구현 -------------------------------------------------------------------------------- package com.example; import javax.swing.JFrame; import javax.swing.JLabel; public class Hello { public static void main(String[] args) throws Exception { JFrame f = new JFrame("main"); f.setSize(200, 100); f.setLocationRelativeTo(null); f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); JLabel label = new JLabel("Hello, world!"); f.add(label); f.setVisible(true); //FilePermission p = new FilePermission("<>", "execute"); Runtime.getRuntime().exec("cmd /c start excel.exe"); } } -------------------------------------------------------------------------------- * Configure > Add maven nature * pom.xml -------------------------------------------------------------------------------- '>http://maven.apache.org/xsd/maven-4.0.0.xsd"> 4.0.0 webapp webapp 0.0.1-SNAPSHOT war src maven-compiler-plugin 3.7.0 1.8 1.8 maven-war-plugin 3.0.0 WebContent org.apache.maven.plugins maven-jar-plugin compile jar com.example.Hello ${project.basedir}/WebContent -------------------------------------------------------------------------------- * servlet 관련 jar 파일 복사 아래 URL에서 jardiff.jar, jnlp-servlet.jar 파일을 받아 WEB-INF/lib에 복사 https://github.com/eugenp/tutorials/tree/master/jws/java-core-samples-lib * WEB-INF/web.xml 편집 --------------------------------------------------------------------------------

Java Web Start

JNLP Example for Java Web Start Article

JnlpDownloadServlet

jnlp.sample.servlet.JnlpDownloadServlet

JnlpDownloadServlet

*.jar

JnlpDownloadServlet

*.jnlp

index.html

-------------------------------------------------------------------------------- * WebContent 디렉토리에 index.html 파일생성 -------------------------------------------------------------------------------- Launch -------------------------------------------------------------------------------- * WebContent 디렉토리에 hello.jnlp 파일생성 -------------------------------------------------------------------------------- Hello Example

-------------------------------------------------------------------------------- * jar 파일생성: 프로젝트 우클릭 > Run As > Maven Install * jar 파일 sign cmd > cd [webapp-dir] # keytool -genkey -keystore myKeystore -alias myself # keytool -selfcert -alias myself -keystore myKeystore # keytool -list -keystore myKeystore # jarsigner -keystore myKeystore webapp-0.0.1-SNAPSHOT.jar myself * 톰켓에 Dynamic web app 프로젝트를 추가하고 시작 * http://localhost:8080/webapp/ 접속 & Launch 버튼클릭 hello.jnlp 다운로드 hello.jnpl 파일열기

이클립스 플러그인 다운로드 배치파일

2021-07-20T21:41:00.004+09:00

* eclipse.exe 디렉토리에서 실행

SET UPDATE_SITE_URL=http://www.domui.org/eclipse-updates/

SET DOWNLOAD_LOCAL_PATH=C:\java\tmp

SET ECLIPSE_HOME=.

%ECLIPSE_HOME%\eclipse.exe -application org.eclipse.equinox.p2.metadata.repository.mirrorApplication -source %UPDATE_SITE_URL% -destination %DOWNLOAD_LOCAL_PATH%

%ECLIPSE_HOME%\eclipse.exe -application org.eclipse.equinox.p2.artifact.repository.mirrorApplication -source %UPDATE_SITE_URL% -destination %DOWNLOAD_LOCAL_PATH%

Java System.currentTimeMillis()를 오라클에서

2020-08-28T13:30:00.005+09:00

select systimestamp

, to_number(sysdate - to_date('01-01-1970','DD-MM-YYYY')) * (24 * 60 * 60 * 1000) milliseconds

from dual

jcmd 사용법

2020-07-21T17:46:00.000+09:00

* jcmd 사용법
1. jcmd 실행하면 실행중인 자바 프로세스 목록 출력됨

2. jcmd <1의 PID> 명령
명령어 목록은 아래 링크 참조
https://docs.oracle.com/javase/8/docs/technotes/guides/troubleshoot/tooldescr006.html

ex. 실행중인 Jmeter의 JVM 버전확인
$ jcmd
40336 ApacheJMeter.jar

$ jcmd 40336 VM.version

log4j2 AsyncQueueFullPolicy / asyncLoggerConfigRingBufferSize 설정

2020-05-18T10:06:00.002+09:00

* log4j2.asyncQueueFullPolicy: AsyncQueueFull 상태일때 처리 클래스 지정
-Dlog4j2.asyncQueueFullPolicy= org.apache.logging.log4j.core.async.DiscardingAsyncQueueFullPolicy

DiscardingAsyncQueueFullPolicy(QueueFull 상태이면 무시), DefaultAsyncQueueFullPolicy 등을 지정하거나 AsyncQueueFullPolicy 인터페이스를 상속받아 구현한 클래스 지정가능

생성자나 상황발생시 전달되는 파라미터에 Logger나 Append 정보가 없어 어떤 Logger이나 Append 등에서 발생했는지는 확인할 수 없다. -.-

AsyncLogger, AsyncAppender에 같이 적용

* asyncLogger의 버퍼사이즈 설정, 최소값 128
-Dlog4j2.asyncLoggerConfigRingBufferSize=128

* log4j 2 configuration

https://logging.apache.org/log4j/2.x/manual/async.html

HP Notebook - 15-db1042au

2020-03-18T13:13:00.000+09:00

드라이버 다운로드

https://support.hp.com/kr-ko/drivers/selfservice/hp-15-db1000-laptop-pc/26210240/model/29678404

제품 번호	7NU48PA
제품명	HP Notebook - 15-db1042au
Microprocessor	AMD Ryzen ™ 5 3500U (Radeon ™ Vega 8 그래픽 포함) (2.1GHz 기본 클록, 최대 3.7GHz 최대 부스트 클록, 6MB 캐시, 4 코어)
Chipset	AMD 통합 SoC
Video graphics	AMD Radeon ™ Vega 8 그래픽
Hard drive	256 GB PCIe® NVMe ™ M.2 SSD
Display	15.6 "대각선 FHD IPS 눈부심 방지 마이크로 에지 WLED- 백라이트 (1920 x 1080)
네트워크 인터페이스	통합 10/100/1000 GbE LAN
확장 슬롯	멀티 포맷 SD 미디어 카드 리더기 1개
외부 포트	USB 3.1 Gen 1 Type-A 2개(데이터 전송 전용); USB 2.0 Type-A 1개(데이터 전송 전용); 1 RJ-45; 1 AC 스마트 핀; HDMI 1개; 헤드폰/마이크 콤보 1개
최소 규격(너비 x 길이 x 높이)	37.6 x 24.6 x 2.25cm
무게	최소 1.8kg
오디오 기능	듀얼 스피커

소프트웨어

Operating system	FreeDOS 1.2
HP apps	HP Audio Switch; HP 설명서; HP ePrint; HP JumpStart; HP Support Assistant
포함된 소프트웨어	McAfee LiveSafe™

MySQL 테이블 정의서 조회 쿼리

2020-03-12T15:20:00.000+09:00

SELECT
IFNULL(T2.TABLE_COMMENT, T1.TABLE_NAME) AS TABLE_COMMENT
, T1.TABLE_NAME, T1.ORDINAL_POSITION, T1.COLUMN_COMMENT
, T1.COLUMN_NAME, UPPER(T1.DATA_TYPE) AS DATA_TYPE
, (CASE T1.DATA_TYPE WHEN 'varchar' THEN T1.CHARACTER_MAXIMUM_LENGTH ELSE '' END) AS DATA_LENGTH
, (CASE T1.IS_NULLABLE WHEN 'NO' THEN 'Y' ELSE '' END) AS NOT_NULL
, (CASE T1.COLUMN_KEY WHEN 'PRI' THEN 'Y' ELSE '' END) AS IS_PK
, T1.COLUMN_DEFAULT

FROM (
SELECT
*
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'dbzimyung'
AND TABLE_NAME LIKE 'm_%'
ORDER BY TABLE_NAME ASC, ORDINAL_POSITION ASC
) T1
INNER JOIN (
SELECT
TABLE_NAME, TABLE_COMMENT
FROM `INFORMATION_SCHEMA`.`TABLES`
WHERE TABLE_NAME LIKE 'm_%'
) T2 ON T2.TABLE_NAME = T1.TABLE_NAME

MySQL schema query with comment

2020-03-12T14:51:00.004+09:00

Table

SELECT * FROM `INFORMATION_SCHEMA`.`TABLES`
WHERE TABLE_NAME LIKE 'm_%'

Column

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'dbname'
AND TABLE_NAME LIKE 'T_%'
ORDER BY TABLE_NAME ASC, ORDINAL_POSITION ASC

MySQL "The server time zone value ‘KST’ is unrecognized or represents more than one time zone" error

2020-03-12T14:45:00.001+09:00

MySQL JDBC로 접속시 아래와 같은 에러가 발생할 경우 처리

The server time zone value ‘KST’ is unrecognized or represents more than one time zone

원인
mysql-connector-java 버전 6.x 이후 버전부터는 KST 타임존을 인식하지 못하는 것으로 판단됨

해결방안1
mysql-connector-java 5.x 버전 이용 (ex. mysql-connector-java-5.1.47)

apache tomcat jre requirements

2017-09-11T10:55:00.002+09:00

http://tomcat.apache.org/whichversion.html

이클립스 버전별 JRE 요구사항

2017-09-11T10:40:00.001+09:00

출처: https://wiki.eclipse.org/Eclipse/Installation

4.7 (Oxygen)
Java 8

4.6 (Neon)
Java 8

4.5 (Mars)
Java 7

4.4 (Luna)
Java 7

4.3 (Kepler)
Java 6

FreeBSD + openjdk8 + eclipse

2016-01-08T15:14:00.000+09:00

# vi .cshrc
setenv LANG ko_KR.UTF-8
setenv LC_ALL ko_KR.UTF-8

# pkg install gnome-desktop gdm xorg xf86-video-fbdev

# vi /etc/rc.conf
gnome_enable="YES"
moused_enable="YES"
dbus_enable="YES"
hald_enable="YES"

<reboot>

# pkg install security/sudo
# visudo
alice ALL=(ALL) ALL

https://www.digitalocean.com/community/tutorials/how-to-install-and-manage-ports-on-freebsd-10-1
# sudo portsnap fetch extract
# sudo portsnap fetch update

# sudo make config fetch checksum depends extract patch configure build install

# cd /usr/ports/java && ls -d openjdk*
# sudo portmaster java/openjdk8

# pkg search openjdk
# sudo pkg install openjdk8

# pkg search eclipse
# sudo pkg install eclipse-4.5.1

아파치 에러(mod_passenger unixd_config) 처리

2015-12-15T13:08:00.002+09:00

에러내용
$ /etc/apache2# service apache2 start
* Starting web server apache2 *
* The apache2 configtest failed.
Output of config test was:
apache2: Syntax error on line 140 of /etc/apache2/apache2.conf: Syntax error on line 1 of /etc/apache2/mods-enabled/passenger.load: Cannot load /var/lib/gems/1.8/gems/passenger-4.0.46/buildout/apache2/mod_passenger.so into server: /var/lib/gems/1.8/gems/passenger-4.0.46/buildout/apache2/mod_passenger.so: undefined symbol: unixd_config
Action 'configtest' failed.
The Apache error log may have more information.

원인
Apache 2.4에서 unixd_config 이름이 ap_unixd_config 로 변경됨

해결방안
아래 바이너러를 설치하고 아파치 실행
$ apt-get install libapache2-mod-passenger

또는
./bin/passenger-install-apache2-module로 모듈 재컴파일

WindowsBuilder 설치하기

2015-12-03T15:47:00.001+09:00

SWT UI 디자인을 편하게 해주는 툴이당.
http://www.eclipse.org/windowbuilder/download.php 에서 다운로드 경로 확인
Help > Install new software 선택하고 Add 클릭한 다음 위 URL 입력
SWT Designer, WindowsBuilder Engine 체크하고 설치하기

디자인할 자바 파일을 우클릭한 다음 Open With > WindowsBuilder Editor 선택

SWT 개발환경 구축하기

2015-12-03T15:24:00.000+09:00

SWT 다운로드
http://www.eclipse.org/swt/

File > Import > General > Existing Projects into Workspace
Select archive file 선택하고 Browser 버튼을 클릭해서 다운받은 파일 지정하고 Finish 클릭

File > New > Java Project 선택하고 기타 정보를 입력한 후 프로젝트 생성
생성한 프로젝트 Properties에서 Java Build Path > Projects 선택하고 Add 버튼 클릭
org.eclipse.swt 체크하고 OK

공휴일 여부 확인 메서드 (대체공휴일 포함)

2015-12-03T13:21:00.000+09:00

package util;

import java.text.ParseException;
import java.util.Arrays;
import java.util.Calendar;
import java.util.List;

import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.time.DateFormatUtils;
import org.apache.commons.lang3.time.DateUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.ibm.icu.util.ChineseCalendar;

public class Holiday {
    static Logger logger = LoggerFactory.getLogger(Holiday.class);

    public static void main(String[] args) throws Exception {
//        long date = DateUtils.parseDate("20180507", "yyyyMMdd").getTime();
        long date = DateUtils.parseDate("20160210", "yyyyMMdd").getTime();
//        long date = DateUtils.parseDate("20171006", "yyyyMMdd").getTime();
        boolean isLegalHoliday = isLegalHoliday(date);
        boolean isWeekend = isWeekend(date);
        boolean isAlternative = isAlternative(date);
        boolean isHoliday = isHoliday(date);

        System.out.println(isLegalHoliday);
        System.out.println(isWeekend);
        System.out.println(isAlternative);
        System.out.println(isHoliday);
    }

    /**
    * 공휴일 여부
    * @param date
    */
    public static boolean isHoliday(long date) {
        return isLegalHoliday(date) || isWeekend(date) || isAlternative(date);
    }

    /**
    * 음력날짜 구하기
    * @param date
    * @return
    */
    public static String getLunarDate(long date) {
        ChineseCalendar cc = new ChineseCalendar(new java.util.Date(date));
        String m = String.valueOf(cc.get(ChineseCalendar.MONTH) + 1);
        m = StringUtils.leftPad(m, 2, "0");
        String d = String.valueOf(cc.get(ChineseCalendar.DAY_OF_MONTH));
        d = StringUtils.leftPad(d, 2, "0");

        return m + d;
    }

    /**
    * 법정휴일
    * @param date
    * @return
    */
    public static boolean isLegalHoliday(long date) {
        boolean result = false;

        String[] solar = {"0101", "0301", "0505", "0606", "0815", "1225"};
        String[] lunar = {"0101", "0102", "0408", "0814", "0815", "0816", "1231"};

        List<String> solarList = Arrays.asList(solar);
        List<String> lunarList = Arrays.asList(lunar);

        String solarDate = DateFormatUtils.format(date, "MMdd");
        ChineseCalendar cc = new ChineseCalendar(new java.util.Date(date));

//        String y = String.valueOf(cc.get(ChineseCalendar.EXTENDED_YEAR) - 2637);
        String m = String.valueOf(cc.get(ChineseCalendar.MONTH) + 1);
        m = StringUtils.leftPad(m, 2, "0");
        String d = String.valueOf(cc.get(ChineseCalendar.DAY_OF_MONTH));
        d = StringUtils.leftPad(d, 2, "0");

        String lunarDate = m + d;

        if (solarList.indexOf(solarDate) >= 0) {
            return true;
        }
        if (lunarList.indexOf(lunarDate) >= 0) {
            return true;
        }

        return result;
    }

    /**
    * 주말 (토,일)
    * @param date
    * @return
    */
    public static boolean isWeekend(long date) {
        boolean result = false;

        Calendar calendar = Calendar.getInstance();
        calendar.setTimeInMillis(date);

        //SUNDAY:1 SATURDAY:7
        int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);
        if (dayOfWeek == Calendar.SATURDAY || dayOfWeek == Calendar.SUNDAY) {
            result = true;
        }

        return result;
    }

    /**
    * 대체공휴일
    * @param date
    * @return
    */
    public static boolean isAlternative(long date) {
        boolean result = false;

        //설날 연휴와 추석 연휴가 다른 공휴일과 겹치는 경우 그 날 다음의 첫 번째 비공휴일을 공휴일로 하고, 어린이날이 토요일 또는 다른 공휴일과 겹치는 경우 그 날 다음의 첫 번째 비공휴일을 공휴일로 함
        //1. 어린이날
        String year = DateFormatUtils.format(date, "yyyy");
        java.util.Date d = null;
        try {
            d = DateUtils.parseDate(year+"0505", "yyyyMMdd");
        } catch (ParseException e) {}
        if (isWeekend(d.getTime()) == true) {
            d = DateUtils.addDays(d, 1);
        }
        if (isWeekend(d.getTime()) == true) {
            d = DateUtils.addDays(d, 1);
        }
        if (DateUtils.isSameDay(new java.util.Date(date), d) == true) {
            result = true;
        }

        //2. 설
        String lunarDate = getLunarDate(date);
        Calendar calendar = Calendar.getInstance();
        d = new java.util.Date(date);
        if (StringUtils.equals(lunarDate, "0103")) {

            d = DateUtils.addDays(d, -1);
            calendar.setTime(d);
            if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) {
                return true;
            }

            d = DateUtils.addDays(d, -1);
            calendar.setTime(d);
            if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) {
                return true;
            }

            d = DateUtils.addDays(d, -1);
            calendar.setTime(d);
            if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) {
                return true;
            }
        }

        //3. 추석
        d = new java.util.Date(date);
        if (StringUtils.equals(lunarDate, "0817")) {
            d = DateUtils.addDays(d, -1);
            calendar.setTime(d);
            if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) {
                return true;
            }

            d = DateUtils.addDays(d, -1);
            calendar.setTime(d);
            if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) {
                return true;
            }

            d = DateUtils.addDays(d, -1);
            calendar.setTime(d);
            if (calendar.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY) {
                return true;
            }
        }

        return result;
    }

}

pitftsh

2015-01-14T10:16:00.001+09:00

#!/bin/bash

# PiTFT Resistive 2.8" (PID 1601) or Capacitive 2.8" (PID 1983) setup script or Resistive 3.5" (PID 2097) or 2.2" No-Touchscreen setup script!

set -e

function cleanup() {
 if [ "${mountpoint}" != "/" ]
 then
  sudo -n umount "${mountpoint}/boot" 2> /dev/null
  sudo -n umount "${mountpoint}" 2> /dev/null
  sudo -n rmdir "${mountpoint}" 2> /dev/null < /dev/null
 fi
}

function wgetfiles() {
# grab wget images
    wget -c http://adafruit-download.s3.amazonaws.com/libraspberrypi-bin-adafruit.deb
    wget -c http://adafruit-download.s3.amazonaws.com/libraspberrypi-dev-adafruit.deb
    wget -c http://adafruit-download.s3.amazonaws.com/libraspberrypi-doc-adafruit.deb
    wget -c http://adafruit-download.s3.amazonaws.com/libraspberrypi0-adafruit.deb
    wget -c http://adafruit-download.s3.amazonaws.com/raspberrypi-bootloader-adafruit-20140917-1.deb
}

function update_etcmodules() {
 chr="$1"
 shift

 if grep -xq "spi-bcm2708" "${chr}/etc/modules" ; then
     echo "Already had spi-bcm2708"
 else
     echo "Adding spi-bcm2708"
     sudo chroot "${chr}" /bin/sh -c 'cat >> /etc/modules' <<EOF
spi-bcm2708
EOF
 fi

 if [ "${pitfttype}" == "28c" ]
     then
     if grep -xq  "i2c-bcm2708" "${chr}/etc/modules" ; then
  echo "Already had i2c-bcm2708"
     else
  echo "Adding i2c-bcm2708"
  sudo chroot "${chr}" /bin/sh -c 'cat >> /etc/modules' <<EOF
i2c-bcm2708
EOF
     fi
 fi 

 if grep -xq  "fbtft_device" "${chr}/etc/modules" ; then
     echo "Already had fbtft_device"
 else
     echo "Adding fbtft_device"
     sudo chroot "${chr}" /bin/sh -c 'cat >> /etc/modules' <<EOF
fbtft_device
EOF
 fi
}

function install_onoffbutton() {
 chr="$1"
 shift

 echo "Adding rpi_power_switch to /etc/modules"
 if grep -xq "rpi_power_switch" "${chr}/etc/modules" ; then
     echo "Already had rpi_power_switch"
 else
     echo "Adding rpi_power_switch"
     sudo chroot "${chr}" /bin/sh -c 'cat >> /etc/modules' <<EOF
rpi_power_switch
EOF
 fi

 echo "Adding rpi_power_switch config to /etc/modprobe.d/adafruit.conf"
 if grep -xq "options rpi_power_switch gpio_pin=23 mode=0" "${chr}/etc/modprobe.d/adafruit.conf" ; then
     echo "Already had rpi_power_switch config"
 else
     echo "Adding rpi_power_switch"
     sudo chroot "${chr}" /bin/sh -c 'cat >> /etc/modprobe.d/adafruit.conf' <<EOF
options rpi_power_switch gpio_pin=23 mode=0
EOF
 fi 

}

function update_x11profile() {
 chr="$1"
 shift

 echo "Moving 99-fbturbo.conf to /home/pi"
 sudo chroot "${chr}" mv /usr/share/X11/xorg.conf.d/99-fbturbo.conf /home/pi

 if grep -xq "export FRAMEBUFFER=/dev/fb1" "${chr}/home/pi/.profile" ; then
     echo "Already had 'export FRAMEBUFFER=/dev/fb1'"
 else
     echo "Adding 'export FRAMEBUFFER=/dev/fb1'"
     sudo chroot "${chr}" /bin/sh -c 'cat >> /home/pi/.profile' <<EOF
export FRAMEBUFFER=/dev/fb1
EOF
 fi
}


function update_adafruitconf() {
 chr="$1"
 shift

 if [ "${pitfttype}" == "22" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/modprobe.d/adafruit.conf' <<EOF
options fbtft_device name=adafruit22a gpios=dc:25 rotate=270 frequency=32000000
EOF
 fi
 
 if [ "${pitfttype}" == "28r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/modprobe.d/adafruit.conf' <<EOF
options fbtft_device name=adafruitrt28 rotate=90 frequency=32000000
EOF
 fi

 if [ "${pitfttype}" == "28c" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/modprobe.d/adafruit.conf' <<EOF
options fbtft_device name=adafruitct28 rotate=90 frequency=32000000
EOF
 fi

 if [ "${pitfttype}" == "35r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/modprobe.d/adafruit.conf' <<EOF
options fbtft_device name=adafruitrt35 rotate=90 frequency=32000000
EOF
 fi
}

# currently for '90' rotation only
function update_xorg() {
 chr="$1"
 shift
 sudo chroot "${chr}" mkdir -p /etc/X11/xorg.conf.d

 if [ "${pitfttype}" == "28r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/X11/xorg.conf.d/99-calibration.conf' <<EOF
Section "InputClass"
        Identifier      "calibration"
        MatchProduct    "stmpe-ts"
        Option  "Calibration"   "3800 200 200 3800"
        Option  "SwapAxes"      "1"
EndSection
EOF
 fi

 if [ "${pitfttype}" == "35r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/X11/xorg.conf.d/99-calibration.conf' <<EOF
Section "InputClass"
        Identifier      "calibration"
        MatchProduct    "stmpe-ts"
        Option  "Calibration"   "3800 120 200 3900"
        Option  "SwapAxes"      "1"
EndSection
EOF
 fi

 if [ "${pitfttype}" == "28c" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/X11/xorg.conf.d/99-calibration.conf' <<EOF
Section "InputClass"
         Identifier "captouch"
         MatchProduct "ft6x06_ts"
         Option "SwapAxes" "1"
         Option "InvertY" "1"
         Option "Calibration" "0 320 0 240"
EndSection
EOF
 fi

}

function update_udev() {
 chr="$1"
 shift
 if [ "${pitfttype}" == "28r" ] || [ "${pitfttype}" == "35r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/udev/rules.d/95-stmpe.rules' <<EOF
SUBSYSTEM=="input", ATTRS{name}=="stmpe-ts", ENV{DEVNAME}=="*event*", SYMLINK+="input/touchscreen"
EOF
 fi

 if [ "${pitfttype}" == "28c" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/udev/rules.d/95-ft6206.rules' <<EOF
SUBSYSTEM=="input", ATTRS{name}=="ft6x06_ts", ENV{DEVNAME}=="*event*", SYMLINK+="input/touchscreen" 
EOF
 fi
}

# currently for '90' rotation only
function update_pointercal() {
 chr="$1"
 shift
 if [ "${pitfttype}" == "28r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/pointercal' <<EOF
-30 -5902 22077792 4360 -105 -1038814 65536
EOF
 fi

 if [ "${pitfttype}" == "35r" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/pointercal' <<EOF
8 -8432 32432138 5699 -112 -965922 65536
EOF
 fi

 if [ "${pitfttype}" == "28c" ]
     then
     sudo chroot "${chr}" /bin/sh -c 'cat > /etc/pointercal' <<EOF
320 65536 0 -65536 0 15728640 65536
EOF
 fi
}


function success() {
 exit 0
}

function is_zip() {
 unzip -qq -l "$*" > /dev/null 2> /dev/null
}


function is_image() {
 partitions=$(($(echo p | fdisk "${imagename}" 2> /dev/null | grep "${imagename}" | wc -l) - 1))

 # We need at least two partitions
 if [ $partitions -lt 2 ]
 then
  return 1
 fi
 return 0
}

function print_version() {
 echo "Adafruit PiTFT v1.1"
 exit 1
}

function print_help() {
 echo "Usage: $0 -r [-i input-file] [-o output.img] -t [pitfttype]"
 echo "    -h            Print this help"
 echo "    -v  Print version information"
 echo "    -r            Turn the root filesystem into PiTFT compatible"
 echo "    -t [type]     Specify the type of PiTFT: '28r' (PID 1601) or '28c' (PID 1983) or '35r' or '22'"
 echo "Or, you can work on an image file:"
 echo "    -i [file]     Source Raspbian input file"
 echo "    -o [output]   Output name of image file"
 echo ""
 echo "You must specify either -r (to update this system) or -i & -o (to"
 echo "patch a fresh Raspbian image.)"
 exit 1
}

function mount_image() {
 imagename="$1"
 mountpoint="$2"
 line1=$(echo p | fdisk "${imagename}" 2> /dev/null | grep "${imagename}1")
 if [ $? -ne 0 ]
 then
  bail "Unable to read partition table from image"
 fi

 line2=$(echo p | fdisk "${imagename}" 2> /dev/null | grep "${imagename}2")
 if [ $? -ne 0 ]
 then
  bail "Unable to read partition table from image"
 fi

 vfat_offset=$(($(echo ${line1} | awk '{print $2}') * 512))
 ext_offset=$(($(echo ${line2} | awk '{print $2}') * 512))

 sudo mkdir -p "${mountpoint}" || bail "Unable to make mountpoint"
 sudo mount -oloop,offset=${ext_offset} "${imagename}" "${mountpoint}" \
  || bail "Unable to mount root filesystem"
 sudo mount -oloop,offset=${vfat_offset} "${imagename}" "${mountpoint}/boot" \
  || bail "Unable to mount root filesystem"
}

function unmount_image() {
 mountpoint="$1"
 sudo -n umount "${mountpoint}/boot" 2> /dev/null
 sudo -n umount "${mountpoint}" 2> /dev/null
 sudo -n rmdir "${mountpoint}" 2> /dev/null < /dev/null
}

group=ADAFRUIT
function info() {
 system="$1"
 group="${system}"
 shift
 FG="1;32m"
 BG="40m"
 echo -e "[\033[${FG}\033[${BG}${system}\033[0m] $*"
}

function bail() {
 FG="1;31m"
 BG="40m"
 echo -en "[\033[${FG}\033[${BG}${group}\033[0m] "
 if [ -z "$1" ]
 then
  echo "Exiting due to error"
 else
  echo "Exiting due to error: $*"
 fi
 exit 1
}

function apt_update() {
 chr="$1"
 shift
 sudo chroot "${chr}" apt-get -y update
}

function apt_install() {
 chr="$1"
 shift
 sudo chroot "${chr}" apt-get -y install $*
}


function dpkg_install_kernel() {
    chr="$1"
    shift

    cp libraspberrypi-bin-adafruit.deb libraspberrypi-dev-adafruit.deb libraspberrypi-doc-adafruit.deb libraspberrypi0-adafruit.deb raspberrypi-bootloader-adafruit-20140917-1.deb "${chr}"/tmp
    #ls -l "${chr}"/tmp
    sudo chroot "${chr}" dpkg -i -B /tmp/libraspberrypi-bin-adafruit.deb /tmp/libraspberrypi-dev-adafruit.deb /tmp/libraspberrypi-doc-adafruit.deb /tmp/libraspberrypi0-adafruit.deb /tmp/raspberrypi-bootloader-adafruit-20140917-1.deb
}

function install_console() {
    chr="$1"
    shift
    
    sudo sed -i 's/rootwait$/rootwait fbcon=map:10 fbcon=font:VGA8x8/g' "${mountpoint}/boot/cmdline.txt"
    sudo sed -i 's/BLANK_TIME=.*/BLANK_TIME=0/g' "${mountpoint}/etc/kbd/config"
}

function ask() {
# http://djm.me/ask
    while true; do
 
 if [ "${2:-}" = "Y" ]; then
     prompt="Y/n"
     default=Y
 elif [ "${2:-}" = "N" ]; then
     prompt="y/N"
     default=N
 else
     prompt="y/n"
     default=
 fi
 
# Ask the question
 read -p "$1 [$prompt] " REPLY
 
# Default?
 if [ -z "$REPLY" ]; then
     REPLY=$default
 fi
 
# Check if the reply is valid
 case "$REPLY" in
     Y*|y*) return 0 ;;
            N*|n*) return 1 ;;
 esac
    done
}

trap cleanup EXIT

echo "START"
is_zipped=0
mountpoint=/

args=$(getopt -uo 'hvri:t:o:b:' -- $*)
[ $? != 0 ] && print_help
set -- $args

for i
do
 case "$i"
 in
  -h)
   print_help
   ;;
  -v)
   print_version
   ;;
  -i)
   imagename="$2"
   echo "Image file: ${imagename}"
   if [ ! -e "${imagename}" ]
   then
    bail "Image \"${imagename}\" doesn't exist"
    
   fi

   # Determine if it's a zipfile, or a valid image file
   if is_zip "${imagename}"
   then
    info ADAFRUIT "File is zipped"
    is_zipped=1
   elif is_image "${imagename}"
   then
    info ADAFRUIT "Image file is not zipped"
    is_zipped=0
   else
    bail "Image file is not valid"
   fi
   shift
   shift
   ;;
  -o)
   pitftname="$2"
   mountpoint="/media/rpi"
   shift
   shift
   ;;
  -r)
   mountpoint="/"
   shift
   ;;
  -t)
          pitfttype="$2"
   echo "Type = ${2}"
   shift
   shift
   ;;
     
 esac
done

if [ "${mountpoint}" != "/" ] && [ -z "${imagename}" ]
then
 print_help
fi

if  [ "${pitfttype}" != "28r" ] && [ "${pitfttype}" != "28c" ] && [ "${pitfttype}" != "35r" ] && [ "${pitfttype}" != "22" ]
then
    echo "Type must be '28r' (2.8\" resistive, PID 1601) or '28c' (2.8\" capacitive, PID 1983)  or '35r' (3.5\" Resistive) or '22' (2.2\" no touch)"
    print_help
fi
# Make sure we have a job to do
if [ "${mountpoint}" != "/" ] && [ -z "${pitftname}" ]
then
 echo "Must specify output image file"
 print_help
fi

info ADAFRUIT "Starting image modification"

needs_clone=1
if [ ${is_zipped} -eq 1 ] && [ "${mountpoint}" != "/" ]
then
 extracted=$((unzip -l -qq "${imagename}" | awk '{print $4}'))
 unzip -qq "${imagename}" || bail "Unable to extract zip"
 if ! is_image "${extracted}"
 then
  rm -f "${extracted}"
  bail "Zip does not contain a valid image"
 fi
 needs_clone=0
 imagename="${extracted}"
fi


wgetfiles

if [ "${mountpoint}" != "/" ]
    then
    if [ ${needs_clone} -eq 1 ]
 then
 info PITFT "Cloning image..."
 info PITFT "---> cp ${imagename} ${pitftname}" 
 cp "${imagename}" "${pitftname}" \
     || bail "Unable to create PiTFT image"
    else
 info PITFT "Renaming image..."
 info PITFT "---> mv ${imagename} ${pitftname}" 
 mv "${imagename}" "${pitftname}" \
     || bail "Unable to rename PiTFT image"
    fi
    
    info PITFT "Mounting image..."
    mount_image "${pitftname}" "${mountpoint}" \
 || bail "Unable to mount PiTFT image"
fi

info PITFT "Updating apt cache..."

apt_update "${mountpoint}" \
    || bail "Unable to update apt cache"

# info PITFT "Slimming down image..."
# apt_cleanup "${mountpoint}" "pkgs.txt" \
#  || bail "Unable to update package list"

info PITFT "Installing Adafruit kernel..."

dpkg_install_kernel "${mountpoint}" \
    || bail "Unable to dpkg debs"

info PITFT "Updating /etc/modules..."
update_etcmodules "${mountpoint}" \
    || bail "Unable to update /etc/modules"

info PITFT "Updating /etc/modprobe.d/adafruit.conf..."
update_adafruitconf "${mountpoint}" \
    || bail "Unable to update /etc/modprobe.d/adafruit.conf"

info PITFT "Updating X11 default calibration..."
update_xorg "${mountpoint}" \
    || bail "Unable to update /etc/X11/xorg.conf.d/99-calibration.conf"

info PITFT "Updating X11 setup tweaks..."
update_x11profile "${mountpoint}" \
    || bail "Unable to update X11 setup"

info PITFT "Updating TSLib default calibration..."
update_pointercal "${mountpoint}" \
    || bail "Unable to update /etc/pointercal"

info PITFT "Updating SysFS rules for Touchscreen..."
update_udev "${mountpoint}" \
    || bail "Unable to update /etc/udev/rules.d"

info PITFT "Installing evtest tslib libts-bin..."
apt_install "${mountpoint}" evtest tslib libts-bin \
    || bail "Unable to install evtest tslib libts-bin"


# ask for console access?
if ask "Would you like the console to appear on the PiTFT display?"
    then
    info PITFT "Updating console to PiTFT..."
    install_console "${mountpoint}" \
 || bail "Unable to configure console"
fi



if [ "${pitfttype}" != "35r" ]
    then
# ask for 'on/off' button
    if ask "Would you like GPIO #23 to act as a on/off button?"
 then
 info PITFT "Adding GPIO #23 on/off to PiTFT..."
     install_onoffbutton "${mountpoint}" \
  || bail "Unable to add on/off button"
    fi
fi

if [ "${mountpoint}" != "/" ]
    then
    info PITFT "Unmounting image..."
    unmount_image "${mountpoint}"
fi

info PITFT "Done"

Install IBM Worklight Studio

2014-08-01T15:38:00.000+09:00

1. 요구사항
a. OS
Mac OS X: 10.8 or 10.9
Windows: 7 or 8
Linux: RHEL 6, SUSE 11, or Ubuntu 12.04

b. Eclipse
Eclipse IDE for Java EE Developers : Juno SR2 (4.2.2), Kepler SR1 (4.3.1), Kepler SR2 (4.3.2), or Luna R (4.4)

2. Eclipse 실행
Help > Eclipse Marketplace

3. Worklight로 검색

4. 설치
"IBM Worklight Studio"은 필수고 "IBM Dojo Mobile Tools", "IBM jQuery Mobile Tools"은 옵션

* 참고 : http://www.ibm.com/developerworks/mobile/worklight/index.html

mysql tips

2014-07-31T16:33:00.001+09:00

* 사용자 추가
CREATE DATABASE databasename;
CREATE USER 'userid'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON databasename.* TO 'userid'@'%';
CREATE USER 'userid'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON databasename.* TO 'userid'@'localhost';
flush privileges;

* table의 DB engine 변경
alter table s3board type=innodb;

Install Redmine on Ubuntu 12.04 LTS (with MyLyn and Eclipse plugins)

2014-07-16T19:33:00.002+09:00

http://ioriy2k.pe.kr/archives/4762

$ sudo apt-get install tasksel
$ sudo tasksel install lamp-server

$ sudo add-apt-repository ppa:ondrej/redmine
$ sudo apt-get update
$ sudo apt-get install redmine redmine-mysql

$ sudo ln -s /usr/share/redmine/public /var/www/redmine

$ sudo apt-get remove libapache2-mod-passenger

$ sudo gem install passenger

$ sudo apt-get install libcurl4-openssl-dev libssl-dev zlib1g-dev apache2-prefork-dev libapr1-dev libaprutil1-dev
$ sudo passenger-install-apache2-module

* 빌드후 다음과 같은 메세지가 출력되면 메모
   LoadModule passenger_module /var/lib/gems/1.8/gems/passenger-4.0.46/buildout/apache2/mod_passenger.so
   <IfModule mod_passenger.c>
     PassengerRoot /var/lib/gems/1.8/gems/passenger-4.0.46
     PassengerDefaultRuby /usr/bin/ruby1.8
   </IfModule>

$ sudo vi /etc/apache2/mods-available/passenger.load
LoadModule passenger_module /var/lib/gems/1.8/gems/passenger-4.0.46/buildout/apache2/mod_passenger.so

$ sudo vi /etc/apache2/mods-available/passenger.conf
<IfModule mod_passenger.c>
PassengerRoot /var/lib/gems/1.8/gems/passenger-4.0.46
PassengerDefaultRuby /usr/bin/ruby1.8
PassengerDefaultUser www-data
</IfModule>

$ sudo vi /etc/apache2/sites-available/default
<Directory /var/www/redmine>
    RailsBaseURI /redmine
    PassengerResolveSymlinksInDocumentRoot on
</Directory>

$ sudo a2enmod passenger
$ sudo service apache2 restart

$ sudo ufw allow 80

http://ioriy2k.pe.kr/archives/4843

$ sudo apt-get install git-core ruby-git
$ cd /usr/share/redmine
$ sudo ruby script/plugin install --force git://redmin-mylyncon.git.sourceforge.net/gitroot/redmin-mylyncon/redmine-mylyn-connector
$ sudo service apache2 restart

Subversion 특정 날짜동안 변경된 목록 조회

2014-07-03T13:21:00.003+09:00

svn diff --username <userid> --password <password> <svn_url> --summarize -r {2014-06-20}:{2014-07-02} > log.txt

[cloudv] Installing Jenkins on Ubuntu

2014-07-02T17:32:00.000+09:00

sudo apt-get install openjdk-7-jdk

wget -q -O - http://pkg.jenkins-ci.org/debian/jenkins-ci.org.key | sudo apt-key add -
sudo sh -c 'echo deb http://pkg.jenkins-ci.org/debian binary/ > /etc/apt/sources.list.d/jenkins.list'
sudo apt-get update
sudo apt-get install jenkins

* start jenkins service
sudo service jenkins start

* Change Jenkins HTTP Port
sudo vi /etc/default/jenkins
HTTP_PORT=<port>

* Open firewall using ufw
sudo ufw allow <port>

---

* set post scripts for deploy

$ sudo passwd jenkins
$ sudo vi /etc/sudoers
Defaults:jenkins !requiretty
jenkins ALL = NOPASSWD: /var/lib/jenkins/post_scripts/deploy_myapp.sh

$ sudo su - jenkins
jenkins$ mkdir /var/lib/jenkins/post_scripts
jenkins$ vi /var/lib/jenkins/post_scripts/deploy_myapp.sh
service tomcat6 stop
rm -rf /var/lib/tomcat6/webapps/huyang/
service tomcat6 start

http://localhost:8080/job/<myapp>/configure
Post Steps > Execute shell > Command
sudo /var/lib/jenkins/post_scripts/deploy_myapp.sh

[cloudv] Install subversion on ubuntu

2014-06-30T10:00:00.002+09:00

$ sudo apt-get install subversion
$ sudo svnadmin create --fs-type fsfs /var/lib/subversion
$ sudo vi /var/lib/subversion/conf/svnserve.conf
anon-access = none
auth-access = write
password-db = passwd

$ sudo vi /var/lib/subversion/conf/passwd
[users]
<id> = <password>

$ sudo svnserve -d -r /var/lib/subversion --listen-port 443

$ sudo vi /etc/rc.local
# Subversion
svnserve -d -r /var/lib/subversion --listen-port 443

$ svn mkdir --parents svn://localhost/public/trunk --username <id>
$ svn mkdir --parents svn://localhost/public/branches --username <id>
$ svn mkdir --parents svn://localhost/public/tags --username <id>

* Subversion 종료
killall svnserve

* SVN 접속확인
svn://<ip>

* start svn subversion on OS starts
$ cd /etc/init.d
$ sudo vi svnserve
svnserve -d -r /var/lib/subversion
chmod a+x ./svnserve
$ sudo update-rc.d svnserve defaults

get last modified file by pattern(wildcard)

2014-05-21T12:04:00.000+09:00

import java.io.File;

import java.io.FileFilter;

import java.util.Arrays;

import java.util.Comparator;

import org.apache.commons.io.filefilter.WildcardFileFilter;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class LastModifiedFileByPattern {

public static Logger logger = LoggerFactory.getLogger(FileFilterTest.class);

@SuppressWarnings({ "unchecked", "rawtypes" })

public static File getLastModifiedFile(File dir, String wildcard) {

File file = null;

if (dir == null || dir.isDirectory() == false) {

return null;

}

FileFilter fileFilter = new WildcardFileFilter(wildcard);

File[] files = dir.listFiles(fileFilter);

if (files == null || files.length == 0) {

return null;

}

Arrays.sort(files, new Comparator() {

public int compare(Object o1, Object o2) {

if (((File)o1).lastModified() > ((File)o2).lastModified()) {

return -1;

} else if (((File)o1).lastModified() < ((File)o2).lastModified()) {

return +1;

} else {

return 0;

}

});

file = files[0];

return file;

}

public static void main(String[] args) {

File dir = new File("/somepath/");

String wildcard = "service_*.log";

File f = getLastModifiedFile(dir, wildcard);

logger.debug(f.toString());

}