Nonymus

JPoschma@jposchma-nb2:~/devel/lcs/ops/kubespray$ ansible-playbook -i lmc-kube/inventory upgrade-cluster.yml -u root
[DEPRECATION WARNING]: The use of 'include' for tasks has been deprecated. Use 'import_tasks' for static inclusions or 'include_tasks' for dynamic inclusions. This feature will be removed in a future
release. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.
[DEPRECATION WARNING]: include is kept for backwards compatibility but usage is discouraged. The module documentation details page may explain more about this rationale.. This feature will be removed in
a future release. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg.

PLAY [localhost] *******************************************************************************************************************************************************************************************

TASK [kubespray-defaults : Configure defaults] ******************************************

Nonymus

CREATE OR REPLACE FUNCTION change_tz() RETURNS integer AS $$
DECLARE
    query varchar;
    result integer := 0;
    rel RECORD;
    col RECORD;
BEGIN
    FOR rel IN SELECT DISTINCT table_name FROM information_schema.columns WHERE table_schema =  'public' AND data_type = 'timestamp without time zone' AND table_name not like 'databasechangelog%' LOOP
      query := 'ALTER TABLE ' || quote_ident(rel.table_name) || ' SET WITHOUT CLUSTER'; -- NOOP, makes combining easier

Nonymus

[Unit]
Description=Cassandra (systemd)
After=network.target

[Service]
User=cassandra
Environment="cassandra_home=/var/lib/cassandra"
LimitNPROC=32768
LimitMEMLOCK=infinity
LimitAS=infinity

Nonymus

#!/bin/sh

mkdir /store/firewall

# Copy the service.xml firewall rules to a central storage
# so they can survive reboot
cp /etc/vmware/firewall/service.xml /store/firewall

# Remove end tag so rule addition works as expected
sed -i "s/<\/ConfigRoot>//" /store/firewall/service.xml

Nonymus

// ==UserScript==
// @name         Remove Twitch Popout Banner Sonntagsstreamer
// @namespace    http://tampermonkey.net/
// @version      0.3
// @description  try to take over the world!
// @author       Ragufti
// @match        https://www.twitch.tv/embed/*/chat?darkpopout&parent=www.sonntagsstreamer.de
// @icon         https://www.google.com/s2/favicons?sz=64&domain=sonntagsstreamer.de
// @source       https://gist.github.com/Nonymus/a44531f062e82f3062ffab6a06d80a56
// @grant        none