Users not showing up when searching in "Transfer Library" dialogue

Reitberger · February 1, 2021, 6:21pm

Hello!

I’m using version 8.0.3 CE of Seafile server (updated last weekend from version 6.3 via 7.0 an 7.1 to 8.03) and had the following problem:

When I transfer a library I have to enter the full email address of the user in the dialogue. Then the user itself appears below the input field and can be selected. This worked for some users, but most users weren’t found. Copied the address exactly but “User not found”.
I found out that there was a problem with the “profile_profile” table in the seahub.db.
The value in the column “institution” was “NULL” for users that were found and empty for all other users not found.
For new users the value is empty too, allthough for the column “institution” a standard value of “NULL” is set. Version of MariaDB is 5.5.68 if this matters.

Does this happen anywhere else or am i the only one?

Sincerely Reitberger

lian · February 3, 2021, 7:13am

Hello.

Whether an user can be searched depends on many configurations in seahub_settings.py.

Can you post your seahub_settings.py here, as well as some records in profile_profile table?

Reitberger · February 3, 2021, 9:30am

Hello!

Thank you for your answer. Bur i should say for me the problem ist solved with a workaround. I fill the coulumn “institution” with “NULL” with a batch. But i was wondering why new users are lacking this “NULL” in “institution” and if i am the only one with this problem!

seahub_settings.py:

-- coding: utf-8 --

SECRET_KEY = “xxx”

DATABASES = {
‘default’: {
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘seahub_db’,
‘USER’: ‘seafile’,
‘PASSWORD’: ‘xxx’,
‘HOST’: ‘127.0.0.1’,
‘PORT’: ‘3306’
}
}

CACHES = {
‘default’: {
‘BACKEND’: ‘django_pylibmc.memcached.PyLibMCCache’,
‘LOCATION’: ‘127.0.0.1:11211’,
}
}

EMAIL_USE_TLS = False
EMAIL_HOST = ‘192.168.x.xxx’
EMAIL_HOST_USER = ‘xxx’
EMAIL_HOST_PASSWORD = ‘’
EMAIL_PORT = ‘2525’
DEFAULT_FROM_EMAIL = ‘xxx’
SERVER_EMAIL = ‘xxx’

TIME_ZONE = ‘Europe/Berlin’
SITE_BASE = ‘://xxx’
SITE_NAME = ‘Filehosting-Service xxx’
SITE_TITLE = ‘Filehosting-Service xxx’
SITE_ROOT = ‘/’
ENABLE_SIGNUP = False
ACTIVATE_AFTER_REGISTRATION = False
SEND_EMAIL_ON_ADDING_SYSTEM_MEMBER = True
SEND_EMAIL_ON_RESETTING_USER_PASSWD = True
CLOUD_MODE = True
FILE_PREVIEW_MAX_SIZE = 30 * 1024 * 1024
SESSION_COOKIE_AGE = 60 * 60 * 24 * 7 * 2
SESSION_SAVE_EVERY_REQUEST = False
SESSION_EXPIRE_AT_BROWSER_CLOSE = False
ENABLE_USER_CREATE_ORG_REPO = False
ENABLE_GLOBAL_ADDRESSBOOK = False

FILE_SERVER_ROOT = ‘://xxx/seafhttp’

Reitberger · February 3, 2021, 9:32am

INSERT INTO profile_profile (id, user, nickname, intro, lang_code, login_id, contact_email, institution, list_in_address_book) VALUES
(1, ‘xxx@xxx.xx’, ‘Philipp xxx’, ‘’, ‘de’, NULL, NULL, NULL, 0),
(2, ‘xxx@xxx.xx’, ‘Melina xxx’, ‘’, NULL, NULL, NULL, NULL, 0),
(4, ‘xxx@xxx.xx’, ‘Jana xxx’, ‘’, ‘de’, NULL, NULL, NULL, 0),

lian · February 4, 2021, 3:31am

Hello.

As you have configured CLOUD_MODE = True and ENABLE_GLOBAL_ADDRESSBOOK = False, so when you search user, Seafile will only search from seahub.contacts_contact and seahub.profile_profile table.

Related codes are

github.com

haiwen/seahub/blob/v8.0.3-server/seahub/api2/endpoints/search_user.py#L106




        elif ENABLE_GLOBAL_ADDRESSBOOK:
            # search from ccnet
            email_list += search_user_from_ccnet(q)


            # search from profile, NOT limit search range
            email_list += search_user_from_profile(q)
        else:
            # in cloud mode, user will be added to Contact when share repo
            # search user from user's contacts
            email_list += search_user_when_global_address_book_disabled(request, q)
    else:
        # not CLOUD_MODE
        # search from ccnet
        email_list += search_user_from_ccnet(q)


        # search from profile, NOT limit search range
        email_list += search_user_from_profile(q)
else:
    # if current user can NOT use global address book,
    # he/she can also search `q` from Contact,

and

github.com

haiwen/seahub/blob/v8.0.3-server/seahub/api2/endpoints/search_user.py#L234


    # search within limited_emails
    users = Profile.objects.filter(Q(user__in=limited_emails) &
            (Q(nickname__icontains=q) | Q(contact_email__icontains=q))).values('user')[:10]


    email_list = []
    for user in users:
        email_list.append(user['user'])


    return email_list


def search_user_when_global_address_book_disabled(request, q):
    """ Return 10 items at most.
    """


    email_list = []
    username = request.user.username


    # search from contact
    # get user's contact list
    contacts = Contact.objects.get_contacts_by_user(username)
    for contact in contacts:

So it’s very strange that you can fix the problem by changing value of institution column.

One more question, have you configured custom_search_user feature?

Or can you add some log to seahub/seahub/api2/endpoints/search_user.py to see what happened when you search user?

Reitberger · February 4, 2021, 10:12am

Hello!

Than you for your support. But now the problem seems gone away. Took me hours and many restarts to find my woraround so it works for me and now i can’t reproduce the error anymore. The only thing i’m still wondering is why a new user gets an empty institution value though it should be set to “NULL” by default.

lian · February 4, 2021, 10:34am

I think it’s because of this line of code:

github.com

haiwen/seahub/blob/v8.0.3-server/seahub/profile/models.py#L168




class Profile(models.Model):
    user = models.EmailField(unique=True)
    nickname = models.CharField(max_length=64, blank=True)
    intro = models.TextField(max_length=256, blank=True)
    lang_code = models.TextField(max_length=50, null=True, blank=True)
    # Login id can be email or anything else used to login.
    login_id = models.CharField(max_length=225, unique=True, null=True, blank=True)
    # Contact email is used to receive emails.
    contact_email = models.EmailField(max_length=225, unique=True, null=True, blank=True)
    institution = models.CharField(max_length=225, db_index=True, null=True, blank=True, default='')
    list_in_address_book = models.BooleanField(default=False, db_index=True)
    objects = ProfileManager()


    def set_lang_code(self, lang_code):
        self.lang_code = lang_code
        self.save()


class DetailedProfileManager(models.Manager):
    def add_detailed_profile(self, username, department, telephone):
        d_profile = self.model(user=username, department=department,

Reitberger · February 4, 2021, 10:55am

Thanks again! Now it works an i think i have understood how things work