Select the appropriate numbers separated by commas and/or spaces, or leave input
blank to select all options shown (Enter 'c' to cancel): 5
Obtaining a new certificate
Performing the following challenges:
http-01 challenge for sub3.example.com
Waiting for verification...
Cleaning up challenges
Deploying Certificate to VirtualHost /etc/nginx/sites-enabled/example.com
Please choose whether or not to redirect HTTP traffic to HTTPS, removing HTTP access.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1: No redirect - Make no further changes to the webserver configuration.
2: Redirect - Make all requests redirect to secure HTTPS access. Choose this for
new sites, or if you're confident your site works on HTTPS. You can undo this
change by editing your web server's configuration.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Select the appropriate number [1-2] then [enter] (press 'c' to cancel):
Web サーバーの設定に対して HTTP → HTTPS へのリダイレクトを行うか聞かれますが、実は設定ファイル上ではすでにリダイレクト設定はしておいたので、今回は「1」（リダイレクトなし）とします。
Select the appropriate number [1-2] then [enter] (press 'c' to cancel): 1
Future versions of Certbot will automatically configure the webserver so that all requests redirect to secure HTTPS access. You can control this behavior and disable this warning with the --redirect and --no-redirect flags.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Congratulations! You have successfully enabled https://sub3.example.com
You should test your configuration at:
https://www.ssllabs.com/ssltest/analyze.html?d=sub3.example.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
IMPORTANT NOTES:
- Congratulations! Your certificate and chain have been saved at:
/etc/letsencrypt/live/sub3.example.com/fullchain.pem
Your key file has been saved at:
/etc/letsencrypt/live/sub3.example.com/privkey.pem
Your cert will expire on 2023-01-18. To obtain a new or tweaked
version of this certificate in the future, simply run certbot again
with the "certonly" option. To non-interactively renew *all* of
your certificates, run "certbot renew"
- If you like Certbot, please consider supporting our work by:
Donating to ISRG / Let's Encrypt: https://letsencrypt.org/donate
Donating to EFF: https://eff.org/donate-le
# views.py
class ClassList(LoginRequiredMixin, generic.ListView):
model = ClassMaster
template_name = 'class_list.html'
class ClubList(LoginRequiredMixin, generic.ListView):
model = ClubMaster
template_name = 'club_list.html'
# forms.py
from django.contrib.auth.models import User
from django.contrib.auth.forms import AuthenticationForm
class LoginForm(AuthenticationForm):
class Meta:
model = User
fields = ['username', 'password']
"If called via POST with user submitted credentials, it tries to log the user in. If login is successful, the view redirects to the URL specified in next. If next isn’t provided, it redirects to settings.LOGIN_REDIRECT_URL (which defaults to /accounts/profile/). If login isn’t successful, it redisplays the login form."
初回は下記のようなメッセージが表示され、yes か no を求められますが、yes と入力して Enter で大丈夫です。
The authenticity of host 's123.xrea.com (123.45.6.78)' can't be established. ECDSA key fingerprint is XXXXXX:XxXXXxxXX+XXXXXXXXxxxxxxXXxXxxxxXXxXXXX. Are you sure you want to continue connecting (yes/no/[fingerprint])?
yes そして Enterすると下記のメッセージが表示され、続けてパスワードを求められます。
Warning: Permanently added 's123.xrea.com,123.45.6.78' (ECDSA) to the list of known hosts.
初回は下記のようなメッセージが表示され、yes か no を求められますが、yes と入力して Enter で大丈夫です。
The authenticity of host 's12.valueserver.jp (123.4.567.89)' can't be established. ECDSA key fingerprint is XXXXXX:XxXXXxxXX+XXXXXXXXxxxxxxXXxXxxxxXXxXXXX. Are you sure you want to continue connecting (yes/no/[fingerprint])?
yes そして Enter すると下記のメッセージが表示され、続けてパスワードを求められます。
Warning: Permanently added 's12.valueserver.jp,123.45.6.78' (ECDSA) to the list of known hosts.
初回は下記のようなメッセージが表示され、yes か no を求められますが、yes と入力して Enter で大丈夫です。
The authenticity of host '[ssh.lolipop.jp]:2222 ([133.130.35.108]:2222)' can't be established. ECDSA key fingerprint is XXXXXX:XxXXXxxXX+XXXXXXXXxxxxxxXXxXxxxxXXxXXXX. Are you sure you want to continue connecting (yes/no/[fingerprint])?
yes そして Enterすると下記のメッセージが表示され、続けてパスワードを求められます。
Warning: Permanently added '[ssh.lolipop.jp]:2222,[133.130.35.108]:2222' (RSA) to the list of known hosts.
>>> exit()
$ pip install mysqlclient
Collecting mysqlclient
Using cached mysqlclient-2.1.0.tar.gz (87 kB)
ERROR: Command errored out with exit status 1:
command: /home/users/0/bambina.jp-アカウント/python3-venv/bin/python3 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-zoshgtdz/mysqlclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-zoshgtdz/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-l1irr5km
cwd: /tmp/pip-install-zoshgtdz/mysqlclient/
Complete output (15 lines):
/bin/sh: mysql_config: コマンドが見つかりません
/bin/sh: mariadb_config: コマンドが見つかりません
/bin/sh: mysql_config: コマンドが見つかりません
mysql_config --version
mariadb_config --version
mysql_config --libs
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/tmp/pip-install-zoshgtdz/mysqlclient/setup.py", line 15, in <module>
metadata, options = get_config()
File "/tmp/pip-install-zoshgtdz/mysqlclient/setup_posix.py", line 70, in get_config
libs = mysql_config("libs")
File "/tmp/pip-install-zoshgtdz/mysqlclient/setup_posix.py", line 31, in mysql_config
raise OSError("{} not found".format(_mysql_config_path))
OSError: mysql_config not found
----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
WARNING: You are using pip version 20.1.1; however, version 21.3.1 is available.
You should consider upgrading via the '/home/users/0/bambina.jp-アカウント/python3-venv/bin/python3 -m pip install --upgrade pip' command.
(scraping_venv) % python
Python 3.9.0 (default, Jan 3 2021, 10:29:59)
[GCC 4.2.1 20070831 patched [FreeBSD]] on freebsd9
Type "help", "copyright", "credits" or "license" for more information.
>>>
今回はテーブル毎のファイルでダウンロードした方が便利な気がするので「Output」のセクションで「Export tables as separate files」にチェックを入れます。
「Object creation options」のセクションで「Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement」と「IF NOT EXISTS (less efficient as indexes will be generated during table creation)」にチェックを入れます。
を使ってスクレイピングをする方法をまとめます。
」以上のプランを想定しています。
