Project

General

Profile

运维支持 #3

Do system maintenance of our OTS website (order.easydingzhi.com) regularly

Added by Xihua Fan about 5 years ago. Updated 12 days ago.

Status:
进行中
Priority:
普通
Assignee:
Xihua Fan
Target version:
-
Start date:
11/09/2020
Due date:
12/31/2025 (Due in 11 days)
% Done:

90%

Estimated time:
100.00 h
Spent time:
17.70 h

Description

Task Details
  • 1. Check EBS/EFS Usage
    eg：
    $df -h
/dev/nvme0n1p1                                      10G  5.7G  4.4G  57% /
fs-e2864107.efs.cn-northwest-1.amazonaws.com.cn:/  8.0E  8.6G  8.0E   1% /efs
  • 2. Check Httpd Log
    /var/log/httpd/ssl_error_log
    /var/log/httpd/error_log
  • 3. Check PHP Log
    /var/log/php-fpm/www-error.log
  • 4. DB Data Backup
    • View: crontab -l
    • Edit: crontab -e
    • Current configuration:
      No. Project Time Server Script
      1 Redmine 00:00 daily v3：52.83.77.219 /var/www/html/shell/databasebk.sh
      2 OTS3.0 00:00 daily v3：52.83.77.219 /var/www/html/shell/databasebk.sh
      3 OTS4.0 00:00 daily v4：13.214.192.143 /var/www/shell/databasebk.sh
  • 5. Monitor the amount of data in the t_order_history table, if it exceeds 100,000 entries, please provide feedback to the group to discuss a solution.
    SELECT COUNT(*) FROM `t_order_history`;
  • 6. Transfer uploaded files from OTS to Onedrive(Jiuting Group - Documents\OTS-Backup\uploadedFile) once a year.
  • 7. Check starting service
    sudo netstat -nltp

1. httpd(80/443)
3. mysqld(3306/33060)
  • 8. Check the LifeCircle for the Amazon Linux 2
    Some information shows: AL2 End of Life is 2025-06-30.
  • 9. Check SSL
  • 10. Check php.ini (v4 only)
    upload_tmp_dir = /var/www/html/storage/upload/tmp
    • 切换tmp的步骤 （Note: 因为php-fpm 服务开启了PrivateTmp 功能，/tmp 和 /var/tmp/ 与其他服务隔离。这需要php指定的tmp目录排除这2个目录。）
      1. 创建临时目录：
mkdir -p /var/www/html/storage/upload/tmp
chown apache:apache /var/www/html/storage/upload/tmp
chmod 700 /var/www/html/storage/upload/tmp

2. 编辑：/etc/php.ini
upload_tmp_dir = /var/www/html/storage/upload/tmp

3. 重启服务
systemctl restart php-fpm
systemctl restart httpd
    • 将来整个storage目录移动到EFS下，记得这里需要修改php.ini
Input
  1. Domain: order.easydingzhi.com
  2. AWS: www.amazonaws.cn
    Account ID->585080865408
    IAM user name->XXX
    Password->XXX
Output
  • Similar to the following example:
  1. Check EBS usage: Used 5.7G (57%)
  2. Check EFS usage: Used 8.6G (1%)
  3. Check Httpd Log: Abnormal(found proxy_fcgi:error)
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/XXXX_20201116.zip
    /efs/ots_dbbackup/XXXX_20201116.zip
Others
  • Maintenance cycle
    Just started: weekly execution (for example, Friday)
    Stable period: monthly execution (such as the end of the month)
#1

Updated by Zhongbao Ye about 5 years ago

  • Assignee changed from Zhongbao Ye to Xihua Fan
#2

Updated by Xihua Fan about 5 years ago

  • Assignee changed from Xihua Fan to Zhongbao Ye
#3

Updated by Zhongbao Ye about 5 years ago

  • Status changed from 新建 to 进行中
  • % Done changed from 0 to 10
Output (2020/11/13)
  1. Check EBS usage: Used 5.9G (12%)
  2. Check EFS usage: Used 390M (1%)
  3. Check Httpd Log: 
    ssl_error_log:
[proxy_fcgi:error]

error_log
[age/Cor/SecurityUpdateChecker]
[Cor/CoreMain.cpp]
  4. Check PHP Log: Normal
  5. Check Bills: Normal
#4

Updated by Xihua Fan about 5 years ago

  1. Check Httpd Log:
ssl_error_log:
[proxy_fcgi:error]

error_log
[age/Cor/SecurityUpdateChecker]
[Cor/CoreMain.cpp]

暂时没有得到现场关于此问题的错误报告，所以不另外开票处理。
（以上可以作为下次运维的结果判断）

#5

Updated by Xihua Fan about 5 years ago

  • Description updated (diff)
#6

Updated by Xihua Fan about 5 years ago

  • Copied to 解析Bug #36: Display the irregular text (strtoupper("LARGE ")) when exporting to Excel added
#7

Updated by Xihua Fan about 5 years ago

  • Copied to deleted (解析Bug #36: Display the irregular text (strtoupper("LARGE ")) when exporting to Excel)
#8

Updated by Zhongbao Ye about 5 years ago

Output (2020/11/20)
  1. Check EBS usage: Used 6G (12%)
  2. Check EFS usage: Used 710M (1%)
  3. Check Httpd Log: Normal
  4. Check PHP Log: Normal
  5. Check Bills: Normal
#9

Updated by Xihua Fan about 5 years ago

5. Backup DB:
/efs/redmine_dbbackup/XXXX_20201116.zip
/efs/ots_dbbackup/XXXX_20201116.zip

忘了提醒，有空请做一下备份处理，结果如上

#10

Updated by Zhongbao Ye about 5 years ago

Output (2020/11/28)
  1. Check EBS usage: Used 6G (12%)
  2. Check EFS usage: Used 1.1G (1%)
  3. Check Httpd Log: Normal
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20201128.zip
/efs/ots_dbbackup/ots_20201128.zip
#11

Updated by Zhongbao Ye about 5 years ago

Output (2020/12/05)
  1. Check EBS usage: Used 5.9G (12%)
  2. Check EFS usage: Used 1.3G (1%)
  3. Check Httpd Log: 
    1. 带有关键词【age/Cor/CoreMain.cpp】【age/Cor/SecurityUpdateChecker】这一类的error

经过调查，发现跟redmine配置环境有关，参考该文档：https://stackoverflow.com/questions/42053485/redmine-archlinux-apache-passenger

2. error.log:[cgi:error] [pid 18975] [client 180.76.155.216:44963] AH02811: script not found or unable to stat: /var/www/cgi-bin/php
以下解释说明内容来源于网络：：https://serverfault.com/questions/549893/script-not-found-or-unable-to-stat-usr-lib-cgi-bin-php-cgi

If you're running a default configuration of Apache on Ubuntu (or have used the default config as a blind template for other virtualhost directives) you'll likely find that you have a ScriptAlias directive mapping /cgi-bin/ (relative to the apache document root) to the filesystem location of /usr/lib/cgi-bin/ - so what they're actually trying to load is http://your.host.name/cgi-bin/php4.

If you're not using your cgi-bin for anything, you're unlikely to lose anything you care about by commenting out the sections relating to it (and the more defined to your needs your configuration is, the smaller any potential attack surface).

You'll find the relevant directives for the default site in /etc/apache2/sites-available/000-default, if memory serves.


    *solution*
* 以上2个问题，暂时没有发现不利影响，暂不处理，后续继续观察！
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20201205.zip
/efs/ots_dbbackup/ots_20201205.zip

后续创建定时任务，定时备份。
crontab文件：/var/spool/cron/root,每周五18点备份以上2个数据库
0 18 * * 5 /var/www/html/shell/databasebk.sh
#12

Updated by Zhongbao Ye about 5 years ago

Output (2020/12/13)
  1. Check EBS usage: Used 5.9G (12%)
  2. Check EFS usage: Used 1.6G (1%)
  3. Check Httpd Log: Normal
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20201211.sql.gz
/efs/ots_dbbackup/ots_20201211.sql.gz
#13

Updated by Zhongbao Ye almost 5 years ago

Output (2020/12/20)
  1. Check EBS usage: Used 5.9G (12%)
  2. Check EFS usage: Used 1.9G (1%)
  3. Check Httpd Log: Normal
  4. Check PHP Log: Normal
    [21-Dec-2020 16:05:22 Asia/Shanghai] PHP Fatal error:  'continue' not in the 'loop' or 'switch' context in /var/www/html/order/protected/actions/order/RemoveAction.php on line 257

    以上错误 #69 对应
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20201218.sql.gz
/efs/ots_dbbackup/ots_20201218.sql.gz
#14

Updated by Zhongbao Ye almost 5 years ago

Output (2020/12/25)
  1. Check EBS usage: Used 6G (12%)
  2. Check EFS usage: Used 2G (1%)
  3. Check Httpd Log
    ssl_error_log:

[Wed Dec 23 20:57:24.042789 2020] [proxy_fcgi:error] [pid 20706] (70008)Partial results are valid but processing is incomplete: [client 94.137.115.66:65454] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

关于[proxy_fcgi:error] 这种错误，原来只关注Easydingzhi服务器上该问题造成的影响，参考 #11。关于此问题，该服务器已同步问题 #11 的修改，下次运维时关注这个问题，有没有效果有待观察。
  4. Check PHP Log
    www-error.log：

[22-Dec-2020 16:53:41 Asia/Shanghai] PHP Fatal error:  'continue' not in the 'loop' or 'switch' context in /var/www/html/order/protected/actions/order/RemoveAction.php on line 257

该问题Van已修复，参考问题: #69。
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20201225.sql.gz
/efs/ots_dbbackup/ots_20201225.sql.gz
#15

Updated by Zhongbao Ye almost 5 years ago

Output (2020/01/03)
  1. Check EBS usage: Used 6.7G (14%)
  2. Check EFS usage: Used 2.1G (1%)
  3. Check Httpd Log: Normal
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20210101.sql.gz
/efs/ots_dbbackup/ots_20210101.sql.gz
#16

Updated by Zhongbao Ye almost 5 years ago

Output (2020/01/10)
  1. Check EBS usage: Used 6.8G (14%)
  2. Check EFS usage: Used 2.2G (1%)
  3. Check Httpd Log: Normal
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20210108.sql.gz
/efs/ots_dbbackup/ots_20210108.sql.gz
#17

Updated by Zhongbao Ye almost 5 years ago

Output (2020/01/17)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 2.4G (1%)
  3. Check Httpd Log: Normal
    ssl_error_log:
[Fri Jan 15 17:19:01.695849 2021] [proxy_fcgi:error] [pid 24865] (70007)The timeout specified has expired: [client 94.137.115.66:52692] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误监控下来，发现依然存在，并且最近一周多次出现，相关问题解决方案，对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20210115.sql.gz
/efs/ots_dbbackup/ots_20210115.sql.gz
#18

Updated by Zhongbao Ye almost 5 years ago

Output (2020/01/22)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 2.5G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Thu Jan 21 23:09:49.912321 2021] [proxy_fcgi:error] [pid 16321] (70007)The timeout specified has expired: [client 188.150.88.90:52333] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误监控下来，发现依然存在，并且最近一周多次出现，相关问题解决方案，对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20210122.sql.gz
/efs/ots_dbbackup/ots_20210122.sql.gz
#19

Updated by Zhongbao Ye almost 5 years ago

Output (2020/01/29)
  1. Check EBS usage: Used 7G (14%)
  2. Check EFS usage: Used 2.7G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Fri Jan 29 16:03:58.679572 2021] [proxy_fcgi:error] [pid 17271] (70007)The timeout specified has expired: [client 188.150.88.90:52974] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误监控下来，发现依然存在，连续一个月，每天都有该错误的记录，相关问题解决方案，对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20210129.sql.gz
/efs/ots_dbbackup/ots_20210129.sql.gz
#20

Updated by Zhongbao Ye almost 5 years ago

Output (2020/02/8)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 2.9G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Fri Jan 29 16:03:58.679572 2021] [proxy_fcgi:error] [pid 17271] (70007)The timeout specified has expired: [client 188.150.88.90:52974] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误监控下来，发现依然存在，连续一个月，每天都有该错误的记录，相关问题解决方案，对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB:
    /efs/redmine_dbbackup/redmine_20210205.sql.gz
/efs/ots_dbbackup/ots_20210205.sql.gz
#21

Updated by Zhongbao Ye almost 5 years ago

Output (2020/02/21)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 3.1G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Thu Feb 18 15:36:18.844237 2021] [proxy_fcgi:error] [pid 11501] (70008)Partial results are valid but processing is incomplete: [client 188.150.88.90:52149] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误监控下来，发现依然存在，连续一个月，每天都有该错误的记录，相关问题解决方案，对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB:2周备份数据
    /efs/redmine_dbbackup/redmine_20210212.sql.gz
/efs/redmine_dbbackup/redmine_20210219.sql.gz
/efs/ots_dbbackup/ots_20210212.sql.gz
/efs/ots_dbbackup/ots_20210219.sql.gz
#22

Updated by Zhongbao Ye almost 5 years ago

Output (2020/02/28)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 3.3G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Thu Feb 25 15:36:18.844237 2021] [proxy_fcgi:error] [pid 11501] (70008)Partial results are valid but processing is incomplete: [client 188.150.88.90:52149] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210226.sql.gz
/efs/ots_dbbackup/ots_20210226.sql.gz
#23

Updated by Zhongbao Ye almost 5 years ago

Output (2020/03/7)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 5.1G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Fri Mar 05 23:09:02.266040 2021] [proxy_fcgi:error] [pid 31885] (70007)The timeout specified has expired: [client 188.150.88.90:60392] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210305.sql.gz
/efs/ots_dbbackup/ots_20210305.sql.gz
#24

Updated by Zhongbao Ye almost 5 years ago

Output (2020/03/14)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 5.4G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Fri Mar 13 23:09:02.266040 2021] [proxy_fcgi:error] [pid 31885] (70007)The timeout specified has expired: [client 188.150.88.90:60392] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210312.sql.gz
/efs/ots_dbbackup/ots_20210312.sql.gz
#25

Updated by Zhongbao Ye over 4 years ago

Output (2020/03/22)
  1. Check EBS usage: Used 7G (14%)
  2. Check EFS usage: Used 6.2G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Sat Mar 20 13:56:43.619595 2021] [proxy_fcgi:error] [pid 13419] (70007)The timeout specified has expired: [client 123.149.87.62:17603] AH01075: Error dispatching request to : (polling), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210319.sql.gz
/efs/ots_dbbackup/ots_20210319.sql.gz
#26

Updated by Zhongbao Ye over 4 years ago

Output (2020/03/28)
  1. Check EBS usage: Used 7G (14%)
  2. Check EFS usage: Used 6.5G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Mon Mar 22 21:39:53.774737 2021] [proxy_fcgi:error] [pid 14993] (70008)Partial results are valid but processing is incomplete: [client 94.137.115.66:51247] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210326.sql.gz
/efs/ots_dbbackup/ots_20210326.sql.gz
#27

Updated by Zhongbao Ye over 4 years ago

Output (2020/04/02)
  1. Check EBS usage: Used 7G (14%)
  2. Check EFS usage: Used 6.8G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Thu Apr 01 12:35:26.703089 2021] [proxy_fcgi:error] [pid 12641] (70007)The timeout specified has expired: [client 123.149.86.137:14905] AH01075: Error dispatching request to : (polling), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210402.sql.gz
/efs/ots_dbbackup/ots_20210402.sql.gz
#28

Updated by Zhongbao Ye over 4 years ago

Output (2020/04/09)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 7.0G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Thu Apr 04 12:35:26.703089 2021] [proxy_fcgi:error] [pid 12641] (70007)The timeout specified has expired: [client 123.149.86.137:14905] AH01075: Error dispatching request to : (polling), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_202104092.sql.gz
/efs/ots_dbbackup/ots_20210409.sql.gz
#29

Updated by Xihua Fan over 4 years ago

  • % Done changed from 10 to 50

我们检查频率改为1月2次（或者说2周一次）

#30

Updated by Zhongbao Ye over 4 years ago

Output (2020/04/25)
  1. Check EBS usage: Used 7.2G (15%)
  2. Check EFS usage: Used 8.1G (1%)
  3. Check Httpd Log:
    ssl_error_log:
[Fri Apr 23 21:52:06.409233 2021] [proxy_fcgi:error] [pid 2805] (70008)Partial results are valid but processing is incomplete: [client 94.137.115.66:50344] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210416.sql.gz
/efs/redmine_dbbackup/redmine_20210423.sql.gz

/efs/ots_dbbackup/ots_20210416.sql.gz
/efs/ots_dbbackup/ots_20210423.sql.gz
#31

Updated by Zhongbao Ye over 4 years ago

Output (2020/05/08)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 9.0G (1%)
  3. Check Httpd Log:
    [Fri May 07 22:28:08.516671 2021] [proxy_fcgi:error] [pid 7456] (70008)Partial results are valid but processing is incomplete: [client 94.137.115.66:64815] AH01075: Error dispatching request to : (reading input brigade), referer: https://order.easydingzhi.com/order

这种错误对应问题 #11。后续继续观察此问题。
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210430.sql.gz
/efs/redmine_dbbackup/redmine_20210507.sql.gz

/efs/ots_dbbackup/ots_20210430.sql.gz
/efs/ots_dbbackup/ots_20210507.sql.gz
#32

Updated by Zhongbao Ye over 4 years ago

Output (2020/05/24)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 11.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210514.sql.gz
/efs/redmine_dbbackup/redmine_20210521.sql.gz

/efs/ots_dbbackup/ots_20210514.sql.gz
/efs/ots_dbbackup/ots_20210521.sql.gz
#33

Updated by Zhongbao Ye over 4 years ago

Output (2020/06/11)
  1. Check EBS usage: Used 7.2G (15%)
  2. Check EFS usage: Used 12.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210604.sql.gz
/efs/redmine_dbbackup/redmine_20210611.sql.gz

/efs/ots_dbbackup/ots_20210604.sql.gz
/efs/ots_dbbackup/ots_20210611.sql.gz
#34

Updated by Zhongbao Ye over 4 years ago

Output (2021/07/05)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 14.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210618.sql.gz
/efs/redmine_dbbackup/redmine_20210625.sql.gz
/efs/redmine_dbbackup/redmine_20210702.sql.gz

/efs/ots_dbbackup/ots_20210618.sql.gz
/efs/ots_dbbackup/ots_20210625.sql.gz
/efs/ots_dbbackup/ots_20210702.sql.gz
#35

Updated by Zhongbao Ye over 4 years ago

Output (2021/07/19)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 15.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210709.sql.gz
/efs/redmine_dbbackup/redmine_20210716.sql.gz

/efs/ots_dbbackup/ots_20210709.sql.gz
/efs/ots_dbbackup/ots_20210716.sql.gz
#36

Updated by Zhongbao Ye over 4 years ago

Output (2021/08/06)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 16.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210723.sql.gz
/efs/redmine_dbbackup/redmine_20210730.sql.gz

/efs/ots_dbbackup/ots_20210723.sql.gz
/efs/ots_dbbackup/ots_20210730.sql.gz
#37

Updated by Zhongbao Ye over 4 years ago

Output (2021/08/23)
  1. Check EBS usage: Used 7.3G (15%)
  2. Check EFS usage: Used 18.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210806.sql.gz
/efs/redmine_dbbackup/redmine_20210813.sql.gz
/efs/redmine_dbbackup/redmine_20210020.sql.gz

/efs/ots_dbbackup/ots_20210806.sql.gz
/efs/ots_dbbackup/ots_20210813.sql.gz
/efs/ots_dbbackup/ots_20210820.sql.gz
#38

Updated by Zhongbao Ye over 4 years ago

  • Assignee changed from Zhongbao Ye to Xihua Fan
#39

Updated by Xihua Fan over 4 years ago

Output (2021/09/15)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 20.0G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20210910.sql.gz
/efs/ots_dbbackup/ots_20210910.sql.gz
#40

Updated by Xihua Fan about 4 years ago

  • Assignee changed from Xihua Fan to Yinghua Wu
#41

Updated by Yinghua Wu about 4 years ago

Output (2021/10/11)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 22G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20211008.sql.gz
/efs/ots_dbbackup/ots_20211008.sql.gz
#42

Updated by Yinghua Wu about 4 years ago

Output (2021/11/22)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 28G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20211119.sql.gz
/efs/ots_dbbackup/ots_20211119.sql.gz
#43

Updated by Yinghua Wu about 4 years ago

Output (2021/12/13)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 29G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20211210.sql.gz
/efs/ots_dbbackup/ots_20211210.sql.gz
#44

Updated by Yinghua Wu almost 4 years ago

Output (2022/01/06)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 29G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20211231.sql.gz
/efs/ots_dbbackup/ots_20211231.sql.gz
#45

Updated by Yinghua Wu almost 4 years ago

Output (2022/02/07)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 30G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220204.sql.gz
/efs/ots_dbbackup/ots_20220204.sql.gz
#46

Updated by Yinghua Wu over 3 years ago

Output (2022/03/28)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 36G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220325.sql.gz
/efs/ots_dbbackup/ots_20220325.sql.gz
#47

Updated by Yinghua Wu over 3 years ago

Output (2022/04/20)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 37G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220415.sql.gz
/efs/ots_dbbackup/ots_20220415.sql.gz
#48

Updated by Xihua Fan over 3 years ago

To Gavin

/efs/redmine_dbbackup/redmine_20220415.sql.gz
/efs/ots_dbbackup/ots_20220415.sql.gz

快一个月了，不要忘了做检查，另外以上2个备份数据库是按周的，你可以删除一些旧的文件（比如只留2个最新的）

#49

Updated by Yinghua Wu over 3 years ago

Output (2022/05/20)
  1. Check EBS usage: Used 6.8G (14%)
  2. Check EFS usage: Used 39G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220513.sql.gz
/efs/ots_dbbackup/ots_20220513.sql.gz
#50

Updated by Yinghua Wu over 3 years ago

Output (2022/06/15)
  1. Check EBS usage: Used 6.8G (14%)
  2. Check EFS usage: Used 12G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220610.sql.gz
/efs/ots_dbbackup/ots_20220610.sql.gz
#51

Updated by Yinghua Wu over 3 years ago

Output (2022/07/11)
  1. Check EBS usage: Used 6.8G (14%)
  2. Check EFS usage: Used 14G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220708.sql.gz
/efs/ots_dbbackup/ots_20220708.sql.gz
#52

Updated by Yinghua Wu over 3 years ago

Output (2022/08/03)
  1. Check EBS usage: Used 6.9G (14%)
  2. Check EFS usage: Used 18G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220729.sql.gz
/efs/ots_dbbackup/ots_20220729.sql.gz
#53

Updated by Yinghua Wu over 3 years ago

Output (2022/09/02)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 22G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220826.sql.gz
/efs/ots_dbbackup/ots_20220826.sql.gz
#54

Updated by Yinghua Wu about 3 years ago

Output (2022/09/30)
  1. Check EBS usage: Used 7.0G (14%)
  2. Check EFS usage: Used 27G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20220923.sql.gz
/efs/ots_dbbackup/ots_20220923.sql.gz
#55

Updated by Yinghua Wu about 3 years ago

  • Assignee changed from Yinghua Wu to Xihua Fan
#56

Updated by Xihua Fan almost 3 years ago

Output (2023/02/26)
  1. Check EBS usage: Used 7.1G (15%)
  2. Check EFS usage: Used 50G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20230224.sql.gz
/efs/ots_dbbackup/ots_20230224.sql.gz
#57

Updated by Xihua Fan over 2 years ago

  • % Done changed from 50 to 90
#58

Updated by Xihua Fan over 2 years ago

Output (2023/07/23)
  1. Check EBS usage: Used 7.7G (16%)
  2. Check EFS usage: Used 78G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20230721.sql.gz
/efs/ots_dbbackup/ots_20230721.sql.gz
  6. SSL Updated （Expires On Saturday, August 10, 2024 at 7:59:59 AM）
#59

Updated by Zhongbao Ye over 2 years ago

  • Description updated (diff)
#60

Updated by Zhongbao Ye almost 2 years ago

Output (2024/02/02)
  1. Check EBS usage: Used 8.7G (18%)
  2. Check EFS usage: Used 111G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20240126.sql.gz
/efs/ots_dbbackup/ots_20240126.sql.gz
#61

Updated by Xihua Fan over 1 year ago

Output (2024/04/01)
  1. Check EBS usage: Used 9.2G (19%)
  2. Check EFS usage: Used 123G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
    /efs/redmine_dbbackup/redmine_20240329.sql.gz
/efs/ots_dbbackup/ots_20240329.sql.gz
#62

Updated by Xihua Fan over 1 year ago

  • Description updated (diff)
#63

Updated by Xihua Fan over 1 year ago

Output (2024/07/26)
  1. Check EBS usage: Used 8.7G (18%)
  2. Check EFS usage: Used 74G (1%)
  3. Check Httpd Log:Normal
  4. Check PHP Log: Normal
  5. Backup DB：
      /efs/redmine_dbbackup/redmine_20240719.sql.gz
  /efs/ots_dbbackup/ots_20240719.sql.gz
  6. Transfer uploaded files(2022/01/01 - 2023/06/30) from OTS to Onedrive(Jiuting Group - Documents\OTS-Backup\uploadedFile).
  7. Create the new repository (ots-web)
    https://git-codecommit.cn-northwest-1.amazonaws.com.cn/v1/repos/ots-web
#64

Updated by Xihua Fan over 1 year ago

  • Description updated (diff)
#65

Updated by Xihua Fan over 1 year ago

  • Description updated (diff)
#66

Updated by Xihua Fan over 1 year ago

Output (2024/08/10)
  1. Check EBS/EFS Usage
    1. ESB: Used 8.5G (17%)
    2. EFS: Used 75G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/redmine_dbbackup/redmine_20240809.sql.gz
  /efs/ots_dbbackup/ots_20240809.sql.gz
  5. Monitor the amount of data in the t_order_history table: Normal
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2: Safe
  9. Check SSL: Normal (Expires On Thursday, November 7, 2024 at 7:59:59 AM)
#67

Updated by Xihua Fan over 1 year ago

  • Description updated (diff)
#68

Updated by Xihua Fan about 1 year ago

  • Target version set to v3.0
#69

Updated by Xihua Fan about 1 year ago

  • Target version deleted (v3.0)
#70

Updated by Xihua Fan about 1 year ago

Output (2024/11/05)
  1. Check EBS/EFS Usage
    1. ESB: Used 8.4G (17%)
    2. EFS: Used 96G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/redmine_dbbackup/redmine_20241101.sql.gz
  /efs/ots_dbbackup/ots_20241101.sql.gz
  5. Monitor the amount of data in the t_order_history table: Normal
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2: Safe
  9. Check SSL: Normal (Expires On Sunday, February 2, 2025 at 7:59:59 AM)
#71

Updated by Xihua Fan 11 months ago

  • Description updated (diff)
#72

Updated by Xihua Fan 11 months ago

Output (2025/01/23)
  1. Check EBS/EFS Usage
    1. ESB: Used 8.4G (17%)
    2. EFS: Used 105G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/redmine_dbbackup/redmine_20250117.sql.gz
  /efs/ots_dbbackup/ots_20250117.sql.gz
  5. Monitor the amount of data in the t_order_history table: Normal
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2: Safe
  9. Check SSL: Normal (Expires On Thursday 24 April 2025 at 07:59:59)
#73

Updated by Xihua Fan 8 months ago

Output (2025/04/20) - OTS3.0
  1. Check EBS/EFS Usage
    1. ESB: Used 9.0G (18%)
    2. EFS: Used 119G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/redmine_dbbackup/redmine_20250419.sql.gz
  /efs/ots_dbbackup/ots3.0_20250419.sql.gz
  5. Monitor the amount of data in the t_order_history table: Normal
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2: Safe
  9. Check SSL: Normal (Thursday, July 17, 2025 at 7:59:59 AM)
#74

Updated by Xihua Fan 6 months ago

Output (2025/06/20) - OTS4.0

  1. Check EBS/EFS Usage
    1. ESB: Used 7.4G (15%)
    2. EFS: Used 126G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/ots4.0_dbbackup/ots4.0_20250614.sql.gz
  5. Monitor the amount of data in the ots_order_history table: Normal
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2023: Safe
  9. Check SSL: Not Used
#75

Updated by Xihua Fan 5 months ago

Output (2025/07/13) - OTS3.0
  1. Check EBS/EFS Usage
    1. ESB: Used 9.9G (20%)
    2. EFS: Used 128G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/redmine_dbbackup/redmine_20250712.sql.gz
  /efs/ots_dbbackup/ots3.0_20250712.sql.gz
  5. Monitor the amount of data in the t_order_history table: Normal
    Will remove some old data
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2: Safe
  9. Check SSL: Normal (Friday, October 10, 2025 at 7:59:59 AM)
#76

Updated by Xihua Fan 3 months ago

Output (2025/09/26) - OTS3.0
  1. Check EBS/EFS Usage
    1. ESB: Used 11G (22%)
    2. EFS: Used 136G (1%)
  2. Check Httpd Log: Normal
  3. Check PHP Log: Normal
  4. DB Data Backup：
      /efs/redmine_dbbackup/redmine_20250920.sql.gz
  /efs/ots_dbbackup/ots3.0_20250920.sql.gz
  5. Monitor the amount of data in the t_order_history table: Normal
    Will remove some old data
  6. Transfer uploaded files: Skip
  7. Check starting service: Normal
  8. Check the LifeCircle for the Amazon Linux 2: Safe
  9. Check SSL: Normal (Tuesday, December 23, 2025 at 7:59:59 AM)
#77

Updated by Xihua Fan about 1 month ago

  • Description updated (diff)
#78

Updated by Zhongbao Ye about 1 month ago

  • Description updated (diff)
#79

Updated by Zhongbao Ye about 1 month ago

  • Description updated (diff)
#80

Updated by Zhongbao Ye 29 days ago

  • Description updated (diff)
#81

Updated by Zhongbao Ye 29 days ago

  • Description updated (diff)
#82

Updated by Zhongbao Ye 29 days ago

  • Description updated (diff)
#83

Updated by Zhongbao Ye 12 days ago

  • Description updated (diff)

Also available in: Atom PDF