gogs_0.11.91_windows_amd64_mws mws/Microsoft Windows Service
Please start gogs.exe from git/bash
hushui@Hushui MINGW64 /d/git-yl/Win/gogs_0.11.91_windows_amd64_mws
$ ./gogs.exe web
2020/06/15 17:04:28 [ WARN] Custom config 'D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/custom/conf/app.ini' not found, ignore this if you're running first time
2020/06/15 17:04:28 [TRACE] Custom path: D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/custom
2020/06/15 17:04:28 [TRACE] Log path: D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/log
2020/06/15 17:04:28 [TRACE] Log Mode: Console (Trace)
2020/06/15 17:04:28 [ INFO] Gogs 0.11.91.0811
2020/06/15 17:04:28 [ INFO] Cache Service Enabled
2020/06/15 17:04:28 [ INFO] Session Service Enabled
2020/06/15 17:04:28 [ INFO] SQLite3 Supported
2020/06/15 17:04:28 [ INFO] Builtin Windows Service Supported
2020/06/15 17:04:28 [ INFO] Run Mode: Development
2020/06/15 17:04:29 [ INFO] Listen: http://0.0.0.0:3000
[Macaron] 2020-06-15 17:04:57: Started GET / for [::1]
2020/06/15 17:04:57 [TRACE] Session ID: adde026b4033ffe7
2020/06/15 17:04:57 [TRACE] CSRF Token: RVwKGhKmToDSu2gFu8Grwl_0JHg6MTU5MjIxMTg5NzU0MTI1OTgwMA==
[Macaron] 2020-06-15 17:04:57: Completed GET / 302 Found in 2.9916ms
[Macaron] 2020-06-15 17:04:57: Started GET /install for [::1]
2020/06/15 17:04:57 [TRACE] Session ID: adde026b4033ffe7
2020/06/15 17:04:57 [TRACE] CSRF Token: RVwKGhKmToDSu2gFu8Grwl_0JHg6MTU5MjIxMTg5NzU0MTI1OTgwMA==
2020/06/15 17:04:57 [TRACE] Template: install
[Macaron] 2020-06-15 17:04:57: Completed GET /install 200 OK in 49.8661ms
[Macaron] 2020-06-15 17:04:57: Started GET /js/jquery-1.11.3.min.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/libs/jquery.are-you-sure.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /assets/font-awesome-4.6.3/css/font-awesome.min.css for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /css/gogs.css?v=ccddea9a765711f1549140af7b516f0b for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /css/semantic-2.3.1.min.css for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /assets/octicons-4.3.0/octicons.min.css for [::1]
[Macaron] [Static] Serving /assets/font-awesome-4.6.3/css/font-awesome.min.css
[Macaron] [Static] Serving /assets/octicons-4.3.0/octicons.min.css
[Macaron] [Static] Serving /css/semantic-2.3.1.min.css
[Macaron] [Static] Serving /css/gogs.css
[Macaron] [Static] Serving /js/libs/jquery.are-you-sure.js
[Macaron] [Static] Serving /js/jquery-1.11.3.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /assets/font-awesome-4.6.3/css/font-awesome.min.css 200 OK in 69.8131ms
[Macaron] 2020-06-15 17:04:57: Completed GET /assets/octicons-4.3.0/octicons.min.css 200 OK in 67.8174ms
[Macaron] 2020-06-15 17:04:57: Completed GET /js/libs/jquery.are-you-sure.js 200 OK in 70.8105ms
[Macaron] 2020-06-15 17:04:57: Completed GET /css/gogs.css?v=ccddea9a765711f1549140af7b516f0b 200 OK in 68.8156ms
[Macaron] 2020-06-15 17:04:57: Completed GET /js/jquery-1.11.3.min.js 200 OK in 70.8105ms
[Macaron] 2020-06-15 17:04:57: Completed GET /css/semantic-2.3.1.min.css 200 OK in 68.8155ms
[Macaron] 2020-06-15 17:04:57: Started GET /js/semantic-2.3.1.min.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/gogs.js?v=ccddea9a765711f1549140af7b516f0b for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/libs/emojify-1.1.0.min.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/libs/clipboard-1.5.9.min.js for [::1]
[Macaron] [Static] Serving /js/gogs.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/gogs.js?v=ccddea9a765711f1549140af7b516f0b 200 OK in 1.9955ms
[Macaron] [Static] Serving /js/libs/clipboard-1.5.9.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/libs/clipboard-1.5.9.min.js 200 OK in 27.9266ms
[Macaron] [Static] Serving /js/libs/emojify-1.1.0.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/libs/emojify-1.1.0.min.js 200 OK in 47.8727ms
[Macaron] [Static] Serving /js/semantic-2.3.1.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/semantic-2.3.1.min.js 200 OK in 59.8402ms
[Macaron] 2020-06-15 17:04:57: Started GET /css/themes/default/assets/fonts/icons.woff2 for [::1]
[Macaron] [Static] Serving /css/themes/default/assets/fonts/icons.woff2
[Macaron] 2020-06-15 17:04:57: Completed GET /css/themes/default/assets/fonts/icons.woff2 200 OK in 8.976ms
[Macaron] 2020-06-15 17:04:57: Started GET /img/favicon.png for [::1]
[Macaron] [Static] Serving /img/favicon.png
[Macaron] 2020-06-15 17:04:57: Completed GET /img/favicon.png 200 OK in 997.5µs
mysql-5.7.28-winx64
D:\>cd git-yl
D:\git-yl>cd Win
D:\git-yl\Win>cd mysql-5.7.28-winx64
D:\git-yl\Win\mysql-5.7.28-winx64>dir
驱动器 D 中的卷是 hushui
卷的序列号是 6E02-8673
D:\git-yl\Win\mysql-5.7.28-winx64 的目录
2020/06/15 17:25 <DIR> .
2020/06/15 17:25 <DIR> ..
2019/09/27 17:09 <DIR> bin
2020/06/15 17:25 <DIR> data
2019/09/27 17:00 <DIR> docs
2019/09/27 17:00 <DIR> include
2019/09/27 17:09 <DIR> lib
2019/09/27 15:00 279,547 LICENSE
2019/09/27 15:00 587 README
2019/09/27 17:00 <DIR> share
2 个文件 280,134 字节
8 个目录 377,808,109,568 可用字节
D:\git-yl\Win\mysql-5.7.28-winx64>cd bin
D:\git-yl\Win\mysql-5.7.28-winx64\bin>mysql.exe -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.28 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;
Database changed
mysql> select name from user;
ERROR 1054 (42S22): Unknown column 'name' in 'field list'
mysql> select User from user;
+---------------+
| User |
+---------------+
| mysql.session |
| mysql.sys |
| root |
+---------------+
3 rows in set (0.00 sec)
mysql> ALTER USER 'root' IDENTIFIED BY '123456';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%'
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
D:\git-yl\Win\mysql-5.7.28-winx64\bin>mysql.exe -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.28 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql
Database changed
mysql> select User from user;
+---------------+
| User |
+---------------+
| mysql.session |
| mysql.sys |
| root |
+---------------+
3 rows in set (0.01 sec)
mysql>
mysql> quit
Bye
D:\git-yl\Win\mysql-5.7.28-winx64\bin>mysql.exe -u root -p <D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/scripts/mysql.sql
Enter password: ******
D:\git-yl\Win\mysql-5.7.28-winx64\bin>
D:\git-yl\Win\mysql-5.7.28-winx64\bin>mysql.exe -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.28 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database gogs;
Query OK, 1 row affected (0.00 sec)
mysql> use mysql;
Database changed
mysql> create user 'gogs' identified by '123456'
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on gogs.* to 'gogs';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> use gogs;
Database changed
mysql> source D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/scripts/mysql.sql;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
Warning (Code 131): Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
Warning (Code 131): Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
Query OK, 0 rows affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> use gogs
Database changed
mysql> use gogs
Database changed
################################################################
############### set utf8 before any DB import ###############
############################################################
mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)
###########################################################################
mysql> source D:/git-yl/gogs/gogs-XXXXXXXXXXX-mysqldump5.7.28.sql;
mysql> source D:/git-yl/gogs/gogs-git.yuelidata.com-Update-admin-hushui-mysqldump5.7.28.sql;
.............
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.03 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
.................
Error ...........
#### Or use Windows Navicat Premium to import
mysql> show tables
-> ;
+--------------------------+
| Tables_in_gogs |
+--------------------------+
| access |
| access_token |
| action |
| attachment |
| collaboration |
| comment |
| deploy_key |
| email_address |
| follow |
| hook_task |
| issue |
| issue_label |
| issue_user |
| label |
| login_source |
| milestone |
| mirror |
| notice |
| org_user |
| protect_branch |
| protect_branch_whitelist |
| public_key |
| pull_request |
| release |
| repository |
| star |
| team |
| team_repo |
| team_user |
| two_factor |
| two_factor_recovery_code |
| upload |
| user |
| version |
| watch |
| webhook |
+--------------------------+
36 rows in set (0.00 sec)
#### gogs Windows server
hushui@Hushui MINGW64 /d/git-yl/Win/gogs_0.11.91_windows_amd64_mws
$ ./gogs.exe web
2020/06/15 17:04:28 [ WARN] Custom config 'D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/custom/conf/app.ini' not found, ignore this if you're running first time
2020/06/15 17:04:28 [TRACE] Custom path: D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/custom
2020/06/15 17:04:28 [TRACE] Log path: D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/log
2020/06/15 17:04:28 [TRACE] Log Mode: Console (Trace)
2020/06/15 17:04:28 [ INFO] Gogs 0.11.91.0811
2020/06/15 17:04:28 [ INFO] Cache Service Enabled
2020/06/15 17:04:28 [ INFO] Session Service Enabled
2020/06/15 17:04:28 [ INFO] SQLite3 Supported
2020/06/15 17:04:28 [ INFO] Builtin Windows Service Supported
2020/06/15 17:04:28 [ INFO] Run Mode: Development
2020/06/15 17:04:29 [ INFO] Listen: http://0.0.0.0:3000
[Macaron] 2020-06-15 17:04:57: Started GET / for [::1]
2020/06/15 17:04:57 [TRACE] Session ID: adde026b4033ffe7
2020/06/15 17:04:57 [TRACE] CSRF Token: RVwKGhKmToDSu2gFu8Grwl_0JHg6MTU5MjIxMTg5NzU0MTI1OTgwMA==
[Macaron] 2020-06-15 17:04:57: Completed GET / 302 Found in 2.9916ms
[Macaron] 2020-06-15 17:04:57: Started GET /install for [::1]
2020/06/15 17:04:57 [TRACE] Session ID: adde026b4033ffe7
2020/06/15 17:04:57 [TRACE] CSRF Token: RVwKGhKmToDSu2gFu8Grwl_0JHg6MTU5MjIxMTg5NzU0MTI1OTgwMA==
2020/06/15 17:04:57 [TRACE] Template: install
[Macaron] 2020-06-15 17:04:57: Completed GET /install 200 OK in 49.8661ms
[Macaron] 2020-06-15 17:04:57: Started GET /js/jquery-1.11.3.min.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/libs/jquery.are-you-sure.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /assets/font-awesome-4.6.3/css/font-awesome.min.css for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /css/gogs.css?v=ccddea9a765711f1549140af7b516f0b for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /css/semantic-2.3.1.min.css for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /assets/octicons-4.3.0/octicons.min.css for [::1]
[Macaron] [Static] Serving /assets/font-awesome-4.6.3/css/font-awesome.min.css
[Macaron] [Static] Serving /assets/octicons-4.3.0/octicons.min.css
[Macaron] [Static] Serving /css/semantic-2.3.1.min.css
[Macaron] [Static] Serving /css/gogs.css
[Macaron] [Static] Serving /js/libs/jquery.are-you-sure.js
[Macaron] [Static] Serving /js/jquery-1.11.3.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /assets/font-awesome-4.6.3/css/font-awesome.min.css 200 OK in 69.8131ms
[Macaron] 2020-06-15 17:04:57: Completed GET /assets/octicons-4.3.0/octicons.min.css 200 OK in 67.8174ms
[Macaron] 2020-06-15 17:04:57: Completed GET /js/libs/jquery.are-you-sure.js 200 OK in 70.8105ms
[Macaron] 2020-06-15 17:04:57: Completed GET /css/gogs.css?v=ccddea9a765711f1549140af7b516f0b 200 OK in 68.8156ms
[Macaron] 2020-06-15 17:04:57: Completed GET /js/jquery-1.11.3.min.js 200 OK in 70.8105ms
[Macaron] 2020-06-15 17:04:57: Completed GET /css/semantic-2.3.1.min.css 200 OK in 68.8155ms
[Macaron] 2020-06-15 17:04:57: Started GET /js/semantic-2.3.1.min.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/gogs.js?v=ccddea9a765711f1549140af7b516f0b for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/libs/emojify-1.1.0.min.js for [::1]
[Macaron] 2020-06-15 17:04:57: Started GET /js/libs/clipboard-1.5.9.min.js for [::1]
[Macaron] [Static] Serving /js/gogs.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/gogs.js?v=ccddea9a765711f1549140af7b516f0b 200 OK in 1.9955ms
[Macaron] [Static] Serving /js/libs/clipboard-1.5.9.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/libs/clipboard-1.5.9.min.js 200 OK in 27.9266ms
[Macaron] [Static] Serving /js/libs/emojify-1.1.0.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/libs/emojify-1.1.0.min.js 200 OK in 47.8727ms
[Macaron] [Static] Serving /js/semantic-2.3.1.min.js
[Macaron] 2020-06-15 17:04:57: Completed GET /js/semantic-2.3.1.min.js 200 OK in 59.8402ms
[Macaron] 2020-06-15 17:04:57: Started GET /css/themes/default/assets/fonts/icons.woff2 for [::1]
[Macaron] [Static] Serving /css/themes/default/assets/fonts/icons.woff2
[Macaron] 2020-06-15 17:04:57: Completed GET /css/themes/default/assets/fonts/icons.woff2 200 OK in 8.976ms
[Macaron] 2020-06-15 17:04:57: Started GET /img/favicon.png for [::1]
[Macaron] [Static] Serving /img/favicon.png
[Macaron] 2020-06-15 17:04:57: Completed GET /img/favicon.png 200 OK in 997.5μs
[Macaron] 2020-06-15 18:05:22: Started POST /install for [::1]
2020/06/15 18:05:22 [TRACE] Session ID: adde026b4033ffe7
2020/06/15 18:05:22 [TRACE] CSRF Token: RVwKGhKmToDSu2gFu8Grwl_0JHg6MTU5MjIxMTg5NzU0MTI1OTgwMA==
.................
2020/06/15 18:05:22 [TRACE] Custom path: D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/custom =========> gogs_0.11.91_windows_amd64_mws\custom\conf\app.ini
2020/06/15 18:05:22 [TRACE] Log path: D:/git-yl/Win/gogs_0.11.91_windows_amd64_mws/log