Jump to content
Froxlor Forum

Max Amigo

Members
 View Profile  See their activity

  • Posts

    38

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by Max Amigo

    [HELP] Cannot create a new database

    in General Discussion

    Posted · Edited by Max Amigo
    added more info

    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;

     

    [HELP] Cannot create a new database

    in General Discussion

    Posted

    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.

     

    Pro tips needed!

    in General Discussion

    Posted

    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?

    Pro tips needed!

    in General Discussion

    Posted

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

    Pro tips needed!

    in General Discussion

    Posted

    @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?

    Pro tips needed!

    in General Discussion

    Posted

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