Hey everyone, I’m stuck with a Jira problem. We changed our network setup and now I can’t get into Jira. The catalina.out log shows this error:
Error: Connection refused. Check hostname and port. Postmaster not accepting TCP/IP connections.
It looks like the database connection is failing. The error mentions something about jdbc:postgresql://192.168.1.228:5432/jira.
Does anyone know where I need to update the IP address for the Jira database? I’ve looked through some config files but can’t find the right spot. Any help would be great!
I’ve dealt with this exact issue before after a network reconfiguration. The database connection details are typically stored in the dbconfig.xml file. You’ll want to navigate to your Jira installation directory, then look in the ‘atlassian-jira/WEB-INF/classes’ folder for this file.
Open dbconfig.xml and search for the tag. You should see something like:
jdbc:postgresql://192.168.1.228:5432/jira
Update the IP address here to match your new network configuration. After making the change, save the file and restart your Jira service.
If you’re still having trouble, double-check that the PostgreSQL service is running and accepting connections on the new IP. You might need to update pg_hba.conf on the database server as well to allow connections from Jira’s new IP address.
Having encountered similar issues, I can suggest checking the server.xml file in your Jira installation’s conf directory. This file often contains database connection details.
Look for a tag with attributes like driverClassName, url, username, and password. The url attribute should contain the database IP address you need to update.
After modifying server.xml, remember to restart Jira for changes to take effect. Also, ensure your database server is configured to accept connections from Jira’s new IP address.
If you’re still stuck, reviewing Jira’s official documentation on database configuration might provide additional insights specific to your setup.