(Just- migrated this instance over to kubernetes… just testing federation…)

    •  rs5th   ( @rs5th@lemmy.scottlabs.io ) English
      13·
      3 years ago

      Here’s a cronjob to clean up the useless activity table every day:

      
apiVersion: batch/v1beta1
kind: CronJob
metadata:
  name: postgresql-cleanup
  namespace: lemmy
spec:
  schedule: "0 0 * * *"
  jobTemplate:
    spec:
      template:
        spec:
          containers:
          - name: postgres-cleanup
            image: postgres:alpine
            command: ["psql", "--host=postgresql", "--dbname=postgres", "--username=postgres", "--command=DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';"]
            env:
            - name: PGPASSWORD
              valueFrom:
                secretKeyRef:
                  name: postgresql
                  key: postgres-password
          backoffLimit: 0
          ttlSecondsAfterFinished: 3600
      •  HTTP_404_NotFound   ( @xtremeownage@lemmyonline.com ) OPEnglish
        13·
        3 years ago

        Oh sweet, here, I will share my lovely ingressroute in return… to replace the nginx stuff everyone else is using.

        apiVersion: traefik.containo.us/v1alpha1
kind: IngressRoute
metadata:
  name: lemmy
  namespace: lemmy
spec:
  entryPoints:
    - websecure
  routes:
    - kind: Rule
      match: Host(`lemmyonline.com`) && (Headers(`Accept`, `application/activity+json`) || Headers(`Accept`, `application/ld+json; profile=\"https://www.w3.org/ns/activitystreams\"`))
      services:
        - name: lemmy
          port: http
    - kind: Rule
      match: Host(`lemmyonline.com`) && (PathPrefix(`/api`) || PathPrefix(`/pictrs`) || PathPrefix(`/feeds`) || PathPrefix(`/nodeinfo`) || PathPrefix(`/.well-known`))
      services:
        - name: lemmy
          port: http
    - kind: Rule
      match: Host(`lemmyonline.com`) && Method(`POST`)
      services:
        - name: lemmy
          port: http
    - kind: Rule
      match: Host(`lemmyonline.com`)
      services:
        - name: lemmy-ui
          port: http

        Thanks!

        Edit- could be consolidated down to only two rules, I left it expanded out to be a tad easier to read.

        •  rs5th   ( @rs5th@lemmy.scottlabs.io ) English
          11·
          3 years ago

          If anyone else has made it this far and are thinking “ah balls, I’m using ingress-nginx”, here’s the ingress annotation for you!

          nginx.ingress.kubernetes.io/configuration-snippet: |
            if ($http_accept = "application/activity+json") {
              set $proxy_upstream_name "lemmy-lemmy-8536";
            }
            if ($http_accept = "application/ld+json; profile=\"https://www.w3.org/ns/activitystreams\"") {
              set $proxy_upstream_name "lemmy-lemmy-8536";
            }
            if ($request_method = POST) {
              set $proxy_upstream_name "lemmy-lemmy-8536";
            }