It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Records deleted from CWD_DIRECTORY_ATTRIBUTE and CWD_DIRECTORY_OPERATION

Philippe Aboulin Jan 16, 2018

Hi,

Sometimes, records are deleted from tables CWD_DIRECTORY_ATTRIBUTE and CWD_DIRECTORY_OPERATION.

The data deleted concerns delegated LDAP authentification. We have to reinsert them manually and restart server. After a while (days or weeks), they are again deleted.

If someone can help to understand...

 

1 answer

0 votes
Ann Worley Atlassian Team Jan 17, 2018

Hi Phillipe,

What an interesting case.

Please let me know more:

  • What version of Confluence are you running?
  • How were the deletions discovered? (I am guessing from your database logs)
  • Do you have logs of the SQL that ran against the database to delete the records?
  • If you check the atlassian-confluence.log for the times the deletions are taking place, what is being recorded at that time? 
  • Were the records originally created by Confluence User Directory setup or were they inserted into the database some other way?
  • What is the impact to your delegated User Directory when the deletions occur? (Can users still log in using that Directory?)

Thank you for providing all these details, I look forward to a better understanding so I can see how to help.

Ann

Philippe Aboulin Jan 19, 2018
  • What version of Confluence are you running?

5.5.2

  • How were the deletions discovered? (I am guessing from your database logs)

No, originally, little problems appeared:

The link to disable users disappeared.

When a space manager tries to grant rights to users on a space, the rights are not granted (without any error message).

After searching, we discovered that the records related to the ldap configuration in the 2 tables had disappeared (we saw that because we also have a test environment on which we have no problem).

After reinserting records and restart server, all worked fine.

  • Do you have logs of the SQL that ran against the database to delete the records?

No SQL logs.

  • If you check the atlassian-confluence.log for the times the deletions are taking place, what is being recorded at that time? 

There is nothing in atlasssian’s log that may explain the problem

  • Were the records originally created by Confluence User Directory setup or were they inserted into the database some other way?

I don't know.

  • What is the impact to your delegated User Directory when the deletions occur? (Can users still log in using that Directory?)

The users can still log in. and they experienced no problem.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

945 views 0 19
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you