INFO:     Started server process [1358431]
INFO:     Waiting for application startup.
2026-05-05 23:39:32,512 - INFO - Starting FastAPI application...
2026-05-05 23:39:32,523 - INFO - MySQL connection pool initialized: localhost:3306
2026-05-05 23:39:32,524 - INFO - Database tables initialized successfully
2026-05-05 23:39:32,702 - INFO - Importing public key from: /home/rxco/public_html/connector-app/keys/PGPPublicKey.asc
2026-05-05 23:39:32,710 - INFO - Import result: 0 imported
2026-05-05 23:39:32,711 - INFO - Set encryption recipient: 7F474ABE432B79B6ADE35A7A1A00E976D4B8366A
2026-05-05 23:39:32,744 - INFO - Private key import: 0 imported
2026-05-05 23:39:32,745 - INFO - ConsultationProcessor initialized
2026-05-05 23:39:32,745 - INFO - PollingService initialized with 3 minute interval
2026-05-05 23:39:32,745 - INFO - SFTP polling loop started
2026-05-05 23:39:32,745 - INFO - SFTP polling service started - scanning every 3 minutes
2026-05-05 23:39:32,745 - INFO - Starting scheduled SFTP scan...
2026-05-05 23:39:32,745 - INFO - SFTP polling enabled (ingress_mode=both)
2026-05-05 23:39:32,746 - INFO - FastAPI application started successfully
INFO:     Application startup complete.
INFO:     Uvicorn running on http://127.0.0.1:8011 (Press CTRL+C to quit)
2026-05-05 23:39:32,923 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-05 23:39:33,268 - INFO - Authentication (publickey) successful!
2026-05-05 23:39:33,269 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-05 23:39:33,364 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-05 23:39:33,478 - INFO - [chan 0] sftp session closed.
2026-05-05 23:39:33,478 - INFO - Scanning SFTP directory for files...
2026-05-05 23:39:33,663 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-05 23:39:33,892 - INFO - Authentication (publickey) successful!
2026-05-05 23:39:33,892 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-05 23:39:33,980 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-05 23:39:34,097 - INFO - [chan 0] sftp session closed.
2026-05-05 23:39:34,097 - INFO - Found 1 zip files to process
2026-05-05 23:39:34,098 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-05-05 23:39:34,266 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-05 23:39:34,479 - INFO - Authentication (publickey) successful!
2026-05-05 23:39:34,479 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-05 23:39:34,560 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-05 23:39:34,672 - INFO - [chan 0] sftp session closed.
2026-05-05 23:39:34,672 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,756 - INFO - Uploaded to S3: connector-service-request-response/encrypted/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,756 - INFO - Saved encrypted file to S3: connector-service-request-response/encrypted/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,799 - WARNING - gpg returned a non-zero error code: 2
2026-05-05 23:39:34,799 - INFO - Decrypted file to /tmp/tmpaqcvc10n/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,836 - INFO - Uploaded to S3: connector-service-request-response/decrypted/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,836 - INFO - Saved decrypted file to S3: connector-service-request-response/decrypted/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,880 - INFO - Uploaded to S3: connector-service-request-response/requests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:39:34,881 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-05-05 23:39:34,881 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-05-05 23:39:34,915 - INFO - Uploaded JSON to S3: connector-service-request-response/requests/extracted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:39:34,916 - INFO - Saved extracted JSON to S3: connector-service-request-response/requests/extracted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:39:34,916 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-05-05 23:39:34,953 - INFO - Uploaded JSON to S3: connector-service-request-response/requests/1rx_request_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:39:34,953 - INFO - Saved 1Rx request to S3: connector-service-request-response/requests/1rx_request_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:39:34,955 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-05-05 23:39:34,962 - ERROR - [consultation_id=3bcecd65-9d61-4016-94ea-5413d08e3e2c] 1Rx API error 400: {"data":null,"error":{"code":400,"message":"Invalid patient phone number for order id 404-7623963-2495509. Supported format is xxxxxxxxxx. ","status":"Bad Request"}}
2026-05-05 23:39:34,963 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 0.87s (active=0)
2026-05-05 23:39:34,963 - INFO - SFTP scan completed - Duration: 2.22s, Found: 1, Processed: 1
INFO:     49.43.156.49:0 - "GET /health/detailed HTTP/1.1" 404 Not Found
INFO:     49.43.156.49:0 - "GET /connectorhealth/detailed HTTP/1.1" 404 Not Found
INFO:     49.43.156.49:0 - "GET /connectorhealth/ HTTP/1.1" 404 Not Found
INFO:     49.43.156.49:0 - "GET /connectorhealth/ HTTP/1.1" 404 Not Found
2026-05-05 23:42:34,966 - INFO - Starting scheduled SFTP scan...
2026-05-05 23:42:35,151 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-05 23:42:35,496 - INFO - Authentication (publickey) successful!
2026-05-05 23:42:35,496 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-05 23:42:35,623 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-05 23:42:35,735 - INFO - [chan 0] sftp session closed.
2026-05-05 23:42:35,736 - INFO - Scanning SFTP directory for files...
2026-05-05 23:42:35,904 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-05 23:42:36,229 - INFO - Authentication (publickey) successful!
2026-05-05 23:42:36,229 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-05 23:42:36,315 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-05 23:42:36,453 - INFO - [chan 0] sftp session closed.
2026-05-05 23:42:36,454 - INFO - Found 1 zip files to process
2026-05-05 23:42:36,454 - INFO - Processing file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip (active=1)
2026-05-05 23:42:36,637 - INFO - Connected (version 2.0, client AWS_SFTP_1.2)
2026-05-05 23:42:36,850 - INFO - Authentication (publickey) successful!
2026-05-05 23:42:36,851 - INFO - Connected to SFTP server as: 2HRV5XSXT0JOV
2026-05-05 23:42:36,942 - INFO - [chan 0] Opened sftp connection (server version 3)
2026-05-05 23:42:37,045 - INFO - [chan 0] sftp session closed.
2026-05-05 23:42:37,046 - INFO - Downloaded /consultationrequests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,127 - INFO - Uploaded to S3: connector-service-request-response/encrypted/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,127 - INFO - Saved encrypted file to S3: connector-service-request-response/encrypted/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,171 - WARNING - gpg returned a non-zero error code: 2
2026-05-05 23:42:37,171 - INFO - Decrypted file to /tmp/tmpl87iivzn/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,207 - INFO - Uploaded to S3: connector-service-request-response/decrypted/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,207 - INFO - Saved decrypted file to S3: connector-service-request-response/decrypted/decrypted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,241 - INFO - Uploaded to S3: connector-service-request-response/requests/myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip
2026-05-05 23:42:37,241 - INFO - Zip contents: ['404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880']
2026-05-05 23:42:37,242 - INFO - Loaded Amazon request with consultation_id: 3bcecd65-9d61-4016-94ea-5413d08e3e2c
2026-05-05 23:42:37,272 - INFO - Uploaded JSON to S3: connector-service-request-response/requests/extracted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:42:37,272 - INFO - Saved extracted JSON to S3: connector-service-request-response/requests/extracted_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:42:37,272 - WARNING - Phone number after normalization is not 10 digits: 37656278
2026-05-05 23:42:37,306 - INFO - Uploaded JSON to S3: connector-service-request-response/requests/1rx_request_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:42:37,306 - INFO - Saved 1Rx request to S3: connector-service-request-response/requests/1rx_request_myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.json
2026-05-05 23:42:37,307 - INFO - Request with consultation_id 3bcecd65-9d61-4016-94ea-5413d08e3e2c already exists
2026-05-05 23:42:37,317 - ERROR - [consultation_id=3bcecd65-9d61-4016-94ea-5413d08e3e2c] 1Rx API error 400: {"data":null,"error":{"code":400,"message":"Invalid patient phone number for order id 404-7623963-2495509. Supported format is xxxxxxxxxx. ","status":"Bad Request"}}
2026-05-05 23:42:37,319 - INFO - Finished file: myrxbucket-gamma-ap-south-1.404-7623963-2495509_621b9c54-2666-4023-bf71-093897942880.zip in 0.86s (active=0)
2026-05-05 23:42:37,319 - INFO - SFTP scan completed - Duration: 2.35s, Found: 1, Processed: 1