Sorean's Virtual Home

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@email.com’, ‘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...