Database is empty?!

Question

I'm using Ubuntu 16.04 (I think...) and tried to install some what turned out to be very crappy software to configure an Ubiquity router.  The installer installed mongodb and also updated java to java8.  Once that was done, it appears as though the entire crowd database is empty!

I can't get logged in or anything...  This server has been off-line for two years and I dusted it off the other day.  I was able to get logged in and see all of the old stuff in the database (Jira and Confluence) but after this crappy Unify software install, now I cannot log in or do anything.  I got into postgres and tried to do a select on several crowd and jira tables but the queries return nothing.

I don't even know where to begin.  Some pointers in any direction would be greatly appreciated!

UPDATE: I was able to view data in the tables! Whew!! So, now the question is why can I not get logged in.  The login page keeps putting up a captcha, but no matter what I enter, it is rejected.  Can the version of java be causing a conflict?  I also updated postgres to 9.6.3.  I know there is a config file, dbconfig.xml, that has an element, database-type, that appears to be identifying a postgres version.  It says, postgres72.  Since postgres was updated is there a different value that needs to be used?

Nic Brough -Adaptavist- · Answer

The message "directory not found" tells us that the Crowd this system is configured to use is not responding.

Either start and run the Crowd server that it is pointing to (which is on the same server given the url for it), or consider reverting to using the internal Jira directory.  See https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html

giuro_dev · Answer

All of the Atlassian apps (confluence, crowd, jira, and stash) are starting up.  I see the following errors:

Not enabled: Atlassian UI Plugin, Crowd REST API, Crowd Trusted Apps Integration, Atlassian Soy Templates - Plugin

I followed the instructions I found to no avail.  In the Jira logs I see:

Application context refresh failed (NonValidatingOsgiBundleXmlApplicationContext
(bundle=com.atlassian.labs.hipchat.hipchat-for-jira-plugin, config=osgibundle:/META-INF/spring/*.xml))

2019-01-16 16:55:53,359 atlassian-scheduler-quartz1.clustered_Worker-2 ERROR      
[com.atlassian.scheduler.JobRunnerResponse] Unable to synchronise directory
com.atlassian.crowd.exception.DirectoryNotFoundException: Directory <2> does not exist

ERROR ServiceRunner     
[com.atlassian.scheduler.JobRunnerResponse] Unable to synchronise directory
com.atlassian.crowd.exception.InvalidCrowdServiceException:
The following URL does not specify a valid
Crowd User Management REST service:
http://localhost:8095/crowd/rest/usermanagement/1/search?entity-type=user&start-index=0&max-results=-1&expand=user

As I said, my version of Java went from 7 to 8.  I can't find any Atlassian information I can use to verify that the configuration is finding the correct version of Java.  No online information on configuration helps.

I simply don't know where to even start looking as the logs don't say much more than I've listed above (yes, there are more errors, but they are all pointing to hipchat and crowd...)

Nic Brough -Adaptavist- · Answer

So, it is starting up, suggesting that there is moderately valid data in it, and you can get to a log in screen.

Next step is to read the application logs to find out why you can't log in.  What are the warnings about the failed logins?