bastcom

Hi again, today, I removed my Froxlor installation along with MySQL. I then installed MariaDB and set up a fresh Froxlor installation. Everything is working fine with MariaDB—just wanted to keep you informed. Best Bastian

Ok yes, would be great if you can take a look. For now, I have a workaround and can use the system. Thanks for the help

Each time a new database is created, a corresponding user is also generated, correct? For example, if I create DB1, the system will create User1; for DB2, it will create User2, and so on. I can see that the system successfully creates both the database and the user, but something seems to go wrong in the process. I tried the command you sent in mysql: GRANT ALL ON `DB`.* TO USER@IP; It worked fine. I also attempted to modify DbManagerMySQL.php with chatgpt. This code is working for me. public function grantCreateToDb(string $username, string $database, string $access_host) { // Manually construct the query (avoiding placeholders for database objects) $query = "GRANT ALL ON `" . $database . "`.* TO '" . $database . "'@'" . $access_host . "'"; // Execute the statement directly Database::pexecute(Database::prepare($query)); } Any idea? I know the second $database is wrong, but it was a workaround.

Yes i did, this is the userdata.inc.php: <?php // autogenerated froxlor file $sql = [ 'debug' => false, 'host' => 'MYSQLSERVER', 'user' => 'froxlorweb22', 'password' => <<<'EOT' PASSWORT EOT, 'db' => 'froxlorweb22', ]; $sql_root = [ '0' => [ 'caption' => 'Default', 'host' => 'MYSQLSERVER', 'user' => 'froxroot', 'password' => <<<'EOT' PASSWORT EOT, ], ]; btw. i have another Froxlor installation, and after updating the database and Froxlor, I'm seeing the same error. I found this online: https://vishalvyas.com/mysql-error-1410-you-are-not-allowed-to-create-a-user-with-grant/

Hi, yes sure no problem. I’ve got a new server running Ubuntu 24.04 and an older one with Ubuntu 22.04. Both are fully updated and running MySQL 8.0.41. I followed the Froxlor documentation and installed it locally on the Ubuntu 22.04 server: Installation Guide After setting everything up, I created a new customer account and tried to add a database under that account. But I ran into this error: SQLSTATE[42000]: Syntax error or access violation: 1410 You are not allowed to create a user with GRANT Since that didn’t work, I removed everything and reinstalled Froxlor again on Ubuntu 22.04. This time, I tried using the database on the Ubuntu 24.04 server instead, but I got the same error again. Not sure what’s going wrong—any ideas? Thanks

Hey, I took another look but wasn’t sure about the solution, so I decided to do 2 fresh installations of Froxlor. Unfortunately, I ran into the same error. Could you take a look? I tried setting it up with both a local and an external database: Local Database: Ubuntu 22.04 MySQL 8.0.41-0ubuntu0.22.04.1 External Database: Ubuntu 24.04 MySQL 8.0.41-0ubuntu0.24.04.1 Let me know if you need any more details. Thanks!

Hi, after updating to Froxlor 2.2.6, I encountered the following error when i try to create a new database. A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1410 You are not allowed to create a user with GRANT This are the log: ==> /var/log/apache2/error.log <== froxlor[2673501]: SQLSTATE[42000]: Syntax error or access violation: 1410 You are not allowed to create a user with GRANT froxlor[2673501]: --- DEBUG: #0 /var/www/froxlor/lib/Froxlor/Database/Database.php(122): PDOStatement->execute(Array) #1 /var/www/froxlor/lib/Froxlor/Database/Manager/DbManagerMySQL.php(363): Froxlor\Database\Database::pexecute(Object(PDOStatement), Array) #2 /var/www/froxlor/lib/Froxlor/Database/DbManager.php(209): Froxlor\Database\Manager\DbManagerMySQL->grantCreateToDb('b---m', 'b---4', '127.0.0.1') #3 /var/www/froxlor/lib/Froxlor/Api/Commands/Mysqls.php(118): Froxlor\Database\DbManager->createDatabase('b---m', 'F8%k@PF((Dd5:b9...', 0, 3, 'b---m') #4 /var/www/froxlor/customer_mysql.php(151): Froxlor\Api\Commands\Mysqls->add() #5 {main} Additionally, I recently updated my Ubuntu system. Here are the versions currently installed: MySQL: 8.0.41-0ubuntu0.24.04.1 Froxlor: 2.2.6 Could you help me resolve this issue? Thanks Bastian

Danke an d00p, bei der Konfiguration habe ich scheinbar übersehen das /etc/apache2/conf-enabled/acme.conf gefehlt hat. Nach der Erstellung geht jetzt alles.

Hi, ja das machen sie. Ich kann Sie auch alle pingen und auch alle aufrufen. Nur das SSL will nicht. ich habe schon alles mögliche ausprobiert und verglichen. Aber ich habe keine idee mehr warum eine gehen und andere nicht.

Hi, ich habe ein Problem mit einem neu installieren System. Ich habe ein Domain angelegt und diese mit einem SSL von let's encrypt versehen. Dies geht auch. Danach habe ich mehrere Subdomains angelegt. Hier ist das Problem bei einigen kann ich kein SSL von let's encrypt holen. Andere wiederum laufen ohne Fehler durch. Bisher konnte ich keinen unterschied sehen bei den Domains. Hatte eventuell schonmal jemand dieses Problem? Hier noch ein Auszug vom Log: [Tue Jun 14 12:07:48 PM CEST 2022] sub.domain.de:Verify error:IP: Invalid response from http://sub.domain.de/.well-known/acme-challenge/d6tc-TsVmC-8f8ZhQK7FXHG0NgWmXVmYfPZVJu-P2y4: 404 [Tue Jun 14 12:07:48 PM CEST 2022] Please add '--debug' or '--log' to check more details. [Tue Jun 14 12:07:48 PM CEST 2022] See: https://github.com/acmesh-official/acme.sh/wiki/How-to-debug-acme.sh [error] Could not find file 'sub.domain.de.cer' in '/root/.acme.sh/sub.domain.de/' [error] Could not find file 'ca.cer' in '/root/.acme.sh/sub.domain.de/' [error] Could not find file 'fullchain.cer' in '/root/.acme.sh/sub.domain.de/' [error] Could not get Let's Encrypt certificate for sub.domain.de: [Tue Jun 14 12:07:37 PM CEST 2022] Using CA: https://acme-v02.api.letsencrypt.org/directory [Tue Jun 14 12:07:37 PM CEST 2022] Creating domain key [Tue Jun 14 12:07:39 PM CEST 2022] The domain key is here: /root/.acme.sh/sub.domain.de/sub.domain.de.key [Tue Jun 14 12:07:39 PM CEST 2022] Multi domain='DNS:sub.domain.de,DNS:www.sub.domain.de' [Tue Jun 14 12:07:39 PM CEST 2022] Getting domain auth token for each domain [Tue Jun 14 12:07:42 PM CEST 2022] Getting webroot for domain='sub.domain.de' [Tue Jun 14 12:07:42 PM CEST 2022] Getting webroot for domain='www.sub.domain.de' [Tue Jun 14 12:07:42 PM CEST 2022] Verifying: sub.domain.de [Tue Jun 14 12:07:43 PM CEST 2022] Pending, The CA is processing your order, please just wait. (1/30) [Tue Jun 14 12:07:45 PM CEST 2022] Pending, The CA is processing your order, please just wait. (2/30) [error] Could not find file 'sub.domain.de.cer' in '/root/.acme.sh/sub.domain.de/' [error] Could not find file 'ca.cer' in '/root/.acme.sh/sub.domain.de/' [error] Could not find file 'fullchain.cer' in '/root/.acme.sh/sub.domain.de/' [error] Could not get Let's Encrypt certificate for sub.domain.de: Danke Grüße Bastian