##### JSBOARD + OOPS administartion Center #################################
#
#  Original Developer	: 躴 < redhands@linux.sarang.net >
#
#  Maintainer		: â < winchild@kldp.org >
#   version corder	:  < admin@oops.org >
#   version corder	: 湬 < dimanche@dimanche.co.kr >
#
#  CVS Server 	: 迵 < blhole@hotmail.com >
#  Homepage  	: http://www.kldp.org
#  Special Thanks	:  < eunjea@kldp.org>
#
#############################################################################
#
#                              Quick Installation in JSBoard 1.0 v0.6
#
#############################################################################


ۼ :  <admin@oops.org>
Ͻ : 2000.7.17

  JSBoard 1.0 version  ġ   Ѵ.
   س JSBoard   ؿ ؼ
ƹ å   ϰ Ǵϰ ġ õϵ
ϱ⸦ ٶ.

========================      ========================

0.7   DB ü SQL query  
ǾǷ     ٶ.

========================================================

****   ****

  1. ȯ
    1-1. exec() Լ test
    1-2. MySQL Լ test
    1-3. web server 
  2. JSBoard ġ
    2-1. MySQL setting
    2-2.   ϱ
  3. JSBoard 
  4. UPGRADE
    4-1. 0.8 Ǵ 1.0.x  upgrade
    4-2. 0.7   upgrade
      4-2-1.  ҽ ̿ϴ 
  5. Bug report

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


1. ȯ

  Linux  ġǾ ִ Server (ٸ NOS   ߻
  ˼ . DIY   ٶ)
  
  apache 1.3.x ̻
  
  MySQL 3.22.30 ̻ (RPM ġ  - ftp://ftp.oops.org)  
  (3.23.x  alpha version ȣȯ  ȹ )
  
  PHP-4.0.0 ̻(RPM ġ  - ftp://ftp.oops.org)  
  JSBoard 1.0 PHP4 Ͽ ۵ ϸ, Session 
  compile ÿ  ֵ ؾ Ѵ.

  * üũ  *

   php exec() Լ MySQL Լ Ǵ ȮѴ.

  1-1. exec() Լ test

    ϴ    ϳ . test.php3 Īϰڴ.
      linux󿡼 Ȯ ۵ Ѵ. ٸ flatform
    ˾Ƽ  ۵ ϴ Ȯ   ٶ.

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

    echo $test[0];
    ?>

       󿡼   ȣ 

    -------------------------------------------------
    ## exec() Լ ׽Ʈ ##

    exec()Լ  ۵ մϴ
    -------------------------------------------------

      Ǿ Ѵ.

  1-2. MySQL Լ test

    info.php3   Ʒ   Ѵ.

    <?php
    phpinfo();
    ?>

    ׸ 󿡼 ȣ   MySQL  ִ ȮѴ.
      Ұ MySQL  ִ php ġÿ mysql θ
     ذͰ  MySQL ΰ Ʋ 쿡   ߻Ҽ
    ִ.  ǥ 찡 PHP rpm ġ ϰ MySQL source
    compile  ̴. PHP rpm ġ Ұ쿡  κ
    /usr/lib/mysql  ġϴ ̱ ̴.

      縦 ϴµ  ߻Ѵٸ 

    <?
    $mcheck = mysql_connect("127.0.0.1", "root", "$passwd");
    Ǵ
    $mcheck = mysql_connect("localhost", "root", "$passwd");

    if ($mcheck) echo "MySQL ӿ ߽ϴ.";
    else echo "MySQL ӿ и ߽ϴ.
    ?>

     code  󿡼 mysql  Ͽ   ޼
       Ȯ  Ѵ.

  1-3. web server 

    jsboard index file index.php3 ̴ ׷Ƿ httpd.conf 
    DirectoryIndex ڿ index.php3 ߰ ֵ Ѵ.  ph file
      ؼ httpd.conf 

    AddType application/x-httpd-php3 .php3

     .ph  ߰ ֵ Ѵ.

2. JSBoard ġ

    JSBoard 󿡼  ϵ Ǿ ֱ   ۵ϴ
    nobody     ־߸ Ѵٴ  ؾ Ѵ.
     permission  Ǹ ؾ Ѵٴ ̴!

  2-1 MySQL setting

    MySQL ó  ϴ    Ѵ. ̹  Ǿ
    ִ    ڽ ̹ Ǿ ִ κ پ ѵ Ѵ.

     ڵ 쿡   ϸ,  ڿ MySQL
     DBü  ޶ û ϸ ȴ.  DB user name,
    DB name, DB password  ˷ ޶ ؾ Ѵ.


    . ϴ MySQL ġ ϵ Ѵ. MySQL RPM Űε Ҽ ִ.

      ftp://ftp.opos.org/pub/Linux/Redhat/RPMS
      ftp://linux.sarang.net/pub/MySQL

      linux  ϴ php rpm ϴ  쿡 php rpm
      packagingҶ mysql ΰ   ߴ³Ŀ  ޶ Ƿ
      ɼ  A+P+M   Ű¡ Ѱ   .

      ҽ  쿡  Ѵ.

    . ġ  root н带 Ѵ.

      [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)

      root password   Ŀ JSBoard  DB ü 
       ϵ Ѵ.  Ϸ 

      USER̸		"", 
      DB̸			"",
      н带		"н" 

        Ѵ.    .  ߿
       ̰͵ ѱ۷  .   ⸦ Ѵٸ ѱ۷
      ص  . ⼭    ϱ ؼ ѱ۷ ϴ 
      ̴.

      mysql> CREATE database ;
      Query OK, 0 rows affected (0.00 sec)

      mysql> insert into user (Host,User,Password)
           > values('localhost','',password('н'));
      Query OK, 0 rows affected (0.00 sec)

      mysql> insert into db values
           > ('localhost','','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
      Query OK, 0 rows affected (0.00 sec)

         ߻Ѵٸ db table ÷ Ʒ    ٶ.

      mysql> desc db;
      +-----------------+---------------+------+-----+---------+-------+
      | Field           | Type          | Null | Key | Default | Extra |
      +-----------------+---------------+------+-----+---------+-------+
      | Host            | char(60)      |      | PRI |         |       |
      | Db              | char(32)      |      | PRI |         |       |
      | User            | char(16)      |      | PRI |         |       |
      | Select_priv     | enum('N','Y') |      |     | N       |       |
      | Insert_priv     | enum('N','Y') |      |     | N       |       |
      | Update_priv     | enum('N','Y') |      |     | N       |       |
      | Delete_priv     | enum('N','Y') |      |     | N       |       |
      | Create_priv     | enum('N','Y') |      |     | N       |       |
      | Drop_priv       | enum('N','Y') |      |     | N       |       |
      | Grant_priv      | enum('N','Y') |      |     | N       |       |
      | References_priv | enum('N','Y') |      |     | N       |       |
      | Index_priv      | enum('N','Y') |      |     | N       |       |
      | Alter_priv      | enum('N','Y') |      |     | N       |       |
      +-----------------+---------------+------+-----+---------+-------+
      13 rows in set (0.00 sec)

      Įrow   13 ƴ϶ Host, Db, User   Į
       mysql query "Y"    Ѵ.  δ MySQL
      3.23.x alpha version 3.22.25   Ʋ  ̴.

      mysql> quit
      Bye

      ̹  Ǿ ִ   ܰ ׳ ǳ ٸ ȴ.

  2-2   ϱ

     ٿε    ġ ϴ 丮 
    Ǯ Ѵ.

    $ tar xvfpz jsboard-version.tar.gz

     Ǯ jsboard-version ̶ 丮  ȴ.

    jsboard/Install/SQL  ̵ Ͽ    Ͽ
    jsboard   table ü 鵵 Ѵ.   MySQL
     ˾ƾ Ѵ.

    $ cd jsboard-version/Install/SQL
    $ mysql -u  -p  < mysql.sql
    Enter password: н

    table ü    ϵ ġ Ű  ϵ
    ۹̼ ϵ Ѵ. jsboard/Install/script  root 
     ġ Ҽ ִٸ

    $ ./root.sh

    Ȥ  ڶ

    $ ./account.sh

     ϵ Ѵ.  account user  ġ Ϸ
        ִ.  db password  ִ  ȣؾ
    Ѵ. ̸ ؼ root   ڿ ϴ Ź ؾ 
     ִ. ٷ
    
    jsbaord/config/global.ph,
    jsboard/config/spma_list.ph,
    jsboard/admin/include/config.ph
    
      group  nobody  ޶ ؾ Ѵ. 

    $ chgrp nobody jsboard/config/global.ph (root ؾ ϴ )
    $ chgrp nobody jsboard/config/spam_list.ph (root ؾ ϴ )
    $ chgrp nobody jsboard/admin/include/config.ph (root ؾ ϴ )

      ޶ ؾ Ѵ. ̸ ϸ Ʒ   
    ȴ.

    -rx-rx----    accountname    nobody     config/global.ph
    -rx-rx----    accountname    nobody     config/spam_list.ph
    -rx-rx-r--    accountname    nobody     admin/include/config.ph

      Ұ account user  ġÿ   
    ɼ  home directory   711 ؾѴ.

      script file ϰ mv, chown, chmod  shell ɾ
    ̷        ǰ 
      ϵ ġؾ ϴ  ľҼ  ̴.

       ϸ  ϵ  ġ ڸ  ȴ.

     jsboard/config/  ̵ Ͽ global.ph  DB   Ѵ.

    /***************************************************************************
      Ÿ̽  
    ***************************************************************************/
    $db[server] = ":/var/lib/mysql/mysql.sock";	//  ּ
    $db[user]   = "";				// 
    $db[pass]   = "";				// н
    $db[name]   = "";				// ̸

     κ   ָ ȴ. DB ܺο   쿡
    ":/var/lib/mysql/mysql.sock" κ DB ip address ü ϸ
    ɰ̴ ( test  ô ^^;;). ׷ mysql source compile
    鵵 mysql.sock file θ   ָ ȴ.

3. JSBoard 

  JSBoard    Ѵ.   JSBoard ʹ  ڵμ
  admin/License  о   쿡  ϴ.

  ġ Ϸ Ǿٸ      Ѵ. 켱 ü
      Ѵ.

  http://domain.com/jsboard/admin

    ϵ Ѵ. ׷ login â ̴. JSBoard ⺻ н
   ʱⰪδ "0000"  Ǿ   н  ϵ Ѵ.

  OOPS Administration Center v1.6  ޶  ϴ   
  հ谡     Ż հ  ߰ Ͽ.  
  ϴܿ    ɼ ߰ Ǿ  Խ   ߰
  Ǿ. ׿ܿ  ȭ Խ  缭 Բ ȭ
  Ͽ, ׿ ޶   . :-)      
  ̴.  Ű  κ ִٸ Խ ÿ ѹ  
  confirm  ڿ  ̷    ̴.

4. UPGRADE

  4-1. 0.8 ̻ 1.0.x version upgrade

    0.8 ̻ 1.0..x version  upgrade ô ܼϴ. , 1.0.2
    ҽ ޾Ƽ   ֱ⸸ ϸ ȴ. ҽ  Ŀ
    jsbaord/Installer/script  root 쿡 root_p.sh  
    ָ Ǹ,   쿡 account_p.sh  ֱ⸸ ϸ ȴ.

      Ұ.... PHP3 ڵ PHP4 update  ߸ Ѵ.!!!!!!

  4-2. 0.7   upgrade

    μ 0.6   0.7  upgrade  ȴ.  
     ϴ user ּ 0.6   upgrade Ŀ
    upgrade Ҽ ִ.

    ϴ 0.7    upgrade ϱ ؼ â԰
      ÷ ֽ ҽ ̿Ͽ  ۾  ־ Ѵ.
      â ҽ װ ߰ Ǿ Ƿ 
     ÷ ֽ  ũƮ jsboard °  ũƮ
    ̿ϴ  ϵ Ѵ.  ũƮ http://jsboard.kldp.org
     ڷǿ Ҽ ִ.

     Ұ upgrade ġ Խ   б   
    ٴ ޼ ü ִ. ̴  Խ  ʱȭ Ǿ
     ̴  Խ ڷ   ٽ  ָ ȴ.

    *  ũƮ Ҷ timeout error ߻ 쵵 ִ.
    * ̴ php.ini    ð 30ʷ  Ǿ ֱ ̴
    *  ð ÷ ְ apache  ٽ ѹ  
    * ٶ.  ٰ ̸    ߺ ش
    *  ϱ ٶ.

    4-2-1.  ũƮ ̿ upgrade

      ڵ ۼ : 躴
      ڵ  : 
       ۼ : 

      http://jsboard.kldp.org/bbs/read.php3?table=bbs_download&no=30&page=1
       convert.phps ٿ     convert.php3 Ǵ
      convert.php  ϵ Ѵ.    󿡼  Ҽ
      ִ 丮 ̵ Ѵ. convert.php3 ͷ   7°
        $new_fiile = "../tmp/$table.sql"; κп ../tmp κ
      nobody   ִ Ȯ Ѵ.  /tmp/$table.sql 
       ϴ   ҵ ϴ. ׸ $new_file ٷ ܿ
      user, pass, name  ֵ Ѵ.

          Ѵٸ ϴ web root /home/httpd/html̶
       Ѵ. ׸ /home/httpd/html/convert  丮 Ѵ.
      convert  nobody ⸦ Ҽ ְ ϱ Ͽ chmod 777 convert
       Ѵ.  ٿε  ҽ ش ҽ convert
      convert.php3  ̸  .  convert.php3  
      κ ϵ Ѵ.

      $db = array('server'  => 'localhost',
                  'user'    => 'db user name ִ´',
                  'pass'    =>	'db password ִ´',
                  'name'    =>	'db ̸ ִ´' );

      $new_file = "./$table.sql"; //  丮 Ѵ.

          ָ ȴ.

       ڽ MySQL  3.22.21  ̶ ҽ  ϴܿ
       Ʒ   ش.

      ALTER TABLE $table MODIFY idx int(6) DEFAULT '0' NOT NULL;
      ALTER TABLE $table MODIFY no int(6) DEFAULT '0' NOT NULL AUTO_INCREMENT;\n");

      κ Ʒ   ϴ ̴.

      ALTER TABLE $table CHANGE idx idx int(6) DEFAULT '0' NOT NULL; 
      ALTER TABLE $table CHANGE no no int(6) DEFAULT '0' NOT NULL AUTO_INCREMENT; 

       󿡼 ȯ  Խ ̸ aaa  Ѵٸ  θ
      ȣѴ.

      http://domain.com/convert/convert.php3?table=aaa

      ũƮ Ϸ   $new_file   н aaa.sql ̶
        Ǿ  ̴.

        db  ϱ   ¿  Ͽ  DB 
      ϵ Ѵ.   ̿Ѵ.

      mysqldump -u USER -p DBname > backup.sql

         ϸ backup.sql ̶ ̸ DB  ȴ.
      ߿  ϰ 

      mysql -u USER -p DBname < backup.sql

        Ҽ ִ. ϴ     $table.sql ϵ
      ̿Ͽ DB ȯ ϵ Ѵ. Ʒ   . (Ʒ aaa
       Խ ȯϴ ̴. Խ     ݺ
       ֵ Ѵ)
      
      mysql -u USER -p DBname < aaa.sql

      ƹ ޼  ʰ prompt  ȯ  Ѱ̴.
      DB۾ Ϸᰡ Ǿ  Խ ۾ Ѵ.

        Խǰ ġ ʰ jsboard Ǯ   
      Խ   ϴ include/Խ̸  jsboard-new/data 
      copy Ѵ. ׸ jsboard-new/Installer/script  root.sh
      account.sh ̿Ͽ  ϵ ġ Ű ۹̼  
      jsboard-new/config/global.ph  DB ־ ش.  
      http://domain.com/jsboard-new/admin   Ͽ  ȣ
      "0000" ̿Ͽ α  ü   Խ   ָ
      ȴ.


5. Bug report

  ׸ ߰ 쿡 http://jsboard.kldp.org/bbs/list.php3?table=bbs_upgrade 
    ָ ϰڴ


