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));; } }