Heimdall icon indicating copy to clipboard operation
Heimdall copied to clipboard

Upgrade to 2.6.x fails with refused connections

Open MLNW opened this issue 11 months ago • 13 comments

I host Heimdall on a Kubernetes cluster. It is running in version 2.5.8 but when I upgrade to 2.6.0 or 2.6.1 the browser shows

image

In the container I see the same errors spammed quite frequently:

  SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'forge' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

  at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

  1   [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()

      +19 vendor frames
  21  /app/www/app/Providers/AppServiceProvider.php:165
      Illuminate\Support\Facades\Facade::__callStatic()

   Illuminate\Database\QueryException

  SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'forge' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

  at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

  1   [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()

      +19 vendor frames
  21  /app/www/app/Providers/AppServiceProvider.php:165
      Illuminate\Support\Facades\Facade::__callStatic()

I'm surprised to see mysql here. Did I miss an upgrade step?

MLNW avatar Mar 01 '24 09:03 MLNW

Not seen that before, what do you have in your .env?

KodeStar avatar Mar 04 '24 07:03 KodeStar

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

LinuxServer-CI avatar Apr 03 '24 15:04 LinuxServer-CI

Not seen that before, what do you have in your .env?

APP_URL=https://heimdall.my.domain
FORCE_HTTPS=true

Sorry for the long delay. These are the values in my .env. The FORCE_HTTPS one needs to be there otherwise we get errors in the browser regarding a mix of HTTP and HTTPS traffic. The instance sits behind a reverse proxy that handles SSL termination.

MLNW avatar Apr 08 '24 06:04 MLNW

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

LinuxServer-CI avatar May 08 '24 15:05 LinuxServer-CI

@MLNW did you ever find a fix for this, I have the same issue.

mattboy9921 avatar May 28 '24 14:05 mattboy9921

No, I did not find a solution but I also haven't looked at it since my last comment.

MLNW avatar May 28 '24 16:05 MLNW

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

LinuxServer-CI avatar Jun 28 '24 15:06 LinuxServer-CI

I still have this issue and I may decide to just wipe it and start from scratch unfortunately.

mattboy9921 avatar Jun 28 '24 15:06 mattboy9921

The logs OP gives is that it's unable to connect to mysql, are yours the same?

j0nnymoe avatar Jun 28 '24 16:06 j0nnymoe

Having this same problem. connection refused / mysql

SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'forge' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

y8s avatar Jul 02 '24 14:07 y8s

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

LinuxServer-CI avatar Aug 01 '24 15:08 LinuxServer-CI