Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade to 2.6.x fails with refused connections #1306

Open
MLNW opened this issue Mar 1, 2024 · 15 comments
Open

Upgrade to 2.6.x fails with refused connections #1306

MLNW opened this issue Mar 1, 2024 · 15 comments

Comments

@MLNW
Copy link

MLNW commented Mar 1, 2024

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
Copy link
Member

KodeStar commented Mar 4, 2024

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

@LinuxServer-CI
Copy link

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
Copy link
Author

MLNW commented Apr 8, 2024

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
Copy link

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
Copy link

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

@MLNW
Copy link
Author

MLNW commented May 28, 2024

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

@LinuxServer-CI
Copy link

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
Copy link

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

@j0nnymoe
Copy link
Member

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

@y8s
Copy link

y8s commented Jul 2, 2024

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
Copy link

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
Copy link

Hello.
Same issue here, connection refused.

@y8s
Copy link

y8s commented Sep 27, 2024

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
Copy link

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
Copy link
Member

KodeStar commented Nov 5, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: Non-Docker Issues
Development

No branches or pull requests

7 participants