status-save.php
=============================================

-------------------
ۼ : 2013-10-22
ۼ : 

2014-08-07   

-------------------


Contents
========

- 
- ġ 
- ˷ 



========

status-save.php CCDB DBMS  Oracle  PPAS(PostgreSQL)   .
Oracle   KT PPAS   ϴ    ׿  ڼ  ϰ
PPAS   ؼ Ѵ.

status-save.php GMS ϵ  RC 丮 뷮, 뷮, Ʈũ , FHS   CCDB ϴ  .
̷   SMS ؼ RC  ȴ.
ġ Ʒ  'ġ '  GTS ġϿ Ѵ.


ġ 
=========

status-save.sh  Ե php ũƮ    PHP  Ű ġѴ.


1. PHP, PostgreSQL  Ű ġ

   # yum install php php-pgsql


2. PHP  Ȯ(PHP ũƮ ⵿  ִ  Ѵ.)

   # php -version

     PHP 5.3.3 (cli) (built: Jul 12 2013 20:35:47) 
     Copyright (c) 1997-2010 The PHP Group
     Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


3. PostgreSQL  ȯ 

   # vi phpinfo.php

     <?php
     phpinfo();
     ?>
 
   # php phpinfo.php  ؼ    Ÿ Ѵ.

     ~  ~

     PDO

     PDO support => enabled
     PDO drivers => pgsql, sqlite

     pdo_pgsql

     PDO Driver for PostgreSQL => enabled
     PostgreSQL(libpq) Version => 8.4.13
     Module version => 1.0.2
     Revision =>  $Id: pdo_pgsql.c 300351 2010-06-10 12:11:19Z iliaa $ 

     pdo_sqlite

     PDO Driver for SQLite 3.x => enabled
     SQLite Library => 3.6.20

     pgsql

     PostgreSQL Support => enabled
     PostgreSQL(libpq) Version => 8.4.13
     Multibyte character support => enabled
     SSL support => enabled
     Active Persistent Links => 0
     Active Links => 0

     Directive => Local Value => Master Value
     pgsql.allow_persistent => On => On
     pgsql.auto_reset_persistent => Off => Off
     pgsql.ignore_notice => Off => Off
     pgsql.log_notice => Off => Off
     pgsql.max_links => Unlimited => Unlimited
     pgsql.max_persistent => Unlimited => Unlimited

     ~  ~

5. status-save.sh  status-save.php  /user/service/bin 丮  


6. status-save.php ũƮ 
   Ʒ  CCDB GMS  ʿ  Ķ͵ ԷѴ.

     CCDB_NAME
     CCDB_USER
     CCDB_PASSWD
     CCDB_VIP
     CCDB_PORT
     GMS_IP
     GMS_STATUS_PORT #GMS  new_sh_statusd UDP port ȣ
     CC_NODE_NAME

   # vi /user/service/bin/status-save.php

    )
     ~  ~
     $db_handle = pg_connect("dbname=cs_ccdb user=solbox password=solbox host=10.10.10.10 port=5432");
 
     $server_addr[0][0] = "222.122.136.110";
     $server_addr[0][1] = "30001";
     $server_addr[0][2] = "KT-IDC";
     ~  ~


7. status-save.sh   Ӽ οѴ.

   # chmod +x /user/service/bin/status-save.sh


8. 5  ڵ  

   # vi /etc/crontab 

     ~  ~
     #
     # Status Save Script
     #
     */5 * * * * root /user/service/bin/status-save.sh >/dev/null


9. GMS   ȯ 

   # nmap -sU -p 30001 222.122.136.110

     Starting Nmap 5.51 ( http://nmap.org ) at 2013-08-06 16:51 KST
     Nmap scan report for 222.122.136.110
     Host is up (0.00037s latency).
     PORT      STATE SERVICE
     30001/udp open  unknown



˷ 
===========



