Mongo DB Troubleshooting

Useful commands to troubleshoot why Mongo DB is in an error state Mongo Change Log https://www.mongodb.com/docs/manual/release-notes/5.0/ Check for disk space 1df -h Check the version 1mongod -version Check the status …

MS SQL Server Database Logging

In order to enable MSSQL Server database logging into the MSSQL Log 1). Open an elevated Poershell prompt 2). Run the query 1Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’AuditLevel’, REG_DWORD, …

Rapid7 Setup

1). Created Policy 12345678910111213141516{     "Version": "2012-10-17",     "Statement": [         {             "Effect": "Allow",           …

Get AD User Information

1PS C:\>get-aduser tor -Properties * Can also list all the servers on the domain 1PS C:\>Get-adcomputer -filter * -properties * | Select-object DNSHostName,whenCreated,Name,Created,Modified,LastLogonDate,Enabled,isDeleted | export-csv c:\servers.csv

Delete Wazuh Agent

Access the Wazuh API Console Run the command, replacing the agent id 1DELETE /agents?pretty=true&older_than=0s&agents_list=473&status=all Output results should indicate number of agents deleted 123456789101112{ "data": { "affected_items": [ "473" ], "total_affected_items": …

Open SSH Errors

Problem: Permission Denied 1234[edc@ftp .ssh]$ sftp [email protected] Permission denied (publickey,keyboard-interactive). Couldn’t read packet: Connection reset by peer [edc@ftp .ssh]$ If the users authorized_keys file has an incorrect permission then the …

Turn On MSSQL Database Logging

Open elevated Powershell Invoke-Sqlcmd -Query “EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’AuditLevel’, REG_DWORD, 3;” -ServerInstance “localhost”; netstop MSSQLSERVER; netstart MSSQLSERVER; netstart MSSQLLaunchpad; netstart SQLSERVERAGENT

Domain Management

Active Directory Administrative Center To manage ad.aimsparking.com login to a Windows domain joined workstation as a Domain Administrator. Then launch the ADAC Tool (https://learn.microsoft.com/en-us/windows-server/identity/ad-ds/get-started/adac/active-directory-administrative-center). User Management 1). Add a User …