***** JSBOARD + OOPS administartion Center *********************************

Original Developer	: 躴 < redhands@linux.sarang.net >

Maintainer		: â < winchild@kldp.org >
 version corder	:  < admin@oops.org >
 version corder	: Dimanche < dimanche@dimanche.co.kr >

CVS Server 		:  迵 < blhole@hotmail.com >
Homepage  	: http://www.kldp.org

******************************************************************************


Title : JSBoard-0.7


ۼ	: . <admin@oops.org> http://www.oops.org
ۼ	: 2000.1.31




====

1. 䱸 
2.  ȯ
3. 
4. Installation (ġ) : root   ó ġ
5. Installation (ġ) :  ڰ ó ġ
6. Installation (ġ) :  ڵ  Part
7. 




1. 䱸
===========

  1-1. flatform

    ġ  ý. ٸ flatform ȣȯ  .
                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    apache 1.3 ̻ php3-3.0.7 ̻ 䱸.

  1-2. Hardware

    ġɼ  OK

  1.3.  䱸

   MySQL  ణ  ʿ


2.  ȯ
============

Jsboard linux system Ͽ apache web server php3 module MySQL 
 Ͽ ۵ Ѵ.  ڽ system exec() Լ  ۵
ϴ Ȯؾ Ѵ.

 )

<? php

echo("exec() Լ ׽Ʈ<p><br>") ; 
exec("echo \"execԼ  ۵ մϴ\"", $test) ; 

echo $test[0] ; 

?> 

  test page   󿡼  

exec() Լ ׽Ʈ

execԼ  ۵ մϴ 

  ޼  ȴ.  php mysql  Ǵ Ȯؾ
Ѵ. ̴

)

<?php
phpinfo() ;
?>

  test page  󿡼 ҷ MySQL   ִ
Ȯؾ Ѵ.   Ұ  RPM ǰ ִ php MySQL
option  ִ ͵ MySQL ΰ /usr/lib/mysql ̾߸ Ѵ.
, MySQL RPM ġ  ִ   ϴ.


3. 
===========

README file 


4. Installation (ġ) : root   ó ġ
=======================================================

  ********  ********

   ڵ  ڵ  ڽ ׸ ãƼ
   Ѵ.  κ root   ִ 
  ó  ϴ 쿡 Ѵ.

  **********************


1. ϴ mysql ġ Ѵ. MySQL RPM Ҽ 

   ftp://linux.sarang.net/pub/ 

    Ҽ ִ. REDHAT 5.x ϴ  

   ftp://ftp.oops.kr.net/pub/Linux/Redhat/RPMS/5.x/i386/MySQL

    ϸ ȴ.

2. root  password Ѵ.

   [root@home /public_html]# mysql mysql 

   Reading table information for completion of table and column names 
   You can turn off this feature to get a quicker startup with -A 

   Welcome to the MySQL monitor. Commands end with ; or \g. 
   Your MySQL connection id is 1961 to server version: 3.22.20a-log 

   Type 'help' for help. 

   mysql> update user set password = password('н')
        > where user = 'root' ;
   Query OK, 1 row affected (0.00 sec) 

   mysql> flush privileges;
   Query OK, 0 rows affected (0.00 sec)

   mysql> quit
   Bye

   ̹  Ǿ ִ   ܰ ׳ ǳ ٸ ȴ.


3. jsboard  ҽ ġ 丮  Ǭ.

   shell> tar xvfpz jsboard-0.7.0.tar.tz

4.  Ǭ jsboard-0.7.0/Install/Config  ̵ Ѵ.
   ̵   root.sh   丮  Ѵ.

   shell> ./root.sh

    jsboard-0.7.0 directory ٽ ƿͼ
   include directory ׷ǰ ۹̼ Ʒ 
    Ǿ ִ Ȯ Ѵ.


   [root@oops jsboard-0.7.0]# ll
   total 52
   drwxr-xr-x  6 oops  oops    1024 Dec 17 16:18 ./
   drwxrwxr-x  7 oops  oops    1024 Dec 15 11:24 ../
   -rw-r--r--  1 oops  oops    4160 Dec 17 17:02 INSTALL.txt
   drwxr-xr-x  4 oops  oops    1024 Dec 17 15:59 Install/
   -rw-r--r--  1 oops  oops    8665 Dec 11 18:12 README
   -rw-r--r--  1 oops  oops    5468 Dec 16 22:16 act.php3
   drwxr-xr-x  5 oops  oops    1024 Dec 17 15:27 admin/
   -rw-r--r--  1 oops  oops    5149 Dec  6 13:45 delete.php3
   -rw-r--r--  1 oops  oops    4641 Dec  7 16:13 edit.php3
   drwxr-xr-x  2 oops  oops    1024 Dec  6 13:45 images/

   drwxrwxr-x  3 oops  nobody  1024 Dec 17 16:12 include/  <----- !!!
                       ^^^^^^
   -rw-r--r--  1 oops  oops      51 Dec 15 12:36 index.php3
   -rw-r--r--  1 oops  oops    2621 Dec 17 15:45 list.php3
   -rw-r--r--  1 oops  oops    7481 Dec  6 13:45 read.php3
   -rw-r--r--  1 oops  oops    3983 Dec  6 13:45 reply.php3
   -rw-r--r--  1 oops  oops    3505 Dec  7 17:05 write.php3


     

   drwxrwxr-x  3 oops  nobody  1024 Dec 17 16:12 include/

   Ǿ  ʴ´ٸ    ۾ Ѵ.

   shell> chgrp nobody ./include
   shell> chmod 775 ./include


5. ٽ jsboard-0.7.0/Install  ̵ Ѵ.

    Ұ   upgrade ϴ ̳  ġ
   ڵ  Install program ؼ ȵȴ.

    丮 Ʊ  mysql root password  
   file ִ.

    mysql_user_regist.php3  vi ̿Ͽ  


   : mysql_user_regist.php3   κ

   /****************************************************/

   // mysql  root password  

   $passwd = "" ;
   $passwd = crypt("$passwd","oo") ;

   /****************************************************/

   
    $passwd = ""  ""̿ mysql root password ´.
     丮 act.php3     κп
   mysql_user_regis.php3 ϰ Ǿ ִ  Ƿ
   ⿡   ش.

   : act.php3   κ

   /****************************************************/

   // mysql  root password  

   $passwd = "" ;
   $passwd = crypt("$passwd","oo") ;

   /****************************************************/


6.  

   http://domain.com/jsboard-0.6/Install

     Ѵ. ҹڿ . ϴ  ϸ
   mysql password  ð̴.
   Ʊ  н带 ϰ enter ŬѴ.

7.   Ѿ 

   jsboard  DB̸ DB  ׸ DB user password   ش.
     ְ Ѿ. 

   ⼭  Ұ ̹ MySQL ϵǾ ִ DB name DB 
   ؼ ȵȴ.

    ϸ   ޼ ߰ ȴ.

   " ϷǾϴ.
    Admin Page ̵ մϴ.
    Admin Page ʱ Password
    0000 Դϴ"

8. admin page login page   Ʈó 0000 ְ ͸ 
   ģ. ϴܿ ִ ư н  ϴ ̴ ̰
    α  ʴ´. α   ѹ
   ָ Ű Ǵ н带 ϰ ش.


   **  **

   admin page   Netscape   ȭ鸸 ´ٵ
   Ǵ Ʒ   ޼ ð

   Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES)
   in /usr/local/apache/htdocs/jsboard-0.7.0/Install/act.php3 on line 46
   Unable to connect to SQL server

   ̶ MySQL reload ٽ ֱ ٶ. ׷ ȵȴٸ
   jsboard-0.7.0/include  db.ph file ϴ   ִٸ
     db ̸, db user, db pass  Ȯ  
      mysql  α  test  .



9. CrayWWWBoard   ģ  ð̴.
   ϴ   ó  켱  н 
    ؾ Ѵ.

   ȭ  ߰ κп "Admin Info"    ̴.
    κ administratin center н带 ϴ κ
    н    ִ.(̵ Ҽ ִ.)

   ̰ ŬϿ н带 Ŀ ٷ  logout ư
    logout Ŀ ٽ  password α Ѵ.

10.   ʹ ϴ Խ ̸ Create DB ־ 
   ָ Խǵ   ϴ.

11. Խ   Խ  йȣ 1ۿ
   ڵ  ǹǷ ̸ Ȯ Ŀ  Խ н带
    ֵ Ѵ.

12. jsboard-0.7.0/jsboard/db.ph   б 常 ϰ Ѵ.


5. Installation (ġ) :  ڰ ó ġ
================================================

  ********  ********

   κ root    ڰ
  ó  ϴ 쿡 Ѵ.

  **********************


1. jsboard  ҽ ġ 丮  Ǭ.

   shell> tar xvfpz jsboard-0.7.0.tar.gz

2.  ڵ ȿ  ΰ ʿ䰡 ִ.
   ׷Ƿ  κ ϰ Ȯϰ  ϱ ٶ.

   ϴ ڽ ID oops Ʒ  shell 󿡼
    Ѵ.

   shell> chmod 711 ~oops

     jsboard-0.7.0/Install/Config/  ̵ Ѵ.
   ׸ Ʒ  Ѵ.

   shell> ./account.sh

    jsboard-0.7.0 directory ٽ ƿͼ
   include directory ׷ǰ ۹̼ Ʒ 
    Ǿ ִ Ȯ Ѵ.

   [root@oops jsboard-0.7.0]# ll
   total 52
   drwxr-xr-x  6 oops  oops    1024 Dec 17 16:18 ./
   drwxrwxr-x  7 oops  oops    1024 Dec 15 11:24 ../
   -rw-r--r--  1 oops  oops    4160 Dec 17 17:02 INSTALL.txt
   drwxr-xr-x  4 oops  oops    1024 Dec 17 15:59 Install/
   -rw-r--r--  1 oops  oops    8665 Dec 11 18:12 README
   -rw-r--r--  1 oops  oops    5468 Dec 16 22:16 act.php3
   drwxr-xr-x  5 oops  oops    1024 Dec 17 15:27 admin/
   -rw-r--r--  1 oops  oops    5149 Dec  6 13:45 delete.php3
   -rw-r--r--  1 oops  oops    4641 Dec  7 16:13 edit.php3
   drwxr-xr-x  2 oops  oops    1024 Dec  6 13:45 images/

   drwx---rwx  3 oops  oops    1024 Dec 17 16:12 include/  <----- !!!
   ^^^^^^^^^^
   -rw-r--r--  1 oops  oops      51 Dec 15 12:36 index.php3
   -rw-r--r--  1 oops  oops    2621 Dec 17 15:45 list.php3
   -rw-r--r--  1 oops  oops    7481 Dec  6 13:45 read.php3
   -rw-r--r--  1 oops  oops    3983 Dec  6 13:45 reply.php3
   -rw-r--r--  1 oops  oops    3505 Dec  7 17:05 write.php3

     

   drwx---rwx  3 oops  oops    1024 Dec 17 16:12 include/

   Ǿ  ʴ´ٸ    ۾ Ѵ.

   shell> chmod 707 ./include

3.  ڵ Install program  
     ؾ Ѵ.

4.  account.sh  ϸ jsboard-0.7.0/include directory
   db.ph file  ȴ.    db 
   Ҽ     jsboard-0.7.0/include directory
     jsboard-0.7.0/Install/admin_sample  ִ db.ph.orig
   jsboard-0.7/include  db.ph file name copy Ѵ. ׸
   1 ˾   DB name, DB user name, DB password
   ˸° ־ش. $db_server ǵ帮 ȵȴٴ 
   .

   db.ph  include/test  ̴. ̰ install/sample
   test ̸ copyϰ ۹̼ 707    files directory
   707  ϵ 606 ۹̼ ֵ Ѵ.

5.  jsboard-0.7.0/Install/SQL directory ̵ ؼ

   shell#  mysql -u DB_USER_NAME -p DB_NAME < mysql.sql
   shell#  mysql -u DB_USER_NAME -p DB_NAME < manager.sql

    Ͽ, Խ table  table 鵵 Ѵ.
   ⼭ DB_USER_NAME ڿ   ޶  DB user ̸̸,
   DB_NAME DB ̸  ־ ָ ȴ.


6.   ۾ .   
   http://domain/~account/jsboard-0.7.0/admin   Ѵ.
   admin page login page  ⺻ н 0000 ְ ͸ 
   ģ. ϴܿ ִ ư н  ϴ ̴ ̰
    α  ʴ´. α   ѹ
   ָ Ű Ǵ н带 ϰ ش.



   **  **

   admin page   Netscape   ȭ鸸 ´ٵ
   Ǵ Ʒ   ޼ ð

   Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES)
   in /usr/local/apache/htdocs/jsboard-0.7.0/Install/act.php3 on line 46
   Unable to connect to SQL server

   ̶ MySQL reload ٽ ֱ ٶ. ׷ ȵȴٸ
   jsboard-0.7.0/include  db.ph file ϴ   ִٸ
     db ̸, db user, db pass  Ȯ  
      mysql  α  test  .



7. CrayWWWBoard   ģ  ð̴.
   ϴ   ó  켱  н 
    ؾ Ѵ.

   ȭ  ߰ κп "Admin Info"    ̴.
    κ administratin center н带 ϴ κ
    н    ִ.(̵ Ҽ ִ.)

   ̰ ŬϿ н带 Ŀ ٷ  logout ư
    logout Ŀ ٽ  password α Ѵ.

8    ʹ ϴ Խ ̸ Create DB ־ 
   ָ Խǵ   ϴ.

9. Խ   Խ  йȣ 1ۿ
   ڵ  ǹǷ ̸ Ȯ Ŀ  Խ н带
    ֵ Ѵ.




6. Installation (ġ) :  ڵ  Part
==================================================

0.6  . ٸ  ˾Ƽ ¥ ߱ ϵ ^^;
 Ұ  ۹̼ǰ  κ и 񱳸   ٶ.
0.7pre3 ̻ ڵ ҽ   ȴ.
0.7pre1-pre2  ڵ DB  Ͽ   
 Ѵ.

mysql> alter table BoardInformation add lang varchar(5);


************  **************

 κп  0.6  Ͽ ȴ.
̹ 0.7  ϰ ִ  ׳ ϵ鸸
  ٶ. ׿  .

********************************


1. jsboard  ҽ ġ 丮  Ǭ.

   shell# tar xvfpz jsboard-0.7.0.tar.tz

   ϴ  Ұ      ε Ѵ.
    file jsboard-0.7.0 ̶ directory  Ǯ
     ġ ʰ ϶. (׷ϵ  ^^:)


2. DB ϰ ״ ׳ Ѿ.
   jsboard-0.7.0/Install/SQL directory  mysql.sql ̶ 
      ϰ  table    ٶ. 
   0.5    KEY date (date)   ִ. 0.6 ʹ
   date key indexing ̿ϱ  ALTER   κ
   ߰ϱ ٶ. 0.6 ̻  ϴ   ׸
   ص ȴ.

   ALTER TABLE table_name ADD INDEX (date);

     ָ ȴ. ٵ, ̹ Ǿ ִ  
     ϸ  Ǵ  𸥴. (SQL ʺ  T.T)

3.   ٸ ̸  ϰ  ġ 
      .

4. ۹̼ǰ     Ǿ ִ Ȯ Ѵ.
   ׸  admin/include/info.ph Ѵ.
   admin/include ۹̼ ̿    Ǿ ִٸ
   ̸  . 

    ڵ 쿡   ġ κ ۹̼ ؾ
   ^^^^^^^^^^^^^^^^^^^^
   Ѵٴ  ؾ Ѵ. ϵ Ѵ.
                              ^^^^^^^^^^^^^^^^

5. jsboard-0.7.0/Install/SQL/manager.sql convert.sql copy Ѵ.
   convert.sql   Ʒ ִ

   ***********************************************************************************

   INSERT INTO BoardInformation VALUES ('','superuser','ooK/oSLfDJOUI','','','',
       '','','','','','','','','','','','','','','','','',
       '','','','','','','','','','','','','en');

   INSERT INTO BoardInformation VALUES ('','test','','ooK/oSLfDJOUI','10','8',
       '40','550','#a5b5c5','#ffffff','#d5b5c5','#ffffff','#ffffff','#555555',
       '#99aabb','#555555','#a5b5c5','#ffffff','#a5c5c5','#ffffff','#d5b5c5',
       '#555555','#ffffff','#555555','#778899','yes','no',
       './include/table_account_name/files','2000000','','no','','yes','yes','127.0.0.1','ko');

   ***********************************************************************************

   insert  2 ϰ   Ѵ.

    oops, bbuwoo, love  ̸ Խ  ϰ 
   ־ٸ  insert  ι° insert ι° filed ִ 'test'  
    ̸  ش.  Ʒ  ؾ Ѵ.

   INSERT INTO BoardInformation VALUES ('','oops','','ooK/oSLfDJOUI','10','8',
       '40','550','#a5b5c5','#ffffff','#d5b5c5','#ffffff','#ffffff','#555555',
       '#99aabb','#555555','#a5b5c5','#ffffff','#a5c5c5','#ffffff','#d5b5c5',
       '#555555','#ffffff','#555555','#778899','yes','no',
       './include/table_account_name/files','2000000','','no','','yes','yes','127.0.0.1','ko');

   INSERT INTO BoardInformation VALUES ('','bbuwoo','','ooK/oSLfDJOUI','10','8',
       '40','550','#a5b5c5','#ffffff','#d5b5c5','#ffffff','#ffffff','#555555',
       '#99aabb','#555555','#a5b5c5','#ffffff','#a5c5c5','#ffffff','#d5b5c5',
       '#555555','#ffffff','#555555','#778899','yes','no',
       './include/table_account_name/files','2000000','','no','','yes','yes','127.0.0.1','ko');

   INSERT INTO BoardInformation VALUES ('','love','','ooK/oSLfDJOUI','10','8',
       '40','550','#a5b5c5','#ffffff','#d5b5c5','#ffffff','#ffffff','#555555',
       '#99aabb','#555555','#a5b5c5','#ffffff','#a5c5c5','#ffffff','#d5b5c5',
       '#555555','#ffffff','#555555','#778899','yes','no',
       './include/table_account_name/files','2000000','','no','','yes','yes','127.0.0.1','ko');

   ϴ Խ 5 insert  5 Ǿ Ұ̴.
     ذ Ǹ ϰڴ.

     󿡼

   shell> mysql -u USER_NAME -d DB_NAME < convert.sql

    Ѵ.


6.  ۾  ϴ     ʱȭ Ͽ
   DB  ۾  Ǹ,  Խ   
   󿡼  ٽ   Ѵ.  Խǵ н嵵
   0000  ʱȭ ȴ.

7. 0.6 version ڵ jsboard/admin/include/info.php3 
   Ѵ ׸ ü  page н 0000 ʱȭ Ǵ
   ̸ ٽ  ֵ Ѵ.

8. ü admin page(http://domain/jsboard/admin/) login ؼ
   0000 ְ ͸ ģ. ϴܿ ִ ư н 
   ϴ ̴ ̰  α  ʴ´. α 
    ѹ ָ Ű Ǵ н带 ϰ ش.

   **  **

   admin page   Netscape   ȭ鸸 ´ٵ
   Ǵ Ʒ   ޼ ð

   Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES)
   in /usr/local/apache/htdocs/jsboard-0.7.0/Install/act.php3 on line 46
   Unable to connect to SQL server

   ̶ MySQL reload ٽ ֱ ٶ. ׷ ȵȴٸ
   jsboard-0.7.0/include  db.ph file ϴ   ִٸ
     db ̸, db user, db pass  Ȯ  
      mysql  α  test  .



9. CrayWWWBoard   ģ  ð̴.
   ϴ   ó  켱  н 
    ؾ Ѵ.

   ȭ  ߰ κп "Admin Info"    ̴.
    κ administratin center н带 ϴ κ
    н    ִ.(̵ Ҽ ִ.)

   ̰ ŬϿ н带 Ŀ ٷ  logout ư
    logout Ŀ ٽ  password α Ѵ.

10.   ʹ ϴ Խ ̸ Create DB ־ 
   ָ Խǵ   ϴ.

   Ƹ  ڵ ̹ ϵǾ ִ $table   ̴.

11. Խ   Խ  йȣ 1ۿ
    ڵ  ǹǷ ̸ Ȯ Ŀ  Խ н带
     ֵ Ѵ.

12. admin page ۾ ,   Խ admin page
    α Ͽ ѹ  ش.  ۾  config.ph
    ο config.ph  Ų.  config.ph κ 
    DB  , config.ph ޴    ִ.

13. jsboard-0.7.0/jsboard/db.ph   б 常 ϰ Ѵ.

׷   ϱ ٶ ^^;



7. 
=======

ġ Ŀ Install directory ۹̼  ݾƵη
ϱ⸦ Ѵ.  700  ϱ⸦ ٶ.
׳ θ  ư Ҽ ִٴ ̴.


