Upgrading from v3 self host PHP Apache2 to Docker v5

[homeusepb]

Hi!

I installed 2FAuth I think it was v3.4 or something similar (cannot exactly remember). Today I finally wanted to transition from that fully self managed PHP to a Docker Compose managed container which should make my life easier. Earlier I used apache2 to run a HTTPS server and it works just fine.

Now for the docker, I made a new directory "2fauth" and within that directory, I copied across my "/var/www/2fauth/storage" and "/var/www/2fauth/database" to "./2fauth/storage" and "./2fauth/database" (the whole folder). I also copied the "/var/www/2fauth/database/database.sqlite" to "./2fauth/database.sqlite" since I saw running the docker container, 2fauth generated an empty database.sqlite file.

So it went well and I could see a login screen however (note at this point my docker server is HTTP only so I had to update my APP_URL to HTTP, whereas my old apache2 was direct HTTPS). So when I login, I get this error screen;

SQLSTATE[HY000]: General error: 1 no such column: twofaccounts.user_id (Connection: sqlite, SQL: select * from "twofaccounts" where "twofaccounts"."user_id" = 1 and "twofaccounts"."user_id" is not null)

It seems that v4 supports multi user, v3 didn't. Could that be confusing 2fauth? If so how would we transition?

I have tried a few things but none seem to work? How can I transition across? Also how would I enable HTTPS access for this Docker container nginx image? I cannot seem to find any docs. Would I need to use apache2 reverse proxy pass HTTPS?
Oh just to add, my working instance which I copied database and storage folders off was running on HTTPS whereas (for now at least), this new docker instance is HTTP. Not sure if that makes a difference (theoretically shouldn't?)

EDIT: I fixed the above issue I am 99% sure, see message below and issue (#319).

Thanks for the assistance!

[homeusepb]

I have just tried from scratch again and this time I am getting "No account found using this email.". Which is odd.
I copied /var/www/2fauth/storage completely and also /var/www/2fauth/database and also copied /var/www/2fauth/database/database.sqlite all these went into a folder called "2fauth_data" which is in a directory called "2fauth".

2fauth
-> docker-compose.yml
->2fauth_data (folder)
Then inside 2fauth_data folder
->storage (folder)
->database (folder)
->database.sqlite

Docker-compose volumes look like this;

version: "3"
services:
  2fauth:
    image: 2fauth/2fauth
    container_name: 2fauth
    volumes:
      - ./2fauth_data:/2fauth
    ports:
      - 8150:8000/tcp
    restart: unless-stopped
    environment:
      # You can change the name of the app
      - APP_NAME=2FAuth

and etc.

Am I missing anything?

**EDIT: So the error above (no such column twoofaccounts.user_id etc. That comes if I copy the database and some of these database migration files do not run. But if they do run (which I believe is a good thing? Since it seems to convert the DB to the newest format), then I get the error of "No account found using this email". So basically i cannot login. I am 100% sure login details are correct since it is in my password manager. Making new account works but I cannot access my data however. :(

This also seems related to: #278 - except that user restored a JSON backup but in v3 2fauth, it had no capability of exporting so I cannot**

I have made an issue (#319) since I believe this is a bug.

Thank you!

[homeusepb]

Solved via Bubka, see #319.
Thank you!