Hello, I had connections that worked fine via inpu...
# help-api-cli-orchestration
d
Hello, I had connections that worked fine via input in the UI. I installed octavia 0.41.0 (same as my airbyte version), ran the
init
and
import all
functions, set the relevant secrets in my
~/.octavia
file, I entered the secrets in the relevant
configuration.yaml
files, and I know this is working since for many non-secrets it is applying (and updating) these in the UI (i.e., if I set some non-secret env file to ABC123, and update it to ABC1234 in
.octavia
, it changes in the UI after running
apply --force
). However, when I test the connections, it is failing, so it must be on the private key. One example in the .octavia file is for the AppStore .p8 file
Copy code
APPLE_P8="-----BEGIN PRIVATE KEY-----\nSOME\nSTUFF\nHERE\n-----END PRIVATE KEY-----"
I’m out of ideas, solutions that have worked for various people (posted here on Slack) are not working for me. Relevant logs for failing connection test:
Copy code
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/api.py", line 116, in post
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/api.py", line 60, in request
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/sessions.py", line 533, in request
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/sessions.py", line 646, in send
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/adapters.py", line 449, in send
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 600, in urlopen
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 343, in _make_request
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 839, in _validate_conn
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connection.py", line 319, in connect
2023-03-07 19:22:22 ERROR i.a.c.i.LineGobbler(voidCall):114 - ImportError: sys.meta_path is None, Python is likely shutting down
2023-03-07 19:22:23 WARN i.a.w.g.DefaultCheckConnectionWorker(run):107 - Check connection job subprocess finished with exit code 1
2023-03-07 19:22:23 ERROR i.a.w.g.DefaultCheckConnectionWorker(run):124 - Unexpected error while checking connection: 
io.airbyte.workers.exception.WorkerException: Error checking connection status: no status nor failure reason were outputted
	at io.airbyte.workers.WorkerUtils.throwWorkerException(WorkerUtils.java:198) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
	at io.airbyte.workers.general.DefaultCheckConnectionWorker.run(DefaultCheckConnectionWorker.java:117) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
	at io.airbyte.workers.general.DefaultCheckConnectionWorker.run(DefaultCheckConnectionWorker.java:41) ~[io.airbyte-airbyte-commons-worker-0.41.0.jar:?]
	at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$5(TemporalAttemptExecution.java:195) ~[io.airbyte-airbyte-workers-0.41.0.jar:?]
	at java.lang.Thread.run(Thread.java:1589) ~[?:?]
l
Hey Dayten, just checking - do you have the double quotes around the private key in your .env file? Try removing those if so and try the connection again
d
Hi @Liam Coley, I tried removing the double quotes in the .octavia file, running
apply --force
, hard-refreshing the UI, and once again testing the connection, but it still errors out with the same log. I’d venture a guess that it is because of the spaces in
-----BEGIN PRIVATE KEY-----
?
Copy code
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 - Exception ignored in: <function Api.__del__ at 0x7f7f1755d710>
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 - Traceback (most recent call last):
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/appstoreconnect/api.py", line 70, in __del__
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/appstoreconnect/api.py", line 331, in _submit_stats
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/api.py", line 116, in post
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/api.py", line 60, in request
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/sessions.py", line 533, in request
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/sessions.py", line 646, in send
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/requests/adapters.py", line 449, in send
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 600, in urlopen
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 343, in _make_request
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 839, in _validate_conn
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 -   File "/usr/local/lib/python3.7/site-packages/urllib3/connection.py", line 319, in connect
2023-03-07 20:26:08 ERROR i.a.c.i.LineGobbler(voidCall):114 - ImportError: sys.meta_path is None, Python is likely shutting down
2023-03-07 20:26:08 WARN i.a.w.g.DefaultCheckConnectionWorker(run):107 - Check connection job subprocess finished with exit code 1
2023-03-07 20:26:08 ERROR i.a.w.g.DefaultCheckConnectionWorker(run):124 - Unexpected error while checking connection:
this is working for my postgres and bigquery connections (with the google credentials file collapsed to a single line like so:
CREDENTIALS_JSON={"type": "service_account","project_id": "my-app","private_key_id": "****placeholder****","private_key": "-----BEGIN PRIVATE KEY-----....
) so it looks like its just not accepting the Appstore private key at this time.