My licence expired and I have purchased a new one. To get the licence I need to: To get your Server ID: * Log in as a Confluence administrator * Click on the Settings icon and choose General configuration * Click on the License Details link (under 'Administration') * Your Server ID is listed in the Server ID field Since Confluence won't start it just gives me a "put in your licence" screen. How do I find the Server ID.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get the Server ID when Confluence won't start

DaveF

My licence expired and I have purchased a new one. To get the licence I need to:

To get your Server ID:

Log in as a Confluence administrator
Click on the Settings icon and choose General configuration
Click on the License Details link (under 'Administration')
Your Server ID is listed in the Server ID field

Since Confluence won't start it just gives me a "put in your licence" screen. How do I find the Server ID.

Accepted answers

Bryan Trummer - ReleaseTEAM

Hi @DaveF - You might want to take a look at this Confluence Knowledge Base article. It includes a SQL query that you can run to hopefully bring you back that information.

https://confluence.atlassian.com/confkb/what-is-the-confluence-server-id-151519275.html

All comments

Bryan Trummer - ReleaseTEAM

Hi @DaveF - You might want to take a look at this Confluence Knowledge Base article. It includes a SQL query that you can run to hopefully bring you back that information.

https://confluence.atlassian.com/confkb/what-is-the-confluence-server-id-151519275.html

Metin _savignano software solutions_

@Bryan Trummer - ReleaseTEAM's answer wouldn't work for me, as I was using the H2 database for a test instance.

However, it's probably even simpler to search the log. You should be able to find a group of lines like these which contain the server ID:

--------------------------
Build Information
--------------------------
maxUsers = -1
installationDate = Fri Nov 01 18:29:59 GMT 2019
supportEntitlementNumber = SEN-L12345678
buildNumber = 8401
serverId = ABCD-CAFE-1234-WXYZ
version = 7.2.0
home = /var/atlassian/application-data/confluence
upTime = 4 minutes, 26 seconds
baseUrl = http://localhost:8090
devMode = false

Evan_W

Umm, which log file and where is it located. I cannot find a log file with this information.

Metin _savignano software solutions_

@Evan_W , on Linux it is usually at /var/atlassian/application-data/confluence/logs/atlassian-confluence.log

For more details about Confluence logfiles, see https://confluence.atlassian.com/doc/working-with-confluence-logs-108364721.html

Evan_W

Hey Metin, thanks for the tip, but I couldn't find the log. It took sometime, and by the way Atlassian, what's with showing a dialogue box without simply showing the server id! Seems like a bug to me.

This is my solution - only took me a day to piece together - again thanks Atlassian.

I needed to interrogate a table in postgres, but I had to login to postgres. Unfortunately my credentials weren't working, so I had to set the database to not require a password (source)
Install locate
$ sudo apt install locate
Update the locate database
$ updatedb
Locate the file pg_hba.conf.
$ locate pg_hba.conf /etc/postgresql/10/main/pg_hba.conf/usr/share/postgresql/10/pg_hba.conf.sample

Edit pg_hba.conf file:

# IPv4 local connections:

host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

127.0.0.1/32 md5

Change below line for MD5 to TRUST

# IPv4 local connections:

host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

127.0.0.1/32 trust

Restart the PostgreSQL Server:
$ sudo /etc/init.d/postgresql restart
Connect the PostgreSQL:
psql -h localhost -U postgrespassword? "password"
Now in the psql environment.
Change the password
confluence=# ALTER USER postgres with password 'new_password';

List all of the databases

postgres=# \l

Select the confluence database
postgres=# \c confluenceSSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)You are now connected to database "confluence" as user "postgres".confluence=#
Look up the server id
confluence=# SELECT * FROM BANDANA WHERE bandanakey = 'confluence.server.id';
The resultant server ID is shown (now you can paste into the licence generation page on the Atlassian site and finally retrieve the missing key).
Quit from postgres
confluence=# \q
Restart the server
Done (Simple eh).

Hal9000

Dear Atlassian. Why must it be so difficult? Please display the server ID on the licence entry form. Make it easy for you to get paid? Win for both of us right?

Mehran_x6vl9c

I absolutely don't get it, why Atlassian Team made every simple thing so complicated. It's about 2 hours I took just to understand how to delete an organization and still no success. An we're not talking about a comprehensive action, just an easy delete option.
And now looking for my Confluence Server ID.

If the perdition of Atlassian Team was, developers have so much free time just to chill in Atlassian account just to figure out how to do a simple process, well you guys should think about it again.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server