Hi.
I've just reset the root pasword on our preprod squiz but can't see how to unlock the root user (still under construction).
A normal admin user can get the lock on the root user and change the password from the one the reset script allocates but can't see how to make that live (login still fails).
Any help gratefully received.
Jeff.
It probably does actually make sense to set the root user live in that script too.
In the mean time I think you could work around this situation with the status change script.
To double check the ID of the root user, use the following SQL:
select assetid from sq_ast where type_code = 'root_user';
It's normally #12, but it's always a good idea to double check.
Based on you being able to change the root password with a sys admin account, eludes to the root user being deactivated on your system. The root user doesn't have to be live for you to be able to login with it.
You can confirm this if you login with the root user and correct password and get a message saying something like "Root User account is disabled in this system".
In which case, you need to do this:
On the VM, log into the terminal as root (like what you did in the manuals) and go to the matrix home directory (I think it is located at /var/www/matrix). Then load up main.inc in an editor (eg. vim data/private/conf/main.inc or nano data/private/conf/main.inc) and change SQ_CONF_ROOT_USER_DISABLED from 1 to 0. This should enable the root user again. For more information, read: http://manuals.matri...c#user-settings
See thread: http://forums.squizsuite.net/index.php?showtopic=12506
Does that help?
Cheers Bart!
That was the missing piece of the puzzle - now back in as root (with a proper password).
Thanks to all who replied.