Czit notes

How to make Nextcloud 20 work with docker

przez kszyh | 2 stycznia 2021 - 20:21 |2 stycznia 2021 Internet

Fix group caching: /lib/private/Group/Database.php: https://github.com/nextcloud/server/issues/21885#issuecomment-749492759 Update and fix instance:

sudo docker exec --user www-data -it cloud php occ upgrade
sudo docker exec --user www-data -it cloud php occ maintenance:repair
sudo docker exec --user www-data -it cloud php occ db:add-missing-primary-keys
sudo docker exec --user www-data -it cloud php occ db:add-missing-indices
sudo docker exec --user www-data -it cloud php occ db:add-missing-columns
sudo docker exec --user www-data -it cloud php occ files:cleanup
sudo docker exec --user www-data -it cloud php occ maintenance:mode --off

sudo docker exec --user www-data -it cloud php occ upgrade

sudo docker exec --user www-data -it cloud php occ maintenance:repair

sudo docker exec --user www-data -it cloud php occ db:add-missing-primary-keys

sudo docker exec --user www-data -it cloud php occ db:add-missing-indices

sudo docker exec --user www-data -it cloud php occ db:add-missing-columns

sudo docker exec --user www-data -it cloud php occ files:cleanup

sudo docker exec --user www-data -it cloud php occ maintenance:mode --off

Putty does not show correct prompt using Powerline fonts

przez kszyh | 6 listopada 2020 - 08:41 |6 listopada 2020 Linux

Dodaj komentarz

https://github.com/arialdomartini/oh-my-git/issues/10#issuecomment-166732282

RDP – Remember windows position at multiple screens

przez kszyh | 17 czerwca 2020 - 09:14 |17 czerwca 2020 Bez kategorii, Windows

Dodaj komentarz

Remember_windows

OpenWRT and PPTP VPN

przez kszyh | 25 maja 2020 - 14:09 |24 sierpnia 2022 Bez kategorii

Dodaj komentarz

PPTP uses the GRE (Generic Routing Encapsulation) protocol to create a point-to-point tunnel. As a pure IP protocol, GRE uses only IP addresses, but without the port numbers given by a router with NAT, and without the delay in establishing a connection. In its basic configuration, OpenWrt Backfire is capable… Continue reading →

Firefox – Disable Address Bar Popup AKA URL bar zoom effect

przez kszyh | 3 maja 2020 - 13:16 |3 maja 2020 Bez kategorii

Dodaj komentarz

about:config

browser.urlbar.openViewOnFocus = false
browser.urlbar.update1 = false

1 2	browser.urlbar.openViewOnFocus = false browser.urlbar.update1 = false

Sentry – Docker

przez kszyh | 4 lutego 2020 - 14:40 |11 lutego 2020 Linux

Dodaj komentarz

snuba

FROM "getsentry/snuba:latest"

1	FROM "getsentry/snuba:latest"

snuba-consumer

FROM "getsentry/snuba:latest"
CMD ["consumer", "--auto-offset-reset=latest", "--max-batch-time-ms", "750"]

1 2	FROM "getsentry/snuba:latest" CMD ["consumer", "--auto-offset-reset=latest", "--max-batch-time-ms", "750"]

snuba-replacer

FROM "getsentry/snuba:latest"
CMD ["replacer", "--auto-offset-reset=latest", "--max-batch-size", "3"]

1 2	FROM "getsentry/snuba:latest" CMD ["replacer", "--auto-offset-reset=latest", "--max-batch-size", "3"]

snuba-cleanup

FROM "getsentry/snuba:latest"
RUN apt-get update && apt-get install -y cron && rm -r /var/lib/apt/lists/*
RUN echo "*/5 * * * * gosu snuba snuba cleanup --dry-run False" | crontab -
ENTRYPOINT ["/usr/sbin/cron"]
CMD ["-l", "-L", "15", "-f"]

FROM "getsentry/snuba:latest"

RUN apt-get update && apt-get install -y cron && rm -r /var/lib/apt/lists/*

RUN echo "*/5 * * * * gosu snuba snuba cleanup --dry-run False" | crontab -

ENTRYPOINT ["/usr/sbin/cron"]

CMD ["-l", "-L", "15", "-f"]

sentry-web

sudo SENTRY_IMAGE=getsentry/sentry:10.0.0 ./install.sh

1	sudo SENTRY_IMAGE=getsentry/sentry:10.0.0 ./install.sh

FROM "sentry-onpremise-local:latest"

1	FROM "sentry-onpremise-local:latest"

sentry-cron

FROM "sentry-onpremise-local:latest"
CMD ["run", "cron"]

1 2	FROM "sentry-onpremise-local:latest" CMD ["run", "cron"]

sentry-worker

FROM "sentry-onpremise-local:latest"
ENV PYTHONWARNINGS "ignore:Unverified HTTPS request"
CMD ["run", "worker"]

FROM "sentry-onpremise-local:latest"

ENV PYTHONWARNINGS "ignore:Unverified HTTPS request"

CMD ["run", "worker"]

sentry-forwarder

FROM "sentry-onpremise-local:latest"
CMD ["run", "post-process-forwarder", "--commit-batch-size", "1"]

1 2	FROM "sentry-onpremise-local:latest" CMD ["run", "post-process-forwarder", "--commit-batch-size", "1"]

NodeJS + Docker + Image Share

przez kszyh | 29 grudnia 2019 - 17:16 |29 grudnia 2019 Bez kategorii

Dodaj komentarz

Dockerfile

FROM node:12-slim

EXPOSE 9000
RUN mkdir /app
WORKDIR /app
RUN curl {URL_WITH_THE_APP} | tar -x && chown -R node:node /app
USER node
RUN npm i
CMD ["npm", "start"]

FROM node:12-slim

EXPOSE 9000

RUN mkdir /app

WORKDIR /app

RUN curl {URL_WITH_THE_APP} | tar -x && chown -R node:node /app

USER node

RUN npm i

CMD ["npm", "start"]

Build

sudo docker build -t {IMAGE} --pull --no-cache .

1	sudo docker build -t {IMAGE} --pull --no-cache .

Save image

sudo docker save {IMAGE:TAG} | gzip > {FILE.tar.gz}

1	sudo docker save {IMAGE:TAG} \| gzip > {FILE.tar.gz}

Load image

curl {IMAGE_URL} z -o {FILE.tar.gz}
sudo docker load -i {FILE.tar.gz}

1 2	curl {IMAGE_URL} z -o {FILE.tar.gz} sudo docker load -i {FILE.tar.gz}

Join MongoDB strings array

przez kszyh | 23 sierpnia 2019 - 14:18 |23 sierpnia 2019 Java Script, MongoDB

Dodaj komentarz

db.getCollection("abstracts").aggregate([
    {
        "$addFields": {
            "keywordsStr": {
                "$reduce": {
                    "input": "$keywords",
                    "initialValue": "",
                    "in": {
                        '$concat': [
                            '$$value',
                            {
                                '$cond': [
                                    { '$eq': ['$$value', ''] },
                                    '',
                                    ', '
                                ]
                            },
                            '$$this']
                    }
                }
            }
        },
    },
])

db.getCollection("abstracts").aggregate([

{

"$addFields": {

"keywordsStr": {

"$reduce": {

"input": "$keywords",

"initialValue": "",

"in": {

'$concat': [

'$$value',

{

'$cond': [

{ '$eq': ['$$value', ''] },

'',

', '

]

'$$this']

}

])

User LAST LOGIN stats

przez kszyh | 10 maja 2019 - 08:10 |10 maja 2019 Bez kategorii, MongoDB

Dodaj komentarz

Get datetime of last successful login of each user – from logs collection

// Requires official MongoShell 3.6+
db.getCollection("log").aggregate(
    [
        {
            $match: {
                "message": { "$eq": "USER_SUCCESS_LOGIN" }
            }
        },
        {
            $sort: { timestamp: -1 }
        },
        {
            $lookup: {
                "from": "users",
                "localField": "meta.user",
                "foreignField": "_id",
                "as": "user"
            }
        },
        {
            $match: {
                "user": { $ne: [] }
            }
        },
        {
            $unwind: { path: "$user" }
        },
        {
            $project: {
                "timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} ,
                "message": 1,
                "userid": "$user._id",
                "firstName": "$user.firstName",
                "lastName": "$user.lastName",
            }
        },
        {
            $group:
                {
                    "_id": "$userid",
                    "firstName": { $first: "$firstName" },
                    "lastName": { $first: "$lastName" },
                    "lastLogin": { $first: "$timestamp" }
                }
        }

    ],
    {
        "allowDiskUse": true
    }
);

// Requires official MongoShell 3.6+

db.getCollection("log").aggregate(

[

{

$match: {

"message": { "$eq": "USER_SUCCESS_LOGIN" }

}

{

$sort: { timestamp: -1 }

{

$lookup: {

"from": "users",

"localField": "meta.user",

"foreignField": "_id",

"as": "user"

}

{

$match: {

"user": { $ne: [] }

}

{

$unwind: { path: "$user" }

{

$project: {

"timestamp": { $dateToString: { format: "%Y-%m-%d %H:%M:%S:%L", date: "$timestamp" }} ,

"message": 1,

"userid": "$user._id",

"firstName": "$user.firstName",

"lastName": "$user.lastName",

}

{

$group:

{

"_id": "$userid",

"firstName": { $first: "$firstName" },

"lastName": { $first: "$lastName" },

"lastLogin": { $first: "$timestamp" }

}

{

"allowDiskUse": true

}

);

Count documents using Aggregation

przez kszyh | 21 sierpnia 2018 - 07:46 |21 sierpnia 2018 MongoDB, Skrypty

Dodaj komentarz

Counts log entries, with type equal 'CREATE’ , fetch patients data from another collection, remove empty documents (if patients was not found the field is empty array), count by provided user id.

var user_id = '5ad070640c9faddd41a4b665'

db.getCollection('log').aggregate([
{ $match: { message: {$eq: 'CREATE' } }},
{
 $lookup: {
     from: 'patients',
     localField: 'meta.patient',
     foreignField: '_id',
     as: 'patient'
     }   
},
{ $match: { patient: {$not: {$size: 0}} }},
{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},
    {
      $count: "created"
    }
])

var user_id = '5ad070640c9faddd41a4b665'

db.getCollection('log').aggregate([

{ $match: { message: {$eq: 'CREATE' } }},

{

$lookup: {

from: 'patients',

localField: 'meta.patient',

foreignField: '_id',

as: 'patient'

}

{ $match: { patient: {$not: {$size: 0}} }},

{ $match: {'meta.user': {$eq: ObjectId(user_id)}}},

{

$count: "created"

}

])

How to make Nextcloud 20 work with docker

Putty does not show correct prompt using Powerline fonts

RDP – Remember windows position at multiple screens

OpenWRT and PPTP VPN

Firefox – Disable Address Bar Popup AKA URL bar zoom effect

Sentry – Docker

NodeJS + Docker + Image Share

Join MongoDB strings array

User LAST LOGIN stats

Count documents using Aggregation

Ostatnie wpisy

Najnowsze komentarze

Kategorie

Meta