Jump to content
Froxlor Forum

christian.a

Members
  • Posts

    17
  • Joined

  • Last visited

Posts posted by christian.a

  1. Im systemctl status mysql schreibt er mir 

    2020-12-11 10:35:41 8545 [Warning] Access denied for user 'froot'@'localhost' (using password: YES)

    Also kann er sich verbinden, aber dann verweigert er den Zugriff. Das Passwort ist geprüft und passt. Sowohl in der froxlor userdata als auch in der mariadb server Einstellung ist 127.0.0.1 als IP des Servers eingetragen.

    Es werden auch keine Mailverzeichnisse angelegt. Wenn ich einen SQL Nutzer und eine Datenbank anlege bekomme ich dazu eine Fehlermeldung...

    A database error occurred
    SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'froot'@'localhost' to database 'user1sql1'
    
     
    
    #0 /home/var/www/froxlor/lib/Froxlor/Database/Database.php(83): PDOStatement->execute(Array)
    #1 /home/var/www/froxlor/lib/Froxlor/Database/Manager/DbManagerMySQL.php(106): Froxlor\Database\Database::pexecute(Object(PDOStatement), Array)
    #2 /home/var/www/froxlor/lib/Froxlor/Database/DbManager.php(105): Froxlor\Database\Manager\DbManagerMySQL->grantPrivilegesTo('user1sql1', 'passwd', '127.0.0.1')
    #3 /home/var/www/froxlor/lib/Froxlor/Api/Commands/Mysqls.php(82): Froxlor\Database\DbManager->createDatabase('user1', 'passwd', '0')
    #4 /home/var/www/froxlor/customer_mysql.php(150): Froxlor\Api\Commands\Mysqls->add()
    #5 {main}
    
    
    				GRANT ALL ON `user1sql1`.* TO :username@:host

    Werde den Server wohl neu aufsetzen müssen, zumal es ja ein paar Tage funktionierte...

  2. Hallo!
    
    Ich habe bei einer froxlor Installation das Problem, dass ich nicht mehr auf die Oberfläche zugreifen kann, da es ein Problem mit der Datenbank gibt.
    Der Froxlor DB User existiert, hat die entsprechenden Rechte (hab es auch schon mit einem alternativen root User versucht) und das Passwort passt auch (über phpmyadmin geht es)
    
    
    
    A database error occurred
    SQLSTATE[HY000] [2002] Connection refused
    
     
    
    #0 /home/var/www/froxlor/lib/Froxlor/Database/Database.php(338): PDO->__construct('mysql:dbname=fr...', 'MyUser', 'DB_UNPRIV_PWD', Array)
    #1 /home/var/www/froxlor/lib/Froxlor/Database/Database.php(213): Froxlor\Database\Database::getDB()
    #2 /home/var/www/froxlor/lib/Froxlor/Settings.php(86): Froxlor\Database\Database::__callStatic('query', Array)
    #3 /home/var/www/froxlor/lib/Froxlor/Settings.php(67): Froxlor\Settings::readSettings()
    #4 /home/var/www/froxlor/lib/Froxlor/Settings.php(122): Froxlor\Settings::init()
    #5 /home/var/www/froxlor/lib/init.php(206): Froxlor\Settings::Get('session.session...')
    #6 /home/var/www/froxlor/index.php(20): require('/home/var/www/f...')
    #7 {main}
    Natürlich hab ich auch keine MariaDB Error Logs...
    
    Das Passwort wurde nicht geändert. Ich habe nur den Zugriff über das interne Netz erlaubt (192.168.%.%) - das hab ich aber auch schon wieder gelöscht.
    
    

    Wo könnte ich hier ansetzen?

     

    Danke! LG

    Chris

  3. Hi,

    wo hat es denn gehackt?
    Ich versuche auch einem ähnlichen Problem auf die Schliche zu kommen.

    Die 35_...conf werden angelegt aber der Apache ignoriert den Inhalt irgendwie...

    Zum Vergleich: diese Domain leitet mich direkt zur Froxlor Oberfläche (Php-fpm, froxlor VHost direkt erreichbar, ...)

    # 35_froxlor_ssl_vhost_www2.domain.at.conf
    # Created 20.02.2020 15:47
    # Do NOT manually edit this file, all changes will be deleted after the next domain change at the panel.
    
    # Domain ID: 6 (SSL) - CustomerID: 2 - CustomerLogin: domain
    <VirtualHost 178.Z.X.Y:443>
      ServerName www2.domain.at
      ServerAdmin info@domain.at
      SSLEngine On
      SSLProtocol -ALL +TLSv1.2
      Protocols h2 http/1.1
      SSLCompression Off
      SSLSessionTickets on
      SSLHonorCipherOrder off
      SSLCipherSuite ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA
      SSLVerifyDepth 10
      SSLCertificateFile /etc/ssl/froxlor-custom/www2.domain.at.crt
      SSLCertificateKeyFile /etc/ssl/froxlor-custom/www2.domain.at.key
      SSLCACertificateFile /etc/ssl/froxlor-custom/www2.domain.at_CA.pem
      SSLCertificateChainFile /etc/ssl/froxlor-custom/www2.domain.at_chain.pem
      <IfModule mod_headers.c>
        Header always set Strict-Transport-Security "max-age=0"
      </IfModule>
      DocumentRoot "/var/customers/webs/domain/www2.domain.at/"
      <FilesMatch \.(php)$>
      SetHandler proxy:unix:/var/lib/apache2/fastcgi/1-domain-www2.domain.at-php-fpm.socket|fcgi://localhost
      </FilesMatch>
      <Directory "/var/customers/webs/domain/www2.domain.at/">
        Require all granted
        AllowOverride All
      </Directory>
      Alias /webalizer "/var/customers/webs/domain/webalizer/www2.domain.at"
      LogLevel debug
      ErrorLog "/var/customers/logs/domain-www2.domain.at-error.log"
      CustomLog "/var/customers/logs/domain-www2.domain.at-access.log" combined
    </VirtualHost>

    Diese bringt mich zum Ziel:

    # 35_froxlor_ssl_vhost_1.domain2.com.conf
    # Created 20.02.2020 15:47
    # Do NOT manually edit this file, all changes will be deleted after the next domain change at the panel.
    
    # Domain ID: 2 (SSL) - CustomerID: 1 - CustomerLogin: domain2
    <VirtualHost 178.Z.X.Y:443>
      ServerName 1.domain2.com
      ServerAdmin domain2.name@icloud.com
      SSLEngine On
      SSLProtocol -ALL +TLSv1.2
      Protocols h2 http/1.1
      SSLCompression Off
      SSLSessionTickets on
      SSLHonorCipherOrder off
      SSLCipherSuite ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA
      SSLVerifyDepth 10
      SSLCertificateFile /etc/ssl/froxlor-custom/1.domain2.com.crt
      SSLCertificateKeyFile /etc/ssl/froxlor-custom/1.domain2.com.key
      SSLCACertificateFile /etc/ssl/froxlor-custom/1.domain2.com_CA.pem
      SSLCertificateChainFile /etc/ssl/froxlor-custom/1.domain2.com_chain.pem
      <IfModule mod_headers.c>
        Header always set Strict-Transport-Security "max-age=0"
      </IfModule>
      DocumentRoot "/var/customers/webs/domain2/1.domain2.com/"
      <FilesMatch \.(php)$>
      SetHandler proxy:unix:/var/lib/apache2/fastcgi/1-domain2-1.domain2.com-php-fpm.socket|fcgi://localhost
      </FilesMatch>
      <Directory "/var/customers/webs/domain2/1.domain2.com/">
        Require all granted
        AllowOverride All
      </Directory>
      Alias /webalizer "/var/customers/webs/domain2/webalizer/1.domain2.com"
      LogLevel debug
      ErrorLog "/var/customers/logs/domain2-1.domain2.com-error.log"
      CustomLog "/var/customers/logs/domain2-1.domain2.com-access.log" combined
    </VirtualHost>

    Und noch die ipandport config:

    # 10_froxlor_ipandport_178.Z.X.Y.443.conf
    # Created 20.02.2020 15:47
    # Do NOT manually edit this file, all changes will be deleted after the next domain change at the panel.
    
    <VirtualHost 178.Z.X.Y:443>
    DocumentRoot "/var/www/froxlor/"
     ServerName panel.domain.eu
      <FilesMatch \.(php)$>
      SetHandler proxy:unix:/var/lib/apache2/fastcgi/3-froxlor.panel-panel.domain.eu-php-fpm.socket|fcgi://localhost
      </FilesMatch>
     SSLEngine On
     SSLProtocol -ALL +TLSv1.2
     Protocols h2 http/1.1
     SSLCompression Off
     SSLSessionTickets on
     SSLHonorCipherOrder off
     SSLCipherSuite ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA
     SSLVerifyDepth 10
     SSLCertificateFile /etc/ssl/froxlor-custom/panel.domain.eu.crt
     SSLCertificateKeyFile /etc/ssl/froxlor-custom/panel.domain.eu.key
     SSLCACertificateFile /etc/ssl/froxlor-custom/panel.domain.eu_CA.pem
     SSLCertificateChainFile /etc/ssl/froxlor-custom/panel.domain.eu_chain.pem
    </VirtualHost>

    Welche Logfiles wären interessant? Die Customer Logs zeigen nichts. (Also kein Inhalt)

    Danke!

    LG

  4. Yes, I did that.

    And it says OK, but there seems to be an error in the gpg file?

    root@srv1:/usr/local/src# wget -O - https://deb.froxlor.org/froxlor.gpg | apt-key add -
    --2019-11-08 11:16:04--  https://deb.froxlor.org/froxlor.gpg
    Resolving deb.froxlor.org (deb.froxlor.org)... 82.149.225.211, 2a01:440:1:12:82:149:225:211
    Connecting to deb.froxlor.org (deb.froxlor.org)|82.149.225.211|:443... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 1709 (1.7K)
    Saving to: 'STDOUT'
    
    -                                                   100%[================================================================================================================>]   1.67K  --.-KB/s    in 0s
    
    2019-11-08 11:16:04 (153 MB/s) - written to stdout [1709/1709]
    
    OK
    

     

  5. Hi there!

    I am trying to install froxlor on a Qemu VM with debian 10.1

    I am using the Wiki (https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-on-debian) for the installation.
    The apt-get update will not succeed as I get the following message:

    W: GPG error: https://deb.froxlor.org/debian buster InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY F6B4A8704F9E9BBC
    E: The repository 'https://deb.froxlor.org/debian buster InRelease' is not signed.
    

    Any help?

    Best regards

    Chris

×
×
  • Create New...