linuxserver / Heimdall

An Application dashboard and launcher
MIT License
7.9k stars 550 forks source link

Upgrade to 2.6.x fails with refused connections #1306

Open MLNW opened 8 months ago

MLNW commented 8 months ago

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?

KodeStar commented 8 months ago

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

LinuxServer-CI commented 7 months ago

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.

MLNW commented 7 months ago

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.

LinuxServer-CI commented 6 months ago

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.

mattboy9921 commented 6 months ago

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

MLNW commented 6 months ago

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

LinuxServer-CI commented 4 months ago

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.

mattboy9921 commented 4 months ago

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

j0nnymoe commented 4 months ago

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

y8s commented 4 months ago

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)
LinuxServer-CI commented 3 months ago

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.

samotelf commented 1 month ago

Hello. Same issue here, connection refused.

y8s commented 1 month ago

Hello. Same issue here, connection refused.

relatively easy workaround: add the 2.5.8 tag and export from the settings page. then start a new install and import everything. not sure what you lose but it helps.

LinuxServer-CI commented 3 weeks ago

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.

KodeStar commented 2 weeks ago

2.6.0 updated the underlying Laravel version from 8 to 10, so it's possible old configuration files are interfering. Maybe try a new install and copy the database across (if using sqlite) or point to the old database.