Upgrade to 11, LDAP problems

Seafile Server
1

Hi,
im running seafile on a FreeBSD server and just migrated from 9.x to 11.
Now i have a problem. Login works fine, but if i try to access Systemadmin/Users/LDAP or LDAP(imported) i get an “internal server error”
Even it is not noted in the upgrade manual i tried to remove the ldap entries in ccnet.conf, but this didn’t help, on the contrary, i couldn’t start the seahub server at all.
The seahub.log shows the following error when i try to access ladp or ldap(imported)

2024-01-14 11:30:38,960 [ERROR] seahub.api2.endpoints.admin.users:920 get Failed to query email_user object list from ccnet_db.
2024-01-14 11:30:38,961 [ERROR] django.request:224 log_response Internal Server Error: /api/v2.1/admin/ldap-users/
2024-01-14 11:30:40,811 [ERROR] seahub.api2.endpoints.admin.users:123 get_user_objs_from_ccnet Failed to query email_user object list from ccnet_db, error: (1064, “You have an error in your SQL syntax; check th
e manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2”).

Thanks for any advice
Gav

2

Did you run the sh upgrade/upgrade_8.0_9.0.sh and sh upgrade/upgrade_9.0_10.0.sh ?

There are also some steps you need to manually take (adding things to config files, installing packages with pip, that kind of stuff). Check the upgrades section of the manual Upgrade notes for 10.0.x - Seafile Admin Manual

3

Yes, i did all the stuff advised
sql upgrade 9-10
sql upgrade 10-11
transferred the ldap config to seahub-settings.py
and run the ldap migration script.
everything exited without error

Freebsd ships actally with 11.0.2.

After checking the code on github i noticed that there are 3 commits in the corresponding 11.0.3 users.py. I hope this will solve my problem.

4

Just to let you know. It was a bug in 11.0.2.
After upgrading to 11.0.3 everything works like expected.