All gists - Opengist

MrGeneration / KB Catalan redirect

0 likes

0 forks

2 files

Last active 21 hours ago

Redirects outdated locale slug for knowledge bases from 'es-ca' to 'ca' for improved usability and very easy switching. As shown in the Zammad 7.0 Release video: https://www.youtube.com/watch?v=unwYUx5--7M

zammad knowledge base catalan es-ca

1	# Default /help URL (replace help with your custom alias if needed; NOT for custom domains)
2	rewrite ^/help/es-ca/(.*)$ /help/ca/$1 permanent;
3
4	# for custom URLs
5	rewrite ^/es-ca/(.*)$ /ca/$1 permanent;

MrGeneration / Useful Minio Console and Restic commands

0 likes

0 forks

4 files

Last active 21 hours ago

Commands used as shown in the video https://youtu.be/P-Pr7Dy6mP8 .

restic backup restore mc minio console s3

1	{
2	"Version": "2012-10-17",
3	"Statement": [
4	{
5	"Effect": "Allow",
6	"Action": ["s3:*"],
7	"Resource": ["arn:aws:s3:::resticsample/*"]
8	}
9	]
10	}

MrGeneration / Backup Paperless NGX with restic

0 likes

0 forks

4 files

Last active 21 hours ago

As shown on https://youtu.be/P-Pr7Dy6mP8

restic backup restore paperless

1	#!/usr/bin/env bash
2	#
3	# 2025-09-25 Marcel Herrguth
4	# As shown on https://youtu.be/P-Pr7Dy6mP8
5	# Attribution back to this GIST is required!
6	#
7	# Parts of this script are oriented from https://github.com/zammad/zammad/tree/develop/contrib/backup
8	# This script supports PostGreSQL (docker) stacks only and expects your media to be in a mounted folder.
9	#
10	# Restoration only works on a pre-installed Paperless NGX installation of the same version (or higher).

MrGeneration / Backup Zammad with restic

0 likes

0 forks

2 files

Last active 21 hours ago

As shown on https://youtu.be/P-Pr7Dy6mP8

restic backup restore zammad

1	#!/usr/bin/env bash
2	#
3	# 2025-09-06 Marcel Herrguth
4	# As shown on https://youtu.be/P-Pr7Dy6mP8
5	# Attribution back to this GIST is required!
6	#
7	# Parts of this script are oriented from https://github.com/zammad/zammad/tree/develop/contrib/backup
8	# Only PostGreSQL is supported; No symlinks are supported
9	#
10	# Restoration only works on a pre-installed Zammad installation of the same version (or higher).

MrGeneration / Search and Replace Gitlab / Github URLs in Tickets

0 likes

0 forks

2 files

Last active 21 hours ago

These snippets allow you to search and replace either just your Gitlab / Github URL or whole group / project URLs if needed. Proceed with care, you cannot undo this operation.

1	# URLs below can contain project / group URLs, but have to fit as this script
2	# does a very simple search and replace.
3	# Backup first
4	old_gitlab_url = 'https://git.my-old.domain/'
5	new_gitlab_url = 'https://git.my-new.domain/'
6
7	Ticket.where("preferences LIKE '%gitlab%'").find_in_batches.each do \|b\|
8	b.each do \|t\|
9	next if t.preferences[:gitlab][:issue_links].count.zero?

MrGeneration / Limit Elasticsearch Memory Usage

0 likes

0 forks

1 files

Last active 21 hours ago

Code snippet to create linked storage directories for Zammad. As shown in https://youtu.be/EorlfrN6n60

elasticsearch heap-size

1	# /etc/elasticsearch/jvm.options.d/heap-size.conf
2	# Below limits Elasticsearch to 1GB memory usage
3	# It uses 50% of your hosts memory by default otherwise
4	-Xms1g
5	-Xmx1g

MrGeneration / Move Store from DB to File (linked directory)

0 likes

0 forks

2 files

Last active 21 hours ago

Code snippet to create linked storage directories for Zammad. As shown in https://youtu.be/EorlfrN6n60

1	# Below works with existing data storage. STOP Zammad during below operation
2	mv /opt/zammad_storage/ /opt/zammad_storage/
3	ln -s /opt/zammad_storage/ /opt/zammad/storage
4	chown zammad:zammad /opt/zammad_storage/
5	chmod 700 /opt/zammad_storage/

MrGeneration / Install and Configure Grafana with Zammad

0 likes

0 forks

6 files

Last active 21 hours ago

This gist provides contextual copy paste options for Using Grafana with Zammad. Video context to this: https://youtu.be/CdGdKE4hjUU

1	##################### Grafana Configuration Example #####################
2	#
3	# Everything has defaults so you only need to uncomment things you want to
4	# change
5
6	# possible values : production, development
7	;app_mode = production
8
9	# instance name, defaults to HOSTNAME environment variable value or hostname if HOSTNAME var is empty
10	;instance_name = FQDN

MrGeneration / Debian / Ubuntu Upgrade

0 likes

0 forks

8 files

Last active 21 hours ago

This gist provides contextual copy paste options for Distribution upgrades with installed Zammad and PostgreSQL for Debian (10, 11, 12) and Ubuntu (18, 20, 22). Video context to this: https://youtu.be/IXp4VWU27wo

1	# The following action is NOT reversible but is significantly faster.
2	# Use at own descression - replace oldversion with your old version and newversion with your new version
3
4	pg_upgradecluster --method=upgrade --link <oldversion> main /var/lib/postgresql/<newversion>/main/

MrGeneration / Zammad 6.2: Enforce SSL-Verification

0 likes

0 forks

4 files

Last active 21 hours ago

With Zammad 6.2 existing configurations for Email channels and i-doit by default have ssl verification disabled. This code snippet activates SSL verification. This change ONLY affects existing, update installations.

1	# Side note: Elasticsearch has an option to verify SSL as well. This might be an edge case.
2	# By default these certificates are self-signed and thus you may not want to run this at all
3	Setting.set('es_ssl_verify', true)