To check if users are active in database, or if they confirmed the registration email, start by connecting to the postgres database on your docker host:
docker exec -it funkwhale2_postgres psql -U funkwhale -d funkwhale
Confirm registration & confirmation status:
SELECT
id,
username,
email,
is_active,
date_joined,
last_login
FROM users_user
ORDER BY date_joined DESC;
will output something like:
id | username | email | is_active | date_joined | last_login
----+----------+-------------------------+-----------+-------------------------------+-------------------------------
4 | Paul | paulXXX@domain.com | t | 2025-12-14 11:18:31.248306+00 | 2025-12-14 11:18:32.49417+00
3 | Mary | maryXYZ@domain.com | t | 2025-12-13 23:33:18.022068+00 | 2025-12-13 23:33:20.309663+00
1 | admin | siteadmin@domain.com | t | 2025-12-13 23:13:51.537683+00 | 2025-12-13 23:32:35.71689+00
(3 rows)Find users who registered but never logged in:
SELECT username, email
FROM users_user
WHERE last_login IS NULL;
Find users who registered but never confirmed:
SELECT username, email
FROM users_user
WHERE is_active = false;