ការថែទាំ

  # ពិនិត្យ status និង health នៃ containers ទាំងអស់
docker compose -f docker-compose.production.yml ps

# ស្វែងមើល logs ជាក់ស្ដែង (services ទាំងអស់)
docker compose -f docker-compose.production.yml logs -f

# ស្វែងមើល logs សម្រាប់ app តែប៉ុណ្ណោះ
docker compose -f docker-compose.production.yml logs -f rtcloud

# Restart container ម្ដង
docker compose -f docker-compose.production.yml restart rtcloud

# Stop services ទាំងអស់
docker compose -f docker-compose.production.yml down

# Start services ទាំងអស់
docker compose -f docker-compose.production.yml up -d

# បើក shell ក្នុង app container
docker compose -f docker-compose.production.yml exec rtcloud bash
  

  docker compose -f docker-compose.production.yml pull
  

  docker compose -f docker-compose.production.yml up -d
  

  RTCLOUD_IMAGE=rtawebteam/rta-smartsurvey:1.2.3
  

  docker compose -f docker-compose.production.yml exec mysql \
  mysqldump -u root -p"$(grep MYSQL_ROOT_PASSWORD .env | cut -d= -f2)" smartsurvey \
  > backup-$(date +%Y%m%d-%H%M%S).sql
  

  docker compose -f docker-compose.production.yml exec -T mysql \
  mysql -u root -p"$(grep MYSQL_ROOT_PASSWORD .env | cut -d= -f2)" smartsurvey \
  < backup-20240101-120000.sql
  

  # Backup uploads
docker run --rm \
  -v rtcloud_uploads:/data \
  -v "$(pwd):/backup" \
  alpine tar czf /backup/uploads-$(date +%Y%m%d).tar.gz -C /data .

# Backup audio recordings
docker run --rm \
  -v rtcloud_audios:/data \
  -v "$(pwd):/backup" \
  alpine tar czf /backup/audios-$(date +%Y%m%d).tar.gz -C /data .
  

  docker run --rm \
  -v rtcloud_uploads:/data \
  -v "$(pwd):/backup" \
  alpine tar xzf /backup/uploads-20240101.tar.gz -C /data
  

  # Daily database backup នៅ 2:00 AM, រក្សា 30 ថ្ងៃ
0 2 * * * cd /opt/rtcloud && docker compose -f docker-compose.production.yml exec -T mysql \
  mysqldump -u root -p"$(grep MYSQL_ROOT_PASSWORD .env | cut -d= -f2)" smartsurvey \
  > /backups/db-$(date +\%Y\%m\%d).sql && \
  find /backups -name "db-*.sql" -mtime +30 -delete
  

  docker compose -f docker-compose.production.yml logs rtcloud
  

  docker compose -f docker-compose.production.yml logs mysql
  

  CSRF_VALIDATION_ENABLED=false
  

  docker compose -f docker-compose.production.yml up -d --force-recreate rtcloud
  

  docker compose -f docker-compose.production.yml exec rtcloud php -r "
  \$salt = trim(shell_exec(\"mysql -h mysql -u root -p\\\"\${MYSQL_ROOT_PASSWORD}\\\" \${MYSQL_DATABASE} -se \\\"SELECT salt FROM ss_user WHERE username='admin';\\\"\"));
  echo md5(\$salt . 'newpassword') . PHP_EOL;
"
  

  docker compose -f docker-compose.production.yml exec mysql \
  mysql -u root -p"${MYSQL_ROOT_PASSWORD}" smartsurvey \
  -e "UPDATE ss_user SET password='<hash_from_step_1>' WHERE username='admin';"