Anonymous
Действительный сертификат TLS не настроен для приема строгих подключений (TDS 8.0 и выше). Соединение закрыто
Сообщение
Anonymous » 09 дек 2024, 03:02
Я пытаюсь запустить приложение C# .NET локально с помощью Microsoft SQL Server через Docker Desktop. Я могу успешно запустить C# .NET в VS Code и SQL Server в Docker.
На этом изображении ниже показана структура моего проекта:
Проблема возникает после того, как я все запускаю и перехожу на localhost:3000< /code> где я беру ошибка:
"A valid TLS certificate is not configured to accept strict (TDS 8.0 and above) connections. The connection has been closed."
Я пытаюсь получить доступ к локальному хосту из обычного браузера Chrome.
Вот мои настройки для подключения к Docker Desktop SQL Server:
{
"Id": "b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0",
"Created": "2024-12-08T19:37:16.566439881Z",
"Path": "/opt/mssql/bin/permissions_check.sh",
"Args": [
"/opt/mssql/bin/sqlservr"
],
"State": {
"Status": "exited",
"Running": false,
"Paused": false,
"Restarting": false,
"OOMKilled": false,
"Dead": false,
"Pid": 0,
"ExitCode": 0,
"Error": "",
"StartedAt": "2024-12-08T20:17:24.478828799Z",
"FinishedAt": "2024-12-08T20:53:48.134906005Z"
},
"Image": "sha256:142124bf195c65dfb872751e433fcd25b2acfabd1063ae2f33f1bf35b058e95e",
"ResolvConfPath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/resolv.conf",
"HostnamePath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/hostname",
"HostsPath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/hosts",
"LogPath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0-json.log",
"Name": "/sql-server-prostride",
"RestartCount": 0,
"Driver": "overlay2",
"Platform": "linux",
"MountLabel": "",
"ProcessLabel": "",
"AppArmorProfile": "",
"ExecIDs": null,
"HostConfig": {
"Binds": [],
"ContainerIDFile": "",
"LogConfig": {
"Type": "json-file",
"Config": {}
},
"NetworkMode": "bridge",
"PortBindings": {
"1433/tcp": [
{
"HostIp": "0.0.0.0",
"HostPort": "3000"
}
]
},
"RestartPolicy": {
"Name": "no",
"MaximumRetryCount": 0
},
"AutoRemove": false,
"VolumeDriver": "",
"VolumesFrom": null,
"ConsoleSize": [
0,
0
],
"CapAdd": null,
"CapDrop": null,
"CgroupnsMode": "private",
"Dns": [],
"DnsOptions": [],
"DnsSearch": [],
"ExtraHosts": null,
"GroupAdd": null,
"IpcMode": "private",
"Cgroup": "",
"Links": null,
"OomScoreAdj": 0,
"PidMode": "",
"Privileged": false,
"PublishAllPorts": false,
"ReadonlyRootfs": false,
"SecurityOpt": null,
"UTSMode": "",
"UsernsMode": "",
"ShmSize": 67108864,
"Runtime": "runc",
"Isolation": "",
"CpuShares": 0,
"Memory": 0,
"NanoCpus": 0,
"CgroupParent": "",
"BlkioWeight": 0,
"BlkioWeightDevice": null,
"BlkioDeviceReadBps": null,
"BlkioDeviceWriteBps": null,
"BlkioDeviceReadIOps": null,
"BlkioDeviceWriteIOps": null,
"CpuPeriod": 0,
"CpuQuota": 0,
"CpuRealtimePeriod": 0,
"CpuRealtimeRuntime": 0,
"CpusetCpus": "",
"CpusetMems": "",
"Devices": null,
"DeviceCgroupRules": null,
"DeviceRequests": null,
"MemoryReservation": 0,
"MemorySwap": 0,
"MemorySwappiness": null,
"OomKillDisable": null,
"PidsLimit": null,
"Ulimits": null,
"CpuCount": 0,
"CpuPercent": 0,
"IOMaximumIOps": 0,
"IOMaximumBandwidth": 0,
"MaskedPaths": [
"/proc/asound",
"/proc/acpi",
"/proc/kcore",
"/proc/keys",
"/proc/latency_stats",
"/proc/timer_list",
"/proc/timer_stats",
"/proc/sched_debug",
"/proc/scsi",
"/sys/firmware",
"/sys/devices/virtual/powercap"
],
"ReadonlyPaths": [
"/proc/bus",
"/proc/fs",
"/proc/irq",
"/proc/sys",
"/proc/sysrq-trigger"
]
},
"GraphDriver": {
"Data": {
"LowerDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd-init/diff:/var/lib/docker/overlay2/ef6167b574dad4a86ebb9ac61f344c47fce85c7c7eeabbfcaf90fce3831ad339/diff:/var/lib/docker/overlay2/afb091ffecaf628a1af80cb40cfa70f17bd0f72dee803c6bdd0b9fae86190f4d/diff:/var/lib/docker/overlay2/bd099f169764e1418a5521c179e727c9fcc6279608da831957881908ef953c87/diff",
"MergedDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd/merged",
"UpperDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd/diff",
"WorkDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd/work"
},
"Name": "overlay2"
},
"Mounts": [],
"Config": {
"Hostname": "b3fac76133ec",
"Domainname": "",
"User": "mssql",
"AttachStdin": false,
"AttachStdout": false,
"AttachStderr": false,
"ExposedPorts": {
"1433/tcp": {}
},
"Tty": false,
"OpenStdin": false,
"StdinOnce": false,
"Env": [
"ACCEPT_EULA=Y",
"SA_PASSWORD=(removed password)",
"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"MSSQL_RPC_PORT=135",
"CONFIG_EDGE_BUILD=",
"MSSQL_PID=developer"
],
"Cmd": [
"/opt/mssql/bin/sqlservr"
],
"Image": "mcr.microsoft.com/mssql/server:latest",
"Volumes": null,
"WorkingDir": "",
"Entrypoint": [
"/opt/mssql/bin/permissions_check.sh"
],
"OnBuild": null,
"Labels": {
"com.microsoft.product": "Microsoft SQL Server",
"com.microsoft.version": "16.0.4165.4",
"org.opencontainers.image.ref.name": "ubuntu",
"org.opencontainers.image.version": "22.04",
"vendor": "Microsoft"
}
},
"NetworkSettings": {
"Bridge": "",
"SandboxID": "",
"SandboxKey": "",
"Ports": {},
"HairpinMode": false,
"LinkLocalIPv6Address": "",
"LinkLocalIPv6PrefixLen": 0,
"SecondaryIPAddresses": null,
"SecondaryIPv6Addresses": null,
"EndpointID": "",
"Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"MacAddress": "",
"Networks": {
"bridge": {
"IPAMConfig": null,
"Links": null,
"Aliases": null,
"MacAddress": "",
"DriverOpts": null,
"NetworkID": "9419b78701593cc49720dcfa7a59b985ddabe12d4654ae6ae119963851d8f5a2",
"EndpointID": "",
"Gateway": "",
"IPAddress": "",
"IPPrefixLen": 0,
"IPv6Gateway": "",
"GlobalIPv6Address": "",
"GlobalIPv6PrefixLen": 0,
"DNSNames": null
}
}
}
}
Подробнее здесь:
https://stackoverflow.com/questions/792 ... nd-above-c
1733702540
Anonymous
Я пытаюсь запустить приложение C# .NET локально с помощью Microsoft SQL Server через Docker Desktop. Я могу успешно запустить C# .NET в VS Code и SQL Server в Docker. На этом изображении ниже показана структура моего проекта: [img]https://i.sstatic.net/fzGbMnY6.png[/img] Проблема возникает после того, как я все запускаю и перехожу на localhost:3000< /code> где я беру ошибка: "A valid TLS certificate is not configured to accept strict (TDS 8.0 and above) connections. The connection has been closed." Я пытаюсь получить доступ к локальному хосту из обычного браузера Chrome. Вот мои настройки для подключения к Docker Desktop SQL Server: { "Id": "b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0", "Created": "2024-12-08T19:37:16.566439881Z", "Path": "/opt/mssql/bin/permissions_check.sh", "Args": [ "/opt/mssql/bin/sqlservr" ], "State": { "Status": "exited", "Running": false, "Paused": false, "Restarting": false, "OOMKilled": false, "Dead": false, "Pid": 0, "ExitCode": 0, "Error": "", "StartedAt": "2024-12-08T20:17:24.478828799Z", "FinishedAt": "2024-12-08T20:53:48.134906005Z" }, "Image": "sha256:142124bf195c65dfb872751e433fcd25b2acfabd1063ae2f33f1bf35b058e95e", "ResolvConfPath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/resolv.conf", "HostnamePath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/hostname", "HostsPath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/hosts", "LogPath": "/var/lib/docker/containers/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0/b3fac76133ec9e1127e11f59ae8f2e5ba482bb915c2221200ff25fbeb60613b0-json.log", "Name": "/sql-server-prostride", "RestartCount": 0, "Driver": "overlay2", "Platform": "linux", "MountLabel": "", "ProcessLabel": "", "AppArmorProfile": "", "ExecIDs": null, "HostConfig": { "Binds": [], "ContainerIDFile": "", "LogConfig": { "Type": "json-file", "Config": {} }, "NetworkMode": "bridge", "PortBindings": { "1433/tcp": [ { "HostIp": "0.0.0.0", "HostPort": "3000" } ] }, "RestartPolicy": { "Name": "no", "MaximumRetryCount": 0 }, "AutoRemove": false, "VolumeDriver": "", "VolumesFrom": null, "ConsoleSize": [ 0, 0 ], "CapAdd": null, "CapDrop": null, "CgroupnsMode": "private", "Dns": [], "DnsOptions": [], "DnsSearch": [], "ExtraHosts": null, "GroupAdd": null, "IpcMode": "private", "Cgroup": "", "Links": null, "OomScoreAdj": 0, "PidMode": "", "Privileged": false, "PublishAllPorts": false, "ReadonlyRootfs": false, "SecurityOpt": null, "UTSMode": "", "UsernsMode": "", "ShmSize": 67108864, "Runtime": "runc", "Isolation": "", "CpuShares": 0, "Memory": 0, "NanoCpus": 0, "CgroupParent": "", "BlkioWeight": 0, "BlkioWeightDevice": null, "BlkioDeviceReadBps": null, "BlkioDeviceWriteBps": null, "BlkioDeviceReadIOps": null, "BlkioDeviceWriteIOps": null, "CpuPeriod": 0, "CpuQuota": 0, "CpuRealtimePeriod": 0, "CpuRealtimeRuntime": 0, "CpusetCpus": "", "CpusetMems": "", "Devices": null, "DeviceCgroupRules": null, "DeviceRequests": null, "MemoryReservation": 0, "MemorySwap": 0, "MemorySwappiness": null, "OomKillDisable": null, "PidsLimit": null, "Ulimits": null, "CpuCount": 0, "CpuPercent": 0, "IOMaximumIOps": 0, "IOMaximumBandwidth": 0, "MaskedPaths": [ "/proc/asound", "/proc/acpi", "/proc/kcore", "/proc/keys", "/proc/latency_stats", "/proc/timer_list", "/proc/timer_stats", "/proc/sched_debug", "/proc/scsi", "/sys/firmware", "/sys/devices/virtual/powercap" ], "ReadonlyPaths": [ "/proc/bus", "/proc/fs", "/proc/irq", "/proc/sys", "/proc/sysrq-trigger" ] }, "GraphDriver": { "Data": { "LowerDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd-init/diff:/var/lib/docker/overlay2/ef6167b574dad4a86ebb9ac61f344c47fce85c7c7eeabbfcaf90fce3831ad339/diff:/var/lib/docker/overlay2/afb091ffecaf628a1af80cb40cfa70f17bd0f72dee803c6bdd0b9fae86190f4d/diff:/var/lib/docker/overlay2/bd099f169764e1418a5521c179e727c9fcc6279608da831957881908ef953c87/diff", "MergedDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd/merged", "UpperDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd/diff", "WorkDir": "/var/lib/docker/overlay2/ba54a081b3f89ad6edfb6b65fa2124e624563c5641854cf3c50e58561c71dbcd/work" }, "Name": "overlay2" }, "Mounts": [], "Config": { "Hostname": "b3fac76133ec", "Domainname": "", "User": "mssql", "AttachStdin": false, "AttachStdout": false, "AttachStderr": false, "ExposedPorts": { "1433/tcp": {} }, "Tty": false, "OpenStdin": false, "StdinOnce": false, "Env": [ "ACCEPT_EULA=Y", "SA_PASSWORD=(removed password)", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "MSSQL_RPC_PORT=135", "CONFIG_EDGE_BUILD=", "MSSQL_PID=developer" ], "Cmd": [ "/opt/mssql/bin/sqlservr" ], "Image": "mcr.microsoft.com/mssql/server:latest", "Volumes": null, "WorkingDir": "", "Entrypoint": [ "/opt/mssql/bin/permissions_check.sh" ], "OnBuild": null, "Labels": { "com.microsoft.product": "Microsoft SQL Server", "com.microsoft.version": "16.0.4165.4", "org.opencontainers.image.ref.name": "ubuntu", "org.opencontainers.image.version": "22.04", "vendor": "Microsoft" } }, "NetworkSettings": { "Bridge": "", "SandboxID": "", "SandboxKey": "", "Ports": {}, "HairpinMode": false, "LinkLocalIPv6Address": "", "LinkLocalIPv6PrefixLen": 0, "SecondaryIPAddresses": null, "SecondaryIPv6Addresses": null, "EndpointID": "", "Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "IPAddress": "", "IPPrefixLen": 0, "IPv6Gateway": "", "MacAddress": "", "Networks": { "bridge": { "IPAMConfig": null, "Links": null, "Aliases": null, "MacAddress": "", "DriverOpts": null, "NetworkID": "9419b78701593cc49720dcfa7a59b985ddabe12d4654ae6ae119963851d8f5a2", "EndpointID": "", "Gateway": "", "IPAddress": "", "IPPrefixLen": 0, "IPv6Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "DNSNames": null } } } } Подробнее здесь: [url]https://stackoverflow.com/questions/79263319/a-valid-tls-certificate-is-not-configured-to-accept-strict-tds-8-0-and-above-c[/url]