🇰🇷 한글 설명
WordPress 플러그인 'Appointment Booking Calendar — Simply Schedule Appointments Booking Plugin'의 1.6.11.8 이하 버전에서 'append_where_sql' 파라미터를 통한 시간 기반 블라인드 SQL 인젝션 취약점이 발견되었습니다. 인증되지 않은 공격자가 공개 nonce를 이용하여 /appointments/bulk REST 엔드포인트에 PUT 요청을 보내 데이터베이스에서 민감한 정보를 추출할 수 있습니다.
💡 쉬운 설명
WordPress 예약 플러그인에 데이터베이스를 조작할 수 있는 보안 구멍이 있습니다. 로그인하지 않은 공격자도 특별한 코드를 삽입하여 민감한 정보를 빼낼 수 있습니다.
🇺🇸 원문 (English)
The Appointment Booking Calendar — Simply Schedule Appointments Booking Plugin plugin for WordPress is vulnerable to time-based blind SQL Injection via the 'append_where_sql' parameter in all versions up to, and including, 1.6.11.8 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for unauthenticated attackers to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database. The /appointments/bulk REST endpoint is reachable by unauthenticated attackers because its permission check accepts a public nonce that is embedded in the booking widget's frontend JavaScript (ssa.api.public_nonce) and visible to all site visitors; exploitation requires issuing the request as a PUT with an application/x-www-form-urlencoded body so that PHP's superglobals are not populated and the blocklist check silently passes.
📍 영향받는 시스템
Simply Schedule Appointments Booking Plugin for WordPress versions up to and including 1.6.11.8
⚔️ 공격 벡터
Unauthenticated attacker sends PUT request with application/x-www-form-urlencoded body to /appointments/bulk endpoint with malicious 'append_where_sql' parameter exploiting public nonce
🛡️ 대응 방법
Update Simply Schedule Appointments Booking Plugin to version 1.6.11.9 or later immediately
🔧 검증 코드
명령 실행 후 나타나는 버전 번호가 1.6.11.9 이상이면 안전하고, 1.6.11.8 이하면 업데이트 필요
curl -s https://api.wordpress.org/plugins/info/1.0/simply-schedule-appointments.json | grep -oP '"version":\s*"\K[^"]+' | head -1