Jump to content
Froxlor Forum

d00p

Administrators
  • Posts

    9521
  • Joined

  • Last visited

  • Days Won

    41

Community Answers

  1. d00p's post in PHP 8.1 installieren was marked as the answer   
    du hast ja auch php-fpm installiert und nicht php-cgi....
  2. 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
  3. 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  
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. d00p's post in Adding multiple domain names to a single site was marked as the answer   
    Just assign the same documentroot?
  11. 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
  12. 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
  13. 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
     
  14. 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
  15. 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.
  16. 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 
  17. 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
  18. d00p's post in [HELP] Reconfiguring running froxlor was marked as the answer   
    Settings -> System -> Use libnss-extrausers instead of libnss-mysql
  19. d00p's post in [HELP] Reconfiguring running froxlor was marked as the answer   
    Settings -> System -> Use libnss-extrausers instead of libnss-mysql
  20. d00p's post in [HELP] Reconfiguring running froxlor was marked as the answer   
    Settings -> System -> Use libnss-extrausers instead of libnss-mysql
  21. d00p's post in Template for: Domain Default Page? was marked as the answer   
    Yes, go to admin -> templates
    Can you explain???
  22. 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
  23. 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
  24. 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
  25. 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?
×
×
  • Create New...