Jump to content
Froxlor Forum

Max Amigo

  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by Max Amigo

  1. So, I deleted the manually DB 'editor1sql1' and user 'editor1sql1'@''. 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'@'' 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          |       |
    | editor1sql1      |       |
    | froxlor          |       |  <-- 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'@'' IDENTIFIED BY 'pass1';
    GRANT ALL PRIVILEGES ON froxlor.* TO 'froxlor'@'';
    CREATE USER 'dbadmin'@'localhost' IDENTIFIED BY 'pass2';
    GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'localhost';
    CREATE USER 'dbadmin'@'' IDENTIFIED BY 'pass2';
    GRANT ALL PRIVILEGES ON *.* TO 'dbadmin'@'';


  2. 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? :huh:

    p.s. Before this error, I saw error that my DB root user doesn't have permissions on 'editor1sql1' table.


  3. 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?

  4. 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 :-)

  5. @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.


  6. 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



  • Create New...