C#•4y ago

Newly hosted .net web app (Linux VPS) not accessing MySqlDatabase

I've just published a .Net web application to a linux VPS, however for some reason, when loading pages that require the database, the website is crashing. I know this is likely due to my database not being connected properly. It works fine on my local machine, just not on the Linux VPS.
Any help would be greatly appreciated!

Here is my appsettings.json (edited out sensitive info):

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "Persist Security Info=False;Server=sql1.hosting.net;User ID=Website;Password=Password;Initial Catalog=myDatabase;MultipleActiveResultSets=true",
    }
}

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "Persist Security Info=False;Server=sql1.hosting.net;User ID=Website;Password=Password;Initial Catalog=myDatabase;MultipleActiveResultSets=true",
    }
}

Kouhai•10/12/22, 6:15 PM

@V3NG3ANC3 Make sure that connection string is valid and can connect

V3NG3ANC3OP•10/12/22, 6:57 PM

Its definitely valid, it connects fine on my test server

Kouhai•10/12/22, 7:04 PM

Your DB is hosted on the VPS?

pip•10/12/22, 7:50 PM

it would help you a lot to log the errors to a text file or console or something

pip•10/12/22, 7:50 PM

my guess is that it may be an outbound rule error? but that's just a pure guess