Category : sql

I am making a Telegram bot with a PostgreSQL database. Everything works correctly on the local computer, but when I upload the code to the server using docker-compose, the following errors appear in the console from time to time: 2021-10-10 02:08:58.865 UTC [3458] FATAL: password authentication failed for user "pgadmin" 2021-10-10 02:08:58.865 UTC [3458] DETAIL: ..

Read more

Hi guys I understand there are a lot of threads on this topic, however I have been unable to find anything that works and am I completely stuck. my Docker-Compose file looks like : version: "3.8" services: app: build: . ports: – 9090:5000 links: – db:database db: platform: linux/x86_64 image: mysql command: –default-authentication-plugin=mysql_native_password restart: unless-stopped ..

Read more

Input Data wk_end_d Total Volume 2/6/2021 236255 2/13/2021 231962 2/20/2021 190785 2/27/2021 209750 3/6/2021 234347 3/13/2021 210586 3/20/2021 217937 3/27/2021 266082 4/3/2021 228382 4/10/2021 200622 4/17/2021 260464 4/24/2021 229509 5/1/2021 259193 Output how iam looking for is .How can I achieve this the calculations are interdependent |wk_end_d| |Total Volume| |New Volume| |Worked Volume| |Remaining Volume| ..

Read more

I have a VPS running Ubuntu 18.04. The server is running an ASP.NET Core application in a docker container and SQL Server Express 2019 is NOT in a container. I am trying to access a database from an application. My connection string: Server=host.docker.internal,1433;User ID=SA;Password=mypass;Database=mydb In application services.AddDbContext<UniversityContext>(options => options.UseLazyLoadingProxies().UseSqlServer(Configuration.GetConnectionString("ConnectionString"))); I get an error SqlException: A ..

Read more

Cannot connect to mssql localhost instance via Azure Data Studio. Get: ‘login failed for user sa’. In the same time I’m able to successfully connect via terminal: mssql -u sa -p myPassword mssql is in docker with status up sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=myPassword -p 1433:1433 –name sql1 -h sql1 -d mcr.microsoft.com/mssql/server:2019-latest os: ..

Read more