docker-compose -f docker-compose.yml -f docker-compose.nginx.yml down
git pull
docker-compose -f docker-compose.yml -f docker-compose.nginx.yml up -d
go install github.com/mattermost/mattermost/server/v8/cmd/mmctl@master
cp go/bin/mmctl /usr/local/bin/
Get container id
docker ps
Enter container (replace id)
docker exec -ti 22c003a9b819 /bin/bash
psql mattermost mmuser
CREATE OR REPLACE FUNCTION apply_default_settings_for_new_user() RETURNS TRIGGER AS $defaultSettings$
BEGIN
IF (SELECT COUNT(*) FROM preferences WHERE userid=NEW.id AND category='display_settings' AND name='name_format') = 0 THEN
INSERT INTO preferences (userid, category, name, value) VALUES (NEW.id, 'display_settings', 'name_format', 'nickname_full_name');
END IF;
UPDATE users set notifyprops='{"push": "all", "email": "true", "channel": "true", "desktop": "mention", "comments": "never", "first_name": "true", "push_status": "online", "mention_keys": "", "push_threads": "all", "desktop_sound": "true", "email_threads": "all", "desktop_threads": "all"}' where id=NEW.id;
RETURN NEW;
END;
$defaultSettings$ LANGUAGE 'plpgsql';
DROP TRIGGER IF EXISTS apply_default_settings_for_new_user ON users;
CREATE TRIGGER apply_default_settings_for_new_user AFTER INSERT ON users FOR EACH ROW EXECUTE PROCEDURE apply_default_settings_for_new_user();
DO
$$
DECLARE rec RECORD;
BEGIN
FOR rec IN SELECT distinct userid from preferences
LOOP
insert into preferences (userid,category,name,value) VALUES (rec.userid, 'display_settings', 'name_format', 'nickname_full_name');
END LOOP;
END;
$$
XXXXXXXXXXXXX muss durch die korrekte User-ID ersetzt werden
UPDATE users set notifyprops='{"push": "all", "email": "true", "channel": "true", "desktop": "mention", "comments": "never", "first_name": "true", "push_status": "online", "mention_keys": "", "push_threads": "all", "desktop_sound": "true", "email_threads": "all", "desktop_threads": "all"}' where userid='XXXXXXXXXXXXX';