No more admin user #76

Closed rodinux closed 9 months ago

Describe the bug

A clear and concise description of what the bug is.

Context

Hardware: VPS bought online
YunoHost version: 11.1.20
I have access to my server: Through SSH | through the webadmin
Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: yes
- If yes, please explain: I have try also install forgejo_ynh package on another domain. Since I have no access at admin page of gitea also. I have also try install another Gitea but the same issue still here.

Steps to reproduce

If you used the webadmin, please perform the equivalent command from the CLI first.
If the error occurs in your browser, explain what you did:
1. Go to 'gitea.mydomain.tld'
2. Click on 'my menu user'
3. No Admininistartion link for Gitea
4. Try the url gitea.mydomain.tld/admin
5. Error: "Forbidden"
6. Also a macaron Flash cookie in the console (see #33)

Expected behavior

Have te right to get the administration page

Logs

/var/log/gitea/routeur.log

2023/06/08 18:25:23 [648200f3] router: completed GET /admin for XXX.XXX.XX.XX:0, 403 Forbidden in 1.7ms @ context/auth.go:27(context.Toggle)
2023/06/08 18:25:26 [648200f6] router: completed GET /admin for XXX.XXX.XX.XX:0, 403 Forbidden in 1.9ms @ context/auth.go:27(context.Toggle)

ssh command executed

I have try debug with this command

cd /opt/gitea/
sudo -u gitea ./gitea admin auth update-ldap --security-protocol "Unencrypted" --name "YunoHost LDAP" --id "1" --host "localhost" --port "389" --skip-tls-verify --user-search-base "ou=users,dc=yunohost,dc=org" --user-filter "(&(uid=%s)(objectClass=posixAccount)(permission=cn=gitea.main,ou=permission,dc=yunohost,dc=org))" --firstname-attribute "givenName" --surname-attribute "sn" --email-attribute "mail" --admin-filter "(permission=cn=gitea.admin,ou=permission,dc=yunohost,dc=org)"

If applicable and useful, add screenshots to help explain your problem.

Capture d’écran du 2023-06-08 18-29-12

I have this

# sudo -u gitea ./gitea admin auth list
2023/06/08 18:35:12 ...dules/setting/log.go:286:generateNamedLogger() [I] Xorm Log: File(file:info)
ID  Name        Type            Enabled
1   YunoHost LDAP   LDAP (via BindDN)   true

If I look at the users sudo -u gitea ./gitea admin user list nobody have IsAdmin value true

Also if it helps /var/log/gitea/xorm.log

/var/log/gitea/xorm.log 
2022/10/21 18:41:25 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2022/10/22 01:46:17 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2022/10/22 01:46:25 routers/init.go:135:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/10/22 01:46:25 routers/init.go:135:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/10/23 10:09:58 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2022/10/23 10:10:06 routers/init.go:135:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/10/23 10:10:06 routers/init.go:135:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/10/27 11:38:36 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2022/10/27 11:38:42 routers/init.go:135:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/10/27 11:38:42 routers/init.go:135:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/11/16 23:36:01 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2022/11/16 23:36:06 routers/init.go:135:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/11/16 23:36:06 routers/init.go:135:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/12/01 17:43:39 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2022/12/01 17:43:44 routers/init.go:135:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2022/12/01 17:43:44 routers/init.go:135:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/01/15 23:19:29 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2023/01/15 23:19:29 routers/init.go:145:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/01/15 23:19:29 routers/init.go:145:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/01/15 23:19:41 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2023/01/15 23:19:41 routers/init.go:145:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/01/15 23:19:41 routers/init.go:145:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/02/01 01:46:06 cmd/web.go:160:runWeb() [I] PING DATABASE mysql
2023/02/01 01:46:11 routers/init.go:145:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/02/01 01:46:11 routers/init.go:145:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:13:54 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/03/22 12:13:58 routers/init.go:145:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/03/22 12:13:58 routers/init.go:145:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/03/22 12:13:58 routers/init.go:145:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/03/22 12:13:58 routers/init.go:145:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:13:58 routers/init.go:145:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:13:58 routers/init.go:145:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/03/22 12:14:11 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column repo_id but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column payload_content but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column event_type but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column is_delivered but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column delivered but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column is_succeed but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column request_content but struct has not related field
2023/03/22 12:14:11 models/db/engine.go:190:InitEngineWithMigration() [W] Table hook_task has column response_content but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column repo_id but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column org_id but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column is_system_webhook but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column url but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column http_method but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column content_type but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column secret but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column events but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column is_active but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column last_status but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column created_unix but struct has not related field
2023/03/22 12:14:12 models/db/engine.go:190:InitEngineWithMigration() [W] Table webhook has column updated_unix but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column id but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column uid but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column name but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column token_hash but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column token_salt but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column created_unix but struct has not related field
2023/03/22 12:14:15 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column updated_unix but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column id but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column uid but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column name but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column token_hash but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column token_salt but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column token_last_eight but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column created_unix but struct has not related field
2023/03/22 12:14:17 models/db/engine.go:190:InitEngineWithMigration() [W] Table access_token has column updated_unix but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column id but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column owner_id but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column owner_name but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column lower_name but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column name but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column description but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column website but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column original_service_type but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column original_url but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column default_branch but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_watches but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_stars but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_forks but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_issues but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_closed_issues but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_pulls but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_closed_pulls but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_milestones but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_closed_milestones but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_projects but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column num_closed_projects but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_private but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_empty but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_archived but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_mirror but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column status but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_fork but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column fork_id but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_template but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column template_id but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column size but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column is_fsck_enabled but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column close_issues_via_commit_in_any_branch but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column topics but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column trust_model but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column avatar but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column created_unix but struct has not related field
2023/03/22 12:14:25 models/db/engine.go:190:InitEngineWithMigration() [W] Table repository has column updated_unix but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column id but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column title but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column description but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column repo_id but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column creator_id but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column is_closed but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column board_type but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column type but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column created_unix but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column updated_unix but struct has not related field
2023/03/22 12:14:29 models/db/engine.go:190:InitEngineWithMigration() [W] Table project has column closed_date_unix but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column id but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column repo_id but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column org_id but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column name but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column description but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column color but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column num_issues but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column num_closed_issues but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column created_unix but struct has not related field
2023/03/22 12:14:31 models/db/engine.go:190:InitEngineWithMigration() [W] Table label has column updated_unix but struct has not related field
2023/03/22 12:14:31 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/03/22 12:14:34 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:14:36 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/03/22 12:14:47 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/03/22 12:14:47 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/22 12:14:48 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/03/30 14:57:18 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/03/30 14:57:24 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/04/04 20:31:57 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/04 20:32:02 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/04/30 22:56:55 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/30 22:56:59 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/04/30 23:00:24 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/30 23:00:25 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/04/30 23:00:37 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/04/30 23:00:37 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/05/23 01:33:41 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/05/23 01:33:47 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 18:20:27 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 18:30:07 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:30:07 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 18:50:47 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:50:47 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 18:50:58 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 18:50:58 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 20:04:50 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 20:04:50 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 21:27:42 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 21:27:42 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 21:27:42 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 21:27:42 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 21:27:42 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 21:27:43 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 21:27:43 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 21:27:43 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 21:27:43 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 21:27:43 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 21:27:43 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 21:31:29 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 21:31:29 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 21:31:39 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 21:31:39 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/03 23:39:54 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/03 23:39:54 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/04 00:02:21 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/04 00:02:21 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/06 21:29:49 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/06 21:29:55 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/07 20:20:27 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/07 20:20:27 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/07 21:58:51 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/07 21:58:51 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field
2023/06/08 18:34:20 cmd/web.go:163:runWeb() [I] PING DATABASE mysql
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table system_setting Column version db default is , struct default is 1
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key Column content db nullable is true, struct nullable is false
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table gpg_key_import Column content db nullable is true, struct nullable is false
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table public_key Column content db nullable is true, struct nullable is false
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table project column board_type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table project column card_type db type is INT(11), struct type is INT UNSIGNED
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db default is 0, struct default is 
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table project Column card_type db nullable is false, struct nullable is true
2023/06/08 18:34:20 routers/init.go:148:GlobalInitInstalled() [W] Table project column type db type is INT(10) UNSIGNED, struct type is INT UNSIGNED
2023/06/08 18:34:21 routers/init.go:148:GlobalInitInstalled() [W] Table hook_task has column repo_id but struct has not related field

@rodinux I had the same problem, I supposed I've requested my user to be admin at the installation of the gitea app.

https://forum.gitea.com/t/site-administration-option-is-not-visible/5161/3

I suppose it's possible to modify the mysql database, but meanwhile I've created a new dedicated admin user from the command line:

sudo -u gitea /opt/gitea/gitea admin user create --admin --username giteaadmin --password xxxxxxx --email xxxx@xxx.xx -c /opt/gitea/custom/conf/app.ini

It's a known issue on upstream: https://github.com/go-gitea/gitea/issues/25985

And it also impact forgejo cf: https://github.com/YunoHost-Apps/forgejo_ynh/blob/master/manifest.toml#L42

Hello,

I've investigated for a long time about this issue this evening and at my conclusion it not simple as it look like.

if we disable ENABLE_REVERSE_PROXY_AUTHENTICATION and ENABLE_REVERSE_PROXY_AUTO_REGISTRATION it work correctly (exept the SSO which is disabled). And if we enable ENABLE_REVERSE_PROXY_AUTHENTICATION only gitea will just consider that the user don't exist and it won't work the first time. When the user are created it work correctly. And when we enable ENABLE_REVERSE_PROXY_AUTO_REGISTRATION gitea just for now create a new user without any link with LDAP and it's why it just don't work.

The regression precissly comme from the move from the basic auth to the REMOTE_USER header authentication. So with the basic auth where was some code which managed this correctly but not with the REMOTE_USER authentication. But there are some work since a long time on this to fix here: https://github.com/go-gitea/gitea/issues/2610

So let's hope that it will be merged quickly.

YunoHost-Apps / gitea_ynh