Unable to connect to external oracle database

manohar chunchu February 23, 2024

Hi i am using jira data center , i installed app sql connecter for jira , trying to connect to database by providing proper details , while testing connection , getting error like failed to connect.

 

can some tell me why?

image.png

1 answer

0 votes
Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 23, 2024

Hi @manohar chunchu 

Is your server who hos your DC app can reach the server where the DB is hosted ?

 

Regadrs

manohar chunchu February 23, 2024

Yes , because i successfully connected from script runner from same jira center,

now i want to connect using sql connector for jira 

Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 23, 2024

Do you have any log when trying to enable the connection ?

manohar chunchu February 23, 2024

No i don't have 

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 23, 2024

Without the log, you can not narrow down what the error might be.

You will need to look at

  • The network settings 
    • Can your server resolve the name of your database host?
    • Can your server reach the database server over your network?
    • Does the database server respond to your request at all?  (if you got the error message immediately, then it probably did.  If it took over 30 seconds to get the error message, then it's likely that you got no response)
  • Is the database server
    • actively serving requests?  Check with another user of the database service
    • containing the database you are trying to use?
  • Credentials
    • Are you sure the database username and password are right?
    • Does the user for the database have all the right permissions on the database you are connecting to?
manohar chunchu February 23, 2024
  • Can your server resolve the name of your database host? jira is running on my pc localhost instance
  • i can reach to my db server because i already connected to my db from script runner from same jira instance

Suggest an answer

Log in or Sign up to answer