Jira with psql

sathyaraj k June 8, 2021

I have pulled Jira and Postgres image and followed the document which is available from our https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-postgresql-938846851.html#ConnectingJiraapplicationstoPostgreSQL-createandconfiguredb .

But it still shows an error while am connecting with the database.

 

 

%MCEPASTEBIN%

5 answers

0 votes
sathyaraj k June 9, 2021

Thanks Hyrum.

Let me try the same and revert the possibilities 

BR,

Sathya

0 votes
Hyrum Steffensen _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 9, 2021

I did a Google search for "Database password decryption not performed." and see a couple Atlassian Community posts suggesting deleting the "dbconfig.xml" file and rerunning the installation. 

Hope this helps,

Hyrum

0 votes
sathyaraj k June 9, 2021

Logs ffrom the path you have mentioned : 

 

atlassian-jira.log : 

root@6709cbc5ded0:/var/atlassian/application-data/jira/log# vi atlassian-jira.log 

root@6709cbc5ded0:/var/atlassian/application-data/jira/log# tail -f atlassian-jira.log 

2021-06-09 13:18:07,173+0000 http-nio-8080-exec-1 WARN anonymous 798x2x1 - 172.17.0.1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:18:07,173+0000 http-nio-8080-exec-1 WARN anonymous 798x2x1 - 172.17.0.1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:18:07,593+0000 http-nio-8080-exec-2 WARN anonymous 798x3x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:18:07,594+0000 http-nio-8080-exec-2 WARN anonymous 798x3x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:18:07,625+0000 http-nio-8080-exec-3 WARN anonymous 798x4x1 - 172.17.0.1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:18:07,625+0000 http-nio-8080-exec-3 WARN anonymous 798x4x1 - 172.17.0.1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:18:07,644+0000 http-nio-8080-exec-4 WARN anonymous 798x5x1 - 172.17.0.1 /secure/johnson-page/777140b2357cda10635f856f68a9388d.woff [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:18:07,644+0000 http-nio-8080-exec-4 WARN anonymous 798x5x1 - 172.17.0.1 /secure/johnson-page/777140b2357cda10635f856f68a9388d.woff [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:18:22,650+0000 http-nio-8080-exec-5 WARN anonymous 798x6x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:18:22,650+0000 http-nio-8080-exec-5 WARN anonymous 798x6x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:21:11,547+0000 http-nio-8080-exec-7 WARN anonymous 801x7x1 - 172.17.0.1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:21:11,549+0000 http-nio-8080-exec-7 WARN anonymous 801x7x1 - 172.17.0.1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:21:11,570+0000 http-nio-8080-exec-8 WARN anonymous 801x8x1 - 172.17.0.1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:21:11,571+0000 http-nio-8080-exec-8 WARN anonymous 801x8x1 - 172.17.0.1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:21:11,863+0000 http-nio-8080-exec-9 WARN anonymous 801x9x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:21:11,863+0000 http-nio-8080-exec-9 WARN anonymous 801x9x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:21:11,955+0000 http-nio-8080-exec-10 WARN anonymous 801x10x1 - 172.17.0.1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:21:11,955+0000 http-nio-8080-exec-10 WARN anonymous 801x10x1 - 172.17.0.1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

2021-06-09 13:21:27,211+0000 http-nio-8080-exec-1 WARN anonymous 801x11x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default

2021-06-09 13:21:27,212+0000 http-nio-8080-exec-1 WARN anonymous 801x11x1 - 172.17.0.1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default

0 votes
sathyaraj k June 9, 2021

I have followed below steps,

step 1 : Download docker images of atlassian/jira-software:latest & postgres:latest

step 2: Run the docker image on 8080:8080 & 5432:5432 respectively

step 3 : Made configuration on dbconfig.xml in jira to get access for postgres

step 4 : docker restart jira (container)

step 5 : Change the listen_address on postgresql.conf (postgres running container) as 192.168.0.103 (local ip)

step 6 : docker restart postgres(conatiner)

 

I didn't use any tool for configuration,

And postgres version is

psql (13.3 (Debian 13.3-1.pgdg100+1))

 

logs : 

2021-06-09 13:01:46,652+0000 JIRA-Bootstrap INFO      [c.a.jira.startup.LauncherContextListener] Startup is complete. Jira is ready to serve.

2021-06-09 13:01:46,659+0000 JIRA-Bootstrap INFO      [c.a.jira.startup.LauncherContextListener] Memory Usage:

    ---------------------------------------------------------------------------------

      Heap memory     :  Used:  422 MiB.  Committed: 1330 MiB.  Max: 1988 MiB

      Non-heap memory :  Used:  331 MiB.  Committed:  357 MiB.  Max: 1536 MiB

    ---------------------------------------------------------------------------------

      TOTAL           :  Used:  753 MiB.  Committed: 1687 MiB.  Max: 3524 MiB

    ---------------------------------------------------------------------------------

2021-06-09 13:02:00,470+0000 Modification Check:thread-1 INFO      [c.a.jira.startup.JiraStartupLogger]

    ___ Modifications ___________________________

         Modified Files                                : seraph-config.xml

         Removed Files                                 : None

2021-06-09 13:02:20,635+0000 http-nio-8080-exec-8 INFO anonymous 781x5x1 1x6orz3 172.17.0.1 /secure/SetupDatabase!default.jspa [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml

2021-06-09 13:02:20,641+0000 http-nio-8080-exec-8 INFO anonymous 781x5x1 1x6orz3 172.17.0.1 /secure/SetupDatabase!default.jspa [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it

2021-06-09 13:02:20,641+0000 http-nio-8080-exec-8 INFO anonymous 781x5x1 1x6orz3 172.17.0.1 /secure/SetupDatabase!default.jspa [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.

2021-06-09 13:02:21,246+0000 http-nio-8080-exec-8 INFO anonymous 781x5x1 1x6orz3 172.17.0.1 /secure/SetupDatabase!default.jspa [c.a.jira.upgrade.PluginUpgradeListener] [plugin-upgrade-listener] Created

2021-06-09 13:02:21,261+0000 http-nio-8080-exec-8 INFO anonymous 781x5x1 1x6orz3 172.17.0.1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.JiraStartupLogger]

    ___ Starting the JIRA Plugin System _________________

Killed

0 votes
Hyrum Steffensen _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 8, 2021

Hello Sathyaraj,

Please answer the following questions:

  • What method are you using to connect the database? Are you using the configuration tool?
  • Which version of Postgres are you using?
  • What is the error message in the Jira system logs?
    • You can view Jira system logs by navigating to <JIRA HOME>/log/atlassian-jira.log

Regards,

Hyrum

Suggest an answer

Log in or Sign up to answer