PowerShell Desired State Configuration le faele: karolo ea 1. Ho lokisa DSC Pull Server hore e sebetse le database ea SQL

PowerShell Desired State Configuration (DSC) e nolofatsa haholo mosebetsi oa ho tsamaisa le ho hlophisa sistimi ea ts'ebetso, likarolo tsa seva, le lits'ebetso ha o na le li-server tse makholo.

Empa ha u sebelisa DSC sebakeng sa marang-rang, ke hore. eseng ho MS Azure, ho na le lintlha tse 'maloa. Li bonahala haholo haeba mokhatlo o le moholo (ho tloha litsing tsa mosebetsi le li-server tse 300) mme ha o so fumane lefatše la lijana:

• Ha ho na litlaleho tse felletseng mabapi le boemo ba litsamaiso. Haeba tlhophiso e hlokahalang ha e so sebelisoe ho li-server tse ling, ntle le litlaleho tsena re ke ke ra tseba ka eona. Ho thata haholo ho fumana tlhaiso-leseling ho tsoa ho seva sa tlaleho e hahelletsoeng, 'me bakeng sa palo e kholo ea baamoheli le eona e ka nka nako e telele.
• Ha e na scalability le mamello ea liphoso. Ho ke ke ha khoneha ho aha polasi ea DSC hula li-server tse tla ba le database e le 'ngoe e mamellang liphoso le polokelo e tloaelehileng ea lifaele tsa mof bakeng sa litlhophiso, li-module le linotlolo tsa ngoliso.

Kajeno ke tla u bolella kamoo u ka rarollang bothata ba pele le ho fumana lintlha tsa ho tlaleha. Ntho e 'ngoe le e' ngoe e ne e tla ba bonolo haholoanyane haeba SQL e ka sebelisoa e le database. MOF ditshepiso tšehetso e hahelletsoeng feela ho Windows Server 2019 kapa ka har'a seva sa Windows 1803. Lata data ka ho sebelisa mofani oa OleDB hape. e ke ke ea sebetsahobane Seva ea DSC e sebelisa paramethara e boletsoeng e sa tšehetsoeng ka botlalo ke OleDbCommand.

Ke fumane mokhoa ona: bakeng sa ba sebelisang Windows Server 2012 le 2016, u ka khona beha ho sebelisa database ea SQL joalo ka mokokotlo bakeng sa seva sa lipotso tsa DSC. Ho etsa sena, re tla theha "moemeli" ka mokhoa oa faele ea .mdb e nang le litafole tse amanang, e tla tsamaisa data e amohetsoeng ho tsoa litlalehong tsa bareki ho database ea seva sa SQL.

Tlhokomeliso: Bakeng sa Windows Server 2016 u tlameha ho e sebelisa AccessDatabaseEngine2016x86hobane Microsoft.Jet.OLEDB.4.0 ha e sa tšehetsoa.

Ha ke na ho bua ka botlalo mabapi le ts'ebetso ea ho tsamaisa seva sa DSC, e hlalositsoe hantle haholo mona. Ke tla hlokomela lintlha tse 'maloa feela. Haeba re kenya mochine oa DSC ho seva se le seng sa marang-rang se nang le WSUS kapa Kaspersky Security Center, joale ho script ea pōpo ea tlhophiso re hloka ho fetola liparamente tse latelang:

1. UseSecurityBestPractices     = $false

   Ho seng joalo, TLS 1.0 e tla koalloa 'me u ke ke ua khona ho hokela database ea SQL. Kaspersky Security Center le eona e ke ke ea sebetsa (bothata bo lokela ho rarolloa Kaspersky Security Center v11).

2. Enable32BitAppOnWin64   = $true

   Haeba u sa etse phetoho ena, u ke ke ua khona ho tsamaisa seva ea AppPool DSC ho IIS ka WSUS.

3. Ha o kenya DSC Server ka WSUS, tima caching e tsitsitseng le e matla bakeng sa sebaka sa DSC.

Ha re tsoeleng pele ho theha seva sa DSC ho sebelisa database ea SQL.

Ho theha database ea SQL

1. Ha re theheng database ea SQL e se nang letho e bitsoang DSC.

   
   
   

2. Ha re theheng ak'haonte ho hokela polokelong ena. Ntlha ea pele, hlahloba hore na seva sa SQL se lumella ho netefatsa li-account tsa Windows le SQL.

   
   
   

3. Eya karolong ya User Mapping. Khetha database, tabeng ena DSC. Re fana ka litokelo tsa mong'a database.

   

4. E entsoe.

   

Ho theha Schema bakeng sa Database ea DSC

Ho na le mekhoa e 'meli ea ho theha schema bakeng sa database ea DSC:

• ka boikemelo, ka sengoloa sa TSQL

  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Devices](
  [TargetName] [nvarchar](255) NOT NULL,
  [ConfigurationID] [nvarchar](255) NOT NULL,
  [ServerCheckSum] [nvarchar](255) NOT NULL,
  [TargetCheckSum] [nvarchar](255) NOT NULL,
  [NodeCompliant] [bit] NOT NULL,
  [LastComplianceTime] [datetime] NULL,
  [LastHeartbeatTime] [datetime] NULL,
  [Dirty] [bit] NOT NULL,
  [StatusCode] [int] NULL
  ) ON [PRIMARY]
  GO
   
  CREATE TABLE [dbo].[RegistrationData](
  [AgentId] [nvarchar](255) NOT NULL,
  [LCMVersion] [nvarchar](255) NULL,
  [NodeName] [nvarchar](255) NULL,
  [IPAddress] [nvarchar](255) NULL,
  [ConfigurationNames] [nvarchar](max) NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  GO
   
  CREATE TABLE [dbo].[StatusReport](
  [JobId] [nvarchar](50) NOT NULL,
  [Id] [nvarchar](50) NOT NULL,
  [OperationType] [nvarchar](255) NULL,
  [RefreshMode] [nvarchar](255) NULL,
  [Status] [nvarchar](255) NULL,
  [LCMVersion] [nvarchar](50) NULL,
  [ReportFormatVersion] [nvarchar](255) NULL,
  [ConfigurationVersion] [nvarchar](255) NULL,
  [NodeName] [nvarchar](255) NULL,
  [IPAddress] [nvarchar](255) NULL,
  [StartTime] [datetime] NULL,
  [EndTime] [datetime] NULL,
  [Errors] [nvarchar](max) NULL,
  [StatusData] [nvarchar](max) NULL,
  [RebootRequested] [nvarchar](255) NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  GO

• tlisa data ho tswa ho lisebelisoa tse se nang letho.mdb e le karolo ea mojule oa PS PSDesiredStateConfiguration ka SQL Data Import Wizard.

  The Devices.mdb eo re tla be re sebetsa le eona e fumaneha ho C:WindowsSysWOW64WindowsPowerShellv1.0ModulesPSDesiredStateConfigurationPullServer.

1. Ho kenya data, tsamaisa SQL Server Import and Export Wizard.

   

2. Re khetha hore na re tla fumana data hokae - molemong oa rona ke database ea Microsoft Access. Tobetsa E latelang.

   

3. Khetha faele eo re kenyang setšoantšo ho eona.

   

4. Re bontša moo re ka kenyang teng - bakeng sa rona ke database ea SQL.

   

5. Khetha seva sa SQL (Lebitso la seva) le database eo re tla kenya data ho eona (DataBase).

   

6. Khetha khetho Kopitsa data ho tsoa ho tafole e le 'ngoe kapa ho feta kapa maikutlo (ho kopitsa data ho tsoa litafoleng kapa ponong).

   

7. Re khetha litafole tseo re tla kenya schema ea database ho tsona.

   

8. Sheba lebokose la Matha hang-hang ebe o tobetsa Finish.

   

9. E entsoe.

   

10. Ka lebaka leo, litafole li lokela ho hlaha polokelong ea polokelo ea DSC.

    

Ho theha faele ea "proxy" ea .mdb

Ho theha khokahano ea ODBC ho seva sa SQL. Ho nahanoa hore MS Access ha ea kengoa ho seva e tsamaisang DSC, kahoo ho seta databases.mdb ho etsoa ho moamoheli ea mahareng ea kentsoeng MS Access.

Ha re theheng khokahano ea ODBC ho seva sa SQL (bonyane ba khokahano bo tlameha ho ts'oana le bonyenyane ba MS Access - 64 kapa 32). E ka etsoa ho sebelisoa:
- Powershell cmdlet:

Add-OdbcDsn –Name DSC –DriverName 'SQL Server' –Platform '<64-bit or 32-bit>' –DsnType System –SetPropertyValue @('Description=DSC Pull Server',"Server=<Name of your SQL Server>",'Trusted_Connection=yes','Database=DSC') –PassThru

- kapa ka letsoho, o sebelisa wizate ea khokahano:

1. Bula lisebelisoa tsa Tsamaiso. Re khetha mehloli ea data ea ODBC ho latela mofuta oa MS Access e kentsoeng. Eya ho "System DSN tab" 'me u thehe khokahano ea sistimi (Eketsa).

   

2. Re bontša hore re tla hokahanya le seva sa SQL. Tobetsa Qetella.

   

3. Hlalosa lebitso le seva ho hokela ho tsona. Ebe ho tla hlokahala hore ho thehoe khokahano e nang le li-parameter tse tšoanang ho seva sa DSC.

   

4. Re bontša hore ho hokahanya le seva sa SQL, re sebelisa mokhoa oa ho kena o entsoeng pele o nang le lebitso la DSC.

   

5. Re hlakisa database ho litlhophiso tsa khokahano ea DSC.

   

6. Tobetsa Qetella.

   

7. Pele re qeta ho seta, re hlahloba hore na khokahanyo e sebetsa (Test Data Source).

   

8. E entsoe.

   

Ho etsa database ea device.mdb ho MS Access. Qala MS Access 'me u thehe polokelo ea boitsebiso e se nang letho e bitsoang devices.mdb.

1. E-ea ho "External Data tab" 'me u tobetse ho ODBC Database. Fesetereng e hlahang, khetha Etsa tafole e hokahaneng ho hokela mohloling oa data.

   

2. Fesetereng e ncha, khetha karolo ea Mohloli oa Boitsebiso ba Mochini ebe o tobetsa OK. Ka fensetere e ncha, kenya lintlha tsa boitsebiso ho hokahanya le seva sa SQL.

   

3. Khetha litafole tse lokelang ho hokahanngoa. Sheba lebokose la "Save password" ebe o tobetsa OK. Boloka phasewete nako le nako bakeng sa litafole tse tharo.

   

4. Ho li-index, o hloka ho khetha tse latelang:
   - TargetName bakeng sa tafole ea dbo_Devices;

   
   
   - NodeName kapa IPAddress bakeng sa dbo_RegistrationData;

   
   
   - NodeName kapa IPAddress bakeng sa dbo_StatusReport.

   

5. Ha re fetole litafole ho MS Access, e leng: tlosa dbo_ prefix e le hore DSC e ka li sebelisa.

   

6. E entsoe.

   

7. Boloka faele ebe u koala MS Access. Hona joale re kopitsa lisebelisoa tse hlahisoang.mdb ho seva sa DSC (ka ho feletseng ho C: Program FilesWindowsPowershellDCSService) le ho nkela e teng sebaka ka eona (haeba e le teng).

Ho lokisa seva sa DSC hore se sebedise SQL

1. Re khutlela ho seva sa DSC. Ho hokela ho seva sa SQL ka faele ea rona ea moemeli, ha re theheng khokahano e ncha ea ODBC ho seva sa DSC. Lebitso, botebo hanyane, le litlhophiso tsa khokahano li tlameha ho tšoana le ha u theha faele ea MDB. U ka kopitsa lisebelisoa tse se nang letho tse seng li hlophisitsoe.mdb ho tloha mona.
2. Ho sebelisa lisebelisoa.mdb, o hloka ho etsa liphetoho ho web.config ea DSC pull server (default ke C:inetpubPSDSCPullServerweb.config):

- bakeng sa Windows Server 2012

<add key="dbprovider" value="System.Data.OleDb">
<add key="dbconnectionstr" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Program FilesWindowsPowerShellDscServiceDevices.mdb;">

- bakeng sa Windows Server 2016

<add key="dbprovider" value="System.Data.OleDb">
<add key="dbconnectionstr" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Program FilesWindowsPowerShellDscServiceDevices.mdb;">

Sena se phethela ho seta seva sa DSC.

Ho hlahloba tshebetso ya seva sa DSC

1. Ha re hlahlobeng hore na seva ea DSC ea fumaneha ka sebatli sa Marang-rang.

   

2. Joale a re hlahlobeng hore na DSC hula seva e sebetsa ka nepo. Ho etsa sena, mochine oa xPSDesiredStateConfiguration o kenyelletsa script ea pullserversetuptests.ps1. Pele o sebelisa mongolo ona, o tlameha ho kenya module ea Powershell e bitsoang Pester. E kenye Kenya-Module -Name Pester.
3. Bula C: Program FilesWindowsPowerShellModulesxPSDesiredStateConfiguration<module version>DSCPullServerSetupPullServerDeploymentVerificationTest (mohlala wa 8.0.0.0.0).

   

4. Bula PullServerSetupTests.ps1 'me u hlahlobe tsela e eang ho web.config ea seva sa DSC. Tsela ea ho web.config, e tla hlahloba script, e totobalitsoe ka bofubelu. Haeba ho hlokahala, re fetola mokhoa ona.

   

5. Matha pullserversetuptests.ps1
   Invoke-Pester.PullServerSetupTests.ps1
   Все работает.

   

6. Ho SQL Management Studio re bona hore mabotho a laoloang a romella litlaleho ho seva sa tlaleho ea DSC mme data e qetella e le polokelong ea polokelo ea DSC ho seva sa SQL.

   

Ke phetho. Lihloohong tse latelang ke rera ho u bolella mokhoa oa ho haha ​​​​litlaleho ho data e fumanoeng, 'me ke tla ama litaba tse mabapi le mamello ea liphoso le scalability.

Source: www.habr.com