Search in clients do not work with standalone database

Description

At first it seemed like an issue with search in LDAP, but a user reports, that search with integration with AD works fine in Spark 2.8.1 and Openfire 4.1.1 when embedded database is used, but not when MySQL is used. This issues started with 4.1 (was fine in 4.0.3).

Environment

None

Activity

Show:
wroot
February 6, 2017, 12:08 PM

More information: it seems that Search plugin 1.7.1 has problems with searching. 1.7.0 is reported to work better. 1.7.1 only fixed - Fixed Stored Cross-Site Scripting vulnerability.

wroot
March 1, 2017, 2:51 PM

User reports that after an update to 4.1.3 using Search plugin 1.7.0 doesn't work anymore, it also shows an error that Search page is not available https://community.igniterealtime.org/thread/60310

Daryl Herzmann
March 1, 2017, 3:37 PM

I tried to reproduce

1. Built current master branch of Openfire
2. Ran through the setup, picked embedded db
3. Went to plugins page on console and installed search 1.7.1 plugin
4. Navigated back to the user search tool provided by the plugin and it worked.

wroot
March 1, 2017, 4:05 PM

Daryl, it works with embedded one. By standalone i meant external (mysql, etc.). And it only affects Spark. Web search is not affected probably, i haven't even tried.

speedy
August 11, 2017, 3:13 PM

tested this on windows

fresh install using defaults

my sql 5.7. 19, OF 4.1.5,

Authenticated against my existing AD/LDAP.  

search worked as expected. I was able to search within spark and the admin console without issue.

Assignee

Dave Cridland

Reporter

wroot

Expected Effort

None

Ignite Forum URL

None

Components

Affects versions

Priority

Major
Configure