---
tags: lab
---
# IPDR 測試
## 測試資料

## CDR export
* 每日 7:00 將前一天的 cdr 資料從 db 上匯出
* log 目錄: `/log/session/`
* log 命名: `session_cdr_[YYYYMMDD].log`
* 檔案保存目錄: `/log/session/archive/[YYYYMMDD]`

### test
* 測試命令: `./ipdrd d`
* 成功輸出:
* 在檔案保存目錄會存放根據 db 上 `cdr_rule` 中的規則抓取不同類型的資料

* 失敗輸出:
* log

    [2022-07-01 10:26:21] [info] Export Session CDR start.
    [2022-07-01 10:26:21] [error] Export Session CDR failed. [/var/www/html/IPDREXE/log/session/archive/2022-07-01/E_GA_20220701.csv], [file open failed]

## CDR transport
* 每日 8:00 將 export 出的 cdr 資料上傳至 billing server
* log 目錄: `/log/transport/`
* log 命名: `transport_[YYYYMMDD].log`
* 檔案保存目錄: `/log/transport/archive/[YYYYMMDD]`

### test
* 測試命令: `./ipdrd b`
* 成功輸出:
* 在檔案保存目錄會存放上傳成功的 cdr 資料

* 失敗輸出:
* 嘗試上傳 3 次，都失敗才寫 log
* 利用 `atq` 命令來查詢再次上傳的工作佇列
* log

    [2022-07-01 12:10:01] [error] SFTP Session CDR failed. [/var/www/html/IPDREXE/log/session/archive/2022-07-01/meetme/E_GA_20220701.csv], [error connecting remote host: Failed to resolve hostname 140.116.82.2421 (Name or service not known)]
    [2022-07-01 12:10:01] [error] SFTP Session CDR failed. [/var/www/html/IPDREXE/log/session/archive/2022-07-01/meetme/E_GA_20220701.chtg], [error connecting remote host: Failed to resolve hostname 140.116.82.2421 (Name or service not known)]
    [2022-07-01 12:10:01] [error] SFTP Session CDR failed. [/var/www/html/IPDREXE/log/session/archive/2022-07-01/meetme/E_GA_20220701070000_2195.csv], [error connecting remote host: Failed to resolve hostname 140.116.82.2421 (Name or service not known)]

## CDR housekeeping
* 將超過 1100 天的 cdr 資料從 db 上移除，並留存備份
* log 目錄: `/log/housekeeping/`
* log 命名: `housekeeping_[YYYYMMDD].log`
* 檔案保存目錄: `/log/housekeeping/archive/`

### test
* 測試命令: `./ipdrd e`
* 成功輸出:
* 在檔案保存目錄會存放超過 1100 天的 cdr 資料

* 失敗輸出:
* log

    [2022-07-01 10:44:23] [info] CDR Housekeeping started.
    [2022-07-01 10:44:23] [error] CDR Housekeeping failed. [Cannot delete or update a parent row: a foreign key constraint fails (`IPDR`.`ipdr_main`, CONSTRAINT `ipdr_main_ibfk_1` FOREIGN KEY (`no`) REFERENCES `cdr` (`id`))]