Skip to main content


Showing posts from 2012

Mysql make user and password

First of all make database mysql> create database DBName;
See all database list mysql> show databases
mysql> use mysql
Making general user mysql> grant usage on *.* to amarokuser@localhost identified by 'amarokpasswd'; Query OK, 0 rows affected (0.00 sec) Making the user having all authorities mysql> grant all privileges on amarokdb.* to amarokuser@localhost ; Query OK, 0 rows affected (0.00 sec) commit all changes mysql> FLUSH PRIVILEGES; see allowed ip adresses SELECT Host FROM mysql.user WHERE user='root';

Lucene Tutorial(1) - How to index Lucene

I'm first in use of lucene. I think this blog is not perfect for you because I'm not professional. but what I wrote is by reading and stuying the book of Lucene in action 2. so I hope this blog is going to be useful some of you
1. Indexing (3.6.1 version)
why Use?
when i can use this lucene?
Suppose~!  you have many text-files in your local computer, window xp, 7 and so on  search programs allow you find filename but not content in textfiles.  how do search content?
so you have to use search engine like lucene

how to Index ?

explain :  
indexDir = directory that you want to index   (a.txt, b.txt, c.txt) dataDir = destination directory where indexing file will store
IndexWriter = it is like translator original file into indexed file
TextFilesFilter class = filtering file extension Document  = it is like file info class
Running this code your first experience is done.

public class Indexer { public static void main(String[] args) throws Exception { if (args.length != 2) { throw new Il…

html image size 100%

/** 백그라운드 이미지를 전체 사이즈에 맞추기**/
background: url('bg_viewbar.gif')  no-repeat center center fixed;
-webkit-background-size: cover;
    -moz-background-size: cover;
    -o-background-size: cover;
    background-size: cover;


this is a part of javascript
after page being loaded window.onload will be called..

window.onload = init;

function init() {

function loginSubmit(){

Ajax Example MyStyle

function sendAjax() {

var xhr = new XMLHttpRequest();

var params="company_id="+"203"+"&"+"search.max="+max+"&"+"search.pos="+pos;"GET",
'url?' + params,
xhr.onreadystatechange = function() {
if (xhr.readyState == 4 && xhr.status == 200)
var obj = eval( '(' + xhr.responseText + ')' );
var list =  obj.list;
for(var i=0; i<list.length; i++){
var html= '<div class="frame" id="frame">'+
'<div id ="content" class="ccc">'+
'<p id="content_title"><strong>'+list[i…

Html heaer, center, footer


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
body {
height: 100%;
margin: 0;
padding: 0;
#head {
height: 100px;
background: #ddd;
position: relative;
z-index: 1;
#body {
min-height: 100%;
margin: -100px 0 -50px;
* html #body {
height: 100%;
#content-area {
padding: 100px 0 50px;
#foot {
height: 50px;
background: #ddd;

<div id="head">
요건 100px 높이 헤드
<div id="body">
<div id="content-area">
<p>컨텐츠 영역 1</p>
<p>컨텐츠 영역 2</p>
<p>컨텐츠 영역 3</p>
<p>(계속 추가해서 테스트 가능)</p>

linux java classpath

vi /etc/profile
add below lines
#JAVA SETTING export JAVA_HOME=/home/hadstore/java/jdk1.6.0_33 export PATH=$PATH:$JAVA_HOME/bin export CLASSPATH=.:$JAVA_HOME/jre/lib/ext:$JAVA_HOME/lib/tools.jar
souce /etc/profile : this is for reload

mysql unique setting

First of all, you can make some column unique when creating table

seq int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
UNIQUE (seq)
Second, when you alter table.

javaScript Confirm Box

<!DOCTYPE html>

<p>Click the button to display a confirm box.</p>

<button onclick="myFunction()">Try it</button>

<p id="demo"></p>

<script type="text/javascript">
function myFunction()
var x;
var r=confirm("Press a button!");
if (r==true)
  x="You pressed OK!";
  x="You pressed Cancel!";


load balancing apache -> http.conf

LoadModule jk_module modules/

JkWorkerProperty worker.list=ajp13w
JkWorkerProperty worker.ajp13w.type=lb
JkWorkerProperty worker.ajp13w.balanced_workers=WAS1,WAS2
JkWorkerProperty worker.sticky_session=true

JkWorkerProperty worker.WAS1.type=ajp13
JkWorkerProperty worker.WAS1.port=8009
JkWorkerProperty worker.WAS1.lbfactor=1

JkWorkerProperty worker.WAS2.type=ajp13
JkWorkerProperty worker.WAS2.port=8009
JkWorkerProperty worker.WAS2.lbfactor=1

JkLogFile logs/jk.log
JkLogLevel info
JkLogStampFormat "[%a %b %d %H:%M:%S %Y]"
#JkMount /*.jsp ajp13w
JkMount /* ajp13w
JkMount /example/* ajp13w

JkUnMount /*.html ajp13w
JkUnMount /*.gif ajp13w
JkUnMount /*.jpg ajp13w
#JkMount /servlet/* ajp13w

MYSQL Authority~!

$ mysql -u root -p Enter password: mysql> use mysql mysql> GRANT ALL ON *.* to root@'' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES;if i want all ipaddress can access to DB Servermysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'your-root-password'

Change Database Characters

Change Character set

There are many way to change character set
this way is to change database character set
ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci; belows sql query shows that what kind of character set mysql has
mysql> show character set;
+x means a+x : all user can execute

$ chmod +x your-script-name
$ chmod 755 your-script-name

$ bash bar
$ sh bar
$ ./bar

echo show on monitor

$ vi first
# My first shell script
echo "Knowledge is Power"

$ ./first

when you write 'free' on linux

you will know the rest of you computer memory

[root@posu7 logs]# free

             total       used       free     shared    buffers     cached
Mem:        524288     404716     119572          0      76072      93512
-/+ buffers/cache:     235132     289156
Swap:      1081336        112    1081224

Install Mysql

Now I let you know how to install MySQl on linux

First this will check if mysql is already installed on linux # rpm -qa | grep mysql
Remove previouse Versin # rpm -e  mysql-devel-5.0.77-4.el5_5.4 –-nodeps(--nodeps will ignore dependencies)
And go to web site to find the version that you want to install
# rpm -ivh Mysql-server....rpm # rpm -ivh Mysql-share.....rpm # rpm -ivh mysql-devel......rpm # rpm -ivh mysql-client......rpm
A) If you are /using mysql on RedHat Linux (Fedora Core/Cent OS) then use following command: * To start mysql server: /etc/init.d/mysqld start * To stop mysql server: /etc/init.d/mysqld stop * To restart mysql server /etc/init.d/mysqld restart# service mysqld start # service mysqld stop # service mysqld restart$ mysql -u root -p Enter password: mysql> use mysql mysql> GRANT ALL ON *.* to root@'' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES; and /etc/sysconfig vi iptables and…

What is RPM

RPM(RedHat Package Manager)
RPM Package Manager (RPM) is a package management system.[2]The name RPM variously refers to the .rpmfile format, files in this format,software packaged in such files, and the package manager itself. RPM was intended primarily for GNU/Linux distributions; the file format is the baseline package format of the Linux Standard Base.
rpm -qi :  mtools-3.9.8-2.i386.rpm print package summary
rpm -i : mtools-3.9.8-2.i386.rpm install package
rpm -ivh : mtools-3.9.8-2.i386.rpm install, monitor and verify pack
rpm -q : mtools verify if pack installed
rpm -qa :  list all installed packs
rpm -ql : mtools list all files installed for pack
rpm -qd : mtools list pack doc files only
rpm -e  : mtools erase package
rpm -Uvh :  * upgrade all packs in distribution

What is Wget

What is Wget

Definition: wget: retrieves files from the web Wget is a network utility to retrieve files from the Web using http and ftp, the two most widely used Internet protocols. It works non-interactively, so it will work in the background, after having logged off. The program supports recursive retrieval of web-authoring pages as well as ftp sites -- you can use wget to make mirrors of archives and home pages or to travel the Web like a WWW robot. Wget works particularly well with slow or unstable connections by continuing to retrieve a document until the document is fully downloaded. Re-getting files from where it left off works on servers (both http and ftp) that support it. Both http and ftp retrievals can be time stamped, so wget can see if the remote file has changed since the last retrieval and automatically retrieve the new version if it has. Wget supports proxy servers; this can lighten the network load, speed up retrieval, and provide access behind firewalls. http://www.g…

FTP Install

First you need to download lftp

[root@localhost /]# yum install lftp

after that 
mkdir /usr/local/src/ftpd cd /usr/local/src/ftpd

before you write below line, you should look on the and check lasted version.
[root@localhost ftpd]# tar -xvzf proftpd-1.3.4a.tar.gz proftpd-1.3.4a/ proftpd-1.3.4a/doc/ proftpd-1.3.4a/doc/utils/ proftpd-1.3.4a/doc/utils/ftpcount.html proftpd-1.3.4a/doc/utils/ftpmail.html proftpd-1.3.4a/doc/utils/ftpasswd.html proftpd-1.3.4a/doc/utils/ftpscrub.html proftpd-1.3.4a/doc/utils/ftpwho.html proftpd-1.3.4a/doc/utils/ftptop.html proftpd-1.3.4a/doc/utils/ftpquota.html proftpd-1.3.4a/doc/utils/ftpdctl.html proftpd-1.3.4a/doc/utils/index.html proftpd-1.3.4a/doc/utils/ftpshut.html proftpd-1.3.4a/doc/contrib/ proftpd-1.3.4a/doc/contrib/mod_sql_odbc.html proftpd-1.3.4a/doc/contrib/mod_wrap2_file.html proftpd-1.3.4a/doc/contrib/mod_ifsession.html proftpd-1.3.4a/doc/contrib/mod_exec.h…

Pattern easy

This is very is and amazing if you know

ex) if(split[i].matches("[A-Za-z]+\\.?")){     }
what dose that mean?
i'm just looking for JAVA API
[A-Za-z] : those alphabet A from Z or a-z is available  +       : [A-Za-z] uses more than one time \\ .?       : .? means one or nothing  

"33. "             return false "gefefeddd."       return true "ddddfedAE"        return true "d.d.d"            return false "ddkdkjeij.33412"  return false "12312tjkjkd@#"    return false


I just started Topcoder
it is very interesting for me
because i have to think about a lot of things.
this homepage is really good
I hope my coding pattern and style will be better than now~!

do you want to do this with me?
write message to me~!

this article is about tho question    "practiceRooms/Inv 2001 R1/ 500"

my answer is below~!

import java.util.ArrayList;

public class SquareDigits {
public static void main(String args[]){
int a= new SquareDigits().smallestResult(112);

public int smallestResult(int value){
int count =0;
ArrayList<Integer> tArray= new ArrayList<Integer>();
int sum = 0;
String sValue ="";
sValue =String.valueOf(count);

for(int i=0; i<sValue.length(); i++){
String eachValue = sValue.substring(i, i+1);
sum = sum + Integer.parseInt(eachValue)*Integer.parseInt(eachValue);

if(sum == value){
if(tArray.size()==0) return count;
return tArray.get(0);