I don't know if this will be at all helpful about the topic, but it looks like there's a draft report for "ActivityPub and HTTP Signatures" at https://swicg.github.io/activitypub-http-signature/#survey-of-standards-...
I apologise for the noise if this isn't helpful.
kinetix242 → created an issue.
No errors this time around!
Tried making the change suggested, though, and now have this:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: argument of AND must be type boolean, not type integer LINE 1: ...eys" WHERE spamkey = 'exempt-needle-sig-hide' AND POSITION(s... ^: SELECT spamvalue FROM "spammaster_keys" WHERE spamkey = :key AND POSITION(spamvalue IN :sighide); Array ( [:key] => exempt-needle-sig-hide [:sighide] => spammaster_settings_form ) in Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle() (line 407 of /[redacted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php).
and
#0 /[redcated]/dev/web/core/lib/Drupal/Core/Database/Connection.php(858): Drupal\Core\Database\ExceptionHandler->handleExecutionException()
#1 /[redcated]/dev/web/core/modules/pgsql/src/Driver/Database/pgsql/Connection.php(239): Drupal\Core\Database\Connection->query()
#2 /[redcated]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php(407): Drupal\pgsql\Driver\Database\pgsql\Connection->query()
#3 /[redcated]/dev/web/modules/contrib/spammaster/spammaster.module(382): Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle()
#4 /[redcated]/dev/web/core/lib/Drupal/Core/Extension/ModuleHandler.php(545): spammaster_form_alter()
#5 /[redcated]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(841): Drupal\Core\Extension\ModuleHandler->alter()
#6 /[redcated]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(284): Drupal\Core\Form\FormBuilder->prepareForm()
#7 /[redcated]/dev/web/core/lib/Drupal/Core/Controller/FormController.php(73): Drupal\Core\Form\FormBuilder->buildForm()
#8 [internal function]: Drupal\Core\Controller\FormController->getContentResult()
#9 /[redcated]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array()
#10 /[redcated]/dev/web/core/lib/Drupal/Core/Render/Renderer.php(627): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#11 /[redcated]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(121): Drupal\Core\Render\Renderer->executeInRenderContext()
#12 /[redcated]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext()
#13 /[redcated]/dev/vendor/symfony/http-kernel/HttpKernel.php(181): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#14 /[redcated]/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#15 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle()
#16 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle()
#17 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle()
#18 /[redcated]/dev/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle()
#19 /[redcated]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\big_pipe\StackMiddleware\ContentLength->handle()
#20 /[redcated]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass()
#21 /[redcated]/dev/web/modules/contrib/activitypub/src/StackMiddleware/FormatSetter.php(44): Drupal\page_cache\StackMiddleware\PageCache->handle()
#22 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\activitypub\StackMiddleware\FormatSetter->handle()
#23 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle()
#24 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle()
#25 /[redcated]/dev/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle()
#26 /[redcated]/dev/web/core/lib/Drupal/Core/DrupalKernel.php(704): Drupal\Core\StackMiddleware\StackedHttpKernel->handle()
#27 /[redcated]/dev/web/index.php(19): Drupal\Core\DrupalKernel->handle()
#28 {main}Nope, running PHP-FPM 8.3.3
Hi there... sorry I wasn't able to get my hands in to this the past couple of days.
I've just updated the module to 2.36 and there still appears to be more to work through:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: argument of AND must be type boolean, not type integer LINE 1: ...r_keys" WHERE spamkey = 'exempt-needle-straw' AND POSITION(s... ^: SELECT spamvalue FROM "spammaster_keys" WHERE spamkey = :key AND POSITION(spamvalue IN :straw); Array ( [:key] => exempt-needle-straw [:straw] => spammaster_settings_form ) in Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle() (line 398 of /[redacted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php).
and
#0 /[redacted]/dev/web/core/lib/Drupal/Core/Database/Connection.php(858): Drupal\Core\Database\ExceptionHandler->handleExecutionException()
#1 /[redacted]/dev/web/core/modules/pgsql/src/Driver/Database/pgsql/Connection.php(239): Drupal\Core\Database\Connection->query()
#2 /[redacted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php(398): Drupal\pgsql\Driver\Database\pgsql\Connection->query()
#3 /[redacted]/dev/web/modules/contrib/spammaster/spammaster.module(382): Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle()
#4 /[redacted]/dev/web/core/lib/Drupal/Core/Extension/ModuleHandler.php(545): spammaster_form_alter()
#5 /[redacted]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(841): Drupal\Core\Extension\ModuleHandler->alter()
#6 /[redacted]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(284): Drupal\Core\Form\FormBuilder->prepareForm()
#7 /[redacted]/dev/web/core/lib/Drupal/Core/Controller/FormController.php(73): Drupal\Core\Form\FormBuilder->buildForm()
#8 [internal function]: Drupal\Core\Controller\FormController->getContentResult()
#9 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array()
#10 /[redacted]/dev/web/core/lib/Drupal/Core/Render/Renderer.php(627): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#11 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(121): Drupal\Core\Render\Renderer->executeInRenderContext()
#12 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext()
#13 /[redacted]/dev/vendor/symfony/http-kernel/HttpKernel.php(181): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#14 /[redacted]/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#15 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle()
#16 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle()
#17 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle()
#18 /[redacted]/dev/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle()
#19 /[redacted]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\big_pipe\StackMiddleware\ContentLength->handle()
#20 /[redacted]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass()
#21 /[redacted]/dev/web/modules/contrib/activitypub/src/StackMiddleware/FormatSetter.php(44): Drupal\page_cache\StackMiddleware\PageCache->handle()
#22 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\activitypub\StackMiddleware\FormatSetter->handle()
#23 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle()
#24 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle()
#25 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle()
#26 /[redacted]/dev/web/core/lib/Drupal/Core/DrupalKernel.php(704): Drupal\Core\StackMiddleware\StackedHttpKernel->handle()
#27 /[redacted]/dev/web/index.php(19): Drupal\Core\DrupalKernel->handle()
#28 {main}
OK, after making the change, this is what the error situation looks like:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: argument of AND must be type boolean, not type integer LINE 1: ...r_keys" WHERE spamkey = 'exempt-needle-straw' AND POSITION(s... ^: SELECT spamvalue FROM "spammaster_keys" WHERE spamkey = :key AND POSITION(spamvalue IN :straw); Array ( [:key] => exempt-needle-straw [:straw] => CAST(spammaster_settings_form AS TEXT) ) in Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle() (line 398 of /[redacted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php).
and
#0 /[redacted]/dev/web/core/lib/Drupal/Core/Database/Connection.php(858): Drupal\Core\Database\ExceptionHandler->handleExecutionException()
#1 /[redacted]/dev/web/core/modules/pgsql/src/Driver/Database/pgsql/Connection.php(239): Drupal\Core\Database\Connection->query()
#2 /[redacted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php(398): Drupal\pgsql\Driver\Database\pgsql\Connection->query()
#3 /[redacted]/dev/web/modules/contrib/spammaster/spammaster.module(381): Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle()
#4 /[redacted]/dev/web/core/lib/Drupal/Core/Extension/ModuleHandler.php(545): spammaster_form_alter()
#5 /[redacted]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(841): Drupal\Core\Extension\ModuleHandler->alter()
#6 /[redacted]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(284): Drupal\Core\Form\FormBuilder->prepareForm()
#7 /[redacted]/dev/web/core/lib/Drupal/Core/Controller/FormController.php(73): Drupal\Core\Form\FormBuilder->buildForm()
#8 [internal function]: Drupal\Core\Controller\FormController->getContentResult()
#9 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array()
#10 /[redacted]/dev/web/core/lib/Drupal/Core/Render/Renderer.php(627): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#11 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(121): Drupal\Core\Render\Renderer->executeInRenderContext()
#12 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext()
#13 /[redacted]/dev/vendor/symfony/http-kernel/HttpKernel.php(181): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#14 /[redacted]/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#15 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle()
#16 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle()
#17 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle()
#18 /[redacted]/dev/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle()
#19 /[redacted]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\big_pipe\StackMiddleware\ContentLength->handle()
#20 /[redacted]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass()
#21 /[redacted]/dev/web/modules/contrib/activitypub/src/StackMiddleware/FormatSetter.php(44): Drupal\page_cache\StackMiddleware\PageCache->handle()
#22 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\activitypub\StackMiddleware\FormatSetter->handle()
#23 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle()
#24 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle()
#25 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle()
#26 /[redacted]/dev/web/core/lib/Drupal/Core/DrupalKernel.php(704): Drupal\Core\StackMiddleware\StackedHttpKernel->handle()
#27 /[redacted]/dev/web/index.php(19): Drupal\Core\DrupalKernel->handle()
#28 {main}I should be able to, yes.
Hi there,
Yes, sorry that I forgot to mention that I'm using Postgresql.
I've just installed 2.35, upon enabling the module, Drupal shows an error dialog stating:
Spam Master Free license could not be created. License status is: MALFUNCTION_4. Check Spam Master configuration page and read more about statuses.
Spam Master MALFUNCTION 4 detected. You are not Protected!!! Not able to automatically Generate a FREE Connection Key on your server, most likely reason is the Settings > General > Administration Email Address -> webmaster@humanwords.cc already in use with a key. Please login at www.spammaster.org with webmaster@humanwords.cc to retrieve your license key and insert in drupal Configuration -> Spam master Settings.So, I went and put the license key I received during yesterday's install in to spam master's configuration, and then Drupal breakage occurred: "The website encountered an unexpected error. Try again later."
After disabling the module again, the logs show:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42883]: Undefined function: 7 ERROR: function locate(text, unknown) does not exist LINE 1: ...r_keys" WHERE spamkey = 'exempt-needle-straw' AND LOCATE(spa... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.: SELECT spamvalue FROM "spammaster_keys" WHERE spamkey = :key AND LOCATE(spamvalue, :straw); Array ( [:key] => exempt-needle-straw [:straw] => CAST(spammaster_settings_form AS TEXT) ) in Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle() (line 398 of [recadcted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php).
and
#0 /[redacted]/dev/web/core/lib/Drupal/Core/Database/Connection.php(858): Drupal\Core\Database\ExceptionHandler->handleExecutionException()
#1 /[redacted]/dev/web/core/modules/pgsql/src/Driver/Database/pgsql/Connection.php(239): Drupal\Core\Database\Connection->query()
#2 /[redacted]/dev/web/modules/contrib/spammaster/src/SpamMasterElusiveService.php(398): Drupal\pgsql\Driver\Database\pgsql\Connection->query()
#3 /[redacted]/dev/web/modules/contrib/spammaster/spammaster.module(381): Drupal\spammaster\SpamMasterElusiveService->spamMasterIsNeedle()
#4 /[redacted]/dev/web/core/lib/Drupal/Core/Extension/ModuleHandler.php(545): spammaster_form_alter()
#5 /[redacted]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(841): Drupal\Core\Extension\ModuleHandler->alter()
#6 /[redacted]/dev/web/core/lib/Drupal/Core/Form/FormBuilder.php(284): Drupal\Core\Form\FormBuilder->prepareForm()
#7 /[redacted]/dev/web/core/lib/Drupal/Core/Controller/FormController.php(73): Drupal\Core\Form\FormBuilder->buildForm()
#8 [internal function]: Drupal\Core\Controller\FormController->getContentResult()
#9 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array()
#10 /[redacted]/dev/web/core/lib/Drupal/Core/Render/Renderer.php(627): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#11 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(121): Drupal\Core\Render\Renderer->executeInRenderContext()
#12 /[redacted]/dev/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext()
#13 /[redacted]/dev/vendor/symfony/http-kernel/HttpKernel.php(181): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
#14 /[redacted]/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#15 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle()
#16 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle()
#17 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle()
#18 /[redacted]/dev/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle()
#19 /[redacted]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\big_pipe\StackMiddleware\ContentLength->handle()
#20 /[redacted]/dev/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass()
#21 /[redacted]/dev/web/modules/contrib/activitypub/src/StackMiddleware/FormatSetter.php(44): Drupal\page_cache\StackMiddleware\PageCache->handle()
#22 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\activitypub\StackMiddleware\FormatSetter->handle()
#23 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle()
#24 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle()
#25 /[redacted]/dev/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle()
#26 /[redacted]/dev/web/core/lib/Drupal/Core/DrupalKernel.php(704): Drupal\Core\StackMiddleware\StackedHttpKernel->handle()
#27 /[redacted]/dev/web/index.php(19): Drupal\Core\DrupalKernel->handle()
#28 {main}kinetix242 → created an issue.
I'll just add that I've created a separate user for Activitypub, changed the site-wide user to that user ID (5), and ensured that authenticated users can publish to the site-wide actor.
Same result when trying to do the follow from the Akkoma instance.
I hope my additional comments are somewhat helpful. Please let me know if there's more I can do.
Some info on it: https://hub.sunny.garden/2023/06/28/what-does-authorized_fetch-actually-do/
I am curious if my Activitypub settings could cause the problem - I have the site-wide user set to 0, which I might have accidentally done, but I haven't seen information / documentation on what the value should be.
kinetix242 → created an issue.