Revert “contained database authentication” after Installation XP1

We have installed sitecore XP1 on our Servers and our SQL admin whats to disable the “contained database authentication” after installation because of security issues he was reading in a article from MS.

I’ve also seen this article: Why do we require Contained database for Sitecore 9?

So here the Question

How can I revert the contained Database setting after the installation without destroying my Sitecore instance?

We have allready tried to extract the Users and create local Server Logins for them but that doesn’t seem to work for all Sitecore users.

When we try to extract the sitecore_coreuser with this SQL Script:

    USE Sitecore_Core

    ALTER USER [sitecore_coreuser] WITH  NAME = [sitecore_coreuser_ORIG]
    USE master
    CREATE LOGIN [sitecore_coreuser] WITH PASSWORD=N'sitecore_coreuser'
    USE Sitecore_Core
    CREATE USER [sitecore_coreuser] FOR LOGIN [sitecore_coreuser] WITH DEFAULT_SCHEMA=[dbo]
    ALTER ROLE [aspnet_Membership_BasicAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Membership_FullAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Membership_ReportingAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Profile_BasicAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Profile_FullAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Profile_ReportingAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Roles_BasicAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Roles_FullAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [aspnet_Roles_ReportingAccess] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [db_datareader] ADD MEMBER [sitecore_coreuser]
    ALTER ROLE [db_datawriter] ADD MEMBER [sitecore_coreuser]
    GO

Sitecore is not working anymore. Did we miss something in the usersettings?

All topic

What could cause a stroke soon after a lung transplant? Is it even known?

Recently a youtuber died of a thrombotic stroke a week after a lung transplant operation. Skimming over abstracts on Pubmed, it appears that strokes and more generally thrombosis is a frequent complication.

However, these articles, which spans a little over a couple decades, stuck to estimating the frequency of these complications and didn’t explore potential causes. The closest was one that found statistically significant risk factors like old age and cardiovascular disease (duh), but that isn’t really a detailed mechanism and didn’t seem relevant to the youtuber in question (she was 21 years old).

Is there an explanation for lung transplants causing strokes so well-known that it’s not worth mentioning in research, or is this really unknown?

All topic

Why is there no preposition after the word ‘requires’?

The constitution requires members of parliament to take an oath of allegiance

I read this sentence in dictionary list of sentence examples and I would like to know: Why is “to” not needed in here:

“The constitution requires to members of parliament to take an oath of allegiance”

or:

“The constitution requires toward members of parliament to take an oath of allegiance.”

All topic

Error after enabling Azure Search for Sitecore 9.0.1

I did the below steps.
1. Created Azure Search service and taken API
2. Added in Connection string
3. Changed search:define value=”Azure”

After that i got the below error

Could not find configuration node: contentSearch/indexConfigurations/defaultSolrIndexConfiguration/fieldMap
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Could not find configuration node: contentSearch/indexConfigurations/defaultSolrIndexConfiguration/fieldMap

All topic

CiviRules opens strange window after disabling rule

I’m experiencing strange behavior of CiviRules v1.12 (CiviCRM 4.7.14.)

If I disable a rule, an unrelated window pops-up. In this case, Fundraising call report. Why should it open a report, if I disable a rule? (screenshot added)

enter image description here

All topic

What holiday is “Miss All Sunday” named after?

In Baroque works, the strongest 14 male members (including the unluckies) are named after numbers: Mr. 13, Mr. 12, Mr. 11 … Mr. 0.

The female counterparts for Mr. 13 through Mr. 8 are named: Miss Friday, Miss Saturday, Miss Thursday, Miss Tuesday, Miss Wednesday, and Miss Monday.

From then on, they are named after holidays: Miss Fathers Day, Miss Mothers Day, Miss Valentine, Miss Merry Christmas, Miss Golden Week, Bon Kurei/Bon Clay (don’t ask), and Miss Double Finger (New Years Day).

The final female, however, is Miss All-Sunday who is Nico Robin. What is “All-Sunday” referring to? Is it a holiday? If it is just meant to be Sunday, why is the “All” there?

All topic

Can MacBook Pro get slower after SSD is almost full?

MBP 13, 2015 with 128 GB SSD and 8 GB RAM.

I have noticed, that after only some 20 GB of SSD was free my Safari browser was very slow.

RAM was used 4-6 GB from 8.

Is it general possible, that SSD can slow the MAC or it was some other reason?

All topic

Visualizing depth image after accessing render results

Based on the work of [1] I obtained the depth data of my scene as shown in the code bellow:

scene.use_nodes = True
tree = scene.node_tree
links = tree.links

# create input render layer node
rl = tree.nodes.new('CompositorNodeRLayers')    

# create output node
v = tree.nodes.new('CompositorNodeViewer')   
v.use_alpha = False

# Links
links.new(rl.outputs['Z'], v.inputs[0]) # link Z to output

bpy.ops.render.render()

# get viewer pixels
pixels = bpy.data.images['Viewer Node'].pixels
# size is always width * height * 4 (rgba)
pixels = np.array(pixels)[::4]

ix = scene.render.resolution_x
iy = scene.render.resolution_y
depth = np.zeros((ix/2,iy/2))

for i in range(0, int(round(ix/2))):
 for k in range(0, int(round(iy/2))):
     depth[i,k] = pixels[i+k]     

np.save('...\outfile.npy', depth)

I set up the nodes, forward the z-data to the output node, render and save the pixels as an array. Since I use depth data instead of RGBA, I only use every 4-th element in the array since the other 3 ones are equal. Further, I use the dimensions of the image to setup a ndarray with numpy (depth) wich I save to an .npy file finally. Somewhere in this part I make a mistake since following code (from commandline) generates a somehow weird looking plot (shown below as well)

from mpl_toolkits.mplot3d import Axes3D
import matplotlib.pyplot as plt
import numpy as np

data = np.load('...\outfile.npy')
x, y = np.mgrid[:data.shape[0], :data.shape[1]]
fig = plt.figure()
ax = fig.add_subplot(1,1,1,projection="3d")
surf=ax.plot_surface(x,y,data)
plt.show()

For a centered cube I get the following outcome:

Plot of depth data for a scene with a centered cube

So I hope somebody can give me a hint on where to look exactly for the error, and also I would be very thankfull for coding and style tips. I also found similar posts, but no one where the obtained data is visualized.

[1] https://ammous88.wordpress.com/2015/01/16/blender-access-render-results-pixels-directly-from-python-2/

All topic