-
Posts
9521 -
Joined
-
Last visited
-
Days Won
41
Community Answers
-
d00p's post in PHP 8.1 installieren was marked as the answer
du hast ja auch php-fpm installiert und nicht php-cgi....
-
d00p's post in Fehler bei Updatecheck und Newsfeed was marked as the answer
OS? Version? ca-certificates version? scheint mir einfach veraltete pakete zu sein, habe hier auf einigen servern absolut kein problem mit den certificates
-
d00p's post in Fresh Install Debian 11 was marked as the answer
Noch ungetestet, aber probiers mal mit folgendem Patch in der install/lib/class.FroxlorInstall.php
diff --git a/install/lib/class.FroxlorInstall.php b/install/lib/class.FroxlorInstall.php index 30855bfa..b30f9ed0 100644 --- a/install/lib/class.FroxlorInstall.php +++ b/install/lib/class.FroxlorInstall.php @@ -734,8 +734,26 @@ class FroxlorInstall private function _grantDbPrivilegesTo(&$db_root, $database, $username, $password, $access_host) { + // mariadb + if (version_compare($db_root->getAttribute(\PDO::ATTR_SERVER_VERSION), '10.0.0', '>=')) { + // create user + $stmt = $db_root->prepare(" + CREATE USER '" . $username . "'@'" . $access_host . "' IDENTIFIED BY :password + "); + $stmt->execute(array( + "password" => $password + )); + // grant privileges + $stmt = $db_root->prepare(" + GRANT ALL ON `" . $database . "`.* TO :username@:host + "); + $stmt->execute(array( + "username" => $username, + "host" => $access_host + )); + } // mysql8 compatibility - if (version_compare($db_root->getAttribute(\PDO::ATTR_SERVER_VERSION), '8.0.11', '>=')) { + elseif (version_compare($db_root->getAttribute(\PDO::ATTR_SERVER_VERSION), '8.0.11', '>=')) { // create user $stmt = $db_root->prepare(" CREATE USER '" . $username . "'@'" . $access_host . "' IDENTIFIED WITH mysql_native_password BY :password
-
d00p's post in Fresh Install Debian 11 was marked as the answer
Okay, hier herrschen wohl doch größere Unterschiede zwischen MariaDB und MySQL - muss ich fürs nächste release fixen.
MariaDB:
| IDENTIFIED {VIA|WITH} authentication_rule [OR authentication_rule ...] authentication_rule: authentication_plugin | authentication_plugin {USING|AS} 'authentication_string' | authentication_plugin {USING|AS} PASSWORD('password') MySQL:
| IDENTIFIED WITH auth_plugin BY 'auth_string' [AND 2fa_auth_option] | IDENTIFIED WITH auth_plugin BY RANDOM PASSWORD [AND 2fa_auth_option] | IDENTIFIED WITH auth_plugin AS 'auth_string' [AND 2fa_auth_option] > For syntax that uses BY 'auth_string', the string is cleartext and is passed to the authentication plugin for possible hashing. > For syntax that uses AS 'auth_string', the string is assumed to be already in the format the authentication plugin requires das "BY" war mal das was bei beiden funktioniert hatte...offenbar nicht mehr
-
d00p's post in Fresh Install Debian 11 was marked as the answer
ja ich denke da wird man einfach verfolgen müssen wie sich die versionierung von mysql ergibt. Aktuell sollte das so kein problem sein. Ausgabe von "mysql --version" ist natürlich eine Möglichkeit setzt aber wieder voraus, dass ich das im installer (web!) überhaupt ausführen darf! + parsing
-
d00p's post in DKIM record for Domains was marked as the answer
No you don't have to. At this time, there are sadly no configuration templates for any dkim service. But with the given setting-opportunities, it should be fairly easy to get this running with opendkim or even rspamd, see the original issue from the underscore in selectors, there are some hints: https://github.com/Froxlor/Froxlor/issues/619
-
d00p's post in DKIM record for Domains was marked as the answer
so which service are you using that signes the emails? this does not happen automatically by enabling dkim in froxlor
-
d00p's post in DKIM record for Domains was marked as the answer
No you don't have to. At this time, there are sadly no configuration templates for any dkim service. But with the given setting-opportunities, it should be fairly easy to get this running with opendkim or even rspamd, see the original issue from the underscore in selectors, there are some hints: https://github.com/Froxlor/Froxlor/issues/619
-
d00p's post in Email accounts not showing after re-enabling mailboxs was marked as the answer
Try running "Recalculate resource usage" in the admin left-side menu
-
d00p's post in Adding multiple domain names to a single site was marked as the answer
Just assign the same documentroot?
-
d00p's post in Konsolidierung der Github Doku und der Froxlor Konfiguration was marked as the answer
https://froxlor.github.io/configuration/nginx/php-fpm
Der lokale user wird beim Konfigurieren der Dienste mit angelegt sofern er nicht existiert. Folge einfach den Konfigurations-Vorgaben für php-fpm, da sollte das dabei sein.
Sofern du libnss-extrausers nutzt statt libnss-mysql (und das solltest du! libnss-mysql ist ziemlich alt) brauchst du keinen nscd mehr - auch hier: die konfigurations-vorgaben beinhalten eigentlich alles was du brauchst
-
d00p's post in Email accounts not showing after re-enabling mailboxs was marked as the answer
Try running "Recalculate resource usage" in the admin left-side menu
-
d00p's post in Installationsschwierigkeiten von PHP-FPM mit Apache was marked as the answer
wenn du es über das config-services script gemacht hast brauchst du da eigentlich nix mehr installieren - voraussetzung ist natürlich das du vorher - so wie die anleitung es sagt - die Einstellungen alle entsprechend korrekt gesetzt hast!
libnss-extrausers ist was anderes als libnss-mysql !!! ich rate dringend libnss-extrausers zu nutzen, beachte das dafür die Option in den entsprechenden Einstellungen aktiviert sein muss.
Also:
1) Einstellungen komplett kontrollieren, alle gewünschten Dienste aktivieren (wie z.B. php-fpm, libnss-extrausers, etc.).
2) config-services ausführen oder ggfls manuell als admin -> Configuration -> distro wählen -> dienst wählen -> etc. -> befehle anschauen, kopieren und auf der shell ausführen
-
d00p's post in How do I enable allow_url_fopen? was marked as the answer
admin -> PHP-configurations -> edit the php config you want to enable this for in field php.ini settings -> save and wait for cron
-
d00p's post in nscd invalidiert nicht die Gruppen was marked as the answer
Mit libnss-extrausers brauchst du kein nscd...kannst du einfach löschen, er liest die User und Gruppen ja über Textfiles genau wie das System.
-
d00p's post in vHost PHP disabled in apache configuration was marked as the answer
Log in as admin -> edit customer -> check "PHP enabled?" flag AND/OR
Log in as admin -> edit domain -> check "PHP enabled" flag
-
d00p's post in [HELP] After switching to PHP-FPM I cannot upload images to WordPress via Admin interface 🤯 was marked as the answer
Well, just take a look at the owner, chown it to user/group editor1
-
d00p's post in [HELP] Reconfiguring running froxlor was marked as the answer
Settings -> System -> Use libnss-extrausers instead of libnss-mysql
-
d00p's post in [HELP] Reconfiguring running froxlor was marked as the answer
Settings -> System -> Use libnss-extrausers instead of libnss-mysql
-
d00p's post in [HELP] Reconfiguring running froxlor was marked as the answer
Settings -> System -> Use libnss-extrausers instead of libnss-mysql
-
d00p's post in Template for: Domain Default Page? was marked as the answer
Yes, go to admin -> templates
Can you explain???
-
d00p's post in Pro tips needed! was marked as the answer
Not magically, no, it's in the docs: you need to adjust the settings and then follow the configuration-steps to set up the system and services
Most of the settings can be changed even without the need to reconfigure any services. Some few don't make sense to change afterwards (e.g. customer basedir, you'd have to manually adjust paths etc. better just not do it). Things like switching the webserver from apache to nginx for example would of course mean you'd have to go through configuration steps for webserver again
most used - as far as i know - is debian. second ubuntu. i have not seen many people with arch or centos using froxlor
-
d00p's post in was mach ich falsch was marked as the answer
Hm, schon die zweite Meldung mit der Datenbank. Muss ich Mal schauen, da hat sich wohl ein Fehler eingeschlichen... Ärgerlich
-
d00p's post in Post Bullseye update (Bind9 installed and running but not in /etc/init.d/bind9) was marked as the answer
Better use 'service' or 'systemctl' - many services just add init.d-files for compatibility reasons but they get removed more and more
-
d00p's post in PHP-FPM Umstellung & Webroot was marked as the answer
Einstellungen -> froxlors vhost Einstellungen -> php-fpm für froxlor vhost nutzen auch aktiviert?