installing friendica 2021.01 on shared hosting

@Friendica Support

https://github.com/friendica/friendica/releases/tag/2021.01

downloads
full-2021.01.tar.gz
friendica-addons 2021.01.tar.gz

The files were unpacked and uploaded via ftp to the server.

The initial install check page displays only one issue.
ImageMagick PHP:

No está instalada la extensión ImageMagick PHP - Optional requirement not satisfied

Activating display PHP errors the following warning message is displayed:

Warning: shell_exec() has been disabled for security reasons in /var/www/virtual/../htdocs/src/Core/Install

@Friendica Support

This entry was edited (3 years ago)

Roland Häder likes this.

Friendica Support reshared this.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

Can't call any profile page or post something.
Admin panel and settings panel seem to work well.

/profile/admin

Exception thrown in /var/www/virtual/ .. /htdocs/src/Module/Profile/Status.php:57
Stack trace:
#0 /var/www/virtual/../htdocs/src/Module/Profile/Index.php(44): Friendica\Module\Profile\Status::content()
#1 [internal function]: Friendica\Module\Profile\Index::content()
#2 /var/www/virtual/.. /htdocs/src/App/Page.php(332): call_user_func()
#3 /var/www/virtual/.. /htdocs/src/App/Page.php(389): Friendica\App\Page->initContent()
#4 /var/www/virtual/ .. /htdocs/src/App.php(562): Friendica\App\Page->run()
#5 /var/www/virtual/.. /htdocs/index.php(40): Friendica\App->runFrontend()
#6 {main}

#5 #4 #1 #2 #3 #6

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

The admin panel for users counts 3 users but doesn't display any of them.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

Can't call any profile page or post something.

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

No line above.

In the admin panel there is the following line:

Notice: Trying to access array offset on value of type bool in /var/www/virtual/tupambae.net/tupambae.com/fedivers/htdocs/src/Database/Database.php on line 1610

Notice: Trying to access array offset on value of type bool in /var/www/virtual/tupambae.net/tupambae.com/fedivers/htdocs/src/Database/Database.php on line 1610
logoFriendica

PHP Version 7.4.21

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

Trying to activate:
Administration - Logs
Enable Debugging

/admin/logs/view says:

Error trying to open <strong>log/friendica.log</strong> log file.\r\n<br/>Check to see if file log/friendica.log exist and is readable.

Should I create a folder /log and he respective friendica.log?

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

Just created the log file, first entry:

2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectFirst, User::getOwnerDataById, Profile::load, Status::content, Index::content, call_user_func, Page::initContent, Page::run","params":"SELECT * FROM `owner-view` WHERE (`uid` = 2) LIMIT 1"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}
2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}

@Tobias

some more log file entries:

2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectFirst, User::getOwnerDataById, Profile::load, Status::content, Index::content, call_user_func, Page::initContent, Page::run","params":"SELECT * FROM `owner-view` WHERE (`uid` = 2) LIMIT 1"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}
2021-07-22T13:04:41Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"b847b3","process_id":18245}
2021-07-22T13:05:01Z index [NOTICE]: no data for session {"session_id":"utnoe5qtf85oj838rrjv32tanv","uri":"\/worker"} - {"file":"Database.php","line":72,"function":"read","uid":"43c183","process_id":18245}
2021-07-22T13:06:21Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, Network::getItems, Network::content, call_user_func, Page::initContent, Page::run, App::runFrontend","params":"SELECT * FROM `network-thread-view` WHERE (`uid` = 2) ORDER BY `received` DESC LIMIT 40"} - {"file":"Database.php","line":662,"function":"p","uid":"286044","process_id":18245}
2021-07-22T13:06:21Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"286044","process_id":18245}
2021-07-22T13:06:24Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, Network::getItems, Network::rawContent, call_user_func, Module::run, App::runFrontend","params":"SELECT * FROM `network-item-view` WHERE (`unseen` = 1 AND `gravity` = 0 AND `uid` = 2) ORDER BY `received` DESC LIMIT 100"} - {"file":"Database.php","line":662,"function":"p","uid":"32e0cc","process_id":18245}
2021-07-22T13:06:25Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectFirst, User::getOwnerDataById, Profile::load, Status::content, Index::content, call_user_func, Page::initContent, Page::run","params":"SELECT * FROM `owner-view` WHERE (`uid` = 2) LIMIT 1"} - {"file":"Database.php","line":662,"function":"p","uid":"0de3be","process_id":18245}
2021-07-22T13:06:25Z index [ERROR]: DB Error {"code":1615,"error":"Prepared statement needs to be re-prepared","callstack":"DBA::selectToArray, vier_community_info, vier_init, Page::run, App::runFrontend","params":"SELECT * FROM `owner-view` WHERE (`blocked` = 0 AND `publish` = 1) ORDER BY `register_date` DESC LIMIT 0, 9"} - {"file":"Database.php","line":662,"function":"p","uid":"0de3be","process_id":18245}

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

In the admin panel the one I posted first.
The other debug info is from the log file:

Just created the log file, first entry:

@Tobias

Michael Vogel

3 years ago •

'pdo_emulate_prepares' => true,

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Michael Vogel@Tobias

'pdo_emulate_prepares' => true,

¿?
Where do I find this to set it?
I guess in the DB?
Where?

@Michael Vogel @Tobias

Adam

3 years ago •

I believe in your friendica config file - might be config/local.config.php (it's what I'm still using but the location changed over the years). In the 'database' section, you'd want the line @Michael Vogel suggested.

@Michael Vogel

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup likes this.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Adam@Tobias

¿Something like this @Michael Vogel ?

local.config.php

	'database' => [
		'hostname' => 'localhost',
		'username' => 'xxxx',
		'password' => 'xxxxx',
		'database' => 'xxxxxx',
		'charset' => 'utf8mb4',
                'pdo_emulate_prepares' => true,
	],

@Michael Vogel @Adam @Tobias

Anubis2814 reshared this.

Adam

3 years ago •

That's my understanding... have you tried it?

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Adam
Nope, waiting for a thumbs up by the boss ..

@Adam

Michael Vogel

3 years ago •

Yes. This might work. But in that version the feature was new and I'm not very confident that it worked well.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Michael Vogel@Tobias@Adam

oks
I will check it out than and give a report.

btw
My idea is to use git.friendi.ca to kinda publish a fork of this last worker in admin version of friendica as a shared host option fork "as is", without further mayor updates or ongoing coding efforts/development. Unless important security issues come up that need to be integrated of course.
"Worst case scenario" a hoster specific friendica version.

It has still dfrn and already activitypub integration so it might be in part kinda last dfrn stable version.

In other words, besides other issues that might come up, any fine tuning hints are welcomed!

@Michael Vogel @Adam @Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Michael Vogel@Tobias@Adam

looks good!

@Michael Vogel @Adam @Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

Error message trying to follow this profile over here → System::externalRedirectTo

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

#5 #4 #1 #2 #3 #9 #8 #6 #7 #10

Michael Vogel

3 years ago •

Try to follow the other direction. Maybe this works.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Michael Vogel

Apparently, on a first glimps, it does ..

@Michael Vogel

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

The profile itself seems to ignore that fact and still offers to follow this profile over here ..

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Hypolite Petovan@Michael Vogel@Tobias

What is System::externalRedirectTo about?

I searched on github and found basically two issues where certain discussion on it goes on:

src/App/BaseURL.php
22 Oct 2018
https://github.com/friendica/friendica/pull/5907
https://github.com/friendica/friendica/issues/5996

I didn't experience any problem with this with friendica2019.12
What has changed that this problem pops up now?

Are there possibilities to work around this problem via .htaccess?

@Hypolite Petovan @Michael Vogel @Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Michael Vogel@Hypolite Petovan@Tobias

Trying to follow a profile on the same instance:
https://subdoman.domain.com/follow?url=https%3A%2F%2Fsubdomain.domain.com%2Fprofile%2Fadmin&auto=1

/admin&addr=6269747069636b75704066656469766572732e747570616d6261652e636f6d is not a relative path, please use System::externalRedirectTo

@Hypolite Petovan @Michael Vogel @Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

Notifications for new comments in posts doesn't work.
Notification for mentions in comments doesn't work.

Pictures and album administration works.

Deleting comments works.
(doesn't work for now in this environment in friendica 2021.04)

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

It is the PHP setting display_errors that should be 0

Where do I find that?

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

I'm on a shared hosting, no access to /etc/php...

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

Why apache2?
Isn't .htaccess something that always works?

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

Right.
But why 2?
Isn't that true for apache(1) too?

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

Admin panel advise on top:

Your table_definition_cache is too low (400). This can lead to the database error "Prepared statement needs to be re-prepared". Please set it at least to 1400 (or -1 for autosizing). See here for more information.

The worker was never executed. Please check your database structure!

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

I contacted the provider about the worker issues and he stated that:

-rw-r----- worker.php
this is not an executable file.
----------------------------------------
> Just to make sure,
> that means the permisons set for the worker.php files are wrong ¡?
----------------------------------------
Yes, the file must be executable to be executed. You should look up the recommended permissions for this file in documentation and let us know. We will help you fixing permissions if you need.

Didn't find any permissions settings for worker.php
How should they be set?

elrido

3 years ago •

Well, if it needs to be executable for their cron to work, make it executable: If you have remote shell access it would be the command "chmod +x worker.php" (+x tells it to add the executable bit to owner, group and others). If you have some other type of access, like an (S)FTP client, you would need to look at the documentation of that tool to see how to do that.

Finally, as an alternative, if you can't figure out how to make it executable, you can use the (already executable) php binary to call the worker. In the cronjob, you would then give the absolute path to the php binary, space, then the absolute path to your worker.php. For example if your php binary were to live at /usr/bin/php7 (that path is something you need to look up in your hosters documentation) and the worker would be /var/www/hostname/friendica/bin/worker.php (the PHP-Info page in the Friendica administration should let you deduce that path) then the resulting full cronjob command would be "/usr/bin/php7 /var/www/hostname/friendica/bin/worker.php".

Please do keep in mind that:
- the worker.php prov... show more

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@elrido

some how the CHMOD permissions where set to 644

changed to 755
thx

@elrido

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias
I guess there is no problem than and I don't need to ask my provider or check some how else.
I remember we used .htaccess when I installed friendica a decade ago for the first time when your friendica instance was like the first time I hoped onto friendica so it worked than too.

@Tobias

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

This ..
is ..

mindblowing

I uploaded fullfriendica2020.07-1 and fullfriendica2020.09-1 to the server the same way I did with the version above (2021.01) and that takes like hours and hours via ftp and get 404 blank pages when calling:
/install

Click to open/close

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

So ..
first of all all friendica2020.09-1 work's but is slow and nearly unresponsive because of never ending loop like waiting times.

2021.01
Diaspora connection works without dfrn redirects so with kinda backfliploop workaround here the new account 2021.01 testserver:

bitPickup

2021-07-25 07:38:13

a ver

Astonishingly squeet.me says on this page that this account here follows that account over there.
When trying to visite redirect gives https://squeet.me/redir/1876762 bas request.

Is dfrn already skipped over here?
I guess not.

Michael Vogel

3 years ago •

Your system doesn't allow background tasks, so everything is executed in the frontend. This will most likely cause this slow behaviour.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Michael Vogel

Yes.
I'm testing around the settings options and enabled the front end worker option in the /admin/settings and am testing if the fast lane option works.

btw
Some parts talk about /htdocs/worker and others (or I got that wrong) refer for the external worker to be set as https://subdomain.domain.com/bin/worker.php

These are basically the different worker setups?

[.. ups looks like the site is down ..]
…ᘛ⁐̤ᕐᐷ

@Michael Vogel

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

Astonishingly squeet.me says on this page that this account here follows that account over there.

Somehow the connection seems to work, starting to test what interactions work …ᘛ⁐̤ᕐᐷ

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

https://1dhfsbbdpv4wshuyc6197nymcfeqqkfvy9.tupambae.org/.well-known/host-meta is not reachable on your system. This is a severe configuration issue that prevents server to server communication. See the installation page for help.

I looked out at github the friendica help section and elsewhere but couldn't find help or hints.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

/admin wrote:

Your table_definition_cache is too low (400). This can lead to the database error "Prepared statement needs to be re-prepared". Please set it at least to 1400 (or -1 for autosizing). See here for more information.

I looked out at github the friendica help section and elsewhere but couldn't find help or hints.

…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup

3 years ago •

@Tobias

table_definition_cache

Where do I find that setting or set it in some php file?

@Tobias

⇧