Windows server 2003x64 and Deployment Manager Agent

Automated deployment for web applications and databases

Postby james.billings » Wed May 21, 2014 1:07 pm

It's the agent rather than the DM server that would be on 2003 for the problem to occur. See the Release Notes here.
james.billings
 
Posts: 1120
Joined: Wed Jun 16, 2010 11:10 am
Location: Red Gate

The same problem

Postby skycaptain » Wed May 28, 2014 4:06 pm

Hi,
I have just had the same problem on a 2k3 64bit machine.
Unfortunately it is a production box with restricted access so it's not a great place for for guessing or finger crossing.
We would really appreciate some help.
SkyCaptain
skycaptain
 
Posts: 15
Joined: Sun May 11, 2014 10:29 am
Location: London

Postby Mike Upton » Wed May 28, 2014 4:34 pm

We believe this problem is fixed in version 2.4.12.1 of the Deployment Agent.

Can you confirm the version of the agent installed on the machine in question? You can find that by looking in Control Panel/Uninstall or change a program for the version of Deployment Agent (publisher Red Gate Software Ltd.), or by looking at the file properties of C:\\Program Files (x86)\\Red Gate\\Deployment Agent\\Agent\\RedGate.Deploy.Agent.exe).

If you have version 2.4.12.1 installed and you're still having problems, please could you restart the service Red Gate Deployment Agent, and then look in the Windows Event Viewer for any errors or warnings from the Deployment Agent.
Mike Upton

Project Manager - SQL Compare|Data Compare|Comparison SDK
Redgate Software Ltd.
Mike Upton
 
Posts: 190
Joined: Wed May 11, 2011 8:04 am
Location: Redgate

Postby skycaptain » Wed May 28, 2014 4:38 pm

Thanks for your reply Mike,
The deployment agent version is 2.4.10.68 so I believe this is the problem. How can I upgrade?
SkyCaptain
skycaptain
 
Posts: 15
Joined: Sun May 11, 2014 10:29 am
Location: London

Postby Mike Upton » Wed May 28, 2014 4:58 pm

First you'll need to upgrade your Deployment Manager Server to 2.4.12.1 (assuming you haven't already), which you should be able to do with the built-in auto-update mechanism, or by downloading it from https://www.red-gate.com/delivery/deployment-manager/download.

You would then normally be able to automatically update the agents from the Deployment Manager web interface, but unfortunately that doesn't work when the Agent service isn't running. Instead, you'll need to perform a manual upgrade of the agent. You can simply get the agent installer .msi from the Tools page of your own Deployment Manager server (http://{your_deployment_manager_server_address}:{port}/downloads/agentinstaller) and run it on the machine in question.

I hope that helps.
Mike Upton

Project Manager - SQL Compare|Data Compare|Comparison SDK
Redgate Software Ltd.
Mike Upton
 
Posts: 190
Joined: Wed May 11, 2011 8:04 am
Location: Redgate

Postby skycaptain » Wed May 28, 2014 4:59 pm

It really does. I will try that.
Thanks very much.
SkyCaptain
skycaptain
 
Posts: 15
Joined: Sun May 11, 2014 10:29 am
Location: London

Postby skycaptain » Wed May 28, 2014 5:07 pm

Just out of curiosity. I just realised that the agent is working fine on another 2k3 64bit machine ! which makes me think the original problem could be related to something different ?
SkyCaptain
skycaptain
 
Posts: 15
Joined: Sun May 11, 2014 10:29 am
Location: London

Re:

Postby ATimson » Wed May 28, 2014 5:33 pm

skycaptain wrote:Just out of curiosity. I just realised that the agent is working fine on another 2k3 64bit machine ! which makes me think the original problem could be related to something different ?

Did that other machine initially have an older version of the Agent installed? I was only having troubles with the initial install/configuration, and newer agent versions operated correctly when upgraded.
ATimson
 
Posts: 11
Joined: Thu May 01, 2014 3:48 am

Postby skycaptain » Wed May 28, 2014 5:41 pm

Yes ! before installing 2.4.10.68 there was another version of the agent installed. I'm a bit confused now!
SkyCaptain
skycaptain
 
Posts: 15
Joined: Sun May 11, 2014 10:29 am
Location: London

Postby Mike Upton » Thu May 29, 2014 8:30 am

We introduced a bug in version 2.4.4.5 of the Deployment Agent that meant it was no longer capable of creating its own security certificate (the thumbprint used for server/agent communication) on Windows Server 2003. Because certificate creation only needs to happen once, only new installations were affected; upgrades from previous versions would have carried on working.

We fixed this bug in version 2.4.12.1, so fresh installations will now work correctly.
Mike Upton

Project Manager - SQL Compare|Data Compare|Comparison SDK
Redgate Software Ltd.
Mike Upton
 
Posts: 190
Joined: Wed May 11, 2011 8:04 am
Location: Redgate

Re:

Postby agr@ida.dk » Tue Jul 01, 2014 6:59 pm

Mike Upton wrote:We introduced a bug in version 2.4.4.5 of the Deployment Agent that meant it was no longer capable of creating its own security certificate (the thumbprint used for server/agent communication) on Windows Server 2003. Because certificate creation only needs to happen once, only new installations were affected; upgrades from previous versions would have carried on working.

We fixed this bug in version 2.4.12.1, so fresh installations will now work correctly.


I'm sorry to say that it doesn't seem to be resolved. I'm having the same problem on a 2003 x86. And I'm using version 2.4.12.1 also tried a few earlier versions.

Any tips on how to get it working? I have two 2003 x86 I need to deploy something on using Deployment Manager
agr@ida.dk
 
Posts: 7
Joined: Tue Jul 01, 2014 6:53 pm

Postby Mike Upton » Thu Jul 03, 2014 7:55 am

If it's still happening in 2.4.12.1 then it must be a slightly different problem. Could you find any relevant messages from the Windows event log and post them here?
Mike Upton

Project Manager - SQL Compare|Data Compare|Comparison SDK
Redgate Software Ltd.
Mike Upton
 
Posts: 190
Joined: Wed May 11, 2011 8:04 am
Location: Redgate

Postby agr@ida.dk » Thu Jul 03, 2014 9:46 am

I've cloned the computer and tried setting security to wide open on the Machinekeys directory and cleaning it out and it didn't change a thing. Also tried to install the agent as system using psexec, didn't solve it either.

Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 1026
Date: 03-07-2014
Time: 10:16:39
User: N/A

Description:
Application: RedGate.Deploy.Agent.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Security.Cryptography.CryptographicException
Stack:
at RedGate.Deploy.Shared.Startup.WindowsServiceHost.RunService()
at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Warning
Event Source: Red Gate Deployment Agent
Event Category: None
Event ID: 0
Date: 03-07-2014
Time: 10:15:52
User: N/A

Description:
2014-07-03 10:15:40,921 [5] WARN RedGate.Deploy.Startup [(null)] - Tried to load C:\\Program Files\\Red Gate\\Deployment Agent\\Agent\\Plugins\\RedGate.Deploy.SqlServerDbPackage.AgentPlugin\\SQLite.Interop.dll as potential plugin, but failed.
System.BadImageFormatException: Could not load file or assembly 'file:///C:\\Program Files\\Red Gate\\Deployment Agent\\Agent\\Plugins\\RedGate.Deploy.SqlServerDbPackage.AgentPlugin\\SQLite.Interop.dll' or one of its dependencies. The module was expected to contain an assembly manifest.
File name: 'file:///C:\\Program Files\\Red Gate\\Deployment Agent\\Agent\\Plugins\\RedGate.Deploy.SqlServerDbPackage.AgentPlugin\\SQLite.Interop.dll'
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile)
at RedGate.Deploy.Agent.Plugins.PluginsModule.GetPotentialPluginAssemblies()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\\Software\\Microsoft\\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\\Software\\Microsoft\\Fusion!EnableLog].



For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
agr@ida.dk
 
Posts: 7
Joined: Tue Jul 01, 2014 6:53 pm

Postby agr@ida.dk » Thu Jul 03, 2014 11:53 am

I've tried repairing .Net 4 - no change
Using the local administrator account - no change

When I start Agent Tools, I get the following error:

Could not start Deployment Manager tools: An exception was thrown while invoking the constructore 'Void .ctor(RedGate.Deploy.Shared.IMutableAgentConfiguration)' on type 'Security TabViewModel'
agr@ida.dk
 
Posts: 7
Joined: Tue Jul 01, 2014 6:53 pm

Postby Mike Upton » Thu Jul 03, 2014 1:17 pm

The message about not being able to load SQLite.Interop.dll as a potential plugin is normal, and nothing to worry about. The problem is being caused by the CryptographicException, but we need more information about the underlying stack trace.

Could you run the following from an administrative command prompt, and post the output here?
Code: Select all
"C:\\Program Files (x86)\\Red Gate\\Deployment Agent\\Agent\\RedGate.Deploy.Agent.exe" agent --console


Thanks
Mike Upton

Project Manager - SQL Compare|Data Compare|Comparison SDK
Redgate Software Ltd.
Mike Upton
 
Posts: 190
Joined: Wed May 11, 2011 8:04 am
Location: Redgate

PreviousNext

Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests