I am seeking to replace the admin password by replacing it in the database.
So my password is … W*hA^oHs9q&C2#EdxsDi7oU5eI7FJXkMv@tSbPT
Is it possible to change that into some format that is understood in NC?
All other opensource applications I use have the ability to complete this and it is provided in the documentation
For example Joomla provides d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199 which translates to secret
So I use that to access the admin and change the password.
Can someone supply something that can assist me here please … pretty please?
I don’t understand what you want to do. Joomla and also Nextcloud are storing passwords in a hashed format. A hashing mechanism is always a one-way ticket so that it isn’t possible to extract the original password from a hash.
Simply I wish to put a password of any text to place in the database via phpmyadmin in a form that NC accepts
Why my issue
I cannot install the latest version of NC on my shared server in SiteGround.
NC refuses to update and a clean install times out
I can install on my mac/mamp install and all works fine except for the password when shifting across.
Have been using NC for some time but upgrades are getting unacceptable when they refuse to do that and a total reinstall needs to occur. Little or no help here. /rant
Nothing personal with that rant
Where I am at is I cannot login as admin.
No SSH or command line access.
How will cronjob help?
I have phpmyadmin access so if there is a command I can run there i bow down to your wonderous skills
Thanks
Some hosters allow to setup cronjobs which can be used to execute commands, like e.g. occ user:resetpassword admin. The password can be parsed using the environment
variable OC_PASS as described in the command help.
Additionally you might have seen that all passwords, which are stored in the table oc_users,
have been generated using bcrypt ($2y$10$…). So you could try to generate a replacement
password on a different machine using the htpasswd command.
Thanks j-ed.
I will try again on my local server
Am at my whits end here
Way too much time wasted with this latest.
If this is what will happen moving forward then sadly NC is becoming a bridge too far.
I love it … simple upgrade maintenance like this is just not on.
I think its time to admit that the upgrade process for a system as complex can’t be done through the web frontend itself in a reliable way. The dev team should either deliver or officially give up on this promise as it obviously means stuck users and data loss!
if you do have access to the database, just update the record with the new passwd you want( in a MD5 mode to crypt it)
UPDATE oc_authtoken
SET password = MD5(‘hellohello on rentre du boulot’)
WHERE login_name = ‘yourcnxname’
Given up on this. @Escubaer nailed it.
When a plain vanilla new install does not install there is some issues that need addressing, whether on my own server or shared space.
Having this issue is now of concern on 5 client servers where we’ve had no issues up until now. For now we will leave the installs out of date until this is resolved (we hope) or go to an alternative. I really hope the former.