My licence expired and I have purchased a new one. To get the licence I need to:
To get your Server ID:
Since Confluence won't start it just gives me a "put in your licence" screen. How do I find the Server ID.
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.
@BryanT'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:
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 , 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
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)
Update the locate database
Locate the file pg_hba.conf.
Edit pg_hba.conf file:
Change below line for MD5 to TRUST
Restart the PostgreSQL Server:
Connect the PostgreSQL:
Now in the psql environment.
Change the password
List all of the databases
Select the confluence database
Look up the server id
Quit from postgres
Restart the server
Done (Simple eh).
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event