Search
Items tagged with: 7
First ever instance crash. Suggestions for avoiding this in the future?
!Friendica Support
I had my first-ever server crash of https://my-place.social. This is in syslog:
2024-11-18T21:34:49.022603-05:00 my-place php: PHP Fatal error: Uncaught mysqli_sql_exception: Too many connections in /var/www/html/src/Database/Database.php:201
2024-11-18T21:34:49.022822-05:00 my-place php: Stack trace:
2024-11-18T21:34:49.022855-05:00 my-place php: #0 /var/www/html/src/Database/Database.php(201): mysqli->__construct()
2024-11-18T21:34:49.022885-05:00 my-place php: #1 /var/www/html/src/Database/Database.php(106): Friendica\Database\Database->connect()
2024-11-18T21:34:49.022911-05:00 my-place php: #2 [internal function]: Friendica\Database\Database->__construct()
2024-11-18T21:34:49.022933-05:00 my-place php: #3 /var/www/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs()
2024-11-18T21:34:49.022958-05:00 my-place php: #4 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.022985-05:00 my-place php: #5 /var/www/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create()
2024-11-18T21:34:49.023014-05:00 my-place php: #6 /var/www/html/vendor/level-2/dice/Dice.php(132): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023049-05:00 my-place php: #7 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023074-05:00 my-place php: #8 /var/www/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create()
2024-11-18T21:34:49.023100-05:00 my-place php: #9 /var/www/html/vendor/level-2/dice/Dice.php(132): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023125-05:00 my-place php: #10 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023147-05:00 my-place php: #11 /var/www/html/index.php(34): Dice\Dice->create()
2024-11-18T21:34:49.023172-05:00 my-place php: #12 {main}
2024-11-18T21:34:49.023208-05:00 my-place php: thrown in /var/www/html/src/Database/Database.php on line 201
show variables like 'max_connections'; shows 151 max_connections.
I did: SET GLOBAL max_connections = 200;
I also edited /etc/mysql/mariadb.conf.d/50-server.cnf and set max_connections = 200
Is this too high? Too low? Did I do this the correct way?
Thank you!
Thanks!
admin profile trouble
#bugResearch
Platform Info: 2023.05 - stable | Browser firefox
Friendica Version: 2023.05 - stableFriendica Source: gitHub
PHP version: 8.1.2-1ubuntu2.14
SQL version: MySQL / MariaDB
memory_limit 256M
4 Core CPU, 8 GB Ram with 300GB NVME Disk
I didn't have a look at gitHub
Short bug description:
Unwanted Profile switch and loss of administration access because of change of email for the wrong profile.Details of the buggy behavior:
I logged into the admin account and created a profile with by error the admin email address from the admin panel:/moderation/users
.After logging into that new profile editing avatar and password I saw the access option for admin and moderation.
Logged out to check the admin profile itself and to post a bug report.
Realized the duplicated email address use, logged out of the admin profile and logged into the newly created profile to change that email address.
Several other tabs with pages of the server were open.
Trying to change the email address the first system message was:
"The form security token was not correct. This probably happened because the form has been opened for too long (>3 hours) before submitting it."
I actually switched in a matter of maybe 15 minutes from a standard networking profile to the admin profile, to two newly created profiles, to the admin profile and again to the new profile with admin access.
The second time, trying to change the email to that of a "commoner":
"Wrong Password."
I double checked that but no chance to change the email of the new account, so I tried to use the password of the admin profile, as the email is related to it. This time apparently everything went well, no system message and the new email figured in the settings field.
BUT, the profile had changed to the admin profile, at least I saw the change at that moment.
In the screens I found that the first message about "old token" the admin profile was already displayed as the logged in profile.
Now the admin email is not the one it should be anymore, the one that figures in local.config.php. When trying to change it back to the admin email I get the following system message:
"Cannot change to that email."
¿Possible to reproduce, if so how:
I don't know as the kinda random profile switch is involved.The profiles should log in and out several times.
Several pages should be opened by logged in profiles.
Than the secondary profile with a different password but the same admin email created by the admin panel user moderation option should try to change it's email address.
First with the own password, than with the admin password.
Expected result:
The secondary profile that had access to the administration pages should be able to change it's email with it's own password, maybe it could but background issues about what profile was actually in use prevented that.To change the email of a profile to the admins email, maybe the option of entering both passwords could be a way to settle this important change?
(I guess not, that change should be protected by the local.config.php security workaround)
A secondary loop of security questions to assure that the intent is to change the admin profile email for the profile XYZ could be implemented because of the importance of that email address and profile.
Screenshots:
--
possible work arounds
Right now I wonder if I could just change the admin email in the local.config.php to settle the problem the easy way but I'm not sure if there is some setting in the DB that could hold that admin information too that needs to be changed. If so I might run into breaking up my access to the admin panels as I'm unaware how to investigate the mariaDB over SSH and have no web page access to the phpmysql surface.information for dev and server team:
The only error that is printed in the error log file every once in a while is:
php.error.log
thrown in /var/www/html/src/Database/Database.php on line 191[ XXX UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Connection refused in /var/www/html/src/Database/Database.php:191
Stack trace:
#0 /var/www/html/src/Database/Database.php(191): mysqli->__construct()
#1 /var/www/html/src/Database/Database.php(97): Friendica\Database\Database->connect()
#2 [internal function]: Friendica\Database\Database->__construct()
#3 /var/www/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs()
#4 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
#5 /var/www/html/src/DI.php(98): Dice\Dice->create()
#6 /var/www/html/src/DI.php(66): Friendica\DI::dba()
#7 /var/www/html/src/DI.php(54): Friendica\DI::setCompositeRootDependencyByHand()
#8 /var/www/html/index.php(35): Friendica\DI::init()
#9 {main}
PHP error log thrown in /src/Database/Database.php on line 191
hi there, I have this message in my php.error.log
what should I do?
I didn't have a look at gitHub
php.error.log Database.php on line 191
thrown in /var/www/html/src/Database/Database.php on line 191[14-Nov-2023 14:15:30 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Connection refused in /var/www/html/src/Database/Database.php:191
Stack trace:
#0 /var/www/html/src/Database/Database.php(191): mysqli->__construct()
#1 /var/www/html/src/Database/Database.php(97): Friendica\Database\Database->connect()
#2 [internal function]: Friendica\Database\Database->__construct()
#3 /var/www/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs()
#4 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
#5 /var/www/html/src/DI.php(98): Dice\Dice->create()
#6 /var/www/html/src/DI.php(66): Friendica\DI::dba()
#7 /var/www/html/src/DI.php(54): Friendica\DI::setCompositeRootDependencyByHand()
#8 /var/www/html/index.php(35): Friendica\DI::init()
#9 {main}
thrown in /var/www/html/src/Database/Database.php on line 191
Platform Info: 2023.05 - stable
Friendica Version: 2023.05 - stableFriendica Source: gitHub
PHP version: 8.1.2-1ubuntu2.14
SQL version: MySQL / MariaDB
memory_limit 256M
4 Core CPU, 8 GB Ram with 300GB NVME Disk
Introduction Not Found Exception
I am getting the following error for a number of pending contacts.
Can you help with the meaining and if anything needs to be done?
Friendica\Network\HTTPException\NotFoundException in /var/www/html/src/BaseRepository.php:156
Stack trace:
#0 /var/www/html/src/Contact/Introduction/Repository/Introduction.php(57): Friendica\BaseRepository->_selectOne()
#1 /var/www/html/src/Contact/Introduction/Repository/Introduction.php(134): Friendica\Contact\Introduction\Repository\Introduction->selectOne()
#2 /var/www/html/src/Model/Contact.php(1210): Friendica\Contact\Introduction\Repository\Introduction->selectForContact()
#3 /var/www/html/src/Module/Contact.php(559): Friendica\Model\Contact:😛hotoMenu()
#4 /var/www/html/src/Module/Directory.php(79): Friendica\Module\Contact::getContactTemplateVars()
#5 /var/www/html/src/BaseModule.php(244): Friendica\Module\Directory->content()
#6 /var/www/html/src/App.php(746): Friendica\BaseModule->run()
#7 /var/www/html/index.php(44): Friendica\App->runFrontend()
#8 {main}
Next Friendica\Contact\Introduction\Exception\IntroductionNotFoundException: There is no Introduction for the contact 676 in /var/www/html/src/Contact/Introduction/Repository/Introduction.php:136
Stack trace:
#0 /var/www/html/src/Model/Contact.php(1210): Friendica\Contact\Introduction\Repository\Introduction->selectForContact()
#1 /var/www/html/src/Module/Contact.php(559): Friendica\Model\Contact:😛hotoMenu()
#2 /var/www/html/src/Module/Directory.php(79): Friendica\Module\Contact::getContactTemplateVars()
#3 /var/www/html/src/BaseModule.php(244): Friendica\Module\Directory->content()
#4 /var/www/html/src/App.php(746): Friendica\BaseModule->run()
#5 /var/www/html/index.php(44): Friendica\App->runFrontend()
#6 {main}
Vorbereitung 1: alias php='/usr/local/php74/bin/php'
Vorbereitung 2: Über Filezilla die Berechtigung für bin/console auf 744 (sonst kommt "permission denied")
Versionstest (falls das was hilft) + Fehler:
bash-4.4$ php -v
PHP 7.4.30 (cli) (built: Jun 14 2022 12:37:00) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with the ionCube PHP Loader + ionCube24 v11.0.1, Copyright (c) 2002-2022, by ionCube Ltd.
with Zend OPcache v7.4.30, Copyright (c), by Zend Technologies
bash-4.4$ bin/console relay
Deprecated: Return type of Friendica\App\Page::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/App/Page.php on line 128
Deprecated: Return type of Friendica\App\Page::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/App/Page.php on line 145
Deprecated: Return type of Friendica\App\Page::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/App/Page.php on line 165
Deprecated: Return type of Friendica\App\Page::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/App/Page.php on line 182
Deprecated: Return type of Friendica\Model\Log\ParsedLogIterator::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/Model/Log/ParsedLogIterator.php on line 205
Deprecated: Return type of Friendica\Model\Log\ParsedLogIterator::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/Model/Log/ParsedLogIterator.php on line 163
Deprecated: Return type of Friendica\Model\Log\ParsedLogIterator::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/Model/Log/ParsedLogIterator.php on line 194
Deprecated: Return type of Friendica\Model\Log\ParsedLogIterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/Model/Log/ParsedLogIterator.php on line 216
Deprecated: Return type of Friendica\Model\Log\ParsedLogIterator::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /solchefreu.de/httpdocs/friendica/src/Model/Log/ParsedLogIterator.php on line 180
Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /solchefreu.de/httpdocs/friendica/src/Database/Database.php on line 108
Fatal error: Uncaught Exception: Missing database structure config file static/dbstructure.config.php in /solchefreu.de/httpdocs/friendica/src/Database/DBStructure.php:306
Stack trace:
#0 /solchefreu.de/httpdocs/friendica/src/Database/Database.php(87): Friendica\Database\DBStructure::definition('/var/www/vhosts...', false)
#1 [internal function]: Friendica\Database\Database->__construct(Object(Friendica\Core\Config\ValueObject\Cache), Object(Friendica\Util\Profiler), Object(Psr\Log\NullLogger))
#2 /solchefreu.de/httpdocs/friendica/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs(Object(Friendica\Database\Database), Array)
#3 /solchefreu.de/httpdocs/friendica/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}(Array, Array)
#4 /solchefreu.de/httpdocs/friendica/vendor/level-2/dice/Dice.php(247): Dice\Dice->create('Friendica\\Datab...', Array, Array)
#5 /solchefreu.de/httpdocs/friendica/vendor/level-2/dice/Dice.php(149): Dice\Dice->Dice\{closure}(Array, Array)
#6 /solchefreu.de/httpdocs/friendica/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}(Array, Array)
#7 /solchefreu.de/httpdocs/friendica/bin/console.php(36): Dice\Dice->create('Psr\\Log\\LoggerI...')
#8 {main}
thrown in /solchefreu.de/httpdocs/friendica/src/Database/DBStructure.php on line 306
what was the reason for this error when deleting a user?
Exception thrown in /var/www/src/App/BaseURL.php:451
Stack trace:
#0 /var/www/src/BaseModule.php(189): Friendica\App\BaseURL->redirect()
#1 /var/www/src/Module/Admin/Users/Index.php(89): Friendica\BaseModule::checkFormSecurityTokenRedirectOnError()
#2 [internal function]: Friendica\Module\Admin\Users\Index::content()
#3 /var/www/src/App/Page.php(333): call_user_func()
#4 /var/www/src/App/Page.php(390): Friendica\App\Page->initContent()
#5 /var/www/src/App.php(707): Friendica\App\Page->run()
#6 /var/www/index.php(42): Friendica\App->runFrontend()
#7 {main}
I forgot it again...
PHP Error
ist das folgende etwas, was für den RC von Bedeutung sein könnte, oder ist da einfach ein Post nicht ganz in Ordnung gewesen?
PHP Fatal error: Uncaught GuzzleHttp\Exception\TransferException: Could not retrieve headers in /var/www/src/Network/HTTPClient.php:223
Stack trace:
#0 /var/www/src/Protocol/Feed.php(300): Friendica\Network\HTTPClient->finalUrl('https://mastodo...')
#1 /var/www/src/Network/Probe.php(1871): Friendica\Protocol\Feed::import('<?xml version="...')
#2 /var/www/src/Network/Probe.php(1884): Friendica\Network\Probe::feed('https://mastodo...', false)
#3 /var/www/src/Network/Probe.php(757): Friendica\Network\Probe::feed('https://mastodo...')
#4 /var/www/src/Network/Probe.php(357): Friendica\Network\Probe::detect('https://mastodo...', '', 0, Array)
#5 /var/www/src/Model/Contact.php(2048): Friendica\Network\Probe::uri('https://mastodo...', '', 0)
#6 /var/www/src/Worker/UpdateContact.php(35): Friendica\Model\Contact::updateFromProbe(8774)
#7 [internal function]: Friendica\Worker\UpdateContact::execute(8774)
#8 /var/www/src/Core/Worker.php(458): call_user_func_array('Friendica\\Worke...', Array)
in /var/www/src/Network/HTTPClient.php on line 223
Internal Server Error → squeet.me/dfrn_request
'https://squeet.me/dfrn_request/jesuisatirebitpickup&addr=6269747069636b75704066656469766572732e747570616d6261652e636f6d is not a relative path, please use System::externalRedirectTo
Exception thrown in /var/www/virtual/../htdocs/src/App/BaseURL.php:451
Stack trace:
#0 /var/www/virtual/../htdocs/src/Model/Contact.php(2198): Friendica\App\BaseURL->redirect()
#1 /var/www/virtual/../htdocs/mod/follow.php(188): Friendica\Model\Contact::createFromProbe()
#2 /var/www/virtual/../htdocs/mod/follow.php(125): follow_process()
#3 /var/www/virtual/../htdocs/src/LegacyModule.php(90): follow_content()
#4 /var/www/virtual/../htdocs/src/LegacyModule.php(64): Friendica\LegacyModule::runModuleFunction()
#5 [internal function]: Friendica\LegacyModule::content()
#6 /var/www/virtual/../htdocs/src/App/Page.php(332): call_user_func()
#7 /var/www/virtual/../src/App/Page.php(389): Friendica\App\Page->initContent()
#8 /var/www/virtual/../src/App.php(562): Friendica\App\Page->run()
#9 /var/www/virtual/../index.php(40): Friendica\App->runFrontend()
#10 {main}