Bug 137070 - Evolution LDAP address source requires a filter, filtering not possible
Summary: Evolution LDAP address source requires a filter, filtering not possible
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-09-27 13:55 UTC by krumelmonster
Modified: 2021-12-13 21:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description krumelmonster 2020-09-27 13:55:51 UTC
I tried this using libreoffice-fresh-7.0.0-2 and libreoffice-still-6.4.6-2 arch lnux packages.

I set up a local openldap Server using the evolutionperson.schema. In Evolution I checked the option to "Copy book content locally for offline operation" and I'm able to list, search, create, delete and edit contacts using Evolution mail.

I was hoping to use this LDAP-Server as an address source in libreoffice. After entering the connection details in the address book source wizard, libreoffice lists the available contact attributes, however once I Finish adding the source, I get the error message:

"Unable to display the complete table content. Please apply a filter."

and no data is displayed.

Auto-Filtering and search are greyed out and creating a filter fails silently: when I open the filtering dialog again after setting up a filter, it isn't there anymore. No address book entries are ever shown.

I can add screenshots and more details later but I'm currently investigating two other possibly related issues which are issues with the LDAP-Password dialog (when entrering wrong credentials is will randomly pop up but the address source wizard will continue, leading to issues) and libreoffice now becoming reproducibly unresponsive whenever trying to access my address sources. I will create separate reports on that later – my debug build is compiling atm.

In general it seems like libreoffice LDAP support is currently not usable. As noted elsewhere (for example in bug 57322), a rewrite of this functionality would be desireable and I'm interested in looking into it.
Comment 1 Julien Nabet 2020-09-27 14:32:11 UTC
Just for your information, there are very few patches concerning Base.
If you're interested in contributing LO for code part, you can start here:
https://wiki.documentfoundation.org/Development/GetInvolved

The first step is indeed to retrieve sources and build them.
Comment 2 Xisco Faulí 2020-11-11 15:14:36 UTC
(In reply to krumelmonster from comment #0)
> I can add screenshots and more details later but I'm currently investigating
> two other possibly related issues which are issues with the LDAP-Password
> dialog (when entrering wrong credentials is will randomly pop up but the
> address source wizard will continue, leading to issues) and libreoffice now
> becoming reproducibly unresponsive whenever trying to access my address
> sources. I will create separate reports on that later – my debug build is
> compiling atm.

any update on this ?
Comment 3 QA Administrators 2021-05-11 03:52:31 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2021-06-11 03:51:33 UTC Comment hidden (obsolete)
Comment 5 Julien Nabet 2021-12-13 21:18:35 UTC
krumelmonster: I noticed you indicated:"a rewrite of this functionality would be desireable and I'm interested in looking into it".
Is it still the case?

I mean, you may give a try by following this link https://wiki.documentfoundation.org/Development/GetInvolved ?

Also, search about "Unable to display the complete table content"
I got STR_DATA_CANNOT_SELECT_UNFILTERED.
From this, I got in connectivity/source/commontools/sqlerror.cxx:
125                 case css::sdb::ErrorCondition::DATA_CANNOT_SELECT_UNFILTERED:
126                     return STR_DATA_CANNOT_SELECT_UNFILTERED;

From DATA_CANNOT_SELECT_UNFILTERED, I see in connectivity/source/drivers/evoab2/NResultSet.cxx:
    664     switch ( _rData.eFilterType )
    665     {
    666         case eFilterNone:
    667             if ( !m_pVersionHelper->isLocal( pBook ) )
    668             {
    669                 SQLError aErrorFactory;
    670                 SQLException aAsException = aErrorFactory.getSQLException( ErrorCondition::DATA_CANNOT_SELECT_UNFILTERED, *this );
    671                 m_aWarnings.appendWarning( SQLWarning(
    672                     aAsException.Message,
    673                     aAsException.Context,
    674                     aAsException.SQLState,
    675                     aAsException.ErrorCode,
    676                     aAsException.NextException
    677                 ) );
    678                 bExecuteQuery = false;
    679             }
    680             break;

It's been added with this commit here:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=33e3bcc6dacf4437fa82b00e83e0176a7a726e75
in 2009