OpenWebUI 사용자 암호 변경

사용자 암호를 잃어버렸을 때 관리자가 변경하는 법


# RANDOM_PASSWORD=$(openssl rand -base64 12)
# HASHED_PASSWORD=$(htpasswd -bnBC 12 "" "$RANDOM_PASSWORD" | tr -d ':\n')
# echo $RANDOM_PASSWORD
N8XhB...
# echo $HASHED_PASSWORD
$2y$12$1111222233334444Je


# cd /var/lib/docker/volumes/chat_openwebui/_data

# ls -F
cache/  uploads/  vector_db/  webui.db

# sqlite3 webui.db

sqlite> .tables
alembic_version   config            group             model
auth              document          knowledge         prompt
channel           feedback          memory            tag
channel_member    file              message           tool
chat              folder            message_reaction  user
chatidtag         function          migratehistory

sqlite> .headers on
sqlite> SELECT * FROM auth;
id|email|password|active
ae46....|john@example.net|$2b$12$....|1
...

sqlite> UPDATE auth
SET password = '$2y$12$1111222233334444Je'
WHERE email = 'john@example.net';