{
"editor.suggestSelection": "first",
"vsintellicode.modify.editor.suggestSelection": "automaticallyOverrodeDefaultValue",
"workbench.colorTheme": "Material Theme Darker High Contrast",
"workbench.iconTheme": "eq-material-theme-icons",
"editor.formatOnSave": true,
"javascript.preferences.quoteStyle": "single",
"typescript.preferences.quoteStyle": "single",
"editor.tabSize": 2,
"liveServer.settings.donotVerifyTags": true,
"liveServer.settings.donotShowInfoMsg": true,
"security.workspace.trust.untrustedFiles": "open",
"files.exclude": {
"**/.git": false
},
"git.autofetch": true,
"terminal.integrated.defaultProfile.windows": "Git Bash",
"terminal.integrated.automationShell.linux": "",
"terminal.integrated.automationShell.windows": "",
"terminal.integrated.profiles.windows": {
"PowerShell": {
"source": "PowerShell",
"icon": "terminal-powershell"
},
"Command Prompt": {
"path": [
"${env:windir}\\Sysnative\\cmd.exe",
"${env:windir}\\System32\\cmd.exe"
],
"args": [],
"icon": "terminal-cmd"
},
"Git Bash": {
"source": "Git Bash"
}
}
}
http://temp.repia.com/dhan/openapiclient-0.0.1-SNAPSHOT.jar.gz
TB_ORGAN CREATE CACHED TABLE "PUBLIC"."TB_ORGAN"( "OFCFS_CODE" VARCHAR(16), "OFCPS_NM" VARCHAR(100), "DEPT_CODE" VARCHAR(16), "DEPT_NM" VARCHAR(100), "USER_NM" VARCHAR(100), "OFFM_TELNO" VARCHAR(32), "EMAIL" VARCHAR(100), "JOB_DC" CLOB, "ORDR" NUMBER );
java -Dlogback.configurationFile=resources/logback.xml -cp .:./resources/ -jar openapiclient-0.0.1-SNAPSHOT.jar HRD ORGAN refresh
#----------------------------------------------------------------------- # api.properties : 시스템 #----------------------------------------------------------------------- # 1. key = value 구조입니다. # 2. key값은 공백문자를 포함불가, value값은 공백문자를 가능 # 3. key값으로 한글을 사용불가, value값은 한글사용이 가능 # 4. 줄을 바꿀 필요가 있으면 '\'를 라인의 끝에 추가(만약 '\'문자를 사용해야 하는 경우는 '\\'를 사용) # 5. Windows에서의 디렉토리 표시 : '\\' or '/' ('\' 사용하면 안됨) # 6. Unix에서의 디렉토리 표시 : '/' # 7. 주석문 처리는 #사용 # 8. value값 뒤에 스페이스가 존재하는 경우 서블릿에서 참조할때는 에러발생할 수 있으므로 trim()하거나 마지막 공백없이 properties 값을 설정할것 #----------------------------------------------------------------------- database.type=h2 database.driver=org.h2.Driver database.jdbcurl=jdbc:h2:tcp://127.0.0.1:9092/~/rsa41 database.user=sa database.password=fpvldk!@# ORGAN.table=TB_ORGAN
logback.xml <?xml version="1.0" encoding="UTF-8"?> <!-- [Layout] %m : 로그내용이 출력 %p : trace > debug > info > warn > error 등의 priority 출력 %r : 어플리케이션이 시작되어 로깅이벤트가 발생하는 시점까지의 경과시간을 밀리세컨드로 출력 %c : 예) 카테고리가 a.b.c 처럼 되어있다면 %c{2}는 b.c가 출력됩니다. %n : 플랫폼 종속적인 개행문자가 출력된다. \r\n 또는 \n 일것이다 %d : 로깅이벤트가 일어나 날짜 출력 ( 프로그램의 실행속도를 느리게 한다.) 예) %d{HH:mm:ss} 또는 %d{dd MMMM yyyy HH:mm:ss} %C : 호출자의 클래스명 출력 예) 클래스구조가 org.apache.xyz.SomeClass 처럼 되어있다면 %C{2}는 xyz.SomeClass 가 출력됩니다 %M : 로깅이 발생한 method 이름을 나타냅니다. %F : 로깅이 발생한 프로그램 파일명을 나타냅니다. %l : 로깅이 발생한 caller의 정보를 나타냅니다 %L : 로깅이 발생한 caller의 라인수를 나타냅니다 %x : 로깅이 발생한 thread와 관련된 NDC(nested diagnostic context)를 출력합니다. %X : 로깅이 발생한 thread와 관련된 MDC(mapped diagnostic context)를 출력합니다. %% : % 표시를 출력하기 위해 사용한다. %t : 로그이벤트가 발생된 쓰레드의 이름을 출력합니다 --> <configuration scan="true" scanPeriod="30 seconds"> <appender name="ROLLING" class="ch.qos.logback.core.rolling.RollingFileAppender"> <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> <!-- rollover daily --> <fileNamePattern>logs/openapiclient-%d{yyyy-MM-dd}.%i.log.zip</fileNamePattern> <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP"> <!-- or whenever the file size reaches 100MB --> <maxFileSize>100MB</maxFileSize> </timeBasedFileNamingAndTriggeringPolicy> </rollingPolicy> <encoder> <pattern>%d{HH:mm:ss.SSS} %-5level %logger{36} - %msg%n</pattern> </encoder> </appender> <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender"> <layout class="ch.qos.logback.classic.PatternLayout"> <Pattern>%d{HH:mm:ss.SSS} [%-5level] - %msg%n</Pattern> </layout> </appender> <!-- Loggers --> <logger name="org.apache.catalina" level="ERROR"> </logger> <logger name="org.apache.commons" level="ERROR"> </logger> <logger name="org.springframework" level="DEBUG" > </logger> <logger name="java.sql" level="DEBUG"> </logger> <logger name="org.mybatis.spring" level="DEBUG"> </logger> <root level="ERROR"> <appender-ref ref="ROLLING"/> <appender-ref ref="STDOUT" /> </root> </configuration>
rssStatus.sh #!/bin/sh trim() { echo $1; } RSS_ROOT="/app/search/RSA" echo ""; EXE_NAME="전자사전 관리데몬" EXE_FILE="DIC_MGR" PID_FILE="${RSS_ROOT}/logs/dic_mgr.pid" if [ -f ${PID_FILE} ] then echo -n ""; #echo "${PID_FILE} exist!" else echo "${PID_FILE} not exist!" fi PID=$(trim `cat $PID_FILE`) RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') if [ ${PID} -eq ${RUN_PID} ] then echo " * ${EXE_NAME}(${EXE_FILE}:${PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="전자사전" EXE_FILE="DicSvr" PID_FILE="${RSS_ROOT}/logs/dic.pid" if [ -f ${PID_FILE} ] then echo -n ""; #echo "${PID_FILE} exist!" else echo "${PID_FILE} not exist!" fi PID=$(trim `cat $PID_FILE`) RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') if [ ${PID} -eq ${RUN_PID} ] then echo " * ${EXE_NAME}(${EXE_FILE}:${PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="질의어 처리기 관리데몬" EXE_FILE="QP_MGR" PID_FILE="${RSS_ROOT}/logs/qp_mgr.pid" if [ -f ${PID_FILE} ] then echo -n ""; #echo "${PID_FILE} exist!" else echo "${PID_FILE} not exist!" fi PID=$(trim `cat $PID_FILE`) RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') if [ ${PID} -eq ${RUN_PID} ] then echo " * ${EXE_NAME}(${EXE_FILE}:${PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="질의어 처리기" EXE_FILE="QuerySvr" PID_FILE="${RSS_ROOT}/logs/1.pid" if [ -f ${PID_FILE} ] then echo -n ""; #echo "${PID_FILE} exist!" else echo "${PID_FILE} not exist!" fi PID=$(trim `cat $PID_FILE`) RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') if [ ${PID} -eq ${RUN_PID} ] then echo " * ${EXE_NAME}(${EXE_FILE}:${PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="스케줄러" EXE_FILE="RSS_DAEMON" PID_FILE="${RSS_ROOT}/logs/rssd.pid" if [ -f ${PID_FILE} ] then echo -n ""; #echo "${PID_FILE} exist!" else echo "${PID_FILE} not exist!" fi PID=$(trim `cat $PID_FILE`) RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') if [ ${PID} -eq ${RUN_PID} ] then echo " * ${EXE_NAME}(${EXE_FILE}:${PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="관리자 서비스" EXE_FILE="rssAdmMgr" PID_FILE="${RSS_ROOT}/logs/rssAdmMgr.pid" if [ -f ${PID_FILE} ] then echo -n ""; #echo "${PID_FILE} exist!" else echo "${PID_FILE} not exist!" fi PID=$(trim `cat $PID_FILE`) RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') if [ ${PID} -eq ${RUN_PID} ] then echo " * ${EXE_NAME}(${EXE_FILE}:${PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="부가기능 서비스" EXE_FILE="org.h2.tools.Server" PID_FILE="${RSS_ROOT}/logs/db.pid" RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') #echo ${RUN_PID} if [ "" != "${RUN_PID}" ] then echo " * ${EXE_NAME}(${EXE_FILE}:${RUN_PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi EXE_NAME="검색어 자동완성" EXE_FILE="AutoCompleteServer.jar" PID_FILE="${RSS_ROOT}/logs/AutoComplete.pid" RUN_PID=$(ps ax |grep ${EXE_FILE} |grep -v grep|awk '{print $1}') #echo ${RUN_PID} if [ "" != "${RUN_PID}" ] then echo " * ${EXE_NAME}(${EXE_FILE}:${RUN_PID})"; else echo " * ${EXE_NAME}(${EXE_FILE}:Dead)"; fi echo -e "\n\n";
backup_daily.sh #!/bin/sh datetime=$(date +%Y%m%d) datetimeAgo=`date +%Y%m%d --date '30 days ago'` echo "cd /app/search/RSA/bin" cd /app/search/RSA/bin echo "./RssConfBackup /app/search/RSA" ./RssConfBackup /app/search/RSA 1>/dev/null echo "cd /app/search/RSA/backup/$datetime" cd /app/search/RSA/backup/$datetime #echo "mysqldump -u search -psearch12#$ AD > AD_$datetime.sql" #mysqldump -u search -psearch12#$ AD > AD_$datetime.sql echo "cd .." cd .. echo "tar cvf ./hrd176_$datetime.tar.gz ./$datetime" tar cfz ./hrd176_$datetime.tar.gz ./$datetime #echo "cp -f ./hrd176_$datetime.tar.gz /data/backup" #cp -f ./hrd176_$datetime.tar.gz /data/backup/ #echo "rm -rf ./hrd176_$datetime" #rm -rf ./$datetime echo "rm -rf ./hrd176_$datetimeAgo.tar.gz" rm -rf ./hrd176_$datetimeAgo.tar.gz #echo "rm -rf /data/backup/hrd176_$datetimeAgo.tar.gz" #rm -rf /data/backup/hrd176_$datetimeAgo.tar.gz #echo "cp -f /app/search/RSA/bin/html/js/* /data/bin/html/js" #cp -f /app/search/RSA/bin/html/js/* /data/bin/html/js echo "cp -Rf /app/search/RSA/conf/* /data/conf" #cp -Rf /app/search/RSA/conf/* /data/conf #echo "cp -f /app/search/RSA/logs/front/search_log/logAnal.out /data/logs/front/search_log" #cp -f /app/search/RSA/logs/front/search_log/logAnal.out /data/logs/front/search_log #echo "cp -f /app/search/RSA/logs/front/statistics_log/favor* /data/logs/front/statistics_log" #cp -f /app/search/RSA/logs/front/statistics_log/favor* /data/logs/front/statistics_log
backup_lmonthly.sh #!/bin/sh datetime=$(date +%Y%m%d) datemonthAgo=`date +%Y%m --date '150 days ago'` datemonth=$(date +%Y%m) echo "cd /app/search/RSA/backup" cd /app/search/RSA/backup echo "cp hrd176_$datetime.tar.gz hrd176_$datemonth.tar.gz" cp hrd176_$datetime.tar.gz hrd176_$datemonth.tar.gz 1>/dev/null 2>/dev/null echo "rm -rf hrd176_$datemonthAgo.tar.gz" rm -rf hrd176_$datetimeAgo.tar.gz
crontab 내용 # Recommend Dictionary update 0 5 * * * /app/search/RSA/bin/acsctl.sh restart # Real-time favorite keyword 0 * * * * /app/search/RSA/bin/realRank.sh # # backup script #30 6 * * * /app/search/RSA/bin/backup_ldaily.sh 0 9 * * 7 /app/search/RSA/bin/apispider/apiSpider.sh 0 7 1 * * /app/search/RSA/bin/backup_lmonthly.sh