Files F27833514

No One
Actions

Authored By

	• Banyek
	Jan 9 2019, 3:26 PM

Size

1 KB

Referenced Files

None

Subscribers

None

View Options

	banyek@cumin2001:~ $ cat T85757/fix_triggers.sh
	#!/bin/bash
	#
	#
	# eg. usage:
	# ./fix_triggers.sh db1125:3317 s7
	#

	HOST=$1
	SECTION=$2

	for db in $(cat mediawiki-config/dblists/${SECTION}.dblist); do
	echo "fixing triggers on ${db}"
	/home/banyek/wmfmariadbpy/wmfmariadbpy/mysql.py -h ${HOST} ${db} -e "SET SESSION sql_log_bin=0; DROP TRIGGER IF EXISTS ${db}.user_insert; CREATE DEFINER='root'@'localhost' TRIGGER ${db}.user_insert BEFORE INSERT ON ${db}.user FOR EACH ROW SET NEW.user_password = '', NEW.user_newpassword = '', NEW.user_email = '', NEW.user_token = '', NEW.user_email_authenticated = '', NEW.user_email_token = '', NEW.user_email_token_expires = '', NEW.user_newpass_time = '';DROP TRIGGER IF EXISTS ${db}.user_update; CREATE DEFINER='root'@'localhost' TRIGGER ${db}.user_update BEFORE UPDATE ON ${db}.user FOR EACH ROW SET NEW.user_password = '', NEW.user_newpassword = '', NEW.user_email = '', NEW.user_token = '', NEW.user_email_authenticated = '', NEW.user_email_token = '', NEW.user_email_token_expires = '', NEW.user_newpass_time = '';"
	done

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 6942144
Default Alt Text: (1 KB)

Event Timeline