mirror of
https://github.com/juanfont/headscale.git
synced 2026-01-13 04:40:29 +01:00
[Bug] tailscale on ios cannot connect to the postgresql server #750
Closed
opened 2025-12-29 02:23:24 +01:00 by adam
·
8 comments
No Branch/Tag Specified
main
update_flake_lock_action
gh-pages
kradalby/release-v0.27.2
dependabot/go_modules/golang.org/x/crypto-0.45.0
dependabot/go_modules/github.com/opencontainers/runc-1.3.3
copilot/investigate-headscale-issue-2788
copilot/investigate-visibility-issue-2788
copilot/investigate-issue-2833
copilot/debug-issue-2846
copilot/fix-issue-2847
dependabot/go_modules/github.com/go-viper/mapstructure/v2-2.4.0
dependabot/go_modules/github.com/docker/docker-28.3.3incompatible
kradalby/cli-experiement3
doc/0.26.1
doc/0.25.1
doc/0.25.0
doc/0.24.3
doc/0.24.2
doc/0.24.1
doc/0.24.0
kradalby/build-docker-on-pr
topic/docu-versioning
topic/docker-kos
juanfont/fix-crash-node-id
juanfont/better-disclaimer
update-contributors
topic/prettier
revert-1893-add-test-stage-to-docs
add-test-stage-to-docs
remove-node-check-interval
fix-empty-prefix
fix-ephemeral-reusable
bug_report-debuginfo
autogroups
logs-to-stderr
revert-1414-topic/fix_unix_socket
rename-machine-node
port-embedded-derp-tests-v2
port-derp-tests
duplicate-word-linter
update-tailscale-1.36
warn-against-apache
ko-fi-link
more-acl-tests
fix-typo-standalone
parallel-nolint
tparallel-fix
rerouting
ssh-changelog-docs
oidc-cleanup
web-auth-flow-tests
kradalby-gh-runner
fix-proto-lint
remove-funding-links
go-1.19
enable-1.30-in-tests
0.16.x
cosmetic-changes-integration
tmp-fix-integration-docker
fix-integration-docker
configurable-update-interval
show-nodes-online
hs2021
acl-syntax-fixes
ts2021-implementation
fix-spurious-updates
unstable-integration-tests
mandatory-stun
embedded-derp
prtemplate-fix
v0.28.0-beta.1
v0.27.2-rc.1
v0.27.1
v0.27.0
v0.27.0-beta.2
v0.27.0-beta.1
v0.26.1
v0.26.0
v0.26.0-beta.2
v0.26.0-beta.1
v0.25.1
v0.25.0
v0.25.0-beta.2
v0.24.3
v0.25.0-beta.1
v0.24.2
v0.24.1
v0.24.0
v0.24.0-beta.2
v0.24.0-beta.1
v0.23.0
v0.23.0-rc.1
v0.23.0-beta.5
v0.23.0-beta.4
v0.23.0-beta3
v0.23.0-beta2
v0.23.0-beta1
v0.23.0-alpha12
v0.23.0-alpha11
v0.23.0-alpha10
v0.23.0-alpha9
v0.23.0-alpha8
v0.23.0-alpha7
v0.23.0-alpha6
v0.23.0-alpha5
v0.23.0-alpha4
v0.23.0-alpha4-docker-ko-test9
v0.23.0-alpha4-docker-ko-test8
v0.23.0-alpha4-docker-ko-test7
v0.23.0-alpha4-docker-ko-test6
v0.23.0-alpha4-docker-ko-test5
v0.23.0-alpha-docker-release-test-debug2
v0.23.0-alpha-docker-release-test-debug
v0.23.0-alpha4-docker-ko-test4
v0.23.0-alpha4-docker-ko-test3
v0.23.0-alpha4-docker-ko-test2
v0.23.0-alpha4-docker-ko-test
v0.23.0-alpha3
v0.23.0-alpha2
v0.23.0-alpha1
v0.22.3
v0.22.2
v0.23.0-alpha-docker-release-test
v0.22.1
v0.22.0
v0.22.0-alpha3
v0.22.0-alpha2
v0.22.0-alpha1
v0.22.0-nfpmtest
v0.21.0
v0.20.0
v0.19.0
v0.19.0-beta2
v0.19.0-beta1
v0.18.0
v0.18.0-beta4
v0.18.0-beta3
v0.18.0-beta2
v0.18.0-beta1
v0.17.1
v0.17.0
v0.17.0-beta5
v0.17.0-beta4
v0.17.0-beta3
v0.17.0-beta2
v0.17.0-beta1
v0.17.0-alpha4
v0.17.0-alpha3
v0.17.0-alpha2
v0.17.0-alpha1
v0.16.4
v0.16.3
v0.16.2
v0.16.1
v0.16.0
v0.16.0-beta7
v0.16.0-beta6
v0.16.0-beta5
v0.16.0-beta4
v0.16.0-beta3
v0.16.0-beta2
v0.16.0-beta1
v0.15.0
v0.15.0-beta6
v0.15.0-beta5
v0.15.0-beta4
v0.15.0-beta3
v0.15.0-beta2
v0.15.0-beta1
v0.14.0
v0.14.0-beta2
v0.14.0-beta1
v0.13.0
v0.13.0-beta3
v0.13.0-beta2
v0.13.0-beta1
upstream/v0.12.4
v0.12.4
v0.12.3
v0.12.2
v0.12.2-beta1
v0.12.1
v0.12.0-beta2
v0.12.0-beta1
v0.11.0
v0.10.8
v0.10.7
v0.10.6
v0.10.5
v0.10.4
v0.10.3
v0.10.2
v0.10.1
v0.10.0
v0.9.3
v0.9.2
v0.9.1
v0.9.0
v0.8.1
v0.8.0
v0.7.1
v0.7.0
v0.6.1
v0.6.0
v0.5.2
v0.5.1
v0.5.0
v0.4.0
v0.3.6
v0.3.5
v0.3.4
v0.3.3
v0.3.2
v0.3.1
v0.3.0
v0.2.2
v0.2.1
v0.2.0
v0.1.1
v0.1.0
Labels
Clear labels
CLI
DERP
DNS
Nix
OIDC
SSH
bug
database
documentation
duplicate
enhancement
faq
good first issue
grants
help wanted
might-come
needs design doc
needs investigation
no-stale-bot
out of scope
performance
policy 📝
pull-request
question
regression
routes
stale
tags
tailscale-feature-gap
well described ❤️
wontfix
Mirrored from GitHub Pull Request
No Label
bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: starred/headscale#750
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @wangzhijie0602 on GitHub (Jul 24, 2024).
Is this a support request?
Is there an existing issue for this?
Current Behavior
After I switched my headscale's database from sqlite to postgresql, I used my iPhone to reconnect, and then he prompted the following problem and could not connect correctly, which did not appear on sqlite's headscale.

Expected Behavior
Can connect to the server normally
Steps To Reproduce
install headscale and postgresql in ubuntu22, configure the configuration file and start it, then use tailscale of iPhone to connect to the headscale server
Environment
Runtime environment
Anything else?
No response
@panteparak commented on GitHub (Jul 27, 2024):
which Headscale version are you running? I've just migrated SQLite to Postgres with a few hiccups on DB side, but solvable by running a few SQL commands.
Can you outline a few more details as listed below?
DEBUGLog Level and show us the logs@wangzhijie0602 commented on GitHub (Jul 28, 2024):
I'm glad you can reply to me, I will provide you with more information next
First of all, I didn't migrate from SQLite to Postgres. I directly created an empty Postgres and rejoined it using the tailscale client. I wanted to test Postgres first, so I didn't have time to migrate my SQLite yet.
I created two new servers to reproduce the problem. What follows is a description based on the new environment.
Next I will introduce my environment below
For server side
For client
Client 1:
Client 2:
The following is my headscale config file
The following is my debug log after starting the headscale server
Here I removed the reverse proxy and used IP to connect directly. The derp server uses the official derp server. It still has the same problem as before, so I infer that this problem has nothing to do with the reverse proxy.
@wangzhijie0602 commented on GitHub (Jul 28, 2024):
Here I added two new clients. In fact, the two new clients were not fully connected. I exported my Postgres database file.
Here I first list the performance of the two clients

Client 1:
After connecting, the following is displayed
Client 2:

It stays in this interface after connecting.
The following content is the content of the server after I deleted the nodes on the server after the first connection failed on the Linux client.

@wangzhijie0602 commented on GitHub (Jul 28, 2024):
Next is the sql dump file I exported containing the information of the two clients.
headscale_backup.zip
@wangzhijie0602 commented on GitHub (Jul 28, 2024):
The server information that appears in the above content is the test server I created. I released it after the test was completed. Now these server IPs no longer belong to me.
@wangzhijie0602 commented on GitHub (Jul 28, 2024):
Here are the steps I took when creating the database
sudo -u postgres psql
CREATE USER foo WITH PASSWORD 'bar';
CREATE DATABASE headscale;
GRANT ALL PRIVILEGES ON DATABASE headscale TO foo;
\q
@mpoindexter commented on GitHub (Aug 31, 2024):
I think this is a duplicate of #764
@kradalby commented on GitHub (Sep 3, 2024):
Yes, likely, I will close as duplicate, we can open if not.