Sorean's Virtual Home

AWS Data Lifecycle Manager vs AWS Backup

by on Jan.04, 2020, under Amazon Web Services

My scenario was that I only wanted a backup of my EC2 every 6 months. It hosts this blog and a couple others, but I don’t really need anything beyond that.

Specifically when looking AWS Backup options for EC2(EBS volumes), the Data Lifecycle Manager allows for basic policies and limited options whereas you can specify custom parameters via a Cron task (https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/ScheduledEvents.html) for AWS Backup.

After configuration this is the definition and schedule in my AWS Backup plan:

Custom cron expression: cron(0 5 6 1,7 ? *)
At 05:00 AM UTC, on day 6 of the month, only in January and July

Pricing

DLM uses standard EBS pricing as it creates EBS snapshots (https://aws.amazon.com/ebs/pricing/)
AWS Backup pricing is the same but allows for more services (https://aws.amazon.com/backup/pricing/)

There is no cost difference in my scenario.

Leave a Comment more...

Windows Auto Login Registry

by on Dec.09, 2019, under Tech Stuff

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon

  • DefaultUserName – Reg_SZ
  • DefaultPassword – Reg_SZ
  • DefaultDomain – Reg_SZ
  • AuotAdminLogon  = 1

Reboot to verify.

Leave a Comment more...

Find Password Policy

by on Sep.16, 2019, under Tech Stuff

net accounts (Local password policy)

net accounts /domain (Domain enforced password policy)

Leave a Comment more...

Injecting a user into a WordPress mySQL database directly.

by on Aug.29, 2019, under Wordpress

If you can read this then you can figure it out, be sure to match the wp_ prefix to match your database on all fields. Default installs will use wp_ but if you customize it then you’ll need to change it.

This is all assuming you have mySQL access to the database. This adds the user as a full administrator into the site (user_level = 10).

INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (‘2’, ‘loginname’, MD5(‘yourpasswordhere’), ‘Username’, ’[email protected]’, ‘http://www.website.com’, ‘2011-06-07 00:00:00’, ”, ‘0’, ‘Displayname’);

INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘2’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);

INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘2’, ‘wp_user_level’, ’10’);

Leave a Comment more...

Source: MSSQL$MICROSOFT##WID Event ID: 28005

by on Aug.07, 2019, under Database Related

Source: MSSQL$MICROSOFT##WID
Event ID: 28005

An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.

Download SQL Management Studio, run as admin, connect to \\.\pipe\microsoft##wid\tsql\query

Run: sp_helpdb
Windows Internal Database shows unknown owner for AdfsArtifcatStore and AdfsConfiguration.

Change the DB owner to a service account or a local account depending on your usage. In my case it was a service account ‘domain\serviceaccount’.

Leave a Comment more...

SceCli missing account fix

by on May.28, 2019, under Tech Stuff

dcgpofix /ignoreschema and press yes at both prompts.

Resolves missing account names.

Leave a Comment more...

Outlook 2016 not remembering Always use setting

by on Mar.20, 2019, under Tech Stuff

This is a registry fix that will disable the prompt system wide when there is a new application installed. Not exactly a fix for the problem itself, but a blanket cover.

REG ADD HKLM\SOFTWARE\Policies\Microsoft\Windows\Explorer /v NoNewAppAlert /t REG_DWORD /d 1

Leave a Comment more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Blogroll

A few highly recommended websites...