Max Amigo

Now it works. Here is SQL that fixed permission issues: GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'127.0.0.1'WITH GRANT OPTION; FLUSH PRIVILEGES;

Can I just export all my setting from froxlor and reset whole installation with proper 'root' user for mysql? Can I re-use those setting to setup froxlor faster?

So, I deleted the manually DB 'editor1sql1' and user 'editor1sql1'@'127.0.0.1'. Then I repeated the process again and I have the initial error: A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'dbadmin'@'127.0.0.1' to database 'editor1sql1' Error: SQLSTATE[HY000]: General error: 1007 Can't create database 'editor1sql1'; database exists Is a cascading result of this one. As a side note: I don't know much about mysql, but might it be somehow related to this?? mysql> SELECT User, Host FROM mysql.user; +------------------+-----------------+ | User | Host | +------------------+-----------------+ | dbadmin | 127.0.0.1 | | editor1sql1 | 127.0.0.1 | | froxlor | 127.0.0.1 | <-- IP address | froxlor | XXX.XXX.XXX.XXX | <-- My public IP address? | dbadmin | localhost | <-- DB root | debian-sys-maint | localhost | <-- localhost | froxlor | localhost | | mysql.infoschema | localhost | | mysql.session | localhost | | mysql.sys | localhost | | root | localhost | +------------------+-----------------+ 11 rows in set (0.00 sec) This is how I created my mysql users: CREATE DATABASE froxlor; CREATE USER 'froxlor'@'localhost' IDENTIFIED BY 'pass1'; GRANT ALL PRIVILEGES ON froxlor.* TO 'froxlor'@'localhost'; CREATE USER 'froxlor'@'127.0.0.1' IDENTIFIED BY 'pass1'; GRANT ALL PRIVILEGES ON froxlor.* TO 'froxlor'@'127.0.0.1'; FLUSH PRIVILEGES; CREATE USER 'dbadmin'@'localhost' IDENTIFIED BY 'pass2'; GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'localhost'; CREATE USER 'dbadmin'@'127.0.0.1' IDENTIFIED BY 'pass2'; GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'127.0.0.1'; FLUSH PRIVILEGES;

When I try to create a database as a customer in Froxlor, I always get an error: A database error occurred SQLSTATE[HY000]: General error: 1007 Can't create database 'editor1sql1'; database exists In the database list I see nothing: Databases (0 / 0) Any idea? p.s. Before this error, I saw error that my DB root user doesn't have permissions on 'editor1sql1' table.

My bad!!! Sorry.

How do I enable SSL redirect for Froxlor Virtual Host? >>e.g. a request to http://domain.tld/ will redirect you to https://domain.tld/

Dear d00p! Thank you very much! Everything works as expected! Even FTP! :-)

Do I need to reconfigure services for this?

🙇‍♂️ Thank you very much! 🍻

Last questions: Can I self protect with Let's Encrypt SSL froxlor installation?

Yes, I did. I will try is from scratch again. I think I got the point now. Just whole idea of settings → configuration is new to me. But when I got it, I must say it is very smart and logical! Now I hope I got the point: when I do services settings - it is just is DB. only when I do configuration it is getting applied. Sorry :-) Me not very smart :-)

@d00p Thank you very much for you answer! So, once I am done with settings for services froxlor gives me instruction how to configure those services. I can apply them manually or by calling php /var/www/froxlor//install/scripts/config-services.php --froxlor-dir=/var/www/froxlor/ --create When I add domain - I do not need reconfigure services. But I have to wait 10 minutes to Let's Encrypt. Right?

Hi guys! I want to install froxlor for my personal projects: many websites on one host behind cloudflare. I have tried to install it on Ubuntu 20.04.1 LTS. Installation was smooth. But didn't succeed to configure: New domains were always pointing to /var/www, not to /var/customers/webs/editor1/mysite1.com/ I didn't manage to setup Let's encrypt. It always was HTTP, never HTTPS. So, I started to dig the docs.... In the docs I saw references to: Debian Wheezy which is version 7. Moreover, in the docs I realised that there is kind of sequence in froxlor setup: 4. Settings before configuration! I cannot change settings when I want and expect that everything will magically work (Am I right?) - There is kind of workflow I have to follow? My questions are the following: 1. What happens is I want to change setting after I have configured froxlor? Or it is one way one go? How it works? What is a right workflow with froxlor? 2. What is the best Linux distro for froxlor? I have an option to start with one the following: Arch Linux latest minimal CentOS 7.9 minimal CentOS 8.4 minimal Debian 10.10 LAMP Debian 10.10 minimal Debian 11 base Ubuntu 18.04.5 LTS minimal Ubuntu 18.04.5 LTS Nextcloud Ubuntu 20.04.1 LTS minimal