tk, @lanodan I’m having trouble getting following to work now. My user on KBBS is following my GS user on both the Pleroma side:
pleroma=> SELECT id, ap_id FROM users WHERE id IN('0000016f-ee31-77b4-218b-430a336b0000', '00000188-d57c-611f-35da-dfec06df0000'); id | ap_id --------------------------------------+----------------------------------------- 0000016f-ee31-77b4-218b-430a336b0000 | <a href="https://bbs.kawa-kun.com/users/tk" rel="ugc">https://bbs.kawa-kun.com/users/tk</a> 00000188-d57c-611f-35da-dfec06df0000 | <a href="https://diatom.social/index.php/user/29" rel="ugc">https://diatom.social/index.php/user/29</a> (2 rows) pleroma=> SELECT * FROM following_relationships WHERE id = 18491; id | follower_id | following_id | state | inserted_at | updated_at -------+--------------------------------------+--------------------------------------+-------+---------------------+--------------------- 18491 | 0000016f-ee31-77b4-218b-430a336b0000 | 00000188-d57c-611f-35da-dfec06df0000 | 1 | 2023-06-20 14:11:01 | 2023-06-20 14:11:01 (1 row)
And on the GS side:
MariaDB [social]> SELECT id, profileurl FROM profile WHERE id IN(3, 29); +----+-----------------------------------+ | id | profileurl | +----+-----------------------------------+ | 3 | <a href="https://bbs.kawa-kun.com/users/tk" rel="ugc">https://bbs.kawa-kun.com/users/tk</a> | | 29 | <a href="https://diatom.social/tk" rel="ugc">https://diatom.social/tk</a> | +----+-----------------------------------+ 2 rows in set (0.000 sec) MariaDB [social]> SELECT * FROM subscription WHERE subscriber = 3 AND subscribed = 29; +------------+------------+--------+------+-------+--------+---------------------------------------------------------------------------------+---------------------+---------------------+ | subscriber | subscribed | jabber | sms | token | secret | uri | created | modified | +------------+------------+--------+------+-------+--------+---------------------------------------------------------------------------------+---------------------+---------------------+ | 3 | 29 | 1 | 1 | NULL | NULL | tag:diatom.social,2023-06-20:subscription:3:person:29:2023-06-20T07:11:02-07:00 | 2023-06-20 14:11:02 | 2023-06-20 14:11:02 | +------------+------------+--------+------+-------+--------+---------------------------------------------------------------------------------+---------------------+---------------------+ 1 row in set (0.000 sec)
But I’m not getting non-mentions in my KBBS user’s timeline despite re-establishing this over and over. Any ideas?