!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!

Uppsi.
The Server works so far, but going to /admon/site throws an error:
---
Service Unavailable

unable to create directory /var/www/friendica/view/smarty3/compiled/58/70/d1

Exception thrown in /var/www/friendica/src/Core/Renderer.php:90
Stack trace:
#0 /var/www/friendica/src/Module/Admin/Site.php(592): Friendica\Core\Renderer::replaceMacros('file:/var/www/f...', Array)
#1 /var/www/friendica/src/BaseModule.php(250): Friendica\Module\Admin\Site->content(Array)
#2 /var/www/friendica/src/App.php(711): Friendica\BaseModule->run(Object(Friendica\Module\Special\HTTPException), Array)
#3 /var/www/friendica/index.php(55): Friendica\App->runFrontend(Object(Friendica\App\Router), Object(Friendica\Core\PConfig\Type\JitPConfig), Object(Friendica\Security\Authentication), Object(Friendica\App\Page), Object(Friendica\Content\Nav), Object(Friendica\Module\Special\HTTPException), Object(Friendica\Util\HTTPInputData), 1702744026.4542, Array)
#4 {main}

Request: 657dcfda7165b
---
BTW. Sorry for not using some formatting (e.g., for code), but currently, I'm running from a live Slax on an ancient laptop with an exotic German keyboard.

New error message (of FRIO) about a folder created by the user root.

I haven't found the extensive conversation about this problem with @Hypolite Petovan yet but I'm quite sure that I changed all folders to ownership of user www-data before 28th of November of the smarty folder. Actually there was another conversation about ownership of folders and I changed all folders to be owned by root except storage and view that day on 02:45hs, the new folder owned by root at /view/smarty3/compiled/ like stated below was created on 3:50hs.

As for what I remember of all the conversations this shouldn't have happened.

<?php
/* Smarty version 4.3.1, created on 2023-11-28 03:50:02
  from '7cd2693513597460a71347ba02d3179c5e5ab822' */
/* @var Smarty_Internal_Template $_smarty_tpl */
if ($_smarty_tpl->_decodeProperties($_smarty_tpl, array (
  'version' => '4.3.1',
  'unifunc' => 'content_6565636a645732_50647552',
  'has_nocache_code' => false,
  'file_dependency' => 
  array (
  ),
  'includes' => 
  array (
  ),
),false)) {
function content_6565636a645732_50647552 (Smarty_Internal_Template $_smarty_tpl) {
?>[url=https://tupambae.org/profile/utopiarte]utopiArte[/url] replied to you on [url=https://tupambae.org/display/0ac89072-1065-6562-6405-8bb240314547]"bugreport - can't answer, like or reshare posts"[/url]<?p>

utopiArte

2023-11-28 03:45:40

> bugreport - can't answer, like or reshare posts

Somehow this is still happening, the profile tutorial can't reply on standard posts of admin or utopiarte.

admin profile trouble
#bugResearch

I didn't have a look at gitHub

--

information for dev and server team:
The only error that is printed in the error log file every once in a while is:

@Friendica Support

#bugResearch

hi there, I have this message in my php.error.log

what should I do?

I didn't have a look at gitHub

I made my first Android app. Well, I didn’t write it from scratch, I took an open source camera app and just renamed and modified it a bit, and rebuilt it.

I called it Trax Cam.

It is a fork of Open Camera. The initial, test version of Trax Cam makes just two small improvements over Open Camera:

• (old)
• Trax Cam
• (old)
• Trax Cam

1. improving the visual difference of the shutter buttons between video and photo mode, recording and not recording, by contrasting colour and style;
2. not forgetting the zoom level when temporarily switching to another app and back, switching between photo and video modes, and the like.

Impressive? Is this everything you have ever wanted from a camera app? No, I didn’t think so. That’s not the point of it. Dear reader, it’s not for you. Not yet, anyway. Sorry!

Trax Cam is not yet intended as a product for ordinary users. Rather, the purpose of this project, at least initially, is as a learning exercise for me. The status of it, at the time of writing, is it is stable, being based on a stable version of Open Camera, and I am running it as my main camera app on two different phones, but I am not committing to making further fixes or updates. I might or might not continue developing or updating it. Switching to other projects will give me a broader and probably more useful learning experience.

Default Camera for /E/-OS

/e/-foundation‘s /e/-OS comes with OpenCamera as its default camera app. I had previously installed OpenCamera on my main LineageOS-powered phone, alongside the default LineageOS camera code-named ‘snap’.

I would sometimes switch between OpenCamera and ‘snap’. I like different things about them, mainly the range of options in OpenCamera and the simplicity of ‘snap’, with neither of them managing to bring the best possible combination, and both still having annoyances and room for improvement.

It was while evaluating /e/ that I noticed again several of the shortcomings of OpenCamera, and decided it could be time for me to do something about it. I had some ideas noted in my head, and have now written them down in a bug tracker.

Trax Cam Issues: https://lab.trax.im/trax.im/traxcam/-/issues . Issue #1 is Remember my zoom level , #2 is Boldly indicate photo/video/recording states (both still “open” as I am not satisfied that I have yet completed them as well as could be done), and I have opened several more.

At the same time, I discovered /e/-foundation is recruiting among other positions a Camera developer: “[You want] to make open source camera apps as good as high-end camera apps?” (If you are an “experienced (5+ years) Android developer”, check it out.) It’s good to see that /e/-foundation recognizes the need and seems to have some resources to tackle it.

In my opinion, one thing /e/ could do to encourage volunteer developers to develop OpenCamera (or another) in a useful direction for /e/ and other libre Android uses, would be to publish a road map or a prioritization of issues for what they consider needs to be done. I feel that projects providing a summary of what they want done is often missing and often a surprisingly effective driver in open source development. Developers tend to be quicker and more efficient at implementing something that is at least loosely specified (along with rationale to explain why) than creating something that they need to invent from scratch.

Comparing with Other Cameras

Besides OpenCamera and Lineage ‘snap’ I also briefly tried FreeDCam and OxygenOS camera (proprietary). Those each have some very slick UI designs which bear studying and would be nice to bring in. In particular, if I recall correctly they both use swipe to review the last and earlier taken pictures, which seems to me more intuitive and easier to use.

I noticed the OxygenOS camera used slick-looking rotary dials for analogue settings such as exposure compensation. I really liked this at first sight. In use, I found their behaviour a bit fussy and skiddy, easy to leave it on a random in-between value, hard to return quickly to the previously used value. It would be great if we could create something along those lines of analogue beauty, but with more positive and robust behaviour to set and leave a desired value. For example, I think it is common and so needs to be easy to switch between “auto” and the last used non-auto value. (Not just for camera controls, indeed, but for all kinds of settings in all apps.)

Available on My F-Droid App Store

You can try out Trax Cam if you like, even though it is not (currently) aimed at general use. https://fdroid.foad.me.uk/fdroid/repo/im.trax.cam_80.apk is a direct link to the installer file for my initial test version. It’s not published on Google Play store. You will need your “install from unknown sources” option enabled in Android settings.

I also put up my own F-Droid app store, and put Trax Cam up on it, so we can install it on phones through the f-droid app. This too is not currently intended for general end users. However, you are welcome to try it. First install the f-droid app (https://f-droid.org/), then add my repository’s URL (https://fdroid.foad.me.uk) under settings, repositories, add.

If you are unfamiliar with F-Droid, it comprises:

• an Open/Libre app store system by which anyone can set up and serve their own app repository, and anyone can browse and install apps from such repositories; and
• the F-Droid app, for browsing and installing apps from any such repositories; and
• a repository of Free/Libre apps for Android, which is the default repository that the F-Droid app connects to until you tell it about other ones.

Putting up my own app store is part of my ambition to support independent creation of free/libre software and self-owned services.

https://blog.foad.me.uk/2021/05/11/introducing-trax-cam/

Julian Foad

2021-05-11 21:04:46

I made my first Android app. Well, I didn’t write it from scratch, I took an open source camera app and just renamed and modified it a bit, and rebuilt it.

I called it Trax Cam.

It is a fork of Open Camera. The initial, test version of Trax Cam makes just two small improvements over Open Camera:

• (old)
• Trax Cam
• (old)
• Trax Cam

1. improving the visual difference of the shutter buttons between video and photo mode, recording and not recording, by contrasting colour and style;
2. not forgetting the zoom level when temporarily switching to another app and back, switching between photo and video modes, and the like.

Impressive? Is this everything you have ever wanted from a camera app? No, I didn’t think so. That’s not the point of it. Dear reader, it’s not for you. Not yet, anyway. Sorry!

Trax Cam is not yet intended as a product for ordinary users. Rather, the purpose of this project, at least initially, is as a learning exercise for me. The status of it, at the time of writing, is it is stable, being based on a stable version of Open Camera, and I am running it as my main camera app on two different phones, but I am not committing to making further fixes or updates. I might or might not continue developing or updating it. Switching to other projects will give me a broader and probably more useful learning experience.

Default Camera for /E/-OS

/e/-foundation‘s /e/-OS comes with OpenCamera as its default camera app. I had previously installed OpenCamera on my main LineageOS-powered phone, alongside the default LineageOS camera code-named ‘snap’.

I would sometimes switch between OpenCamera and ‘snap’. I like different things about them, mainly the range of options in OpenCamera and the simplicity of ‘snap’, with neither of them managing to bring the best possible combination, and both still having annoyances and room for improvement.

It was while evaluating /e/ that I noticed again several of the shortcomings of OpenCamera, and decided it could be time for me to do something about it. I had some ideas noted in my head, and have now written them down in a bug tracker.

Trax Cam Issues: https://lab.trax.im/trax.im/traxcam/-/issues . Issue #1 is Remember my zoom level , #2 is Boldly indicate photo/video/recording states (both still “open” as I am not satisfied that I have yet completed them as well as could be done), and I have opened several more.

At the same time, I discovered /e/-foundation is recruiting among other positions a Camera developer: “[You want] to make open source camera apps as good as high-end camera apps?” (If you are an “experienced (5+ years) Android developer”, check it out.) It’s good to see that /e/-foundation recognizes the need and seems to have some resources to tackle it.

In my opinion, one thing /e/ could do to encourage volunteer developers to develop OpenCamera (or another) in a useful direction for /e/ and other libre Android uses, would be to publish a road map or a prioritization of issues for what they consider needs to be done. I feel that projects providing a summary of what they want done is often missing and often a surprisingly effective driver in open source development. Developers tend to be quicker and more efficient at implementing something that is at least loosely specified (along with rationale to explain why) than creating something that they need to invent from scratch.

Comparing with Other Cameras

Besides OpenCamera and Lineage ‘snap’ I also briefly tried FreeDCam and OxygenOS camera (proprietary). Those each have some very slick UI designs which bear studying and would be nice to bring in. In particular, if I recall correctly they both use swipe to review the last and earlier taken pictures, which seems to me more intuitive and easier to use.

I noticed the OxygenOS camera used slick-looking rotary dials for analogue settings such as exposure compensation. I really liked this at first sight. In use, I found their behaviour a bit fussy and skiddy, easy to leave it on a random in-between value, hard to return quickly to the previously used value. It would be great if we could create something along those lines of analogue beauty, but with more positive and robust behaviour to set and leave a desired value. For example, I think it is common and so needs to be easy to switch between “auto” and the last used non-auto value. (Not just for camera controls, indeed, but for all kinds of settings in all apps.)

Available on My F-Droid App Store

You can try out Trax Cam if you like, even though it is not (currently) aimed at general use. https://fdroid.foad.me.uk/fdroid/repo/im.trax.cam_80.apk is a direct link to the installer file for my initial test version. It’s not published on Google Play store. You will need your “install from unknown sources” option enabled in Android settings.

I also put up my own F-Droid app store, and put Trax Cam up on it, so we can install it on phones through the f-droid app. This too is not currently intended for general end users. However, you are welcome to try it. First install the f-droid app (https://f-droid.org/), then add my repository’s URL (https://fdroid.foad.me.uk) under settings, repositories, add.

If you are unfamiliar with F-Droid, it comprises:

• an Open/Libre app store system by which anyone can set up and serve their own app repository, and anyone can browse and install apps from such repositories; and
• the F-Droid app, for browsing and installing apps from any such repositories; and
• a repository of Free/Libre apps for Android, which is the default repository that the F-Droid app connects to until you tell it about other ones.

Putting up my own app store is part of my ambition to support independent creation of free/libre software and self-owned services.

https://blog.foad.me.uk/2021/05/11/introducing-trax-cam/

Issues · Trax / traxcam

Android camera based on Open Camera · Development repository · Introduction blog post

^GitLab

@utzer [Friendica]
smallest VPS:
VPS #1
1GB RAM
1 CPU
25GB DISK
1TB TRANSFER(tx+rx)

your recomandation:
VPS #4
8GB RAM
4 CPU
160GB DISK
5TB TRANSFER(tx+rx)

btw, this is what they state about the debian options:

OpenVPN
For freedom fighters
The only VPN to be trusted is the one you have full control over.
The server and client certificates are automatically generated and the client file sent via email to the customer after. Runs on port 443, which is almost always accessible. All logging is sent to /dev/null and DNS queries are made on the same server.

Wireguard
Also for freedom fighters
40-50% faster than OpenVPN.
Route all your traffic through an encrypted tunnel, perfect for bypassing internet controlled by a fascist government.

LEMP
Ready to use webserver
LEMP stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. It comes preconfigured with an optimized PHP setup which can run, depending on the size of the server, load heavy sites. It is also good as a content delivery server for example advertisement banners, videos, or even a fileserver for files to download.

Nextcloud Server
Ready to use Nextcloud
Run your own cloud service.
Nextcloud, the next generation open source Enterprise File Sync and Share software, the server is optimized for high usage with Let's Encrypt https certificate.

@bitPickup mʕ•ﻌ•ʔm @Hank G ☑️ @Raroun @TupambAdmin

post warning: child abuse, government refusal to accept help:

since 2021 I've tried to prevent CSAM on Poast, we have reached out to NCMEC multiple times including through Cloudflare in 2022:

poa.st/@graf/posts/AFcUm2ZycTmRk3XeDI

they refuse to allow Poast access to scan every user upload on the basis poast is "registered in canada" despite ALL of our user generating hardware being in the united states. we aren't allowed to use the biggest database of CSAM to scan our user uploads against because I'm Canadian and it's illegal for anybody to have a database of hashes to even provide a 3rd party free database of literal letters and numbers. you're not allowed to prevent CSAM materials without permission and if you try to you need to give the government every piece of your ID possible and be registered to do it.

CSAM is the #1 crime worldwide
your government subsidizes this
so does mine

anime graf mays 🛰️🪐

2022-01-20 04:08:09

i was weighing or not i would make a post on this but i think in the interest of protecting children this really needs to be outlined

Poast has been trying since the fall to utilize cloudflare's automated CSAM scan function that they are walling off behind a login from NCMEC

our goal is simple, we want to prevent or deter people from uploading CSAM materials that can be then distributed from Poast -- something a normal reasonable person should want to involve themselves in if they are operating a social media site, let alone one with notoriety like poast is quickly gaining

over a month passed from the time poast registered and Erin Hunter responded with the default "welcome we need you to fill out this form blabla" as seen in image #1

image #2, a month later she responds that NCMEC can't help us as our platform is registered in canada, despite none of our hardware existing in canada -- because the name poast is registered here we can't use NCMEC. we reply back and forth about poast's root servers being in San Diego, Piscataway and Newark

this banter of her telling us we cant use NCMEC to report child pornography because Poast has a Canadian registration goes back and forth and it's become clear to me/us that NCMEC doesn't care about the child porn reports as much as they do about bureaucratic white tape

this becomes majorly apparent when this woman refuses to accept responsibility and tags cloudflare representatives in to tell me NCMEC doesnt want to deal with us

NCMEC doesn't want to prevent the spread of child porn because of red tape they had to call in cloudflare to explain

NCMEC refused to allow us access to compare hashes of images uploaded to poast because I registered poast in canada

they don't care about protecting children or preventing the spread of child pornography. at all. and if you try to tell me they do you're a fucking retard full stop

i was weighing or not i would make a post on this but i think in the interest of protecting children this really needs to be outlined

Poast has been trying since the fall to utilize cloudflare's automated CSAM scan function that they are walling off behind a login from NCMEC

our goal is simple, we want to prevent or deter people from uploading CSAM materials that can be then distributed from Poast -- something a normal reasonable person should want to involve themselves in if they are operating a social media site, let alone one with notoriety like poast is quickly gaining

over a month passed from the time poast registered and Erin Hunter responded with the default "welcome we need you to fill out this form blabla" as seen in image #1

image #2, a month later she responds that NCMEC can't help us as our platform is registered in canada, despite none of our hardware existing in canada -- because the name poast is registered here we can't use NCMEC. we reply back and forth about poast's root servers being in San Diego, Piscataway and Newark

this banter of her telling us we cant use NCMEC to report child pornography because Poast has a Canadian registration goes back and forth and it's become clear to me/us that NCMEC doesn't care about the child porn reports as much as they do about bureaucratic white tape

this becomes majorly apparent when this woman refuses to accept responsibility and tags cloudflare representatives in to tell me NCMEC doesnt want to deal with us

NCMEC doesn't want to prevent the spread of child porn because of red tape they had to call in cloudflare to explain

NCMEC refused to allow us access to compare hashes of images uploaded to poast because I registered poast in canada

they don't care about protecting children or preventing the spread of child pornography. at all. and if you try to tell me they do you're a fucking retard full stop

@Hypolite Petovan Hello. After lots more testing today, i now have 50% happy news!

1. I've still never succeeded in receiving a DM in Masto that was sent from Friendica [both libranet.de AND a new venera.social account i made today], if i use the 4-tab popup post-composer windowlet, with my Masto handle listed in the Permissions tab as a Private Message. Every single time, the DM appears to Send ok from Friendica, but it simply never arrives in Masto. Otoh...
2. Finally i have succeeded in sending DMs that DO arrive in Masto, using the Friendica "Envelope Icon" toolbar shortcut to https://libranet.de/message. The solution was exasperatingly simple, yet completely obscure to me for 36 hours coz i was relentlessly just blindly following posting "the Masto way", unaware that this is wrong in Friendica. Specifically in https://libranet.de/message, each previous time that i had tried unsuccessfully to send a DM, i had prefaced my Masto handle with "@", because in Masto that IS part of the handle. It was only today that finally i decided to see what would happen if i omitted that leading "@", at which point i was delighted but astonished to see that finally the autodetect kicked in, it successfully matched my correct handle, & consequently all my DMs now DO properly Send from both my Friendica accounts, AND get received in my Masto account. Phew & thank bloody goodness, coz this was driving me batty!

I'm still disappointed that #1 does not work for me, but very happy that at least #2 does.

As such, this certainly eliminates any possibility that my problem [#1 OR #2] might have been caused by a bug in the Dev version [libranet.de], given that i proved today that the problem equally occurred in the Stable version [venera.social] ... and now i know how to avoid/solve #2.

Thank you all for helping, & sorry that i was such a slow learner.

!Friendica Support
https://wiki.friendi.ca/docs/install
So I am stuck at the create a database point. I can't tell if they just told me, create a database without telling me how or if this helped create a database. I went with B and here were the resutls. Are there peices missing or are these warnings ok for the system we are using?

$ bin/console autoinstall -v
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
Executable: /home/anubis2814/mywebsite/bin/console.php
Arguments: array (
0 => 'autoinstall',
)
Options: array (
'v' => 1,
)
Command: autoinstall
Initializing setup...
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
Complete!

Checking environment...
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
NOTICE: Not checking .htaccess/URL-Rewrite during CLI installation.

[Error] --------
GNU Multiple Precision PHP module: Error: GNU Multiple Precision PHP module required but not installed.

[Backtrace]:
#0 /home/anubis2814/mywebsite/vendor/asika/simple-console/src/Console.php(108): Friendica\Console\AutomaticInstallation->doExecute()
#1 /home/anubis2814/mywebsite/src/Core/Console.php(163): Asika\SimpleConsole\Console->execute()
#2 /home/anubis2814/mywebsite/vendor/asika/simple-console/src/Console.php(108): Friendica\Core\Console->doExecute()
#3 /home/anubis2814/mywebsite/bin/console.php(41): Asika\SimpleConsole\Console->execute()
#4 {main}