From 60d3abc6ecdc21b4ab921d34a55b4af48690f55a Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Thu, 11 Mar 2021 18:53:14 +0100 Subject: Rewrote the whole website to get rid on a heavy theme --- content/en/blog/miscellaneous/_index.md | 5 - content/en/blog/miscellaneous/bacula-bareos.md | 38 ------- content/en/blog/miscellaneous/bash-tcp-client.md | 15 --- .../en/blog/miscellaneous/boot-from-initramfs.md | 16 --- content/en/blog/miscellaneous/building-rpms.md | 29 ----- .../blog/miscellaneous/clean-old-centos-kernels.md | 11 -- .../miscellaneous/debug-disk-usage-postgresql.md | 14 --- content/en/blog/miscellaneous/etc-update-alpine.md | 38 ------- content/en/blog/miscellaneous/fstab.md | 9 -- content/en/blog/miscellaneous/i3dropdown.md | 32 ------ content/en/blog/miscellaneous/libreoffice.md | 9 -- .../en/blog/miscellaneous/link-deleted-inode.md | 10 -- content/en/blog/miscellaneous/make.md | 10 -- content/en/blog/miscellaneous/mencoder.md | 21 ---- content/en/blog/miscellaneous/mssql-centos-7.md | 29 ----- .../my-postgresql-role-cannot-login.md | 12 --- content/en/blog/miscellaneous/nginx-ldap.md | 25 ----- .../en/blog/miscellaneous/osm-overlay-example.md | 19 ---- content/en/blog/miscellaneous/pleroma.md | 117 --------------------- .../en/blog/miscellaneous/postgresql-read-only.md | 17 --- .../en/blog/miscellaneous/postgresql-reassign.md | 18 ---- content/en/blog/miscellaneous/pulseaudio.md | 11 -- .../purge-postfix-queue-based-content.md | 13 --- content/en/blog/miscellaneous/qmail.md | 21 ---- content/en/blog/miscellaneous/rocketchat.md | 18 ---- .../miscellaneous/screen-cannot-open-terminal.md | 17 --- content/en/blog/miscellaneous/seti-at-home.md | 18 ---- .../en/blog/miscellaneous/sqlite-pretty-print.md | 16 --- content/en/blog/miscellaneous/switching-to-hugo.md | 58 ---------- 29 files changed, 666 deletions(-) delete mode 100644 content/en/blog/miscellaneous/_index.md delete mode 100644 content/en/blog/miscellaneous/bacula-bareos.md delete mode 100644 content/en/blog/miscellaneous/bash-tcp-client.md delete mode 100644 content/en/blog/miscellaneous/boot-from-initramfs.md delete mode 100644 content/en/blog/miscellaneous/building-rpms.md delete mode 100644 content/en/blog/miscellaneous/clean-old-centos-kernels.md delete mode 100644 content/en/blog/miscellaneous/debug-disk-usage-postgresql.md delete mode 100644 content/en/blog/miscellaneous/etc-update-alpine.md delete mode 100644 content/en/blog/miscellaneous/fstab.md delete mode 100644 content/en/blog/miscellaneous/i3dropdown.md delete mode 100644 content/en/blog/miscellaneous/libreoffice.md delete mode 100644 content/en/blog/miscellaneous/link-deleted-inode.md delete mode 100644 content/en/blog/miscellaneous/make.md delete mode 100644 content/en/blog/miscellaneous/mencoder.md delete mode 100644 content/en/blog/miscellaneous/mssql-centos-7.md delete mode 100644 content/en/blog/miscellaneous/my-postgresql-role-cannot-login.md delete mode 100644 content/en/blog/miscellaneous/nginx-ldap.md delete mode 100644 content/en/blog/miscellaneous/osm-overlay-example.md delete mode 100644 content/en/blog/miscellaneous/pleroma.md delete mode 100644 content/en/blog/miscellaneous/postgresql-read-only.md delete mode 100644 content/en/blog/miscellaneous/postgresql-reassign.md delete mode 100644 content/en/blog/miscellaneous/pulseaudio.md delete mode 100644 content/en/blog/miscellaneous/purge-postfix-queue-based-content.md delete mode 100644 content/en/blog/miscellaneous/qmail.md delete mode 100644 content/en/blog/miscellaneous/rocketchat.md delete mode 100644 content/en/blog/miscellaneous/screen-cannot-open-terminal.md delete mode 100644 content/en/blog/miscellaneous/seti-at-home.md delete mode 100644 content/en/blog/miscellaneous/sqlite-pretty-print.md delete mode 100644 content/en/blog/miscellaneous/switching-to-hugo.md (limited to 'content/en/blog/miscellaneous') diff --git a/content/en/blog/miscellaneous/_index.md b/content/en/blog/miscellaneous/_index.md deleted file mode 100644 index 806622d..0000000 --- a/content/en/blog/miscellaneous/_index.md +++ /dev/null @@ -1,5 +0,0 @@ ---- -title: "Miscellaneous" -linkTitle: "Miscellaneous" -weight: 40 ---- diff --git a/content/en/blog/miscellaneous/bacula-bareos.md b/content/en/blog/miscellaneous/bacula-bareos.md deleted file mode 100644 index a5fd0be..0000000 --- a/content/en/blog/miscellaneous/bacula-bareos.md +++ /dev/null @@ -1,38 +0,0 @@ ---- -title: "Some bacula/bareos commands" -linkTitle: "Some bacula/bareos commands" -date: 2018-01-10 -description: > - Some bacula/bareos commands ---- - -Bacula is a backup software, bareos is a fork of it. Here are some tips and solutions to specific problems. - -## Adjust an existing volume for pool configuration changes - -In bconsole, run the following commands and follow the prompts : -{{< highlight sh >}} -update pool from resource -update all volumes in pool -{{< /highlight >}} - -## Using bextract - -On the sd you need to have a valid device name with the path to your tape, then run : -{{< highlight sh >}} -bextract -V - -{{< /highlight >}} - -## Integer out of range sql error - -If you get an sql error `integer out of range` for an insert query in the catalog, check the id sequence for the table which had the error. For -example with the basefiles table : -{{< highlight sql >}} -select nextval('basefiles_baseid_seq'); -{{< /highlight >}} - -You can then fix it with : -{{< highlight sql >}} -alter table BaseFiles alter column baseid set data type bigint; -{{< /highlight >}} diff --git a/content/en/blog/miscellaneous/bash-tcp-client.md b/content/en/blog/miscellaneous/bash-tcp-client.md deleted file mode 100644 index f10f22b..0000000 --- a/content/en/blog/miscellaneous/bash-tcp-client.md +++ /dev/null @@ -1,15 +0,0 @@ ---- -title: "Bash tcp client" -linkTitle: "Bash tcp client" -date: 2018-03-21 -description: > - Bash tcp client ---- - -There are somea fun toys in bash. I would not rely on it for a production script, but here is one such things : - -{{< highlight sh >}} -exec 5<>/dev/tcp/10.1.0.254/8080 -bash$ echo -e "GET / HTTP/1.0\n" >&5 -bash$ cat <&5 -{{< /highlight >}} diff --git a/content/en/blog/miscellaneous/boot-from-initramfs.md b/content/en/blog/miscellaneous/boot-from-initramfs.md deleted file mode 100644 index 3d5c55e..0000000 --- a/content/en/blog/miscellaneous/boot-from-initramfs.md +++ /dev/null @@ -1,16 +0,0 @@ ---- -title: "Boot from initramfs shell" -linkTitle: "Boot from initramfs shell" -date: 2014-01-24 -description: > - Boot from initramfs shell ---- - -I had to finish booting from an initramfs shell, here is how I used `switch_root` to do so : - -{{< highlight sh >}} -lvm vgscan -lvm vgchange -ay vg -mount -t ext4 /dev/mapper/vg-root /root -exec switch_root -c /dev/console /root /sbin/init -{{< /highlight >}} diff --git a/content/en/blog/miscellaneous/building-rpms.md b/content/en/blog/miscellaneous/building-rpms.md deleted file mode 100644 index 99667eb..0000000 --- a/content/en/blog/miscellaneous/building-rpms.md +++ /dev/null @@ -1,29 +0,0 @@ ---- -title: "Building rpm packages" -linkTitle: "Building rpm packages" -date: 2016-02-22 -description: > - Building rpm packages ---- - -Here is how to build locally an rpm package. Tested at the time on a centos 7. - -## Setup your environment - -First of all, you have to use a non-root account. - - - Create the necessary directories : `mkdir -p ~/rpmbuild/{BUILD,RPMS,S{OURCE,PEC,RPM}S}` - - Tell rpmbuild where to build by adding the following in your `.rpmmacros` file : `echo -e “%_topdir\t$HOME/rpmbuild” » ~/.rpmmacros` - -## Building package - -There are several ways to build a rpm, depending on what kind of stuff you have to deal with. - -### Building from a tar.gz archive containing a .spec file - -Run the following on you .tar.gz archive : `rpmbuild -tb memcached-1.4.0.tar.gz`. When the building process ends, you will find your package in a `$HOME/rpmbuild/RPMS/x86_64/` like directory, depending on your architecture. - -### Building from a spec file - - - `rpmbuild -v -bb ./contrib/redhat/collectd.spec` - - If you are missing some dependencies : `rpmbuild -v -bb ./contrib/redhat/collectd.spec 2>&1 |awk '/is needed/ {print $1;}'|xargs yum install -y` diff --git a/content/en/blog/miscellaneous/clean-old-centos-kernels.md b/content/en/blog/miscellaneous/clean-old-centos-kernels.md deleted file mode 100644 index eb49269..0000000 --- a/content/en/blog/miscellaneous/clean-old-centos-kernels.md +++ /dev/null @@ -1,11 +0,0 @@ ---- -title: "Clean old centos kernels" -linkTitle: "Clean old centos kernels" -date: 2016-02-03 -description: > - Clean old centos kernels ---- - -There is a setting in `/etc/yum.conf` that does exactly that : `installonly_limit=`. The value of this setting is the number of older kernels that are kept when a new kernel is installed by yum. If the number of installed kernels becomes greater than this, the oldest one gets removed at the same time a new one is installed. - -This cleaning can also be done manually with a command that belongs to the yum-utils package : `package-cleanup –oldkernels –count=2` diff --git a/content/en/blog/miscellaneous/debug-disk-usage-postgresql.md b/content/en/blog/miscellaneous/debug-disk-usage-postgresql.md deleted file mode 100644 index 827d69f..0000000 --- a/content/en/blog/miscellaneous/debug-disk-usage-postgresql.md +++ /dev/null @@ -1,14 +0,0 @@ ---- -title: "Investigate postgresql disk usage" -linkTitle: "Investigate postgresql disk usage" -date: 2015-11-24 -description: > - Investigate postgresql disk usage ---- - -## How to debug disk occupation in postgresql - -- get a database oid number from `ncdu` in `/var/lib/postgresql` -- reconcile oid number and db name with : `select oid,datname from pg_database where oid=18595;` -- Then in database : `select table_name,pg_relation_size(quote_ident(table_name)) from information_schema.tables where table_schema = 'public' order by 2;` - diff --git a/content/en/blog/miscellaneous/etc-update-alpine.md b/content/en/blog/miscellaneous/etc-update-alpine.md deleted file mode 100644 index dbc0824..0000000 --- a/content/en/blog/miscellaneous/etc-update-alpine.md +++ /dev/null @@ -1,38 +0,0 @@ ---- -title: "etc-update script for alpine linux" -linkTitle: "etc-update script for alpine linux" -date: 2019-04-02 -description: > - etc-update script for alpine linux ---- - -Alpine linux doesn't seem to have a tool to merge pending configuration changes, so I wrote one : -{{< highlight sh >}} -#!/bin/sh -set -eu - -for new_file in $(find /etc -iname '*.apk-new'); do - current_file=${new_file%.apk-new} - echo "===== New config file version for $current_file =====" - diff ${current_file} ${new_file} || true - while true; do - echo "===== (r)eplace file with update? (d)iscard update? (m)erge files? (i)gnore =====" - PS2="k/d/m/i? " - read choice - case ${choice} in - r) - mv ${new_file} ${current_file} - break;; - d) - rm -f ${new_file} - break;; - m) - vimdiff ${new_file} ${current_file} - break;; - i) - break;; - esac - done -done -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/fstab.md b/content/en/blog/miscellaneous/fstab.md deleted file mode 100644 index 3b7cded..0000000 --- a/content/en/blog/miscellaneous/fstab.md +++ /dev/null @@ -1,9 +0,0 @@ ---- -title: "Use spaces in fstab" -linkTitle: "Use spaces in fstab" -date: 2011-09-29 -description: > - How to use spaces in a folder name in fstab ---- - -Here is how to use spaces in a folder name in fstab : you put `\040` where you want a space. diff --git a/content/en/blog/miscellaneous/i3dropdown.md b/content/en/blog/miscellaneous/i3dropdown.md deleted file mode 100644 index 52262ec..0000000 --- a/content/en/blog/miscellaneous/i3dropdown.md +++ /dev/null @@ -1,32 +0,0 @@ ---- -title: "i3dropdown" -linkTitle: "i3dropdown" -date: 2020-01-23 -description: > - i3dropdown ---- - -i3dropdown is a tool to make any X application drop down from the top of the screen, in the famous quake console style back in the day. - -## Compilation - -First of all, you have get i3dropdown and compile it. It does not have any dependencies so it is really easy : -{{< highlight sh >}} -git clone https://gitlab.com/exrok/i3dropdown -cd i3dropdown -make -cp build/i3dropdown ~/bin/ -{{< /highlight >}} - -## i3 configuration - -Here is a working example of the pavucontrol app, a volume mixer I use : -{{< highlight conf >}} -exec --no-startup-id i3 --get-socketpath > /tmp/i3wm-socket-path -for_window [instance="^pavucontrol"] floating enable -bindsym Mod4+shift+p exec /home/julien/bin/i3dropdown -W 90 -H 50 pavucontrol pavucontrol-qt -{{< /highlight >}} - -To work properly, i3dropdown needs to have the path to the i3 socket. Because the command to get the socketpath from i3 is a little slow, it is best to cache it somewhere. By default -i3dropdown recognises `/tmp/i3wm-socket-path`. Then each window managed by i3dropdown needs to be floating. The last line bind a key to invoke or mask the app. - diff --git a/content/en/blog/miscellaneous/libreoffice.md b/content/en/blog/miscellaneous/libreoffice.md deleted file mode 100644 index 29b8541..0000000 --- a/content/en/blog/miscellaneous/libreoffice.md +++ /dev/null @@ -1,9 +0,0 @@ ---- -title: "Removing libreoffice write protection" -linkTitle: "Removing libreoffice write protection" -date: 2018-03-05 -description: > - Removing libreoffice write protection ---- - -You can choose to ignore write-protection by setting `Tools > Options > libreOffice Writer > Formatting Aids > Protected Areas > Ignore protection`. diff --git a/content/en/blog/miscellaneous/link-deleted-inode.md b/content/en/blog/miscellaneous/link-deleted-inode.md deleted file mode 100644 index 45f0417..0000000 --- a/content/en/blog/miscellaneous/link-deleted-inode.md +++ /dev/null @@ -1,10 +0,0 @@ ---- -title: "Link to a deleted inode" -linkTitle: "Link to a deleted inode" -date: 2018-03-05 -description: > - Link to a deleted inode ---- - -Get the inode number from `lsof`, then run `debugfs -w /dev/mapper/vg-home -R 'link <16008> /some/path'` where 16008 is the inode number (the < > are important, they tell debugfs you manipulate an inode). The path is relative to the root of the block device you are restoring onto. - diff --git a/content/en/blog/miscellaneous/make.md b/content/en/blog/miscellaneous/make.md deleted file mode 100644 index 0795127..0000000 --- a/content/en/blog/miscellaneous/make.md +++ /dev/null @@ -1,10 +0,0 @@ ---- -title: "Understanding make" -linkTitle: "Understanding make" -date: 2018-01-30 -description: > - Understanding make ---- - -http://gromnitsky.users.sourceforge.net/articles/notes-for-new-make-users/ - diff --git a/content/en/blog/miscellaneous/mencoder.md b/content/en/blog/miscellaneous/mencoder.md deleted file mode 100644 index 4bb8fd0..0000000 --- a/content/en/blog/miscellaneous/mencoder.md +++ /dev/null @@ -1,21 +0,0 @@ ---- -title: "Aggregate images into a video with mencoder" -linkTitle: "Aggregate images into a video with mencoder" -date: 2018-04-30 -description: > - Aggregate images into a video withmencoder ---- - -## Aggregate png images into a video -{{< highlight sh >}} -mencoder mf://*.png -mf w=1400:h=700:fps=1:type=png -ovc lavc -lavcopts vcodec=mpeg4:mbd=2:trell -oac copy -o output.avi -{{< /highlight >}} - -You should use the following to specify a list of files instead of `*.png`: -{{< highlight sh >}} -mf://@list.txt -{{< /highlight >}} - -## References - -- http://www.mplayerhq.hu/DOCS/HTML/en/menc-feat-enc-images.html diff --git a/content/en/blog/miscellaneous/mssql-centos-7.md b/content/en/blog/miscellaneous/mssql-centos-7.md deleted file mode 100644 index 019f442..0000000 --- a/content/en/blog/miscellaneous/mssql-centos-7.md +++ /dev/null @@ -1,29 +0,0 @@ ---- -title: "Installing mssql on centos 7" -linkTitle: "Installing mssql on centos 7" -date: 2019-07-09 -description: > - Installing mssql on centos 7 ---- - -{{< highlight sh >}} -vi /etc/sysconfig/network-scripts/ifcfg-eth0 -vi /etc/resolv.conf -curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo -curl -o /etc/yum.repos.d/mssql-prod.repo https://packages.microsoft.com/config/rhel/7/prod.repo -yum update -yum install -y mssql-server mssql-tools -yum install -y sudo -localectl set-locale LANG=en_US.utf8 -echo "export LANG=en_US.UTF-8" >> /etc/profile.d/locale.sh -echo "export LANGUAGE=en_US.UTF-8" >> /etc/profile.d/locale.sh -yum install -y openssh-server -systemctl enable sshd -systemctl start sshd -passwd -/opt/mssql/bin/mssql-conf setup -rm -f /etc/localtime -ln -s /usr/share/zoneinfo/Europe/Paris /etc/localtime -/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -p -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/my-postgresql-role-cannot-login.md b/content/en/blog/miscellaneous/my-postgresql-role-cannot-login.md deleted file mode 100644 index 2b958bf..0000000 --- a/content/en/blog/miscellaneous/my-postgresql-role-cannot-login.md +++ /dev/null @@ -1,12 +0,0 @@ ---- -title: "Cannot login role into postgresql" -linkTitle: "Cannot login role into postgresql" -date: 2015-11-24 -description: > - Cannot login role into postgresql ---- - -{{< highlight sh >}} -ALTER ROLE "user" LOGIN; -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/nginx-ldap.md b/content/en/blog/miscellaneous/nginx-ldap.md deleted file mode 100644 index b480943..0000000 --- a/content/en/blog/miscellaneous/nginx-ldap.md +++ /dev/null @@ -1,25 +0,0 @@ ---- -title: "LDAP auth with nginx" -linkTitle: "LDAP auth with nginx" -date: 2018-03-05 -description: > - LDAP auth with nginx ---- - -{{< highlight sh >}} -ldap_server ldap { - auth_ldap_cache_enabled on; - auth_ldap_cache_expiration_time 10000; - auth_ldap_cache_size 1000; - - url "ldaps://ldapslave.adyxax.org/ou=Users,dc=adyxax,dc=org?uid?sub?(objectClass=posixAccount)"; - binddn "cn=admin,dc=adyxax,dc=org"; - binddn_passwd secret; - group_attribute memberUid; - group_attribute_is_dn off; - satisfy any; - require valid_user; - #require group "cn=admins,ou=groups,dc=adyxax,dc=org"; -} -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/osm-overlay-example.md b/content/en/blog/miscellaneous/osm-overlay-example.md deleted file mode 100644 index 2787a6e..0000000 --- a/content/en/blog/miscellaneous/osm-overlay-example.md +++ /dev/null @@ -1,19 +0,0 @@ ---- -title: "OpenStreetMap overlay example" -linkTitle: "OpenStreetMap overlay example" -date: 2020-05-19 -description: > - An example of how to query things visually on OpenStreetMap ---- - -http://overpass-turbo.eu/ -{{< highlight html >}} - - - - - - - - -{{< /highlight >}} diff --git a/content/en/blog/miscellaneous/pleroma.md b/content/en/blog/miscellaneous/pleroma.md deleted file mode 100644 index 91c10f8..0000000 --- a/content/en/blog/miscellaneous/pleroma.md +++ /dev/null @@ -1,117 +0,0 @@ ---- -title: "Pleroma installation notes" -linkTitle: "Pleroma installation notes" -date: 2018-11-16 -description: > - Pleroma installation notes ---- - -This article is about my installation of pleroma in a standard alpine linux lxd container. - -## Installation notes -{{< highlight sh >}} -apk add elixir nginx postgresql postgresql-contrib git sudo erlang-ssl erlang-xmerl erlang-parsetools erlang-runtime-tools make gcc build-base vim vimdiff htop curl -/etc/init.d/postgresql start -rc-update add postgresql default -cd /srv -git clone https://git.pleroma.social/pleroma/pleroma -cd pleroma/ -mix deps.get -mix generate_config -cp config/generated_config.exs config/prod.secret.exs -cat config/setup_db.psql -{{< /highlight >}} - -At this stage you are supposed to execute these setup_db commands in your postgres. Instead of chmoding and stuff detailed in the official documentation I execute it manually from psql shell : -{{< highlight sh >}} -su - postgres -psql -CREATE USER pleroma WITH ENCRYPTED PASSWORD 'XXXXXXXXXXXXXXXXXXX'; -CREATE DATABASE pleroma_dev OWNER pleroma; -\c pleroma_dev; -CREATE EXTENSION IF NOT EXISTS citext; -CREATE EXTENSION IF NOT EXISTS pg_trgm; -{{< /highlight >}} - -Now back to pleroma : -{{< highlight sh >}} -MIX_ENV=prod mix ecto.migrate -MIX_ENV=prod mix phx.server -{{< /highlight >}} - -If this last command runs without error your pleroma will be available and you can test it with : -{{< highlight sh >}} -curl http://localhost:4000/api/v1/instance -{{< /highlight >}} - -If this works, you can shut it down with two C-c and we can configure nginx. This article doesn't really cover my setup since my nginx doesn't run there, and I am using letsencrypt wildcard certificates fetched somewhere else unrelated, so to simplify I only paste the vhost part of the configuration : -{{< highlight sh >}} -### in nginx.conf inside the container ### -# {{{ pleroma -proxy_cache_path /tmp/pleroma-media-cache levels=1:2 keys_zone=pleroma_media_cache:10m max_size=500m inactive=200m use_temp_path=off; -ssl_session_cache shared:ssl_session_cache:10m; -server { - listen 80; - listen [::]:80; - server_name social.adyxax.org; - return 301 https://$server_name$request_uri; -} -server { - listen 443 ssl; - listen [::]:443 ssl; - server_name social.adyxax.org; - root /usr/share/nginx/html; - - include /etc/nginx/vhost.d/social.conf; - ssl_certificate /etc/nginx/fullchain; - ssl_certificate_key /etc/nginx/privkey; -} -# }}} - -### in a vhost.d/social.conf ### -location / { - proxy_set_header Host $http_host; - proxy_set_header X-Forwarded-Host $http_host; - proxy_set_header X-Real-IP $remote_addr; - proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; - proxy_pass http://172.16.1.8:4000/; - - add_header 'Access-Control-Allow-Origin' '*'; - proxy_http_version 1.1; - proxy_set_header Upgrade $http_upgrade; - proxy_set_header Connection "upgrade"; - - allow all; -} - -location /proxy { - proxy_cache pleroma_media_cache; - proxy_cache_lock on; - proxy_pass http://172.16.1.8:4000$request_uri; -} - -client_max_body_size 20M; -{{< /highlight >}} - -Now add the phx.server on boot. I run pleroma has plemora user to completely limit the permissions of the server software. The official documentation has all files belong to the user running the server, I prefer that only the uploads directory does. Since I don't run nginx from this container I also edit this out : -{{< highlight sh >}} -adduser -s /sbin/nologin -D -h /srv/pleroma pleroma -cp -a /root/.hex/ /srv/pleroma/. -cp -a /root/.mix /srv/pleroma/. -chown -R pleroma:pleroma /srv/pleroma/uploads -cp installation/init.d/pleroma /etc/init.d -sed -i /etc/init.d/pleroma -e '/^directory=/s/=.*/=\/srv\/pleroma/' -sed -i /etc/init.d/pleroma -e '/^command_user=/s/=.*/=nobody:nobody/' -sed -i /etc/init.d/pleroma -e 's/nginx //' -rc-update add pleroma default -rc-update add pleroma start -{{< /highlight >}} - -You should be good to go and access your instance from any web browser. After creating your account in a web browser come back to the cli and set yourself as moderator : -{{< highlight sh >}} -mix set_moderator adyxax -{{< /highlight >}} - -## References - -- https://git.pleroma.social/pleroma/pleroma diff --git a/content/en/blog/miscellaneous/postgresql-read-only.md b/content/en/blog/miscellaneous/postgresql-read-only.md deleted file mode 100644 index c064e97..0000000 --- a/content/en/blog/miscellaneous/postgresql-read-only.md +++ /dev/null @@ -1,17 +0,0 @@ ---- -title: "Grant postgresql read only access" -linkTitle: "Grant postgresql read only access" -date: 2015-11-24 -description: > - Grant postgresql read only access ---- - -{{< highlight sh >}} -GRANT CONNECT ON DATABASE "db" TO "user"; -\c db -GRANT USAGE ON SCHEMA public TO "user"; -GRANT SELECT ON ALL TABLES IN SCHEMA public TO "user"; -ALTER DEFAULT PRIVILEGES IN SCHEMA public - GRANT SELECT ON TABLES TO "user"; -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/postgresql-reassign.md b/content/en/blog/miscellaneous/postgresql-reassign.md deleted file mode 100644 index 7779c40..0000000 --- a/content/en/blog/miscellaneous/postgresql-reassign.md +++ /dev/null @@ -1,18 +0,0 @@ ---- -title: "Change owner on a postgresql database and all tables" -linkTitle: "Change owner on a postgresql database and all tables" -date: 2012-04-20 -description: > - Change owner on a postgresql database and all tables ---- - -{{< highlight sh >}} -ALTER DATABASE name OWNER TO new_owner -for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done -for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done -for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done -{{< /highlight >}} - -{{< highlight sh >}} -reassign owned by "support" to "test-support"; -{{< /highlight >}} diff --git a/content/en/blog/miscellaneous/pulseaudio.md b/content/en/blog/miscellaneous/pulseaudio.md deleted file mode 100644 index c656275..0000000 --- a/content/en/blog/miscellaneous/pulseaudio.md +++ /dev/null @@ -1,11 +0,0 @@ ---- -title: "Pulseaudio" -linkTitle: "Pulseaudio" -date: 2018-09-25 -description: > - Pulseaudio ---- - -- List outputs : `pacmd list-sinks | grep -e 'name:' -e 'index'` -- Select a new one : `pacmd set-default-sink alsa_output.usb-C-Media_Electronics_Inc._USB_PnP_Sound_Device-00.analog-stereo` - diff --git a/content/en/blog/miscellaneous/purge-postfix-queue-based-content.md b/content/en/blog/miscellaneous/purge-postfix-queue-based-content.md deleted file mode 100644 index 2db52ac..0000000 --- a/content/en/blog/miscellaneous/purge-postfix-queue-based-content.md +++ /dev/null @@ -1,13 +0,0 @@ ---- -title: "Purge postfix queue based on email contents" -linkTitle: "Purge postfix queue based on email contents" -date: 2009-04-27 -description: > - Purge postfix queue based on email contents ---- - - -{{< highlight sh >}} -find /var/spool/postfix/deferred/ -type f -exec grep -li 'XXX' '{}' \; | xargs -n1 basename | xargs -n1 postsuper -d -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/qmail.md b/content/en/blog/miscellaneous/qmail.md deleted file mode 100644 index 6a28f1a..0000000 --- a/content/en/blog/miscellaneous/qmail.md +++ /dev/null @@ -1,21 +0,0 @@ ---- -title: "Qmail" -linkTitle: "Qmail" -date: 2018-03-05 -description: > - Qmail ---- - -## Commands - -- Get statistics : `qmail-qstat` -- list queued mails : `qmail-qread` -- Read an email in the queue (NNNN is the #id from qmail-qread) : `find /var/qmail/queue -name NNNN| xargs cat | less` -- Change queue lifetime for qmail in seconds (example here for 15 days) : `echo 1296000 > /var/qmail/control/queuelifetime` - -## References - -- http://www.lifewithqmail.org/lwq.html -- http://www.fileformat.info/tip/linux/qmailnow.htm -- https://www.hivelocity.net/kb/how-to-change-queue-lifetime-for-qmail/ - diff --git a/content/en/blog/miscellaneous/rocketchat.md b/content/en/blog/miscellaneous/rocketchat.md deleted file mode 100644 index 072658d..0000000 --- a/content/en/blog/miscellaneous/rocketchat.md +++ /dev/null @@ -1,18 +0,0 @@ ---- -title: "RocketChat" -linkTitle: "RocketChat" -date: 2019-08-06 -description: > - RocketChat ---- - -Docker simple install : -{{< highlight sh >}} -docker run --name db -d mongo --smallfiles --replSet hurricane - -docker exec -ti db mongo -> rs.initiate() - -docker run -p 3000:3000 --name rocketchat --env ROOT_URL=http://hurricane --env MONGO_OPLOG_URL=mongodb://db:27017/local?replSet=hurricane --link db -d rocket.chat -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/screen-cannot-open-terminal.md b/content/en/blog/miscellaneous/screen-cannot-open-terminal.md deleted file mode 100644 index 7622191..0000000 --- a/content/en/blog/miscellaneous/screen-cannot-open-terminal.md +++ /dev/null @@ -1,17 +0,0 @@ ---- -title: "Screen cannot open terminal error" -linkTitle: "Screen cannot open terminal error" -date: 2018-07-03 -description: > - Screen cannot open terminal error ---- - -If you encounter : -{{< highlight sh >}} -Cannot open your terminal '/dev/pts/0' - please check. -{{< /highlight >}} - -Then you did not open the shell with the user you logged in with. You can make screen happy by running : -{{< highlight sh >}} -script /dev/null -{{< /highlight >}} diff --git a/content/en/blog/miscellaneous/seti-at-home.md b/content/en/blog/miscellaneous/seti-at-home.md deleted file mode 100644 index a8d1cf8..0000000 --- a/content/en/blog/miscellaneous/seti-at-home.md +++ /dev/null @@ -1,18 +0,0 @@ ---- -title: "Seti@Home" -linkTitle: "Seti@Home" -date: 2018-03-05 -description: > - Seti@Home ---- - -{{< highlight sh >}} -apt install boinc -echo "graou" > /var/lib/boinc-client/gui_rpc_auth.cfg -systemctl restart boinc-client -boinccmd --host localhost --passwd graou --get_messages 0 -boinccmd --host localhost --passwd graou --get_state|less -boinccmd --host localhost --passwd graou --lookup_account http://setiathome.berkeley.edu XXXXXX -boinccmd --host localhost --passwd graou --project_attach http://setiathome.berkeley.edu -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/sqlite-pretty-print.md b/content/en/blog/miscellaneous/sqlite-pretty-print.md deleted file mode 100644 index 08bcec6..0000000 --- a/content/en/blog/miscellaneous/sqlite-pretty-print.md +++ /dev/null @@ -1,16 +0,0 @@ ---- -title: "Sqlite pretty print" -linkTitle: "Sqlite pretty print" -date: 2019-06-19 -description: > - Sqlite pretty print ---- - -- In ~/.sqliterc : -{{< highlight sh >}} -.mode column -.headers on -.separator ROW "\n" -.nullvalue NULL -{{< /highlight >}} - diff --git a/content/en/blog/miscellaneous/switching-to-hugo.md b/content/en/blog/miscellaneous/switching-to-hugo.md deleted file mode 100644 index 739b36d..0000000 --- a/content/en/blog/miscellaneous/switching-to-hugo.md +++ /dev/null @@ -1,58 +0,0 @@ ---- -title: "Switching to Hugo" -linkTitle: "Switching to Hugo" -date: 2019-12-19 -description: > - I switched my personal wiki from dokuwiki to Hugo ---- - -This is the website you are currently reading. It is a static website built using hugo. This article details how I installed hugo, how I initialised this website and how I manage it. I often refer to it as wiki.adyxax.org because I hosted a unique dokuwiki for a long time as my main website (and a pmwiki before that), but with hugo it has become more than that. It is now a mix of wiki, blog and showcase of my work and interests. - -## Installing hugo - -{{< highlight sh >}} -go get github.com/gohugoio/hugo -{{< / highlight >}} - -You probably won't encounter this issue but this command failed at the time I installed hugo because the master branch in one of the dependencies was -tainted. I fixed it with by using a stable tag for this project and continue installing hugo from there: -{{< highlight sh >}} -cd go/src/github.com/tdewolff/minify/ -tig --all -git checkout v2.6.1 -go get github.com/gohugoio/hugo -{{< / highlight >}} - -This did not build me the extended version of hugo that I need for the [docsy](https://github.com/google/docsy) theme I chose, so I had to get it by doing : -{{< highlight sh >}} -cd ~/go/src/github.com/gohugoio/hugo/ -go get --tags extended -go install --tags extended -{{< / highlight >}} - -## Bootstraping this site - -{{< highlight sh >}} -hugo new site www -cd www -git init -git submodule add https://github.com/google/docsy themes/docsy -{{< / highlight >}} - -The docsy theme requires two nodejs programs to run : -{{< highlight sh >}} -npm install -D --save autoprefixer -npm install -D --save postcss-cli -{{< / highlight >}} - -## hugo commands - -To spin up the live server for automatic rebuilding the website when writing articles : -{{< highlight sh >}} -hugo server --bind 0.0.0.0 --minify --disableFastRender -{{< / highlight >}} - -To publish the website in the `public` folder : -{{< highlight sh >}} -hugo --minify -{{< / highlight >}} -- cgit v1.2.3