[Bug]: Stuck on "Initializing the connection to the local database..." Fresh Docker install #1155

Closed
opened 2026-02-28 19:33:57 -06:00 by GiteaMirror · 33 comments
Owner

Originally created by @davemcmath on GitHub (Jun 17, 2024).

Verified issue does not already exist?

  • I have searched and found no existing issue
  • I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

A bug happened!

Fresh docker install with

docker run --pull=always --restart=unless-stopped -d -p 5006:5006 -v /dockerdata/actual_data/:/data --name my_actual_budget docker.io/actualbudget/actual-server:latest

with a data folder provisioned and UI fails to load and is stuck on "Initializing the connection to the local database..."

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome, Safari

Operating System

Other

Originally created by @davemcmath on GitHub (Jun 17, 2024). ### Verified issue does not already exist? - [X] I have searched and found no existing issue - [X] I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file) ### What happened? A bug happened! Fresh docker install with docker run --pull=always --restart=unless-stopped -d -p 5006:5006 -v /dockerdata/actual_data/:/data --name my_actual_budget docker.io/actualbudget/actual-server:latest with a data folder provisioned and UI fails to load and is stuck on "Initializing the connection to the local database..." ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Chrome, Safari ### Operating System Other
GiteaMirror added the bug label 2026-02-28 19:33:57 -06:00
Author
Owner

@youngcw commented on GitHub (Jun 17, 2024):

Can you test out edge.actualbudget.org? There was a change recently that may help your issue.

@youngcw commented on GitHub (Jun 17, 2024): Can you test out edge.actualbudget.org? There was a change recently that may help your issue.
Author
Owner

@davemcmath commented on GitHub (Jun 18, 2024):

I wasn't sure if you meant go to that URL, or try with the edge release version, so I did both. When I go to that URL it works fine with my browsers, Chrome and Safari.

Then tried Docker on latest edge release.

So I deleted all my data files and tried with

docker run --pull=always --restart=unless-stopped -d -p 5006:5006 -v /dockerdata/actual_data/:/data --name my_actual_budget docker.io/actualbudget/actual-server:edge

It still sits there with this.....

image

Ran without the -d

user@hostname:/dockerdata$ docker run --pull=always --restart=unless-stopped -p 5006:5006 -v /dockerdata/actual_data/:/data --name my_actual_budget docker.io/actualbudget/actual-server:edge
edge: Pulling from actualbudget/actual-server

Digest: sha256:5d49b87080d446be6e1f9e8fc8feffed3eb20db22f41cf1f7bfb98d6b479a598
Status: Image is up to date for actualbudget/actual-server:edge
Checking if there are any migrations to run for direction "up"...
Migrations: DONE
Listening on :::5006...

That's all I get from the logs. Is there anyway to get more verbose logs from the docker image?

@davemcmath commented on GitHub (Jun 18, 2024): I wasn't sure if you meant go to that URL, or try with the edge release version, so I did both. When I go to that URL it works fine with my browsers, Chrome and Safari. Then tried Docker on latest edge release. So I deleted all my data files and tried with docker run --pull=always --restart=unless-stopped -d -p 5006:5006 -v /dockerdata/actual_data/:/data --name my_actual_budget docker.io/actualbudget/actual-server:**edge** It still sits there with this..... <img width="604" alt="image" src="https://github.com/actualbudget/actual/assets/50442147/f36618fc-002c-4618-b140-9506a2be24fd"> Ran without the -d user@hostname:/dockerdata$ docker run --pull=always --restart=unless-stopped -p 5006:5006 -v /dockerdata/actual_data/:/data --name my_actual_budget docker.io/actualbudget/actual-server:edge edge: Pulling from actualbudget/actual-server Digest: sha256:5d49b87080d446be6e1f9e8fc8feffed3eb20db22f41cf1f7bfb98d6b479a598 Status: Image is up to date for actualbudget/actual-server:edge Checking if there are any migrations to run for direction "up"... Migrations: DONE Listening on :::5006... That's all I get from the logs. Is there anyway to get more verbose logs from the docker image?
Author
Owner

@ddz99 commented on GitHub (Jun 19, 2024):

I have the same bug. It's specifically a bug with Safari. running on MacOS Sonoma 14.0.

Works fine on Opera on my machine.

@ddz99 commented on GitHub (Jun 19, 2024): I have the same bug. It's specifically a bug with Safari. running on MacOS Sonoma 14.0. Works fine on Opera on my machine.
Author
Owner

@davemcmath commented on GitHub (Jun 20, 2024):

I tried with Chrome on MacOS and couldn't get it working there either.

To clarify I wasn't using HTTPS as it was on my internal network.

Now I have just reconfigured to use HTTPS and it now works fine with Chrome and Safari and jumps immediately to the set a password page.

If HTTP is meant to work out of the box I still think there is a bug somewhere here.

@davemcmath commented on GitHub (Jun 20, 2024): I tried with Chrome on MacOS and couldn't get it working there either. To clarify I **wasn't** using HTTPS as it was on my internal network. Now **I have just reconfigured to use HTTPS** and it now works fine with Chrome and Safari and jumps immediately to the set a password page. If HTTP is meant to work out of the box I still think there is a bug somewhere here.
Author
Owner

@newtonfav commented on GitHub (Jun 27, 2024):

I'm having same issue, stuck at "Initializing the connection to the local database..." I'm running the repo on my PC locally. should i open a new issue for this @youngcw

@newtonfav commented on GitHub (Jun 27, 2024): I'm having same issue, stuck at "Initializing the connection to the local database..." I'm running the repo on my PC locally. should i open a new issue for this @youngcw
Author
Owner

@youngcw commented on GitHub (Jun 27, 2024):

@newtonfav Only if your issue is different than this.

@youngcw commented on GitHub (Jun 27, 2024): @newtonfav Only if your issue is different than this.
Author
Owner

@newtonfav commented on GitHub (Jun 27, 2024):

@newtonfav Only if your issue is different than this.

same, just that I'm not running on docker

@newtonfav commented on GitHub (Jun 27, 2024): > @newtonfav Only if your issue is different than this. same, just that I'm not running on docker
Author
Owner

@youngcw commented on GitHub (Jun 27, 2024):

@davemcmath If you are on anything apple make sure you are using https, and probably a non self-signed cert. Apple browsers are really picky about certs, and Actual doesn't work properly without https.

@youngcw commented on GitHub (Jun 27, 2024): @davemcmath If you are on anything apple make sure you are using https, and probably a non self-signed cert. Apple browsers are really picky about certs, and Actual doesn't work properly without https.
Author
Owner

@newtonfav commented on GitHub (Jun 28, 2024):

Is there a guide on how i can run using https instead of http on local server?

@newtonfav commented on GitHub (Jun 28, 2024): Is there a guide on how i can run using https instead of http on local server?
Author
Owner

@nyakojiru commented on GitHub (Oct 7, 2024):

I'm on the same train. Can't use it on iOS with http. There should be optional parameters to be able to use Actual with http in development mode. I don't want to expose the service to the internet .

@nyakojiru commented on GitHub (Oct 7, 2024): I'm on the same train. Can't use it on iOS with http. There should be optional parameters to be able to use Actual with http in development mode. I don't want to expose the service to the internet .
Author
Owner

@hrv231 commented on GitHub (Oct 15, 2024):

I'm having the same problem, running on docker, behind traefik proxy, with HTTPS.
I'm using it with a purchased domain and let's encrypt certificate.

I generally use Firefox, so when I open the link that takes me to Actual, at first shows the Initializing the connection to the local database... , then I refresh the page and quickly it takes me to the enter your password.

I believe there is a bug for sure.

Edit: added more details

@hrv231 commented on GitHub (Oct 15, 2024): I'm having the same problem, running on docker, behind traefik proxy, with HTTPS. I'm using it with a purchased domain and let's encrypt certificate. I generally use Firefox, so when I open the link that takes me to Actual, at first shows the _Initializing the connection to the local database..._ , then I refresh the page and quickly it takes me to the enter your password. I believe there is a bug for sure. Edit: added more details
Author
Owner

@tibuski commented on GitHub (Feb 12, 2025):

I wanted to give actual budget a try but I am facing the same issue on a fresh docker start ...

@tibuski commented on GitHub (Feb 12, 2025): I wanted to give actual budget a try but I am facing the same issue on a fresh docker start ...
Author
Owner

@Ralle001 commented on GitHub (Feb 12, 2025):

As I can see there is no changes.

Logs:
Checking if there are any migrations to run for direction "up"...
Migrations: DONE
Listening on :::5006...

Tried: Opera, Chrome, Edge

config.json:
{}

Still stuck on: "Initializing the connection to the local database…"

@Ralle001 commented on GitHub (Feb 12, 2025): As I can see there is no changes. Logs: `Checking if there are any migrations to run for direction "up"...` `Migrations: DONE` `Listening on :::5006...` Tried: Opera, Chrome, Edge config.json: `{}` Still stuck on: "Initializing the connection to the local database…"
Author
Owner

@tibuski commented on GitHub (Feb 12, 2025):

FYI, I made it work by using https. It seems it's required.

@tibuski commented on GitHub (Feb 12, 2025): FYI, I made it work by using https. It seems it's required.
Author
Owner

@bo0tzz commented on GitHub (Feb 12, 2025):

I suspect this issue is caused by the uBlock extension: https://github.com/uBlockOrigin/uBlock-issues/issues/3527

@bo0tzz commented on GitHub (Feb 12, 2025): I suspect this issue is caused by the uBlock extension: https://github.com/uBlockOrigin/uBlock-issues/issues/3527
Author
Owner

@tibuski commented on GitHub (Feb 12, 2025):

Just did a test disabling ublock and in private mode but got the same issue.

@tibuski commented on GitHub (Feb 12, 2025): Just did a test disabling ublock and in private mode but got the same issue.
Author
Owner

@bo0tzz commented on GitHub (Feb 12, 2025):

In my case it happens if uBlock is installed at all, the disable button in the extension seems to make no difference.

@bo0tzz commented on GitHub (Feb 12, 2025): In my case it happens if uBlock is installed at all, the disable button in the extension seems to make no difference.
Author
Owner

@MikesGlitch commented on GitHub (Feb 13, 2025):

This should fix it: https://github.com/actualbudget/actual/pull/4375

@MikesGlitch commented on GitHub (Feb 13, 2025): This should fix it: https://github.com/actualbudget/actual/pull/4375
Author
Owner

@fdfytr commented on GitHub (Feb 15, 2025):

This should fix it: #4375

It does not
Same error on Firefox linux
Tried to clean cache, redownloading latest image without resolving

@fdfytr commented on GitHub (Feb 15, 2025): > This should fix it: [#4375](https://github.com/actualbudget/actual/pull/4375) It does not Same error on Firefox linux Tried to clean cache, redownloading latest image without resolving
Author
Owner

@youngcw commented on GitHub (Feb 15, 2025):

This should fix it: #4375

It does not Same error on Firefox linux Tried to clean cache, redownloading latest image without resolving

@fdfytr you have to test out the PR or edge build. Latest won't have the fix until the next release.

@youngcw commented on GitHub (Feb 15, 2025): > > This should fix it: [#4375](https://github.com/actualbudget/actual/pull/4375) > > It does not Same error on Firefox linux Tried to clean cache, redownloading latest image without resolving @fdfytr you have to test out the PR or edge build. Latest won't have the fix until the next release.
Author
Owner

@bibberp commented on GitHub (Feb 26, 2025):

I'm still having the same problem even with the edge build

services:
  actual_server:
    image: docker.io/actualbudget/actual-server:edge
    ports:

      - '5006:5006'
    volumes:
      - /opt/actual/actual-data:/data
    healthcheck:
      # Enable health check for the instance
      test: ['CMD-SHELL', 'node src/scripts/health-check.js']
      interval: 60s
      timeout: 10s
      retries: 3
      start_period: 20s
    restart: unless-stopped
@bibberp commented on GitHub (Feb 26, 2025): I'm still having the same problem even with the edge build ``` services: actual_server: image: docker.io/actualbudget/actual-server:edge ports: - '5006:5006' volumes: - /opt/actual/actual-data:/data healthcheck: # Enable health check for the instance test: ['CMD-SHELL', 'node src/scripts/health-check.js'] interval: 60s timeout: 10s retries: 3 start_period: 20s restart: unless-stopped ```
Author
Owner

@MikesGlitch commented on GitHub (Feb 26, 2025):

I'm still having the same problem even with the edge build

services:
  actual_server:
    image: docker.io/actualbudget/actual-server:edge
    ports:

      - '5006:5006'
    volumes:
      - /opt/actual/actual-data:/data
    healthcheck:
      # Enable health check for the instance
      test: ['CMD-SHELL', 'node src/scripts/health-check.js']
      interval: 60s
      timeout: 10s
      retries: 3
      start_period: 20s
    restart: unless-stopped

Can you open devtools with F12/CTRL Shift I, and copy/paste the contents in here.

There's a chance you're cached on the old code - can you also try in incognito?

@MikesGlitch commented on GitHub (Feb 26, 2025): > I'm still having the same problem even with the edge build > > ``` > services: > actual_server: > image: docker.io/actualbudget/actual-server:edge > ports: > > - '5006:5006' > volumes: > - /opt/actual/actual-data:/data > healthcheck: > # Enable health check for the instance > test: ['CMD-SHELL', 'node src/scripts/health-check.js'] > interval: 60s > timeout: 10s > retries: 3 > start_period: 20s > restart: unless-stopped > ``` Can you open devtools with F12/CTRL Shift I, and copy/paste the contents in here. There's a chance you're cached on the old code - can you also try in incognito?
Author
Owner

@bibberp commented on GitHub (Feb 27, 2025):

192.168.1.220/:1 The Cross-Origin-Opener-Policy header has been ignored, because the URL's origin was untrustworthy. It was defined either in the final response or a redirect. Please deliver the response using the HTTPS protocol. You can also use the 'localhost' origin instead. See https://www.w3.org/TR/powerful-features/#potentially-trustworthy-origin and https://html.spec.whatwg.org/#the-cross-origin-opener-policy-header.Understand this errorAI i18n.ts:60 Unknown locale en-US, falling back to en

same for incognito -- seems like it really wants https? I thought that it supported local http connections?

tried on MacBook with safari and win10 with chrome

@bibberp commented on GitHub (Feb 27, 2025): `192.168.1.220/:1 The Cross-Origin-Opener-Policy header has been ignored, because the URL's origin was untrustworthy. It was defined either in the final response or a redirect. Please deliver the response using the HTTPS protocol. You can also use the 'localhost' origin instead. See https://www.w3.org/TR/powerful-features/#potentially-trustworthy-origin and https://html.spec.whatwg.org/#the-cross-origin-opener-policy-header.Understand this errorAI i18n.ts:60 Unknown locale en-US, falling back to en` same for incognito -- seems like it really wants https? I thought that it supported local http connections? tried on MacBook with safari and win10 with chrome
Author
Owner

@MikesGlitch commented on GitHub (Feb 27, 2025):

same for incognito -- seems like it really wants https? I thought that it supported local http connections?

It does if it comes from localhost. localhost is treated as a secure context. There's some info here: https://developer.mozilla.org/en-US/docs/Web/Security/Secure_Contexts#when_is_a_context_considered_secure

You should have seen these two messages in your console:

Backend: Attempting to connect to client
Backend: Client connected

If you didn't it suggests you're not on the latest edge version - you may want to do another docker pull.

@MikesGlitch commented on GitHub (Feb 27, 2025): > same for incognito -- seems like it really wants https? I thought that it supported local http connections? It does if it comes from localhost. localhost is treated as a secure context. There's some info here: https://developer.mozilla.org/en-US/docs/Web/Security/Secure_Contexts#when_is_a_context_considered_secure You should have seen these two messages in your console: ``` Backend: Attempting to connect to client Backend: Client connected ``` If you didn't it suggests you're not on the latest edge version - you may want to do another docker pull.
Author
Owner

@bibberp commented on GitHub (Feb 27, 2025):

Thanks for your help!

So I want to make sure I understand right.. if I have it running on a separate computer in my home than what I'm accessing it on, I can't access it via http? (From my phone for example)

Just repulled the edge version, so unless something wild is happening I believe I have the most most current it could be

@bibberp commented on GitHub (Feb 27, 2025): Thanks for your help! So I want to make sure I understand right.. if I have it running on a separate computer in my home than what I'm accessing it on, I can't access it via http? (From my phone for example) Just repulled the edge version, so unless something wild is happening I believe I have the most most current it could be
Author
Owner

@MikesGlitch commented on GitHub (Feb 28, 2025):

Yeah, it's primarily for this reason: https://actualbudget.org/docs/troubleshooting/shared-array-buffer/

Browsers are smart enough to know localhost or 127.0.0.1 is a secure context but anything else needs a certificate.

@MikesGlitch commented on GitHub (Feb 28, 2025): Yeah, it's primarily for this reason: https://actualbudget.org/docs/troubleshooting/shared-array-buffer/ Browsers are smart enough to know localhost or 127.0.0.1 is a secure context but anything else needs a certificate.
Author
Owner

@fdfytr commented on GitHub (Mar 8, 2025):

This should fix it: #4375

It does not Same error on Firefox linux Tried to clean cache, redownloading latest image without resolving

@fdfytr you have to test out the PR or edge build. Latest won't have the fix until the next release.

updated release via docker - same problem
linux firefox spinning
android tablet and mac has no issues

@fdfytr commented on GitHub (Mar 8, 2025): > > > This should fix it: [#4375](https://github.com/actualbudget/actual/pull/4375) > > > > > > It does not Same error on Firefox linux Tried to clean cache, redownloading latest image without resolving > > [@fdfytr](https://github.com/fdfytr) you have to test out the PR or edge build. Latest won't have the fix until the next release. updated release via docker - same problem linux firefox spinning android tablet and mac has no issues
Author
Owner

@MikesGlitch commented on GitHub (Mar 8, 2025):

updated release via docker - same problem linux firefox spinning android tablet and mac has no issues

Are you using the latest edge docker image? If so are you using https? And is it localhost or is it something else like 192.x.x.x?

@MikesGlitch commented on GitHub (Mar 8, 2025): > updated release via docker - same problem linux firefox spinning android tablet and mac has no issues Are you using the latest edge docker image? If so are you using https? And is it localhost or is it something else like 192.x.x.x?
Author
Owner

@bo0tzz commented on GitHub (Mar 8, 2025):

On my end (running v25.3.1) this is fixed by now

@bo0tzz commented on GitHub (Mar 8, 2025): On my end (running v25.3.1) this is fixed by now
Author
Owner

@madamson747 commented on GitHub (Mar 10, 2025):

Switching to the edge version has resolved this problem for me too. I'm currently running on Ubuntu Server 24.04.2 and accessing via a Brave browser.

Previously I had tried to connect while running the latest build (Chrome, Safari and Brave) and all didn't work.

@madamson747 commented on GitHub (Mar 10, 2025): Switching to the edge version has resolved this problem for me too. I'm currently running on Ubuntu Server 24.04.2 and accessing via a Brave browser. Previously I had tried to connect while running the latest build (Chrome, Safari and Brave) and all didn't work.
Author
Owner

@fdfytr commented on GitHub (Mar 12, 2025):

updated release via docker - same problem linux firefox spinning android tablet and mac has no issues

Are you using the latest edge docker image? If so are you using https? And is it localhost or is it something else like 192.x.x.x?

i am using actual-server:latest with assumption bug was fixed in the latest release
192.xxx with default https on in the browser - tried to put address for exclusion didnt help

changed tag to edge and it is working
thank you

@fdfytr commented on GitHub (Mar 12, 2025): > > updated release via docker - same problem linux firefox spinning android tablet and mac has no issues > > Are you using the latest edge docker image? If so are you using https? And is it localhost or is it something else like 192.x.x.x? i am using actual-server:latest with assumption bug was fixed in the latest release 192.xxx with default https on in the browser - tried to put address for exclusion didnt help changed tag to edge and it is working thank you
Author
Owner

@anatoly314 commented on GitHub (Mar 26, 2025):

Trying to install actualbudjet using k3s and hit the same issue. When I use nodeport to redirect, it doesn't work. When I use portforward using kubectl or k9s it works. Now trying to setup reverse proxy as a sidecar but still unsuccessfully. Maybe someone can point to where I can see more detailed logs than in console? I have added:

            - name: DEBUG
              value: "actual:*"

but don't see nothing helpful.
P.S. forget to mention I have this issue on m1 mac both Chrome and Firefox

@anatoly314 commented on GitHub (Mar 26, 2025): Trying to install actualbudjet using k3s and hit the same issue. When I use nodeport to redirect, it doesn't work. When I use portforward using kubectl or k9s it works. Now trying to setup reverse proxy as a sidecar but still unsuccessfully. Maybe someone can point to where I can see more detailed logs than in console? I have added: ``` - name: DEBUG value: "actual:*" ``` but don't see nothing helpful. P.S. forget to mention I have this issue on m1 mac both Chrome and Firefox
Author
Owner

@dasm commented on GitHub (Mar 27, 2025):

On my end (running v25.3.1) this is fixed by now

Unfortunately, it doesn't work for me. I had this issue few times before v25.3.1 but simple refresh usually fixed it. Now, I'm stuck every time I try to open the budget.
It's interesting, because the fix should be included in the v25.3.1 based on release notes for v25.3.0

Switching to the edge version has resolved this problem for me too. I'm currently running on Ubuntu Server 24.04.2 and accessing via a Brave browser.

When I moved to edge it's working with no issue.

@dasm commented on GitHub (Mar 27, 2025): > On my end (running v25.3.1) this is fixed by now Unfortunately, it doesn't work for me. I had this issue few times before `v25.3.1` but simple refresh usually fixed it. Now, I'm stuck every time I try to open the budget. It's interesting, because the fix should be included in the `v25.3.1` based on [release notes for v25.3.0](https://actualbudget.org/blog/release-25.3.0/) > Switching to the edge version has resolved this problem for me too. I'm currently running on Ubuntu Server 24.04.2 and accessing via a Brave browser. When I moved to `edge` it's working with no issue.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#1155