Conversation

Notices

1. Embed this notice
   Reilly Chase (rchase@social.hostifi.com)'s status on Tuesday, 27-Dec-2022 09:19:32 JST Reilly Chase

   • Alex Gleason
   Hey @alex I finally got Rebased + Soapbox installed on a DigitalOcean VPS with a DigitalOcean managed Postgres db.
   
   Maybe I'll write a blog post later if I get time... some of these Pleroma db options were pretty difficult to track down between StackOverflow/git issues/forums.
   
   There were some extra steps like:
   • Manually create postgres and pleroma dbs at DigitalOcean
   • Connect to the db remotely (I used TablePlus GUI) then execute the SQL in the config/setup_db.psql file on the managed db
   • Download the ca cert from DigitalOcean managed db and transfer the file to /opt/pleroma/ca-certificate.crt
   • Create a db pool at DigitalOcean with max 22 connections for the 1GB RAM db instance
   • Modify config/prod.secret.exs and add the ssl, port, ssl_opts, pool_size, and queue_target options below:
   
   config :pleroma, Pleroma.Repo,
   adapter: Ecto.Adapters.Postgres,
   username: "user",
   password: "password",
   database: "pleroma",
   hostname: "my-unique-id.b.db.ondigitalocean.com",
   port: 25060,
   ssl: true,
   ssl_opts: [verify: :verify_peer, cacertfile: '/opt/pleroma/ca-certificate.crt'],
   pool_size: 10,
   queue_target: 5000
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 27-Dec-2022 09:19:30 JST Alex Gleason

     in reply to

     @rchase Mastodon users won’t see emoji reactions at all, but the thumbs-up in Soapbox gets mapped to favourite. So that’s the only one Mastodon users will see.

   • Embed this notice
     Reilly Chase (rchase@social.hostifi.com)'s status on Tuesday, 27-Dec-2022 09:19:31 JST Reilly Chase

     in reply to

     • Alex Gleason
     Also was wondering, no matter which reaction I give to a post of someone on a Mastodon server, they're going to just see that I "Favourite"'d it right?
     
     I want to set my server to heart reactions only to be more Twitter-like, you said this was possible via a config file, can you point me to any doc on that I couldn't find it?
   • Embed this notice
     Reilly Chase (rchase@social.hostifi.com)'s status on Tuesday, 27-Dec-2022 09:19:32 JST Reilly Chase

     in reply to

     • Alex Gleason
     I ran into a lot of issues with this error originally:
     
     "FATAL: remaining connection slots are reserved for non-replication superuser connections."
     
     Indicating there were too many db connections in use. After I added these lines to config/prod.secret.exs it went away:
     
     pool_size: 10,
     queue_target: 5000
     
     I also created a db pool on the DigitalOcean managed db to allow up to 22 connections (max for my 1GB RAM db instance).
     
     I am running a 1GB RAM 1vCPU VPS instance as well, after reading your post recommending 4GB RAM 2vCPU I upgraded the VPS to 2GB RAM 2vCPU (even though it was actually running fine as is but I also just started out...)
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 27-Dec-2022 09:20:13 JST Alex Gleason

     in reply to

     @rchase Interesting, never seen that one before.

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 27-Dec-2022 09:22:28 JST Alex Gleason

     in reply to

     • Alex Gleason

     @rchase There’s a secret way to configure which emojis are shown for reactions, but you should just wait a month and we’ll add a UI for it and let users pick any emoji.

     Also, thumbs-up is hardcoded to favourite. There’s no way around that currently.

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 27-Dec-2022 09:23:49 JST Alex Gleason

     in reply to

     • Alex Gleason

     @rchase I want to drop thumbs-up and make heart map to favorite, but then there’s no way to “extra-like” something. Or rather, we lose the ability to acknowledge something without extra-liking it… Also, there are backwards-compat implications. So I’ve been frozen on that issue.

   • Embed this notice
     Reilly Chase (rchase@social.hostifi.com)'s status on Tuesday, 27-Dec-2022 09:23:54 JST Reilly Chase

     in reply to

     • Alex Gleason
     Ok sick I'll wait for the update rather than do something hacky thanks!
     Alex Gleason likes this.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 27-Dec-2022 09:28:30 JST Alex Gleason

     in reply to

     @rchase There will be a features editor in the next release that lets you disable emoji reactions entirely. Then it would use that behavior.

   • Embed this notice
     Reilly Chase (rchase@social.hostifi.com)'s status on Tuesday, 27-Dec-2022 09:28:31 JST Reilly Chase

     in reply to

     • Alex Gleason
     Can you do a Twitter mode for us people who want to map heart to thumbs up/favorite and then remove all other emojis? Seems like if you're removing the ability to thumbs up and mapping heart to it then it's just a frontend decision with no backend incompatibility issue.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 27-Dec-2022 09:33:10 JST Alex Gleason

     in reply to

     • Alex Gleason

     @rchase See: https://gitlab.com/soapbox-pub/soapbox/-/merge_requests/1914