I have locked myself out of my AWS Yellowfin instance

Mike Sheehan ●

Hi Page,

Thanks for reaching out. Your YF user password can be reset in a couple ways. Note these options are all intended for administrators of the system, so if you're not one, you'll have to request someone in your organization with admin permissions to perform these actions.

The ResetAdmin.jsp method is probably the simplest method, but this will only be possible if you have access to YF's installation folder.

Another option would be to sign in from an Admin account, head into the Admin Console > Users > select user > Password > update Password, and have the Admin (assuming you don't have access to a separate Admin account) create and provide you with a temporary password. At which point you can then sign in and change the password yourself in your Profile Settings.

Finally, if you may actually know your password and have access to the config db, you can run an UPDATE statement in your IpClass table against the AccessAttempts column, setting the value to '0', which will give you more attempts. Something like:

UPDATE 73yellowfin20171201.ipclass SET AccessAttempts = '0' WHERE EmailLeft = 'michael.sheehan';

Please let me know how goes and whether you have any further questions.

Regards,

Mike

Hi Page,

Thanks for reaching out. Your YF user password can be reset in a couple ways. Note these options are all intended for administrators of the system, so if you're not one, you'll have to request someone in your organization with admin permissions to perform these actions.

The ResetAdmin.jsp method is probably the simplest method, but this will only be possible if you have access to YF's installation folder.

Another option would be to sign in from an Admin account, head into the Admin Console > Users > select user > Password > update Password, and have the Admin (assuming you don't have access to a separate Admin account) create and provide you with a temporary password. At which point you can then sign in and change the password yourself in your Profile Settings.

Finally, if you may actually know your password and have access to the config db, you can run an UPDATE statement in your IpClass table against the AccessAttempts column, setting the value to '0', which will give you more attempts. Something like:

UPDATE 73yellowfin20171201.ipclass SET AccessAttempts = '0' WHERE EmailLeft = 'michael.sheehan';

Please let me know how goes and whether you have any further questions.

Regards,

Mike

Reply URL

1

Page ●

Hi Mike,

Yes that is very helpful thanks.

Can you tell what sql developer tool I can use to connect to the database?

Thanks

Files:

Reply URL

1

Mike Sheehan ●

Hi Rebecca,

Any tool that allows you to connecto via JDBC by inputting the connection credentials should do it. I'd say DbVisualizer is a pretty common one.

Please confirm once you're back up-and-running and let me know if you have any further questions.

Regards,

Mike

Reply URL

1

Mike Sheehan ●

Hi Rebecca,

I just wanted to check in and see how things are going with this. Are we okay to close this case out?

Regards,

Mike

Reply URL

1

Mike Sheehan ●

Hi Rebecca,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike

Reply URL

I have locked myself out of my AWS Yellowfin instance

Replies (5)