웹해킹 테스트 게시판 만들기 - 2

게시판 필요 기능

#1. 로그인, 로그아웃, 회원가입

#2. 게시판 게시글 편집, 글 추가, 삭제, 검색, 목록

#3. 추가 기능 파일 업로드, 다운로드

#4. 테이블

-member 테이블 projMem (id, passwd, name, addDate)

-board 테이블 : projBoard (board_id, title, content, writer, writeDate, visitcount, orig_file(기존이름), save_file(저장시 이름))

#5. DB 설정

-최고 DB관리자 : SYSDBA

-일반 사용자 : projUser

-DB명: ora19c/1234

-SID : ORA19C => /app/ora19c/19c/network/admin/tnsnames.ora

-DB연결정보 String url = "jdbc:oracle:thin:@localhost:1521:ORA19C"; String id = "projUser"; String pw = "1234";

 

제일 문제가 많았던 환경구성파일

...
..
.

JAVA_HOME=/usr/local/lib/jdk-1.8.0_361
JRE_HOME=$JAVA_HOME/jre
CATALINA_HOME=/usr/local/tomcat9

CLASSPATH=$JAVA_HOME/jre/lib:$JAVA_HOME/lib/tools.jar:$CATALINA_HOME/lib-jsp-api.jar:$CATALINA_HOME/lib/servlet-api.jar

PATH=$PATH:$JAVA_HOME/bin:/bin:/sbin

export JAVA_HOME
export JRE_HOME
export CLASSPATH CATALINA_HOME
export LANG=ko_KR.UTF-8

 

bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

#oracle setup
export ORACLE_HOSTNAME=source
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_OWNER=ora19c
export ORACLE_BASE=/app/ora19c
export ORACLE_HOME=/app/ora19c/19c
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME:/usr/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ora19c
export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
 if [ $USER = "ora19c" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
   else
        ulimit -u 16384 -n 65536
   fi
 fi

~

 

톰캣 설정파일

#/etc/systemd/system/tomcat9.service

Type=forking

Environment=JAVA_HOME=/usr/local/lib/jdk1.8.0_361
Environment=CATALINA_HOME=/usr/local/tomcat9
Environment=CATALINA_BASE=/usr/local/tomcat9
Environment='CATALINA_OPTS=-Xms512M -Xmx1024M -server -XX:+UseParallelGC'
Environment='JAVA_OPTS=-Djava.awt.headless=true -Djava.security.egd=file:/dev/.$'

ExecStart=/usr/local/tomcat9/bin/startup.sh
ExecStop=/usr/local/tomcat9/bin/shutdown.sh
User=root
Group=root
RestartSec=10
Restart=always

[Install]
WantedBy=multi-user.target

 

oracle 리스너 관련

[ora19c@localhost admin]$ cat listener.ora 
# listener.ora Network Configuration File: /app/ora19c/19c/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )



[ora19c@localhost admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /app/ora19c/19c/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORA19C =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora19c)
    )
  )

LISTENER_ORA19C =
  (ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521))