upgrade failed 23.8.3 to 23.10.0 | authentik | Page 1

tawdry halo Oct 26, 2023, 5:22 PM

#

Hello

I tried to update my authentik server, but unfortunately without success

The error is as follows:
Unapplying authentik_stages_authenticator_totp.0010_alter_totpdevice_key... FAKED
Unapplying authentik_stages_authenticator_totp.0009_auto_20190420_0723... FAKED
2023-10-26 17:17:41 [debug ] Running system_crit command command=./manage.py migrate authentik_stages_authenticator_totp 0009_auto_20190420_0723 --fake
DBG event=Loaded config logger=authentik.lib.config timestamp=1698340662.9654481 file=/authentik/lib/default.yml
DBG event=Loaded environment variables logger=authentik.lib.config timestamp=1698340662.96620

green ember Oct 26, 2023, 5:31 PM

#

can you post the full logs from the server container

tacit leaf Oct 26, 2023, 5:36 PM

#

hijacking this thread as I have the same error https://bin.lama-corp.space/upload/otter-sloth-snail

tawdry halo Oct 26, 2023, 5:37 PM

#

@tacit leaf Thanks, I have the same error, so I don't put the log file here

sick salmon Oct 26, 2023, 5:37 PM

#

another here, my logs look really close to the ones above. Rollback to 2023.8.3 worked
also FWIW logging in with 2023.8.3 then upgrading to 2023.10.0 allows the login session to stay. So error only affects new logins

tacit leaf Oct 26, 2023, 5:37 PM

#

no worries :D

tawdry halo Oct 26, 2023, 5:41 PM

#

🙂

real barn Oct 26, 2023, 6:01 PM

#

Yes, I also have the same error...

green ember Oct 26, 2023, 6:01 PM

#

https://github.com/goauthentik/authentik/pull/7315 🙃

GitHub

lifecycle: fix otp merge migration by BeryJu · Pull Request #7315 ·...

Details

REPLACE ME

Checklist

Local tests pass (ak test authentik/)
The code has been formatted (make lint-fix)

If an API change has been made

The API schema has been updated (make gen-build...

tawdry halo Oct 26, 2023, 6:29 PM

#

ohhh that was fast, I see it has been fixed 🙂 will it be included in a new release?

#

ok i seeee 10.1 thx

wheat sierra Oct 26, 2023, 8:50 PM

#

I still seem to be hitting this problem upgrading from 2023.6.0 to 2023.10.1

#

django.db.utils.ProgrammingError: column "throttling_failure_count" of relation "authentik_stages_authenticator_static_staticdevice" already exists

#

I've tried rolling back to prior versions without success, perhaps I'm doing it wrong. I diff'ed the docker-compose.yml files and can see it's only a couple of lines changing between versions, so I'm not sure what I'm missing or why I can't roll back easily.

green ember Oct 26, 2023, 8:53 PM

#

run this in one of the containers and then restart them ak migrate authentik_stages_authenticator_static 0009_throttling --fake ak migrate authentik_stages_authenticator_totp 0009_auto_20190420_0723 --fake

wheat sierra Oct 26, 2023, 9:10 PM

#

Thanks. Which container?

#

worker, server, or doesn't matter?

green ember Oct 26, 2023, 9:13 PM

#

doesn't matter

wheat sierra Oct 26, 2023, 9:14 PM

#

They're both perpetually in the state of "Restarting"

#

hard target to hit

#

I keep getting Error response from daemon: Container 00ec75906d55b05e6a65cdbaf97188233683bef1b4b16daa88484e8d3416a791 is restarting, wait until the container is running

green ember Oct 26, 2023, 9:16 PM

#

add command: debug to one of the containers in the compose

wheat sierra Oct 26, 2023, 9:16 PM

#

ok

#

Where's ak located? I found one in /lifecycle/ak

green ember Oct 26, 2023, 9:18 PM

#

it's in the path, you can just run ak

wheat sierra Oct 26, 2023, 9:18 PM

#

it wasn't in the path

#

k$ docker compose exec server "ak migrate authentik_stages_authenticator_static 0009_throttling --fake" OCI runtime exec failed: exec failed: unable to start container process: exec: "ak migrate authentik_stages_authenticator_static 0009_throttling --fake": executable file not found in $PATH: unknown

green ember Oct 26, 2023, 9:19 PM

#

remove the quotation marks

wheat sierra Oct 26, 2023, 9:20 PM

#

making progress

#

BOOM!

#

Thank you @green ember !!!

green ember Oct 26, 2023, 9:22 PM

#

hotdab

wheat sierra Oct 26, 2023, 9:26 PM

#

Eh, well, new problems. I've got Authentik as my identity provider for my Proxmox server. When I attempt to log in, I get this odd web page:

#

And on my Synology NAS, it just never loads.

#

(these are the only two things I've used Authentik for thus far)

green ember Oct 26, 2023, 9:26 PM

#

check the logs

wheat sierra Oct 26, 2023, 9:27 PM

#

maybe a cookie clearing will help

#

nope

#

error in log:

#

{"event": "Internal Server Error: /api/v3/flows/executor/default-authentication-flow/", "exception" : [{"exc_type": "ProgrammingError", "exc_value": "column authentik_stages_authenticator_static_authenticatorstaticstage.token _length does not exist\nLINE 1: ...r_static_authenticatorstaticstage\".\"token_count\", \"authentik...\n

green ember Oct 26, 2023, 9:30 PM

#

did you restart the containers after running the command above

wheat sierra Oct 26, 2023, 9:30 PM

#

yes. I'll do it again just to be sure.

#

yeah, same deal.

#

having trouble uploading a log...

#

📎 message.txt

dreamy canyon Oct 27, 2023, 4:24 AM

#

I am also experiencing the same problem as OMG Pickles. I've followed the same steps laid out for them and am now also seeing the page with HTML.

#

Asked Docker to give me the log from the server container and this is what it sent over

📎 log.json

green ember Oct 27, 2023, 10:57 AM

#

I've added a disclaimer to only upgrade from 2023.8 to 2023.10 for the time being https://goauthentik.io/docs/releases/2023.10, the linked issue https://github.com/goauthentik/authentik/issues/7326 has a workaround for now

GitHub

Authentik Login showing HTML · Issue #7326 · goauthentik/authentik

Describe your question/ Just updated to 2023.10.1 and since I'm already logged into authentik on a browser, everything is working, but since I tried another browser, I seem to be not getting th...

wheat sierra Oct 27, 2023, 2:54 PM

#

@green ember Can you link to the comment that has the correct workaround please? There are at least two comments suggesting making manual database changes.

#

Nevermind, it appears the "fix" is this psql command: alter table authentik_stages_authenticator_static_authenticatorstaticstage add column token_length INTEGER default 12;

wheat sierra Oct 27, 2023, 7:40 PM

#

After the two ak commands shared here #1167151382776791250 message plus the psql command referenced in my previous message, my environment is working again.

steel drift Oct 28, 2023, 12:25 AM

#

Originally I had the same issue but then ran the migrations and now I have a new error, "django.db.utils.ProgrammingError: column "throttling_failure_count" of relation "authentik_stages_authenticator_totp_totpdevice" already exists" any ideas?

coarse lake Oct 28, 2023, 8:19 PM

#

green ember run this in one of the containers and then restart them ```ak migrate authentik_...

hmm... i have something similar but running this doesn't seem to help? for me I get:

CommandError: Cannot find a migration matching '0009_auto_20190420_0723' from app 'authentik_stages_authenticator_totp'.

green ember Oct 28, 2023, 8:20 PM

#

check https://github.com/goauthentik/authentik/issues/7326 for the workarounds

GitHub

Database error when upgrading to 2023.10 from a version older than ...

Describe your question/ Just updated to 2023.10.1 and since I'm already logged into authentik on a browser, everything is working, but since I tried another browser, I seem to be not getting th...

#upgrade failed 23.8.3 to 23.10.0