Bamboo admin password reset?

select * from USERS where ID=1 from the reset admin account instructions isn't working. What am I missing?

4 answers

0 vote
Colin Goudie Community Champion Aug 24, 2012

How is it not working? What is the result of running the query?

... Physical database connection acquired for: neen-db-008
08:31:01 [SELECT - 0 row(s), 0.000 secs] [Error Code: 208, SQL State: S0002] Invalid object name 'USERS'.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]

Hi, from the error logs, it looks like you are using SQL Server? Can you provide more information? Perhaps you are not referencing the database/schema name when running the query? Do you know what the name of the schema is?

Maybe try dbo.USERS?

Yes, I am using SQL Server 2008. I have the Bamboo database selected within DBvisualizer. I see the same error no matter which schema I have selected.

Can you please check if the user doing the query has permission? Can you actually see the USERS table from the visualizer? Perhaps it's in lowercase?

I do not see a USERS table. The closest thing is dbo.users

dbo.users. dbo is the default schema.

Same thing. As I said, might be lowercase.

There is not a table named USERS, users, or Users.

I tried again with

SELECT * FROM users where name='_your_user_name_'; as was selected elsewhere and get:
(0 row(s) affected)

Not really an answer, but I've decided to reinstall Bamboo from scratch. Issue closed.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 18, 2017 in Bamboo

FAQ: How to Upgrade Bamboo Server

Bamboo 5.9 will no longer be supported after June 12, 2017. What does this mean? As part of our End of Life policy, Atlassian supports major versions for two years after the first major iteratio...

1,572 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you