Obtaining username and password for Airbyte with abctl v0.11.1

Slack Knowledge Base Q&A Platform Questions
, , , ,
1

Summary

The user is having trouble obtaining the username and password for Airbyte using abctl v0.11.1, as the environment variables ABCTL_LOCAL_INSTALL_USERNAME and ABCTL_LOCAL_INSTALL_PASSWORD are being ignored. The command ‘abctl local credentials’ does not provide the username.


Question

How do I get username and password for airbyte? With the recent abctl v0.11.1. It seems it ignores ABCTL_LOCAL_INSTALL_USERNAME and ABCTL_LOCAL_INSTALL_PASSWORD
I tried abctl local credentials but it does not provide username.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["username", "password", "airbyte", "abctl", "v0.11.1", "credentials"]
2

And the UI insist that it has to have @ in the username

3

can you see password?
for default installation email is <mailto:example@example.com|example@example.com>

4

<mailto:example@example.com|example@example.com> with the password from abctl local credentials It did not work

5

mailto:example@example.com|example@example.com with the one in ABCTL_LOCAL_INSTALL_PASSWORD did not work either

6

you can try to set custom secrets https://docs.airbyte.com/deploying-airbyte/integrations/authentication#setting-a-password-via-secrets

7

if you want check user in database you can try

install kubectl (https://kubernetes.io/docs/tasks/tools/#kubectl) and kubectx + kubens (https://github.com/ahmetb/kubectx)
install also k9s (https://k9scli.io/)
then execute commands

KUBECONFIG=~/.airbyte/abctl/abctl.kubeconfig kubectl config view --flatten > ~/.kube/config
kubectx kind-airbyte-abctl
kubens airbyte-abctl```
then you can forward ports
`kubectl port-forward --address 0.0.0.0 airbyte-db-0 5432:5432`
and connect to database: `db-airbyte`
host `localhost:5432` with your preferred tool and in `user` table you can find your user
8

Ok, will try seetting the custom secrets.
Still, it does not solve the problem. Were you able to replicate the issue and find why it is happening?

9

What do you mean by db-airbyte?

10

Hi <@U05JENRCF7C>, I am currently facing the same issue, the user email is set up in user table in internal db though. Changed the password through a secret but still can’t log in to the UI :wink:

11

<@U07AY8L61HT> db-airbyte is the name of the logical database when you connect to host localhost:5432

12

I’ve got the username from user database and set new pasword with kubectl but still can’t login

13

<@U07AY8L61HT> <@U06HNC55M99> you might need to restart airbyte-abctl-server like this:


kubectl scale --replicas=1 deployment/airbyte-abctl-server```
14

still, it does not work.

15

username’s correct from db-airbyte.user table

16

credentials updated as I set up with kubectl apply -f secret.yaml

17

I can see the password from abctl local credentials as I set it up

18

Have you tried abctl local install --secret secret.yaml?
Maybe bootloader does something extra than kubectl apply -f secret.yaml

19

<@U07AY8L61HT> how does your secret.yaml look like?

20

What I did
• cat secret.yaml

kind: Secret
metadata:
  name: airbyte-auth-secrets
type: Opaque
stringData:
  instance-admin-password: abcdefg```
• `abctl local install --secret secret.yaml`
• `kubectl edit ingress -n airbyte-abctl --kubeconfig ~/.airbyte/abctl/abctl.kubeconfig` to allow more than localhost