Junos Space Developer
Highlighted
Junos Space Developer

super account is locked

Tuesday

I want to unlock my super account on Junos Space by using 

mysql -u jboss -p<YOU-JBOSS-PASSWORD> build_db

 

but there's an error "access denied for user root @ local host "

How to solve it?

7 REPLIES 7
Highlighted
Junos Space Developer

Re: super account is locked

Tuesday

Hi Halo,

 

Please follow this KB : https://kb.juniper.net/InfoCenter/index?page=content&id=KB17582&actp=METADATA&act=login

 

 

Regards
-Animesh
If this worked for you please flag my post as an "Accepted Solution" so others can be benefited.
Highlighted
Junos Space Developer

Re: super account is locked

Tuesday

For Super user account locked error -

“This account is locked. You can’t log in” for super user in Junos Space

Run the below command in Space CLI- 

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db -e "update USER_IP_ADDRESS set isLocked=0"

 

Relaunch the Browser post cache clearance or in an Incognito Mode and then login to Space UI.

 

 

Regards
-Animesh
If this worked for you please flag my post as an "Accepted Solution" so others can be benefited.
Highlighted
Junos Space Developer

Re: super account is locked

Tuesday

Hi Thanks for suggestion.

I know the step to unlock super user but there' s error when using this command.

I can't use this command by using current privileges

Capture.PNG

Highlighted
Junos Space Developer

Re: super account is locked

Tuesday

Hi,

 

Thanks for the update. Please make sure you are logged into Space CLI using admin credentials.

What is the error you get when trying to run the below command -

 

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db -A

update USER_IP_ADDRESS set isLocked=0;

update USER set isLocked = 0 where name = 'super';

 

 

Regards

Animesh

Regards
-Animesh
If this worked for you please flag my post as an "Accepted Solution" so others can be benefited.
Highlighted
Junos Space Developer
Solution
Accepted by topic author Halo
Wednesday

Re: super account is locked

Tuesday

Run the below commands only -

 

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db -e "update USER set isLocked = 0 where name = 'super'"

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db -e  "update USER_IP_ADDRESS set isLocked=0"

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db -e "UPDATE USER set password='ok89Nva6qHxytSHsP8AeLg==' where name='super'"

 

Let me know what is the error you get running these commands.. if it goes well -

Login into SPace UI using credentials - super / juniper123

 

 

Regards
-Animesh
If this worked for you please flag my post as an "Accepted Solution" so others can be benefited.
Highlighted
Junos Space Developer

Re: super account is locked

Wednesday

This is useful. Thank you so much

Highlighted
Junos Space Developer

Re: super account is locked

Wednesday
Hi Halo,

Glad was able to help..
Good Day..


Juniper Business Use Only
Regards
-Animesh
If this worked for you please flag my post as an "Accepted Solution" so others can be benefited.
Feedback