Hello Rich @rhessinger,

sorry for the delayed answer.
As you imagined, the user is constantly prompted to log in. Even with correct credentials he is not allowed log in an gets error 401. The "normal" scenario is within VisualStudio. After changing a branch you want to restore nuget packages and suddenly you are asked to login to ProGet again. The only way out is to reboot the server instance of ProGet.

I am afraid we are the only ones with such a behaviour.

Kind regards,
Rosario

Hello,
after we updated from ProGet 6.0.20 to 2022.17 we are having some problems with authentication. We use the windows integrated authentication and once or twice a weak only one random user in our group is not allowed to authenticate.
The only log messages we can find are from the hosting IIS. There we get for example:

2023-06-07 06:56:24 172.19.134.24 GET /nuget/Acl/v3/index.json - 443 COMPANY\<username>172.18.2.17 NuGet+VS+VSIX/6.6.0+(Microsoft+Windows+NT+10.0.19045.0,+Enterprise/17.0) - 401 0 0 7

To fix this we restart the IIS or sometimes even the whole server instance (with ProGet and IIS). In the example above you can see the feed "Acl", but we are receiving the same message for all feeds on our ProGet. Another way to fix the authentication problem is to wait for several hours . Then the user is magically allowed to consume packages again.

Maybe we just have some missconfiguration with our IIS. Has anybody an idea?

Hello Rich and Alana,
thank you for your effort.
I wrote my problem as a reminder to the open issue https://github.com/OneGet/oneget/issues/430.
We will see what happens

Kind regards,
Rosario

Hello,
I have problems getting information with Powershell Find-Package on a NuGet-Feed hosted on ProGet. My Feed named "Common_Develop" ha a connector to https://api.nuget.org/v3/index.json. When I send Find-Package to nuget.org directly everything works fine. As soon as I send the same request to the local ProGet feed that has a connector to nuget.org I get errors because something with the JSON object schema is not as expected. Changing the the source URI to use ODATA (v2) instead of JSON-LD (v3) fixes the problem. But the first try with Find-Package against nuget.org uses JSON-LD (v3) and works fine.
So my question is: What is wrong with the Feed on ProGet using the connector to nuget.org?
Is this a bug with ProGet Version 2022.17 (Build 15) or do I have to change something with the feed configuration?

For error reproduction my powershell:

PS C:\Users\digiov> $PsVersionTable

Name                           Value
----                           -----
PSVersion                      7.3.1
PSEdition                      Core
GitCommitId                    7.3.1
OS                             Microsoft Windows 10.0.19044
Platform                       Win32NT
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

PS C:\Users\digiov> Find-Package -Name System.IO -Source https://api.nuget.org/v3/index.json

Name                           Version          Source                           Summary
----                           -------          ------                           -------
System.IO                      4.3.0            https://api.nuget.org/v3/index.… Provides base input and output (I/O) types, including System.IO.Stream, System.IO.StreamReader and Sys…

PS C:\Users\digiov> Find-Package -Name System.IO -Source https://ProGet/nuget/Common_Develop/v3/index.json
WARNING: An internal error occurred: The JSON object returned by the NuGet API does not match expected schema. Expected property: 'type'. Check the debug stream for the full JSON object dump.       
Find-Package: No match was found for the specified search criteria and package name 'System.IO'. Try Get-PackageSource to see all available registered package sources.
PS C:\Users\digiov> Find-Package -Name System.IO -Source https://ProGet/nuget/Common_Develop/

Name                           Version          Source                           Summary
----                           -------          ------                           -------
System.IO                      4.3.0            https://ProGet/nuget/Common_De.… Provides base input and output (I/O) types, including System.IO.Stream, System.IO.StreamReader and Sys…

Hello @atripp,
today we upgraded successfully to 2.0.17. We believe there were problems with Windows Active Directory Users and the permissions granted per group. Our solution was a new sql user and a corresponding change of the connection string in the ProGet.config.
Thank you for your help.

Hi @atripp,
we did the installation again with my user as member of the db admin users. Additionally we checked the default schema is dbo. The errors occurred again. After this try we found the missing tables - but created with my user as prefix instead of dbo.
For example the table __StoredProcInfo was created as COMPANY\myUser.__StoredProcInfo instead of dbo.__StoredProcInfo. This should be the cause of the problem , but we have no clue how and why this happened.

A question to be sure: Are these sql files from the installation compatible with SQL Server 2019 (15.0.4261.1)?

Hi @atripp ,
thank you for the tips so far.
My user and the security settings should be fine - my DB-team checked this again and more access as my user has is not possible . So, the dbo schema should be no problem.

We reset the DB to a state before the first updgrade attempt. Then i tryed the inedosql error command and got this:

PS C:\Users\XXXXX\Downloads\ProGet-22.0.17\SqlScripts> .\inedosql.exe errors --connection-string="Data Source=dbname;Initial Catalog=ProGet;Integrated Security=True" --all
ed36e7c2-8ca9-4674-80b4-9e3a956fe1b6 DDL-DML/v1-3/0002. 0.1.0/21 CREATE ROLE ProGetUser_Role.sql
PS C:\Users\XXXXX\Downloads\ProGet-22.0.17\SqlScripts> .\inedosql.exe error ed36e7c2-8ca9-4674-80b4-9e3a956fe1b6 --connection-string="Data Source=dbname;Initial Catalog=ProGet;Integrated Security=True"
GUID: ed36e7c2-8ca9-4674-80b4-9e3a956fe1b6
Name: DDL-DML/v1-3/0002. 0.1.0/21 CREATE ROLE ProGetUser_Role.sql
Executed: 14.07.2020 14:41:44
Resolved: 14.07.2020 16:04:44

Resolution:


Error:
User, group, or role 'ProGetUser_Role' already exists in the current database.

I think this should be no problem. But the installation of ProGet 22.0.17 failed again with error:

     INFO: Executing untracked script OBJECTS/3.TRIGGERS/1.TR__DockerRepositoryTags__ValidateImage.sql...
     INFO: Executing untracked script OBJECTS/3.TRIGGERS/X.TR__Users__ValidateAnonymous.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.1.AddStoredProcInfo.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.2.HandleError.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.3.Events_RaiseEvent.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.4.PackageIds_GetPackageId.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/1.ApiKeys_CreateOrUpdateApiKey.sql...
    ERROR:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    ERROR:    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    ERROR:    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    ERROR:    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
    ERROR: Unhandled Exception: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.__AddStoredProcInfo'.
    ERROR:    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    ERROR:    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    ERROR:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteQueryWithSplitter(String query, SqlTransaction transaction)
    ERROR:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteScripts(IEnumerable`1 scripts, ChangeScriptState state)
    ERROR:    at Inedo.DbUpdater.Program.Update(String scriptPath, String connectionString, Boolean force)
    ERROR:    at Inedo.DbUpdater.Program.Run(ArgList args)
    ERROR:    at Inedo.DbUpdater.Program.Main(String[] args)
    ERROR: Process exited with code: -532462766 (failure)

As you can see there is a message with INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.1.AddStoredProcInfo.sql.... This is running well and I can confirm that the DB has a table dbo.__StoredProcInfo.
I really don't understand what I am doing wrong.

I even looked for the not found procedure and can find it. There is a __AddStoredProcInfo entry in table dbo.__StoredProcInfo.

Do you have any other ideas?

Hello, I am trying to upgrade our installation of ProGet from 6.0.14 to 22.0.17. I use the Inedo Hub offline Installer, because the hosting server has no internet access. The ProGet DB is hosted on a seperate DB Server with SQL Server 2019.
The first try failed with following error:

...
...
...
INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.3.Events_RaiseEvent.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/0.4.PackageIds_GetPackageId.sql...
     INFO: Executing untracked script OBJECTS/4.PROCEDURES/1.ApiKeys_CreateOrUpdateApiKey.sql...
    ERROR:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    ERROR:    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    ERROR:    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    ERROR:    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
    ERROR:    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    ERROR:    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    ERROR:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteQueryWithSplitter(String query, SqlTransaction transaction)
    ERROR:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteScripts(IEnumerable`1 scripts, ChangeScriptState state)
    ERROR:    at Inedo.DbUpdater.Program.Update(String scriptPath, String connectionString, Boolean force)
    ERROR: Unhandled Exception: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.__AddStoredProcInfo'.
    ERROR:    at Inedo.DbUpdater.Program.Run(ArgList args)
    ERROR:    at Inedo.DbUpdater.Program.Main(String[] args)
    ERROR: Process exited with code: -532462766 (failure)

After this ProGet was inaccessible and I downgraded back to 6.0.14.
All following attempts to install 22.0.17 failed with the next error:

...
...
...
 INFO: Executing untracked script OBJECTS/2.VIEWS/1.LicenseRules_Extended.sql...
     INFO: Executing untracked script OBJECTS/2.VIEWS/1.Licenses_Extended.sql...
     INFO: Executing untracked script OBJECTS/2.VIEWS/1.Licenses_Usage.sql...
    ERROR:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    ERROR:    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    ERROR:    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
    ERROR:    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
    ERROR:    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    ERROR:    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    ERROR:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteQueryWithSplitter(String query, SqlTransaction transaction)
    ERROR:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.ExecuteScripts(IEnumerable`1 scripts, ChangeScriptState state)
    ERROR:    at Inedo.DbUpdater.Program.Update(String scriptPath, String connectionString, Boolean force)
    ERROR:    at Inedo.DbUpdater.Program.Run(ArgList args)
    ERROR:    at Inedo.DbUpdater.Program.Main(String[] args)
    ERROR: Unhandled Exception: System.Data.SqlClient.SqlException: Invalid object name 'PackageLicenses'.
    ERROR: Process exited with code: -532462766 (failure)

My investigation so far is, that there is no table 'PackageLicenses' on the DB, so the second error makes sense to me.

Can some help me?

Hello,
i was thinking about filtering connectors like it is possible to search packages. What i mean is the possibility to filter by package properties (explained here: https://docs.microsoft.com/en-us/nuget/consume-packages/finding-and-choosing-packages?view=vsmac-2019#search-syntax).
The search syntax is working on the feeds, but unfortunately not with connectors. My initial intention for this post is the idea to filter by "owner:Microsoft" instead of "Microsoft.*". For me it looks like a more properly way to filter packages from Microsoft.
Please let me know if i am getting something wrong. Otherwise this would be a great feature - are there more opinions about this or am i the only trying something like this?