No one cannot login to Confluence

[Princely Benedict]

https://confluence.atlassian.com/crowdkb/cloned-crowd-instance-does-not-allow-login-692782491.html

[Princely Benedict]

Thanks again and here is the database tables. there is no cwd_property table

[AnnWorley]

Hi Princely,

That looks like a screenshot from a Confluence database. Crowd has it's own database. To find the database Crowd is using check for the file crowd.cfg.xml in
the Crowd Home directory in the "shared" folder or right in the root of Crowd home in older versions. The database sever and name will be on this line:

<property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/cwd301</property>

In my case the sever is localhost and the Crowd db is named cwd301.

I look forward to hearing if you can log into Confluence after updating the Crowd database.

Thanks,

Ann

[AnnWorley]

Hi Princely,

Based on the knowledge base article you linked, no one can log into Confluence because of SSL issues with a migrated version of Crowd. The article provides a SQL query to take the secure requirement off the SSO cookie. Was your team able to try the query? Please let us know whether anyone can log into Confluence now.

Thanks,

Ann

[Princely Benedict]

Thanks Ann,

There is no cwd_property table in the data base. We are running confluence server 6.6 on ubuntu 16 LTS and the database is mysql.


Please advise where to run the sql query, i mean which table.

[AnnWorley]

The SSO cookie is set in Crowd. Please run the query against the Crowd database. I double-checked that my Crowd database does have a cwd_property table:

Please backup the Crowd database before running any queries against it and restart Crowd after making the changes.