모과이의꿈

NT에서의 SVN설치는 다소 쉽다.

1. 옮길려는 NT서버에 visualSVN Server 설치
- https://www.visualsvn.com/server/
- 무료인 Standard Edition 또는 유료 Enterprise Edition

2. Repositories 복사
- 원본 서버에서 VisualSVN Server Manager 실행
- [동작]-[모든작업]-[Start Comand Prompt] 실행

- svnadmin hotcopy 복사원본repository경로 복사위치
ex) svnadmin hotcopy d:/repositories/target d:/repos-backup2
- 또는 svnadmin dump 복사원본 복사위치
ex) svnadmin dump d:/repositories/target > d:/repos-backup2.dump

3. 복사된repositories를 옮길려는 NT서버로 복사
-일반적으로 c: 또는 d: 의 repositories 폴더 내

4. visualSVN server manager에서 좌측 repostitories 노드를 우클릭 후 [Import Existing Repository.]


5. Users 및 Groups 복사
- 원본 서버의 Repositories폴더 내 authz, authz-windows, htpasswd 파일을 복사하여 
신규 서버 내 Repositories폴더 내로 옮겨줌
-예전 버전 2 당시에는 authz 파일 내에 groups 정보가 들어 있었지만 3.3.0 버전 부터 groups.conf 파일로 옮겨짐
-따라서 다른 버전 간 복사시에는 authz 파일 내 [groups]부분 이하 내용을 groups.conf파일로 복사해줌


Move visualSVN to New NT server.

1. Install VisualSVN on new NT server.
- https://www.visualsvn.com/server/

2. Backup repositories
- excute "VisualSVN Server Manager"
- Click [Action]-[All tasks]-[StartCommand Prompt] on upper tab menu
- Using svnadmin hotcopy or svnadmin dump
ex) svnadmin hotcopy d:/repositories/target_repository d:/repos-backup2
ex) svnadmin dump d:/repositories/target_repository > d:/repos-backup2.dump

3. copy backup repositories files to new NT server

4. select repositories node and right clikc, then select [Import Existing Repository] 
on left space on visualSVN server manager on new NT server

5. copy Users and Groups
- If visualSVN is older than version 3.3 on older server, 
copy authz, authz-windows, htpasswd in "Repositories" folder to "Repositories" folder on New server
- copy contents of below [groups] in authz to groups.conf(It is groups info file upper version 3)

[출처]

http://egloos.zum.com/zeraf29/v/5892622

1. apmsetup 설치

2. 설치한 컴의 윈도우 방화벽 제어판에 -> 고급 -> 인바운드 -> mysql 포트 3306 TCP 추가

3. mysql workbench로 'anywhere'로 설정한 계정으로 DB 접속

성공~!

https://support.office.com/en-us/article/Add-holidays-and-vacation-days-83497cbf-9b6e-4805-8603-2a89038290a0

<?php 
include_once 'class.push.php'; 
$push = new pushmessage(); 

$params = array("pushtype"=>"android", $idphone=>"android_smart_phone_id_here", $mst=>"Hello, an android user"); 
$rtn = $push->sendMessage($params); 
//print_r($rtn); 

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

class.push.php

<?php 
/** 
 * Copyright 2014 Shop-Wiz.Com. 
 * 
 * Licensed under the Apache License, Version 2.0 (the "License"); you may 
 * not use this file except in compliance with the License. You may obtain 
 * a copy of the License at 
 * 
 * http://www.apache.org/licenses/LICENSE-2.0 
 * 
 * Unless required by applicable law or agreed to in writing, software 
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT 
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the 
 * License for the specific language governing permissions and limitations 
 * under the License. 
 */ 

class pushmessage{ 
     
     
     
    public $androidAuthKey = "Android Auth Key Here"; 
    public $iosApnsCert = "./certification/xxxxx.pem"; 
    
     /** 
     * For Android GCM 
     * $params["msg"] : Expected Message For GCM 
     */ 
    private function sendMessageAndroid($registration_id, $params) { 
        $this->androidAuthKey = "Android Auth Key Here";//Auth Key Herer 
         
        ## data is different from what your app is programmed 
        $data = array( 
                'registration_ids' => array($registration_id), 
                'data' => array( 
                                'gcm_msg' => $params["msg"] 
                            ) 
                ); 
         
         
        $headers = array( 
        "Content-Type:application/json", 
        "Authorization:key=".$this->androidAuthKey 
        ); 
         
         
        $ch = curl_init(); 
        curl_setopt($ch, CURLOPT_URL, "https://android.googleapis.com/gcm/send"); 
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); 
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); 
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); 
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); 
        curl_setopt($ch, CURLOPT_POST, true); 
        curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data)); 
        $result = curl_exec($ch); 
        //result sample {"multicast_id":6375780939476727795,"success":1,"failure":0,"canonical_ids":0,"results":[{"message_id":"0:1390531659626943%6cd617fcf9fd7ecd"}]} 
        //http://developer.android.com/google/gcm/http.html // refer error code 
        curl_close($ch); 
        
        $rtn["code"] = "000";//means result OK 
        $rtn["msg"] = "OK"; 
        $rtn["result"] = $result; 
        return $rtn; 
        
     } 
     
     
    /** 
     * For IOS APNS 
     * $params["msg"] : Expected Message For APNS 
     */ 
    private function sendMessageIos($registration_id, $params) { 
        
        $ssl_url = 'ssl://gateway.push.apple.com:2195'; 
        //$ssl_url = 'ssl://gateway.sandbox.push.apple.com:2195; //For Test 
        
        $payload = array(); 
        $payload['aps'] = array('alert' => array("body"=>$params["msg"], "action-loc-key"=>"View"), 'badge' => 0, 'sound' => 'default'); 
        ## notice : alert, badge, sound 

                 
        ## $payload['extra_info'] is different from what your app is programmed, this extra_info transfer to your IOS App 
        $payload['extra_info'] = array('apns_msg' => $params["msg"]); 
        $push = json_encode($payload); 
         
        //Create stream context for Push Sever. 
        $streamContext = stream_context_create(); 
        stream_context_set_option($streamContext, 'ssl', 'local_cert', $this->iosApnsCert); 

        $apns = stream_socket_client($ssl_url, $error, $errorString, 60, STREAM_CLIENT_CONNECT, $streamContext); 
        if (!$apns) { 

            $rtn["code"] = "001"; 
            $rtn["msg"] = "Failed to connect ".$error." ".$errorString; 
            return $rtn; 
        } 
         
        //echo 'error=' . $error; 
        $t_registration_id = str_replace('%20', '', $registration_id); 
        $t_registration_id = str_replace(' ', '', $t_registration_id); 
        $apnsMessage = chr(0) . chr(0) . chr(32) . pack('H*', str_replace(' ', '', $t_registration_id)) . chr(0) . chr(strlen($push)) . $push; 
         
        $writeResult = fwrite($apns, $apnsMessage); 
        fclose($apns); 
        
        $rtn["code"] = "000";//means result OK 
        $rtn["msg"] = "OK"; 
        return $rtn; 

    }//private function sendMessageIos($registration_id, $msg, $link, $type) { 
           
            
        
       /** 
     * Send message to SmartPhone 
     * $params [pushtype, msg, registration_id] 
     */ 
       public function sendMessage($params){ 
           
        //$parm = array("msg"=>$params["msg"]); 
        if($params["registration_id"] && $params["msg"]){ 
               switch($params["pushtype"]){ 
                   case "ios": 
                    $this->sendMessageIos($params["registration_id"], $params); 
                    break; 
                case "android": 
                    $this->sendMessageAndroid($params["registration_id"], $params); 
                    break; 
               } 
        } 

       } 
    
   
    /* 
     * Sample For database 
     * regist phone Id from Phone to Mysql via controllers 
     * Look a tableSchema at the bottom 
     * @ $params["appType"] : android or ios.. 
     * @ $params["appId"] : //APA91bGEGu5NSyYDYp5OMO4mZ0j1n2DznGARaNFVcCYfLHvHat..... or 6b1653ad818a89fc6937f5067a9b372aec79edeb9504d6ef.... 
     **/ 
    public function registration($params){ 
        $pushtype = $params["pushtype"]; 
        $idphone = $params["idphone"]; 
        
        print_r($params); 
        //{insert into database} 
        echo json_encode($rtn); 
    } 
     
     
    /** 
     * Step 2. 
     * Send message to each iphone from web App. 
     * @params : Array() : messages () 
     */ 
    public function send($params){ 
        //$sql = "select pushtype, idphone from gcmapns "; 
       // $rows = $CI->db->get_rows($sql); 
       //get data from database and save to $rows 
        if(is_array($rows)){ 
            foreach($rows as $key => $val){ 
                switch($val["pushtype"]){ 
                    case "ios": 
                        $rtn = $this->sendMessageIos($val["idphone"], $params); 
                        break; 
                    case "android": 
                        $rtn = $this->sendMessageAndroid($val["idphone"], $params); 
                        break; 
                }//switch($val["pushtype"]){ 
            }//foreach($rows as $key => $val){ 
        }//if(is_array($rows)){ 

         
    }//function send(){ 
            
         
     

                 
}