Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

无法绑定账号/保存任何设置 #175

Open
1 task done
qwq233 opened this issue Jul 14, 2022 · 15 comments
Open
1 task done

无法绑定账号/保存任何设置 #175

qwq233 opened this issue Jul 14, 2022 · 15 comments
Labels
need more information question unreproducible

Comments

@qwq233
Copy link

qwq233 commented Jul 14, 2022 •
edited by BANKA2017
Loading

  • 我已升级贴吧云签到到最新版本，并且运行了升级脚本

问题描述

如题，本人在尝试过docker镜像与手动安装均无法正常绑定账号/保存任何设置
但能在安装过程中正常地创建sql表，且通过phpmyadmin强行修改设置成功
没有任何报错，未找到日志等辅助信息

复现步骤

绑定账号->手动绑定账号->确认->返回账号管理发现无账号可用
设置中心->随便修改些设置->确认->返回发现无变化

环境

  • 云签到版本：git latest
  • 服务器系统和版本：archlinux nginx php8.0
  • 云签到是否在 Docker 中运行：否
  • PHP 版本：8.0
  • MySQL 版本：mariadb 10.8.3
@qwq233
Copy link
Author

qwq233 commented Jul 15, 2022

暂时不知道提交更多消息的方法 方便告知下如何查看日志之类的方法吗？

@BANKA2017
Copy link
Collaborator

写不进数据库属于玄学问题，云签没有日志这种玩意。建议打开 设置 -> 开发者模式 看看有没有什么奇奇怪怪的报错

@kenvix
Copy link
Member

kenvix commented Jul 15, 2022

云签到和phpmyadmin所用的用户是否相同?

另外建议看一下mysql，php-fpm和nginx的log

@qwq233
Copy link
Author

qwq233 commented Jul 15, 2022

云签到和phpmyadmin所用的用户是否相同?

另外建议看一下mysql，php-fpm和nginx的log

不是 但是安装过程能正常写入数据库 所以应该不是权限的问题

@qwq233
Copy link
Author

qwq233 commented Jul 15, 2022

写不进数据库属于玄学问题，云签没有日志这种玩意。建议打开 设置 -> 开发者模式 看看有没有什么奇奇怪怪的报错

我通过phpmyadmin修改dev项目为1开启了此项，没有看到报错

@BANKA2017
Copy link
Collaborator

写不进数据库属于玄学问题，云签没有日志这种玩意。建议打开 设置 -> 开发者模式 看看有没有什么奇奇怪怪的报错

我通过phpmyadmin修改dev项目为1开启了此项，没有看到报错

尝试命令行跑 do.php 有没有问题？

@qwq233
Copy link
Author

qwq233 commented Jul 15, 2022

写不进数据库属于玄学问题，云签没有日志这种玩意。建议打开 设置 -> 开发者模式 看看有没有什么奇奇怪怪的报错

我通过phpmyadmin修改dev项目为1开启了此项，没有看到报错

尝试命令行跑 do.php 有没有问题？

image

@qwq233
Copy link
Author

qwq233 commented Jul 23, 2022

hello?

@n0099
Copy link
Collaborator

n0099 commented Jul 23, 2022 •
edited
Loading

已mege的#178 可能修复了本issue，请更新后再试

@qwq233
Copy link
Author

qwq233 commented Jul 24, 2022

依旧不行

@kenvix
Copy link
Member

kenvix commented Jul 24, 2022

#178 只是修正了执行问题。造成当前问题的原因仍不明确

@qwq233
Copy link
Author

qwq233 commented Jul 24, 2022

#178 只是修正了执行问题。造成当前问题的原因仍不明确

那有没有办法得到日志或者其他可以用于检修的信息呢

@kenvix
Copy link
Member

kenvix commented Jul 24, 2022

#178 只是修正了执行问题。造成当前问题的原因仍不明确

那有没有办法得到日志或者其他可以用于检修的信息呢

可能没有了。按理说数据库操作失败是会报错的，但是没有报错就很诡异了

@qwq233
Copy link
Author

qwq233 commented Mar 5, 2023

我注意到当我手动添加贴吧的时候，为302跳转至主页且body部分id为error-page。

❯ curl 'https://[EDITED]/setting.php?mod=showtb' -v \
  -H 'authority: [EDITED]' \
  -H 'accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7' \
  -H 'accept-language: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7' \
  -H 'cache-control: max-age=0' \
  -H 'content-type: application/x-www-form-urlencoded' \
  -H 'cookie: uid=1; pwd=[EDITED]' \
  -H 'dnt: 1' \
  -H 'origin: null' \
  -H 'sec-ch-ua: "Chromium";v="110", "Not A(Brand";v="24", "Google Chrome";v="110"' \
  -H 'sec-ch-ua-mobile: ?0' \
  -H 'sec-ch-ua-platform: "Windows"' \
  -H 'sec-fetch-dest: document' \
  -H 'sec-fetch-mode: navigate' \
  -H 'sec-fetch-site: same-origin' \
  -H 'sec-fetch-user: ?1' \
  -H 'sec-gpc: 1' \
  -H 'upgrade-insecure-requests: 1' \
  -H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36' \
  --data-raw 'pid=1&add=%E5%AE%AB%E6%BC%AB' \
  --compressed
*   Trying 104.21.62.212:443...
* Connected to [EDITED] port 443 (#0)
* ALPN: offers h2
* ALPN: offers http/1.1
*  CAfile: /etc/ssl/certs/ca-certificates.crt
*  CApath: none
* [CONN-0-0][CF-SSL] TLSv1.0 (OUT), TLS header, Certificate Status (22):
* [CONN-0-0][CF-SSL] TLSv1.3 (OUT), TLS handshake, Client hello (1):
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Certificate Status (22):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, Server hello (2):
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Finished (20):
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, Encrypted Extensions (8):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, Certificate (11):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, CERT verify (15):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, Finished (20):
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Finished (20):
* [CONN-0-0][CF-SSL] TLSv1.3 (OUT), TLS change cipher, Change cipher spec (1):
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
* [CONN-0-0][CF-SSL] TLSv1.3 (OUT), TLS handshake, Finished (20):
* SSL connection using TLSv1.3 / TLS_AES_256_GCM_SHA384
* ALPN: server accepted h2
* Server certificate:
*  subject: C=US; ST=California; L=San Francisco; O=Cloudflare, Inc.; CN=sni.cloudflaressl.com
*  start date: Apr 25 00:00:00 2022 GMT
*  expire date: Apr 25 23:59:59 2023 GMT
*  subjectAltName: host "[EDITED]" matched cert's "[EDITED]"
*  issuer: C=US; O=Cloudflare, Inc.; CN=Cloudflare Inc ECC CA-3
*  SSL certificate verify ok.
* Using HTTP2, server supports multiplexing
* Copying HTTP/2 data in stream buffer to connection buffer after upgrade: len=0
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
* h2h3 [:method: POST]
* h2h3 [:path: /setting.php?mod=showtb]
* h2h3 [:scheme: https]
* h2h3 [:authority: [EDITED]]
* h2h3 [accept-encoding: deflate, gzip, br, zstd]
* h2h3 [authority: [EDITED]]
* h2h3 [accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7]
* h2h3 [accept-language: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7]
* h2h3 [cache-control: max-age=0]
* h2h3 [content-type: application/x-www-form-urlencoded]
* h2h3 [cookie: uid=1; pwd=[EDITED]]
* h2h3 [dnt: 1]
* h2h3 [origin: null]
* h2h3 [sec-ch-ua: "Chromium";v="110", "Not A(Brand";v="24", "Google Chrome";v="110"]
* h2h3 [sec-ch-ua-mobile: ?0]
* h2h3 [sec-ch-ua-platform: "Windows"]
* h2h3 [sec-fetch-dest: document]
* h2h3 [sec-fetch-mode: navigate]
* h2h3 [sec-fetch-site: same-origin]
* h2h3 [sec-fetch-user: ?1]
* h2h3 [sec-gpc: 1]
* h2h3 [upgrade-insecure-requests: 1]
* h2h3 [user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36]
* h2h3 [content-length: 28]
* Using Stream ID: 1 (easy handle 0x55ecab94aec0)
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
> POST /setting.php?mod=showtb HTTP/2
> Host: [EDITED]
> accept-encoding: deflate, gzip, br, zstd
> authority: [EDITED]
> accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7
> accept-language: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7
> cache-control: max-age=0
> content-type: application/x-www-form-urlencoded
> cookie: uid=1; pwd=[EDITED]
> dnt: 1
> origin: null
> sec-ch-ua: "Chromium";v="110", "Not A(Brand";v="24", "Google Chrome";v="110"
> sec-ch-ua-mobile: ?0
> sec-ch-ua-platform: "Windows"
> sec-fetch-dest: document
> sec-fetch-mode: navigate
> sec-fetch-site: same-origin
> sec-fetch-user: ?1
> sec-gpc: 1
> upgrade-insecure-requests: 1
> user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36
> content-length: 28
>
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
* We are completely uploaded and fine
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, Newsession Ticket (4):
* [CONN-0-0][CF-SSL] TLSv1.3 (IN), TLS handshake, Newsession Ticket (4):
* old SSL session ID is stale, removing
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
* Connection state changed (MAX_CONCURRENT_STREAMS == 256)!
* [CONN-0-0][CF-SSL] TLSv1.2 (OUT), TLS header, Supplemental data (23):
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
< HTTP/2 302
< date: Sun, 05 Mar 2023 05:20:26 GMT
< content-type: text/html; charset=utf-8
< location: index.php
< x-powered-by: PHP/8.0.26
< strict-transport-security: max-age=31536000; includeSubDomains; preload
< referrer-policy: no-referrer
< x-content-type-options: nosniff
< x-download-options: noopen
< x-frame-options: SAMEORIGIN
< x-permitted-cross-domain-policies: none
< x-robots-tag: none
< x-xss-protection: 1; mode=block
< cf-cache-status: DYNAMIC
< nel: {"success_fraction":0,"report_to":"cf-nel","max_age":604800}
< server: cloudflare
< cf-ray: 7a2fe8e16ef90fc0-HKG
< alt-svc: h3=":443"; ma=86400, h3-29=":443"; ma=86400
<

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" lang="zh-CN">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>贴吧云签到 - 提示信息</title>
<style type="text/css">
            html {
                background: #eee;
            }
            body {
                background: #fff;
                color: #333;
                font-family: "微软雅黑","Microsoft YaHei", sans-serif;
                margin: 2em auto;
                padding: 1em 2em;
                max-width: 700px;
                -webkit-box-shadow: 10px 10px 10px rgba(0,0,0,0.13);
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
                box-shadow: 10px 10px 10px rgba(0,0,0,0.13);
                opacity:0.8;
            }
            h1 {
                border-bottom: 1px solid #dadada;
                clear: both;
                color: #666;
                font: 24px "微软雅黑","Microsoft YaHei",, sans-serif;
                margin: 30px 0 0 0;
                padding: 0;
                padding-bottom: 7px;
            }
            #error-page {
                margin-top: 50px;
            }
            h3 {
                text-align:center;
            }
            #error-page p {
                font-size: 9px;
                line-height: 1.5;
                margin: 25px 0 20px;
            }
            #error-page code {
                font-family: Consolas, Monaco, monospace;
            }
            ul li {
                margin-bottom: 10px;
                font-size: 9px ;
            }
            a {
                color: #21759B;
                text-decoration: none;
                margin-top:-10px;
            }
            a:hover {
                color: #D54E21;
            }
            .button {
                background: #f7f7f7;
                border: 1px solid #cccccc;
                color: #555;
                display: inline-block;
                text-decoration: none;
                font-size: 9px;
                line-height: 26px;
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
                height: 28px;
                margin: 0;
                padding: 0 10px 1px;
                cursor: pointer;
                -webkit-border-radius: 3px;
                -webkit-appearance: none;
                border-radius: 3px;
                white-space: nowrap;
                -webkit-box-sizing: border-box;
                -moz-box-sizing:    border-box;
                box-sizing:         border-box;

                -webkit-box-shadow: inset 0 1px 0 #fff, 0 1px 0 rgba(0,0,0,.08);
                box-shadow: inset 0 1px 0 #fff, 0 1px 0 rgba(0,0,0,.08);
                vertical-align: top;
            }

            .button.button-large {
                height: 29px;
                line-height: 28px;
                padding: 0 12px;
            }

            .button:hover,
            .button:focus {
                background: #fafafa;
                border-color: #999;
                color: #222;
            }

            .button:focus  {
                -webkit-box-shadow: 1px 1px 1px rgba(0,0,0,.2);
                box-shadow: 1px 1px 1px rgba(0,0,0,.2);
            }

            .button:active {
                background: #eee;
                border-color: #999;
                color: #333;
                -webkit-box-shadow: inset 0 2px 5px -3px rgba( 0, 0, 0, 0.5 );
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
                box-shadow: inset 0 2px 5px -3px rgba( 0, 0, 0, 0.5 );
            }
            table {
                table-layout:auto;
                border:1px solid #333;
                empty-cells:show;
                border-collapse:collapse;
            }
            th {
                padding:4px;
                border:1px solid #333;
                overflow:hidden;
                color:#333;
                background: #eee;
            }
            td {
                padding:4px;
                border:1px solid #333;
                overflow:hidden;
                color:#333;
            }
        </style>
</head>
<body id="error-page">
<h3>贴吧云签到 - 提示信息</h3><br /><meta http-equiv="refresh" content="0; url=index.php" />请稍候......<br /><br />如果您的浏览器没有自动跳转，请点击下面的链接<br /><a style="float:right" href="index.php"><< 返回上一页</a> <br />
</body>
</html>
* [CONN-0-0][CF-SSL] TLSv1.2 (IN), TLS header, Supplemental data (23):
* Connection #0 to host [EDITED] left intact

nginx的error log没有新内容
access log

"[EDITED]" - [05/Mar/2023:13:30:23 +0800] "POST /setting.php?mod=showtb HTTP/2.0" 302 4437 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36"

@qwq233
Copy link
Author

qwq233 commented Mar 5, 2023

此外，我注意到当我通过"网页授权"(即通过wappass登入)是可以正常添加百度账号的，但是依旧除此之外的设置均无法进行。
但是我通过curl手动添加贴吧也无法进行，因此我暂且排除了浏览器的问题，暂时没有更多想法了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
need more information question unreproducible
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@kenvix @n0099 @BANKA2017 @qwq233