Problem with pending tasks

Discussion in 'Installation/Configuration' started by Luksor, Jan 26, 2025.

  1. Luksor

    Luksor New Member

    Hello, I have problem with "pending tasks" on my ispconfig panel, after update of ispconfig and my debian I see that tasks from panel not saving and waiting for .... nothing.

    I checked with cron disabled by running /usr/local/ispconfig/server/server.sh and

    Code:
    26.01.2025-22:38 - WARNING - There is already a lockfile set, but no process running with this pid (3846085). Continuing.
    Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    Database connection failed Database connection failed Database connection failed Database connection failed Database connection failed Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! PHP Fatal error:  Uncaught Error: Call to a member function testConnection() on false in /usr/local/ispconfig/server/server.php:67
    Stack trace:
    #0 {main}
      thrown in /usr/local/ispconfig/server/server.php on line 67
    Database connection failed Database connection failed Database connection failed
    I checked connection from phpmyadmin with details from config.inc.php
    And I can login from phpmyadmin and also commandline of debian normally.

    I have changeg mysql port but also in config.inc.php this is added.


    Code:
    //** Database
    $conf['db_type'] = 'mysql';
    $conf['db_host'] = 'localhost';
    $conf['db_port'] = 'sqlportchanged from 3306 to other';
    $conf['db_database'] = 'dbispconfig';
    $conf['db_user'] = 'ispconfig';
    $conf['db_password'] = 'pass1';
    $conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")
    $conf['db_new_link'] = false;
    $conf['db_client_flags'] = 0;
    
    define('DB_TYPE',$conf['db_type']);
    define('DB_HOST',$conf['db_host']);
    define('DB_PORT',$conf['db_port']);
    define('DB_DATABASE',$conf['db_database']);
    define('DB_USER',$conf['db_user']);
    define('DB_PASSWORD',$conf['db_password']);
    define('DB_CHARSET',$conf['db_charset']);
    
    
    //** Database settings for the master DB. This setting is only used in multiserver setups
    $conf['dbmaster_type']            = 'mysql';
    $conf['dbmaster_host']            = 'localhost';
    $conf['dbmaster_port']            = 'sqlport other than 3306';
    $conf['dbmaster_database']        = 'dbispconfig';
    $conf['dbmaster_user']            = '';
    $conf['dbmaster_password']        = 'pass21';
    $conf['dbmaster_new_link']         = false;
    $conf['dbmaster_client_flags']     = 0;

    I have single server that be multiserver some years ago but all working fine after conversion.
    Using now PHP 8.3

    Roundcube work fine but i found that SSL for website not renewing, after this i found this problem.
    I have this problems many times, but years ago. I forgot where to look for fix...
    Please help.
     

    Attached Files:

    Last edited: Jan 27, 2025
  2. Luksor

    Luksor New Member

    And also what i see, that when i make new webmail user or change website/dns settings, all saving or creating normally but pending tasks adding and adding.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    You have set login details for dbmaster host, but these must not be set on a single server as you do not have a master in that case. The dbmaster host must be empty; it can not be localhost.

    Code:
    $conf['dbmaster_host']                  = '';
     
    Luksor likes this.
  4. Luksor

    Luksor New Member

    Wow nice, that help thank you so much. One week ago i thinking about write here but I kept trying to fix it without success.
    Now working fine. So much thank you.
     
    till likes this.

Share This Page