Upgrade 6.2.5 to 6.3.1 Table 'ccnet-db.LDAPConfig' doesn't exist

Seafile Server
1

When running the upgrade_6.2_6.3.sh I get the above message:

This script would upgrade your seafile server from 6.2 to 6.3
Press [ENTER] to contiune

Updating seafile/seahub database …

[INFO] You are using MySQL
[INFO] updating ccnet database…
[ERROR] Failed to execute sql: (1146, “Table ‘ccnet-db.LDAPConfig’ doesn’t exist”)

Failed to upgrade your database

seafile@seafile-mysql-test

Had a troll through the various upgrade mysql directories and could not find this table anywhere.

mysql> show tables;
±-------------------+
| Tables_in_ccnet-db |
±-------------------+
| Binding |
| EmailUser |
| Group |
| GroupDNPair |
| GroupUser |
| LDAPUsers |
| OrgGroup |
| OrgUser |
| Organization |
| UserRole |
±-------------------+
10 rows in set (0.00 sec)

This is community edition.

2

Further to this, I can see in binary file seafile/bin/ccnet-server that there is indeed the following:

CREATE TABLE IF NOT EXISTS LDAPConfig ( id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, cfg_group VARCHAR(255) NOT NULL,cfg_key VARCHAR(255) NOT NULL, value VARCHAR(255), property INTEGER) ENGINE=INNODB

so the question is now… in what release was this table created and what has been the effect of running seafile without it.

If this table is manually created, what else needs to happen to start populating it correctly?

A secondary question is what other table creations have been missed in upgrade instructions.

3

So trolling through binary history, it seems this was added seafile server 6.2.x. Hopefully someone from seafile will shed some light on this issue and what should be done.

4

Maybe a databse upgrade is needed. Did you one?

5

That error was reported running the upgrade script.

6

Ok, so what about recreating ccnet-db and load the preferences from ccnet.conf?