I am currently trying out the social plugin and I wonder how I can follow other users?
type in the search (right above) the qualified full name, then follow
So I searched for @nextcloud@mastodon.xyz but it just says No accounts found?
Just wanted to make it clear, I tried several addresses but I always get the same result. Am I even doing the right thing?
Just tested and its fine, maybe something wrong in the config or netconfig. Take a look in the protocol please.
Indeed there is an error
500 - {"status":-1,"exception":"OCA\\Social\\Exceptions\\InvalidResourceException","message":"An exception occurred while executing 'INSERT INTO `oc_social_cache_actors` (`id`, `account`, `type`, `local`, `following`, `followers`, `inbox`, `shared_inbox`, `outbox`, `featured`, `url`, `preferred_username`, `name`, `summary`, `public_key`, `source`, `details`, `creation`, `icon_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\", \"nextcloud@mastodon.xyz\", \"Person\", \"0\", \"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/following\", \"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/followers\", \"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/inbox\", \"https:\\\/\\\/mastodon.xyz\\\/inbox\", \"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/outbox\", \"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/collections\\\/featured\", \"https:\\\/\\\/mastodon.xyz\\\/@nextcloud\", \"nextcloud\", \"Nextcloud \\ud83d\\udcf1\\u2601\\ufe0f\\ud83d\\udcbb\", \"<p>A safe home for all your data, community-driven &amp; open source!<br \\\/><a href=\\\"https:\\\/\\\/nextcloud.com\\\" rel=\\\"nofollow noopener\\\" target=\\\"_blank\\\"><span class=\\\"invisible\\\">https:\\\/\\\/<\\\/span><span class=\\\"\\\">nextcloud.com<\\\/span><span class=\\\"invisible\\\"><\\\/span><\\\/a><br \\\/>Join us at <a href=\\\"https:\\\/\\\/help.nextcloud.com\\\" rel=\\\"nofollow noopener\\\" target=\\\"_blank\\\"><span class=\\\"invisible\\\">https:\\\/\\\/<\\\/span><span class=\\\"\\\">help.nextcloud.com<\\\/span><span class=\\\"invisible\\\"><\\\/span><\\\/a> and <a href=\\\"https:\\\/\\\/github.com\\\/nextcloud\\\" rel=\\\"nofollow noopener\\\" target=\\\"_blank\\\"><span class=\\\"invisible\\\">https:\\\/\\\/<\\\/span><span class=\\\"\\\">github.com\\\/nextcloud<\\\/span><span class=\\\"invisible\\\"><\\\/span><\\\/a> \\ud83d\\ude0a<\\\/p>\", \"-----BEGIN PUBLIC KEY-----\\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAzydjBvhTuNNgOUTTz450\\nl4RiORVw4XU2gMGqvB5QtYGuLkBDU2BZR41N\\\/BVoYX3exNYei35kO2P\\\/vAFBZ6NO\\nQIuQXbrd1Gy8FF9Hv6Te\\\/n8KPlRN76RsMVfml+CN6COTjgl+sXJogzTyFcPLxoZS\\nJJbP64Yw3p0b5y3JNwrVuQPLBnjcjuHFKuxU5NXHgTZak4U4WCYdIE3FNw9\\\/Xiyc\\nacpo1GoZabMzJupGGtOWi8FL64EchvtRkvmyhb0Ae1GVnDY6Y1xhsbTEmrwSkDH4\\nlSDIkdxxQMZOo4Y8+UyMJamzlxwm2kmfFebSjVhwQmvYLLEzvSfPAA0q6mI7uuin\\nEQIDAQAB\\n-----END PUBLIC KEY-----\\n\", \"{\\\"@context\\\":[\\\"https:\\\/\\\/www.w3.org\\\/ns\\\/activitystreams\\\",\\\"https:\\\/\\\/w3id.org\\\/security\\\/v1\\\",{\\\"manuallyApprovesFollowers\\\":\\\"as:manuallyApprovesFollowers\\\",\\\"sensitive\\\":\\\"as:sensitive\\\",\\\"movedTo\\\":{\\\"@id\\\":\\\"as:movedTo\\\",\\\"@type\\\":\\\"@id\\\"},\\\"alsoKnownAs\\\":{\\\"@id\\\":\\\"as:alsoKnownAs\\\",\\\"@type\\\":\\\"@id\\\"},\\\"Hashtag\\\":\\\"as:Hashtag\\\",\\\"ostatus\\\":\\\"http:\\\/\\\/ostatus.org#\\\",\\\"atomUri\\\":\\\"ostatus:atomUri\\\",\\\"inReplyToAtomUri\\\":\\\"ostatus:inReplyToAtomUri\\\",\\\"conversation\\\":\\\"ostatus:conversation\\\",\\\"toot\\\":\\\"http:\\\/\\\/joinmastodon.org\\\/ns#\\\",\\\"Emoji\\\":\\\"toot:Emoji\\\",\\\"focalPoint\\\":{\\\"@container\\\":\\\"@list\\\",\\\"@id\\\":\\\"toot:focalPoint\\\"},\\\"featured\\\":{\\\"@id\\\":\\\"toot:featured\\\",\\\"@type\\\":\\\"@id\\\"},\\\"schema\\\":\\\"http:\\\/\\\/schema.org#\\\",\\\"PropertyValue\\\":\\\"schema:PropertyValue\\\",\\\"value\\\":\\\"schema:value\\\"}],\\\"id\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\",\\\"type\\\":\\\"Person\\\",\\\"following\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/following\\\",\\\"followers\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/followers\\\",\\\"inbox\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/inbox\\\",\\\"outbox\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/outbox\\\",\\\"featured\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\/collections\\\/featured\\\",\\\"preferredUsername\\\":\\\"nextcloud\\\",\\\"name\\\":\\\"Nextcloud \\\\ud83d\\\\udcf1\\\\u2601\\\\ufe0f\\\\ud83d\\\\udcbb\\\",\\\"summary\\\":\\\"<p>A safe home for all your data, community-driven &amp; open source!<br \\\/><a href=\\\\\\\"https:\\\/\\\/nextcloud.com\\\\\\\" rel=\\\\\\\"nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">nextcloud.com<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a><br \\\/>Join us at <a href=\\\\\\\"https:\\\/\\\/help.nextcloud.com\\\\\\\" rel=\\\\\\\"nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">help.nextcloud.com<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a> and <a href=\\\\\\\"https:\\\/\\\/github.com\\\/nextcloud\\\\\\\" rel=\\\\\\\"nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">github.com\\\/nextcloud<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a> \\\\ud83d\\\\ude0a<\\\/p>\\\",\\\"url\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/@nextcloud\\\",\\\"manuallyApprovesFollowers\\\":false,\\\"publicKey\\\":{\\\"id\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud#main-key\\\",\\\"owner\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/users\\\/nextcloud\\\",\\\"publicKeyPem\\\":\\\"-----BEGIN PUBLIC KEY-----\\\\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAzydjBvhTuNNgOUTTz450\\\\nl4RiORVw4XU2gMGqvB5QtYGuLkBDU2BZR41N\\\/BVoYX3exNYei35kO2P\\\/vAFBZ6NO\\\\nQIuQXbrd1Gy8FF9Hv6Te\\\/n8KPlRN76RsMVfml+CN6COTjgl+sXJogzTyFcPLxoZS\\\\nJJbP64Yw3p0b5y3JNwrVuQPLBnjcjuHFKuxU5NXHgTZak4U4WCYdIE3FNw9\\\/Xiyc\\\\nacpo1GoZabMzJupGGtOWi8FL64EchvtRkvmyhb0Ae1GVnDY6Y1xhsbTEmrwSkDH4\\\\nlSDIkdxxQMZOo4Y8+UyMJamzlxwm2kmfFebSjVhwQmvYLLEzvSfPAA0q6mI7uuin\\\\nEQIDAQAB\\\\n-----END PUBLIC KEY-----\\\\n\\\"},\\\"tag\\\":[],\\\"attachment\\\":[{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"\\\\ud83d\\\\udcbb Website\\\",\\\"value\\\":\\\"<a href=\\\\\\\"https:\\\/\\\/nextcloud.com\\\\\\\" rel=\\\\\\\"me nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">nextcloud.com<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a>\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"\\\\ud83d\\\\ude0d Contribute\\\",\\\"value\\\":\\\"<a href=\\\\\\\"https:\\\/\\\/nextcloud.com\\\/contribute\\\\\\\" rel=\\\\\\\"me nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">nextcloud.com\\\/contribute<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a>\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"\\\\ud83c\\\\udf08 Include initiative\\\",\\\"value\\\":\\\"<a href=\\\\\\\"https:\\\/\\\/nextcloud.com\\\/include\\\\\\\" rel=\\\\\\\"me nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">nextcloud.com\\\/include<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a>\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"\\\\ud83d\\\\udcac Forum\\\",\\\"value\\\":\\\"<a href=\\\\\\\"https:\\\/\\\/help.nextcloud.com\\\\\\\" rel=\\\\\\\"me nofollow noopener\\\\\\\" target=\\\\\\\"_blank\\\\\\\"><span class=\\\\\\\"invisible\\\\\\\">https:\\\/\\\/<\\\/span><span class=\\\\\\\"\\\\\\\">help.nextcloud.com<\\\/span><span class=\\\\\\\"invisible\\\\\\\"><\\\/span><\\\/a>\\\"}],\\\"endpoints\\\":{\\\"sharedInbox\\\":\\\"https:\\\/\\\/mastodon.xyz\\\/inbox\\\"},\\\"icon\\\":{\\\"type\\\":\\\"Image\\\",\\\"mediaType\\\":\\\"image\\\/png\\\",\\\"url\\\":\\\"https:\\\/\\\/6-28.mastodon.xyz\\\/accounts\\\/avatars\\\/000\\\/059\\\/736\\\/original\\\/848538f02443fd59.png\\\"},\\\"image\\\":{\\\"type\\\":\\\"Image\\\",\\\"mediaType\\\":\\\"image\\\/jpeg\\\",\\\"url\\\":\\\"https:\\\/\\\/6-28.mastodon.xyz\\\/accounts\\\/headers\\\/000\\\/059\\\/736\\\/original\\\/eb04c45d6ac733c9.jpg\\\"},\\\"_host\\\":\\\"mastodon.xyz\\\"}\", \"[]\", \"2019-01-23 09:22:24\", \"https:\\\/\\\/cloud.rockdapus.org\\\/documents\\\/g\\\/5e3898fd-070f-472d-bbd7-370d12c00a76\"]:\n\nSQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\xF0\\x9F\\x93\\xB1\\xE2\\x98...' for column 'name' at row 1"}```If I interprete this correctly the database is rejecting the emoji symbols from the name field of nextcloud. Let’s see if I can figure out if I can set the correct encoding in the db or if it’s something else, help is appreciated.
I have the feeling this is the guide I should follow https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html?highlight=emoji
Huii, that was quite a ride but now it works.
I am not sure how to check if
[mysqld]
innodb_file_per_table=1
was actually set or not. From the posts that I read I guessed that if
SELECT NAME, SPACE FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
returns values greater than 0 that this setting is already applyed.
From there on I used the other commands of the docs and I was abel to find and follow @nextcloud@mastodon.xyz
Now I thought I would see posts by them in my global timeline.
Do I have to wait for new posts utill they appear in my global timeline?
be honest, cant say, thats what i struggle with, but I think it is my firewall, where only the SSL Port ist open.
Yes that’s what I had to do, nexcloud posted something and I saw it. Nice!
Good luck to you @anon93002831 to solve your problem
1 Like