HTTP Status 500 [...] Unable to esablish a connection with the database. (User not found: SA

Hi,

I've just encountered a error while trying to access my JIRA-system. I have a local database with me as the sole user. I haven't done any changes to the system, nor the JIRA instance.

When I try to access the site, I get this message:

HTTP Status 500 - com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (User not found: SA)

type Exception report

message com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (User not found: SA)

description The server encountered an internal error (com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (User not found: SA)) that prevented it from fulfilling this request.

exception [...]

I've read this solution https://answers.atlassian.com/questions/110284/cannot-access-jira-page-after-upgrade-from-5-1-7-to-version-5-2 which seems to give the same result.

I've tried to delete the plugins, with negative result. I've located the dbconfig.xml file, but don't know how to telnet to the database. This is the url stated in the config-file though:

<url>jdbc:hsqldb:D:\gmbaej\JIRA/database/jiradb</url>

2 answers

1 accepted

1 votes
Richie Gee Atlassian Team May 06, 2013

Hi there,

Just a question, are you using the HSQL for testing purposes, if that is the case, you might want to try follow the steps below to check if whether your HSQL is corrupted or not.

If this is your first installation, then I would suggest just removing the entire <tt><JIRA-home>/database</tt> folder and re-create it. That will remove all previous data and set JIRA into a factory state. In your case, it is better to move to another folder as a backup and see if you are able to start up fresh.

The best recommendation I can give is to use an external database like postgres or mysql as the hsqldb is an in memory database.

Hope this helps :)

You could say testing... I have a 10-license JIRA just for my own purpose - I don't have access to a external db at work.

I did what you said and restored the system - everything seems to work fine. Thank you!

Richie Gee Atlassian Team May 06, 2013

It is my pleasure to assist you as well, and I strongly encourage for your to use external database for your future usage to avoid similar problem from happening again.

Cheers :)

did anthing happen on your drive "D:" ?

i assume this is a testing environment...(jira on windows with hsqldb in the back)

if you feel safe you could try moving the dbconfig.xml file to a different location and force jira to recreate it....during startup it will ask you wich database to connect...enter credentials and location from previosly moved dbconfig.xml file....

if it won't work take a look at jira_home directory...there should be a dir called "export"...unless you didn't disabled auto-backup you should be able to restore your old instance from ${depends on your setup}

let me know how it goes

Thanks for your answer:)

No, nothing have happend to my drive, as I know..

I renamed the dbconfig-file and got this message (I also had to manually delete the "JIRA\plugins\.osgi-plugins\felix\felix-cache"-folder):

As you said I have a backup, but I had hoped that wouldn't be necessary..

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,870 views 12 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot