original configuration of https://gitea.c3d2.de/; was merged into https://gitea.c3d2.de/c3d2/nix-config
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This repo is archived. You can view files and clone it, but cannot push or open issues/pull-requests.

1.5 KiB

Migration from imbert to zentralwerk

based on https://docs.gitea.io/en-us/backup-and-restore/


sudo -u git  gitea dump -c /etc/gitea/app.ini

@gitea.hq.c3d2.de (lxc 315 @server6)

  • copied gitea-dump-*.zip from imbert to /tmp/

Check consistency:

su gitea
export GITEA_WORK_DIR=/var/lib/gitea
/nix/store/*-gitea-1.15.2/bin/gitea doctor --all

Fix problems caused by database schema changes between Gitea 1.8.3 and 1.15.2

2 Factor Auth didn't work, but was only used by 2 users anyway. We delete the old settings:

delete from two_factor;

There is a new column repository.owner_name that needs be set. Otherwise the web frontend displayed links starting with //.

Before fixing, we checked the owner_names queried by joining via "user".id = repo.owner_id:

select "user".lower_name, repo.owner_name, repo.lower_name from repository as repo inner join "user" on "user".id = repo.owner_id;
UPDATE repository
SET owner_name = map.name
FROM (SELECT "user".lower_name AS name, repository.owner_id AS id
      FROM repository INNER JOIN "user" ON "user".id = repository.owner_id
     ) AS map
WHERE map.id = repository.owner_id;

Problems with old logins

Till now PASSWORD_HASH_ALGO argon2 was used, but seems not to work in the new version. Using the password recovery works.