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.

 

9 minutes ago, d00p said:

Settings -> Froxlor VirtualHost Settings -> Enable SSL-redirect for the froxlor vhost, right below where you activated Let's Encrypt...

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! :-)

2 hours ago, d00p said:

Yes, sure, enable ssl and lets encrypt and then enable let's encrypt for the froxlor-vhost in "Settings -> Froxlor VirtualHost-Settings -> Enable Let's Encrypt for the froxlor vhost"

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?

15 minutes ago, d00p said:

did you follow ALL instructions given there? Especially the --apply command that should be run in ordner to EXECUTE the configuration-steps for the desired services

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!

18 minutes ago, d00p said:

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

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:

1. New domains were always pointing to /var/www, not to /var/customers/webs/editor1/mysite1.com/
2. 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