November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
LocalDB is not supported on this platform
What does the connection string look like in appSettings.json or appSettings.development.json
Could what you have here be overriding your env variables ?
Edited,
Mar 15, 2023 9:16
I already checked if that was the case and no connetionstrings in those files. My ConnectionStrings secrets.json look like his:
{
"ConnectionStrings:EPiServerDB": "Server=localhost; Database=cmsDb;User Id=sa;Password=Passw0rd!;MultipleActiveResultSets=True;TrustServerCertificate=True"
}
Mar 15, 2023 9:45
Enock
- Mar 16, 2023 8:39
FROM mcr.microsoft.com/mssql/server:2019-latest AS base
ENV ACCEPT_EULA=Y
USER root
WORKDIR /src
COPY ./Docker/create-db.sh .
RUN chmod +x /src/create-db.sh
USER mssql
EXPOSE 1433
ENTRYPOINT /src/create-db.sh & /opt/mssql/bin/sqlservr
ENV ACCEPT_EULA=Y
USER root
WORKDIR /src
COPY ./Docker/create-db.sh .
RUN chmod +x /src/create-db.sh
USER mssql
EXPOSE 1433
ENTRYPOINT /src/create-db.sh & /opt/mssql/bin/sqlservr
Eric Herlitz
- Mar 16, 2023 9:22
That SQL sever won't probably work on an ARM mac. Instead use mcr.microsoft.com/azure-sql-edge
Enock
- Mar 16, 2023 9:38
What puzzles me is that it has worked before. But what you are saying is also what I have read on my google searches. However it is not possible to change it at this point
Enock
- Mar 16, 2023 10:15
As mentioned, my ConnectionStrings looks like this "ConnectionStrings:EPiServerDB": "Server=localhost; Database=cmsDb;User Id=sa;Password=Passw0rd!;MultipleActiveResultSets=True;TrustServerCertificate=True" in my user secrets, and through debugging I can see it somehow gets overwritten and then looks like this ""Data Source=(localdb)\\mssqllocaldb;Initial Catalog=EPiServerDB;Integrated Security=True;MultipleActiveResultSets=True"
Any idea how that can be overwritten or where?
Any idea how that can be overwritten or where?
Eric Herlitz
- Mar 16, 2023 10:55
Either you modify it in appsettings.Development.json or via some injected class, Alloy used to have one of those. Search your code and you'll find it.
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
I'm new to development on Optimizely CMS and I use macOS. We are currently in the middle of migration from CMS v11 to v12. The new dev environment is using docker and until a few days ago there was no issue in compatibility and no limitations. Now I'm not able to run the project as I get the PlatformNotSupportedException "LocalDB is not supported on this platform". Yet our partners who are technical responsible for this platform, have not made any changes to the database or setup
I get that SQL Server LocalDB is a feature of SQL Server, which is Windows only, that's the solution is containerized which should avoid that issue, and did until now.
My question is if anyone can think of or know reason why this suddenly could be a problem when it has worked fine until now.
Any help/comment/suggestion is highly appreciated
Thanks