sueboy: 14 6月 2020

vs code vscode remote ssh Error: EACCES: permission denied

vscode remote ssh Error: EACCES: permission denied

https://github.com/microsoft/vscode/issues/48659

1. make sure that sudo -u newuser -i works in a regular ssh session without requesting a password

2. remove "-o RemoteCommand=none" and "bash" from extension.js like so


sed -i s/"-o RemoteCommand=none"/""/ ~/.vscode/extensions/ms-vscode-remote.remote-ssh-*/out/extension.js

sed -i s/"bash"/""/ ~/.vscode/extensions/ms-vscode-remote.remote-ssh-*/out/extension.js

3. create an ssh config entry with a RemoteCommand like this one:


Host pi-for-newuser
  Hostname pi
  User pi
  RemoteCommand sudo -u newuser -i

Get Problem:

mesg: ttyname failed: Inappropriate ioctl for device

https://unix.stackexchange.com/questions/48527/ssh-inside-ssh-fails-with-stdin-is-not-a-tty


RequestTTY Yes
RemoteCommand sudo -i

firebase functinos cookie only __session

https://firebase.google.com/docs/hosting/manage-cache?hl=zh-cn#using_cookies

将 Firebase 托管与 Cloud Functions 或 Cloud Run 搭配使用时，Cookie 通常会从传入的请求中剥离出来。这是实现高效的 CDN 缓存行为所必需的。只有特别指定的 __session Cookie 可以传入应用执行过程中。 __session Cookie（如果存在）会自动成为缓存键的一部分，也就是说，使用不同 Cookie 的两个用户绝不会收到彼此的已缓存响应。只有在您的应用根据用户授权提供不同的内容时，您才能使用 __session Cookie。

firebase functions cold start use Express.js node.js get problem

System on firebase functions always have problems that code start.

https://medium.com/@siriwatknp/cold-start-workaround-in-firebase-cloud-functions-8e9db1426bd3

google office

https://firebase.google.com/docs/functions/networking


const http = require('http');
const functions = require('firebase-functions');

// Setting the `keepAlive` option to `true` keeps
// connections open between function invocations
const agent = new http.Agent({keepAlive: true});

exports.function = functions.https.onRequest((request, response) => {
    req = http.request({
        host: '',
        port: 80,
        path: '',
        method: 'GET',
        agent: agent, // Holds the connection open after the first invocation
    }, res => {
        let rawData = '';
        res.setEncoding('utf8');
        res.on('data', chunk => { rawData += chunk; });
...

Two line let me confused. Not only me.


const agent = new http.Agent({keepAlive: true}); 

agent: agent, // Holds the connection open after the first invocation

Some guy same me.

Get same problem.

https://stackoverflow.com/questions/56912118/how-can-i-maintain-persist-a-cloud-functions-connection-using-expressjs

Success??

https://stackoverflow.com/questions/55425015/how-to-keep-alive-dialogflow-firebase-function-to-avoid-new-connection-time-wast

Thanks Max. However I found the answer to this problem from the same link I posted above (i.e. firebase.google.com/docs/functions/networking). Just adding two lines of code solved the problem. Now response is quite prompt. I added following lines: 1. const agent = new http.Agent({keepAlive: true}); 2. agent: agent, – Vipul Sisodia Apr 2 '19 at 19:04

See Express.js

https://nodejs.org/dist/latest-v10.x/docs/api/http.html#http_new_agent_options

Not thing can Try.

Other way

https://medium.com/@onufrienkos/keep-alive-connection-on-inter-service-http-requests-3f2de73ffa1

https://stackoverflow.com/questions/60667847/unable-to-verify-leaf-signature-from-request-with-firebase-functions-node-js-wit

index.js


require('https').globalAgent.keepAlive = true;

const functions = require('firebase-functions');
const express = require('express');
const app = express();

...

exports.api = functions.runWith(runtimeOpts).https.onRequest(app);


require('https').globalAgent.keepAlive = true;

Try by yourself.

新增說明文字

https://www.youtube.com/watch?v=MgLc95nBeNE

mysql json mariadb

最近寫mysql 發現原來 mysql 在json內容時，也有支援一些操作

https://www.cnblogs.com/chuanzhang053/p/9139624.html

https://medium.com/micheh/%E5%9C%A8-mysql-%E4%BD%BF%E7%94%A8-json-5796a65701ad

再加上 mysql 還有另一個譆能虛疑欄位 GENERATED ALWAYS AS

http://blog.changyy.org/2017/09/mysql-json-mysql-57.html

基本上可以把json內的某欄位值當成 virutal colume, 直接輸出覺得這樣可以玩出很多變化

https://www.cnblogs.com/waterystone/p/5626098.html

EExcel 丞燕快速查詢2