qd-today / qd

QD [v20240210] —— HTTP请求定时任务自动执行框架 base on HAR Editor and Tornado Server
https://qd-today.github.io/qd/
MIT License
4.44k stars 576 forks source link

第一次按照,按照教程,也按照6.14更新,但是点击公开模板就是500 #22

Closed zasl closed 4 years ago

zasl commented 4 years ago

第一次按照,按照教程,也按照6.14注册admin,但是点击公开模板就是500

AragonSnow commented 4 years ago

@zasl 公开模板不需要注册admin。500的话上传日志看看。

zasl commented 4 years ago

root@N1:~# docker logs qiandao [I 200915 16:14:39 run:55] http server started on 0.0.0.0:80 [I 200915 16:14:43 web:2064] 302 GET / (172.31.0.1) 6.90ms [I 200915 16:14:43 web:2064] 302 GET /my/ (172.31.0.1) 5.53ms [I 200915 16:14:43 web:2064] 200 GET /login (172.31.0.1) 248.51ms [I 200915 16:14:49 web:2064] 302 POST /register (172.31.0.1) 648.53ms [I 200915 16:14:49 utils:177] no smtp [I 200915 16:14:49 web:2064] 200 GET /my/ (172.31.0.1) 271.06ms [E 200915 16:14:51 web:1591] Uncaught exception GET /subscribe/ (172.31.0.1) HTTPServerRequest(protocol='http', host='192.168.2.1:18888', method='GET', uri='/subscribe/', version='HTTP/1.1', remote_ip='172.31.0.1', headers={'Accept-Language': 'zh-CN,zh-TW;q=0.9,zh;q=0.8,en-GB;q=0.7,en-US;q=0.6,en;q=0.5', 'Accept-Encoding': 'gzip, deflate', 'Host': '192.168.2.1:18888', '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.9', 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', 'Dnt': '1', 'Connection': 'keep-alive', 'Referer': 'http://192.168.2.1:18888/my/', 'Cookie': '_xsrf=2|f801fa66|9aeba6c139d0a86ce0c651ef603423bf|1600157325; user="2|1:0|10:1600157689|4:user|68:hMQEcm9sZcDECG5pY2tuYW1lwMQCaWQBxAVlbWFpbLMyNTE3NTAzMzMzMzNAcXEuY29t|cfab8ddcb8107354de326574bca73a1c808db8a0a30a72f4b83a52af0450b93c"', 'Upgrade-Insecure-Requests': '1'}) Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/tornado/web.py", line 1510, in _execute result = method(*self.path_args, self.path_kwargs) File "/usr/local/lib/python2.7/site-packages/tornado/web.py", line 1768, in wrapper return method(self, *args, *kwargs) File "/usr/local/lib/python2.7/site-packages/tornado/web.py", line 2898, in wrapper return method(self, args, kwargs) File "/usr/src/app/web/handlers/subscribe.py", line 42, in get res = requests.get(url, verify=False) File "/usr/local/lib/python2.7/site-packages/requests/api.py", line 76, in get return request('get', url, params=params, kwargs) File "/usr/local/lib/python2.7/site-packages/requests/api.py", line 61, in request return session.request(method=method, url=url, kwargs) File "/usr/local/lib/python2.7/site-packages/requests/sessions.py", line 530, in request resp = self.send(prep, send_kwargs) File "/usr/local/lib/python2.7/site-packages/requests/sessions.py", line 643, in send r = adapter.send(request, kwargs) File "/usr/local/lib/python2.7/site-packages/requests/adapters.py", line 516, in send raise ConnectionError(e, request=request) ConnectionError: HTTPSConnectionPool(host='gitee.com', port=443): Max retries exceeded with url: /api/v5/repos/qiandao-today/templates/readme (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0xffff81c57310>: Failed to establish a new connection: [Errno 111] Connection refused',)) [E 200915 16:14:51 web:1591] Uncaught exception GET /subscribe/ (172.31.0.1) HTTPServerRequest(protocol='http', host='192.168.2.1:18888', method='GET', uri='/subscribe/', version='HTTP/1.1', remote_ip='172.31.0.1', headers={'Accept-Language': 'zh-CN,zh-TW;q=0.9,zh;q=0.8,en-GB;q=0.7,en-US;q=0.6,en;q=0.5', 'Accept-Encoding': 'gzip, deflate', 'Host': '192.168.2.1:18888', '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.9', 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', 'Dnt': '1', 'Connection': 'keep-alive', 'Referer': 'http://192.168.2.1:18888/my/', 'Cookie': '_xsrf=2|f801fa66|9aeba6c139d0a86ce0c651ef603423bf|1600157325; user="2|1:0|10:1600157689|4:user|68:hMQEcm9sZcDECG5pY2tuYW1lwMQCaWQBxAVlbWFpbLMyNTE3NTAzMzMzMzNAcXEuY29t|cfab8ddcb8107354de326574bca73a1c808db8a0a30a72f4b83a52af0450b93c"', 'Upgrade-Insecure-Requests': '1'}) Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/tornado/web.py", line 1510, in _execute result = method(*self.path_args, self.path_kwargs) File "/usr/local/lib/python2.7/site-packages/tornado/web.py", line 1768, in wrapper return method(self, *args, *kwargs) File "/usr/local/lib/python2.7/site-packages/tornado/web.py", line 2898, in wrapper return method(self, args, kwargs) File "/usr/src/app/web/handlers/subscribe.py", line 42, in get res = requests.get(url, verify=False) File "/usr/local/lib/python2.7/site-packages/requests/api.py", line 76, in get return request('get', url, params=params, kwargs) File "/usr/local/lib/python2.7/site-packages/requests/api.py", line 61, in request return session.request(method=method, url=url, kwargs) File "/usr/local/lib/python2.7/site-packages/requests/sessions.py", line 530, in request resp = self.send(prep, send_kwargs) File "/usr/local/lib/python2.7/site-packages/requests/sessions.py", line 643, in send r = adapter.send(request, kwargs) File "/usr/local/lib/python2.7/site-packages/requests/adapters.py", line 516, in send raise ConnectionError(e, request=request) ConnectionError: HTTPSConnectionPool(host='gitee.com', port=443): Max retries exceeded with url: /api/v5/repos/qiandao-today/templates/readme (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0xffff81c57310>: Failed to establish a new connection: [Errno 111] Connection refused',)) [E 200915 16:14:51 web:2064] 500 GET /subscribe/ (172.31.0.1) 42.82ms [E 200915 16:14:51 web:2064] 500 GET /subscribe/ (172.31.0.1) 42.82ms [I 200915 16:14:59 web:2064] 200 GET /pushs (172.31.0.1) 205.90ms

麻烦您看下,N1刷的openwrt

AragonSnow commented 4 years ago

@zasl 显示是打开不gitee, 你可以再openwrt中试试curl能不能正常打开 https://gitee.com/qiandao-today/templates。然后防火墙上要放行

zasl commented 4 years ago

好的,我尝试一下,我是从b站的教程中知道这里的,看到b站的回复有群晖跟我情况是一样的。我现在重新安装去。

zasl commented 4 years ago

小白一个,您看下我这个是可以的吗?如果可以,请问如何防火墙放行?

root@N1:~# curl https://gitee.com/qiandao-today/templates <!DOCTYPE html>

qiandao-today/templates
Watch 1 Star 2 Fork 1

qiandao-today / templates

加入 Gitee
与超过 500 万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未指定开源许可证,未经作者的许可,此代码仅用于学习,不能用于其他用途。
暂无描述 展开 收起

克隆/下载
xiaoxiao 最后提交于 gitee
取消
提示: 由于 Git 不支持空文件夾,创建文件夹后会生成空的 .keep 文件
Loading...
README.md

整理qiandao.today可用的har

鸣谢

gxitm

AragonSnow

FellBan

Devil

github-h

liuqitech

呆贼

网站

Tips:

  1. 链接里最好使用raw.githubusercontent.com的模板地址,其他的链接没有测试过
  2. 修改日期格式 四位年-两位月-两位日 24小时:两位分:两位秒 ,例子:2020-05-15 07:03:47
网站 作者 链接 修改日期 备注/日志
联想签到延保 gxitm 联想签到延保(jointask).har 2020-05-15 04:37:17 account:账号,password:密码
参加连续10天签到任务
natfrp gxitm natfrp.har 2020-05-15 07:03:47 登录请求cookies:acw_tc,登录请求cookies:wordpress
url:https://openid.oxygen.moe/oauth/authorize/?response_type=code&client_id=ezEb7xY9ZHGwXMTtaUzdHcnKAGRnxUwphfMcIj9l
189天翼云盘 gxitm 189天翼云盘.har 2020-06-08 14:35:16 手机抓包,accessToken在链接里
url:http://api.cloud.189.cn/loginByOpen189AccessToken.action?accessToken=
国航APP AragonSnow airchina.har 2020-06-17 02:40:10 抓包,app杀台后不用输密码登录就行,这两个链接里有这个参数
前两个在
https://m.airchina.com.cn:9061/worklight/apps/services/api/AirChina/iphone/init
param在
https://m.airchina.com.cn:9061/worklight/apps/services/api/AirChina/iphone/query
paramters=到&结束
20200617更新:替换公共API地址,改用内置,需要配合aragonsonw/qiandao最新版使用
轻之国度 AragonSnow lightnovel 轻之国度.har 2020-05-20 15:43:45 cks 网页cookie
https://www.lightnovel.us/
summer-plus(原south-plus) AragonSnow
github-h
summer-plus(原south-plus).har 2020-08-10 16:00:00 pwd 密码
user 用户名
https://www.summer-plus.net/
精易论坛 FellBan 精易论坛.har 2020-05-21 09:23:54 cookie
https://bbs.125.la
腾讯视频VIP devil 腾讯视频VIP.har 2020-05-25 14:11:06 cookie
腾讯视频手机APP抓包cookie
WPS签到送会员 devil WPS.har 2020-05-25 14:06:23 WPS会员小程序抓包【sid】 https://zt.wps.cn/
柠檬PT签到 devil 柠檬PT签到.har 2020-05-25 14:06:23 cookie
https://leaguehd.com/attendance.php
ZodGame论坛 github-h ZodGame论坛.har 2020-06-25 19:20:44 cookie
https://zodgame.xyz
星空论坛seikuu github-h 星空论坛seikuu.har 2020-06-25 17:51:54 cookie
https://bbs2.seikuu.com/
网易云音乐-电脑 AND 手机 qiandao.today公共模板 网易云音乐-电脑 AND 手机.har 2020-06-25 21:12:03 cookie
https://music.163.com/
吾爱破解 github-h 吾爱破解.har 2020-06-09 10:59:44 cookie
https://www.52pojie.cn/
哥特动漫王国 github-h 哥特动漫王国.har 2020-07-27 13:20:16 cookie
https://www.gtloli.net/forum.php
萌出血动漫论坛 github-h 萌出血动漫论坛.har 2020-07-27 13:00:07 cookie
http://www.bbsmcx.com/forum.php
ArcTime字幕平台 github-h ArcTime字幕平台.har 2020-06-25 19:24:49 用户名+密码
http://m.arctime.cn/
柚坛社区 github-h 柚坛社区.har 2020-06-25 19:26:42 cookie
http://www.miuibbs.cn/
keylol(原SteamCN蒸汽论坛) github-h keylol(原SteamCN蒸汽论坛).har 2020-06-25 19:28:10 cookie
https://keylol.com/
机锋论坛 github-h 机锋论坛.har 2020-06-25 19:27:50 cookie
http://bbs.gfan.com/
HMOE俱乐部 github-h HMOE俱乐部.har 2020-07-27 15:00:21 用户名+密码
https://club.hmoe.club/
3DMGAME论坛 github-h 3DMGAME论坛.har 2020-06-25 20:58:13 cookie
https://bbs.3dmgame.com/
花火学院 github-h 花火学院.har 2020-06-25 19:19:35 cookie
https://www.say-huahuo.com/
QQNTR论坛 github-h QQNTR论坛.har 2020-06-25 19:28:02 cookie
https://iya.app/
CSDN-专业IT技术论坛 github-h CSDN-专业IT技术论坛.har 2020-06-25 19:24:22 用户名+cookie
此为签到模块,记得定期抽奖
https://www.csdn.net/
漫画补档 AragonSnow 漫画补档.har 2020-06-16 02:24:44 用户名+密码
此模板默认是没有设置安全问题,没测试过有安全问题的是否能登陆成功
https://www.manhuabudang.com/
华盟论坛 github-h 华盟论坛.har 2020-06-25 19:27:40 用户名+密码
https://bbs.77169.net/
什么值得买 liuqitech
呆贼
什么值得买.har 2020-06-28 14:12:00 网页版 cookie
https://www.smzdm.com/
Office-E5白嫖API调用 gxitm Office-E5白嫖API调用.har 2020-07-03 21:45:38 refresh_token+client_id+secret
根据相关教程获取到三个参数,并要保证被调用的10个API有权限
url:https://developer.microsoft.com/zh-CN/microsoft-365/dev-program
杉果游戏 github-h 杉果游戏.har 2020-07-04 15:00:21 用户名+密码
用户名为邮箱
https://ww.sonkwo.com/
天天爱阅读签到提醒 github-h 天天爱阅读签到提醒.har 2020-07-27 15:00:21 cookie+SCKEY(可选)
请导入后认真阅读模板说明
https://wap.cmread.com/
夏跡natsunokiseki github-h 夏跡natsunokiseki.har 2020-07-27 15:00:21 用户名+密码
每日登录
https://bbs.natsunokiseki.org/
联想智选app aragonsnow 联想智选app.har 2020-08-03 15:00:21 需要在京东智选APP 账号密码登录抓包
account 和 password 是app登录的账号密码, loginType,邮箱是email,手机号是msisdn
IMEI 和 baseinfo 在 抓包的 https://api.club.lenovo.cn/users/getSessionID 的header里
deviceId 在 抓包的 https://uss.lenovomm.com/authen/1.2/tgt/user/get 的post里

点评 ( 0 )

你可以在登录后,发表评论

1
https://gitee.com/qiandao-today/templates.git
git@gitee.com:qiandao-today/templates.git
qiandao-today
templates
templates
master
AragonSnow commented 4 years ago

@zasl https://github.com/coolsnowwolf/lede/issues/1760 参考这个最下面的试试,我没有你所说的设备,网络问题我无法帮你解决

zasl commented 4 years ago

@zasl coolsnowwolf/lede#1760 参考这个最下面的试试,我没有你所说的设备,网络问题我无法帮你解决

谢谢您 但是按照那个方法没有解决。

zasl commented 4 years ago

解决了解决了,谢谢您,按照那个方法解决了,我接受转发的选项选错了。

dz515704201 commented 4 years ago

解决了解决了,谢谢您,按照那个方法解决了,我接受转发的选项选错了。

我也遇到了同样的问题。点击公共模板就弹500。N1的docker环境,想详细了解你是怎么解决的,我是个小白

youzhadanke commented 3 years ago

求助 N1 armbian5.77+docker 签到6.24 下载安装还是好的, 今天重装了下, 安装签到就报错了,已经重装2遍了。 Traceback (most recent call last): File "/usr/src/app/web/handlers/subscribe.py", line 66, in get self.db.pubtpl.add(har) File "/usr/src/app/db/pubtpl.py", line 31, in add return self._insert(**insert) File "/usr/src/app/db/basedb.py", line 102, in _insert dbcur = self._execute(sql_query, values.values()) File "/usr/src/app/db/basedb.py", line 40, in _execute dbcur.execute(sql_query, values) OperationalError: table pubtpl has no column named commenturl 只要一打开公共模板就报这个错。