Posts made by internalit_7155

Hello
I followed the advised migration path but I found out I had a sqlserver 2005 installed so I had to upgrade it to 2012 at least (the only one compatible with windows 2008R2).
The upgrade to 5.2.32 went fine and was confirmed by the installer, just when starting the service it crashes.
I had to update the serverurl as described here:

https://inedo.com/support/kb/1014/changing-url-with-the-integrated-web-server

After that the service started but connecting with a browser the Proget I see a white (empty) page.

Is there a log I could check to find out what went wrong?

Hello
I tried generating anew license in a new account but no sigar.
I usually use the manual activation because it looks like it's the only option that the software allow.
Is there another way to generate a new free license?

I did a try and I've got an error. It looks like it goes up to a certain version and then stops with an exception on the DB...

 Debug: Product = ProGet (5.3.33)
   Debug: OS = Microsoft Windows NT 6.1.7601 Service Pack 1
   Debug: Edition = Express
   Debug: TargetPath = C:\Program Files\ProGet
   Debug: WebAppPath = C:\Program Files\ProGet\WebApp
   Debug: ServicePath = C:\Program Files\ProGet\Service
   Debug: PackagesPath = C:\ProgramData\ProGet\Packages
   Debug: ASPNETTempPath = C:\ProgramData\ProGet\Temporary ASP.NET Files
   Debug: ConnectionString = Data Source=localhost\SQLEXPRESS; Initial Catalog=ProGet; Integrated Security=True;
   Debug: Port = 8624
   Debug: UseIntegratedWebServer = True
   Debug: WebServerPrefixes = http://*:8624/
   Debug: InstallSqlExpress = False
   Debug: UserAccount = NetworkService
   Debug: WebAppUserAccount = NetworkService
   Debug: ServiceUserAccount = NetworkService
   Debug: LicenseKey = xxxxxxxxxxxxxxxxx
   Debug: EmailAddress = 
   Debug: FullName = 
   Debug: ConfigureIIS = False
   Debug: BackupDatabase = True
   Debug: DatabaseBackupPath = C:\ProGetBackups
   Debug: ExtensionsPath = C:\ProgramData\ProGet\Extensions
   Debug: ExtensionsTempPath = C:\ProgramData\ProGet\ExtensionsTemp
   Debug: LogFile = C:\Users\Administrator\AppData\Local\Temp\2\tmp43D3.tmp.txt
   Debug: Upgrade = True
Information: Stopping ProGet service...
   Debug: Stopping service INEDOPROGETSVC...
   Debug: INEDOPROGETSVC service stopped.
Information: Stopping the ProGet web server service...
   Debug: Stopping service INEDOPROGETWEBSVC...
 Warning: Could not start service: Service INEDOPROGETWEBSVC was not found on computer '.'.
Information: Backing up database to C:\ProGetBackups...
   Debug: Backup file: C:\ProGetBackups\ProGet-Pre5.3.33.bak
   Debug: Backup completed.
Information: Removing previous version...
   Debug: Staging C:\Program Files\ProGet\Service for delete...
   Debug: Attempting to rename C:\Program Files\ProGet\Service to C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8...
   Debug: Attempting to rename C:\Program Files\ProGet\Service to C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8...
   Debug: C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8\ renamed.
   Debug: Attempting to hide C:\Program Files\ProGet\4d8f57223875443783bebe68440b20e8...
   Debug: Directory staged for delete.
   Debug: Staging C:\Program Files\ProGet\WebApp for delete...
   Debug: Attempting to rename C:\Program Files\ProGet\WebApp to C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8...
   Debug: Attempting to rename C:\Program Files\ProGet\WebApp to C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8...
   Debug: C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8\ renamed.
   Debug: Attempting to hide C:\Program Files\ProGet\2a21e037287648aeb3f15982030ad0c8...
   Debug: Directory staged for delete.
   Debug: Deleting old start menu items...
Information: Updating database schema...
   Debug: Launching process "C:\Users\ADMINI~1\AppData\Local\Temp\2\ProGetSetup\SqlScripts\inedosql.exe" update SqlScripts.zip --connection-string="Data Source=localhost\SQLEXPRESS; Initial Catalog=ProGet; Integrated Security=True;"...
   Debug: Database uses old change script schema; upgrading...
   Debug: Script DDL-DML/v5.0-5.2/0212. 5.1.3/More asset hashes.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0213. 5.1.8/Add Feeds_UnlistPackage task.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0214. 5.1.19/10. Drop Connector Password Constraint.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/00. Alter Connector Filter Column.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/01. Connector Name Constraint.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/10. Create DebianPackages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/20. Create PypiPackages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/30. Add FeedTypes.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/40. Add Licenses_Manage task.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/50. Add FeedReplicationMode.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/51. Add FeedReplication_Configuration.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/60. Create HelmCharts.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/61. Add Helm FeedType.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/70. Add Columns to FeedRetentionRules.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/71. Create ProGetLicensingViolations.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0220. 5.2.0/80. Remove MyGet FeedSync.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0221. 5.2.1/10. Connector Name Constraint.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0222. 5.2.5/10. Increase Package_Versions length.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0222. 5.2.6/10. Webhooks Constraint Change.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0224. 5.2.8/10. Index NuGet v2 Package Size.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0225. 5.2.12/10. Add Docker blob media type.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0226. 5.2.14/10. Update ServiceUrls Configuration.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0227. 5.2.14/10. Create ExternalUsers.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0227. 5.2.15/10. Create PackageDependents.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0228. 5.2.16/Create FeedAlternateNames.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0240. 5.2.25/10. Add RPM FeedType.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0240. 5.2.25/10. Add RPM Packages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0240. 5.2.25/10. Add RPM RepoData.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.27/10. Alter DockerBlobs.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.27/10. Alter DockerBlobUploads.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.27/10. Alter Vulnerabilities Add Blob_Digest.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.0-5.2/0241. 5.2.28/change UQ on package dependents.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/10. Add DockerRepositories.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/11. Add ContainerConfigBlob_Id.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/12. Alter DockerImages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/13. Create DockerRepositoryTags.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/14. Remove old data.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/20. Add DockerImageLayers.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/01. Container Layer Visibility/30. Add ImageTypeCode.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/02. Container Versioning/1. Add Columns to Docker Tags Table.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/02. Container Versioning/1. Add LastDownload to Images.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/02. Container Versioning/1. Add Repository ImageUrl to Docker Repository.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/03. Helm Chart Visibility/10. Create HelmChartDockerImages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/04. Container and Package Usage/10. Create PackageContainerUsage.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/04. Container and Package Usage/11. Create FeedScanners.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/04. Container and Package Usage/12. Update PackageDependent.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/04. Container and Package Usage/13. Update PackageUsage.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/04. Container and Package Usage/14. AddGrouptToPackageUsage.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/05. Various Refactoring/10. Drop FeedAdapters.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/05. Various Refactoring/10. Drop NuGetQuirks.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/05. Various Refactoring/20. Fix upack versions.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/05. Various Refactoring/22. Expand upack versions.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/05. Various Refactoring/30. Alter Connectors.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/05. Various Refactoring/40. Drop NpmConnectorPackages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/06. ManualVulnerabilityRefactoring/10. AddFeedIdAndContraintToVulnerabilitiesTable.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/06. ManualVulnerabilityRefactoring/20. MigrateManualVulnerabilities.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/07. OOBEUpgrade/10.DisableOOBEOnUpgrade.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/09. Remove Bad BaseUrl.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/10. Clean Directory Providers.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/10. Delete Anonymous User.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/10. Make Anonymous an Admin for OOB.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/10. Remove Deployment Feed Type.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/10. Trigger Docker and Helm Rebuild Jobs.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/10. Update npm feeds to use NpmFeedConfig.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/11. Rename ProGet Feed Type.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/12. Rename ProGet Connector Feed Type.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/20. Move System Config Values to Feeds and Connectors.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/20. Remove Legacy NuGetConfig Attribs.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/30. Add ModifyDate to DockerRepositories.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/40. Remove npm connector tasks.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/50. Add CreatedDate To Package Consumers.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3/51. New Retention Rules.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.09/10. Create CustomLanguages.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.09/40. Create UserConfiguration.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.14/Create ClusterNodes Table.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.23/10. Add DockerUpload context.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.26/10. Add SHA512 to npm.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.26/10.RebuildHelmMetadata.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.27/10.ExpandContainerUsageServer.sql is missing a legacy ID.
   Debug: Script DDL-DML/v5.3.27/10.ExpandWebhookUrl.sql is missing a legacy ID.
   Error: Unhandled Exception: System.Data.SqlClient.SqlException: The parameterized query '(@Script_Guid uniqueidentifier,@Script_Name nvarchar(200),@Scrip' expects the parameter '@Script_Sql', which was not supplied.
   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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   Error:    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   Error:    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   Error:    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   Error:    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   Error:    at Inedo.DbUpdater.SqlServer.SqlServerDatabaseConnection.UpgradeSchema(IDictionary`2 canoncialGuids)
   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)
   Debug: C:\Program Files\ProGet\WebApp restored.
   Debug: C:\Program Files\ProGet\Service restored.
   Debug: Starting service INEDOPROGETSVC...
   Debug: INEDOPROGETSVC service started.
   Error: System.InvalidOperationException: C:\Users\ADMINI~1\AppData\Local\Temp\2\ProGetSetup\SqlScripts\inedosql.exe returned exit code -532462766
   at Inedo.Installer.Subtasks.RunProcessSubtask.Run()
   at Inedo.Installer.InstallationTask`1.RunSubtask(InstallationSubtask subtask)
   at Inedo.ProGet.Setup.InstallProGetTask.UpdateDatabaseSchema()
   at Inedo.ProGet.Setup.InstallProGetTask.Upgrade(UniversalPackageVersion oldVersion)
   at Inedo.Installer.InstallationTask`1.Inedo.Installer.IInstallationTask.RunInternal()

Do we just download the legacy installer and run it?
We have Proget 3.7.6.2 installed on a windows 2008R2 and in proget we have just one nuget legacy feed defined.

The best would be to upgrade so that all the configuration are retained and external project using the server would not need to upgrade their configuration also.

I might have found the issue. The activation code before was signed with sha1 hash and now a sha256 hash is used and probably this is not supported by version 3.7.6.2 hence the invalid registration code issue.

I also tried to upgrade to 4.7.9 version to no avail... do you happen to know which version introduced the sha256 hash thing?

Hi atripp

Thank you for you answer.
I did copy it multiple times as well as cut instead of copy but to no avail.
When I hit save I get an error saying the activation code is invalid.
I also though it should still work and also it should have no limitations of the number of activations... Any idea what I could check?

We have a Proget version 3.7.6.2 and a free perpetual license.
We hat to restore the VM where it is installed and the mac address changed or some other parameter to identify the sever so it is required to activate the license again.
Now ProGet asks to be reactivated but when we generate the activation code on myinedo site and do a save on the Manual Activation form the system says the activation code is invalid.

From the documentation there should not be any limitation on the activations of the server.

Does anyone know what the problem is and how can we fix it?

Kind regards