windows远程桌面提示 CredSSP加密Oracle修正 问题

win10远程连接server2008提示出现错误:
出现身份验证错误
要求的函数不受支持
这可能是由于 CredSSP加密Oracle修正
原因可能是win10更新以后出现的,版本大都是 Microsoft Windows [Version 10.0.17134.48] 这个版本。

解决方法一,修改组策略,但是家庭版win10还打不开组策略,可能有其它方法调出来,这里不用这个方法。
本地组策略:
计算机配置>管理模板>系统>凭据分配>加密Oracle修正
选择启用并选择易受攻击。

解决方法二,修改注册表。保存以下内容为 .reg 文件,导入注册表。

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Policies\System\CredSSP\Parameters]
"AllowEncryptionOracle"=dword:00000002

再次连接即可。

评论关闭

mysql打开普通日志

打开普通日志比较耗资源,所以一般只开启错误日志。

普通日志里可以看到sql语句。可以用来协助排错。

# 查看general_log开关状态
SHOW VARIABLES LIKE ‘%general%’;
会返回两条数据,一个是开关状态,一个是日志路径。

# 临时打开general_log日志
SET GLOBAL general_log=’ON’;

# 关闭
SET GLOBAL general_log=’OFF’;

评论关闭

python版本问题导致pip install出现证书错误问题

在python下执行pip install,报错:

$ ./pip install pyopenssl ndg-httpsclient pyasn1
Collecting pyopenssl
Could not fetch URL https://pypi.python.org/simple/pyopenssl/: There was a problem confirming the ssl certificate: [Errno 1] _ssl.c:499: error:1407742E:SSL routines:SSL23_GET_SERVER_H ELLO:tlsv1 alert protocol version – skipping
C:\Python27\lib\site-packages\pip-9.0.1-py2.7.egg\pip\_vendor\requests\packages\urllib3\util\ssl_.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name In dication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/security.html#snimissingwarning.
SNIMissingWarning
C:\Python27\lib\site-packages\pip-9.0.1-py2.7.egg\pip\_vendor\requests\packages\urllib3\util\ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not available. This preven ts urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https: //urllib3.readthedocs.io/en/latest/security.html#insecureplatformwarning.
InsecurePlatformWarning
Could not find a version that satisfies the requirement pyopenssl (from versions: )
No matching distribution found for pyopenssl
C:\Python27\lib\site-packages\pip-9.0.1-py2.7.egg\pip\_vendor\requests\packages\urllib3\util\ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not available. This preven ts urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https: //urllib3.readthedocs.io/en/latest/security.html#insecureplatformwarning.
InsecurePlatformWarning

alading@venus MINGW64 /c/Python27/Scripts

最后查原因是python版本低了,老版本中的tls 1.0版本ssl不再支持,需要更新python2.7到最后一个版本。这里更新到python 2.7.14 解决。
$ ./pip.exe install redis
Collecting redis
Downloading https://files.pythonhosted.org/packages/3b/f6/7a76333cf0b9251ecf49efff635015171843d9b977e4ffcf59f9c4428052/redis-2.10.6-py2.py3-none-any.whl (64kB)
Installing collected packages: redis
Successfully installed redis-2.10.6
You are using pip version 9.0.1, however version 10.0.1 is available.
You should consider upgrading via the ‘python -m pip install –upgrade pip’ command.

 

评论关闭