Navigation

    Inedo Community Forums

    Forums

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. tamir.dahan_7908
    T
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Best
    • Groups

    tamir.dahan_7908

    @tamir.dahan_7908

    0
    Reputation
    3
    Posts
    1
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    tamir.dahan_7908 Follow

    Best posts made by tamir.dahan_7908

    This user hasn't posted anything yet.

    Latest posts made by tamir.dahan_7908

    • RE: ProGet - Could not open a connection to SQL Server

      Thanks Alena
      I tried that you suggested to me to do but it looks like I'm getting the same error message

      ProGet version is 24.0.10.5.
      Current DB schema version is unknown.
      Unhandled exception: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)
         at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
         at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
         at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
         at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
         at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
         at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
         at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
         at Microsoft.Data.SqlClient.SqlConnection.Open()
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.GetConnection()
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteTable[TResult](String query, Func`2 adapter, SqlTransaction transaction, SqlParameter[] args)
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.GetChangeScriptVersion(SqlTransaction transaction)
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.GetState()
         at Inedo.DbUpdater.ConsoleHost.Update(String scriptPath, String connectionString, Boolean force)
         at Inedo.DbUpdater.ConsoleHost.Run(ArgList args)
         at Inedo.DbUpdater.ConsoleHost.RunAsync(IEnumerable`1 args)
         at Inedo.ProGet.Service.Program.UpdateDatabaseSchemaAsync() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E463691\Src\ProGet.Service\Program.cs:line 318
         at Inedo.ProGet.Service.Program.Run(WebServerMode mode, Boolean runAsService, Boolean linuxContainer, String urls) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E463691\Src\ProGet.Service\Program.cs:line 28
         at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
         at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
      ClientConnectionId:00000000-0000-0000-0000-000000000000
      

      any other suggestion ?
      Tamir

      posted in Support
      T
      tamir.dahan_7908
    • ProGet - Could not open a connection to SQL Server

      Hi

      I'm trying to install ProGet version 24.0.10.5 in my docker environment

      following the instructions from inedo documentation
      https://docs.inedo.com/docs/installation/linux/docker-guide

      after i ran the flowing commands

      docker run --name inedo-sql -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=mypassword'  -e 'MSSQL_PID=Express' --net=inedo --restart=unless-stopped   -d mcr.microsoft.com/mssql/server:latest
      
      docker exec -it inedo-sql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'mypassword' -Q 'CREATE DATABASE [ProGet] COLLATE SQL_Latin1_General_CP1_CI_AS'
      

      I can see that I have 2 containers up and running
      but the proget container cannot succeed to start successfully

      CONTAINER ID   IMAGE                                                COMMAND                  CREATED          STATUS          PORTS                                        NAMES
      ce9547b183fa   proget.inedo.com/productimages/inedo/proget:latest   "/bin/sh -c '/usr/lo…"   15 minutes ago   Up 28 seconds   0.0.0.0:80->80/tcp, :::80->80/tcp, 443/tcp   proget
      22ed0ef2c195   mcr.microsoft.com/mssql/server:latest                "/opt/mssql/bin/perm…"   22 minutes ago   Up 22 minutes   1433/tcp                                     inedo-sql
      

      the logs from the Db looks OK

      2024-07-21 08:14:14.44 spid12s     Database 'msdb' running the upgrade step from version 956 to version 957.
      2024-07-21 08:14:14.46 spid14s     Database 'model' running the upgrade step from version 956 to version 957.
      2024-07-21 08:14:14.54 spid14s     Clearing tempdb database.
      2024-07-21 08:14:14.77 spid14s     [2]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
      2024-07-21 08:14:14.77 spid14s     Starting up database 'tempdb'.
      2024-07-21 08:14:14.86 spid32s     The Service Broker endpoint is in disabled or stopped state.
      2024-07-21 08:14:14.87 spid32s     The Database Mirroring endpoint is in disabled or stopped state.
      2024-07-21 08:14:14.88 spid32s     Service Broker manager has started.
      2024-07-21 08:14:14.88 spid12s     Recovery is complete. This is an informational message only. No user action is required.
      2024-07-21 08:14:14.90 spid22s     The default language (LCID 0) has been set for engine and full-text services.
      2024-07-21 08:16:52.28 spid79      [5]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
      2024-07-21 08:16:52.28 spid79      Starting up database 'ProGet'.
      2024-07-21 08:16:52.28 spid79      RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [5]
      2024-07-21 08:16:52.28 spid79      RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 5.
      2024-07-21 08:16:52.31 spid79      Parallel redo is started for database 'ProGet' with worker pool size [1].
      2024-07-21 08:16:52.33 spid79      Parallel redo is shutdown for database 'ProGet' with worker pool size [1].
      RecoveryUnit::Shutdown. IsOnline: 02024-07-21 08:20:53.17 spid67      XE session 'telemetry_xevents' started.
      2024-07-21 08:30:54.02 spid66      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
      2024-07-21 08:30:54.03 spid66      Using 'xplog70.dll' version '2022.160.4125' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
      2024-07-21 08:34:14.24 spid66      [5]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
      2024-07-21 08:34:14.24 spid66      Starting up database 'ProGet'.
      2024-07-21 08:34:14.24 spid66      RemoveStaleDbEntries: Cleanup of stale DB entries called for database ID: [5]
      2024-07-21 08:34:14.24 spid66      RemoveStaleDbEntries: Cleanup of stale DB entries skipped because master db is not memory optimized. DbId: 5.
      2024-07-21 08:34:14.28 spid66      Parallel redo is started for database 'ProGet' with worker pool size [1].
      2024-07-21 08:34:14.29 spid66      Parallel redo is shutdown for database 'ProGet' with worker pool size [1].
      

      but the server can not commentate with the DB

      ProGet version is 24.0.10.5.
      Current DB schema version is unknown.
      Unhandled exception: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)
         at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
         at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
         at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
         at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
         at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
         at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
         at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
         at Microsoft.Data.SqlClient.SqlConnection.Open()
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.GetConnection()
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteTable[TResult](String query, Func`2 adapter, SqlTransaction transaction, SqlParameter[] args)
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.GetChangeScriptVersion(SqlTransaction transaction)
         at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.GetState()
         at Inedo.DbUpdater.ConsoleHost.Update(String scriptPath, String connectionString, Boolean force)
         at Inedo.DbUpdater.ConsoleHost.Run(ArgList args)
         at Inedo.DbUpdater.ConsoleHost.RunAsync(IEnumerable`1 args)
         at Inedo.ProGet.Service.Program.UpdateDatabaseSchemaAsync() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E463691\Src\ProGet.Service\Program.cs:line 318
         at Inedo.ProGet.Service.Program.Run(WebServerMode mode, Boolean runAsService, Boolean linuxContainer, String urls) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E463691\Src\ProGet.Service\Program.cs:line 28
         at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
         at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr)
      ClientConnectionId:00000000-0000-0000-0000-000000000000
      

      Please advice
      Tamir

      posted in Support
      T
      tamir.dahan_7908