6.1.2 to 6.2.2 Upgrade - MySQL Error - 'REFERENCES command denied'

Seafile Server
1

This is from a server that was brought online in v. 4.X. I’ve seen a similar MySQL error in a previous upgrade.

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

Updating seafile/seahub database …

[INFO] You are using MySQL
[INFO] updating ccnet database…
[INFO] updating seahub database…
[ERROR] Failed to execute sql: REFERENCES command denied to user ‘seafile’@‘localhost’ for table ‘revision_tag_tags’

Failed to upgrade your database

When I elevated the MySQL user seafile’s privileges and ran the upgrade script again I got:

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

Updating seafile/seahub database …

[INFO] You are using MySQL
[INFO] updating ccnet database…
[ERROR] Failed to execute sql: Duplicate column name 'reference_id’

Failed to upgrade your database

Following this error I had to REM the lines in the MySQL upgrade script that referred to ‘reference_id’ to get the upgrade to succeed. Afterwards, I go back and reset the user seafile’s privileges to what they were before the error. The server seems to be working fine.

Any idea why I am seeing these errors? What should the MySQL privileges be for user seafile?

Anything I might have missed that would imperil the function of the server from here on?

-Thank you

2

post: show grants for 'seafile'@'localhost';

from manual:

create database `ccnet-db` character set = 'utf8';
create database `seafile-db` character set = 'utf8';
create database `seahub-db` character set = 'utf8';

create user 'seafile'@'localhost' identified by 'seafile';

GRANT ALL PRIVILEGES ON `ccnet-db`.* to `seafile`@localhost;
GRANT ALL PRIVILEGES ON `seafile-db`.* to `seafile`@localhost;
GRANT ALL PRIVILEGES ON `seahub-db`.* to `seafile`@localhost;