웹훅 직접 테스트

현재 디렉토리 정보:

현재 경로: /var/www/html/plugin/paypal_subscription/test

파일 경로: /var/www/html/plugin/paypal_subscription/test/simple_test.php

파일 존재 확인:

그누보드 설정 확인:

DB 호스트: localhost

DB 사용자: root

DB 이름: gnu

비밀번호: (빈 문자열)

데이터베이스 직접 연결:

❌ 데이터베이스 연결 실패: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

로그 파일 확인:

✅ 로그 디렉토리 존재: /var/www/html/plugin/paypal_subscription/test/../logs

로그 파일들:

최신 로그 내용 (마지막 1000자):

subscriptions\/I-WG97NKF4XKGK","rel":"edit","method":"PATCH","encType":"application\/json"},{"href":"https:\/\/api.sandbox.paypal.com\/v1\/billing\/subscriptions\/I-WG97NKF4XKGK","rel":"self","method":"GET","encType":"application\/json"},{"href":"https:\/\/api.sandbox.paypal.com\/v1\/billing\/subscriptions\/I-WG97NKF4XKGK\/suspend","rel":"suspend","method":"POST","encType":"application\/json"},{"href":"https:\/\/api.sandbox.paypal.com\/v1\/billing\/subscriptions\/I-WG97NKF4XKGK\/capture","rel":"capture","method":"POST","encType":"application\/json"}],"id":"I-WG97NKF4XKGK","plan_id":"P-0PB27241B3787273PNCN6YIQ","status":"ACTIVE","status_update_time":"2025-08-13T01:37:02Z"},"links":[{"href":"https:\/\/api.sandbox.paypal.com\/v1\/notifications\/webhooks-events\/WH-02J28655NL943390D-8FF44419GA6002847","rel":"self","method":"GET"},{"href":"https:\/\/api.sandbox.paypal.com\/v1\/notifications\/webhooks-events\/WH-02J28655NL943390D-8FF44419GA6002847\/resend","rel":"resend","method":"POST"}]}}

웹훅 URL 테스트:

구독 활성화 시뮬레이션

웹훅 URL: https://www.thinkocn.com/plugin/paypal_subscription/includes/webhook.php

실제 웹훅 호출 테스트:

HTTP 응답: 200

응답 내용:

{"status":"success","message":"Webhook processed successfully","timestamp":"2025-08-23T15:11:57+09:00"}
웹훅 로그 (마지막 20줄):
[2025-08-23 12:41:34] [ERROR] Invalid request method | Data: {"method":"GET"}
[2025-08-23 15:11:56] [INFO] Gnuboard environment loaded | Data: {"path":"..\/..\/..\/common.php"}
[2025-08-23 15:11:56] [INFO] G5 table prefix set | Data: {"prefix":"g5_"}
[2025-08-23 15:11:56] [INFO] Webhook received | Data: {"method":"POST","payload_size":1002}
[2025-08-23 15:11:56] [INFO] Processing webhook event | Data: {"event_type":"BILLING.SUBSCRIPTION.ACTIVATED","event_id":"WH-2W724009AC2067914-5Z725107KP7987537","resource_id":"I-9FMY6D16NWL0","table_prefix":"g5_","full_payload":{"id":"WH-2W724009AC2067914-5Z725107KP7987537","event_version":"1.0","create_time":"2025-08-13T10:31:57.000Z","resource_type":"subscription","event_type":"BILLING.SUBSCRIPTION.ACTIVATED","summary":"Subscription activated","resource":{"id":"I-9FMY6D16NWL0","plan_id":"P-3MC99372MN303192FNCNWNAY","status":"ACTIVE","status_update_time":"2025-08-13T10:31:57Z","subscriber":{"email_address":"test@example.com","name":{"given_name":"Test","surname":"User"}},"billing_info":{"outstanding_balance":{"currency_code":"USD","value":"0.00"},"cycle_executions":[{"tenure_type":"REGULAR","sequence":1,"cycles_completed":0,"cycles_remaining":0}],"next_billing_time":"2026-08-13T10:31:57Z"},"create_time":"2025-08-13T10:31:57Z","links":[{"href":"https:\/\/api-m.sandbox.paypal.com\/v1\/billing\/subscriptions\/I-9FMY6D16NWL0","rel":"self","method":"GET"}]},"links":[{"href":"https:\/\/api-m.sandbox.paypal.com\/v1\/notifications\/webhooks-events\/WH-2W724009AC2067914-5Z725107KP7987537","rel":"self","method":"GET"}]}}
[2025-08-23 15:11:56] [INFO] Processing subscription activation | Data: {"paypal_sub_id":"I-9FMY6D16NWL0","plan_id":"P-3MC99372MN303192FNCNWNAY"}
[2025-08-23 15:11:56] [INFO] Executing SQL query | Data: {"sql":"SELECT * FROM g5_subscription WHERE paypal_sub_id = 'I-9FMY6D16NWL0'"}
[2025-08-23 15:11:56] [INFO] Member upgraded to premium | Data: {"mb_id":"test_user","level":5}
[2025-08-23 15:11:56] [INFO] Subscription activated successfully | Data: {"mb_id":"test_user"}
[2025-08-23 15:11:56] [INFO] Webhook processed successfully | Data: {"event_type":"BILLING.SUBSCRIPTION.ACTIVATED"}
[2025-08-23 15:11:57] [INFO] Gnuboard environment loaded | Data: {"path":"..\/..\/..\/common.php"}
[2025-08-23 15:11:57] [INFO] G5 table prefix set | Data: {"prefix":"g5_"}
[2025-08-23 15:11:57] [INFO] Webhook received | Data: {"method":"POST","payload_size":230}
[2025-08-23 15:11:57] [INFO] Processing webhook event | Data: {"event_type":"BILLING.SUBSCRIPTION.ACTIVATED","event_id":"WH-real-test-1755929517","resource_id":"I-9FMY6D16NWL0","table_prefix":"g5_","full_payload":{"id":"WH-real-test-1755929517","event_type":"BILLING.SUBSCRIPTION.ACTIVATED","resource":{"id":"I-9FMY6D16NWL0","plan_id":"P-3MC99372MN303192FNCNWNAY","status":"ACTIVE","billing_info":{"next_billing_time":"2026-08-13T10:31:57Z"}}}}
[2025-08-23 15:11:57] [INFO] Processing subscription activation | Data: {"paypal_sub_id":"I-9FMY6D16NWL0","plan_id":"P-3MC99372MN303192FNCNWNAY"}
[2025-08-23 15:11:57] [INFO] Executing SQL query | Data: {"sql":"SELECT * FROM g5_subscription WHERE paypal_sub_id = 'I-9FMY6D16NWL0'"}
[2025-08-23 15:11:57] [INFO] Member upgraded to premium | Data: {"mb_id":"test_user","level":5}
[2025-08-23 15:11:57] [INFO] Subscription activated successfully | Data: {"mb_id":"test_user"}
[2025-08-23 15:11:57] [INFO] Webhook processed successfully | Data: {"event_type":"BILLING.SUBSCRIPTION.ACTIVATED"}