H
Homarr6d ago
Pi0rre

Lost a username

Hello everyone, I have lost my administrator username. I can access the container to recreate an admin account with a new password, but I don't know how to do it and there is nothing about this case in the documentation.
Solution:
1. Shut down Homarr 2. Create a full backup of all Homarr files in case something goes wrong 3. Download a SQL Lite database editor and open the users table 4. Search for your username, note it down and then close the editor 5. Start Homarr again, use CLI to reset the password....
Jump to solution
7 Replies
Cakey Bot
Cakey Bot6d ago
Thank you for submitting a support request. Depending on the volume of requests, our team should get in contact with you shortly.
⚠️ Please include the following details in your post or we may reject your request without further comment: - Log (See https://homarr.dev/docs/community/faq#how-do-i-open-the-console--log) - Operating system (Unraid, TrueNAS, Ubuntu, ...) - Exact Homarr version (eg. 0.15.0, not latest) - Configuration (eg. docker-compose, screenshot or similar. Use ``your-text`` to format) - Other relevant information (eg. your devices, your browser, ...)
Frequently Asked Questions | Homarr documentation
Can I install Homarr on a Raspberry Pi?
Manicraft1001
Manicraft10016d ago
What database are you using?
Pi0rre
Pi0rreOP6d ago
#---------------------------------------------------------------------#
# Homarr - A simple, yet powerful dashboard for your server. #
#---------------------------------------------------------------------#
services:
homarr:
container_name: homarr
image: ghcr.io/homarr-labs/homarr:latest
restart: unless-stopped
labels:
- com.centurylinklabs.watchtower.enable=true
networks:
- bw-apps
cap_add:
- SYS_ADMIN
security_opt:
- seccomp:unconfined
volumes:
- /var/run/docker.sock:/var/run/docker.sock # Optional, only if you want docker integration
- ./appdata:/appdata
ports:
- "127.0.0.1:7575:7575"
environment:
#NODE_TLS_REJECT_UNAUTHORIZED: 0
AUTH_PROVIDERS: "credentials,oidc"
AUTH_OIDC_CLIENT_ID: "ce564d618xxxxxx"
AUTH_OIDC_CLIENT_SECRET: "a0MmTxxxxxx"
AUTH_OIDC_NAME_ATTRIBUTE_OVERWRITE: "username"
AUTH_OIDC_CLIENT_NAME: "PIBGD"
AUTH_OIDC_SCOPE_OVERWRITE: "openid"
AUTH_OIDC_PROFILE_ATTRIBUTE: "username"
#AUTH_OIDC_GROUPS_ATTRIBUTE: "groups"
AUTH_OIDC_AUTO_LOGIN: "false"
AUTH_OIDC_ISSUER: "https://sso.pibxxxxx"
BASE_URL: "portail.pibgd.net"
TZ: "Europe/Paris"
NEXTAUTH_URL: "https://portail.pixxxxx"
DEFAULT_COLOR_SCHEME: "dark"
DISABLE_ANALYTICS: "true"
SECRET_ENCRYPTION_KEY: "11e3fxxxxx"
PUID: 1000
PGID: 999
networks:
default:
name: proxy
external: true
bw-apps:
external: true
#---------------------------------------------------------------------#
# Homarr - A simple, yet powerful dashboard for your server. #
#---------------------------------------------------------------------#
services:
homarr:
container_name: homarr
image: ghcr.io/homarr-labs/homarr:latest
restart: unless-stopped
labels:
- com.centurylinklabs.watchtower.enable=true
networks:
- bw-apps
cap_add:
- SYS_ADMIN
security_opt:
- seccomp:unconfined
volumes:
- /var/run/docker.sock:/var/run/docker.sock # Optional, only if you want docker integration
- ./appdata:/appdata
ports:
- "127.0.0.1:7575:7575"
environment:
#NODE_TLS_REJECT_UNAUTHORIZED: 0
AUTH_PROVIDERS: "credentials,oidc"
AUTH_OIDC_CLIENT_ID: "ce564d618xxxxxx"
AUTH_OIDC_CLIENT_SECRET: "a0MmTxxxxxx"
AUTH_OIDC_NAME_ATTRIBUTE_OVERWRITE: "username"
AUTH_OIDC_CLIENT_NAME: "PIBGD"
AUTH_OIDC_SCOPE_OVERWRITE: "openid"
AUTH_OIDC_PROFILE_ATTRIBUTE: "username"
#AUTH_OIDC_GROUPS_ATTRIBUTE: "groups"
AUTH_OIDC_AUTO_LOGIN: "false"
AUTH_OIDC_ISSUER: "https://sso.pibxxxxx"
BASE_URL: "portail.pibgd.net"
TZ: "Europe/Paris"
NEXTAUTH_URL: "https://portail.pixxxxx"
DEFAULT_COLOR_SCHEME: "dark"
DISABLE_ANALYTICS: "true"
SECRET_ENCRYPTION_KEY: "11e3fxxxxx"
PUID: 1000
PGID: 999
networks:
default:
name: proxy
external: true
bw-apps:
external: true
Solution
Manicraft1001
Manicraft10016d ago
1. Shut down Homarr 2. Create a full backup of all Homarr files in case something goes wrong 3. Download a SQL Lite database editor and open the users table 4. Search for your username, note it down and then close the editor 5. Start Homarr again, use CLI to reset the password.
Pi0rre
Pi0rreOP6d ago
Its okay thanks you very much
Manicraft1001
Manicraft10016d ago
Were you able to reset the password this way?
Pi0rre
Pi0rreOP6d ago
So I was able to display the accounts used and then click on them with the reset password commands.

Did you find this page helpful?