我的动态

2023/09/19 11:26:47

squid的策略匹配注意点

目前的问题是配置了如下squid.conf，但是对目的端口dst_port的限制不生效。

acl src_net src all
acl dst_port port 80
acl dst_domain dstdomain .baidu.com
acl dst_net dst all
acl CONNECT method CONNECT

http_access allow src_net
http_access allow dst_port   # 这条不生效
http_access allow CONNECT dst_port
http_access allow dst_domain
http_access allow dst_net
http_access allow localhost manager
http_access deny manager
http_access deny all

经过一番折腾，发现如下方法是生效的，即将端口的控制修改为deny方式，且将其前置，这样不但可以加速访问控制选择速度，还能减轻squid的负载。

acl src_net src all
acl dst_port port 80
acl dst_domain dstdomain .baidu.com
acl dst_net dst all
acl CONNECT method CONNECT

http_access deny !dst_port   # 这样生效
http_access allow src_net
#http_access allow dst_port   # 这条不生效
http_access allow CONNECT dst_port
http_access allow dst_domain
http_access allow dst_net
http_access allow localhost manager
http_access deny manager
http_access deny all

2023/07/19 15:58:32

headless cms

strapi
tina cms

2023/02/07 17:45:28

python37已经安装的包列表

Package                         Version
------------------------------- -----------
aiofiles                        0.8.0
altair                          4.2.0
altgraph                        0.17
amqp                            5.1.1
aniso8601                       7.0.0
anyio                           3.0.1
apache-libcloud                 3.4.1
appdirs                         1.4.4
APScheduler                     3.7.0
argon2-cffi                     21.3.0
argon2-cffi-bindings            21.2.0
Arpeggio                        1.10.2
arrow                           1.1.1
asgiref                         3.5.2
astor                           0.8.1
astroid                         2.4.2
astunparse                      1.6.3
async-exit-stack                1.0.1
async-generator                 1.10
atomicwrites                    1.4.0
attrs                           19.3.0
autopep8                        1.5.4
Babel                           2.9.1
backcall                        0.2.0
base58                          2.1.1
batinfo                         0.4.2
bcrypt                          3.1.7
beautifulsoup4                  4.9.3
bernhard                        0.2.6
billiard                        3.6.4.0
bleach                          4.1.0
blinker                         1.4
boto3                           1.26.5
botocore                        1.29.5
bottle                          0.12.21
bs4                             0.0.1
CacheControl                    0.12.6
cached-property                 1.5.2
cachetools                      4.2.2
cachy                           0.3.0
celery                          5.2.7
certifi                         2020.6.20
cffi                            1.14.1
chardet                         3.0.4
charset-normalizer              2.0.12
chevron                         0.14.0
cleo                            0.8.1
cli-helpers                     2.2.1
click                           7.1.2
click-didyoumean                0.3.0
click-plugins                   1.1.1
click-repl                      0.2.0
clikit                          0.6.2
cloudpickle                     2.0.0
colorama                        0.4.3
colored                         1.4.3
colorlog                        4.6.2
commonmark                      0.9.1
comtypes                        1.1.7
ConfigArgParse                  1.2.3
configobj                       5.0.6
crashtest                       0.3.1
cryptography                    36.0.2
cssselect                       1.1.0
cutecharts                      1.2.0
cycler                          0.11.0
dearpygui                       1.6.2
debugpy                         1.5.1
decorator                       5.1.1
defusedxml                      0.7.1
Deprecated                      1.2.13
deta                            0.9
dill                            0.3.4
distlib                         0.3.1
Django                          3.1
djangorestframework             3.13.1
dnspython                       2.1.0
docker                          5.0.3
docutils                        0.18.1
doit                            0.34.2
ecdsa                           0.14.1
email-validator                 1.1.2
emmett                          2.4.5
entrypoints                     0.4
et-xmlfile                      1.1.0
eventlet                        0.33.1
Fabric3                         1.14.post1
fake-useragent                  0.1.11
Faker                           13.13.0
fastapi                         0.61.0
feedgenerator                   2.0.0
filelock                        3.0.12
filetype                        1.0.7
Flask                           1.1.2
Flask-Admin                     1.6.0
Flask-BasicAuth                 0.2.0
Flask-Cors                      3.0.10
fonttools                       4.29.1
future                          0.18.2
gevent                          21.1.2
geventhttpclient                1.4.4
ghp-import                      2.0.2
gitdb                           4.0.9
GitPython                       3.1.27
Glances                         3.2.7
graphene                        2.1.8
graphql-core                    2.3.2
graphql-relay                   2.0.1
greenlet                        1.1.0
grequests                       0.6.0
grpcio                          1.42.0
h11                             0.12.0
h2                              4.0.0
har2case                        0.3.1
hpack                           4.0.0
hprose                          1.4.3
html5lib                        1.1
httpcore                        0.13.6
httpie                          3.0.2
httprunner                      2.3.0
httptools                       0.4.0
httpx                           0.18.2
hyperframe                      6.0.1
idna                            2.10
ifaddr                          0.2.0
importlib-metadata              4.11.1
importlib-resources             5.4.0
iniconfig                       1.0.1
installer                       0.3.0
invoke                          1.4.1
IPy                             1.1
ipykernel                       6.9.1
ipython                         7.32.0
ipython-genutils                0.2.0
ipywidgets                      7.6.5
isort                           4.3.21
itsdangerous                    2.0.1
jedi                            0.18.1
jenkinsapi                      0.3.11
Jinja2                          3.0.1
jmespath                        1.0.1
jsonpath                        0.82
jsonschema                      4.4.0
jupyter-client                  7.1.2
jupyter-core                    4.9.2
jupyterlab-pygments             0.1.2
jupyterlab-widgets              1.0.2
jwt                             1.3.1
keyring                         21.8.0
kiwisolver                      1.3.2
kombu                           5.2.4
lazy-object-proxy               1.4.3
limits                          1.6
litecli                         1.9.0
lockfile                        0.12.2
locust                          1.6.0
loguru                          0.5.3
lxml                            4.6.1
Mako                            1.2.0
Markdown                        3.3.6
MarkupSafe                      2.0.1
matplotlib                      3.5.1
matplotlib-inline               0.1.3
mccabe                          0.6.1
mergedeep                       1.3.4
mistune                         0.8.4
mkdocs                          1.2.3
mkdocs-material                 8.2.1
mkdocs-material-extensions      1.0.3
more-itertools                  8.4.0
msgpack                         1.0.0
multi-key-dict                  2.0.3
multidict                       6.0.2
natsort                         8.1.0
nbclient                        0.5.12
nbconvert                       6.4.2
nbformat                        5.1.3
nest-asyncio                    1.5.4
netifaces                       0.11.0
Nikola                          8.2.0
nose                            1.3.7
notebook                        6.4.8
numpy                           1.19.1
openpyxl                        3.0.7
orjson                          3.4.7
packaging                       20.5
pandas                          1.3.4
pandocfilters                   1.5.0
parameterized                   0.7.0
paramiko                        2.7.1
parse                           1.18.0
parso                           0.8.3
parver                          0.3.1
passlib                         1.7.4
pastel                          0.2.1
pbkdf2                          1.3
pbr                             5.4.5
pdm                             1.12.8
pdm-pep517                      0.10.2
peewee                          3.14.4
pefile                          2021.5.24
pelican                         4.7.1
pendulum                        2.1.2
pep517                          0.12.0
pexpect                         4.8.0
pickleshare                     0.7.5
piexif                          1.1.3
Pillow                          7.2.0
pip                             22.0.3
pkginfo                         1.7.1
platformdirs                    2.5.0
playwright                      1.10.0
pluggy                          0.13.1
ply                             3.11
plyer                           2.0.0
poetry                          1.1.7
poetry-core                     1.0.3
prettytable                     2.4.0
prometheus-client               0.13.1
promise                         2.3
prompt-toolkit                  3.0.28
protobuf                        3.19.1
psutil                          5.7.2
PTable                          0.9.2
ptyprocess                      0.7.0
pulumi                          3.33.2
pulumi-openstack                3.8.0
py                              1.9.0
py2exe                          0.10.4.0
py3nvml                         0.2.7
pyaes                           1.6.1
pyarrow                         7.0.0
pyasn1                          0.4.8
pycodestyle                     2.6.0
pycparser                       2.20
pycryptodomex                   3.15.0
pyDAL                           17.3
pydantic                        1.6.1
pydeck                          0.7.1
pyecharts                       1.9.1
pyee                            8.0.1
pyflowchart                     0.1.4
pygal                           3.0.0
Pygments                        2.11.2
pygtrie                         2.4.2
pyinstaller                     4.3
pyinstaller-hooks-contrib       2021.2
pylev                           1.4.0
pylint                          2.5.3
pymdown-extensions              9.2
pymdstat                        0.4.2
Pympler                         1.0.1
PyMySQL                         1.0.2
PyNaCl                          1.4.0
pynput                          1.7.3
pyparsing                       2.4.7
pypiserver                      1.4.2
pypiwin32                       223
Pypubsub                        4.0.3
pyquery                         1.4.1
pyrsistent                      0.18.1
PyRSS2Gen                       1.1
pyshorteners                    1.0.1
PySimpleGUI                     4.43.0
pySMART.smartx                  0.3.10
pysmi                           0.3.4
pysnmp                          4.4.12
PySocks                         1.7.1
pytest                          6.2.4
pytest-asyncio                  0.15.1
pytest-base-url                 1.4.2
pytest-html                     3.1.1
pytest-metadata                 1.11.0
pytest-mock                     3.5.0
pytest-playwright               0.1.0
pytest-rerunfailures            9.1.1
python-crontab                  2.5.1
python-dateutil                 2.8.1
python-dotenv                   0.19.2
python-jenkins                  1.7.0
python-jose                     3.2.0
python-multipart                0.0.5
python-rapidjson                1.6
pythonfinder                    1.2.9
pytils                          0.4.1
pyttsx3                         2.90
pytz                            2022.1
pytzdata                        2020.1
pyvmomi                         7.0.3
pywebio                         1.3.3
pywin32                         227
pywin32-ctypes                  0.2.0
pywinpty                        2.0.5
PyYAML                          5.4.1
pyyaml_env_tag                  0.1
pyzmq                           19.0.2
redis                           3.5.3
renoir                          1.5.3
requests                        2.24.0
requests-html                   0.10.0
requests-toolbelt               0.9.1
resolvelib                      0.8.1
rfc3986                         1.5.0
rich                            11.1.0
robotframework                  3.1.2
robotframework-pythonlibcore    2.2.1
robotframework-requests         0.7.0
robotframework-ride             1.7.4.2
robotframework-selenium2library 3.0.0
robotframework-seleniumlibrary  5.1.3
roundrobin                      0.0.2
rsa                             4.7
Rx                              1.6.1
s3transfer                      0.6.0
sanic                           22.6.0
sanic-routing                   22.3.0
scandir                         1.10.0
schedule                        1.1.0
seldom                          1.9.0
selection                       0.0.14
selenium                        3.141.0
semver                          2.13.0
Send2Trash                      1.8.0
setuptools                      41.2.0
severus                         1.1.1
shellingham                     1.4.0
simplejson                      3.17.2
six                             1.15.0
slowapi                         0.1.5
smmap                           5.0.0
sniffio                         1.2.0
soupsieve                       2.0.1
sparklines                      0.4.2
speedtest-cli                   2.1.3
SQLAlchemy                      1.4.20
sqlparse                        0.3.1
starlette                       0.13.6
streamlit                       1.7.0
tabulate                        0.8.10
termcolor                       1.1.0
terminado                       0.13.3
testpath                        0.6.0
toml                            0.10.1
tomli                           2.0.1
tomlkit                         0.9.2
toolz                           0.11.2
tornado                         6.1
tqdm                            4.51.0
traitlets                       5.1.1
typed-ast                       1.4.1
typer                           0.3.2
typing_extensions               4.2.0
tzlocal                         2.1
ua-parser                       0.10.0
ujson                           3.2.0
Unidecode                       1.3.2
unittest-xml-reporting          3.0.4
urllib3                         1.25.10
user-agent                      0.1.10
user-agents                     2.2.0
uvicorn                         0.16.0
validators                      0.18.2
vine                            5.0.0
virtualenv                      20.4.6
w3lib                           1.22.0
walrus                          0.9.0
watchdog                        2.1.6
wcwidth                         0.2.5
webencodings                    0.5.1
weblib                          0.1.30
websocket-client                1.3.3
websockets                      10.2
Werkzeug                        2.0.1
wget                            3.2
wheel                           0.36.2
widgetsnbextension              3.5.2
wifi                            0.3.8
win32-setctime                  1.0.3
windows-curses                  2.3.0
wrapt                           1.12.1
WTForms                         3.0.1
wxPython                        4.0.7.post2
xmltodict                       0.13.0
xpinyin                         0.7.6
Yapsy                           1.12.2
zeroconf                        0.38.7
zipp                            3.1.0
zope.event                      4.4
zope.interface                  5.1.0

2022/12/30 20:21:47

qq.2170853509

2022/11/22 20:45:07

highlightjs的demo

https://highlightjs.org/static/demo/

2022/11/17 20:22:58

谷歌加速

https://greenhubtx.ga/

2022/11/17 17:36:13

Win查看文件夹大小的工具

https://www.folder-size-explorer.com/download-folder-size-explorer.shtml

2022/11/16 14:39:12

在线调试代码

https://replit.com/languages/go

2022/10/27 16:50:53

python2快速启动ipv6服务器

python -c "import socket,SocketServer,CGIHTTPServer;SocketServer.TCPServer.address_family=socket.AF_INET6;CGIHTTPServer.test()" 8080

2022/10/19 16:55:51

查询表的创建时间和更新时间

查询所有表

SELECT table_name,create_time FROM  information_schema.TABLES;

查询指定表

SELECT table_name,create_time FROM information_schema.TABLES WHERE table_name = 'table_name';