check out monyetbot’s webfinger it points to frank_bot instead of monyetbot, which probably means monyetbot was renamed, and lemmy does not do well with renamed users that still refer to their former name under webfinger.
i can’t think of anything else besides the very risky option of editing the db directly, but you’ll probably have to ask the lemmy devs for the correct sql statement that would solve this.
or, as a more temporary option, maybe this could be solved at the webserver level, by redirecting all requests to /u/frank_bot to /u/monyetbot (must take care to distinguish between requests to backend and frontend, both *ends respond to that http request (with different content types)) but that would just involve an nginx expert instead of an sql expert, and i am neither.
@[email protected] I updated the db and it seems like it’s fixed. Thanks for helping! The solution was the actor_id for the user account was still pointing to Frank_Bot URL, which is already invalid.
Oh wait… sorry @[email protected] I just realized I made a mistake there. T_T You actually cannot change your account name(only your display name) which I now understand the reason. I changed the account name a long time ago so I forgot that I changed the account name manually via the database without updating the actor_id and inbox_url correctly.
E.g. the actor_id should be https://monyet.cc/u/MonyetBot instead of https://monyet.cc/u/Frank_Bot, which was the old URL.
The reason you can’t change your account name is most probably everything relies on the actor_id to work, and if the actor_id is invalid, it won’t be able to federate. Even if they updated the actor_id and inbox_url, all your past post, comments and messages etc. should be tied to the old url, which won’t carry over after you change your account name.
luckily we caught this early before monyetbot had a lot of posts. anyway, i think what’s even more important is the keypair in the db, so it is good the problems monyetbot had were not related to that.
by the way, you may want to do a sql dump and search if there’s any other reference to frank_bot that can be updated. i heard lemmy 0.18.3 (out last night) has quite a bit of db optimizations, so don’t want any outdated reference to cause issues with that.
I tried checking the foreign key contrainsts in the db but it seems like there aren’t any tables referencing actor_id, usually just the id(PK column) of the person table.
@[email protected] @[email protected] i have found the issue.
check out monyetbot’s webfinger it points to
frank_botinstead ofmonyetbot, which probably means monyetbot was renamed, and lemmy does not do well with renamed users that still refer to their former name under webfinger.Ooo, nice catch!
Ah yeah… that was the initial name for the account :/ So there’s nothing that can be done to fix it right?
i can’t think of anything else besides the very risky option of editing the db directly, but you’ll probably have to ask the lemmy devs for the correct sql statement that would solve this.
or, as a more temporary option, maybe this could be solved at the webserver level, by redirecting all requests to
/u/frank_botto/u/monyetbot(must take care to distinguish between requests to backend and frontend, both *ends respond to that http request (with different content types)) but that would just involve an nginx expert instead of an sql expert, and i am neither.@[email protected] I updated the db and it seems like it’s fixed. Thanks for helping! The solution was the actor_id for the user account was still pointing to Frank_Bot URL, which is already invalid.
oh that’s nice, may i know what sql statement you used?
anyway, time to upvote everything in this thread so it federates over 🤣
I’m going to open a github issue on this so I’ll just link it here later haha
Oh wait… sorry @[email protected] I just realized I made a mistake there. T_T You actually cannot change your account name(only your display name) which I now understand the reason. I changed the account name a long time ago so I forgot that I changed the account name manually via the database without updating the actor_id and inbox_url correctly. E.g. the actor_id should be https://monyet.cc/u/MonyetBot instead of https://monyet.cc/u/Frank_Bot, which was the old URL.
The reason you can’t change your account name is most probably everything relies on the actor_id to work, and if the actor_id is invalid, it won’t be able to federate. Even if they updated the actor_id and inbox_url, all your past post, comments and messages etc. should be tied to the old url, which won’t carry over after you change your account name.
luckily we caught this early before monyetbot had a lot of posts. anyway, i think what’s even more important is the keypair in the db, so it is good the problems monyetbot had were not related to that.
by the way, you may want to do a sql dump and search if there’s any other reference to
frank_botthat can be updated. i heard lemmy 0.18.3 (out last night) has quite a bit of db optimizations, so don’t want any outdated reference to cause issues with that.I tried checking the foreign key contrainsts in the db but it seems like there aren’t any tables referencing actor_id, usually just the id(PK column) of the person table.
wait a minute… I might actually know the solution. let me update you later
alright, but please update even if it doesn’t work out, as being curious, i also like to know about all the other attempts at solving things