~peanutlasko as far as I know the only way is to follow each account from your mastodon instance, as both BMU and your mastodon account have to recognize and register the follow

Now my next question is, lol - how can I mass add all my twitter followers into this. I assume with a DB insert ?

~peanutlasko gotcha, glad it sounds like it's working as intended now - clearly the setup issue raised wasn't addressed by ~cloutier for new installs, so unfortunately the manual insert of data is needed, and the table structures have changed since I put together the sample values a couple of months ago

Wait, I think i understand now - it's trying to find someone who follows this handle already (@MKBHD@myselfhosteddomain.com) and fails (because nobody does)

If I add it via Mastodon FIRST, then search on Birdmakeup, it's working. So the error only happens whenever I'm searching and haven't added them prior in Mastodon. Makes sense actually.

Right, I can find NPR just fine too. I was under the impression though you should be able to search ANY twitter handle (even if it's not in the database yet), correct?

In Birdsitelive that was the case. Then you could get the Mastodon handle, copy/paste it into Mastodon.

~peanutlasko weird I was able to look up the account I seeded in the DB using the bmu interface without that error - but frankly there isn't much value in using the interface. You can just look up users in the mastodon UI and follow them from there, so long as that's working you should be in good shape.

better now! Thanks a lot for all this help Eric. So it appears to be working somewhat - I can log into my Mastodon instance and follow users from twitter. However, if I visit the actual birdmakeup..com that I self host, then I enter in any Twitter handle - @MKBHD for example, I still get the error:

2023-07-21 15:40:02 fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1] 2023-07-21 15:40:02 An unhandled exception has occurred while executing the request. 2023-07-21 15:40:02 System.NullReferenceException: Object reference not set to an instance of an object. 2023-07-21 15:40:02 at BirdsiteLive.Controllers.UsersController.Index(String id) in /src/BirdsiteLive/Controllers/UsersController.cs:line 133 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) 2023-07-21 15:40:02 at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.g__Awaited|8_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)

~peanutlasko Ok I was able to re-create the issues you're seeing on a fresh install, and got everything working. The problem is resolved by populating the data below in the two tables (followers, twitter_users).

May be worth doing a fresh install rather than trying to resolve your current setup, so stop and remove the container, delete the database and birdmakeup user from postgres using pgadmin.

After you've stopped and remove the bmu container, and removed the db/user from postgres, do the following:

1. Create birdmakeup user in postgres
2. Give superuser privileges
3. Create the birdmakeup database, and set it to be owned by your birdmakeup user

Start up the container, you should get a working UI at your birdmakeup domain

In pgadmin, paste the following values into the two relevant tables:

followers:

id	followings	acct	host	inboxroute	sharedinboxroute	actorid	postingerrorcount
1	{1}	peanutlasko	mas.to	/users/peanutlasko/inbox	/inbox	https://mas.to/users/peanutlasko	0

twitter_users - NOTE that the lastsync timestamp has spaces in it (2023-07-21 14:54:07.16) and the following 0 is for the fetchingerrorcount

id	acct	lasttweetpostedid	lastsync	fetchingerrorcount	twitteruserid	fediverseaccount
1	npr	1646138106595139584	2023-07-21 14:54:07.16	0	5392522

Then restart the bmu container and it should be working

~peanutlasko yes fully feel the frustration, it seems like the setup may be broken. I'm going to try setting up a fresh install and see if I can re-create what you're seeing, and hopefully solve.

Also noted my followers table doesnt have a column for followingssyncstatus nor does my twitter_users have a asttweetsynchronizedforallfollowersid column