adminze

Nov 122022
 

One of my owncloud instances is unable to change a new users password from the web UI. This seems to happen often and I couldnt figure out how. But you can change it directly in the SQL database:

– Create the hash e.g. on Cyberchef. Select bcrypt 10 rounds and prepend “1|” to the resulting hash:

– Login to SQL database, e.g.
mysql -h mysql.owncloud.de -u myuser -p mydatabase

– Update new PW, dont forget the 1| in front of the hash
update users set password='1|$2a$10$xxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where uid="yyyyyyy";

Done.