I was trying to Upgrade EE to the latest Version, self hosted, Ubuntu 20.04 incl. latest updates
Steps:
docker pull seatable/seatable-ee:latest
cd /opt/seatable
docker-compose down
docker-compose up -d
docker exec -it seatable /bin/bash # Login to the SeaTable container. Then execute the upgrade statement
mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db </opt/seatable/seatable-server-latest/sql/mysql/upgrade/2.5/dtable.sql
As above Value “DB_ROOT_PASSWD” MySQL Password has been added and used
Error Message:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘db’ (111)
Did the seatable-mysql docker container start?
Did the database in the docker container start?
Did you modify the mysql password in the docker-compose.yml?
What does mysql’s log file say?
Can you connect with “mysql -u …”?
The upgrade procedure has been done as X times before
The mysql password has not been changed and mysql is running
Screenshots:
Before “Enter password” the following upgrade command has been executed:
mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db </opt/seatable/seatable-server-latest/sql/mysql/upgrade/2.5/dtable.sql
For above value “DB_ROOT_PASSWD” correct MySQL Password has been added and used
Hi, thank you for asking, the upgrade succeeded with waiting for Version EE 2.5.5, I am not sure if there is a connection between the release and success or any other reason.