public void ApproveRequest(
NodeId requestId,
bool isRejected
)
{
Guid id = GetNodeIdGuid(requestId);
using (gdsdbEntities entities = new gdsdbEntities())
{
var request = (from x in entities.CertificateRequests where x.RequestId == id select x).SingleOrDefault();
if (request == null)
{
throw new ServiceResultException(StatusCodes.BadNodeIdUnknown);
}
if (isRejected)
{
request.State = (int)CertificateRequestState.Rejected;
// erase information which is ot required anymore
request.CertificateSigningRequest = null;
request.PrivateKeyPassword = null;
}
else
{
request.State = (int)CertificateRequestState.Approved;
}
entities.SaveChanges();
}
}
public override bool SetApplicationCertificate(
NodeId applicationId,
byte[] certificate,
bool isHttpsCertificate
)
{
Guid id = GetNodeIdGuid(applicationId);
using (gdsdbEntities entities = new gdsdbEntities())
{
var results = from x in entities.Applications
where x.ApplicationId == id
select x;
var result = results.SingleOrDefault();
if (result == null)
{
return(false);
}
if (isHttpsCertificate)
{
result.HttpsCertificate = certificate;
}
else
{
result.Certificate = certificate;
}
entities.SaveChanges();
}
return(true);
}
public NodeId StartNewKeyPairRequest(
NodeId applicationId,
string certificateGroupId,
string certificateTypeId,
string subjectName,
string[] domainNames,
string privateKeyFormat,
string privateKeyPassword,
string authorityId)
{
Guid id = GetNodeIdGuid(applicationId);
using (gdsdbEntities entities = new gdsdbEntities())
{
var application = (from x in entities.Applications where x.ApplicationId == id select x).SingleOrDefault();
if (application == null)
{
throw new ServiceResultException(StatusCodes.BadNodeIdUnknown);
}
var request = (from x in application.CertificateRequests where x.AuthorityId == authorityId select x).SingleOrDefault();
bool isNew = false;
if (request == null)
{
request = new CertificateRequest()
{
RequestId = Guid.NewGuid(), AuthorityId = authorityId
};
isNew = true;
}
request.State = (int)CertificateRequestState.New;
request.CertificateGroupId = certificateGroupId;
request.CertificateTypeId = certificateTypeId;
request.SubjectName = subjectName;
request.DomainNames = JsonConvert.SerializeObject(domainNames);
request.PrivateKeyFormat = privateKeyFormat;
request.PrivateKeyPassword = privateKeyPassword;
request.CertificateSigningRequest = null;
if (isNew)
{
application.CertificateRequests.Add(request);
}
entities.SaveChanges();
return(new NodeId(request.RequestId, NamespaceIndex));
}
}
public CertificateRequestState FinishRequest(
NodeId applicationId,
NodeId requestId,
out string certificateGroupId,
out string certificateTypeId,
out byte[] signedCertificate,
out byte[] privateKey)
{
certificateGroupId = null;
certificateTypeId = null;
signedCertificate = null;
privateKey = null;
Guid reqId = GetNodeIdGuid(requestId);
Guid appId = GetNodeIdGuid(applicationId);
using (gdsdbEntities entities = new gdsdbEntities())
{
var request = (from x in entities.CertificateRequests where x.RequestId == reqId select x).SingleOrDefault();
if (request == null)
{
throw new ServiceResultException(StatusCodes.BadInvalidArgument);
}
switch (request.State)
{
case (int)CertificateRequestState.New:
return(CertificateRequestState.New);
case (int)CertificateRequestState.Rejected:
return(CertificateRequestState.Rejected);
case (int)CertificateRequestState.Accepted:
return(CertificateRequestState.Accepted);
case (int)CertificateRequestState.Approved:
break;
default:
throw new ServiceResultException(StatusCodes.BadInvalidArgument);
}
certificateGroupId = request.CertificateGroupId;
certificateTypeId = request.CertificateTypeId;
entities.SaveChanges();
return(CertificateRequestState.Approved);
}
}
public override bool SetApplicationTrustLists(
NodeId applicationId,
NodeId trustListId,
NodeId httpsTrustListId
)
{
Guid id = GetNodeIdGuid(applicationId);
using (gdsdbEntities entities = new gdsdbEntities())
{
var result = (from x in entities.Applications where x.ApplicationId == id select x).SingleOrDefault();
if (result == null)
{
return(false);
}
result.TrustListId = null;
result.HttpsTrustListId = null;
if (trustListId != null)
{
string storePath = trustListId.ToString();
var result2 = (from x in entities.CertificateStores where x.Path == storePath select x).SingleOrDefault();
if (result2 != null)
{
result.TrustListId = result2.ID;
}
}
if (httpsTrustListId != null)
{
string storePath = httpsTrustListId.ToString();
var result2 = (from x in entities.CertificateStores where x.Path == storePath select x).SingleOrDefault();
if (result2 != null)
{
result.HttpsTrustListId = result2.ID;
}
}
entities.SaveChanges();
}
return(true);
}
public override void Initialize()
{
using (gdsdbEntities entities = new gdsdbEntities())
{
Assembly assembly = typeof(SqlApplicationsDatabase).GetTypeInfo().Assembly;
StreamReader istrm = new StreamReader(assembly.GetManifestResourceStream("Opc.Ua.Gds.Server.DB.gdsdb.edmx.sql"));
string tables = istrm.ReadToEnd();
entities.Database.Initialize(true);
entities.Database.CreateIfNotExists();
var parts = tables.Split(new string[] { "GO" }, System.StringSplitOptions.None);
foreach (var part in parts)
{
entities.Database.ExecuteSqlCommand(part);
}
entities.SaveChanges();
}
}
public override bool SetApplicationCertificate(
NodeId applicationId,
string certificateTypeId,
byte[] certificate)
{
Guid id = GetNodeIdGuid(applicationId);
if (certificateTypeId.Equals(nameof(Ua.ObjectTypeIds.UserCredentialCertificateType), StringComparison.OrdinalIgnoreCase))
{
return(false);
}
using (gdsdbEntities entities = new gdsdbEntities())
{
var results = from x in entities.Applications
where x.ApplicationId == id
select x;
var result = results.SingleOrDefault();
if (result == null)
{
return(false);
}
if (certificateTypeId.Equals(nameof(Ua.ObjectTypeIds.HttpsCertificateType), StringComparison.OrdinalIgnoreCase))
{
result.HttpsCertificate = certificate;
}
else
{
result.Certificate = certificate;
}
entities.SaveChanges();
}
return(true);
}
public override void UnregisterApplication(NodeId applicationId)
{
Guid id = GetNodeIdGuid(applicationId);
List <byte[]> certificates = new List <byte[]>();
using (gdsdbEntities entities = new gdsdbEntities())
{
var result = (from ii in entities.Applications
where ii.ApplicationId == id
select ii).SingleOrDefault();
if (result == null)
{
throw new ArgumentException("A record with the specified application id does not exist.", nameof(applicationId));
}
foreach (var entry in new List <CertificateRequest>(result.CertificateRequests))
{
entities.CertificateRequests.Remove(entry);
}
foreach (var entry in new List <ApplicationName>(result.ApplicationNames))
{
entities.ApplicationNames.Remove(entry);
}
foreach (var entry in new List <ServerEndpoint>(result.ServerEndpoints))
{
entities.ServerEndpoints.Remove(entry);
}
entities.Applications.Remove(result);
entities.SaveChanges();
m_lastCounterResetTime = DateTime.UtcNow;
}
}
public CertificateRequestState ReadRequest(
NodeId applicationId,
NodeId requestId,
out string certificateGroupId,
out string certificateTypeId,
out byte[] certificateRequest,
out string subjectName,
out string[] domainNames,
out string privateKeyFormat,
out string privateKeyPassword)
{
certificateGroupId = null;
certificateTypeId = null;
certificateRequest = null;
subjectName = null;
domainNames = null;
privateKeyFormat = null;
privateKeyPassword = null;
Guid reqId = GetNodeIdGuid(requestId);
Guid appId = GetNodeIdGuid(applicationId);
using (gdsdbEntities entities = new gdsdbEntities())
{
var request = (from x in entities.CertificateRequests where x.RequestId == reqId select x).SingleOrDefault();
if (request == null)
{
throw new ServiceResultException(StatusCodes.BadInvalidArgument);
}
switch (request.State)
{
case (int)CertificateRequestState.New:
return(CertificateRequestState.New);
case (int)CertificateRequestState.Rejected:
return(CertificateRequestState.Rejected);
case (int)CertificateRequestState.Accepted:
return(CertificateRequestState.Accepted);
case (int)CertificateRequestState.Approved:
break;
default:
throw new ServiceResultException(StatusCodes.BadInvalidArgument);
}
certificateGroupId = request.CertificateGroupId;
certificateTypeId = request.CertificateTypeId;
certificateRequest = request.CertificateSigningRequest;
subjectName = request.SubjectName;
domainNames = request.DomainNames != null?JsonConvert.DeserializeObject <string[]>(request.DomainNames) : null;
privateKeyFormat = request.PrivateKeyFormat;
privateKeyPassword = request.PrivateKeyPassword;
entities.SaveChanges();
return(CertificateRequestState.Approved);
}
}
public override NodeId RegisterApplication(
ApplicationRecordDataType application
)
{
NodeId appNodeId = base.RegisterApplication(application);
if (NodeId.IsNull(appNodeId))
{
appNodeId = new NodeId(Guid.NewGuid(), NamespaceIndex);
}
Guid applicationId = GetNodeIdGuid(appNodeId);
string capabilities = base.ServerCapabilities(application);
using (gdsdbEntities entities = new gdsdbEntities())
{
Application record = null;
if (applicationId != Guid.Empty)
{
var results = from ii in entities.Applications
where ii.ApplicationId == applicationId
select ii;
record = results.SingleOrDefault();
if (record != null)
{
var endpoints = from ii in entities.ServerEndpoints
where ii.ApplicationId == record.ID
select ii;
foreach (var endpoint in endpoints)
{
entities.ServerEndpoints.Remove(endpoint);
}
var names = from ii in entities.ApplicationNames
where ii.ApplicationId == record.ID
select ii;
foreach (var name in names)
{
entities.ApplicationNames.Remove(name);
}
entities.SaveChanges();
}
}
bool isNew = false;
if (record == null)
{
applicationId = Guid.NewGuid();
record = new Application()
{
ApplicationId = applicationId
};
isNew = true;
}
record.ApplicationUri = application.ApplicationUri;
record.ApplicationName = application.ApplicationNames[0].Text;
record.ApplicationType = (int)application.ApplicationType;
record.ProductUri = application.ProductUri;
record.ServerCapabilities = capabilities;
if (isNew)
{
entities.Applications.Add(record);
}
entities.SaveChanges();
if (application.DiscoveryUrls != null)
{
foreach (var discoveryUrl in application.DiscoveryUrls)
{
entities.ServerEndpoints.Add(new ServerEndpoint()
{
ApplicationId = record.ID, DiscoveryUrl = discoveryUrl
});
}
}
if (application.ApplicationNames != null && application.ApplicationNames.Count >= 1)
{
foreach (var applicationName in application.ApplicationNames)
{
entities.ApplicationNames.Add(new ApplicationName()
{
ApplicationId = record.ID, Locale = applicationName.Locale, Text = applicationName.Text
});
}
}
entities.SaveChanges();
m_lastCounterResetTime = DateTime.UtcNow;
return(new NodeId(applicationId, NamespaceIndex));;
}
}