GoToSocial | Mastodon Alternative

[murgero]

The software is currently in alpha stages, but supports a lot already and can pretty much be used daily. It's also super light on resources, enough so that you can use it without a database server (sqlite) (but supports postgresql also!) and can run on a Raspberry Pi Zero!

Original Source: https://github.com/superseriousbusiness/gotosocial

I also have an app packed and ready to install, but i'm currently testing so I wont make it public just yet, but you can see the instance running at https://gts.urgero.dev (assuming I haven't taken it down for testing/rebuilding)

Public repo for testing: https://git.cloudron.io/murgero/cloudron-gotosocial

And a current user profile that I am using for testing also: https://gts.urgero.dev/@socialadmin

[robi]

Oh nice it's based on Go.

Haha, the repo says it's read-only and on holiday until next year.

[murgero]

Anyone looking to try it out: Public repo for testing: https://git.cloudron.io/murgero/cloudron-gotosocial

It's pretty stable, but there are upstream bugs like weird federation issues with certain versions of Mastodon and other ActivityPub servers.

[yusf]

@murgero Hey, I'm getting

App installation error: Invalid CloudronManifest.json: Format validation failed (Invalid URL) @ /mediaLinks/0

when running cloudron install --image=mitchellurgero/org.urgero.gts:latest.

[yusf]

I did remove the mediaLinks line in the manifest file and it all worked. Now my issue is that I can't configure account-domain before the app boots up, making it seemingly impossible to change:

# DO NOT change this after your server has already run once, or you will break things!

Any advice?

Great job so far

[murgero]

@yusf Oh shoot, I should remove the medialinks section, its not ready yet.

[murgero]

@yusf The startup script configures this for you. I am trying to find a way to make that configurable pre-install like some apps can change their ports pre install. Otherwise it defaults to the current app domain.

Also, if you wanna get weird with it, you can change that value but then drop the table in postgresql for the app (PROCEED WITH CAUTION)

[yusf]

@murgero So if I drop the table it just gets recreated?

I was also considering trying install to domain.tld, then move it to a subdomain.

[murgero]

@yusf You can't move domain once it's installed unless you drop the database it uses (see that same config for the creds, db name, etc)

be aware this will erase any user data on the instance.

But yes - it will recreate database and tables.

[robi]

Sounds like there could be a DB script action created that would be a bit more fine grained in modifying just the wanted (sub)domain references, instead of a whole DB drop.

Eventually becoming a migration script.

[murgero]

@robi Is that something upstream? Cause I can't find that.

[robi]

@murgero no, it was a suggestion, since so many people want TLD based Masto IDs yet still want to run the server on a subdomain.

[yusf]

So I can enter a terminal in the GTS container, access and drop its db from there?

[murgero]

@yusf you should be able to yes

[yusf]

@murgero It's not clear to me how to do that. I tried

ALTER DATABASE mydb CONNECTION LIMIT 0;
and

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'mydb';

but I only managed to lock myself out before being able to
DROP DATABASE mydb;

How should I drop the database? No matter what I try I get

ERROR: cannot drop the currently open database`

[murgero]

@yusf That's more a question for psql community. sadly IDK lol