

the original: https://blog.csdn.net/u012878073/article/details/86511957
Solutions:
First you need to turn off the MySQL service and enter the command:
mysql> net stop MySQL
To start the local MySQL service in safe mode (note: launch the CMD window as an administrator), enter the command “MySQld — Defaults file=”G:\Install_Applications\ mysql.8.0.11 \ My.ini” –console –skip-grant — tables “to start the MySQL service, the cursor will stop without any output, which indicates that the MySQL service has been started.
Start the CMD window, and enter the command “mysql-uroot-p” to directly enter and log in to the mysql server, and then modify, you can enter the command:
(before 5.7.11) & GT; update user set password=password(“123456″) where user=”root”;
(5.7.11 or later) & GT; update user set authentication_string=password(“123456″) where user=”root”;
Here I’m using:
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘HuaZai12345! ‘;
The diagram below:

Now exit, enter the command “mysql-uroot-p” and enter the password just set, and you can log in to the mysql server normally, as shown in the figure below:

Ok, this is the solution for ERROR 1045 (28000): Access Denied for user ‘root’@’localhost’ (using password: NO). If you have any questions, please feel free to leave me a message.
: “learn together, make progress together”, I also hope that we will pay more attention to the IT community of CSND.
Reading CSV document with Pandas is an error that cannot be read because there is Chinese in the document. The error is due to the failure of the 'utf-8' codec to decode the 0 bit byte 0xc4

Solutions:
After reading the file, add encoding=’ GBK ‘,
such as: pddata=pd. Read_csv (' felipe.csv ',encoding=' GBK ')
Interested to continue to see the reason!
As you know, the default encoding we use in Python is UTF-8. For an introduction to coding, I recommend taking a look at Liao Da’s Python tutorial, “Strings and Coding.” Since UTF-8 format cannot correctly read CSV files with Chinese characters, it would be a good idea to select a format that can read Chinese characters.
So what format can read Chinese characters?We open the Python3 official website: find the section on standard characters. The diagram below:

So what format do you want to change?You can see that the third column of the table, Language, represents what Language the encoding supports. So let’s find out.
!
I’m not going to show you the table here, but if you’re interested, go to the website. Anyway, under my careful search, there is big5; Big5hkscs; Gb2312; GBK; Gb18030. Hz; The five formats iso2022_jp_2 may support Chinese. After my test, I found gb2312; GBK; Gb18030 can read CSV files with Chinese smoothly. (Since all three are ok, let’s have a good GBK.)

It works!
The following error occurred when ff visited a self-signed internal website
SSL received a weak ephemeral Diffie-Hellman key in Server Key Exchange handshake message. (Error code: ssl_error_weak_server_ephemeral_dh_key)
Tomcat is used by the server. The solution is to modify Tomcat /conf/server.xml, change the configuration, and add sslEnabledProtocols and Ciphers
<Connector protocol="org.apache.coyote.http11.Http11Protocol"
port="9443" minSpareThreads="5" maxSpareThreads="75"
enableLookups="true" disableUploadTimeout="true"
acceptCount="100" maxThreads="200"
scheme="https"
secure="true" SSLEnabled="true"
keystoreFile="/home/tomc/apache-tomcat-7.0.33/conf/server.keystore"
keystorePass="111111"
clientAuth="true"
sslEnabledProtocols="TLSv1,TLSv1.1,TLSv1.2"
ciphers="TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256, TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384,TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA,TLS_ECDHE_RSA_WITH_RC4_128_SHA,TLS_RSA_WITH_AES_128_CBC_SHA256,TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_CBC_SHA256, TLS_RSA_WITH_AES_256_CBC_SHA,SSL_RSA_WITH_RC4_128_SHA"
URIEncoding="UTF-8"/>
1. First step: modify the php.ini file: Open/Applications/MAMP/bin/PHP/{your PHP version}/conf/PHP ini file
find display_errors = Off (about 277 lines of location), to establish display_errors = On and find the error_reporting = E_ALL (about 270 lines of position, there are three kinds of value type, According to their own needs to set)

2. The second step is to set the Log errors option of mamp pro:
Main window-& gt; php-> Log errors selects to_screen so that the error prompts
on the browser to restart the service.
Windows SupDate on VISTA cannot be updated. Error code _800700C1 appears.
Refer to the foreign language and explain why:
32 bit SP1 Vista Cannot check for WindowsUpdate
800700c1 is not an valid Win32 Application not an valid Win32 Application.
0x3 IuctL.dll and iuengine-dll are not the correct version (usually due to caching problems)
iuctl.dll and iuengine.dll are not the correct version and are unable to be updated.
0x1 iuctL.dll is not the correct version
iuctl.dll is not the correct version and is unable to be updated.
The solution is as follows
Step 1: Reset IE
1) Click Start, click Run, type inetcpL.cpl, and then click OK to open network properties.
2) Click the General TAB, delete cookies, history, etc. (Run cleanMgr directly)
3) Click the “Security” TAB, select network, and click the default level button.
4) Click the “Privacy” TAB and click the default button.
5) Click the “Advanced” TAB, click the Default button, and uncheck the “Enable Three-party Browser Extension” check box.
Step 2: Register the XML component
1) Click Start, click Run, type CMD, and then click OK
2) In the command window, type the following command line (enter after each command) regsvr32 MSXML.dll Regsvr32 MSxml2.dll Regsvr32 MSxml3.dll
3) If “the specified module cannot be found” appears, download the relevant DLL file from the network or copy it to someone else’s computer, put it in C:\WINDOWS\ System32, and then try to run it in the command.
BTW: Regsvr32 is a command under Microsoft Windows operating system. It is used to register and de-register DLL and ActiveX files, so that they can be reflected in the login file. The default is the system directory (C:\ Windows and C:\ Windows \ System32).
Download center
http://www.ylmf.net/dll/
http://www.zhaodll.com/ (looking for DLL)
The home of http://article.pchome.net/content-929868.html (computer)
Step 3: Close all third-party firewall programs.
Please check whether you have the following anti-virus software or firewall installed, if so, please shut down temporarily.
Sygate Personal Firewall, Norton Internet Security Freedom Firewall, Zone Alarm Firewall.
Step 4: Close the Windows Firewall
1) Click Start, click Run, type Firewall. CPL, and then click OK.
2) Select close and click OK.
Step 5: If you have any of these installed, such as Covenant Eyes, Browser Blaster, and popup Blocker, shut them down or uninstall them to diagnose problems.
Step 6: Enter CMD as administrator and run “SFC/ScanNow”
If “Windows Resource Protection found corrupted files but could not fix some of them”, you can find the details of the scan through the Takeown command, and then manually fix the corrupted system files for specific diagnostic information. You can also insert a Vista repair CD into the drive and run “SFC/ScanNow” as an administrator
BTW: SFC (System File Checker) System File Checker is a Windows utility used to verify System File integrity and repair System files. If system files are found to be incorrect or missing, the program will ask you to insert the Windows installation DISC to fix or replace the incorrect files.
Step 7: WindowsUpdate automatic diagnosis and repair
http://support.microsoft.com/kb/971058
Step 8: Microsoft Telephony support services
TEL: 800-820-3800/800-820-3800/021-96081318.
Description of the bug
Technology stack
nginxuwsgibottle
Error details
Alarm robots often have the following warnings:
<27>1 2018-xx-xxT06:59:03.038Z 660ece0ebaad admin/admin 14 - - Socket Error: 104
<31>1 2018-xx-xxT06:59:03.038Z 660ece0ebaad admin/admin 14 - - Removing timeout for next heartbeat interval
<28>1 2018-xx-xxT06:59:03.039Z 660ece0ebaad admin/admin 14 - - Socket closed when connection was open
<31>1 2018-xx-xxT06:59:03.039Z 660ece0ebaad admin/admin 14 - - Added: {'callback': <bound method SelectConnection._on_connection_start of <pika.adapters.select_connection.SelectConnection object at 0x7f74752525d0>>, 'only': None, 'one_shot': True, 'arguments': None, 'calls': 1}
<28>1 2018-xx-xxT06:59:03.039Z 660ece0ebaad admin/admin 14 - - Disconnected from RabbitMQ at xx_host:5672 (0): Not specified
<31>1 2018-xx-xxT06:59:03.039Z 660ece0ebaad admin/admin 14 - - Processing 0:_on_connection_closed
<31>1 2018-xx-xxT06:59:03.040Z 660ece0ebaad admin/admin 14 - - Calling <bound method _CallbackResult.set_value_once of <pika.adapters.blocking_connection._CallbackResult object at 0x7f74752513f8>> for "0:_on_connection_closed"
The debug process
Determine the error location
If you have a log, it’s easy to do. First of all, look at where the log is typed.
Our own code
No.
Uwsgi code
root@660ece0ebaad:/# uwsgi –version
2.0.14
from github co down, no.
Python Library code
Execute in the container
>>> import sys
>>> sys.path
['', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages/PILcompat', '/usr/lib/python2.7/dist-packages/gtk-2.0']
Under these directories, grep is found in pika
root@660ece0ebaad:/usr/local/lib/python2.7# grep "Socket Error" -R .
Binary file ./dist-packages/pika/adapters/base_connection.pyc matches
./dist-packages/pika/adapters/base_connection.py: LOGGER.error("Fatal Socket Error: %r", error_value)
./dist-packages/pika/adapters/base_connection.py: LOGGER.error("Socket Error: %s", error_code)
Determine the PIKA version.
>>> import pika
>>> pika.__version__
'0.10.0'
Error determination logic
It can be seen from the code that the Socket Error is the Error code of errno, and it is determined that the meaning of the Error code is that RST is sent to the opposite end.
>>> import errno
>>> errno.errorcode[104]
'ECONNRESET'
Suspected rabbitmq server address error, an unlistened port will return RST, after verification found that it is not.
then suspected link timeout break without notifying the client, etc. Take a look at the RabbitMQ Server logs and find a large number of:
=ERROR REPORT==== 7-Dec-2018::20:43:18 ===
closing AMQP connection <0.9753.18> (172.17.0.19:27542 -> 192.168.44.112:5672):
missed heartbeats from client, timeout: 60s
--
=ERROR REPORT==== 7-Dec-2018::20:43:18 ===
closing AMQP connection <0.9768.18> (172.17.0.19:27544 -> 192.168.44.112:5672):
missed heartbeats from client, timeout: 60s
It is found that all the links between RabbitMQ Server and Admin Docker have been broken
root@xxxxxxx:/home/dingxinglong# netstat -nap | grep 5672 | grep "172.17.0.19"
So why does RabbitMQ Server kick out piKA’s links?Look at the PIKA code comment:
:param int heartbeat_interval: How often to send heartbeats.
Min between this value and server's proposal
will be used. Use 0 to deactivate heartbeats
and None to accept server's proposal.
We did not pass in the heartbeat interval, so in theory we should use the server default 60S. In fact, the client has never sent heartbeat packets.
verifies that a HeartbeatChecker object has been successfully created and a timer has been successfully created by printing, but the timer has never been called back.
follows through the code using blocking_connections, as seen in its add_timeout comment:
def add_timeout(self, deadline, callback_method):
"""Create a single-shot timer to fire after deadline seconds. Do not
confuse with Tornado's timeout where you pass in the time you want to
have your callback called. Only pass in the seconds until it's to be
called.
NOTE: the timer callbacks are dispatched only in the scope of
specially-designated methods: see
`BlockingConnection.process_data_events` and
`BlockingChannel.start_consuming`.
:param float deadline: The number of seconds to wait to call callback
:param callable callback_method: The callback method with the signature
callback_method()
The timer is triggered by process_data_Events and we are not calling it. So the client heartbeat is never triggered. Simply turn off heartbeat to solve this problem.
Specific trigger point
follows the code of basic_publish interface.
receives RST when sending, and finally prints socket_error in base_connection.py:452, _handle_error function.
def connect_mq():
mq_conf = xxxxx
connection = pika.BlockingConnection(
pika.ConnectionParameters(mq_conf['host'],
int(mq_conf['port']),
mq_conf['path'],
pika.PlainCredentials(mq_conf['user'],
mq_conf['pwd']),
heartbeat_interval=0))
channel = connection.channel()
channel.exchange_declare(exchange=xxxxx, type='direct', durable=True)
return channel
channel = connect_mq()
def notify_xxxxx():
global channel
def _publish(product):
channel.basic_publish(exchange=xxxxx,
routing_key='xxxxx',
body=json.dumps({'msg': 'xxxxx'}))
hint: the database has changed.
Use the last two steps in the “database has changed” loop until alter Database Open. No more error, “Database has changed”.
Up to this point, I will follow the original blogger’s operation. Now I need to close the command line and click computer — > Management – & gt; After the service, find the Oracle-related service and stop it, and then restart it. Oracle services are closed and started in a certain order, specific query can be online.
You can also refer to the following website content for setting, I did not try, roughly the same.
http://www.linuxidc.com/Linux/2016-04/130111.htm
Error: ENOENT: no such file or directory, uv_cwd Error: Cannot find module
new project was deployed to huawei cloud, which is a service provided by express. When it was started with pm2, an error was reported:

initially thought it was express installation error:
Error: Cannot find module 'express'
So multiple installations, various attempts, but it doesn’t work, or even reinstall Node.
later I found that it was fine to start directly with node, so it was fine when I started only one process with pm2. It’s so strange that I started ten projects and didn’t find this kind of problem.
And then I set my sights on
Error: ENOENT: no such file or directory, uv_cwd
The answer, at last, is simply to restart THE PM2
pm2 kill

and then start again:

and then it’s ok to leave work.