Minimize downtime with Read-Only Mode for Confluence Data Center

At Atlassian, we know work can’t stop for maintenance windows. For many organizations, it can be difficult for admins to find time for planned maintenance. After all, downtime on mission-critical applications can affect productivity and team output. To minimize planned downtime in Jira Software and Jira Service Desk Data Center, we introduced zero downtime upgrades – admins can shut down and … Read moreMinimize downtime with Read-Only Mode for Confluence Data Center

Running Confluence behind NGINX with SSL

This page describes how to set up NGINX as a reverse proxy for Confluence. The configuration described on this page results in a scenario where: External client connections with NGINX are secured using SSL. Connections between NGINX and Confluence Server are unsecured. Confluence Server and NGINX run on the same machine. We assume that you already have a running instance of … Read moreRunning Confluence behind NGINX with SSL

Securing your Atlassian applications with Apache using SSL

This page explains how to configure HTTPS (HTTP over SSL) when using Apache as a reverse proxy. You should consider doing this to ensure usernames, passwords and other proprietary data are encrypted when accessing your applications over the internet. The instructions on this page apply to the following Atlassian server applications: JIRA server applications (JIRA Software Server, … Read moreSecuring your Atlassian applications with Apache using SSL

How to use NGINX to proxy requests for Confluence

Purpose This page describes a possible way to use NGINX to proxy requests for Confluence running in a standard Tomcat container. You can find additional documentation that explains how to use Apache mod_proxy for the very same purpose.  For Confluence 6.0 or later you’ll need a version of NGINX that supports WebSockets (1.3 or later). Solution Configuring Tomcat … Read moreHow to use NGINX to proxy requests for Confluence

Start and Stop JIRA applications

How you start and stop your JIRA application depends on whether you are running JIRA as a Service. Windows If you installed JIRA as a service, you can Start JIRA Server and Stop JIRA Server from the Windows Start menu. You can’t start or stop JIRA manually using the start-jira.bat and stop-jira.bat file. If you didn’t install JIRA as a service you’ll need … Read moreStart and Stop JIRA applications

Confluence: pid file found but no matching process was found. Stop aborted.

I am trying to stop confluence through ./stop-confluence.sh but it is showing error like this “PID file found but no matching process was found. Stop aborted.” so I try to kill that process with “kill -9 pid” but it showing that “PID: no process found”. Can anyone please give me any idea what is going … Read moreConfluence: pid file found but no matching process was found. Stop aborted.

How to drop a PostgreSQL database if there are active connections to it?

I need to write a script that will drop a PostgreSQL database. There may be a lot of connections to it, but the script should ignore that. The standard DROP DATABASE db_name query doesn’t work when there are open connections. How can I solve the problem? This will drop existing connections except for yours: Query pg_stat_activity and get the … Read moreHow to drop a PostgreSQL database if there are active connections to it?

Permission denied in Postgres

I added the user myuserto Postgres. Then I added the database mydatabase in the pgAdmin III GUI and restored from a backup file. So the owner of mydatabase is the superuser postgres. Then I tried to give all rights to access and modify mydatabase to myuser. I logged into psql as user postgres: psql -d template1 -U postgres and then I ran this query: GRANT ALL PRIVILEGES … Read morePermission denied in Postgres