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

davemcmath · 2024-06-17T13:18:44Z

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

youngcw · 2024-06-17T14:18:39Z

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

davemcmath · 2024-06-18T06:12:45Z

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.....

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?

ddz99 · 2024-06-19T14:19:44Z

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.

davemcmath · 2024-06-20T06:59:17Z

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.

newtonfav · 2024-06-27T22:54:55Z

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

youngcw · 2024-06-27T22:58:06Z

@newtonfav Only if your issue is different than this.

newtonfav · 2024-06-27T23:00:14Z

@newtonfav Only if your issue is different than this.

same, just that I'm not running on docker

youngcw · 2024-06-27T23:01:42Z

@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.

newtonfav · 2024-06-28T01:25:04Z

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

nyakojiru · 2024-10-07T06:42:14Z

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 .

hrv231 · 2024-10-15T17:00:55Z

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

tibuski · 2025-02-12T08:51:52Z

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

Ralle001 · 2025-02-12T09:05:00Z

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…"

tibuski · 2025-02-12T10:10:51Z

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

bo0tzz · 2025-02-12T10:25:32Z

I suspect this issue is caused by the uBlock extension: uBlockOrigin/uBlock-issues#3527

tibuski · 2025-02-12T11:51:41Z

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

bo0tzz · 2025-02-12T13:16:28Z

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

MikesGlitch · 2025-02-13T21:23:15Z

This should fix it: #4375

fdfytr · 2025-02-15T15:55:58Z

This should fix it: #4375

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

youngcw · 2025-02-15T15:59:36Z

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.

bibberp · 2025-02-26T21:34:04Z

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

MikesGlitch · 2025-02-26T22:44:40Z

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?

bibberp · 2025-02-27T03:19:47Z

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

MikesGlitch · 2025-02-27T09:25:34Z

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.

bibberp · 2025-02-27T22:55:50Z

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

MikesGlitch · 2025-02-28T14:46:57Z

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.

fdfytr · 2025-03-08T20:10:47Z

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

MikesGlitch · 2025-03-08T20:17:15Z

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?

bo0tzz · 2025-03-08T20:23:23Z

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

davemcmath added the bug Something isn't working label Jun 17, 2024

igorpecovnik mentioned this issue Feb 6, 2025

Software title: actual budget armbian/configng#419

Draft

6 tasks

MikesGlitch mentioned this issue Feb 13, 2025

🐛 Fix Initializing the connection to the local database hang #4375

Merged

MikesGlitch closed this as completed in #4375 Feb 13, 2025

MikesGlitch reopened this Mar 8, 2025

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

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

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

davemcmath commented Jun 17, 2024

youngcw commented Jun 17, 2024

davemcmath commented Jun 18, 2024

ddz99 commented Jun 19, 2024 •

edited

Loading

davemcmath commented Jun 20, 2024

newtonfav commented Jun 27, 2024

youngcw commented Jun 27, 2024

newtonfav commented Jun 27, 2024

youngcw commented Jun 27, 2024

newtonfav commented Jun 28, 2024

nyakojiru commented Oct 7, 2024 •

edited

Loading

hrv231 commented Oct 15, 2024 •

edited

Loading

tibuski commented Feb 12, 2025

Ralle001 commented Feb 12, 2025 •

edited

Loading

tibuski commented Feb 12, 2025

bo0tzz commented Feb 12, 2025

tibuski commented Feb 12, 2025

bo0tzz commented Feb 12, 2025

MikesGlitch commented Feb 13, 2025

fdfytr commented Feb 15, 2025

youngcw commented Feb 15, 2025

bibberp commented Feb 26, 2025 •

edited

Loading

MikesGlitch commented Feb 26, 2025

bibberp commented Feb 27, 2025 •

edited

Loading

MikesGlitch commented Feb 27, 2025 •

edited

Loading

bibberp commented Feb 27, 2025

MikesGlitch commented Feb 28, 2025

fdfytr commented Mar 8, 2025

MikesGlitch commented Mar 8, 2025 •

edited

Loading

bo0tzz commented Mar 8, 2025

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

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

Comments

davemcmath commented Jun 17, 2024

Verified issue does not already exist?

What happened?

Where are you hosting Actual?

What browsers are you seeing the problem on?

Operating System

youngcw commented Jun 17, 2024

davemcmath commented Jun 18, 2024

ddz99 commented Jun 19, 2024 • edited Loading

davemcmath commented Jun 20, 2024

newtonfav commented Jun 27, 2024

youngcw commented Jun 27, 2024

newtonfav commented Jun 27, 2024

youngcw commented Jun 27, 2024

newtonfav commented Jun 28, 2024

nyakojiru commented Oct 7, 2024 • edited Loading

hrv231 commented Oct 15, 2024 • edited Loading

tibuski commented Feb 12, 2025

Ralle001 commented Feb 12, 2025 • edited Loading

tibuski commented Feb 12, 2025

bo0tzz commented Feb 12, 2025

tibuski commented Feb 12, 2025

bo0tzz commented Feb 12, 2025

MikesGlitch commented Feb 13, 2025

fdfytr commented Feb 15, 2025

youngcw commented Feb 15, 2025

bibberp commented Feb 26, 2025 • edited Loading

MikesGlitch commented Feb 26, 2025

bibberp commented Feb 27, 2025 • edited Loading

MikesGlitch commented Feb 27, 2025 • edited Loading

bibberp commented Feb 27, 2025

MikesGlitch commented Feb 28, 2025

fdfytr commented Mar 8, 2025

MikesGlitch commented Mar 8, 2025 • edited Loading

bo0tzz commented Mar 8, 2025

ddz99 commented Jun 19, 2024 •

edited

Loading

nyakojiru commented Oct 7, 2024 •

edited

Loading

hrv231 commented Oct 15, 2024 •

edited

Loading

Ralle001 commented Feb 12, 2025 •

edited

Loading

bibberp commented Feb 26, 2025 •

edited

Loading

bibberp commented Feb 27, 2025 •

edited

Loading

MikesGlitch commented Feb 27, 2025 •

edited

Loading

MikesGlitch commented Mar 8, 2025 •

edited

Loading