For first post, please answer the questions below!
Describe your issue in detail
Hello,
I am trying to install Pydio Cells on Centos
I am failing to complete the step “cells configure”
Here what is the root cause for this failure
2023-06-14T15:47:54.492+0200 INFO pydio.grpc.oauth Checking if legacy migration table exists. {“migration_table”: “schema_migration”}
2023-06-14T15:47:54.509+0200 INFO pydio.grpc.oauth A migration table exists, checking if it is a transactional migration table. {“migration_table”: “schema_migration”}
2023-06-14T15:47:54.515+0200 INFO pydio.grpc.oauth Migration has not yet been applied, running migration. {“version”: “20190100000012000000”}
2023-06-14T15:47:54.517+0200 ERROR pydio.grpc.oauth Could not apply migrations {“error”: “error executing migrations/20190100000012000000_client.up.sql, sql: ALTER TABLE hydra_client ADD created_at timestamp NOT NULL DEFAULT now();\nALTER TABLE hydra_client ADD updated_at timestamp NOT NULL DEFAULT now();\n: Error 1060: Duplicate column name ‘created_at’”, “errorVerbose”: “Error 1060: Duplicate column name ‘created_at’\nerror executing migrations/20190100000012000000_client.up.sql, sql: ALTER TABLE hydra_client ADD created_at timestamp NOT NULL DEFAULT now();\nALTER TABLE hydra_client ADD updated_at timestamp NOT NULL DEFAULT now();\n\ngithub.com/ory/x/popx.NewMigrationBox.func1.1\n\tgithub.com/ory/x@v0.0.368/popx/migration_box.go:80\ngithub.com/ory/x/popx.Migration.Run\n\tgithub.com/ory/x@v0.0.368/popx/migration_info.go:34\ngithub.com/ory/x/popx.(*Migrator).UpTo.func1.2\n\tgithub.com/ory/x@v0.0.368/popx/migrator.go:139\ngithub.com/ory/x/popx.(*Migrator).isolatedTransaction\n\tgithub.com/ory/x@v0.0.368/popx/migrator.go:314\ngithub.com/ory/x/popx.(*Migrator).UpTo.func1\n\tgithub.com/ory/x@v0.0.368/popx/migrator.go:138\ngithub.com/ory/x/popx.(*Migrator).exec\n\tgithub.com/ory/x@v0.0.368/popx/migrator.go:559\ngithub.com/ory/x/popx.(*Migrator).UpTo\n\tgithub.com/ory/x@v0.0.368/popx/migrator.go:92\ngithub.com/ory/x/popx.(*Migrator).Up\n\tgithub.com/ory/x@v0.0.368/popx/migrator.go:80\ngithub.com/ory/hydra/persistence/sql.(*Persister).MigrateUp\n\tgithub.com/ory/hydra@v1.11.10/persistence/sql/persister_migration.go:40\ngithub.com/pydio/cells/v4/common/auth.InitRegistry.func1.1\n\tgithub.com/pydio/cells/v4/common/auth/registry.go:177\ngithub.com/pydio/cells/v4/common/utils/std.Retry\n\tgithub.com/pydio/cells/v4/common/utils/std/func.go:32\ngithub.com/pydio/cells/v4/common/auth.InitRegistry.func1\n\tgithub.com/pydio/cells/v4/common/auth/registry.go:127\nsync.(*Once).doSlow\n\tsync/once.go:74\nsync.(*Once).Do\n\tsync/once.go:65\ngithub.com/pydio/cells/v4/common/auth.InitRegistry\n\tgithub.com/pydio/cells/v4/common/auth/registry.go:118\ngithub.com/pydio/cells/v4/idm/oauth/grpc.init.0.func1.1\n\tgithub.com/pydio/cells/v4/idm/oauth/grpc/plugins.go:90\ngithub.com/pydio/cells/v4/common/service.WithGRPC.func1.1\n\tgithub.com/pydio/cells/v4/common/service/grpc.go:42\ngithub.com/pydio/cells/v4/common/service.(*service).Start\n\tgithub.com/pydio/cells/v4/common/service/service.go:226\ngithub.com/pydio/cells/v4/common/server.(*server).Serve.func2.1\n\tgithub.com/pydio/cells/v4/common/server/server.go:111\ngolang.org/x/sync/errgroup.(*Group).Go.func1\n\tgolang.org/x/sync@v0.1.0/errgroup/errgroup.go:75\nruntime.goexit\n\truntime/asm_amd64.s:1594”}
What version of Cells are you using?
Pydio Cells Home Edition
Version: 4.2.2
Built: 12 Jun 23 11:21 +0000
Git commit: 97743aa135594a3f8eb53ee0c191b61aaa2ad260
OS/Arch: linux/amd64
Go version: go1.19.9
What is the server OS? Database name/version? Browser name or mobile device description (if issue appears client-side)?
Server OS : Centos 7.7.7
Database : MariaDB 5.5.68
Browser name : Firefox 113.0.2 (64 bits)
The issue appears server side
What steps have you taken to resolve this issue already?
I do not understand my error since it was a brand new mariadb installation on my server.
I checked my database “schema_migration” exists and that i