opencanary_web
opencanary_web copied to clipboard
p1r06u3
No response After enter the username and password to the web
First I can login the web successfuly 。But I can't access the web by same username , password and brower.In the meantime there is no changes in the server.Please help urgengtly.
The error is below:
[root@xxx ~]# tailf /usr/local/src/opencanary_web/logs/app.log
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context
conn = self._revalidate_connection()
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection
"Can't reconnect until invalid "
StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back
[SQL: SELECT User.id AS User_id, User.username AS User_username, User.password AS User_password, User.create_time AS User_create_time
FROM User
WHERE User.username = %(username_1)s AND User.password = %(password_1)s]
[parameters: [{}]]
500 POST /auth/ (127.0.0.1) 5.18ms
[root@xxx]# tailf /var/log/mysqld.log 2020-01-19T04:59:45.327767Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-01-19T04:59:45.328534Z 0 [Warning] CA certificate ca.pem is self signed. 2020-01-19T04:59:45.328598Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-01-19T04:59:45.329065Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2020-01-19T04:59:45.329110Z 0 [Note] IPv6 is available. 2020-01-19T04:59:45.329123Z 0 [Note] - '::' resolves to '::'; 2020-01-19T04:59:45.329142Z 0 [Note] Server socket created on IP: '::'. 2020-01-19T04:59:45.338876Z 0 [Note] Event Scheduler: Loaded 0 events 2020-01-19T04:59:45.339041Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.29' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
First check the nginx.Because nginx is revers proxy server to tornado web server. And then ensure your python version is 2.7 not 3.x. The backend web username and password is correct.
Dear pirogue, 密码是正确的，重启应用就好了，但是只有一个WEB界面可以登录，我登录后，其他WEB界面都不能登录了。感觉是session控制的问题 [root@xxx ~]# ps -ef|grep -i nginx root 7500 1 0 Jan15 ? 00:00:00 nginx: master process /usr/sbin/nginx -c /etc/nginx/nginx.conf nginx 7501 7500 0 Jan15 ? 00:00:00 nginx: worker process nginx 7502 7500 0 Jan15 ? 00:00:00 nginx: worker process nginx 7503 7500 0 Jan15 ? 00:00:00 nginx: worker process nginx 7504 7500 0 Jan15 ? 00:00:01 nginx: worker process nginx 7505 7500 0 Jan15 ? 00:00:00 nginx: worker process root 22360 22302 0 17:38 pts/1 00:00:00 grep --color=auto -i nginx [root@xxx ~]# ps aux |grep -i python root 1409 0.0 0.2 573928 19324 ? Ssl Jan15 0:26 /usr/bin/python2 -Es /usr/sbin/tuned -l -P root 1494 0.0 0.2 225664 17404 ? S Jan15 0:47 /usr/bin/python -s /usr/sbin/osad --pid-file /var/run/osad.pid root 6357 0.0 0.1 216004 11592 ? Ss 03:41 0:00 /usr/bin/python2 /usr/bin/denyhosts.py --foreground --unlock --config=/etc/denyhosts.conf root 19158 0.0 0.1 217772 10464 ? Ss 14:48 0:02 /usr/bin/python /usr/bin/supervisord root 19161 0.5 0.4 560148 38820 ? Sl 14:48 0:53 python /usr/local/src/opencanary_web/server.py --port=8000 root 19162 0.4 0.4 486716 39880 ? Sl 14:48 0:48 python /usr/local/src/opencanary_web/server.py --port=8001 root 19163 0.5 0.5 633908 41820 ? Sl 14:48 0:53 python /usr/local/src/opencanary_web/server.py --port=8002 root 19164 0.5 0.4 1076096 39976 ? Sl 14:48 0:58 python /usr/local/src/opencanary_web/server.py --port=8003 root 22364 0.0 0.0 112712 996 pts/1 S+ 17:38 0:00 grep --color=auto -i python
[root@XXX ~]# python -V Python 2.7.5
[root@XXX ~]# systemctl status nginx ◠nginx.service - nginx - high performance web server Loaded: loaded (/usr/lib/systemd/system/nginx.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2020-01-15 12:36:39 CST; 4 days ago Docs: http://nginx.org/en/docs/ Process: 7497 ExecStart=/usr/sbin/nginx -c /etc/nginx/nginx.conf (code=exited, status=0/SUCCESS) Main PID: 7500 (nginx) CGroup: /system.slice/nginx.service ├─7500 nginx: master process /usr/sbin/nginx -c /etc/nginx/nginx.conf ├─7501 nginx: worker process ├─7502 nginx: worker process ├─7503 nginx: worker process ├─7504 nginx: worker process └─7505 nginx: worker process
Jan 15 12:36:39 XXX systemd[1]: Starting nginx - high performance web server... Jan 15 12:36:39 XXX systemd[1]: Started nginx - high performance web server. 发件人: pirogue [mailto:[email protected]] 发送时间: 2020年1月19日 16:06 收件人: p1r06u3/opencanary_web [email protected] 抄送: xiaozhg/Xiao ZhiGang(IT) [email protected]; Author [email protected] 主题: Re: [p1r06u3/opencanary_web] No response After enter the username and password to the web (#45)
[External Email. Please do not open suspicious links or attachments.]
First check the nginx.Because nginx is revers proxy server to tornado web server. And then ensure your python version is 2.7 not 3.x. The backend web username and password is correct.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fp1r06u3%2Fopencanary_web%2Fissues%2F45%3Femail_source%3Dnotifications%26email_token%3DAJUUVCVHDIUVDTNSHJ46C7TQ6QCW3A5CNFSM4KIXHYOKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJKLT5Y%23issuecomment-575977975&data=02%7C01%7Cxiaozhg%40coscon.com%7Cdd3402cbc22143ced4fe08d79cb67016%7Cff308fd09421454ab8b34d36252ab3a3%7C0%7C0%7C637150179687985113&sdata=cZYIbLdr7BU9DEEgIqUxTtN10o5B%2FTIUsmJDa3YiRyk%3D&reserved=0, or unsubscribehttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAJUUVCUNCJAJMXGE2EHDSMDQ6QCW3ANCNFSM4KIXHYOA&data=02%7C01%7Cxiaozhg%40coscon.com%7Cdd3402cbc22143ced4fe08d79cb67016%7Cff308fd09421454ab8b34d36252ab3a3%7C0%7C0%7C637150179687985113&sdata=M8EbG0ynXhnuJU%2Fl%2FC%2BbRx4irhSvvg0B%2BiMQo%2Bpd8u4%3D&reserved=0.
For any cargo tracking and vessel schedule, please logon http://elines.coscoshipping.com
DISCLAIMER: This e-mail is confidential for COSCO SHIPPING Lines Co.,Ltd (COSCO SHIPPING Lines) and may also be privileged. Any unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. If you have received this e-mail in error, please delete it immediately, unread and notify the sender as soon as possible. COSCO SHIPPING Lines does not warrant this email is virus-free and is not liable for any losses or responsibilities arising from any virus being transmitted by this email. Internet communications are not secure and COSCO SHIPPING Lines does not accept legal responsibility for the contents of this message.