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 override bool CompleteCertificateRequest( NodeId applicationId, NodeId requestId, out byte[] certificate, out byte[] privateKey) { certificate = null; privateKey = null; Guid reqId = GetNodeIdGuid(requestId); 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.BadNodeIdUnknown); } if (request.State == (int)CertificateRequestState.New) { return(false); } if (request.State == (int)CertificateRequestState.Rejected) { throw new ServiceResultException(StatusCodes.BadUserAccessDenied, "The certificate request has been rejected by the administrator."); } certificate = request.Certificate; privateKey = request.PrivateKey; if (request.State == (int)CertificateRequestState.Approved) { if (request.AuthorityId != "https") { request.Application.Certificate = certificate; } else { request.Application.HttpsCertificate = certificate; } request.State = (int)CertificateRequestState.Accepted; } entities.SaveChanges(); return(true); } }
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.Tables.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 void UnregisterApplication( NodeId applicationId, out byte[] certificate, out byte[] httpsCertificate) { certificate = null; httpsCertificate = null; 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)); } certificate = result.Certificate; httpsCertificate = result.HttpsCertificate; 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 override NodeId CreateCertificateRequest( NodeId applicationId, byte[] certificate, byte[] privateKey, 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.Certificate = certificate; request.PrivateKey = privateKey; if (isNew) { application.CertificateRequests.Add(request); } entities.SaveChanges(); return(new NodeId(request.RequestId, NamespaceIndex)); } }
public override void ApproveCertificateRequest( 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); } request.State = (int)((isRejected) ? CertificateRequestState.Rejected : CertificateRequestState.Approved); entities.SaveChanges(); } }
public override NodeId RegisterApplication( ApplicationRecordDataType application ) { NodeId appNodeId = base.RegisterApplication(application); 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));; } }