2026-09-18 01:02:23,960 - INFO - Starting FastAPI application...
2026-09-18 01:02:23,981 - INFO - MySQL connection pool initialized: localhost:3306
2026-09-18 01:02:23,994 - INFO - Database tables initialized successfully
2026-09-18 01:02:23,999 - INFO - Importing public key from: /home/rxco/public_html/connector-app/keys/PGPPublicKey.asc
2026-09-18 01:02:24,005 - INFO - Import result: 0 imported
2026-09-18 01:02:24,005 - INFO - Set encryption recipient: 7F474ABE432B79B6ADE35A7A1A00E976D4B8366A
2026-09-18 01:02:24,028 - INFO - Private key import: 0 imported
2026-09-18 01:02:24,028 - INFO - ConsultationProcessor initialized
2026-09-18 01:02:24,028 - INFO - PollingService initialized with 3 minute interval
2026-09-18 01:02:24,029 - INFO - SFTP polling loop started
2026-09-18 01:02:24,029 - INFO - SFTP polling service started - scanning every 3 minutes
2026-09-18 01:02:24,029 - INFO - Starting scheduled SFTP scan...
2026-09-18 01:02:24,030 - INFO - SFTP polling enabled (ingress_mode=both)
2026-09-18 01:02:24,030 - INFO - FastAPI application started successfully
2026-09-18 01:02:24,300 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:02:24,686 - INFO - Authentication (publickey) successful!
2026-09-18 01:02:24,686 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-18 01:02:24,837 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:02:24,997 - INFO - [chan 0] sftp session closed.
2026-09-18 01:02:24,998 - INFO - Scanning SFTP directory for files...
2026-09-18 01:02:25,238 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:02:25,670 - INFO - Authentication (publickey) successful!
2026-09-18 01:02:25,671 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-18 01:02:25,835 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:02:26,015 - INFO - [chan 0] sftp session closed.
2026-09-18 01:02:26,016 - INFO - Found 1 zip files to process
2026-09-18 01:02:26,016 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-09-18 01:02:26,257 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:02:26,556 - INFO - Authentication (publickey) successful!
2026-09-18 01:02:26,556 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-18 01:02:26,706 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:02:26,931 - INFO - [chan 0] sftp session closed.
2026-09-18 01:02:26,931 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-09-18 01:02:26,976 - WARNING - gpg returned a non-zero error code: 2
2026-09-18 01:02:26,976 - INFO - Decrypted file to /tmp/tmp4qz07imc/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-09-18 01:02:26,977 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-09-18 01:02:26,977 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-09-18 01:02:26,977 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-09-18 01:02:26,978 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-09-18 01:02:26,987 - ERROR - [consultation_id=3bcecd65-9d61-4016-94ea-5413d08e3e2c] 1Rx API error 400 (attempt 1/3): {"data":null,"error":{"code":400,"message":"Invalid patient phone number for order id 404-7623963-2495509. Supported format is xxxxxxxxxx. ","status":"Bad Request"}}
2026-09-18 01:02:26,988 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 0.97s (active=0)
2026-09-18 01:02:26,989 - INFO - SFTP scan completed - Duration: 2.96s, Found: 1, Processed: 1
2026-09-18 01:03:50,817 - INFO - Received 1Rx webhook: 404-9745147-1620315#3cb79b00-bc07-4512-9f30-3ea9066d411b
INFO:     127.0.0.1:40268 - "POST /webhook/1rx HTTP/1.1" 200 OK
2026-09-18 01:03:50,820 - INFO - Background processing webhook for consultation 3cb79b00-bc07-4512-9f30-3ea9066d411b
2026-09-18 01:03:50,820 - INFO - Processing 1Rx response for consultation_id: 3cb79b00-bc07-4512-9f30-3ea9066d411b
2026-09-18 01:03:50,823 - INFO - Processing 1Rx response for consultation 3cb79b00-bc07-4512-9f30-3ea9066d411b
2026-09-18 01:03:50,823 - INFO - Downloading prescription JPEG from: http://localhost:10000/api/1rx/v1/orders/404-9745147-1620315%233cb79b00-bc07-4512-9f30-3ea9066d411b/download-jpeg-prescription
2026-09-18 01:03:55,961 - INFO - JPEG downloaded successfully: 1277442 bytes
2026-09-18 01:03:55,963 - INFO - Consultation 3cb79b00-bc07-4512-9f30-3ea9066d411b: real order within API ramp (slot 1/1 today); delivering via Shuttle API
2026-09-18 01:03:55,980 - INFO - Found credentials in environment variables.
2026-09-18 01:03:57,604 - INFO - Uploaded to S3: consultation-responses/404-9745147-1620315#3cb79b00-bc07-4512-9f30-3ea9066d411b/3cb79b00-bc07-4512-9f30-3ea9066d411b.zip
2026-09-18 01:03:57,607 - INFO - Prescription ZIP staged for Amazon at S3 key: consultation-responses/404-9745147-1620315#3cb79b00-bc07-4512-9f30-3ea9066d411b/3cb79b00-bc07-4512-9f30-3ea9066d411b.zip
2026-09-18 01:03:58,940 - INFO - Fetched Amazon access token (expires_in=3600s, refresh_in=3000s)
2026-09-18 01:03:58,941 - INFO - {"event": "consume_api_request", "primaryReferenceId": "404-9745147-1620315#3cb79b00-bc07-4512-9f30-3ea9066d411b", "secondaryReferenceId": "3cb79b00-bc07-4512-9f30-3ea9066d411b", "trackingId": "b7879b80-d011-479d-9b03-7167b5f5fd2f", "providerName": "myrx", "customerCallAttemptNumber": 1, "attempt": 1, "timestampIst": 1789673638940}
2026-09-18 01:04:10,650 - INFO - {"event": "consume_api_response", "primaryReferenceId": "404-9745147-1620315#3cb79b00-bc07-4512-9f30-3ea9066d411b", "secondaryReferenceId": "3cb79b00-bc07-4512-9f30-3ea9066d411b", "trackingId": "b7879b80-d011-479d-9b03-7167b5f5fd2f", "providerName": "myrx", "customerCallAttemptNumber": 1, "attempt": 1, "httpStatus": 200, "status": "ACKNOWLEDGED", "acknowledgementTimeStamp": 1789673650483, "timestampIst": 1789673650650}
2026-09-18 01:04:10,655 - INFO - [consultation_id=3cb79b00-bc07-4512-9f30-3ea9066d411b] Amazon API acknowledged response (trackingId=b7879b80-d011-479d-9b03-7167b5f5fd2f)
2026-09-18 01:04:10,657 - INFO - Successfully processed 1Rx response for consultation 3cb79b00-bc07-4512-9f30-3ea9066d411b
2026-09-18 01:04:10,659 - INFO - Successfully processed 1Rx response for consultation 3cb79b00-bc07-4512-9f30-3ea9066d411b
2026-09-18 01:04:10,659 - INFO - Successfully processed webhook for consultation 3cb79b00-bc07-4512-9f30-3ea9066d411b
2026-09-18 01:04:47,058 - INFO - Received 1Rx webhook: 404-1378868-4902721#5dd9096f-5a93-4712-a66c-0643a07d5ef5
INFO:     127.0.0.1:40294 - "POST /webhook/1rx HTTP/1.1" 200 OK
2026-09-18 01:04:47,061 - INFO - Background processing webhook for consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5
2026-09-18 01:04:47,061 - INFO - Processing 1Rx response for consultation_id: 5dd9096f-5a93-4712-a66c-0643a07d5ef5
2026-09-18 01:04:47,063 - INFO - Processing 1Rx response for consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5
2026-09-18 01:04:47,064 - INFO - Downloading prescription JPEG from: http://localhost:10000/api/1rx/v1/orders/404-1378868-4902721%235dd9096f-5a93-4712-a66c-0643a07d5ef5/download-jpeg-prescription
2026-09-18 01:04:50,640 - INFO - JPEG downloaded successfully: 1279446 bytes
2026-09-18 01:04:50,642 - INFO - Consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5: real-order API ramp exhausted (1/1 used today); delivering via SFTP
2026-09-18 01:04:50,642 - INFO - Consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5 is not a test order; delivering via SFTP instead of the Shuttle API
2026-09-18 01:04:50,722 - INFO - File encrypted successfully: /tmp/tmpyjm3awwl/response_encrypted.zip
2026-09-18 01:04:51,025 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:04:51,644 - INFO - Authentication (publickey) successful!
2026-09-18 01:04:51,645 - INFO - Connected to SFTP server as: 1A10E9TC5CYBE
2026-09-18 01:04:51,803 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:04:51,803 - INFO - Uploading file: /tmp/tmpyjm3awwl/response_encrypted.zip (876731 bytes) -> /consultationresponses/404-1378868-4902721#5dd9096f-5a93-4712-a66c-0643a07d5ef5_33d178ce-81b3-45f7-ab14-8a8899c2626e.zip
2026-09-18 01:04:52,993 - INFO - [chan 0] sftp session closed.
2026-09-18 01:04:52,993 - INFO - Successfully uploaded response to /consultationresponses/404-1378868-4902721#5dd9096f-5a93-4712-a66c-0643a07d5ef5_33d178ce-81b3-45f7-ab14-8a8899c2626e.zip
2026-09-18 01:04:52,995 - INFO - Successfully processed 1Rx response for consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5
2026-09-18 01:04:52,998 - INFO - Successfully processed 1Rx response for consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5
2026-09-18 01:04:52,998 - INFO - Successfully processed webhook for consultation 5dd9096f-5a93-4712-a66c-0643a07d5ef5
2026-09-18 01:05:26,991 - INFO - Starting scheduled SFTP scan...
2026-09-18 01:05:27,274 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:05:27,705 - INFO - Authentication (publickey) successful!
2026-09-18 01:05:27,706 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-18 01:05:27,882 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:05:28,053 - INFO - [chan 0] sftp session closed.
2026-09-18 01:05:28,054 - INFO - Scanning SFTP directory for files...
2026-09-18 01:05:28,321 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:05:28,607 - INFO - Authentication (publickey) successful!
2026-09-18 01:05:28,608 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-18 01:05:28,756 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:05:28,920 - INFO - [chan 0] sftp session closed.
2026-09-18 01:05:28,920 - INFO - Found 1 zip files to process
2026-09-18 01:05:28,921 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-09-18 01:05:29,171 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-09-18 01:05:29,513 - INFO - Authentication (publickey) successful!
2026-09-18 01:05:29,513 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-09-18 01:05:29,683 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-09-18 01:05:29,933 - INFO - [chan 0] sftp session closed.
2026-09-18 01:05:29,933 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-09-18 01:05:29,978 - WARNING - gpg returned a non-zero error code: 2
2026-09-18 01:05:29,978 - INFO - Decrypted file to /tmp/tmp6fv4a4zb/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-09-18 01:05:29,978 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-09-18 01:05:29,979 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-09-18 01:05:29,979 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-09-18 01:05:29,981 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-09-18 01:05:29,989 - ERROR - [consultation_id=3bcecd65-9d61-4016-94ea-5413d08e3e2c] 1Rx API error 400 (attempt 1/3): {"data":null,"error":{"code":400,"message":"Invalid patient phone number for order id 404-7623963-2495509. Supported format is xxxxxxxxxx. ","status":"Bad Request"}}
2026-09-18 01:05:29,991 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 1.07s (active=0)
2026-09-18 01:05:29,992 - INFO - SFTP scan completed - Duration: 3.00s, Found: 1, Processed: 1
2026-09-18 01:06:28,476 - INFO - Shutting down FastAPI application...
2026-09-18 01:06:28,477 - INFO - Stopping SFTP polling service...
2026-09-18 01:06:29,992 - INFO - SFTP polling loop stopped
2026-09-18 01:06:29,993 - INFO - SFTP polling service stopped
2026-09-18 01:06:29,993 - INFO - FastAPI application shutdown complete