IT 관련 포스팅

God Mode.{ED7BA470-8E54-465E-825C-99712043E01C} 폴더 바탕화면 생성 

LOW=低  작게
HiGH=高  크게
Non＝無し 음소거

compile : 기본 scope. 컴파일 할 때 필요

runtime : 컴파일시에는 필요하지 않지만 런타임에 필요. 배포시 포함.

provided : 컴파일 할 때 필요하지만, 컨테이너 등에서 기본으로 제공되는 모듈임을 의미(에를들면 servlet-api.jar 같은...) 배포시에 제외됨.

test : 테스트 단계에 필요. 배포시 제외

모듈 다운로드

curl -O http://archive.apache.org/dist/tomcat/tomcat-connectors/jk/tomcat-connectors-1.2.41-src.tar.gz

[root@nhisct src]# tar -xvf tomcat-connectors-1.2.42-src.tar.gz

[root@nhisct src]# cd tomcat-connectors-1.2.42-src/

[root@nhisct tomcat-connectors-1.2.42-src]# cd native/

[root@nhisct native]# ls

BUILDING.txt  README.txt  aclocal.m4  buildconf.sh  configure.ac  netscape

Makefile.am   STATUS.txt  apache-1.3  common        docs          scripts

Makefile.in   TODO.txt    apache-2.0  configure     iis

[root@nhisct native]#

[root@nhisct native]# ./buildconf.sh

buildconf: checking installation...

buildconf: autoconf not found.

           You need autoconf version 2.59 or newer installed

           to build mod_jk from SVN.

[root@nhisct native]# ./configure --with-apxs=/usr/bin/apxs

/usr/bin/apxs 없는경우 ( /usr/sbin/apxs 이거나 httpd-devel 설치 안된경우일수 있음)

httpd

httpd-tools

httpd-devel

[root@nhisct native]# make

[root@nhisct native]# make install

[root@nhisct native]# cd /etc/httpd/conf.modules.d/

[root@nhisct conf.modules.d]# vi 00-jk.conf

LoadModule jk_module modules/mod_jk.so

[root@nhisct httpd]# cd /etc/httpd/conf.d/

[root@nhisct conf.d]# vi httpd-jk.conf

<IfModule jk_module>

    # We need a workers file exactly once

    # and in the global server

    JkWorkersFile conf.d/workers.properties

    JkLogStampFormat "[%a %b %d %H:%M:%S %Y] "

    # Our JK error log

    # You can (and should) use rotatelogs here

    JkLogFile logs/mod_jk.log

    # Our JK log level (trace,debug,info,warn,error)

    JkLogLevel info

    # Our JK shared memory file

    JkShmFile logs/mod_jk.shm

    # If you want to put all mounts into an external file

    # that gets reloaded automatically after changes

    # (with a default latency of 1 minute),

    # you can define the name of the file here.

    JkMountFile conf.d/uriworkermap.properties

</IfModule>

[root@nhisct conf.d]# vi workers.properties

worker.list=tomcat1,tomcat2

worker.tomcat1.port=8080

worker.tomcat1.host=localhost

worker.tomcat1.type=ajp13

#worker.tomcat1.lbfactor=1

#worker.tomcat2.port=8081

#worker.tomcat2.host=localhost

#worker.tomcat3.type=ajp13

#workes.tomcat3.lbfactor=1

[root@nhisct conf.d]# vi uriworkermap.properties

/*=tomcat1

#/*.jsp=tomcat2

#/*.png=tomcat3

#/*.css=tomcat4

ex) http://localhost/test/test.jsp

request.getContextPath()   return /test

request.getRequestURI()  return /test/test.jsp

request.getRequestURL() return http://localhost/test/test.jsp

request.ServletPath()  return /test.jsp

request.getRealPath("")  return null or c:/www/webapps/test

host = url.replace(uri,"").replace(contextPath,"");    return http://localhost

remoteAddr = request.getRemoteAddr();            remoteAddr(ex. 0.0.0.0)

svn,apache  설정이 완료되어 있는경우

추가로   ssl 관련 설정을 할수 있으면 centos7 에는  apache ssl 관련 설정이 미리 되어 있는경우가 있습니다.

import java.awt.Color;

import java.awt.Font;

import java.awt.FontMetrics;

import java.awt.Graphics2D;

import java.awt.Image;

import java.awt.RenderingHints;

import java.awt.font.FontRenderContext;

import java.awt.font.LineMetrics;

import java.awt.geom.Rectangle2D;

import java.awt.image.BufferedImage;

import java.io.File;

import java.io.IOException;

import java.util.HashMap;

import javax.imageio.ImageIO;

import org.apache.log4j.Logger;

public class ImageUtil {

public final static Logger LOG = Logger.getLogger(ImageUtil.class);

public static final HashMap<RenderingHints.Key, Object> RenderingProperties = new HashMap<>();

static{

    RenderingProperties.put(RenderingHints.KEY_TEXT_ANTIALIASING, RenderingHints.VALUE_TEXT_ANTIALIAS_ON);

    RenderingProperties.put(RenderingHints.KEY_STROKE_CONTROL, RenderingHints.VALUE_STROKE_PURE);

    RenderingProperties.put(RenderingHints.KEY_FRACTIONALMETRICS, RenderingHints.VALUE_FRACTIONALMETRICS_ON);

}

public static BufferedImage textToImage(int width,int height,String Text, Font f, float Size,String fileName,boolean isFile) throws IOException{

    //Derives font to new specified size, can be removed if not necessary.

  try{

double size = height/3;

if(width>height) size = height/3;

else size =width/3;

if(size<1) size =1;

if(f == null) f  = new Font("Arial", Font.PLAIN, (int) size);

    f = f.deriveFont((float)size);

    FontRenderContext frc = new FontRenderContext(null, true, true);

    //Calculate size of buffered image.

    //LineMetrics lm = f.getLineMetrics(Text, frc);

    LOG.debug("textToImage...2 "+frc.toString());

    char[] array = Text.toCharArray();

    Rectangle2D r2d = f.getStringBounds(array, 0, array.length, frc);

/*     Rectangle2D r2d = f.getStringBounds(Text, frc);*/

    LOG.debug("textToImage...3 ");

    if(r2d.getWidth() > width) {

    size=size/1.5;

    if(size <1) size = 1;

    f  = new Font("Arial", Font.PLAIN, (int) size);

    f = f.deriveFont((float)size);

    frc = new FontRenderContext(null, true, true);

   // lm = f.getLineMetrics(Text, frc);

    r2d = f.getStringBounds(Text, frc);

    }

    double realHeight = r2d.getHeight();

    double realWidth = r2d.getWidth();

  // BufferedImage img = new BufferedImage((int)Math.ceil(r2d.getWidth()), (int)Math.ceil(r2d.getHeight()), BufferedImage.TYPE_INT_RGB);

    BufferedImage img = new BufferedImage((int)Math.ceil(width), (int)Math.ceil(height), BufferedImage.TYPE_INT_RGB);

    Graphics2D g2d = img.createGraphics();

    g2d.setRenderingHints(RenderingProperties);

    Color backColor = new Color(45, 108, 147);

    g2d.setBackground(backColor);

    g2d.setColor(Color.WHITE);

    g2d.clearRect(0, 0, img.getWidth(), img.getHeight());

    g2d.setFont(f);

   // g2d.drawString(Text, 0, lm.getAscent());

    g2d.drawString(Text, (float) ((width/2)-(realWidth/2)), (float) ((height/2)+(realHeight/4)));

    g2d.dispose();

    if(isFile) ImageIO.write(img, "jpg", new File(fileName));

    return img;

  }catch(Exception e){

    LOG.error(e);

    throw e;

    }

}

public static BufferedImage textToImage1(int width,int height,String Text, Font f, float Size,String fileName,boolean isFile) throws IOException{

BufferedImage img = new BufferedImage((int)Math.ceil(width), (int)Math.ceil(height), BufferedImage.TYPE_INT_RGB);

Graphics2D g2d = img.createGraphics();

boolean sizeOk = false;

double size = height/3;

if(width>height) size = height/3;

else size =width/3;

int realWidth = 10;

int realHeight = 10;

while(!sizeOk){

if(f == null) f  = g2d.getFont();

    f = f.deriveFont((float)size);

    FontMetrics fm = g2d.getFontMetrics(f);

    realWidth = fm.stringWidth(Text);

    realHeight = fm.getHeight();

    size=size/1.5;

    if(realWidth<width || size<0) sizeOk = true;

}

    g2d.setRenderingHints(RenderingProperties);

    Color backColor = new Color(45, 108, 147);

    g2d.setBackground(backColor);

    g2d.setColor(Color.WHITE);

    g2d.clearRect(0, 0, img.getWidth(), img.getHeight());

    g2d.setFont(f);

   // g2d.drawString(Text, 0, lm.getAscent());

    g2d.drawString(Text, (float) ((width/2)-(realWidth/2)), (float) ((height/2)+(realHeight/4)));

    g2d.dispose();

    if(isFile) ImageIO.write(img, "jpg", new File(fileName));

    return img;

}

public static BufferedImage resizeImage(BufferedImage image, int width, int height) {

float w = new Float(width) ;

float h = new Float(height) ;

if ( w <= 0 && h <= 0 ) {

w = image.getWidth();

h = image.getHeight();

} else if ( w <= 0 ) {

w = image.getWidth() * ( h / image.getHeight() ); 

} else if ( h <= 0 ) {

h = image.getHeight() * ( w / image.getWidth() ); 

}

int wi = (int) w;

int he = (int) h;

BufferedImage resizedImage = new BufferedImage(wi,he,BufferedImage.TYPE_INT_RGB);

resizedImage.getGraphics().drawImage(

image.getScaledInstance(wi,he,Image.SCALE_AREA_AVERAGING),

0,0,wi,he,null

);

return resizedImage;

}

}

INSERT INTO t_0008.tbLOchange (serial,c_date,c_type,is_admin,contents,param_1,param_2,param_3) VALUES ( '0201t253', now(),'2','Y','LO.mail.log.reg','idwook80@iremo.net','','super')
[2017-11-02 18:36:11] ERROR com.jlee.sol.db.manager.DBConnection.sqlDo(DBConnection.java:582) - [DB ERROR] Cannot excute query - INSERT INTO t_0008.tbLOchange (serial,c_date,c_type,is_admin,contents,param_1,param_2,param_3) VALUES ( '0201t253', now(),'2','Y','LO.mail.log.reg','idwook80@iremo.net','','super') - java.sql.SQLException: Field 'log' doesn't have a default value
[2017-11-02 18:36:11] DEBUG com.jlee.sol.db.manager.DBConnection.sqlDo(DBConnection.java:571) -