Category Archives: How to Fix

git clone appears fatal: index-pack failed problem solution

Problem 1.
When Git clone occurred, the following problems occurred:

fatal: The remote end hung up unexpectedly
fatal: early EOF
fatal: index-pack failed

2. Steps to solve the problem:

git config --add core.compression -1

3. New problems
The terminal executes the previous sentence and then continues to pull the code. The problem appears as follows:

error: RPC failed; curl 18 transfer closed with outstanding read data remaining 
fatal: The remote end hung up unexpectedly
fatal: early EOF
fatal: index-pack failed

4. Problem-solving steps
This error may be caused by insufficient git memory. Modify the configuration to continue terminal processing:

[core] 
packedGitLimit = 512m 
packedGitWindowSize = 512m 
[pack] 
deltaCacheSize = 2047m 
packSizeLimit = 2047m 
windowMemory = 2047m

The statements in the above modified terminal are similar to those of eg:
git config --global core.com compression 0
After the above steps of processing, you can pull down the code!
Reference:
Technology blog: https://stackoverflow.com/questions/21277806/fatal-early-eof-fatal-index-pack-failed technology blog: https://vnzmi.com/2017/01/08/git-early-eof-index-pack-failed/ technology blog: https://blog.csdn.net/qq_32791023/article/details/83622283?depth_1-utm_source=distribute.pc_relevant.none-task& utm_source=distribute.pc_relevant.none-task
The above content is only on behalf of the individual summary if there are mistakes, please also criticize correct, welcome to study together!

yum Times Error: rpmdb open failed solution

Yum-y install Telnet

error: rpmdb: BDB0113 Thread/process 29682/140047880361792 failed: BDB1507 Thread died in Berkeley DB library
error: db5 error(-30973) from dbenv->failchk: BDB0087 DB_RUNRECOVERY: Fatal error, run database recovery
error: cannot open Packages index using db5 -  (-30973)
error: cannot open Packages database in /var/lib/rpm
CRITICAL:yum.main:

Error: rpmdb open failed

Solutions:

cd /var/lib/rpm
rm -rf __db*
rpm --rebuilddb

Module parse failed:Unexpectedtoken (1:0)You may need an appropriate loader to handle this file type

And give me a lesson on the cruel reality, make robeletric before it has been a problem in the environment, the beginning the whole vue and waste on the environment for so long time
I will download the latest version of the node directly, so The Times running someone else’s project is wrong, then I did not think of to see if the environment problem, and a call to find on the net, then change a lot of things, and no
this time on the Internet to see says the latest version of the node with a lot of things are not compatible, 8. A few is relatively stable, then changed 8. A few of the node and project up
to come over for a few days, when I see some other module, when start to quote for the following error:

ERROR in ./demo03/src/app.vue
Module parse failed: /vue-tutorials/06.Router/demo03/src/app.vue Unexpected token (1:0)
You may need an appropriate loader to handle this file type.
SyntaxError: Unexpected token (1:0)
    at Parser.pp$4.raise (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:2221:15)
    at Parser.pp.unexpected (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:603:10)
    at Parser.pp$3.parseExprAtom (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1822:12)
    at Parser.pp$3.parseExprSubscripts (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1715:21)
    at Parser.pp$3.parseMaybeUnary (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1692:19)
    at Parser.pp$3.parseExprOps (/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1637:21)
    at Parser.pp$3.parseMaybeConditional (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1620:21)
    at Parser.pp$3.parseMaybeAssign (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1597:21)
    at Parser.pp$3.parseExpression (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:1573:21)
    at Parser.pp$1.parseStatement (/Downloads/vue-tutorials/06.Router/node_modules/webpack/node_modules/acorn/dist/acorn.js:727:47)
 @ ./demo03/src/main.js 9:23-43

>

>

>
>
>
>
>
>
>
>
>
> loaders in webpack.config.js changed to rules

module: {
    loaders: [
      {
        test: /\.vue$/,
        loader: 'vue'
      },
      {
        test: /\.js$/,
        loader: 'babel',
        exclude: /node_modules/
      },
      {
        test: /\.json$/,
        loader: 'json'
      },
      {
        test: /\.html$/,
        loader: 'vue-html'
      },
      {
        test: /\.(png|jpg|gif|svg)$/,
        loader: 'url',
        query: {
          limit: 10000,
          name: '[name].[ext]?[hash]'
        }
      }
    ]

webpack1.x -> Module. loaders changed the environment for module.rules
to start the project for the first time. Version conflicts seem to solve most problems!!

Job for apache2.service failed apache2 cannot be started

I planned to configure the virtual domain name in Apache before, so I did various operations on the configuration file of Apache. As a result, I don’t know why Apache always reported errors when it was restarted and started

Job for apache2.service failed because the control process exited with error code. See "systemctl status apache2.service"
 and "journalctl -xe" for details.

So I went to the apache2 error log /var/log/apache2 and couldn’t find a solution. So I unloaded Apache and reinstalled Apache and PHP

The next day, I encountered this problem again when I was tuning my configuration file. I used soft connection in both processes, so I wondered if there was something wrong with soft connection. I carefully checked what soft connection is

　Soft links under linux are similar to shortcuts under windows.

　　Examples.
　　ln -s httpd.conf confighttp

　　where httpd.conf is the source file , conffighttp is the link filename , its role is to edit when conffighttp
, which is actually a link edit httpd.conf.
　　If the soft link is to be removed.

　　confighttp-rm-rf.

　　This will only delete the conffighttp link file, but not the source file httpd.conf.

　　As opposed to soft links, and hard links.
　　Order to establish a hard link.
　　ln httpd.conf confighttp

　　A hard-linked file is the equivalent of a file stored in two locations, which effectively prevents accidental deletion.

Translated with www.DeepL.com/Translator (free version)

Then use the command to try to delete the previous soft connection, found success. Apache restore, problem resolved

linux startx problem

Problem description:
Today, I suddenly found that none of the users except root could start startx.
 

Fatal server error:
PAM authentication failed, cannot start X server.
        Perhaps you do not have console ownership?
When reporting a problem related to a server crash, please send
the full server output, not just the last messages.
Please report problems to [email protected].
giving up.
xinit:  No such file or directory (errno 2):  unable to connect to X server
xinit:  No such process (errno 3):  Server error.
Couldnt get a file descriptor referring to the console

 
Solution:
Check /var/run/console.lock contains the username, and /var/run/console/< user> To exist. When authenticating, pam_console compares the user name to the content of Console.lock, and if not, the authentication fails. /var/run/console/< user> Used to record the number of times the user logged in, and then the console.lock can be deleted after the user logged out.
 
Solutions:
I used the ordinary user of Oracle. I created a file named Oracle by running touch Oracle command under /var/run/console/, and then I could enter the graphical interface by re-running Startx.

Python Mac installs mysqlclient package error “error: command’clang’ failed with exit status 1” solution

Python Mac installation mysqlClient package error “Error: Command ‘clang’ failed with Exit Status 1

Today, I installed mysqlClient package on Mac, but it always gave me an error. I finally solved the problem for a long time, so I wrote down the solution

PIP installation command

pip install mysqlclient

Error message

Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (setup.py) ... error
  ERROR: Complete output from command /Users/xxx/virtualSpaces/flask_info/bin/python3.7 -u -c 'import setuptools, tokenize;__file__='"'"'/private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-install-vke00caa/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-wheel-voixgzfs --python-tag cp37:
  ERROR: running bdist_wheel
  running build
  running build_py
  creating build
  creating build/lib.macosx-10.14-x86_64-3.7
  copying _mysql_exceptions.py -> build/lib.macosx-10.14-x86_64-3.7
  creating build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/compat.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/connections.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/converters.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/cursors.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/release.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  copying MySQLdb/times.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
  creating build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/CR.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/ER.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  copying MySQLdb/constants/REFRESH.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
  running build_ext
  building '_mysql' extension
  creating build/temp.macosx-10.14-x86_64-3.7
  clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk/usr/include -I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk/System/Library/Frameworks/Tk.framework/Versions/8.5/Headers -Dversion_info=(1,3,13,'final',0) -D__version__=1.3.13 -I/usr/local/include -I/usr/local/Cellar/python/3.7.2/Frameworks/Python.framework/Versions/3.7/include/python3.7m -c _mysql.c -o build/temp.macosx-10.14-x86_64-3.7/_mysql.o
  _mysql.c:257:6: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                          s = PyUnicode_AsUTF8(item);
                            ^ ~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:287:6: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                          s = PyUnicode_AsUTF8(item);
                            ^ ~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:564:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                  _stringsuck(ca, value, ssl);
                  ^~~~~~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:553:16: note: expanded from macro '_stringsuck'
          if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                 ^~~~~~~~~~~~~~~~~~~~
  _mysql.c:565:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                  _stringsuck(capath, value, ssl);
                  ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:553:16: note: expanded from macro '_stringsuck'
          if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                 ^~~~~~~~~~~~~~~~~~~~
  _mysql.c:566:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                  _stringsuck(cert, value, ssl);
                  ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:553:16: note: expanded from macro '_stringsuck'
          if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                 ^~~~~~~~~~~~~~~~~~~~
  _mysql.c:567:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                  _stringsuck(key, value, ssl);
                  ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:553:16: note: expanded from macro '_stringsuck'
          if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                 ^~~~~~~~~~~~~~~~~~~~
  _mysql.c:568:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                  _stringsuck(cipher, value, ssl);
                  ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  _mysql.c:553:16: note: expanded from macro '_stringsuck'
          if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                 ^~~~~~~~~~~~~~~~~~~~
  _mysql.c:2530:8: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
          cname = PyUnicode_AsUTF8(name);
                ^ ~~~~~~~~~~~~~~~~~~~~~~
  8 warnings generated.
  clang -bundle -undefined dynamic_lookup build/temp.macosx-10.14-x86_64-3.7/_mysql.o -L/usr/local/Cellar/mysql-connector-c/6.1.11/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.14-x86_64-3.7/_mysql.cpython-37m-darwin.so
  ld: library not found for -lssl
  clang: error: linker command failed with exit code 1 (use -v to see invocation)
  error: command 'clang' failed with exit status 1
  ----------------------------------------
  ERROR: Failed building wheel for mysqlclient
  Running setup.py clean for mysqlclient
Failed to build mysqlclient
  Running setup.py install for mysqlclient ... error
    ERROR: Complete output from command /Users/xxx/virtualSpaces/flask_info/bin/python3.7 -u -c 'import setuptools, tokenize;__file__='"'"'/private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-install-vke00caa/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-record-nq6eazu6/install-record.txt --single-version-externally-managed --compile --install-headers /Users/xxx/virtualSpaces/flask_info/bin/../include/site/python3.7/mysqlclient:
    ERROR: running install
    running build
    running build_py
    creating build
    creating build/lib.macosx-10.14-x86_64-3.7
    copying _mysql_exceptions.py -> build/lib.macosx-10.14-x86_64-3.7
    creating build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/compat.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/connections.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/converters.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/cursors.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/release.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    copying MySQLdb/times.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb
    creating build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/__init__.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/CLIENT.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/CR.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/ER.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/FLAG.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    copying MySQLdb/constants/REFRESH.py -> build/lib.macosx-10.14-x86_64-3.7/MySQLdb/constants
    running build_ext
    building '_mysql' extension
    creating build/temp.macosx-10.14-x86_64-3.7
    clang -Wno-unused-result -Wsign-compare -Wunreachable-code -fno-common -dynamic -DNDEBUG -g -fwrapv -O3 -Wall -I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk/usr/include -I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk/System/Library/Frameworks/Tk.framework/Versions/8.5/Headers -Dversion_info=(1,3,13,'final',0) -D__version__=1.3.13 -I/usr/local/include -I/usr/local/Cellar/python/3.7.2/Frameworks/Python.framework/Versions/3.7/include/python3.7m -c _mysql.c -o build/temp.macosx-10.14-x86_64-3.7/_mysql.o
    _mysql.c:257:6: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                            s = PyUnicode_AsUTF8(item);
                              ^ ~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:287:6: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                            s = PyUnicode_AsUTF8(item);
                              ^ ~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:564:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                    _stringsuck(ca, value, ssl);
                    ^~~~~~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:553:16: note: expanded from macro '_stringsuck'
            if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                   ^~~~~~~~~~~~~~~~~~~~
    _mysql.c:565:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                    _stringsuck(capath, value, ssl);
                    ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:553:16: note: expanded from macro '_stringsuck'
            if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                   ^~~~~~~~~~~~~~~~~~~~
    _mysql.c:566:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                    _stringsuck(cert, value, ssl);
                    ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:553:16: note: expanded from macro '_stringsuck'
            if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                   ^~~~~~~~~~~~~~~~~~~~
    _mysql.c:567:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                    _stringsuck(key, value, ssl);
                    ^~~~~~~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:553:16: note: expanded from macro '_stringsuck'
            if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                   ^~~~~~~~~~~~~~~~~~~~
    _mysql.c:568:3: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
                    _stringsuck(cipher, value, ssl);
                    ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    _mysql.c:553:16: note: expanded from macro '_stringsuck'
            if(t){d=PyUnicode_AsUTF8(t);ssl_keepref[n_ssl_keepref++]=t;}\
                   ^~~~~~~~~~~~~~~~~~~~
    _mysql.c:2530:8: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
            cname = PyUnicode_AsUTF8(name);
                  ^ ~~~~~~~~~~~~~~~~~~~~~~
    8 warnings generated.
    clang -bundle -undefined dynamic_lookup build/temp.macosx-10.14-x86_64-3.7/_mysql.o -L/usr/local/Cellar/mysql-connector-c/6.1.11/lib -lmysqlclient -lssl -lcrypto -o build/lib.macosx-10.14-x86_64-3.7/_mysql.cpython-37m-darwin.so
    ld: library not found for -lssl
    clang: error: linker command failed with exit code 1 (use -v to see invocation)
    error: command 'clang' failed with exit status 1
    ----------------------------------------
ERROR: Command "/Users/xxx/virtualSpaces/flask_info/bin/python3.7 -u -c 'import setuptools, tokenize;__file__='"'"'/private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-install-vke00caa/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-record-nq6eazu6/install-record.txt --single-version-externally-managed --compile --install-headers /Users/xxx/virtualSpaces/flask_info/bin/../include/site/python3.7/mysqlclient" failed with error code 1 in /private/var/folders/jg/_5c6yf2x2b721htvf0h3vvlm0000gn/T/pip-install-vke00caa/mysqlclient/

The solution
Github gives an explanation of brew info openssl :
solves the problem by adding environment variables:

export LDFLAGS="-L/usr/local/opt/openssl/lib"
export CPPFLAGS="-I/usr/local/opt/openssl/include"

Then execute the installation command again

pip install mysqlclient

On my side, I installed the reset.txt file directly, but the difference is not significant.

Making related issue official solution:

reference: https://github.com/PyMySQL/mysqlclient-python/issues/169
https://www.jianshu.com/p/d4a349a7e7f5

[Handling Notes] Alternative reasons for Configuration system failed to initialize exception

Configuration System failed to initialize exception

There is a c# program on a computer, when performing an operation, it will always report the following error:

Baidu Yi found that the common reason in the market is the location of a specific node in the configuration file is wrong, or the configuration file is damaged, etc., and this program does not use the built-in configuration file scheme, but ini, so it does not apply to my problem. As a result of this program is not mine, so first reflator out source code (c # let I’ve struggled with this, on the one hand, afraid of his own program was against, on the other hand, thanks to the ~ to the others, NND), debug tracking under, found that was WebRequest. The Create () caused by abnormal, this method will most because of the incoming uri string format error caused illegal exception, this can cause the error was the first time to see (I want to Create methods internal is also caused by other classes, but did not explore), anyway, Since it is a non-mainstream exception raised by the built-in class, we try:
Reinstall the.net Framework
Doing weigh in hand.

posted on
The ticket is 2013-07-15
Ahdung reading (
…). Comments (
…).
The editor
collection

Reproduced in: https://www.cnblogs.com/ahdung/p/3191370.html

The underlying provider failed on open problem solving

The provider fails on open if you use Entity Framework6 and link to MS SqlServer, whereas The local test is ok. If you use IP access, The provider fails on open. If you look it up on The Internet, someone says that The connection string is wrong, whereas The connection string is wrong, why do I successfully update The database with add-Migration and update-database commands?Why I used localhost under IIS Express, so I continued searching and found something written by a foreigner
Url here, children’s shoes are interested can go to http://th2tran.blogspot.com/2009/06/underlying-provider-failed-on-open.html
Patriotic?Don’t like reading foreign languages?Okay, I’m going to hell.
The author generally mean, he also met this problem, so to get back and forth, back and forth finally found that the EF in the operation of the database to repeatedly links, disconnect the database, if the connection string is a Windows SERVICE, rather than using a user name and password, then try to access the database user is NT AUTHORITY \ NETWORK SERVICE, this fellow permission is not big enough to cause the login failed. At the end of the story, the author tries to add that account to SQL Server and gives permission, and that’s it.
I am lazy to do the problem of new account, so, directly change to use user name and password, test again, OK.
Meow, it’s really a matter of concatenating strings.

Solve the problem of Too many levels of symbolic links

Too many levels of symbolic links when using ln to create soft links

root@instance-vgiv786y:/opt/jdk1.8.0_181/bin# ln-s Java /usr/local/bin/ Java

change to:
root @instancevgiv786y :/opt/jdk1.8.0_181/bin# ln-s /opt/jdk1.8.0_181/bin/ Java /usr/local/bin/ Java
Obviously I’m installing the JDK, but why would I want to create this soft connection?Just add the environment variable at /etc/profile. However, when I connected this server as one of Jenkins’ nodes, I was surprised to find that Java could not be found. Obviously, I added the environment variable and it took effect. Jenkins had to look under various bin directory, so I created this soft connection.

ssh can connect but sftp can not connect

An error occurred when switching from the command line to SFTP using Xshell:
sftp subsystem request is rejected.
please make sure that sftp subsystem is properly installed in ssh server.
Here’s why:
[root@bogon ~]# tail /var/log/secure
Feb 23 16:29:48 localhost sshd[2989]: subsystem request for sftp
Feb 23 16:29:48 localhost sshd[2989]: subsystem request for sftp failed, subsystem not found
It can be seen that there is no directory for FTP – Server
Let’s look for the path address of FTP – Server:
[root@bogon ~]# locate sftp-server
/usr/libexec/openssh/sftp-server
/usr/share/man/man8/sftp-server.8.gz
Then open configuration:
[root@bogon ~]# vi /etc/ssh/sshd_config
will
# # override the default of no subsystems
Subsystem SFTP/usr/libexec/openssh/SFTP server. –
replace
# override the default of no subsystems
Subsystem SFTP/usr/libexec/openssh/SFTP server. –
Ok, load SSHD again.
[root@bogon ~]# /etc/init.d/sshd reload
Reconnect found OK.

DB-Lib error message 20002, severity 9

reprinted
Db-lib error message 20002, severity 9
complete error response: 20002, b ‘db-lib error message 20002, severity 9:\nAdaptive Server connection failed (i0.185.43.12:1433)\n ‘
Problem description:
In Python, using PSMSSQL to connect to a remote database, error reported. It is no problem to connect the remote machine through other machines, and it is also no problem to connect the remote machine with other tools (SQLCMD, Naticat, etc.) on my own machine, and locate the problem in the use of PyMSSQL library on this machine
Solutions:
Specify charset=”CP936″ at each pymssql.connect

conn = pymssql.connect(host='localhost',server='.',user='sa',password='XXXX', database='aaa',charset="CP936")