Category Archives: How to Fix

Local can link to the server database, upload jar package to the server will report an error

Question:

The problem encountered in the project is very strange. MySQL database is installed on CentOS, and the project is spring boot.

When the project is started locally, it is normal to connect to the server database, the local database client is normal to connect to the server database, and the server is normal to connect to the client database. When the project is deployed to the server, an exception is thrown.

A lot of misinformation..

The most important thing is:

java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)

reason:

I forgot to repack every time you run a project, idea will not help you repackage it. You need to do it yourself

Other questions can be referred to

https://www.cnblogs.com/secbro/p/12544158.html

Vue introduction path is correct, but it always reports an error: already included file name‘ ××ב differs from file name ‘ ××ב only in casing.

Vue import path ××× from ‘ ×××’ Error
the file name and address introduced are correct, but the error is still reported
already included file name‘ ×××’ differs from file name ‘ ×××’ only in casing.

At this time, we just need to remove the suffix Vue of the file name
solution

Solution 1: remove the suffix Vue of the file name

Solution 2: change the point in front of the path to@

Path

function

./

current file sibling directory

./

current file superior directory

@

when importing a module, you can use @ instead of/SRC directory to refer to the relative path

Navicat import local SQL file error “[MSG] finished – unsuccessfully | [err] 1046 – no database selected”

Error screen:

reason:

If you do not create a database with the same name and character set, you can directly right-click run SQL file on MySQL

 
solve:

1. Create a database with the same name and character set under MySQL

2. Under the newly created database, right-click run SQL file

3. Deselect the second item

4. Click start to import SQL file successfully

The problem has been solved. If the table has not been loaded, refresh the navicate or exit and reopen it

@Error in restcontroller annotation

If the @ restcontroller annotation can’t recognize the red, the reason is that there is no web dependency added to the POM file.

<dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-web</artifactId>
</dependency>

If a web dependency is added or an error is reported, it may be that there is no specified version number, so Maven can’t recognize


the solution is to enter the pom.xml file, click this location, find the dependency with the corresponding version number, replace the original dependency and import it again


Windows subsystem Ubuntu 18.04 solves SSH problem

Download 18.04 of Ubuntu in the Microsoft Store of windows, but there are some problems in SSH localhost. Refer to some information on the Internet and make the following summary

    first, you need to install sshd sudo apt get install openssh server and then modify/etc/SSH/sshd_ Two items under config file

      permitrootlogin yes permitrootlogin changed to yes passwordauthentication yes passwordauthentication changed to yes Restart SSH service /etc/init.d/ssh restart execute SSH localhost again input password should be able to SSH successfully

Linux use ls to view the file color is all white solution, and Linux file color introduction

1. The color of the file is white

method 1 :

1. Modify the ~ /. Bashrc file and add the following

alias ls='ls --color=auto'

2. Source to make the configuration changes take effect

source ~/.bashrc

method 2 :

1. Directly under the command line, give LS -- color = auto an alias LS

alias ls='ls --color=auto'

be careful:

In this way, every time you open a new terminal, you have to execute it again. It’s better to configure it in the ~ /. Bashrc file!

2 introduction of file color in Linux

1. Ls has more than three output colors, including the following,

White : denotes common file Blue : denotes directory Green : denotes executable file Red : denotes compressed file light blue : linked file red flashing : denotes a problem with the linked file yellow : denotes e> Device files gray : indicates other files

2. This is the default color agreed by Linux system. You can also modify it according to your own preference. In the environment variable $ls_ Just modify it on colors , and change it in ~ /. Bashrc
if you want to save it permanently

echo $LS_COLORS
rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:

Among them, before the semicolon is the background color of words , after the semicolon is the color of words

3 change the color of the user name

reference resources: https://blog.csdn.net/u013832707/article/details/53995085

Opencv opencvsharpexternal compilation and recording process

1-35013;- VS2019-36733;- OpenCvSharpExterior-283044;-

2’38468;’21547;’ 24405s;

D:\VS2019\opencvsharp-4.4.0.20200916\opencv files\opencv440 win x64\include\3rdparty\ippicv\ippicv win\icv\include

D:\VS2019\opencvsharp-4.4.0.20200916\\\opencv files\opencv440 wine x64\include

3-38745;- 24577;- 24211;- 38468;-

liblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibliblibzlibd.lib
opencv aruco440d.lib
opencv bgsegm440d.lib
opencv bioinspired440d.lib
opencv calib3d440d.lib
The opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening of the opening lib
opencv fuzzy440d.lib
opencv hfs440d.lib
opencv highgui440d.lib
opencv imgcodecs440d.lib
opencv imgproc440d.lib
open the line to descridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescridescriopen open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open up photo4440d.libopen open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open open 40d.lib
opencv quality 440d.lib
opencv reg440d.lib
opencv rgbd440d.lib
opencv saliency440d.lib
The opening of the opening of the structural opening of the superstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstsuperstremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremaremarema
opencv ts440d.lib
opencv video440d.lib
opencv videoio440d.lib
opencv videostab440d.lib
opencv xfeatures2d440d.lib
opencv ximgproc440d.lib
opencv xobjdetect440d.lib
opencv xphoto440d.lib

OpenCV 357933387454524577;24211s;

TypeError: connection.connect is not a function

Today, when I wrote node.js to operate the database, I encountered a typeerror: connection.connect is not a function when setting up the database connection. The following is the bug prompt, as shown in the figure

when I found this error, I immediately went to connection.connect, but I didn’t find anything wrong,
For this reason, I made a special effort to find the previous code and compare it. The following is the thinking at that time

later, I asked my friend to check the custom module
PS: after staring at it for more than ten minutes, I didn’t find the error. At this moment, I felt like a mentally retarded person

later, I had to check one by one, I found that my mistake was to write the return value of the function as an object….. Verification complete….. Retarded stone hammer…..

Change it to the following way

rerun

Quickly convert map to ordered array

    take out the key of map and put it into a slice s to sort and traverse, V: = range s, take the value: map [v] from the map and put it in the array in turn 0

    var err error
msgs = make([]*configModel.SysMailMsg, len(cacheMap))
keys := make([]int, len(cacheMap))

i := 0
for k, _ := range cacheMap {
   if keys[i], err = strconv.Atoi(k); err != nil {
      return nil, err
   }
   i++
}
sort.Ints(keys)
mi := 0
for _, v := range keys {
   var tmp configModel.SysMailMsg
   json.UnmarshalFromString(cacheMap[strconv.Itoa(v)], &tmp)
   msgs[mi] = &tmp
   mi++
}

Error in installing torch vision or pilot on Linux or Jetson nano: the headers or library files could not be found for JPEG

1 error analysis

When I install torch vision on Jetson nano, I report an error (torch vision depends on the pilot Library): the headers or library files could not be found for JPEG, , and the error reason is that pilot needs JPEG dependency in the process of installing from source code

writing src/Pillow.egg-info/PKG-INFO
writing dependency_links to src/Pillow.egg-info/dependency_links.txt
writing top-level names to src/Pillow.egg-info/top_level.txt
reading manifest file 'src/Pillow.egg-info/SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching '*.c'
warning: no files found matching '*.h'
warning: no files found matching '*.sh'
warning: no previously-included files found matching '.appveyor.yml'
warning: no previously-included files found matching '.coveragerc'
warning: no previously-included files found matching '.editorconfig'
warning: no previously-included files found matching '.readthedocs.yml'
warning: no previously-included files found matching 'codecov.yml'
warning: no previously-included files matching '.git*' found anywhere in distribution
warning: no previously-included files matching '*.pyc' found anywhere in distribution
warning: no previously-included files matching '*.so' found anywhere in distribution
no previously-included directories found matching '.ci'
writing manifest file 'src/Pillow.egg-info/SOURCES.txt'
running build_ext


The headers or library files could not be found for jpeg,
a required dependency when compiling Pillow from source.

2 error resolution

To install pilot, you need to rely on the source code: JPEG JPEG

sudo apt-get install libjpeg-dev zlib1g-dev