Hello.
I'm trying to set up a Jira Service desk on an Azure Ubuntu 18.04 VM connecting to a postgres database in Azure. The setup goes well up until I connect Jira to the database. I test the connection before clicking next, and the test returns okay. When I press next to connect to the database, the whole thing crashes with the following log(see comment)
I haven't been able to find any answers online. Please advice
are you using a Postgres Azure Database or did you install PostgreSQL on a VM ? I think the Postgres Azure Database is not yet supported by Atlassian, as per this ticket on Atlassian support site.
However, Azure SQL Server is officialy supported so you can use this instead as a database server.
Let me know if you have any questions,
--Alexis
Hello Alexis.
We are using a Postgres Azure Database. I just got it to work. I created a new database in on the postgres server, and edited the dbconfig.xml and replaced the DBname with the new one, and then restarted jira. I don't really understand why it works, since it's the exact same database, just called 03 instead of 02.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM public.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "public.propertyentry" does not exist
Position: 68)
com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM public.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "public.propertyentry" does not exist
Position: 68)
The whole log is too long to insert
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If I refresh the page, it returns that the database is locked, furthermore I'm unable to configure the settings again
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.