Jump to content
Froxlor Forum

CengizPirasa

Members
  • Posts

    13
  • Joined

  • Last visited

About CengizPirasa

  • Birthday 08/22/1984

Profile Information

  • Location
    Bielefeld
  • Interests
    IT & IT

CengizPirasa's Achievements

Rookie

Rookie (2/14)

  • First Post
  • Collaborator Rare
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. This Patchfile does not work. root@ws1:/var/www/froxlor/install/lib# patch --dry-run -b -p1 < cls.diff can't find file to patch at input line 5 Perhaps you used the wrong -p or --strip option? The text leading up to this was: -------------------------- |diff --git a/install/lib/class.FroxlorInstall.php b/install/lib/class.FroxlorInstall.php |index ba101c35..8da5328b 100644 |--- a/install/lib/class.FroxlorInstall.php |+++ b/install/lib/class.FroxlorInstall.php -------------------------- File to patch: class.FroxlorInstall.php checking file class.FroxlorInstall.php Hunk #1 FAILED at 643. Hunk #2 FAILED at 667. 2 out of 2 hunks FAILED Maybe I´m doins something wrong? Greets
  2. H, going to test this as soon as possible. Got some other errors going on with buster in a LXC-Container. App-Armor won`t let apache start. I think you get the results at 1am. Greets
  3. Hi, dont know if this is the right thread to post: I had the same Problem with a freh installation of Froxlor @mysql v8. Had to rewrite the Installer: From: (Line 645 to 663) foreach ($mysql_access_host_array as $mysql_access_host) { $_db = str_replace('`', '', $this->_data['mysql_database']); $stmt = $db_root->prepare(" GRANT ALL PRIVILEGES ON `" . $_db . "`.* TO :username@:host IDENTIFIED BY 'password'"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host )); $stmt = $db_root->prepare("SET PASSWORD FOR :username@:host = PASSWORD(:password)"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host, "password" => $this->_data['mysql_unpriv_pass'] )); } $db_root->query("FLUSH PRIVILEGES;"); Replace with: foreach ($mysql_access_host_array as $mysql_access_host) { //Create User if (version_compare($version_server, '8.0.11', '>=')) { $stmt = $db_root->prepare("CREATE USER :username@:host IDENTIFIED BY :password"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host, "password" => $this->_data['mysql_unpriv_pass'] )); } else { $stmt = $db_root->prepare(" GRANT ALL PRIVILEGES ON `" . $_db . "`.* TO :username@:host IDENTIFIED BY 'password'"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host )); $stmt = $db_root->prepare("SET PASSWORD FOR :username@:host = PASSWORD(:password)"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host, "password" => $this->_data['mysql_unpriv_pass'] )); } } // Ab dafür (DB -> Rolle -> User) $stmt = $db_root->prepare("CREATE ROLE 'Froxlor_Role'"); $stmt->execute(); $stmt = $db_root->prepare("GRANT ALL ON `" . $_db . "`.* TO 'Froxlor_Role'"); $stmt->execute(); foreach ($mysql_access_host_array as $mysql_access_host) { $stmt = $db_root->prepare("GRANT Froxlor_Role TO :username@:host"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host )); } foreach ($mysql_access_host_array as $mysql_access_host) { $stmt = $db_root->prepare("SET DEFAULT ROLE Froxlor_Role TO :username@:host"); $stmt->execute(array( "username" => $this->_data['mysql_unpriv_user'], "host" => $mysql_access_host )); } if (version_compare($version_server, '8.0.11', '<')) { $db_root->query("FLUSH PRIVILEGES;"); } Some Info´s: - I have used MySQL Roles - Add User with GRANT only does not work anymore - FLUSH PRIVILEGES is also obsolete. For sure there are some possibilities to finetune some of the code. hf with it
  4. Hi, ich erkenne da nicht wirklich einen Sinn. Wie handelt web01 die Seiten von web02 und andersherum? Eine Shared DB existiert nicht? Oder sind web01 und web02 "readonly?" sprich: Configs und co werden woanders erstellt und generiert (mngt. Froxlor drop der Configs in SharedStorage), die Webserver liefern nur aus? War viel manuell zu erledigen in Bezug auf SharedStorage (Pfade der Configs etc)? Grüße
  5. Bedeutet dann aber auch, für den Fall, dass ein FrontEnd Http ausfällt, oder die Last zu hoch ist, war es das? Nutzt ihr fcgid? Grüße
  6. Hi, kleine Frage, ich mache mir derzeit Gedanken, wie eine mögliche Multiserver Umgebung aussehen könnte. Da stellt sich die Frage, wo werden die Configs der Froxlor Umgebung gespeichert? Sofern SQL, reicht es dann nicht, einen dedicated SQL bereitzustellen, damit "mehrere" FrontEnd (httpd, ftp) ihre settings lesen/schreiben? Was muss bedacht werden? SharedStorage? uid/gid? Grüße
×
×
  • Create New...