rchamorro

1. Download docker-compose.yml to dir named sentry
2. Change SENTRY_SECRET_KEY to random 32 char string
3. Run docker-compose up -d
4. Run docker-compose exec sentry sentry upgrade to setup database and create admin user
5. (Optional) Run docker-compose exec sentry pip install sentry-slack if you want slack plugin, it can be done later
6. Run docker-compose restart sentry
7. Sentry is now running on public port 9000

• https://docs.docker.com/compose/compose-file/#env_file

rchamorro

WITH SlugTable AS
(
	SELECT Id, CASE WHEN N > 1 THEN CONCAT(RTRIM(slug), '-', n) ELSE slug END AS NewSlug
	FROM (
	SELECT Id
		REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(RTRIM(LTRIM(LOWER(Title))), ' ', '-'), '/', '-'), '(',''), ')',''), '--','-'),'--','-'),'''','-'),'á','a'),'é','e'),'í','i'),'ó','o'),'ú','u'),'à','a'),'è','e'),'ò','o') AS Slug, 
		ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [Id]) as N from Posts n
	) AS Q
)
Update Posts

rchamorro

# This is an example of the Stack Exchange Tier 1 HAProxy config
# The only things that have been changed from what we are running are: 
# 1. User names have been removed
# 2. All Passwords have been remove
# 3. IPs have been changed to use the example/documentation ranges
# 4. Rate limit numbers have been changed to randome numbers, don't read into them

userlist stats-auth
        group admin users $admin_user
        user $admin_user insecure-password $some_password