PayPal Transaction Not Crediting Pharos Account

Issue Description

PayPal transactions are successfully processed but do not reflect in the Pharos account balance. The issue persists despite successful authentication and transaction completion. Connectivity and settings appear correct, but funds are not being credited.

Reported Symptoms

• PayPal transaction completes successfully.
• No update is reflected in the Pharos user balance.
• The PayPal API and Pharos API endpoints are reachable.
• IIS logs show a 302 redirect for PayPal requests.
• LogProcessor does not show any transaction records.
• SQLite transaction logs do not update.

Verification Steps

Verify PayPal API and Pharos API Connectivity

• Confirm that both Pharos API and PayPal API endpoints are accessible.
• Use telnet to PayPal on port 443 to confirm connectivity.
• Review IIS logs for 302 redirects or blocked requests when PayPal attempts to communicate with Pharos.

Check PayPal Instant Payment Notification (IPN) Settings

• Ensure that the PayPal IPN (Instant Payment Notification) feature is enabled.
• Confirm that the IPN URL is correctly set to:
  perl
  CopiarEditar
  https://<server>/PharosAPI/PayPal
• Review the PayPal IPN history to check if notifications are being sent and whether they are reaching Pharos.

Check Firewall and Network Filtering Rules

• Verify whether Geo IP filtering or other firewall rules are blocking PayPal IPN notifications.
• Ensure that the following PayPal IPN endpoints are whitelisted to allow notifications to reach Pharos:
  onotify.paypal.com
  oipnpb.paypal.com
• Check that LogProcessor is receiving transaction events. If it is empty, this indicates that notifications are not reaching Pharos.

Resolution Steps

• If network filtering was blocking PayPal notifications, whitelist the required PayPal endpoints and retry.
• After updating the firewall settings, monitor LogProcessor to confirm that transaction records appear.
• Validate SQLite transaction logs to confirm updates after a test transaction.

Outcome

• Once network access to PayPal IPN notifications is restored, transactions should update correctly in Pharos.
• LogProcessor should begin recording transaction events, confirming successful PayPal communication.

Best Practices to Prevent Similar Issues

• Ensure PayPal IPN settings are correctly configured in both PayPal and Pharos.
• Check for firewall rules or Geo IP filtering that may block PayPal notifications.
• Monitor IIS logs for unusual redirects or blocked requests (302, 403 errors).
• Validate LogProcessor entries to confirm that transactions are being logged correctly.
• Review SQLite transaction logs to confirm updates after processing a test transaction