Atlas-connect jira app threw 'Unauthorized: Could not lookup stored client data' and 'SequelizeConnectionError' after publised in heroku

Hello everyone.

I am new about developing jira-plugin with atlas-connect. I am getting error when i try to test my app on jira. I am gonna write all steps that i applied. Could you please help me about this issue?

  1. I create an application with atlas-connect cli.
  2. I developed my app on react.
  3. I tried this on jira with my localhost. It worked properly.
  4. I followed the documentation and i published my application on heroku.
  5. Next it threw error like this.
    I think it is about postgresql. But ı dont want to store and use data in postgresql. Because i want to use just entity properties data from jira cloud. And also i want to use this way with AP.request from all.js.

Can you give please me some advice about this issue what can i do for fixing error?

Config.json

{
    "development": {
        "port": 3000,
        "errorTemplate": true,
        "store": {
            "adapter": "sequelize",
            "dialect": "sqlite3",
            "logging": false,
            "type": "memory"
        }
    },
    "production": {
        "port": "$PORT",
        "errorTemplate": true,
        "localBaseUrl": "https://x-y-z.herokuapp.com", // the url which i published my app on her oku
        "store": {
            "type": "postgres",
            "url": "$DATABASE_URL"
        },
        "whitelist": [
            "*.jira-dev.com",
            "*.atlassian.net",
            "*.atlassian.com",
            "*.jira.com"
        ]
    },
    "product": "jira"
}

atlassian-connect.json

{
    "key": "abc",
    "name": "abc",
    "description": "My very first app",
    "baseUrl": "{{localBaseUrl}}",
    "vendor": { 
      "name": "vendor", 
      "url": "vendor website"
    },
    "authentication": {
        "type": "jwt"
    },
    "lifecycle": {
        "installed": "/installed"
    },
    "scopes": [
        "READ"
    ],
    "modules": {
        "webPanels": [
          {
            "key": "example-issue-left-panel",
            "location": "atl.jira.view.issue.right.context",
            "name": {
              "value": "My app"
            },
            "url": "/panel",
            "weight": 50
          }
        ]
    }
}

And error

1 Like

Welcome to the Atlassian developer community @kaanyesil. Thanks for posting with so much detail!

The Postgres requirement supports the Connect install lifecycle. I don’t know how to get around that with Atlassian Connect Express (ACE).

However, what you seek is possible. The pattern is known as a “static app” and there is an example from many years ago. To my knowledge, the pattern is still valid, even if front-end JavaScript has moved on from jquery. :wink: There’s just no reason to use ACE, or any back-end server if this is how you want to build your App. And I think all that React you wrote can still be extracted.

1 Like

Thank you so much @ibuchanan.

I am going to try this way :slight_smile:

1 Like

@ kaanyesil I was troubleshooting this similar error all day today. I solved it by running:

heroku config:set PGSSLMODE=no-verify

As specified here: Node.js, PostgreSQL error: no pg_hba.conf entry for host - Stack Overflow

Credit to boris’s reply here:

1 Like