9 KrisRoofe




TA的排名 2w+

MongoDB: ERROR: child process failed, exited with error number

参考:SO: MongoDB: ERROR: child process failed, exited with error numberCheck if the mongod is running with pgrep mongod or ps -aef | grep mongod or systemctl status mongodStop and restart it to check if the issue goneif you start mongod with mongod -f /et

2020-07-30 14:42:15

SSH passwordless login(免密登陆)

linux,windows 都一样。下面以windows为例:生成密钥对$ ssh-keygenGenerating public/private rsa key pair.Enter file in which to save the key (/c/Users/user/.ssh/id_rsa): ./id_rsa_ss1Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identifi

2020-07-24 17:03:42

Why is this rsync connection unexpectedly closed on Windows?

参考:SO: Why is this rsync connection unexpectedly closed on Windows?rsync.exe -avz -e 'ssh -p 22' user@example.com:/home/user/testfileuser@example.com's password:rsync: connection unexpectedly closed (0 bytes received so far) [sender]rsync error: error

2020-07-24 14:34:02

nginx: [emerg] “proxy_pass“ cannot have URI part in location given by regular expression, or inside

参考SO: nginx ‘proxy_pass’ cannot have URI part in location?使用下面的配置会出现上面的问题location ~ ^/web/(project1|project2|project3)/$ { proxy_pass https://example.com/h5/;}原因:nginx cannot process your desired URI part in the proxy_pass directivebecause you’re

2020-07-24 09:49:56

nginx 路径替换

下面使用一个简单的例子来说明路径替换,配置了两个路径指向同一个项目。location ^~ /internal/project/ {allow;allow;allow;deny all;proxy_pass https://example.com/external/project/;}location ~ /external/ {root /var/www/html;index index.html;}Pr

2020-07-24 09:40:17

auditd Unregistered Authentication Agent for unix-process

sudo systemctl restart auditd> Failed to restart auditd.service: Operation refused, unit> auditd.service may be requested by dependency only (it is configured> to refuse manual start/stop). See system logs and 'systemctl status> auditd.ser

2020-07-08 20:56:18

pam_succeed_if(sshd:auth): requirement “uid 」= 1000“ not met by user “root“

有下面两种情形:cat /etc/shadow | grep root 查看root用户是否被锁定。如果出现 root:!!$6$CG (注意其中的!!)则说明root用户被锁定,不能登陆。解决方案:passwd -u root 解除用户锁定。查看PAM配置文件/etc/pam.d/login, /etc/pam.d/sshd /etc/pam.d/system-auth中是否有 auth required pam_succeed_if.so uid >= 1000;修改或者注释该

2020-07-07 15:34:13

Centos setting password for user, but still can‘t log in on it

Refer to : Centos setting password for user, but still can’t log in on itUse another to check the log by with sudo tail -f /var/log/secureIt shows something like this,Jul 4 16:24:06 iz2ze86eplnjdk8exdjimjz sshd[17288]: pam_tally2(sshd:auth): user lv (1

2020-07-07 15:19:54

Error response from daemon: OCI runtime create failed

Refer to StackOverflow:docker: Error response from daemon: OCI runtime create failed: unable to retrieve OCI runtime errorTo check the issue by run docker in the debug mode.1: stop docker with systemctl stop docker2: run docker in debug mode dockerd -

2020-07-07 15:18:23


select max(record_id),record_name,user_id from sc_records group by user_id order by null.SQL Show most recent record in GROUP BY?Retrieving the last record in each group - MySQL

2020-06-06 08:20:35


使用变量来计算累加和set @csum := 0;select id, count, (@csum := @csum + count) as cumulative_sumfrom YourTableorder by id;参考 Create a Cumulative Sum Column in MySQL

2020-05-07 10:50:29

nginx: [emerg] a duplicate default server for

StackOverflow: nginx: [emerg] a duplicate default server forGithub: Error: duplicate listen options for [::]:443 #5550

2020-04-22 16:20:31


Scaffolding generally refers to a quickly set up skeleton for an app. It’s not rails-only since other platforms have it as well. It’s also not generally meant to be a “final” system;简单描述为:脚手架是用来快速搭建一...

2020-04-14 18:30:04


设置IFS为\n(IFS=$'\n'; ffmpeg -i $file) 处理文件名为my video.mp4的视频文件。FFmpeg Error ( no such file or directory error)Bash and filenames with spacesLooping through files with spaces in the names? [duplic...

2020-04-11 10:07:35

pread() read only xxxx of yyyy

Refer to pread() read only xxxx of yyyy通常是读取正在修改的文件造成的。

2020-03-04 19:27:41

nginx 访问频率限制 (limit_req_zone) 及白名单配置


2020-03-03 10:08:01


在本地项目中导出裸仓库 git clone --bare ./ ../project_name.git上传到服务器上pscp -r ../project_name.git user_name@ip_or_hostname:/git_path/在本地仓库中设置服务端的git地址git remote add origin user_name@ip_or_hostname:/git_path/pr...

2019-12-26 15:28:09

elasticsearch 7 批量删除文档。

参考 StackOverflow 问题Delete all documents from index/type without deleting type 的 回答curl -XPOST 'localhost:9200/materials/_delete_by_query?conflicts=proceed&pretty' -H 'Content-Type: application/j...

2019-12-12 20:31:29

com.mysql.jdbc.Driver not loaded 或者 com.mariadb.jdbc.Driver not loaded

logstash Error: com.mariadb.jdbc.Driver not loadedCannot load driver class: com.mysql.jdbc.Driver Spring

2019-12-06 18:20:54

使用 SQL 进行排名搜索

参考 Ranked search with SQL计算term的出现次数。SELECT SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4)) AS Occurrences以次数进行排序。SELECT SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4) ...

2019-11-09 17:19:11


勋章 我的勋章
  • GitHub
  • 持之以恒
  • 勤写标兵Lv1